ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
113 rows where cases = 6269 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 25
- Missouri 40
- Oklahoma 7
- Kansas 6
- Louisiana 5
- Minnesota 5
- North Carolina 5
- Texas 5
- Georgia 4
- Mississippi 4
- South Carolina 4
- Tennessee 4
- Colorado 3
- New York 3
- Wisconsin 3
- Alabama 2
- Ohio 2
- Puerto Rico 2
- Virginia 2
- Arizona 1
- Illinois 1
- Kentucky 1
- Michigan 1
- Oregon 1
- Pennsylvania 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2475106 | 2475106 | 2022-05-05 | Saline | Missouri | 29195 | 6269 | 107 |
2471849 | 2471849 | 2022-05-04 | Saline | Missouri | 29195 | 6269 | 102 |
2468593 | 2468593 | 2022-05-03 | Saline | Missouri | 29195 | 6269 | 102 |
2465337 | 2465337 | 2022-05-02 | Saline | Missouri | 29195 | 6269 | 102 |
2462082 | 2462082 | 2022-05-01 | Saline | Missouri | 29195 | 6269 | 102 |
2458826 | 2458826 | 2022-04-30 | Saline | Missouri | 29195 | 6269 | 102 |
2459129 | 2459129 | 2022-04-30 | Seneca | New York | 36099 | 6269 | 91 |
2455570 | 2455570 | 2022-04-29 | Saline | Missouri | 29195 | 6269 | 102 |
2452314 | 2452314 | 2022-04-28 | Saline | Missouri | 29195 | 6269 | 102 |
2449058 | 2449058 | 2022-04-27 | Saline | Missouri | 29195 | 6269 | 102 |
2445801 | 2445801 | 2022-04-26 | Saline | Missouri | 29195 | 6269 | 102 |
2442546 | 2442546 | 2022-04-25 | Saline | Missouri | 29195 | 6269 | 102 |
2439290 | 2439290 | 2022-04-24 | Saline | Missouri | 29195 | 6269 | 102 |
2436034 | 2436034 | 2022-04-23 | Saline | Missouri | 29195 | 6269 | 102 |
2432778 | 2432778 | 2022-04-22 | Saline | Missouri | 29195 | 6269 | 102 |
2433569 | 2433569 | 2022-04-22 | Manati | Puerto Rico | 72091 | 6269 | |
2429522 | 2429522 | 2022-04-21 | Saline | Missouri | 29195 | 6269 | 102 |
2426266 | 2426266 | 2022-04-20 | Saline | Missouri | 29195 | 6269 | 102 |
2423010 | 2423010 | 2022-04-19 | Saline | Missouri | 29195 | 6269 | 102 |
2419753 | 2419753 | 2022-04-18 | Saline | Missouri | 29195 | 6269 | 102 |
2416498 | 2416498 | 2022-04-17 | Saline | Missouri | 29195 | 6269 | 102 |
2413242 | 2413242 | 2022-04-16 | Saline | Missouri | 29195 | 6269 | 102 |
2409986 | 2409986 | 2022-04-15 | Saline | Missouri | 29195 | 6269 | 102 |
2406730 | 2406730 | 2022-04-14 | Saline | Missouri | 29195 | 6269 | 102 |
2403474 | 2403474 | 2022-04-13 | Saline | Missouri | 29195 | 6269 | 102 |
2400219 | 2400219 | 2022-04-12 | Saline | Missouri | 29195 | 6269 | 102 |
2396532 | 2396532 | 2022-04-11 | Pointe Coupee | Louisiana | 22077 | 6269 | 92 |
2396964 | 2396964 | 2022-04-11 | Saline | Missouri | 29195 | 6269 | 102 |
2393277 | 2393277 | 2022-04-10 | Pointe Coupee | Louisiana | 22077 | 6269 | 92 |
2393709 | 2393709 | 2022-04-10 | Saline | Missouri | 29195 | 6269 | 102 |
2390021 | 2390021 | 2022-04-09 | Pointe Coupee | Louisiana | 22077 | 6269 | 92 |
2390453 | 2390453 | 2022-04-09 | Saline | Missouri | 29195 | 6269 | 102 |
2386765 | 2386765 | 2022-04-08 | Pointe Coupee | Louisiana | 22077 | 6269 | 92 |
2387197 | 2387197 | 2022-04-08 | Saline | Missouri | 29195 | 6269 | 102 |
2383942 | 2383942 | 2022-04-07 | Saline | Missouri | 29195 | 6269 | 102 |
2380687 | 2380687 | 2022-04-06 | Saline | Missouri | 29195 | 6269 | 102 |
2377432 | 2377432 | 2022-04-05 | Saline | Missouri | 29195 | 6269 | 102 |
2374179 | 2374179 | 2022-04-04 | Saline | Missouri | 29195 | 6269 | 102 |
2370927 | 2370927 | 2022-04-03 | Saline | Missouri | 29195 | 6269 | 102 |
2367674 | 2367674 | 2022-04-02 | Saline | Missouri | 29195 | 6269 | 102 |
2364421 | 2364421 | 2022-04-01 | Saline | Missouri | 29195 | 6269 | 102 |
2361167 | 2361167 | 2022-03-31 | Saline | Missouri | 29195 | 6269 | 102 |
2357913 | 2357913 | 2022-03-30 | Saline | Missouri | 29195 | 6269 | 102 |
2354660 | 2354660 | 2022-03-29 | Saline | Missouri | 29195 | 6269 | 102 |
2351407 | 2351407 | 2022-03-28 | Saline | Missouri | 29195 | 6269 | 102 |
2285061 | 2285061 | 2022-03-08 | Routt | Colorado | 8107 | 6269 | 24 |
2263905 | 2263905 | 2022-03-01 | Ashe | North Carolina | 37009 | 6269 | 70 |
2244837 | 2244837 | 2022-02-23 | Canovanas | Puerto Rico | 72029 | 6269 | |
2137238 | 2137238 | 2022-01-21 | Gallia | Ohio | 39053 | 6269 | 91 |
2126343 | 2126343 | 2022-01-18 | McPherson | Kansas | 20113 | 6269 | 111 |
2123091 | 2123091 | 2022-01-17 | McPherson | Kansas | 20113 | 6269 | 111 |
2119839 | 2119839 | 2022-01-16 | McPherson | Kansas | 20113 | 6269 | 111 |
2116587 | 2116587 | 2022-01-15 | McPherson | Kansas | 20113 | 6269 | 111 |
2113336 | 2113336 | 2022-01-14 | McPherson | Kansas | 20113 | 6269 | 111 |
2110084 | 2110084 | 2022-01-13 | McPherson | Kansas | 20113 | 6269 | 111 |
2057059 | 2057059 | 2021-12-27 | Oneida | Wisconsin | 55085 | 6269 | 107 |
1968312 | 1968312 | 2021-11-30 | Ottawa | Oklahoma | 40115 | 6269 | 101 |
1965061 | 1965061 | 2021-11-29 | Ottawa | Oklahoma | 40115 | 6269 | 101 |
1961809 | 1961809 | 2021-11-28 | Ottawa | Oklahoma | 40115 | 6269 | 101 |
1958558 | 1958558 | 2021-11-27 | Ottawa | Oklahoma | 40115 | 6269 | 101 |
1955307 | 1955307 | 2021-11-26 | Ottawa | Oklahoma | 40115 | 6269 | 101 |
1952056 | 1952056 | 2021-11-25 | Ottawa | Oklahoma | 40115 | 6269 | 101 |
1948805 | 1948805 | 2021-11-24 | Ottawa | Oklahoma | 40115 | 6269 | 101 |
1930064 | 1930064 | 2021-11-18 | Franklin | Virginia | 51067 | 6269 | 108 |
1851432 | 1851432 | 2021-10-25 | Venango | Pennsylvania | 42121 | 6269 | 132 |
1842053 | 1842053 | 2021-10-22 | Erath | Texas | 48143 | 6269 | 100 |
1825968 | 1825968 | 2021-10-17 | Uvalde | Texas | 48463 | 6269 | 105 |
1822719 | 1822719 | 2021-10-16 | Uvalde | Texas | 48463 | 6269 | 105 |
1819470 | 1819470 | 2021-10-15 | Uvalde | Texas | 48463 | 6269 | 105 |
1814696 | 1814696 | 2021-10-14 | Beltrami | Minnesota | 27007 | 6269 | 76 |
1815300 | 1815300 | 2021-10-14 | Davie | North Carolina | 37059 | 6269 | 70 |
1811494 | 1811494 | 2021-10-13 | Mower | Minnesota | 27099 | 6269 | 39 |
1804022 | 1804022 | 2021-10-11 | Bryan | Georgia | 13029 | 6269 | 60 |
1800773 | 1800773 | 2021-10-10 | Bryan | Georgia | 13029 | 6269 | 60 |
1797524 | 1797524 | 2021-10-09 | Bryan | Georgia | 13029 | 6269 | 60 |
1794275 | 1794275 | 2021-10-08 | Bryan | Georgia | 13029 | 6269 | 60 |
1793054 | 1793054 | 2021-10-07 | Dillon | South Carolina | 45033 | 6269 | 110 |
1761340 | 1761340 | 2021-09-27 | Shawano | Wisconsin | 55115 | 6269 | 87 |
1747716 | 1747716 | 2021-09-23 | Lincoln | Tennessee | 47103 | 6269 | 78 |
1735398 | 1735398 | 2021-09-20 | Chilton | Alabama | 1021 | 6269 | 133 |
1737312 | 1737312 | 2021-09-20 | Chatham | North Carolina | 37037 | 6269 | 91 |
1717995 | 1717995 | 2021-09-14 | Knox | Ohio | 39083 | 6269 | 120 |
1715431 | 1715431 | 2021-09-13 | Medina | Texas | 48325 | 6269 | 138 |
1688510 | 1688510 | 2021-09-05 | Cattaraugus | New York | 36009 | 6269 | 94 |
1671904 | 1671904 | 2021-08-31 | Washington | Mississippi | 28151 | 6269 | 143 |
1574829 | 1574829 | 2021-08-01 | Jefferson | New York | 36045 | 6269 | 68 |
1551566 | 1551566 | 2021-07-25 | Chisago | Minnesota | 27025 | 6269 | 54 |
1548319 | 1548319 | 2021-07-24 | Chisago | Minnesota | 27025 | 6269 | 54 |
1545072 | 1545072 | 2021-07-23 | Chisago | Minnesota | 27025 | 6269 | 54 |
1542443 | 1542443 | 2021-07-22 | Lee | North Carolina | 37105 | 6269 | 83 |
1536418 | 1536418 | 2021-07-20 | Cherokee | South Carolina | 45021 | 6269 | 159 |
1474260 | 1474260 | 2021-07-01 | Lenoir | North Carolina | 37107 | 6269 | 124 |
1392614 | 1392614 | 2021-06-06 | Lafayette | Mississippi | 28071 | 6269 | 120 |
1389369 | 1389369 | 2021-06-05 | Lafayette | Mississippi | 28071 | 6269 | 120 |
1386124 | 1386124 | 2021-06-04 | Lafayette | Mississippi | 28071 | 6269 | 120 |
1350249 | 1350249 | 2021-05-24 | Isabella | Michigan | 26073 | 6269 | 93 |
1297285 | 1297285 | 2021-05-08 | Eagle | Colorado | 8037 | 6269 | 22 |
1294039 | 1294039 | 2021-05-07 | Eagle | Colorado | 8037 | 6269 | 22 |
1171440 | 1171440 | 2021-03-30 | Laurel | Kentucky | 21125 | 6269 | 54 |
1168250 | 1168250 | 2021-03-29 | Acadia | Louisiana | 22001 | 6269 | 189 |
Advanced export
JSON shape: default, array, newline-delimited
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);