First 100 rows

Out of roughly 33.9K rows in texas.fl_oil_field. Version obs-0899cd28df65.

First 100 rows of texas.fl_oil_field, 34 columns wide
district_nofield_nodisc_datedisc_county_codedepth_1st_welltesting_countyfirst_alter_test_monthsecond_alter_test_monthoffshore_codeschedule_column_hdg_cdcum_oil_prod_to_convcum_cshd_prod_to_convcum_oil_allow_to_convcum_cshd_allow_to_convoff_file_cum_oil_allowoff_file_cum_cshd_allowoff_file_cum_oil_prodoff_file_cum_cshd_prodon_file_cum_oil_allowon_file_cum_cshd_allowon_file_cum_oil_prodon_file_cum_cshd_prodytd_cum_oil_allowytd_cum_cshd_allowytd_cum_oil_prodytd_cum_cshd_prodledger_monthschedule_lines_counterannual_lines_counteroriginal_oil_in_placeeb_exempt_flagschedule_start_datenew_field_approval_dateconsolidated_field_flag
012001April 1, 1972099999017LA000014848276181402895416360000000006000NApril 1, 1972nullnull
012999Aug. 11, 2004137028300LA00000000000000006220NAug. 11, 2004Aug. 11, 2004Y
01256500Dec. 20, 1981311980031100LB276130316503513417135179685346487248194068849548352210674619255853116109533479790848283275316604055204812196982376761360NDec. 1, 1981nullnull
01256600March 4, 1988311613031100LA000086181290500047011191902000000006000NMarch 1, 1988nullnull
01256700Sept. 27, 1987311665831100LA000010450968142179931862000000006000NNov. 1, 1995nullnull
01256750Nov. 16, 2002311619231100LA000086709280075254765144229822608280000006000NNov. 16, 2002Nov. 16, 2002null
01434333Feb. 5, 1958127403212700LA898100076726409424096000000006000NFeb. 1, 1958nullnull
01434666July 29, 1957127420512700LA1202310000000000000006000NJuly 1, 1957nullnull
01467500March 16, 1952493306849300LA22826422603106302260801922585411320960833234498589103737601195023229267235706210NMarch 1, 1952nullnull
01467505April 1, 1981493283849300LA607057781231784888144671140252680925520644442227515768001389704499390960228806000NApril 1, 1981nullnull
01467510April 1, 1981493288149300LA3350329138674129041769369624058985640670710225117305149796041240434437141279806000NApril 1, 1981nullnull
01467515April 1, 1981493291549300LA13671136752926064389650573324506292200791712277260809600185506727394031606000NApril 1, 1981nullnull
01621200Aug. 20, 1976325182232500LA78292183796119567692506896505143909224266482432454721811441229621011584281274169606200NAug. 1, 1976nullnull
01621333April 2, 195832538232500LA3426830138302796225150725480983230093218083012242801047014482896017006000NApril 1, 1958nullnull
01748500March 16, 19562144742100LA1610000000000000006000NMarch 1, 1956nullnull
011057500Jan. 31, 1984311976831100LA0000169861448001329119000000006000NJan. 1, 1984nullnull
011313500Feb. 13, 1966187194918700LA17385562292747630000000000006000NFeb. 1, 1966nullnull
011780300June 2, 1990507358950700LA00004424819841653120000000006000NJune 1, 1990nullnull
011780500March 16, 1980507369150700LA1030862882371504906917927397181217311243008665887010950367920330271591224606000NMarch 1, 1980nullnull
012031001null2911002900LA58809406111698708124061741968417161395000000006000Nnullnullnull
012396500Jan. 30, 1977127590012700LA1668101630975120643057866557221732360226210348108442021140166023896014306600NJan. 1, 1977nullnull
012564001Jan. 16, 19521322981300LA813849915013377576267996293106189123000000006000NJan. 1, 1952nullnull
012663500April 12, 197450755250700LA168874936170400000000000006000NApril 1, 1974nullnull
012769200April 24, 1985493530549300LA0000976971197000297846947000000006000NApril 1, 1985nullnull
013375500Jan. 1, 19792117492100LA30624864121600000000000006000NJan. 1, 1979nullnull
013806200Aug. 26, 1962311348131100LA2261884936720571616826115806182405874111000000006000NAug. 1, 1962nullnull
013806400July 2, 1963311540631100LA19033917213367451702540000000000006000NJuly 1, 1963nullnull
013806600July 10, 1963311588631100LA4720203085624535830232191574863692604783116583000000006000NJuly 1, 1963nullnull
013806800Aug. 24, 1963311593831100LA41142917877198150272501521895532964361517889156000000006000NAug. 1, 1963nullnull
013946500Dec. 12, 1976507658950700LA7073268515400308000000000000006110NDec. 1, 1976nullY
014078666Aug. 28, 1955127332212700LA6130000000000000006000NAug. 1, 1955nullnull
014079530Nov. 3, 1981127453312700LA137715380084800799922469435041000000006000NNov. 1, 1981nullnull
014079540Oct. 11, 1972127460112700LA5785186795115411118256875183942722475532000000006000NOct. 1, 1972nullnull
014300500null283721028300LA000079227110399612249213499194589060382152336342208215148316300NMay 1, 2008nullnull
014462333Dec. 7, 19641771085617700LA162649424516115128746772693837194432100600301704392309520248725366776744390556000NDec. 1, 1964nullnull
014462666Oct. 4, 19781771155817700LA6503465647840854704749424976952562281612728000000006000NOct. 1, 1978nullnull
014668500Sept. 14, 1987127371412700LA000017302130189769958321053000000006000NSept. 1, 1987nullnull
014680700Nov. 2, 1984311578231100LA0000251856159550017344346277000000006000NNov. 1, 1984nullnull
014681700Oct. 5, 1985311577931100LA0000256163162618015818831623000000006000NOct. 1, 1985nullnull
014900500Sept. 18, 2008163579616300LA0000295068157742045707122376000000006000NSept. 1, 2008Dec. 11, 2008null
015066001null33163033100LA4050000000000000006000Nnullnullnull
015122750Jan. 24, 2013311247431100LA0000248823147794416569610580632395455520258143055814311294454525006400NJan. 24, 2013Jan. 24, 2013null
015123444Jan. 16, 1976311311431100LA1764233774268184016060000000000006100NJan. 1, 1976nullnull
015440500Aug. 11, 1984507245150700LA0000267221910896014548000000006000NAug. 1, 1984nullnull
015440520Aug. 11, 1984507256250700LA00006431499284377118796000000006000NAug. 1, 1984nullnull
015599500July 1, 1964323104932300LA255460582015056230296924160108881000000006110NJuly 1, 1964nullN
015743500Jan. 5, 19832917702900LA000047452888068711000000006000NJan. 1, 1983nullnull
015835700Oct. 4, 1982331289833100LA44234450106803170226803394000000006000NOct. 1, 1982nullnull
016011500Jan. 26, 19572124962100LA42360000000000000006000NJan. 1, 1957nullnull
016053001Sept. 4, 19322122002100LA7534763946620516474659007074766020503609234391503260240120010206000NSept. 1, 1932nullnull
016053500April 3, 19632122342100LA361183647012618487542862670146658222104106941552238211348831221040811186070841306310NApril 1, 1963nullnull
016096250Sept. 1, 1971507313250700LA744868868641140585707457761372368363320385133000000006100NSept. 1, 1971nullnull
016101100Feb. 2, 1981507499750700LA4915592609007036960033733185875702173932705973002715603092018106733248706000NFeb. 1, 1981nullnull
016101500Dec. 8, 1959507440050700LA2154951307012939641388828204509391177811073216092000000006000NDec. 1, 1959nullnull
016101520Feb. 25, 1981507439050700LA36099872564764304800242273333771218618916813365013578068309053366612106000NFeb. 1, 1981nullnull
016105700April 4, 1976507336050700LA782771597791426422444656130805420090883931202485000000006000NApril 1, 1976nullnull
016105750Jan. 30, 1978507330350700LA1975215041424730287520915129263247495301000000006000NJan. 1, 1978nullnull
016469001Sept. 1, 1947325220932500LA238864156469844521162642951054379142803413362774754951124184826580905897763506310NSept. 1, 1947nullN
016483550Aug. 2, 1982507268450700LA1343993145200000000000006000NAug. 1, 1982nullnull
016582500June 2, 1977177624417700LA574036583584649866034620757822295321041252706324120106405438036419906000NJune 1, 1977nullnull
016727001null5520955500LA3915651315227561900000000000006110NnullnullY
016973500April 20, 1968177188317700LA8248148156205681635608288022915000000006000NApril 1, 1968nullnull
017137500Feb. 23, 1969557945500LA00000000000000006000NFeb. 1, 1969nullnull
017210500null1318531300LA000043566446883520000000006000NFeb. 28, 2010nullnull
017220500Dec. 28, 19801320491300LA433149510432199680864821310975330036140655641043620510144811294441106100NDec. 1, 1980nullnull
017670001June 12, 1949491111549100LA2395015819723563942310692009322429159000000006010NJune 1, 1949nullnull
017850001Feb. 2, 1949163328016300LA27833155574176810339959650188241243514960818697175641243745308355813353856853514919292849152223006210NFeb. 1, 1949nullnull
017850200Nov. 22, 19761351261300LA75591648096000000000000006000NNov. 1, 1976nullnull
017850250July 19, 2019163402816300LA000064023283801120000000006100NJuly 19, 2019July 19, 2019null
017850666June 17, 1953163350416300LA12644422216032395232195351695635336899161027288489337136951575682231026164620868306000NJune 1, 1953nullnull
018001260null311886631100LA0000410331595212119672256000000006220NSept. 1, 1999Dec. 20, 1999Y
018001600Nov. 23, 1981311510231100LA21733109563655125392012139520966528282762254000000006100NNov. 1, 1981nullnull
018001650Aug. 31, 1983311562431100LA00001172526258448576749000000006000NAug. 1, 1983nullnull
018001700Jan. 24, 1983311555631100LA000018918912420301612130604019856000000006000NJan. 1, 1983nullnull
018034500June 10, 19852127162100LA00007755463201481611000000006000NJune 1, 1985nullnull
018069100Dec. 9, 1976127695012700LA3788112695525741051480000000000006220NDec. 1, 1976nullY
018072250Aug. 21, 1958127424912700LA26994114068419957674189800240979000000006000NAug. 1, 1958nullnull
018072500April 18, 1970127542512700LB40299103927696904738742113489428425020990741232081971963626992189511312632704054483871892434970843410397316500NApril 1, 1970nullnull
018072750March 26, 1971127575412700LB4729080446325763513267393597428130461280411402009754707901114331635013703761285921706000NMarch 1, 1971nullnull
018073500April 15, 1987127561012700LA00001421830132053128000000006000NApril 1, 1987nullnull
018075333June 17, 1970507470850700LA8241702018396000000000000006000NJune 1, 1970nullnull
018075666April 18, 1969507543550700LA13403071504043165774243776410000000000006110NApril 1, 1969nullY
018159325Sept. 3, 19851346201300LA00003139213685504189187000000006000NSept. 1, 1985nullnull
018159500Feb. 20, 19541354241300LA789820000000000000006000NFeb. 1, 1954nullnull
018240500Dec. 13, 194813754013700LA0000157565200000000006100NDec. 1, 1948nullnull
018527400July 29, 19751362201300LA57561968667820000000000006000NJuly 1, 1975nullnull
018527500April 27, 19751363841300LA847913451027314421380000000000006000NApril 1, 1975nullnull
018527600Dec. 20, 19761370821300LA73772255727654727664482047876044809000000006000NDec. 1, 1976nullnull
018532400Sept. 1, 19771372281300LA157305490562794771200000000000006000NSept. 1, 1977nullnull
018539500May 31, 1982323172032300LA5828860172001478010266324362219000000006000NMay 1, 1982nullnull
018575800Nov. 18, 19831356241300LA0000431414131002451725166000000006000NNov. 1, 1983nullnull
018713499Sept. 14, 1979127454612700LA821421067141342231016500525454100642303045639384202190686201541505431701415576100NSept. 1, 1979nullnull
018713550Jan. 23, 1986127449212700LA0000112100288287224834195587146027156030036267332606000NJan. 1, 1986nullnull
018713600Oct. 1, 1981127458012700LA3748606215772678905594277698210882578000000006000NOct. 1, 1981nullnull
018749666May 30, 1959127195112700LA67205670797364134852231647876859624514000000006000NMay 1, 1959nullnull
018859100Aug. 3, 1981177730017700LA13948139881161600000000000006000NAug. 1, 1981nullnull
019895450Nov. 1, 2005311641431100LA00002514063128666760000000006000NNov. 1, 2005July 14, 2006null
0110003333Oct. 16, 19541320991300LA252340000000000000006000NOct. 1, 1954nullnull
0110003666Oct. 8, 19621320961300LA11194515643843128677826413176190014658141000000006000NOct. 1, 1962nullnull
0110035001null5520955500LA488590000000000000006000Nnullnullnull

What is in each column

Sampled, not exhaustive — enough to tell whether this is the data you want without making the database read tens of millions of rows.

district_no

varchar

Sampled
33.9K
Distinct
13
  • 04 5.8K
  • 03 4.8K
  • 08 4.8K
  • 13 3.9K
  • 02 3.3K
  • 10 3.1K
  • 09 2.5K
  • 11 1.9K
  • 06 1.5K
  • 01 1.4K
  • 14 740
  • 05 366

field_no

int4

Sampled
33.9K
Distinct
33.9K
  • 21023001 1
  • 68227001 1
  • 98085650 1
  • 4640500 1
  • 88733225 1
  • 79002100 1
  • 51152660 1
  • 95122050 1
  • 37167300 1
  • 67623001 1
  • 75961750 1
  • 78459750 1

disc_date

date

Sampled
33.9K
Distinct
15.4K
Empty
0.0614
  • Nov. 1, 1963 35
  • Aug. 1, 1967 35
  • Jan. 1, 1977 24
  • Oct. 1, 1950 21
  • Aug. 11, 2004 20
  • June 7, 1949 18
  • Dec. 10, 1941 16
  • Jan. 1, 1984 16
  • Feb. 1, 1980 16
  • April 1, 1980 15
  • May 1, 1981 15
  • Nov. 24, 1981 15

disc_county_code

int2

Sampled
33.9K
Distinct
222
  • 355 1.1K
  • 239 712
  • 399 709
  • 427 699
  • 409 664
  • 273 636
  • 503 634
  • 237 580
  • 131 579
  • 469 537
  • 391 535
  • 71 515

depth_1st_well

int4

Sampled
33.9K
Distinct
9.7K
  • 0 53
  • 5500 32
  • 4300 31
  • 5400 31
  • 4800 29
  • 4400 28
  • 5900 27
  • 4600 26
  • 5800 26
  • 4500 25
  • 4000 25
  • 3200 24

testing_county

int2

Sampled
33.9K
Distinct
221
  • 355 1.1K
  • 239 712
  • 399 708
  • 427 699
  • 409 664
  • 273 638
  • 503 633
  • 131 582
  • 237 579
  • 469 545
  • 391 527
  • 71 515

first_alter_test_month

int2

Sampled
33.9K
Distinct
13
  • 0 32.9K
  • 7 165
  • 11 140
  • 1 120
  • 3 96
  • 2 88
  • 12 84
  • 9 83
  • 6 76
  • 10 74
  • 8 45
  • 4 42

second_alter_test_month

int2

Sampled
33.9K
Distinct
13
  • 0 32.9K
  • 1 165
  • 5 141
  • 7 120
  • 9 96
  • 8 88
  • 6 84
  • 3 83
  • 12 75
  • 4 74
  • 2 45
  • 10 42

Take it away

Back to everything we know about Field Oil Information