ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

782 rows where county = "Pontotoc" and state = "Oklahoma" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

  • Oklahoma · 782 ✖

fips 1

county 1

  • Pontotoc · 782 ✖
Link rowid date ▲ county state fips cases deaths
2501794 2501794 2022-05-13 Pontotoc Oklahoma 40123 12132 150
2498536 2498536 2022-05-12 Pontotoc Oklahoma 40123 12132 150
2495278 2495278 2022-05-11 Pontotoc Oklahoma 40123 12121 149
2492020 2492020 2022-05-10 Pontotoc Oklahoma 40123 12121 149
2488762 2488762 2022-05-09 Pontotoc Oklahoma 40123 12121 149
2485505 2485505 2022-05-08 Pontotoc Oklahoma 40123 12121 149
2482247 2482247 2022-05-07 Pontotoc Oklahoma 40123 12121 149
2478989 2478989 2022-05-06 Pontotoc Oklahoma 40123 12121 149
2475731 2475731 2022-05-05 Pontotoc Oklahoma 40123 12121 149
2472474 2472474 2022-05-04 Pontotoc Oklahoma 40123 12092 147
2469218 2469218 2022-05-03 Pontotoc Oklahoma 40123 12092 147
2465962 2465962 2022-05-02 Pontotoc Oklahoma 40123 12092 147
2462707 2462707 2022-05-01 Pontotoc Oklahoma 40123 12092 147
2459451 2459451 2022-04-30 Pontotoc Oklahoma 40123 12092 147
2456195 2456195 2022-04-29 Pontotoc Oklahoma 40123 12092 147
2452939 2452939 2022-04-28 Pontotoc Oklahoma 40123 12092 147
2449683 2449683 2022-04-27 Pontotoc Oklahoma 40123 12076 145
2446426 2446426 2022-04-26 Pontotoc Oklahoma 40123 12076 145
2443171 2443171 2022-04-25 Pontotoc Oklahoma 40123 12076 145
2439915 2439915 2022-04-24 Pontotoc Oklahoma 40123 12076 145
2436659 2436659 2022-04-23 Pontotoc Oklahoma 40123 12076 145
2433403 2433403 2022-04-22 Pontotoc Oklahoma 40123 12076 145
2430147 2430147 2022-04-21 Pontotoc Oklahoma 40123 12076 145
2426891 2426891 2022-04-20 Pontotoc Oklahoma 40123 12066 145
2423635 2423635 2022-04-19 Pontotoc Oklahoma 40123 12066 145
2420378 2420378 2022-04-18 Pontotoc Oklahoma 40123 12066 145
2417123 2417123 2022-04-17 Pontotoc Oklahoma 40123 12066 145
2413867 2413867 2022-04-16 Pontotoc Oklahoma 40123 12066 145
2410611 2410611 2022-04-15 Pontotoc Oklahoma 40123 12066 145
2407355 2407355 2022-04-14 Pontotoc Oklahoma 40123 12066 145
2404099 2404099 2022-04-13 Pontotoc Oklahoma 40123 12032 144
2400844 2400844 2022-04-12 Pontotoc Oklahoma 40123 12032 144
2397589 2397589 2022-04-11 Pontotoc Oklahoma 40123 12032 144
2394334 2394334 2022-04-10 Pontotoc Oklahoma 40123 12032 144
2391078 2391078 2022-04-09 Pontotoc Oklahoma 40123 12032 144
2387822 2387822 2022-04-08 Pontotoc Oklahoma 40123 12032 144
2384567 2384567 2022-04-07 Pontotoc Oklahoma 40123 12032 144
2381312 2381312 2022-04-06 Pontotoc Oklahoma 40123 11990 142
2378057 2378057 2022-04-05 Pontotoc Oklahoma 40123 11990 142
2374803 2374803 2022-04-04 Pontotoc Oklahoma 40123 11990 142
2371551 2371551 2022-04-03 Pontotoc Oklahoma 40123 11990 142
2368298 2368298 2022-04-02 Pontotoc Oklahoma 40123 11990 142
2365045 2365045 2022-04-01 Pontotoc Oklahoma 40123 11990 142
2361792 2361792 2022-03-31 Pontotoc Oklahoma 40123 11990 142
2358538 2358538 2022-03-30 Pontotoc Oklahoma 40123 11981 138
2355284 2355284 2022-03-29 Pontotoc Oklahoma 40123 11981 138
2352031 2352031 2022-03-28 Pontotoc Oklahoma 40123 11981 138
2348779 2348779 2022-03-27 Pontotoc Oklahoma 40123 11981 138
2345526 2345526 2022-03-26 Pontotoc Oklahoma 40123 11981 138
2342273 2342273 2022-03-25 Pontotoc Oklahoma 40123 11981 138
2339020 2339020 2022-03-24 Pontotoc Oklahoma 40123 11981 138
2335766 2335766 2022-03-23 Pontotoc Oklahoma 40123 11978 135
2332512 2332512 2022-03-22 Pontotoc Oklahoma 40123 11978 135
2329259 2329259 2022-03-21 Pontotoc Oklahoma 40123 11978 135
2326007 2326007 2022-03-20 Pontotoc Oklahoma 40123 11978 135
2322754 2322754 2022-03-19 Pontotoc Oklahoma 40123 11978 135
2319500 2319500 2022-03-18 Pontotoc Oklahoma 40123 11978 135
2316246 2316246 2022-03-17 Pontotoc Oklahoma 40123 11978 135
2312993 2312993 2022-03-16 Pontotoc Oklahoma 40123 11934 131
2309740 2309740 2022-03-15 Pontotoc Oklahoma 40123 11934 131
2306487 2306487 2022-03-14 Pontotoc Oklahoma 40123 11934 131
2303236 2303236 2022-03-13 Pontotoc Oklahoma 40123 11934 131
2299984 2299984 2022-03-12 Pontotoc Oklahoma 40123 11934 131
2296732 2296732 2022-03-11 Pontotoc Oklahoma 40123 11934 131
2293480 2293480 2022-03-10 Pontotoc Oklahoma 40123 11934 131
2290228 2290228 2022-03-09 Pontotoc Oklahoma 40123 11857 125
2286976 2286976 2022-03-08 Pontotoc Oklahoma 40123 11857 125
2283724 2283724 2022-03-07 Pontotoc Oklahoma 40123 11857 125
2280472 2280472 2022-03-06 Pontotoc Oklahoma 40123 11857 125
2277219 2277219 2022-03-05 Pontotoc Oklahoma 40123 11857 125
2273966 2273966 2022-03-04 Pontotoc Oklahoma 40123 11857 125
2270713 2270713 2022-03-03 Pontotoc Oklahoma 40123 11857 125
2267461 2267461 2022-03-02 Pontotoc Oklahoma 40123 11857 125
2264208 2264208 2022-03-01 Pontotoc Oklahoma 40123 11787 120
2260958 2260958 2022-02-28 Pontotoc Oklahoma 40123 11787 120
2257707 2257707 2022-02-27 Pontotoc Oklahoma 40123 11787 120
2254456 2254456 2022-02-26 Pontotoc Oklahoma 40123 11787 120
2251205 2251205 2022-02-25 Pontotoc Oklahoma 40123 11787 120
2247954 2247954 2022-02-24 Pontotoc Oklahoma 40123 11787 120
2244703 2244703 2022-02-23 Pontotoc Oklahoma 40123 11787 120
2241452 2241452 2022-02-22 Pontotoc Oklahoma 40123 11659 119
2238201 2238201 2022-02-21 Pontotoc Oklahoma 40123 11659 119
2234950 2234950 2022-02-20 Pontotoc Oklahoma 40123 11659 119
2231699 2231699 2022-02-19 Pontotoc Oklahoma 40123 11659 119
2228448 2228448 2022-02-18 Pontotoc Oklahoma 40123 11659 119
2225197 2225197 2022-02-17 Pontotoc Oklahoma 40123 11659 119
2221946 2221946 2022-02-16 Pontotoc Oklahoma 40123 11659 119
2218695 2218695 2022-02-15 Pontotoc Oklahoma 40123 11464 116
2215444 2215444 2022-02-14 Pontotoc Oklahoma 40123 11464 116
2212193 2212193 2022-02-13 Pontotoc Oklahoma 40123 11464 116
2208940 2208940 2022-02-12 Pontotoc Oklahoma 40123 11464 116
2205687 2205687 2022-02-11 Pontotoc Oklahoma 40123 11464 116
2202434 2202434 2022-02-10 Pontotoc Oklahoma 40123 11464 116
2199180 2199180 2022-02-09 Pontotoc Oklahoma 40123 11464 116
2195926 2195926 2022-02-08 Pontotoc Oklahoma 40123 11137 112
2192672 2192672 2022-02-07 Pontotoc Oklahoma 40123 11137 112
2189418 2189418 2022-02-06 Pontotoc Oklahoma 40123 11137 112
2186165 2186165 2022-02-05 Pontotoc Oklahoma 40123 11137 112
2182913 2182913 2022-02-04 Pontotoc Oklahoma 40123 11137 112
2179661 2179661 2022-02-03 Pontotoc Oklahoma 40123 11137 112

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
CREATE INDEX [idx_ny_times_us_counties_state]
    ON [ny_times_us_counties] ([state]);
CREATE INDEX [idx_ny_times_us_counties_county]
    ON [ny_times_us_counties] ([county]);
CREATE INDEX [idx_ny_times_us_counties_fips]
    ON [ny_times_us_counties] ([fips]);
CREATE INDEX [idx_ny_times_us_counties_date]
    ON [ny_times_us_counties] ([date] desc);