EnerPub - Technical Sheet


1	EnerPub by Stonebridge Consulting \| Technical Sheet
2
3	Current Version:	v1.0
4
5	Overview	EnerPub offers open access to oil & gas wells and production public data pulled directly from state agencies. EnerPub makes it easy to get and ingest well and production data by eliminating the cumbersome and time-consuming process of downloading data from agencies, and reducing reliance on and costs associated with commercial public data providers.
6
7	Connecting:	Access this data directly from your Snowflake account
8		If you do not have a Snowflake account, click here to sign up
9
10	Terms of Service	https://www.sbconsulting.com/terms-of-use
11	Privacy Policy	https://www.sbconsulting.com/privacy-policy
12	Contact Us	https://www.sbconsulting.com/contact
13	Email	info@sbconsulting.com


1	EnerPub Release Notes
2
3	Release Date	Version	Notes
4	7/29/2020	v1.0	Texas Connector: Well Master, general well details (well header), historical & current production volumes from the Texas Railroad Commission (TRRC).


1	EnerPub \| Data Dictionary
2
3	DATABASE	SCHEMA	TABLE	COLUMNS	DATA TYPE	DEFINITION

4	PUBLIC_DATA	TRRC	COUNTY	COUNTY_FIPS_CODE	NUMBER(38,0)	The FIPS county code is a 5-digit Federal Information Processing Standard (FIPS) code (FIPS 6-4) which uniquely identifies counties and county equivalents in the United States, certain U.S possessions, and certain freely associated states. The first two digits are the FIPS state code and the last three are the county code within the state or possession.
5	PUBLIC_DATA	TRRC	COUNTY	COUNTY_NAME	VARCHAR(40)	Name of the county the well is located.
6	PUBLIC_DATA	TRRC	COUNTY	COUNTY_NO	NUMBER(38,0)	The county number (no.) is based on 3-digit numbers: The Railroad Commission assigns a number to each onshore county; the American Petroleum Institute (API) assigns a number to each offshore county. The first 254 number of the code are odd, and indicate onshore counties only. The remaining 23 numbers are both odd and even, and indicate offshore counties.
7	PUBLIC_DATA	TRRC	COUNTY	DISTRICT_NAME	VARCHAR(40)	The RRC district name associated to the lease reported on the production report. The current RRC Districts are 01, 02, 03, 04, 05, 06, 6E, 7B, 7C, 08, 8A, 09, & 10.
8	PUBLIC_DATA	TRRC	COUNTY	DISTRICT_NO	NUMBER(38,0)	A number representing the RRC district name in the RRC system associated to the lease reported on the production report. The 14 districts are represented by a one through fourteen numeric value. The table below indicates the converted values: RRC DISTRICT RRC DISTRICT VALUE ID VALUE ID 01 - 01 08 - 7B 02 - 02 09 - 7C 03 - 03 10 - 08 04 - 04 11 - 8A 05 - 05 13 - 09 06 - 06 14 - 10 07 - 6E (oil only) This value is not used. 12 - 8B
9	PUBLIC_DATA	TRRC	COUNTY	ON_SHORE_FLAG	VARCHAR(40)	Flag that denoted whether the location is onshore.
10	PUBLIC_DATA	TRRC	DISTRICT	DISTRICT_NAME	VARCHAR(2)	The RRC district name associated to the lease reported on the production report. The current RRC Districts are 01, 02, 03, 04, 05, 06, 6E, 7B, 7C, 08, 8A, 09, & 10.
11	PUBLIC_DATA	TRRC	DISTRICT	DISTRICT_NO	VARCHAR(2)	A number representing the RRC district name in the RRC system associated to the lease reported on the production report. The 14 districts are represented by a one through fourteen numeric value. The table below indicates the converted values: RRC DISTRICT RRC DISTRICT VALUE ID VALUE ID 01 - 01 08 - 7B 02 - 02 09 - 7C 03 - 03 10 - 08 04 - 04 11 - 8A 05 - 05 13 - 09 06 - 06 14 - 10 07 - 6E (oil only) This value is not used. 12 - 8B
12	PUBLIC_DATA	TRRC	FIELD	FIELD_CLASSIFICATION	VARCHAR(5)	A field is classified as an oil field, a gas field, or as both oil and gas. If a gas field is associated with an oil field, the oil and gas fields will usually have the same field number; they are indicated in this data item by the value "b". If a gas field is associated with an oil field, but the related oil field has a different field number, the data item "fl-assoc-oil-field number" will act as a pointer to the related oil field number. The actual process of classifying a field depends initially on the gas to oil ratio (GOR) of the first well but may also result from administrative hearings. However, as additional well discoveries provide more information about the field, the creation of a related field may become necessary. gas field value "G" oil field value "O" associated field value "B" (both oil and gas) Note: If the field is both oil and gas, and the flassoc-oil-field-number data item has a number greater than zeroes, then there exists at least one associated gas field with a field number that is different than its related oil field.
13	PUBLIC_DATA	TRRC	FIELD	FIELD_COUNTRY_NAME	VARCHAR(3)	Name of the country the field is located.
14	PUBLIC_DATA	TRRC	FIELD	FIELD_COUNTY_NAME	VARCHAR(40)	Name of the county the field is located.
15	PUBLIC_DATA	TRRC	FIELD	FIELD_COUNTY_STATE	VARCHAR(100)	Name of the county and state the field is located.
16	PUBLIC_DATA	TRRC	FIELD	FIELD_DISTRICT	VARCHAR(3)	The DISTRICT the field is located within.
17	PUBLIC_DATA	TRRC	FIELD	FIELD_MULTI_COUNTY_FLAG	VARCHAR(1)	Identifies if the field is within a single county (0) or multiple counties (1).
18	PUBLIC_DATA	TRRC	FIELD	FIELD_NAME	VARCHAR(100)	A field name is made up of: a word chosen by the operator, the stratigraphic interval name of the formation, and the formation depth at which the field is located, e.g., Johnson Frio 4700.
19	PUBLIC_DATA	TRRC	FIELD	FIELD_NUMBER	VARCHAR(8)	A number representing the field name.
20	PUBLIC_DATA	TRRC	FIELD	FIELD_STATE_ABBR	VARCHAR(2)	The state abbreviation representing the state the field is located.
21	PUBLIC_DATA	TRRC	FIELD	FIELD_STATE_NAME	VARCHAR(5)	The state the field is located.
22	PUBLIC_DATA	TRRC	FIELD	RESERVOIR_NAME	VARCHAR(100)	Name assigned to a subsurface pool of hydrocarbons contained in porous or fractured rock formations.
23	PUBLIC_DATA	TRRC	FIELD	RESERVOIR_NUMBER	VARCHAR(8)	The three digit number representing the reservoir name.
24	PUBLIC_DATA	TRRC	FIELD_DISTRICT	DISTRICT_NO	VARCHAR(2)	A number representing the RRC district name in the RRC system associated to the lease reported on the production report. The 14 districts are represented by a one through fourteen numeric value. The table below indicates the converted values: RRC DISTRICT RRC DISTRICT VALUE ID VALUE ID 01 - 01 08 - 7B 02 - 02 09 - 7C 03 - 03 10 - 08 04 - 04 11 - 8A 05 - 05 13 - 09 06 - 06 14 - 10 07 - 6E (oil only) This value is not used. 12 - 8B
25	PUBLIC_DATA	TRRC	FIELD_DISTRICT	FIELD_FORMATION_NAME	VARCHAR(32)	Name assigned to any rock or sedimentary bed sufficiently distinctive to be a unit.
26	PUBLIC_DATA	TRRC	FIELD_DISTRICT	FIELD_NAME_DISTRICT_NAME	VARCHAR(37)	The RRC district name associated to the lease reported on the production report. The current RRC Districts are 01, 02, 03, 04, 05, 06, 6E, 7B, 7C, 08, 8A, 09, & 10.
27	PUBLIC_DATA	TRRC	FIELD_DISTRICT	FIELD_NAME_DISTRICT_NO	VARCHAR(37)	Unique field identifier representing the field.
28	PUBLIC_DATA	TRRC	FIELD_DISTRICT	FIELD_NO	VARCHAR(8)	An 8-digit number assigned to a field. The first five digits of the field number are unique to each field. The last three numbers are the reservoir number. The numeric value of the first five digits is associated with the alphabet; as the alphabetic field name ascends, the value of the numbers increases. The 3-digit reservoir number doesn't have an alphabetic/numeric relationship. (Note: Wildcat field names and numbers do not have an alpha/numeric relationship of any kind).
29	PUBLIC_DATA	TRRC	FIELD_DISTRICT	FIELD_NO_DISTRICT_NO	VARCHAR(10)	Unique number representing the field (combination of FIELD_NO & DISTRICT_NO)
30	PUBLIC_DATA	TRRC	LEASE	DISTRICT_NO	VARCHAR(2)	A number representing the RRC district name in the RRC system associated to the lease reported on the production report. The 14 districts are represented by a one through fourteen numeric value. The table below indicates the converted values: RRC DISTRICT RRC DISTRICT VALUE ID VALUE ID 01 - 01 08 - 7B 02 - 02 09 - 7C 03 - 03 10 - 08 04 - 04 11 - 8A 05 - 05 13 - 09 06 - 06 14 - 10 07 - 6E (oil only) This value is not used. 12 - 8B
31	PUBLIC_DATA	TRRC	LEASE	LEASE_NAME	VARCHAR(50)	The name of the lease.
32	PUBLIC_DATA	TRRC	LEASE	LEASE_NO	VARCHAR(6)	Number representing the lease; unique within district. Note: for a unique lease number, use the field "LEASE_NO_DISTRICT_NO"
33	PUBLIC_DATA	TRRC	LEASE	LEASE_NO_DISTRICT_NO	VARCHAR(8)	Unique number representing the lease.
34	PUBLIC_DATA	TRRC	OPERATOR	FA_OPTION_CODE	VARCHAR(2)	Indicates the Financial Assurance option code. (Example: Option 1 Indicates whether or not the organization is restricted from using option 1 for Financial Assurance. Option 1 is the Individual Performance Bond or Letter of Credit based on the total aggregate well depth for all of the wells operated by the organization. Note: Option 1 is only available to those organizations that are oil or gas operators only).
35	PUBLIC_DATA	TRRC	OPERATOR	OPERATOR_NAME	VARCHAR(50)	The owner of the right to drill or produce a well, or the entity contractually charged with drilling of a test well and production of subsequent wells.
36	PUBLIC_DATA	TRRC	OPERATOR	OPERATOR_NO	VARCHAR(6)	Unique number assigned to OPERATOR.
37	PUBLIC_DATA	TRRC	OPERATOR	OPERATOR_SB639_FLAG	VARCHAR(1)	Indicates the SB639 status of the Operator.
38	PUBLIC_DATA	TRRC	OPERATOR	OPERATOR_TAX_CERT_FLAG	VARCHAR(1)	Indicates whether the tax certificate for the operator has been received from the comptroller.
39	PUBLIC_DATA	TRRC	OPERATOR	P5_LAST_FILED_DT	DATE	The date of the last P-5 filed.
40	PUBLIC_DATA	TRRC	OPERATOR	P5_STATUS_CODE	VARCHAR(4)	Indicates the status of the organization.
41	PUBLIC_DATA	TRRC	PRODUCTION_MONTHS	CYCLE_YEAR_MONTH	VARCHAR(6)	This represents the production month and year in YYYY-MM format.
42	PUBLIC_DATA	TRRC	PRODUCTION_MONTHS	MONTH_HAS_PRODUCTION_FLAG	NUMBER(1,0)	Indicates of the production volumes are available (1) or not available (2). Note the Texas Railroad Comission has a 2-3 month lag on production volumes data availability.
43	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES	COND_ENDING_BAL	NUMBER(21,0)	This numeric amount is a positive amount that represents the amount of condensate that is available for movement off leases. This is also called "stock on hand." It is computed by adding the condensate ending balance from the previous cycle to the condensate produced and subtracting the total of all of the liquid dispositions.
44	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES	COND_LIMIT	NUMBER(21,0)	This data item contains the sum of condensate limit daily amounts for all prorated wells on the lease.
45	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES	COND_PROD_VOL	NUMBER(21,0)	The amount of condensate oil in BBL produced by lease as reported by the operator on a production report.
46	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES	COND_TOT_DISP	NUMBER(21,0)	This numeric amount has a positive value and represents the number of barrels of condensate disposed.
47	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES	COUNTY_NAME	VARCHAR(100)	Name of the county the well is located.
48	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES	COUNTY_NO	VARCHAR(3)	The county number (no.) is based on 3-digit numbers: The Railroad Commission assigns a number to each onshore county; the American Petroleum Institute (API) assigns a number to each offshore county. The first 254 number of the code are odd, and indicate onshore counties only. The remaining 23 numbers are both odd and even, and indicate offshore counties.
49	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES	CSGD_GAS_LIFT	NUMBER(21,0)	Gas used, given, or sold for gas lift by lease. It does not include gas delivered to pressure maintenance or processing plants, even though the gas may be used for gas lift.
50	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES	CSGD_LIMIT	NUMBER(21,0)	This data item contains the sum of casinghead gas limit daily amounts for all prorated wells on the lease.
51	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES	CSGD_PROD_VOL	NUMBER(21,0)	The amount of casinghead gas in MCF produced by county and lease as reported by the operator on a production report. This is an estimated value.
52	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES	CSGD_TOT_DISP	NUMBER(21,0)	This data item contains the MCF of casinghead gas distributed, by county by lease. This is an estimated value.
53	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES	CYCLE_DATE	DATE	This represents the production month and year in YYYY-MM format.
54	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES	DISTRICT_NAME	VARCHAR(2)	The RRC district name associated to the lease reported on the production report. The current RRC Districts are 01, 02, 03, 04, 05, 06, 6E, 7B, 7C, 08, 8A, 09, & 10.
55	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES	DISTRICT_NO	VARCHAR(2)	A number representing the RRC district name in the RRC system associated to the lease reported on the production report. The 14 districts are represented by a one through fourteen numeric value. The table below indicates the converted values: RRC DISTRICT RRC DISTRICT VALUE ID VALUE ID 01 - 01 08 - 7B 02 - 02 09 - 7C 03 - 03 10 - 08 04 - 04 11 - 8A 05 - 05 13 - 09 06 - 06 14 - 10 07 - 6E (oil only) This value is not used. 12 - 8B
56	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES	ENTITY_ID
57	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES	FIELD_NAME	VARCHAR(32)	A field name is made up of: a word chosen by the operator, the stratigraphic interval name of the formation, and the formation depth at which the field is located, e.g., Johnson Frio 4700.
58	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES	FIELD_NO	VARCHAR(8)	An 8-digit number assigned to a field. The first five digits of the field number are unique to each field. The last three numbers are the reservoir number. The numeric value of the first five digits is associated with the alphabet; as the alphabetic field name ascends, the value of the numbers increases. The 3-digit reservoir number doesn't have an alphabetic/numeric relationship. (Note: Wildcat field names and numbers do not have an alpha/numeric relationship of any kind).
59	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES	FIELD_TYPE	VARCHAR(2)	This represents the type of field. Values are: FL-49B VALUE '49'. FL-EXEMPT VALUE 'EX'. FL-PRORATED VALUE 'PR'. FL-CYCLING VALUE 'CY'. FL-STORAGE VALUE 'ST'. FL-LIQUID-LIMIT VALUE 'LQ'. FL-CAPACITY VALUE 'CA'. FL-SALVAGE VALUE 'SV'. FL-ONE-WELL VALUE 'ON'. FL-SPECIAL VALUE 'SP'.
60	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES	GAS_ALLOW	NUMBER(21,0)	Indicates the allowable assigned to the well for the lease.
61	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES	GAS_LIFT_INJ_VOL	NUMBER(21,0)	Gas used, given, or sold for gas lift by lease. It does not include gas delivered to pressure maintenance or processing plants, even though the gas may be used for gas lift.
62	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES	GAS_PROD_VOL	NUMBER(21,0)	The amount of gas in MCF produced by lease as reported by the operator on a production report.
63	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES	GAS_TOT_DISP	NUMBER(21,0)	This numeric amount has a positive value and represents the MCF amount of gas disposed.
64	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES	GAS_WELL_NO	VARCHAR(6)	The 6-digit number that uniquely identifies a gas well.
65	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES	LEASE_NAME	VARCHAR(50)	The name of the lease.
66	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES	LEASE_NO	VARCHAR(6)	Number representing the lease; unique within district. Note: for a unique lease number, use the field "LEASE_NO_DISTRICT_NO"
67	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES	LEASE_NO_DISTRICT_NO	VARCHAR(8)	Unique number representing the lease.
68	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES	OIL_ALLOW	NUMBER(21,0)	Sum of oil well allowables by lease for the cycle.
69	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES	OIL_ENDING_BAL	NUMBER(21,0)	This numeric amount is a positive amount that represents the amount of oil that is available for movement off leases by lease. This is also called "stock on hand." It is computed by adding the oil ending balance from the previous cycle to the oil produced and subtracting the total of all of the liquid dispositions.
70	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES	OIL_PROD_VOL	NUMBER(21,0)	The amount of oil in BBL produced by lease as reported by the operator on a production report.
71	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES	OIL_TOT_DISP	NUMBER(21,0)	This numeric amount has a positive value and represents the barrels of oil disposed of for oil leases.
72	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES	OPERATOR_NAME	VARCHAR(50)	The owner of the right to drill or produce a well, or the entity contractually charged with drilling of a test well and production of subsequent wells.
73	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES	OPERATOR_NO	VARCHAR(6)	Unique number assigned to OPERATOR.
74	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_GAS_WELL	API_10	VARCHAR(100)	The API number is a unique number assigned identify wells. An API number is an 10-digit number made up of a 2-digit state code, a 3-digit county code and a 5-digit unique number.
75	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_GAS_WELL	COND_ENDING_BAL	NUMBER(21,0)	This numeric amount is a positive amount that represents the amount of condensate that is available for movement off leases. This is also called "stock on hand." It is computed by adding the condensate ending balance from the previous cycle to the condensate produced and subtracting the total of all of the liquid dispositions.
76	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_GAS_WELL	COND_LIMIT	NUMBER(21,0)	This data item contains the sum of condensate limit daily amounts for all prorated wells on the lease.
77	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_GAS_WELL	COND_PROD_VOL	NUMBER(21,0)	The amount of condensate oil in BBL produced by lease as reported by the operator on a production report.
78	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_GAS_WELL	COND_TOT_DISP	NUMBER(21,0)	This numeric amount has a positive value and represents the number of barrels of condensate disposed.
79	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_GAS_WELL	COUNTY_NAME	VARCHAR(100)	Name of the county the well is located.
80	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_GAS_WELL	COUNTY_NO	VARCHAR(3)	The county number (no.) is based on 3-digit numbers: The Railroad Commission assigns a number to each onshore county; the American Petroleum Institute (API) assigns a number to each offshore county. The first 254 number of the code are odd, and indicate onshore counties only. The remaining 23 numbers are both odd and even, and indicate offshore counties.
81	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_GAS_WELL	CSGD_GAS_LIFT	NUMBER(21,0)	Gas used, given, or sold for gas lift by lease. It does not include gas delivered to pressure maintenance or processing plants, even though the gas may be used for gas lift.
82	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_GAS_WELL	CSGD_LIMIT	NUMBER(21,0)	This data item contains the sum of casinghead gas limit daily amounts for all prorated wells on the lease.
83	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_GAS_WELL	CSGD_PROD_VOL	NUMBER(21,0)	The amount of casinghead gas in MCF produced by county and lease as reported by the operator on a production report. This is an estimated value.
84	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_GAS_WELL	CSGD_TOT_DISP	NUMBER(21,0)	This data item contains the MCF of casinghead gas distributed, by county by lease. This is an estimated value.
85	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_GAS_WELL	CYCLE_DATE	DATE	This represents the production month and year in YYYY-MM format.
86	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_GAS_WELL	DISTRICT_NAME	VARCHAR(2)	The RRC district name associated to the lease reported on the production report. The current RRC Districts are 01, 02, 03, 04, 05, 06, 6E, 7B, 7C, 08, 8A, 09, & 10.
87	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_GAS_WELL	DISTRICT_NO	VARCHAR(2)	A number representing the RRC district name in the RRC system associated to the lease reported on the production report. The 14 districts are represented by a one through fourteen numeric value. The table below indicates the converted values: RRC DISTRICT RRC DISTRICT VALUE ID VALUE ID 01 - 01 08 - 7B 02 - 02 09 - 7C 03 - 03 10 - 08 04 - 04 11 - 8A 05 - 05 13 - 09 06 - 06 14 - 10 07 - 6E (oil only) This value is not used. 12 - 8B
88	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_GAS_WELL	FIELD_NAME	VARCHAR(32)	A field name is made up of: a word chosen by the operator, the stratigraphic interval name of the formation, and the formation depth at which the field is located, e.g., Johnson Frio 4700.
89	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_GAS_WELL	FIELD_NO	VARCHAR(8)	An 8-digit number assigned to a field. The first five digits of the field number are unique to each field. The last three numbers are the reservoir number. The numeric value of the first five digits is associated with the alphabet; as the alphabetic field name ascends, the value of the numbers increases. The 3-digit reservoir number doesn't have an alphabetic/numeric relationship. (Note: Wildcat field names and numbers do not have an alpha/numeric relationship of any kind).
90	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_GAS_WELL	FIELD_TYPE	VARCHAR(2)	This represents the type of field. Values are: FL-49B VALUE '49'. FL-EXEMPT VALUE 'EX'. FL-PRORATED VALUE 'PR'. FL-CYCLING VALUE 'CY'. FL-STORAGE VALUE 'ST'. FL-LIQUID-LIMIT VALUE 'LQ'. FL-CAPACITY VALUE 'CA'. FL-SALVAGE VALUE 'SV'. FL-ONE-WELL VALUE 'ON'. FL-SPECIAL VALUE 'SP'.
91	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_GAS_WELL	GAS_ALLOW	NUMBER(21,0)	Indicates the allowable assigned to the well for the gas well.
92	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_GAS_WELL	GAS_LIFT_INJ_VOL	NUMBER(21,0)	Gas used, given, or sold for gas lift by lease. It does not include gas delivered to pressure maintenance or processing plants, even though the gas may be used for gas lift.
93	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_GAS_WELL	GAS_PROD_VOL	NUMBER(21,0)	The amount of gas in MCF produced by lease as reported by the operator on a production report.
94	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_GAS_WELL	GAS_TOT_DISP	NUMBER(21,0)	This numeric amount has a positive value and represents the MCF amount of gas disposed.
95	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_GAS_WELL	GAS_WELL_NO	VARCHAR(6)	The 6-digit number that uniquely identifies a gas well.
96	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_GAS_WELL	LEASE_NAME	VARCHAR(50)	The name of the lease.
97	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_GAS_WELL	LEASE_NO	VARCHAR(6)	Number representing the lease; unique within district. Note: for a unique lease number, use the field "LEASE_NO_DISTRICT_NO"
98	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_GAS_WELL	LEASE_NO_DISTRICT_NO	VARCHAR(8)	Unique number representing the lease.
99	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_GAS_WELL	OIL_ALLOW	NUMBER(21,0)	Sum of oil well allowables by lease for the cycle.
100	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_GAS_WELL	OIL_ENDING_BAL	NUMBER(21,0)	This numeric amount is a positive amount that represents the amount of oil that is available for movement off leases by lease. This is also called "stock on hand." It is computed by adding the oil ending balance from the previous cycle to the oil produced and subtracting the total of all of the liquid dispositions.
101	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_GAS_WELL	OIL_PROD_VOL	NUMBER(21,0)	The amount of oil in BBL produced by lease as reported by the operator on a production report.
102	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_GAS_WELL	OIL_TOT_DISP	NUMBER(21,0)	This numeric amount has a positive value and represents the barrels of oil disposed of for oil leases.
103	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_GAS_WELL	OPERATOR_NAME	VARCHAR(50)	The owner of the right to drill or produce a well, or the entity contractually charged with drilling of a test well and production of subsequent wells.
104	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_GAS_WELL	OPERATOR_NO	VARCHAR(6)	Unique number assigned to OPERATOR.
105	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_OIL_LEASE	COND_ENDING_BAL	NUMBER(21,0)	This numeric amount is a positive amount that represents the amount of condensate that is available for movement off leases. This is also called "stock on hand." It is computed by adding the condensate ending balance from the previous cycle to the condensate produced and subtracting the total of all of the liquid dispositions.
106	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_OIL_LEASE	COND_LIMIT	NUMBER(21,0)	This data item contains the sum of condensate limit daily amounts for all prorated wells on the lease.
107	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_OIL_LEASE	COND_PROD_VOL	NUMBER(21,0)	The amount of condensate oil in BBL produced by lease as reported by the operator on a production report.
108	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_OIL_LEASE	COND_TOT_DISP	NUMBER(21,0)	This numeric amount has a positive value and represents the number of barrels of condensate disposed.
109	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_OIL_LEASE	COUNTY_NAME	VARCHAR(100)	Name of the county the well is located.
110	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_OIL_LEASE	COUNTY_NO	VARCHAR(3)	The county number (no.) is based on 3-digit numbers: The Railroad Commission assigns a number to each onshore county; the American Petroleum Institute (API) assigns a number to each offshore county. The first 254 number of the code are odd, and indicate onshore counties only. The remaining 23 numbers are both odd and even, and indicate offshore counties.
111	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_OIL_LEASE	CSGD_GAS_LIFT	NUMBER(21,0)	Gas used, given, or sold for gas lift by lease. It does not include gas delivered to pressure maintenance or processing plants, even though the gas may be used for gas lift.
112	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_OIL_LEASE	CSGD_LIMIT	NUMBER(21,0)	This data item contains the sum of casinghead gas limit daily amounts for all prorated wells on the lease.
113	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_OIL_LEASE	CSGD_PROD_VOL	NUMBER(21,0)	The amount of casinghead gas in MCF produced by county and lease as reported by the operator on a production report. This is an estimated value.
114	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_OIL_LEASE	CSGD_TOT_DISP	NUMBER(21,0)	This data item contains the MCF of casinghead gas distributed, by county by lease. This is an estimated value.
115	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_OIL_LEASE	CYCLE_DATE	DATE	This represents the production month and year in YYYY-MM format.
116	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_OIL_LEASE	DISTRICT_NAME	VARCHAR(2)	The RRC district name associated to the lease reported on the production report. The current RRC Districts are 01, 02, 03, 04, 05, 06, 6E, 7B, 7C, 08, 8A, 09, & 10.
117	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_OIL_LEASE	DISTRICT_NO	VARCHAR(2)	A number representing the RRC district name in the RRC system associated to the lease reported on the production report. The 14 districts are represented by a one through fourteen numeric value. The table below indicates the converted values: RRC DISTRICT RRC DISTRICT VALUE ID VALUE ID 01 - 01 08 - 7B 02 - 02 09 - 7C 03 - 03 10 - 08 04 - 04 11 - 8A 05 - 05 13 - 09 06 - 06 14 - 10 07 - 6E (oil only) This value is not used. 12 - 8B
118	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_OIL_LEASE	FIELD_NAME	VARCHAR(32)	A field name is made up of: a word chosen by the operator, the stratigraphic interval name of the formation, and the formation depth at which the field is located, e.g., Johnson Frio 4700.
119	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_OIL_LEASE	FIELD_NO	VARCHAR(8)	An 8-digit number assigned to a field. The first five digits of the field number are unique to each field. The last three numbers are the reservoir number. The numeric value of the first five digits is associated with the alphabet; as the alphabetic field name ascends, the value of the numbers increases. The 3-digit reservoir number doesn't have an alphabetic/numeric relationship. (Note: Wildcat field names and numbers do not have an alpha/numeric relationship of any kind).
120	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_OIL_LEASE	FIELD_TYPE	VARCHAR(2)	This represents the type of field. Values are: FL-49B VALUE '49'. FL-EXEMPT VALUE 'EX'. FL-PRORATED VALUE 'PR'. FL-CYCLING VALUE 'CY'. FL-STORAGE VALUE 'ST'. FL-LIQUID-LIMIT VALUE 'LQ'. FL-CAPACITY VALUE 'CA'. FL-SALVAGE VALUE 'SV'. FL-ONE-WELL VALUE 'ON'. FL-SPECIAL VALUE 'SP'.
121	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_OIL_LEASE	GAS_ALLOW	NUMBER(21,0)	Indicates the allowable assigned to the well for the oil lease.
122	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_OIL_LEASE	GAS_LIFT_INJ_VOL	NUMBER(21,0)	Gas used, given, or sold for gas lift by lease. It does not include gas delivered to pressure maintenance or processing plants, even though the gas may be used for gas lift.
123	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_OIL_LEASE	GAS_PROD_VOL	NUMBER(21,0)	The amount of gas in MCF produced by lease as reported by the operator on a production report.
124	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_OIL_LEASE	GAS_TOT_DISP	NUMBER(21,0)	This numeric amount has a positive value and represents the MCF amount of gas disposed.
125	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_OIL_LEASE	LEASE_NAME	VARCHAR(50)	The name of the lease.
126	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_OIL_LEASE	LEASE_NO	VARCHAR(6)	Number representing the lease; unique within district. Note: for a unique lease number, use the field "LEASE_NO_DISTRICT_NO"
127	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_OIL_LEASE	LEASE_NO_DISTRICT_NO	VARCHAR(8)	Unique number representing the lease.
128	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_OIL_LEASE	OIL_ALLOW	NUMBER(21,0)	Sum of oil well allowables by lease for the cycle.
129	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_OIL_LEASE	OIL_ENDING_BAL	NUMBER(21,0)	This numeric amount is a positive amount that represents the amount of oil that is available for movement off leases by lease. This is also called "stock on hand." It is computed by adding the oil ending balance from the previous cycle to the oil produced and subtracting the total of all of the liquid dispositions.
130	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_OIL_LEASE	OIL_PROD_VOL	NUMBER(21,0)	The amount of oil in BBL produced by lease as reported by the operator on a production report.
131	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_OIL_LEASE	OIL_TOT_DISP	NUMBER(21,0)	This numeric amount has a positive value and represents the barrels of oil disposed of for oil leases.
132	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_OIL_LEASE	OPERATOR_NAME	VARCHAR(50)	The owner of the right to drill or produce a well, or the entity contractually charged with drilling of a test well and production of subsequent wells.
133	PUBLIC_DATA	TRRC	PRODUCTION_VOLUMES_OIL_LEASE	OPERATOR_NO	VARCHAR(6)	Unique number assigned to OPERATOR.
134	PUBLIC_DATA	TRRC	ENTITY_HIERARCHY	DISTRICT_NAME	VARCHAR(50)	The RRC district name associated to the lease reported on the production report. The current RRC Districts are 01, 02, 03, 04, 05, 06, 6E, 7B, 7C, 08, 8A, 09, & 10.
135	PUBLIC_DATA	TRRC	ENTITY_HIERARCHY	DISTRICT_NO	VARCHAR(50)	A number representing the RRC district name in the RRC system associated to the lease reported on the production report. The 14 districts are represented by a one through fourteen numeric value. The table below indicates the converted values: RRC DISTRICT RRC DISTRICT VALUE ID VALUE ID 01 - 01 08 - 7B 02 - 02 09 - 7C 03 - 03 10 - 08 04 - 04 11 - 8A 05 - 05 13 - 09 06 - 06 14 - 10 07 - 6E (oil only) This value is not used. 12 - 8B
136	PUBLIC_DATA	TRRC	ENTITY_HIERARCHY	ENTITYID	VARCHAR(50)	Unique value associated to the Entity.
137	PUBLIC_DATA	TRRC	ENTITY_HIERARCHY	ENTITYNAME	VARCHAR(100)	Name of the entity.
138	PUBLIC_DATA	TRRC	ENTITY_HIERARCHY	ENTITYSUBTYPE	VARCHAR(500)	Description of the entity subtype.
139	PUBLIC_DATA	TRRC	ENTITY_HIERARCHY	ENTITYTYPE	VARCHAR(50)	Description of the entity type.
140	PUBLIC_DATA	TRRC	ENTITY_HIERARCHY	FIELD_FORMATION_NAME	VARCHAR(100)	Name assigned to any rock or sedimentary bed sufficiently distinctive to be a unit.
141	PUBLIC_DATA	TRRC	ENTITY_HIERARCHY	FIELD_NO_DISTRICT_NO	VARCHAR(50)	Unique number representing the field (combination of FIELD_NO & DISTRICT_NO)
142	PUBLIC_DATA	TRRC	ENTITY_HIERARCHY	LEASE_NAME	VARCHAR(100)	The name of the lease.
143	PUBLIC_DATA	TRRC	ENTITY_HIERARCHY	LEASE_NO_DISTRICT_NO	VARCHAR(100)	Unique number representing the lease.
144	PUBLIC_DATA	TRRC	ENTITY_HIERARCHY	WELL_API_10	VARCHAR(10)	The API number is a unique number assigned identify wells. An API number is an 10-digit number made up of a 2-digit state code, a 3-digit county code and a 5-digit unique number.
145	PUBLIC_DATA	TRRC	ENTITY_HIERARCHY	WELL_NAME	VARCHAR(100)	Given name of well; if not provided, the well name is calculated by combining the LEASE NAME and the WELL NUMBER.
146	PUBLIC_DATA	TRRC	WELL	ABSTRACT	VARCHAR(100)	Number assigned to summary statement of facts on which a person's land title rests.
147	PUBLIC_DATA	TRRC	WELL	API10	VARCHAR(100)	The API number is a unique number assigned identify wells. An API number is an 10-digit number made up of a 2-digit state code, a 3-digit county code and a 5-digit unique number.
148	PUBLIC_DATA	TRRC	WELL	BLOCK	VARCHAR(100)	Indentifying number associated with a square portion of land.
149	PUBLIC_DATA	TRRC	WELL	COMPLETION_DATE	DATE	Most recent date completion forms were completed for an oil or gas well. Forms include either a W-2 or G-1 form.
150	PUBLIC_DATA	TRRC	WELL	COUNTRY	VARCHAR(3)	Name of the country the well is located.
151	PUBLIC_DATA	TRRC	WELL	COUNTY	VARCHAR(40)	Name of the county the well is located.
152	PUBLIC_DATA	TRRC	WELL	CURRENT_OPERATOR	VARCHAR(100)	The CURRENT owner of the right to drill or produce the well, or the entity contractually charged with drilling of a test well and production of subsequent wells.
153	PUBLIC_DATA	TRRC	WELL	CURRENT_OPERATOR_NUMBER	VARCHAR(100)	Unique number assigned to CURRENT OPERATOR.
154	PUBLIC_DATA	TRRC	WELL	DF_ELEVATION	VARCHAR(100)	Measurement of Derrick Floor Elevation above Mean Sea Level
155	PUBLIC_DATA	TRRC	WELL	DISTRICT_NO	VARCHAR(100)	A number representing the RRC district name in the RRC system associated to the lease reported on the production report. The 14 districts are represented by a one through fourteen numeric value. The table below indicates the converted values: RRC DISTRICT RRC DISTRICT VALUE ID VALUE ID 01 - 01 08 - 7B 02 - 02 09 - 7C 03 - 03 10 - 08 04 - 04 11 - 8A 05 - 05 13 - 09 06 - 06 14 - 10 07 - 6E (oil only) This value is not used. 12 - 8B
156	PUBLIC_DATA	TRRC	WELL	FIELD	VARCHAR(100)	Field in which the well is located.
157	PUBLIC_DATA	TRRC	WELL	FIELD_NO_DISTRICT_NO	VARCHAR(100)	Unique number representing the field (combination of FIELD_NO & DISTRICT_NO)
158	PUBLIC_DATA	TRRC	WELL	FIELD_NUMBER	VARCHAR(100)	RRC-assigned number for the field.
159	PUBLIC_DATA	TRRC	WELL	FIRST_PROD_DATE	VARCHAR(100)
160	PUBLIC_DATA	TRRC	WELL	GL_ELEVATION	VARCHAR(100)	Measurement of Ground Level Elevation above Mean Sea Level
161	PUBLIC_DATA	TRRC	WELL	KB_ELEVATION	VARCHAR(100)	Measurement of Kelly Bushing Elevation above Mean Sea Level
162	PUBLIC_DATA	TRRC	WELL	LATERAL_LENGTH	VARCHAR(100)
163	PUBLIC_DATA	TRRC	WELL	LATITUDE	FLOAT	Location of a well according to system of spherical coordinates of the Earth which run east and west.
164	PUBLIC_DATA	TRRC	WELL	LEASE	VARCHAR(100)	The name of the lease.
165	PUBLIC_DATA	TRRC	WELL	LEASE_NO_DISTRICT_NO	VARCHAR(100)	Unique number representing the lease.
166	PUBLIC_DATA	TRRC	WELL	LEASE_NUMBER	VARCHAR(100)	Number representing the lease; unique within district. Note: for a unique lease number, use the field "LEASE_NO_DISTRICT_NO"
167	PUBLIC_DATA	TRRC	WELL	LONGITUDE	FLOAT	Location of a well according to system of spherical coordinates of the Earth which run north and south.
168	PUBLIC_DATA	TRRC	WELL	MEASURED_DEPTH	FLOAT	Maximum Depth of Well Bore
169	PUBLIC_DATA	TRRC	WELL	ORIGINAL_OPERATOR	VARCHAR(100)	The ORIGINAL owner of the right to drill or produce the well, or the entity contractually charged with drilling of a test well and production of subsequent wells. The ORIGINAL OPERATOR may not be the CURRENT OPERATOR.
170	PUBLIC_DATA	TRRC	WELL	PERMIT_DATE	DATE	This data item contains the RRC permit issue date.
171	PUBLIC_DATA	TRRC	WELL	PLUG_DATE	DATE	The date reported on the W-3 form by the operator.
172	PUBLIC_DATA	TRRC	WELL	RANGE	VARCHAR(100)	RANGE measures EAST or WEST from the PRINCIPAL MERIDIAN which is a designated meridian. Ranges are also USUALLY SIX MILES in size. The first six miles west of the principal meridian would be range one west, R. 1 W.. R. 3 E. would be 12 to 18 miles east of the principal meridian. Each square, six miles by six miles is called a township.
173	PUBLIC_DATA	TRRC	WELL	SECTION	VARCHAR(100)	Name of subdivision of land that is one mile square, containing approximately 640 acres.
174	PUBLIC_DATA	TRRC	WELL	SPUD_DATE	DATE	This data item contains an eight-character date in century, year, month, day format representing the date drilling was started.
175	PUBLIC_DATA	TRRC	WELL	STATE	VARCHAR(2)	State in which the well was drilled.
176	PUBLIC_DATA	TRRC	WELL	STATE_ID	VARCHAR(100)	2 digit state code used to identify which state the well was drilled.
177	PUBLIC_DATA	TRRC	WELL	SURVEY	VARCHAR(100)	Name associated with the boundaries to a portion of land.
178	PUBLIC_DATA	TRRC	WELL	TOWNSHIP	VARCHAR(100)	TOWNSHIP measures the distance NORTH or SOUTH from the BASE LINE which is a designated parallel. A township USUALLY measures SIX MILES in size. The first six miles north of the base line is township one north written T. 1 N., running from 0 to 6 miles north of the base line. T. 4. S. would, therefore, be 18 to 24 miles south of the base line.
179	PUBLIC_DATA	TRRC	WELL	TVD	VARCHAR(100)	The vertical distance from a point in the well (usually the current or final depth) to a point at the surface, usually the elevation of the rotary kelly bushing.
180	PUBLIC_DATA	TRRC	WELL	UPDATED	DATE	Date the well data was last updated by the TRRC
181	PUBLIC_DATA	TRRC	WELL	WELL_NAME	VARCHAR(100)	Given name of well; if not provided, the well name is calculated by combining the LEASE NAME and the WELL NUMBER.
182	PUBLIC_DATA	TRRC	WELL	WELL_NUMBER	VARCHAR(100)	The number that uniquely identifies the well for a given LEASE.
183	PUBLIC_DATA	TRRC	WELL	WELL_STATUS	VARCHAR(100)	Current status of well. Type of well may be: 1. ABANDONED 2. BRINE MINING 3. DOMESTIC USE WELL 4. GAS STRG-INJECTION 5. GAS STRG-SALT FORMATION 6. GAS STRG-WITHDRAWAL 7. GEOTHERMAL WELL 8. INJECTION 9. LPG STORAGE 10. NO PRODUCTION 11. NOT ELIGIBLE FOR ALLOWABLE 12. OBSERVATION 13. OTHER TYPE SERVICE 14. PARTIAL PLUG 15. PROD FACTOR WELL 16. PRODUCING 17.SEALED 18.SHUT IN 19.SHUT IN – MULTI- COMPLETIONS 20.SWR-10-WELL 21. TEMP ABANDONED 22. TRAINING 23.WATER SUPPLY
184	PUBLIC_DATA	TRRC	WELL	WELL_TYPE	VARCHAR(100)	Indicates if the well is an Oil well or Gas well
185	PUBLIC_DATA	TRRC	WELL	WELLBORE_PROFILE	VARCHAR(100)	Indicates whether or not a directional survey has been filed
186	PUBLIC_DATA	TRRC	WELL	WELLUID	VARCHAR(100)	Unique identifier for the well provided by the TRRC


1	PRODUCTION_VOLUMES
2		COUNTY_NO	COUNTY_NAME	DISTRICT_NO	DISTRICT_NAME	FIELD_NO	FIELD_NAME	FIELD_TYPE	LEASE_NO	LEASE_NAME	LEASE_NO_DISTRICT_NO	GAS_WELL_NO	OPERATOR_NO	OPERATOR_NAME	CYCLE_DATE	OIL_PROD_VOL	OIL_ALLOW	OIL_ENDING_BAL	GAS_PROD_VOL	GAS_ALLOW	GAS_LIFT_INJ_VOL	COND_PROD_VOL	COND_LIMIT	COND_ENDING_BAL	CSGD_PROD_VOL	CSGD_LIMIT	CSGD_GAS_LIFT	OIL_TOT_DISP	GAS_TOT_DISP	COND_TOT_DISP	CSGD_TOT_DISP
3		48105	CROCKETT	9	7C	67995200	OZONA (CANYON SAND)	CA	153172	HATTON, E.H. ESTATE "10D"	15317209	2	20542	ANADARKO E&P COMPANY LP	2007-05-01	0	0	0	148	186	0	0	0	0	0	0	0	0	148	0	0
4		48161	FREESTONE	5	5	88576304	TEAGUE (CV-BOSSIER CONS.)	CA	217518	UTLEY "C"	21751805	28	525380	MARATHON OIL COMPANY	2007-10-01	0	0	0	8744	10137	0	0	0	0	0	0	0	0	8744	0	0
5		48105	CROCKETT	9	7C	67995200	OZONA (CANYON SAND)	CA	153390	HOOVER, LAURA ESTATE "52D"	15339009	2	20542	ANADARKO E&P COMPANY LP	2007-09-01	0	0	0	1451	1451	0	0	0	0	0	0	0	0	1451	0	0
6		48105	CROCKETT	9	7C	67995200	OZONA (CANYON SAND)	CA	153390	HOOVER, LAURA ESTATE "52D"	15339009	2	20542	ANADARKO E&P COMPANY LP	2007-12-01	0	0	0	1345	1488	0	0	0	0	0	0	0	0	1345	0	0
7
8	WELL
9		WELLUID	API10	WELL_NAME	WELL_TYPE	LEASE	LEASE_NUMBER	WELL_NUMBER	STATE_ID	FIELD	FIELD_NUMBER	DISTRICT_NO	LEASE_NO_DISTRICT_NO	FIELD_NO_DISTRICT_NO	COUNTY	STATE	COUNTRY	SECTION	TOWNSHIP	RANGE	GL_ELEVATION	KB_ELEVATION	DF_ELEVATION	PERMIT_DATE	CURRENT_OPERATOR	CURRENT_OPERATOR_NUMBER	ORIGINAL_OPERATOR	SPUD_DATE	COMPLETION_DATE	PLUG_DATE	WELL_STATUS	FIRST_PROD_DATE	WELLBORE_PROFILE	ABSTRACT	MEASURED_DEPTH	BLOCK	TVD	SURVEY	LATERAL_LENGTH	LATITUDE	LONGITUDE	UPDATED
10		19588	4200338873	MEANS /SAN ANDRES/ UNIT 5414W	O	MEANS /SAN ANDRES/ UNIT	17503	5414W		MEANS	60137001	10	1750310	6013700110	ANDREWS	TX	USA	3			3159				XTO ENERGY INC.	945936			2002-02-06		INJECTION		VERTICAL	912	4626	C-45		P.S.L./T. E. MCDILL		32.48685	-102.55184	2002-06-27
11		195280	4209783050	BATTERY OTTO #2 14A	O	BATTERY OTTO #2	28163	14A		COOKE COUNTY REGULAR	20350001	13	2816313	2035000113	COOKE	TX	USA								MILLER GLENN J.	567780			1996-06-21	1980-05-28	PRODUCING		VERTICAL	148	828			BBB & CRR CO.		33.68166	-97.32797	1996-09-11
12		205117	4210331872	NORTH MCELROY UNIT 3357	O	NORTH MCELROY UNIT	20377	3357		MCELROY	59337001	10	2037710	5933700110	CRANE	TX	USA								APACHE CORPORATION	27200			1978-08-02		SHUT IN		VERTICAL		3175					31.46367	-102.37295	1984-01-12
13		227600	4210542397	UNIVERSITY EAST 4415AH	O	UNIVERSITY EAST	17576	4415AH		LIN (WOLFCAMP)	53613750	9	1757609	5361375009	CROCKETT	TX	USA	15			2674				EP ENERGY E&P COMPANY L.P.	253385			2017-05-31		PRODUCING		HORIZONTAL	U394	6917	44		UL		31.03561	-101.21843	2017-12-22
14
15	ENTITY_HIERARCHY
16		ENTITYTYPE	ENTITYSUBTYPE	ENTITYID	ENTITYNAME	DISTRICT_NO	DISTRICT_NAME	FIELD_NO_DISTRICT_NO	FIELD_FORMATION_NAME	LEASE_NO_DISTRICT_NO	LEASE_NAME	WELL_API_10	WELL_NAME
17		WELL	O	4208332038	BIBLE DON 1	8	DISTRICT 7B	1951100108	COLEMAN COUNTY REGULAR	1838208	BIBLE DON	4208332038	BIBLE DON 1
18		WELL	O	4208332041	BIBLE DON 5	8	DISTRICT 7B	1951100108	COLEMAN COUNTY REGULAR	1838208	BIBLE DON	4208332041	BIBLE DON 5
19		WELL	O	4208332043	DEBUSK 1	8	DISTRICT 7B	1951100108	COLEMAN COUNTY REGULAR	1754708	DEBUSK	4208332043	DEBUSK 1
20		WELL	O	4208332047	DEVANNEY 2	8	DISTRICT 7B	2743750008		1630208	DEVANNEY	4208332047	DEVANNEY 2
21
22	PRODUCTION_MONTHS
23		CYCLE_YEAR_MONTH	MONTH_HAS_PRODUCTION_FLAG
24		199803	1
25		199802	1
26		199801	1
27		199712	1
28
29	OPERATOR
30		OPERATOR_NO	OPERATOR_NAME	P5_STATUS_CODE	P5_LAST_FILED_DT	OPERATOR_TAX_CERT_FLAG	OPERATOR_SB639_FLAG	FA_OPTION_CODE
31		129007	CANION OIL AND GAS	I	2001-05-01	Y	N	41
32		129008	CANAN MOWREY OPERATING, LLC	A	2019-11-21	Y	N	2
33		129009	CANDELERO OIL & GAS COMPANY	I	1999-01-05	Y	Y	3
34		129010	CANARY PRODUCTION SERVICES, LLC	A	2019-10-18	Y	Y	99
35
36	LEASE
37		LEASE_NO_DISTRICT_NO	LEASE_NO	DISTRICT_NO	LEASE_NAME
38		24238806	242388	6	WILLIAMS, A. GAS UNIT
39		20382710	203827	10	BLOCK 31 UNIT
40		26584506	265845	6	HARRELL, JEANETTE
41		26589006	265890	6	BROWN, KATHLEEN LEE GU
42
43	COUNTY
44		COUNTY_NO	COUNTY_NAME	COUNTY_FIPS_CODE	DISTRICT_NO	DISTRICT_NAME	ON_SHORE_FLAG
45		363	PALO PINTO	48363	8	DISTRICT 7B	Y
46		367	PARKER	48367	8	DISTRICT 7B	Y
47		411	SAN SABA	48411	8	DISTRICT 7B	Y
48		417	SHACKELFORD	48417	8	DISTRICT 7B	Y
49
50	FIELD_DISTRICT
51		FIELD_NO	DISTRICT_NO	FIELD_NO_DISTRICT_NO	FIELD_NAME_DISTRICT_NO	FIELD_NAME_DISTRICT_NAME	FIELD_FORMATION_NAME
52		81422500	13	8142250013	SCHENK (13)	SCHENK (09)	SCHENK (CONGL. 5600)
53		82226500	11	8222650011	SEMINOLE, EAST (11)	SEMINOLE, EAST (8A)	SEMINOLE, EAST (SAN ANDRES)
54		85000900	14	8500090014	SPEARMAN, EAST (14)	SPEARMAN, EAST (10)	SPEARMAN, EAST (ST. LOUIS)
55		52624200	10	5262420010	LEA (10)	LEA (08)	LEA (CONNELL)
56
57	FIELD
58		FIELD_NUMBER	FIELD_NAME	FIELD_DISTRICT	RESERVOIR_NUMBER	RESERVOIR_NAME	FIELD_COUNTRY_NAME	FIELD_STATE_NAME	FIELD_STATE_ABBR	FIELD_COUNTY_STATE	FIELD_COUNTY_NAME	FIELD_MULTI_COUNTY_FLAG	FIELD_CLASSIFICATION
59		2999	WILDCAT-COMMISSION USE ONLY	1	999		USA	TEXAS	TX	EDWARDS COUNTY, TX	EDWARDS	N	OIL
60		4666	WILDCAT-COMMISSION USE ONLY	2	666		USA	TEXAS	TX	LIVE OAK COUNTY, TX	LIVE OAK	N	OIL
61		4999	WILDCAT-COMMISSION USE ONLY	2	999		USA	TEXAS	TX	LAVACA COUNTY, TX	LAVACA	N	OIL
62		6000	WILDCAT-COMMISSION USE ONLY	3	0		USA	TEXAS	TX	BRAZORIA COUNTY, TX	BRAZORIA	N	OIL
63
64	DISTRICT
65		DISTRICT_NO	DISTRICT_NAME
66		14	10
67		1	1
68		2	2
69		8	7B
70
71	PRODUCTION_VOLUMES_GAS_WELL
72		COUNTY_NO	COUNTY_NAME	DISTRICT_NO	DISTRICT_NAME	FIELD_NO	FIELD_NAME	FIELD_TYPE	LEASE_NO	LEASE_NAME	LEASE_NO_DISTRICT_NO	API_10	GAS_WELL_NO	OPERATOR_NO	OPERATOR_NAME	CYCLE_DATE	OIL_PROD_VOL	OIL_ALLOW	OIL_ENDING_BAL	GAS_PROD_VOL	GAS_ALLOW	GAS_LIFT_INJ_VOL	COND_PROD_VOL	COND_LIMIT	COND_ENDING_BAL	CSGD_PROD_VOL	CSGD_LIMIT	CSGD_GAS_LIFT	OIL_TOT_DISP	GAS_TOT_DISP	COND_TOT_DISP	CSGD_TOT_DISP
73		48355	NUECES	4	4	75205499	RED FISH BAY, NORTH (9100-C)	ON	209458	STATE TRACT 342	20945804	4235530107	1	153474	CINCO NATURAL RESOURCES CORP.	2011-01-01	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
74		48355	NUECES	4	4	75205499	RED FISH BAY, NORTH (9100-C)	ON	209458	STATE TRACT 342	20945804	4235530107	1	153474	CINCO NATURAL RESOURCES CORP.	2011-04-01	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
75		48489	WILLACY	4	4	74975200	RAYMONDVILLE (CONSOLIDATED)	CA	229620	YTURRIA, H.	22962004	4248931166	4020	164455	CODY ENERGY LLC	2016-03-01	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
76		48481	WHARTON	3	3	9962500	BOB ALEXANDER (MASSIVE WILCOX)	CA	214666	KOONCE GAS UNIT	21466603	4248134772	4	834097	TMR EXPLORATION, INC.	2019-04-01	0	0	0	4604	4604	0	5	0	0	0	0	0	0	4604	0	0
77
78	PRODUCTION_VOLUMES_OIL_LEASE
79		COUNTY_NO	COUNTY_NAME	DISTRICT_NO	DISTRICT_NAME	FIELD_NO	FIELD_NAME	FIELD_TYPE	LEASE_NO	LEASE_NAME	LEASE_NO_DISTRICT_NO	OPERATOR_NO	OPERATOR_NAME	CYCLE_DATE	OIL_PROD_VOL	OIL_ALLOW	OIL_ENDING_BAL	GAS_PROD_VOL	GAS_ALLOW	GAS_LIFT_INJ_VOL	COND_PROD_VOL	COND_LIMIT	COND_ENDING_BAL	CSGD_PROD_VOL	CSGD_LIMIT	CSGD_GAS_LIFT	OIL_TOT_DISP	GAS_TOT_DISP	COND_TOT_DISP	CSGD_TOT_DISP
80		48049	BROWN	8	7B	12406001	BROWN COUNTY REGULAR	C	21530	SHULTS HEIRS "A"	2153008	665870	PITCOCK, INC.	1999-06-01	92	180	78	0	0	0	0	0	0	428	4320	0	171	0	0	428
81		48409	SAN PATRICIO	4	4	83754646	SINTON, NORTH (4600)	R	7311	WELDER, R. H. -A- A/C 1	731104	525380	MARATHON OIL COMPANY	1999-10-01	758	899	244	0	0	0	0	0	0	1994	5766	0	657	0	0	1994
82		48051	BURLESON	3	3	34733600	GIDDINGS (BUDA)	R	23559	SLOVACEK-SLOVACEK UNIT	2355903	876645	UNION PACIFIC RESOURCES COMPANY	1999-12-01	135	186	199	0	0	0	0	0	0	371	54436	0	181	0	0	371
83		48387	RED RIVER	6	6	53164075	LENNOX (COTTON VALLEY CONGL.)	N	13825	LENNOX	1382506	847991	TEXAS ROYALTY CORP.	1999-12-01	388	434	282	0	0	0	0	0	0	1	9920	0	373	0	0	1


1	Use Case	Description	Query (Please copy / paste entire content of cell)

2	Texas Top 20 Operators in 2020	In this example, we are showing the top producing operators in 2020 within Texas. We are combining production volumes for all four captured products, converting each to a standard unit, BOE.	-- Top Producing Operators in 2020 (Texas) WITH GasWellCount AS ( SELECT COUNT() AS GasWellCount , LEASE_NO_DISTRICT_NO FROM TRRC.WELL WHERE WELL_TYPE = 'G' GROUP BY LEASE_NO_DISTRICT_NO ) , OilWellCount AS ( SELECT COUNT() AS OilWellCount , LEASE_NO_DISTRICT_NO FROM TRRC.WELL WHERE WELL_TYPE = 'O' GROUP BY LEASE_NO_DISTRICT_NO ) , Operator_Volumes AS ( SELECT OPERATOR_NO , SUM(OIL_PROD_VOL) AS OIL_PROD_BBL , SUM(COND_PROD_VOL) AS COND_PROD_BBL , SUM(GAS_PROD_VOL) AS GAS_PROD_MCF , SUM(CSGD_PROD_VOL) AS CSGD_PROD_MCF , CAST(SUM(GAS_PROD_VOL) / 6.00 AS INT) AS GAS_PROD_BBE , CAST(SUM(CSGD_PROD_VOL) / 6.00 AS INT) AS CSGD_PROD_BBE , CAST(SUM(OIL_PROD_VOL + COND_PROD_VOL + GAS_PROD_VOL / 6.00 + CSGD_PROD_VOL / 6.00 ) AS INT) AS TOTAL_BOE , PV.LEASE_NO_DISTRICT_NO , OilWellCount , GasWellCount FROM PUBLIC_DATA.TRRC.PRODUCTION_VOLUMES PV LEFT OUTER JOIN OilWellCount OC ON OC.LEASE_NO_DISTRICT_NO = PV.LEASE_NO_DISTRICT_NO LEFT OUTER JOIN GasWellCount GC ON GC.LEASE_NO_DISTRICT_NO = PV.LEASE_NO_DISTRICT_NO WHERE CYCLE_DATE >= CAST('2020-01-01' AS DATE) GROUP BY OPERATOR_NO , PV.LEASE_NO_DISTRICT_NO , OilWellCount , GasWellCount HAVING CAST(SUM(OIL_PROD_VOL + COND_PROD_VOL + GAS_PROD_VOL / 6.00 + CSGD_PROD_VOL / 6.00 ) AS INT) > 0 ) , Operator_Sums AS ( SELECT OPERATOR_NO , SUM(OIL_PROD_BBL) AS OIL_PROD_BBL , SUM(COND_PROD_BBL) AS COND_PROD_BBL , SUM(GAS_PROD_MCF) AS GAS_PROD_MCF , SUM(CSGD_PROD_MCF) AS CSGD_PROD_MCF , SUM(GAS_PROD_BBE) AS GAS_PROD_BBE , SUM(CSGD_PROD_BBE) AS CSGD_PROD_BBE , SUM(TOTAL_BOE) AS TOTAL_BOE , COUNT(*) AS ProducingLeaseCount , SUM(OilWellCount) AS OilWellCount , SUM(GasWellCount) AS GasWellCount FROM Operator_Volumes GROUP BY OPERATOR_NO ) SELECT TOP 20 O.OPERATOR_NAME AS Operator_Name , OS.ProducingLeaseCount AS ProducingLeaseCount , OS.OilWellCount AS OilWellCount , OS.GasWellCount AS GasWellCount , OS.TOTAL_BOE AS Total_BOE , OS.OIL_PROD_BBL AS Oil_BBL , OS.COND_PROD_BBL AS Condensate_BBL , OS.GAS_PROD_MCF AS Gas_MCF , OS.CSGD_PROD_MCF AS Casinghead_Gas_MCF FROM Operator_Sums OS LEFT OUTER JOIN TRRC.OPERATOR O ON O.OPERATOR_NO = OS.OPERATOR_NO ORDER BY OS.TOTAL_BOE DESC ;
3	Production Volumes (Single Well)	In this example, we are showing production volumes for a single well. Simply replace the well API included (4246932770) with a well API of your choice. Use the results of this query to plot the production volumes on a chart for better analysis.	SET API10=4240135414; --Enter Well's API10 here WITH OIL_PRODUCTION AS ( SELECT DISTINCT EH_WELL.WELL_API_10 WELL_API_10, EH_WELL.WELL_NAME, EH_WELL.LEASE_NAME, EH_WELL.LEASE_NO_DISTRICT_NO, PROD_VOL.CYCLE_DATE, PROD_VOL.OIL_PROD_VOL, NULL AS "Lease_Gas_Production_Volume", NULL AS "Lease_Condensate_Production_Volume", PROD_VOL.CSGD_PROD_VOL FROM TRRC.ENTITY_HIERARCHY EH_WELL INNER JOIN TRRC.PRODUCTION_VOLUMES PROD_VOL ON PROD_VOL.LEASE_NO_DISTRICT_NO = EH_WELL.LEASE_NO_DISTRICT_NO WHERE EH_WELL.ENTITYTYPE = 'WELL' AND EH_WELL.ENTITYSUBTYPE = 'O' AND WELL_API_10 = $API10 ) , GAS_PRODUCTION AS ( SELECT DISTINCT EH_WELL.WELL_API_10 WELL_API_10, EH_WELL.WELL_NAME, EH_WELL.LEASE_NAME, EH_WELL.LEASE_NO_DISTRICT_NO, PROD_VOL.CYCLE_DATE, NULL AS "Lease_Oil_Production_Volume", PROD_VOL.GAS_PROD_VOL, PROD_VOL.COND_PROD_VOL, NULL AS "Lease_CSGD_Production_Volume" FROM TRRC.ENTITY_HIERARCHY EH_WELL INNER JOIN TRRC.PRODUCTION_VOLUMES PROD_VOL ON PROD_VOL.LEASE_NO_DISTRICT_NO = EH_WELL.LEASE_NO_DISTRICT_NO WHERE EH_WELL.ENTITYTYPE = 'WELL' AND EH_WELL.ENTITYSUBTYPE = 'G' AND WELL_API_10 = $API10 ) SELECT DISTINCT COALESCE(OIL_PRODUCTION.WELL_NAME,GAS_PRODUCTION.WELL_NAME) WELL_NAME, COALESCE(OIL_PRODUCTION.CYCLE_DATE,GAS_PRODUCTION.CYCLE_DATE) CYCLE_DATE, OIL_PRODUCTION.OIL_PROD_VOL, GAS_PRODUCTION.GAS_PROD_VOL, GAS_PRODUCTION.COND_PROD_VOL, OIL_PRODUCTION.CSGD_PROD_VOL FROM OIL_PRODUCTION FULL OUTER JOIN GAS_PRODUCTION ON GAS_PRODUCTION.Well_API_10 = OIL_PRODUCTION.Well_API_10 AND GAS_PRODUCTION.CYCLE_DATE = OIL_PRODUCTION.CYCLE_DATE ORDER BY 1,2
4	Texas Top 20 Counties in 2020	In this example, we are showing the top producing counties in 2020 within Texas. We are combining production volumes for all four capture products, converting each to a standard unit, BOE.	-- Top Producing Counties in 2020 (Texas) WITH GasWellCount AS ( SELECT COUNT() AS GasWellCount , LEASE_NO_DISTRICT_NO FROM WELL WHERE WELL_TYPE = 'G' GROUP BY LEASE_NO_DISTRICT_NO ) , OilWellCount AS ( SELECT COUNT() AS OilWellCount , LEASE_NO_DISTRICT_NO FROM WELL WHERE WELL_TYPE = 'O' GROUP BY LEASE_NO_DISTRICT_NO ) , CountyVolumes AS ( SELECT COUNTY_NAME , COUNTY_NO , SUM(OIL_PROD_VOL) AS OIL_PROD_BBL , SUM(COND_PROD_VOL) AS COND_PROD_BBL , SUM(GAS_PROD_VOL) AS GAS_PROD_MCF , SUM(CSGD_PROD_VOL) AS CSGD_PROD_MCF , CAST(SUM(GAS_PROD_VOL) / 6.00 AS INT) AS GAS_PROD_BOE , CAST(SUM(CSGD_PROD_VOL) / 6.00 AS INT) AS CSGD_PROD_BOE , CAST(SUM(OIL_PROD_VOL + COND_PROD_VOL + GAS_PROD_VOL / 6.00 + CSGD_PROD_VOL / 6.00 ) AS INT) AS TOTAL_BOE , PV.LEASE_NO_DISTRICT_NO , OilWellCount , GasWellCount FROM PRODUCTION_VOLUMES PV LEFT OUTER JOIN OilWellCount OC ON OC.LEASE_NO_DISTRICT_NO = PV.LEASE_NO_DISTRICT_NO LEFT OUTER JOIN GasWellCount GC ON GC.LEASE_NO_DISTRICT_NO = PV.LEASE_NO_DISTRICT_NO WHERE CYCLE_DATE >= CAST('2020-01-01' AS DATE) GROUP BY COUNTY_NAME , COUNTY_NO , PV.LEASE_NO_DISTRICT_NO , OilWellCount , GasWellCount HAVING CAST(SUM(OIL_PROD_VOL + COND_PROD_VOL + GAS_PROD_VOL / 6.00 + CSGD_PROD_VOL / 6.00 ) AS INT) > 0 ) , County_Sums AS ( SELECT COUNTY_NAME , COUNTY_NO , SUM(OIL_PROD_BBL) AS OIL_PROD_BBL , SUM(COND_PROD_BBL) AS COND_PROD_BBL , SUM(GAS_PROD_MCF) AS GAS_PROD_MCF , SUM(CSGD_PROD_MCF) AS CSGD_PROD_MCF , SUM(GAS_PROD_BOE) AS GAS_PROD_BOE , SUM(CSGD_PROD_BOE) AS CSGD_PROD_BOE , SUM(TOTAL_BOE) AS TOTAL_BOE , COUNT(*) AS ProducingLeaseCount , SUM(OilWellCount) AS OilWellCount , SUM(GasWellCount) AS GasWellCount FROM CountyVolumes GROUP BY COUNTY_NAME ,COUNTY_NO ) SELECT TOP 20 CS.COUNTY_NAME AS County_Name , CS.COUNTY_NO AS County_Number , CS.ProducingLeaseCount AS ProducingLeaseCount , CS.OilWellCount AS OilWellCount , CS.GasWellCount AS GasWellCount , CS.TOTAL_BOE AS Total_BOE , CS.OIL_PROD_BBL AS Oil_BBL , CS.COND_PROD_BBL AS Condensate_BBL , CS.GAS_PROD_BOE AS Gas_BOE , CS.CSGD_PROD_BOE AS Casinghead_Gas_BOE FROM County_Sums CS ORDER BY CS.TOTAL_BOE DESC ;
5	To submit a use case request, click here or email info@sbconsulting.com.


1	Data Summary	Count (Est)*	Count as %*
2	U.S. Oil & Gas Wells	4,753,080	100%
3	EnerPub v1.0 Release	1,019,917	21.5%
4			*as of June 2020
5
6	State Well Populations				EnerPub Data Availability Status by Attribute Categories
7	STATE	Well Count (Est.)	EnerPub Count	Connector	Well Header	Production	Formations	Injection	Permits	Completions	Well Tests	Frac Info	Frac Ingredients	Casing	Tubing	Perfs	Plugs	Plug & Abandon
8	TX	1,019,917	1,019,917	Active	v1.0	v1.0
18	NM	122,899	0		v1.5	v1.5