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

757 rows where county = "McIntosh" and fips = 40091 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

fips 1

  • 40091 · 757 ✖

county 1

  • McIntosh · 757 ✖
Link rowid date ▲ county state fips cases deaths
2501781 2501781 2022-05-13 McIntosh Oklahoma 40091 4864 124
2498523 2498523 2022-05-12 McIntosh Oklahoma 40091 4864 124
2495265 2495265 2022-05-11 McIntosh Oklahoma 40091 4862 124
2492007 2492007 2022-05-10 McIntosh Oklahoma 40091 4862 124
2488749 2488749 2022-05-09 McIntosh Oklahoma 40091 4862 124
2485492 2485492 2022-05-08 McIntosh Oklahoma 40091 4862 124
2482234 2482234 2022-05-07 McIntosh Oklahoma 40091 4862 124
2478976 2478976 2022-05-06 McIntosh Oklahoma 40091 4862 124
2475718 2475718 2022-05-05 McIntosh Oklahoma 40091 4862 124
2472461 2472461 2022-05-04 McIntosh Oklahoma 40091 4860 124
2469205 2469205 2022-05-03 McIntosh Oklahoma 40091 4860 124
2465949 2465949 2022-05-02 McIntosh Oklahoma 40091 4860 124
2462694 2462694 2022-05-01 McIntosh Oklahoma 40091 4860 124
2459438 2459438 2022-04-30 McIntosh Oklahoma 40091 4860 124
2456182 2456182 2022-04-29 McIntosh Oklahoma 40091 4860 124
2452926 2452926 2022-04-28 McIntosh Oklahoma 40091 4860 124
2449670 2449670 2022-04-27 McIntosh Oklahoma 40091 4866 124
2446413 2446413 2022-04-26 McIntosh Oklahoma 40091 4866 124
2443158 2443158 2022-04-25 McIntosh Oklahoma 40091 4866 124
2439902 2439902 2022-04-24 McIntosh Oklahoma 40091 4866 124
2436646 2436646 2022-04-23 McIntosh Oklahoma 40091 4866 124
2433390 2433390 2022-04-22 McIntosh Oklahoma 40091 4866 124
2430134 2430134 2022-04-21 McIntosh Oklahoma 40091 4866 124
2426878 2426878 2022-04-20 McIntosh Oklahoma 40091 4868 124
2423622 2423622 2022-04-19 McIntosh Oklahoma 40091 4868 124
2420365 2420365 2022-04-18 McIntosh Oklahoma 40091 4868 124
2417110 2417110 2022-04-17 McIntosh Oklahoma 40091 4868 124
2413854 2413854 2022-04-16 McIntosh Oklahoma 40091 4868 124
2410598 2410598 2022-04-15 McIntosh Oklahoma 40091 4868 124
2407342 2407342 2022-04-14 McIntosh Oklahoma 40091 4868 124
2404086 2404086 2022-04-13 McIntosh Oklahoma 40091 4877 124
2400831 2400831 2022-04-12 McIntosh Oklahoma 40091 4877 124
2397576 2397576 2022-04-11 McIntosh Oklahoma 40091 4877 124
2394321 2394321 2022-04-10 McIntosh Oklahoma 40091 4877 124
2391065 2391065 2022-04-09 McIntosh Oklahoma 40091 4877 124
2387809 2387809 2022-04-08 McIntosh Oklahoma 40091 4877 124
2384554 2384554 2022-04-07 McIntosh Oklahoma 40091 4877 124
2381299 2381299 2022-04-06 McIntosh Oklahoma 40091 4885 123
2378044 2378044 2022-04-05 McIntosh Oklahoma 40091 4885 123
2374790 2374790 2022-04-04 McIntosh Oklahoma 40091 4885 123
2371538 2371538 2022-04-03 McIntosh Oklahoma 40091 4885 123
2368285 2368285 2022-04-02 McIntosh Oklahoma 40091 4885 123
2365032 2365032 2022-04-01 McIntosh Oklahoma 40091 4885 123
2361779 2361779 2022-03-31 McIntosh Oklahoma 40091 4885 123
2358525 2358525 2022-03-30 McIntosh Oklahoma 40091 4895 122
2355271 2355271 2022-03-29 McIntosh Oklahoma 40091 4895 122
2352018 2352018 2022-03-28 McIntosh Oklahoma 40091 4895 122
2348766 2348766 2022-03-27 McIntosh Oklahoma 40091 4895 122
2345513 2345513 2022-03-26 McIntosh Oklahoma 40091 4895 122
2342260 2342260 2022-03-25 McIntosh Oklahoma 40091 4895 122
2339007 2339007 2022-03-24 McIntosh Oklahoma 40091 4895 122
2335753 2335753 2022-03-23 McIntosh Oklahoma 40091 4888 120
2332499 2332499 2022-03-22 McIntosh Oklahoma 40091 4888 120
2329246 2329246 2022-03-21 McIntosh Oklahoma 40091 4888 120
2325994 2325994 2022-03-20 McIntosh Oklahoma 40091 4888 120
2322741 2322741 2022-03-19 McIntosh Oklahoma 40091 4888 120
2319487 2319487 2022-03-18 McIntosh Oklahoma 40091 4888 120
2316233 2316233 2022-03-17 McIntosh Oklahoma 40091 4888 120
2312980 2312980 2022-03-16 McIntosh Oklahoma 40091 4885 118
2309727 2309727 2022-03-15 McIntosh Oklahoma 40091 4885 118
2306474 2306474 2022-03-14 McIntosh Oklahoma 40091 4885 118
2303223 2303223 2022-03-13 McIntosh Oklahoma 40091 4885 118
2299971 2299971 2022-03-12 McIntosh Oklahoma 40091 4885 118
2296719 2296719 2022-03-11 McIntosh Oklahoma 40091 4885 118
2293467 2293467 2022-03-10 McIntosh Oklahoma 40091 4885 118
2290215 2290215 2022-03-09 McIntosh Oklahoma 40091 4879 118
2286963 2286963 2022-03-08 McIntosh Oklahoma 40091 4879 118
2283711 2283711 2022-03-07 McIntosh Oklahoma 40091 4879 118
2280459 2280459 2022-03-06 McIntosh Oklahoma 40091 4879 118
2277206 2277206 2022-03-05 McIntosh Oklahoma 40091 4879 118
2273953 2273953 2022-03-04 McIntosh Oklahoma 40091 4879 118
2270700 2270700 2022-03-03 McIntosh Oklahoma 40091 4879 118
2267448 2267448 2022-03-02 McIntosh Oklahoma 40091 4879 118
2264195 2264195 2022-03-01 McIntosh Oklahoma 40091 4865 114
2260945 2260945 2022-02-28 McIntosh Oklahoma 40091 4865 114
2257694 2257694 2022-02-27 McIntosh Oklahoma 40091 4865 114
2254443 2254443 2022-02-26 McIntosh Oklahoma 40091 4865 114
2251192 2251192 2022-02-25 McIntosh Oklahoma 40091 4865 114
2247941 2247941 2022-02-24 McIntosh Oklahoma 40091 4865 114
2244690 2244690 2022-02-23 McIntosh Oklahoma 40091 4865 114
2241439 2241439 2022-02-22 McIntosh Oklahoma 40091 4854 114
2238188 2238188 2022-02-21 McIntosh Oklahoma 40091 4854 114
2234937 2234937 2022-02-20 McIntosh Oklahoma 40091 4854 114
2231686 2231686 2022-02-19 McIntosh Oklahoma 40091 4854 114
2228435 2228435 2022-02-18 McIntosh Oklahoma 40091 4854 114
2225184 2225184 2022-02-17 McIntosh Oklahoma 40091 4854 114
2221933 2221933 2022-02-16 McIntosh Oklahoma 40091 4854 114
2218682 2218682 2022-02-15 McIntosh Oklahoma 40091 4788 111
2215431 2215431 2022-02-14 McIntosh Oklahoma 40091 4788 111
2212180 2212180 2022-02-13 McIntosh Oklahoma 40091 4788 111
2208927 2208927 2022-02-12 McIntosh Oklahoma 40091 4788 111
2205674 2205674 2022-02-11 McIntosh Oklahoma 40091 4788 111
2202421 2202421 2022-02-10 McIntosh Oklahoma 40091 4788 111
2199167 2199167 2022-02-09 McIntosh Oklahoma 40091 4788 111
2195913 2195913 2022-02-08 McIntosh Oklahoma 40091 4678 111
2192659 2192659 2022-02-07 McIntosh Oklahoma 40091 4678 111
2189405 2189405 2022-02-06 McIntosh Oklahoma 40091 4678 111
2186152 2186152 2022-02-05 McIntosh Oklahoma 40091 4678 111
2182900 2182900 2022-02-04 McIntosh Oklahoma 40091 4678 111
2179648 2179648 2022-02-03 McIntosh Oklahoma 40091 4678 111

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);