← Back to the library

OWPO Apr 2026 xlsx dataset characterization (local parse)

Record
p11-federal-rec-05-r3
State
US-FEDERAL
Category
wells · dataset_characterization
Status
observed
Period
2026
Quality
Candidate
Review state
Pending review
Native ID
owpo-xlsx-apr2026

Fields

columns
8
data rows
11422
distinct recipients
32
null recipient rows
0
read me count
11,409 wells through January 31, 2026
sparse rows
207
top funding type
State Program; Initial Grant 9972
top recipient
Kansas 2569

Evidence

  1. data rows: 11422
    https://www.doi.gov/sites/default/files/data/owpopluggedwellsapr2026.xlsx · xlsx Well Data sheet: 11423 rows incl header · source p11-federal-r3-src-02 · visit p11-federal-r3-visit-02
  2. columns: 8
    https://www.doi.gov/sites/default/files/data/owpopluggedwellsapr2026.xlsx · xlsx Well Data header row · source p11-federal-r3-src-02 · visit p11-federal-r3-visit-02
  3. distinct recipients: 32
    https://www.doi.gov/sites/default/files/data/owpopluggedwellsapr2026.xlsx · xlsx Well Data col C distribution (openpyxl) · source p11-federal-r3-src-02 · visit p11-federal-r3-visit-02
  4. top recipient: Kansas 2569
    https://www.doi.gov/sites/default/files/data/owpopluggedwellsapr2026.xlsx · xlsx Well Data col C distribution (openpyxl) · source p11-federal-r3-src-02 · visit p11-federal-r3-visit-02
  5. read me count: 11,409 wells through January 31, 2026
    https://www.doi.gov/sites/default/files/data/owpopluggedwellsapr2026.xlsx · xlsx Read Me sheet, row 2 · source p11-federal-r3-src-02 · visit p11-federal-r3-visit-02
  6. sparse rows: 207
    https://www.doi.gov/sites/default/files/data/owpopluggedwellsapr2026.xlsx · xlsx Well Data scan: rows with any empty cell · source p11-federal-r3-src-02 · visit p11-federal-r3-visit-02
  7. null recipient rows: 0
    https://www.doi.gov/sites/default/files/data/owpopluggedwellsapr2026.xlsx · xlsx Well Data col C null count (stdlib XML recompute: 0; the 13 nulls are col A Well_ID) · source p11-federal-r3-src-02 · visit p11-federal-r3-visit-02
  8. top funding type: State Program; Initial Grant 9972
    https://www.doi.gov/sites/default/files/data/owpopluggedwellsapr2026.xlsx · xlsx Well Data col H distribution (raw shared string 'State Program; Initial Grant', 2 spaces) · source p11-federal-r3-src-02 · visit p11-federal-r3-visit-02

Provenance

Collected 2026-10-04 by agent p11-federal. Still missing: recipient name normalization.