Data Explorer
Query the US Nationwide Parcel Dataset
$1.75 / 1,000 records$100 minimum
39/80
Live SQL
SELECT * FROM "lr_parcel_us" WHERE statefp = '40' AND countyfp = '087'
27,129 matching parcels
Data Preview
parcelid | taxacctnum | statefp | countyfp | parceladdr | parcelcity | parcelstate | parcelzip | ownername | owneraddr | ownercity | ownerstate | ownerzip | countyname | cousubfp | cousubname | tractce | tractname | calcarea | imprvalue | landvalue | agvalue | totalvalue | saleamt | saledate | numbldgs | numunits | yearbuilt | numfloors | bldgsqft | bedrooms | halfbaths | fullbaths | firmid | firmdate | fldzone | zonesubty | staticbfe | elevmin | elevmax | elevavg | usecode | usedesc | zoningcode | zoningdesc | taxacres | ownertype | naicscode | legaldesc | township | section | qtrsection | range | plssdesc | book | page | parceltype | accesstype | iucnclass | placename | placetype | fireplaces | heating | heatfuel | cooling | foundation | roofcover | siding | lrversion | taxyear | taxdistrict | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 390288 | R0102876 | 40 | 087 | OK | NFL LLC | MCCLAIN | 92626 | PURCELL | 400204 | 4002.0400 | 268011.0896 | 40087C | 2025-12-17 | AE | FLOODWAY | 66.2000 | BUSINESS | 11111 | BOB MOORE FARMS | FARM | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||||||||||
| 380921 | R0078249 | 40 | 087 | OK | GENERAL MATERIALS INC | MCCLAIN | 91946 | NEWCASTLE-BLANCHARD | 400106 | 4001.0600 | 2489464.2767 | 40087C | 2025-12-17 | X | AREA OF MINIMAL FLOOD HAZARD | 12.6600 | BUSINESS | 7225 | LUIGI'S IN NEWCASTLE | RESTAURANT | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||||||||||
| 1061005 | 440007153 | 40 | 087 | OK | NFL LLC | MCCLAIN | 92626 | PURCELL | 400204 | 4002.0400 | 1525874.4192 | 40087C | 2025-12-17 | AE | 14.4300 | BUSINESS | 11111 | BOB MOORE FARMS | FARM | 2026.2 | |||||||||||||||||||||||||||||||||||||||||||||||||||
| 1061012 | 440007161 | 40 | 087 | OK | HAWKINS RANDALL PAUL REVOCABLE … | MCCLAIN | 92626 | PURCELL | 400204 | 4002.0400 | 40391.9919 | 40087C | 2025-12-17 | AE | 9.8900 | TRUST | 6216 | HAWKINS PEST CONTROL | HOME_SERVICE | 2026.2 | |||||||||||||||||||||||||||||||||||||||||||||||||||
| 1052820 | 440000018 | 40 | 087 | OK | LONROS RANCH LLC | MCCLAIN | 90929 | EAST MCCLAIN | 400400 | 4004 | 1883122.3512 | 40087C | 2025-12-17 | A | 467.7500 | BUSINESS | TRAIN WRECK DUCK CLUB | SPORT_OR_FITNESS_FACILITY | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1061275 | 440007388 | 40 | 087 | OK | OKLAHOMA MOTORSPORTS COMPLEX I | MCCLAIN | 92626 | PURCELL | 400204 | 4002.0400 | 282739.0714 | 40087C | 2025-12-17 | AE | 70.4400 | PERSON | CHAMPION RACING | SPORT_OR_RECREATION_CLUB | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1061298 | 440007411 | 40 | 087 | OK | D OWEN PROPERTIES LLC C/O DERIC… | MCCLAIN | 92626 | PURCELL | 400204 | 4002.0400 | 39862.7036 | 40087C | 2025-12-17 | AE | 11.4600 | BUSINESS | D.OWEN CONSTRUCTION | BUILDING_OR_CONSTRUCTION_SERVICE | 2026.2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 377774 | R0075101 | 40 | 087 | OK | GREEN DAVID & BARBARA-TRUST GR… | MCCLAIN | 91946 | NEWCASTLE-BLANCHARD | 400106 | 4001.0600 | 319201.6571 | 40027C | 2025-12-17 | AE | FLOODWAY | 80 | TRUST | 2026.2 | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| 377520 | R0074847 | 40 | 087 | OK | BARBER ROSA C/O DELORES ALLIS… | MCCLAIN | 92626 | PURCELL | 400300 | 4003 | 166292.0141 | 40027C | 2025-12-17 | AE | FLOODWAY | 14 | PERSON | 2026.2 | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| 372583 | R0069910 | 40 | 087 | OK | BRADSHAW DAVID 1/2 INT | MCCLAIN | 92626 | PURCELL | 400204 | 4002.0400 | 321133.8678 | 40087C | 2025-12-17 | AE | FLOODWAY | 62.8900 | PERSON | 2026.2 | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1060913 | 440007076 | 40 | 087 | OK | CARGILL & ALBRECHT ET AL | MCCLAIN | 92626 | PURCELL | 400204 | 4002.0400 | 328899.7317 | 40087C | 2025-12-17 | AE | FLOODWAY | 69.5500 | PERSON | 2026.2 | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| 377035 | R0074362 | 40 | 087 | OK | INTERVEST DEVELOPMENT LTD PRTSHP | MCCLAIN | 92626 | PURCELL | 400300 | 4003 | 329641.6042 | 40087C | 2025-12-17 | AE | FLOODWAY | 64 | BUSINESS | 2026.2 | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| 380772 | R0078100 | 40 | 087 | OK | NATIVE DOODLES INC | MCCLAIN | 91946 | NEWCASTLE-BLANCHARD | 400106 | 4001.0600 | 630210.8809 | 40027C | 2025-12-17 | AE | FLOODWAY | 160 | BUSINESS | 2026.2 | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1061307 | 440007419 | 40 | 087 | OK | TARVER JACK E | MCCLAIN | 92626 | PURCELL | 400204 | 4002.0400 | 279452.7395 | 40087C | 2025-12-17 | AE | FLOODWAY | 49.7000 | PERSON | 2026.2 | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1055559 | 440002580 | 40 | 087 | OK | MAYNARD GARY D & DONNA K | MCCLAIN | 92626 | PURCELL | 400201 | 4002.0100 | 611895.6350 | 40087C | 2025-12-17 | X | AREA OF MINIMAL FLOOD HAZARD | 150 | PERSON | 2026.2 | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| 393769 | R0118241 | 40 | 087 | OK | TARP KAIREN D-LIFE EST | MCCLAIN | 92626 | PURCELL | 400300 | 4003 | 642596.9742 | 40087C | 2025-12-17 | AE | FLOODWAY | 111.9000 | PERSON | 2026.2 | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1060920 | 440007080 | 40 | 087 | OK | LEFLORE LOUIS C | MCCLAIN | 92626 | PURCELL | 400204 | 4002.0400 | 278423.3089 | 40087C | 2025-12-17 | AE | FLOODWAY | 68.5000 | PERSON | 2026.2 | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1060900 | 440007064 | 40 | 087 | OK | LEFLORE LAWRENCE C | MCCLAIN | 92626 | PURCELL | 400204 | 4002.0400 | 330155.2510 | 40087C | 2025-12-17 | AE | FLOODWAY | 80 | PERSON | 2026.2 | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| 371498 | R0068825 | 40 | 087 | OK | NFL LLC | MCCLAIN | 92626 | PURCELL | 400204 | 4002.0400 | 651809.7163 | 40087C | 2025-12-17 | AE | FLOODWAY | 180.3500 | BUSINESS | 2026.2 | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1058670 | 440005222 | 40 | 087 | OK | TAYLOR RICHARD DONALD III | MCCLAIN | 92626 | PURCELL | 400300 | 4003 | 103396.4106 | 40087C | 2025-12-17 | AE | FLOODWAY | 22.3100 | PERSON | 2026.2 | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| 371434 | R0068761 | 40 | 087 | OK | UNIVERSITY OF OKLAHOMA | MCCLAIN | 91946 | NEWCASTLE-BLANCHARD | 400106 | 4001.0600 | 622292.6855 | 40087C | 2025-12-17 | AE | FLOODWAY | 20.7500 | PERSON | 2026.2 | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1063359 | 440030467 | 40 | 087 | OK | NCLP LLC | MCCLAIN | 91946 | NEWCASTLE-BLANCHARD | 400106 | 4001.0600 | 190695.4818 | 40087C | 2025-12-17 | AE | FLOODWAY | 213.3000 | BUSINESS | 2026.2 | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1064739 | 440010457 | 40 | 087 | OK | PACIFIC ENTERPRISES ABC CO C/O … | MCCLAIN | 91946 | NEWCASTLE-BLANCHARD | 400106 | 4001.0600 | 219436.0422 | 40027C | 2025-12-17 | AE | FLOODWAY | 28.2300 | BUSINESS | 2026.2 | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| 387492 | R0097694 | 40 | 087 | OK | INTERVEST DEVELOPMENT LTD PRTSHP | MCCLAIN | 92626 | PURCELL | 400300 | 4003 | 1489533.9123 | 40027C | 2025-12-17 | AE | FLOODWAY | 360.6700 | BUSINESS | 2026.2 | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1060914 | 440031783 | 40 | 087 | OK | INGLE TREVOR & JENNIFER | MCCLAIN | 92626 | PURCELL | 400204 | 4002.0400 | 669303.6540 | 40087C | 2025-12-17 | AE | FLOODWAY | 157.9199 | PERSON | 2026.2 |