ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,369 rows where cases = 29 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
These facets timed out: county, fips
state >30
- Nebraska 257
- Texas 193
- Kentucky 161
- Michigan 150
- Georgia 125
- Oklahoma 121
- Montana 107
- Iowa 106
- Missouri 105
- Tennessee 100
- Arkansas 96
- Virginia 95
- Kansas 93
- Illinois 92
- Puerto Rico 91
- Indiana 89
- Wisconsin 85
- Minnesota 83
- North Carolina 81
- Idaho 77
- South Dakota 77
- Ohio 69
- West Virginia 66
- North Dakota 63
- Washington 62
- Alaska 59
- Colorado 55
- Florida 53
- Oregon 53
- Mississippi 50
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2461690 | 2461690 | 2022-05-01 | Unknown | Maine | 29 | 0 | |
2458434 | 2458434 | 2022-04-30 | Unknown | Maine | 29 | 0 | |
2143307 | 2143307 | 2022-01-23 | Petroleum | Montana | 30069 | 29 | 1 |
2140052 | 2140052 | 2022-01-22 | Petroleum | Montana | 30069 | 29 | 1 |
2136796 | 2136796 | 2022-01-21 | Petroleum | Montana | 30069 | 29 | 1 |
2123809 | 2123809 | 2022-01-17 | Arthur | Nebraska | 31005 | 29 | 1 |
2120557 | 2120557 | 2022-01-16 | Arthur | Nebraska | 31005 | 29 | 1 |
2117305 | 2117305 | 2022-01-15 | Arthur | Nebraska | 31005 | 29 | 1 |
2114054 | 2114054 | 2022-01-14 | Arthur | Nebraska | 31005 | 29 | 1 |
2110802 | 2110802 | 2022-01-13 | Arthur | Nebraska | 31005 | 29 | 1 |
2107551 | 2107551 | 2022-01-12 | Arthur | Nebraska | 31005 | 29 | 1 |
2104300 | 2104300 | 2022-01-11 | Arthur | Nebraska | 31005 | 29 | 1 |
2101049 | 2101049 | 2022-01-10 | Arthur | Nebraska | 31005 | 29 | 1 |
2097798 | 2097798 | 2022-01-09 | Arthur | Nebraska | 31005 | 29 | 1 |
2098885 | 2098885 | 2022-01-09 | King | Texas | 48269 | 29 | 0 |
2094546 | 2094546 | 2022-01-08 | Arthur | Nebraska | 31005 | 29 | 1 |
2095633 | 2095633 | 2022-01-08 | King | Texas | 48269 | 29 | 0 |
2091294 | 2091294 | 2022-01-07 | Arthur | Nebraska | 31005 | 29 | 1 |
2088043 | 2088043 | 2022-01-06 | Arthur | Nebraska | 31005 | 29 | 1 |
2084791 | 2084791 | 2022-01-05 | Arthur | Nebraska | 31005 | 29 | 1 |
2081539 | 2081539 | 2022-01-04 | Arthur | Nebraska | 31005 | 29 | 1 |
2078287 | 2078287 | 2022-01-03 | Arthur | Nebraska | 31005 | 29 | 1 |
2075036 | 2075036 | 2022-01-02 | Arthur | Nebraska | 31005 | 29 | 1 |
2071785 | 2071785 | 2022-01-01 | Arthur | Nebraska | 31005 | 29 | 1 |
2068534 | 2068534 | 2021-12-31 | Arthur | Nebraska | 31005 | 29 | 1 |
2065283 | 2065283 | 2021-12-30 | Arthur | Nebraska | 31005 | 29 | 1 |
2062033 | 2062033 | 2021-12-29 | Arthur | Nebraska | 31005 | 29 | 1 |
2058784 | 2058784 | 2021-12-28 | Arthur | Nebraska | 31005 | 29 | 1 |
2055535 | 2055535 | 2021-12-27 | Arthur | Nebraska | 31005 | 29 | 1 |
2052285 | 2052285 | 2021-12-26 | Arthur | Nebraska | 31005 | 29 | 1 |
2049035 | 2049035 | 2021-12-25 | Arthur | Nebraska | 31005 | 29 | 1 |
2045785 | 2045785 | 2021-12-24 | Arthur | Nebraska | 31005 | 29 | 1 |
2042535 | 2042535 | 2021-12-23 | Arthur | Nebraska | 31005 | 29 | 1 |
2039286 | 2039286 | 2021-12-22 | Arthur | Nebraska | 31005 | 29 | 1 |
2036036 | 2036036 | 2021-12-21 | Arthur | Nebraska | 31005 | 29 | 1 |
2032786 | 2032786 | 2021-12-20 | Arthur | Nebraska | 31005 | 29 | 1 |
2010204 | 2010204 | 2021-12-13 | Unknown | New Mexico | 29 | 0 | |
1897517 | 1897517 | 2021-11-08 | Unknown | Vermont | 29 | 0 | |
1803288 | 1803288 | 2021-10-10 | Unknown | Vermont | 29 | 0 | |
1792447 | 1792447 | 2021-10-07 | Harding | New Mexico | 35021 | 29 | 2 |
1740312 | 1740312 | 2021-09-21 | Blaine | Nebraska | 31009 | 29 | 0 |
1737063 | 1737063 | 2021-09-20 | Blaine | Nebraska | 31009 | 29 | 0 |
1506440 | 1506440 | 2021-07-11 | Banner | Nebraska | 31007 | 29 | 0 |
1503194 | 1503194 | 2021-07-10 | Banner | Nebraska | 31007 | 29 | 0 |
1499948 | 1499948 | 2021-07-09 | Banner | Nebraska | 31007 | 29 | 0 |
1496702 | 1496702 | 2021-07-08 | Banner | Nebraska | 31007 | 29 | 0 |
1493455 | 1493455 | 2021-07-07 | Banner | Nebraska | 31007 | 29 | 0 |
1490208 | 1490208 | 2021-07-06 | Banner | Nebraska | 31007 | 29 | 0 |
1486961 | 1486961 | 2021-07-05 | Banner | Nebraska | 31007 | 29 | 0 |
1483715 | 1483715 | 2021-07-04 | Banner | Nebraska | 31007 | 29 | 0 |
1480469 | 1480469 | 2021-07-03 | Banner | Nebraska | 31007 | 29 | 0 |
1477222 | 1477222 | 2021-07-02 | Banner | Nebraska | 31007 | 29 | 0 |
1473976 | 1473976 | 2021-07-01 | Banner | Nebraska | 31007 | 29 | 0 |
1470730 | 1470730 | 2021-06-30 | Banner | Nebraska | 31007 | 29 | 0 |
1467485 | 1467485 | 2021-06-29 | Banner | Nebraska | 31007 | 29 | 0 |
1464240 | 1464240 | 2021-06-28 | Banner | Nebraska | 31007 | 29 | 0 |
1460995 | 1460995 | 2021-06-27 | Banner | Nebraska | 31007 | 29 | 0 |
1457750 | 1457750 | 2021-06-26 | Banner | Nebraska | 31007 | 29 | 0 |
1454505 | 1454505 | 2021-06-25 | Banner | Nebraska | 31007 | 29 | 0 |
1451260 | 1451260 | 2021-06-24 | Banner | Nebraska | 31007 | 29 | 0 |
1448014 | 1448014 | 2021-06-23 | Banner | Nebraska | 31007 | 29 | 0 |
1444769 | 1444769 | 2021-06-22 | Banner | Nebraska | 31007 | 29 | 0 |
1441524 | 1441524 | 2021-06-21 | Banner | Nebraska | 31007 | 29 | 0 |
1438278 | 1438278 | 2021-06-20 | Banner | Nebraska | 31007 | 29 | 0 |
1435031 | 1435031 | 2021-06-19 | Banner | Nebraska | 31007 | 29 | 0 |
1431784 | 1431784 | 2021-06-18 | Banner | Nebraska | 31007 | 29 | 0 |
1428539 | 1428539 | 2021-06-17 | Banner | Nebraska | 31007 | 29 | 0 |
1425294 | 1425294 | 2021-06-16 | Banner | Nebraska | 31007 | 29 | 0 |
1422046 | 1422046 | 2021-06-15 | Banner | Nebraska | 31007 | 29 | 0 |
1418801 | 1418801 | 2021-06-14 | Banner | Nebraska | 31007 | 29 | 0 |
1415556 | 1415556 | 2021-06-13 | Banner | Nebraska | 31007 | 29 | 0 |
1412310 | 1412310 | 2021-06-12 | Banner | Nebraska | 31007 | 29 | 0 |
1409065 | 1409065 | 2021-06-11 | Banner | Nebraska | 31007 | 29 | 0 |
1405820 | 1405820 | 2021-06-10 | Banner | Nebraska | 31007 | 29 | 0 |
1402574 | 1402574 | 2021-06-09 | Banner | Nebraska | 31007 | 29 | 0 |
1399329 | 1399329 | 2021-06-08 | Banner | Nebraska | 31007 | 29 | 0 |
1396083 | 1396083 | 2021-06-07 | Banner | Nebraska | 31007 | 29 | 0 |
1392837 | 1392837 | 2021-06-06 | Banner | Nebraska | 31007 | 29 | 0 |
1389592 | 1389592 | 2021-06-05 | Banner | Nebraska | 31007 | 29 | 0 |
1386347 | 1386347 | 2021-06-04 | Banner | Nebraska | 31007 | 29 | 0 |
1383102 | 1383102 | 2021-06-03 | Banner | Nebraska | 31007 | 29 | 0 |
1379856 | 1379856 | 2021-06-02 | Banner | Nebraska | 31007 | 29 | 0 |
1376611 | 1376611 | 2021-06-01 | Banner | Nebraska | 31007 | 29 | 0 |
1373365 | 1373365 | 2021-05-31 | Banner | Nebraska | 31007 | 29 | 0 |
1370120 | 1370120 | 2021-05-30 | Banner | Nebraska | 31007 | 29 | 0 |
1366874 | 1366874 | 2021-05-29 | Banner | Nebraska | 31007 | 29 | 0 |
1363628 | 1363628 | 2021-05-28 | Banner | Nebraska | 31007 | 29 | 0 |
1360437 | 1360437 | 2021-05-27 | McPherson | Nebraska | 31117 | 29 | 1 |
1357191 | 1357191 | 2021-05-26 | McPherson | Nebraska | 31117 | 29 | 1 |
1353945 | 1353945 | 2021-05-25 | McPherson | Nebraska | 31117 | 29 | 1 |
1350699 | 1350699 | 2021-05-24 | McPherson | Nebraska | 31117 | 29 | 1 |
1347453 | 1347453 | 2021-05-23 | McPherson | Nebraska | 31117 | 29 | 1 |
1344205 | 1344205 | 2021-05-22 | McPherson | Nebraska | 31117 | 29 | 1 |
1340957 | 1340957 | 2021-05-21 | McPherson | Nebraska | 31117 | 29 | 1 |
1337709 | 1337709 | 2021-05-20 | McPherson | Nebraska | 31117 | 29 | 1 |
1334462 | 1334462 | 2021-05-19 | McPherson | Nebraska | 31117 | 29 | 1 |
1331215 | 1331215 | 2021-05-18 | McPherson | Nebraska | 31117 | 29 | 1 |
1327968 | 1327968 | 2021-05-17 | McPherson | Nebraska | 31117 | 29 | 1 |
1324722 | 1324722 | 2021-05-16 | McPherson | Nebraska | 31117 | 29 | 1 |
1321476 | 1321476 | 2021-05-15 | McPherson | Nebraska | 31117 | 29 | 1 |
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);