P-5 Organization (ASCII)

P-5 Organization (ASCII) joins to Drilling Permit Master and Trailer — Daily File (with latitudes and longitudes) on ID = Operator number — one row here matches many rows there.

permitted by

The six-digit P-5 number on the permit is the operator directory's primary key. Exact on all 5,000 sampled permits. This is what turns an anonymous permit into a company with a status and an address.

P-5 Organization (ASCII) joins to Drilling Permit Master and Trailer — End of Month File (with latitudes and longitudes) on ID = Operator number — one row here matches many rows there.

permitted by

The permit's P-5 operator number, resolved to the organization.

P-5 Organization (ASCII) joins to Drilling Permit Master on ID = Operator number — one row here matches many rows there.

was permitted to

The P-5 organization number RRC approved on the permit, resolved to the operator directory for the company's name, address and current P-5 status. Both sides are integers here — unusually for this catalogue — so the comparison runs as printed. All 20,000 sampled permits resolve. The directory is a snapshot of today, so it gives you the operator's status now and not its status when the permit was issued.

P-5 Organization (ASCII) joins to Completion Information in Data Format on ID = Operator number — one row here matches many rows there.

completed by

The completing operator's P-5 number. 4,504 of 5,000 sampled completions resolve; the rest name organizations that predate the current directory. These two columns are different types — one is text, the other an integer — so a direct equality is rejected by Postgres. Cast the text side to integer, which also disposes of any leading zeros; casting the integer to text would not, because '000123' and 123 are not equal as text.

P-5 Organization (ASCII) joins to Drilling Permits Pending Approval (with latitudes and longitudes) on ID = Operator number — one row here matches many rows there.

was filed by

The operator on a pending application, resolved to the P-5 directory — which is how you find out whether the company doing the filing is in good standing, before the permit is granted. All 258 rows across the fifteen extracts held resolve. These two columns are different types — one is text, the other an integer — so a direct equality is rejected by Postgres. Cast the text side to integer, which also disposes of any leading zeros; casting the integer to text would not, because '000123' and 123 are not equal as text.

P-5 Organization (ASCII) joins to Gas Well Status (26 Month G-10) on ID = Operator number — one row here matches many rows there.

was filed by

The six-digit P-5 number of the company that filed the G-10, resolved to the operator directory. All 5,000 sampled tests resolve; the column is never null and never non-numeric on the current tape. These two columns are different types — one is text, the other an integer — so a direct equality is rejected by Postgres. Cast the text side to integer, which also disposes of any leading zeros; casting the integer to text would not, because '000123' and 123 are not equal as text.

P-5 Organization (ASCII) joins to Drilling Permit Master and Trailer on ID = Operator number — one row here matches many rows there.

was applied for by

The P-5 number as the OPERATOR wrote it on the W-1, resolved to the operator directory. Both sides are integers. 19,997 of 20,000 sampled applications resolve. Three fewer than the permit segment's 20,000, and the difference is the point: the root holds what was filed and the permit segment holds what RRC approved, so a P-5 number the Commission corrected survives here.

P-5 Organization (ASCII) joins to Horizontal Drilling Permits on ID = Operator number — one row here matches many rows there.

was permitted to

The permit's operator, resolved to the P-5 directory. Measured over the whole table: all 173,511 rows resolve. These two columns are different types — one is text, the other an integer — so a direct equality is rejected by Postgres. Cast the text side to integer, which also disposes of any leading zeros; casting the integer to text would not, because '000123' and 123 are not equal as text.

P-5 Organization (ASCII) joins to High Cost Gas on ID = Operator number — one row here matches many rows there.

certified for

The operator holding the certification. 4,236 of 5,000 sampled rows resolve against the current P-5 register; older certifications name organizations that have since been removed. These two columns are different types — one is text, the other an integer — so a direct equality is rejected by Postgres. Cast the text side to integer, which also disposes of any leading zeros; casting the integer to text would not, because '000123' and 123 are not equal as text.

P-5 Organization (ASCII) joins to UIC Database (ASCII) on ID = Operator — one row here matches many rows there.

permitted to

The P-5 number of the organization authorised to inject, resolved to the operator directory. These two columns are different types — one is text, the other an integer — so a direct equality is rejected by Postgres. Cast the text side to integer, which also disposes of any leading zeros; casting the integer to text would not, because '000123' and 123 are not equal as text.

P-5 Organization (ASCII) joins to ST-1 Application Report on ID = Operator P5 — one row here matches many rows there.

applied for by

The P-5 number on the ST-1 application, resolved to the organization. 2,932 of 5,000 sampled applications match the current register. Note that the ST-1 file writes its district the way RRC prints it (7C, 8A) while the production data uses the internal number, so ST-1 does NOT join to the PDQ lease directory on district — it looks like it does and the matches are wrong. These two columns are different types — one is text, the other an integer — so a direct equality is rejected by Postgres. Cast the text side to integer, which also disposes of any leading zeros; casting the integer to text would not, because '000123' and 123 are not equal as text.

P-5 Organization (ASCII) joins to PDQ Lease Production by Cycle on ID = Operator number — one row here matches many rows there.

reported by the organization

The same operator number against the authoritative P-5 register, which carries the organisation type, address and status that the production system's copy does not. These two columns are different types — one is text, the other an integer — so a direct equality is rejected by Postgres. Cast the text side to integer, which also disposes of any leading zeros; casting the integer to text would not, because '000123' and 123 are not equal as text.

P-5 Organization (ASCII) joins to RRC Oil / ICE Inspections and Violations on ID = P5 operator number — one row here matches many rows there.

cited the operator

The P-5 number of the operator cited in the violation, resolved to the operator directory. These two columns are different types — one is text, the other an integer — so a direct equality is rejected by Postgres. Cast the text side to integer, which also disposes of any leading zeros; casting the integer to text would not, because '000123' and 123 are not equal as text.

P-5 Organization (ASCII) joins to PDQ Operator Production by Cycle on ID = Operator number — one row here matches many rows there.

totals the organization

The same operator number against the authoritative P-5 register. These two columns are different types — one is text, the other an integer — so a direct equality is rejected by Postgres. Cast the text side to integer, which also disposes of any leading zeros; casting the integer to text would not, because '000123' and 123 are not equal as text.

P-5 Organization (ASCII) joins to Oil and Gas Docket Parties on Name — rows can match many rows in both directions.

is the organization named

The docket file names parties as free text and does not carry the P-5 number, so this is a name match against the operator directory. 4,079 of 5,000 sampled party names match exactly; the remainder differ by punctuation, a suffix or an abbreviation. Treat a miss as 'not matched', never as 'not an operator'.