Wellbore Form Dates
Queryable Fixed-width
When each form was filed against a wellbore, plus elevation and plug-back depths.
Get the data
Free. You will be asked to confirm an email address before the files are built — that is the only gate, and it is there so we can tell you when a large export is ready.
What this is
Record type 03. The filing calendar of a wellbore: the W-2/G-1 completion date, the drilling completion date, the dates attached to each form key, the surface elevation and how it was determined, and the plug-back depths.
It is the closest thing the wellbore database has to a timeline.
What you can do with it
Reconstruct when a well was drilled, completed and re-worked, and pull the surface elevation needed to convert measured depths to subsea.
Gotchas
The elevation code says how the elevation was measured — a GR (ground level) and a KB (kelly bushing) elevation differ by the height of the rig floor, so comparing them without checking the code is a mistake of tens of feet.
Sentinel dates are everywhere: 0000-00-00, 00000000 and 1900-01-01 all mean "not recorded". The upstream loader turns the unparseable ones into NULL, but a 1900 date that parsed cleanly is still a placeholder, not a fact.
Record layout
24 columns. Byte positions are 1-based and come from the RRC record layout, so you can check our decoding against the original file yourself.
wb_dates
24 columns
| # | Column | Type | Bytes | RRC name | Meaning | Lookup |
|---|---|---|---|---|---|---|
| 1 |
api_county
key
join
|
text | — | — | The three-digit county component of the API number. For offshore wells this is the nearest onshore county, not the well's actual location. | — |
| 2 |
api_unique
key
join
|
text | — | — | The five-digit well component of the API number. Unique only in combination with the county code. | — |
| 3 |
file_key
key
|
text | 3-10 | WB-FILE-KEY |
Key of the technical-data form set this row describes. | — |
| 4 |
file_date
|
date | 11-18 | WB-FILE-DATE |
Date the completion build was filed, CCYYMMDD. | — |
| 5 |
except_rule_11
|
text | 27 | WB-EXCEPT-RULE-11 |
Y when an exception to Statewide Rule 11 was granted. | — |
| 6 |
cement_affidavit
|
text | 28 | WB-CEMENT-AFFIDAVIT |
Cement affidavit status: N, Y, B, A or R. | — |
| 7 |
g5_flag
|
text | 29 | WB-G5-FLAG |
Y when a Form G-5 gas well classification is on file. | — |
| 8 |
w12_flag
|
text | 30 | WB-W12-FLAG |
Y when a Form W-12 inclination report is on file. | — |
| 9 |
dir_survey
|
text | 31 | WB-DIR-SURVEY |
Y when a directional survey is on file. | — |
| 10 |
w2_g1_date
|
date | 32-39 | WB-W2-G1-DATE |
Date the W-2 or G-1 completion report was filed, CCYYMMDD. | — |
| 11 |
compl_date
|
date | 40-47 | WB-COMPL-DATE |
Completion date, CCYYMMDD. | — |
| 12 |
drl_compl_date
|
date | 48-55 | WB-DRL-COMPL-DATE |
Date drilling was completed, CCYYMMDD. | — |
| 13 |
plugb_depth1
|
integer measured in ft | 56-60 | WB-PLUGB-DEPTH1 |
First plug-back depth, feet. | — |
| 14 |
plugb_depth2
|
integer measured in ft | 61-65 | WB-PLUGB-DEPTH2 |
Second plug-back depth, feet. | — |
| 15 |
water_injection_nbr
|
text | 66-71 | WB-WATER-INJECTION-NBR |
Water injection permit number. | — |
| 16 |
salt_wtr_nbr
|
text | 72-76 | WB-SALT-WTR-NBR |
Saltwater disposal permit number. | — |
| 17 |
remarks_ind
|
text | 85 | WB-REMARKS-IND |
Y when remark records exist for this bore. | — |
| 18 |
elevation
|
integer measured in ft | 86-89 | WB-ELEVATION |
Ground or derrick elevation, feet. | — |
| 19 |
elevation_code
|
text | 90-91 | WB-ELEVATION-CODE |
Which point the elevation was measured from. Depths are relative to it. | Elevation reference point |
| 20 |
docket_nbr
|
text | 100-109 | WB-DOCKET-NBR |
Docket number associated with the completion, if any. | — |
| 21 |
psa_well_flag
|
text | 110 | WB-PSA-WELL-FLAG |
Y when the horizontal well is covered by a production sharing agreement. | — |
| 22 |
allocation_well_flag
|
text | 111 | WB-ALLOCATION-WELL-FLAG |
Y when the well is an allocation well. | — |
| 23 |
ingested_at
|
timestamptz | — | — | When the upstream pipeline last wrote this row. Not an RRC field — it is EZRRC's provenance stamp, and it is what the freshness badge is measured against. | — |
| 24 |
log_file_rba
|
text | 92-99 | WB-LOG-FILE-RBA |
Pointer into RRC's separate wellbore log file. | — |
Code lookups used here
Every coded column in this dataset resolves to a real lookup table, so
a well code of G can be read as what it actually means.
Elevation reference point 5 values
Read by elevation_code
The point the elevation was measured from. Depths in the same record are measured from this datum, so two wells are not comparable until you know which one each used.
| Code | Means |
|---|---|
GL |
Ground level |
DF |
Derrick floor |
KB |
Kelly bushing |
RT |
Rotary table |
GR |
Ground |
Source: RRC manual WBA091, COBOL 88-level values on WB-ELEVATION-CODE
What this joins to
The Railroad Commission never states these keys anywhere in the files. They are the reason the data is hard to use, so here they are with the exact columns on both sides.
Wellbore Form Dates joins to Full Wellbore Database (ASCII) on API county and API unique — many rows here share a single row there.
its form filing dates
The W-2/G-1, drilling completion and plug-back dates recorded against the wellbore, one row per form key. Keyed on the API county and unique number, which is how every record type in WBA091 hangs off its root record.
full-wellbore-ascii.api_county = wellbore-form-dates.api_county AND full-wellbore-ascii.api_unique = wellbore-form-dates.api_unique
Where this comes from
- Published by
- Texas Railroad Commission — the original page
- Original format
- Fixed-width Columns are byte ranges with no separators, described only in a scanned record layout.
- Update cadence
- Updated once a week (Weekly, with the wellbore database.)
- RRC download link
- GoAnywhere MFT
- Record layout manual
- Our table
texas.wb_dates
EZRRC is an independent mirror of public-domain data published by the Texas Railroad Commission. It is not affiliated with or endorsed by the RRC. For any legal or regulatory purpose, verify against the official RRC release.