ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
63 rows where cases = 5982 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 24
- Kentucky 11
- Virginia 6
- Indiana 5
- North Carolina 5
- Illinois 3
- Kansas 3
- Louisiana 3
- Maryland 3
- Minnesota 3
- Ohio 3
- Idaho 2
- New York 2
- Tennessee 2
- Texas 2
- Arkansas 1
- California 1
- Georgia 1
- Iowa 1
- Massachusetts 1
- Mississippi 1
- Pennsylvania 1
- South Carolina 1
- Utah 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2461500 | 2461500 | 2022-05-01 | Bourbon | Kentucky | 21017 | 5982 | 56 |
2458244 | 2458244 | 2022-04-30 | Bourbon | Kentucky | 21017 | 5982 | 56 |
2454988 | 2454988 | 2022-04-29 | Bourbon | Kentucky | 21017 | 5982 | 56 |
2451732 | 2451732 | 2022-04-28 | Bourbon | Kentucky | 21017 | 5982 | 56 |
2453780 | 2453780 | 2022-04-28 | Waynesboro city | Virginia | 51820 | 5982 | 69 |
2448476 | 2448476 | 2022-04-27 | Bourbon | Kentucky | 21017 | 5982 | 56 |
2445220 | 2445220 | 2022-04-26 | Bourbon | Kentucky | 21017 | 5982 | 56 |
2441964 | 2441964 | 2022-04-25 | Bourbon | Kentucky | 21017 | 5982 | 56 |
2402445 | 2402445 | 2022-04-13 | Blaine | Idaho | 16013 | 5982 | 30 |
2308316 | 2308316 | 2022-03-15 | Washington | Indiana | 18175 | 5982 | 79 |
2305065 | 2305065 | 2022-03-14 | Washington | Indiana | 18175 | 5982 | 79 |
2304030 | 2304030 | 2022-03-13 | Mecklenburg | Virginia | 51117 | 5982 | 110 |
2300778 | 2300778 | 2022-03-12 | Mecklenburg | Virginia | 51117 | 5982 | 110 |
2297526 | 2297526 | 2022-03-11 | Mecklenburg | Virginia | 51117 | 5982 | 110 |
2237196 | 2237196 | 2022-02-21 | Caroline | Maryland | 24011 | 5982 | 78 |
2233945 | 2233945 | 2022-02-20 | Caroline | Maryland | 24011 | 5982 | 78 |
2216943 | 2216943 | 2022-02-15 | Harris | Georgia | 13145 | 5982 | 101 |
2175271 | 2175271 | 2022-02-02 | Marion | Kentucky | 21155 | 5982 | 67 |
2149320 | 2149320 | 2022-01-25 | Morehouse | Louisiana | 22067 | 5982 | 121 |
2039691 | 2039691 | 2021-12-22 | Coshocton | Ohio | 39031 | 5982 | 121 |
2018789 | 2018789 | 2021-12-16 | Randolph | Illinois | 17157 | 5982 | 111 |
2020678 | 2020678 | 2021-12-16 | Henderson | Tennessee | 47077 | 5982 | 111 |
2017427 | 2017427 | 2021-12-15 | Henderson | Tennessee | 47077 | 5982 | 111 |
1989595 | 1989595 | 2021-12-07 | Jefferson | Indiana | 18077 | 5982 | 108 |
1964059 | 1964059 | 2021-11-29 | Calvert | Maryland | 24009 | 5982 | 101 |
1870002 | 1870002 | 2021-10-31 | Steele | Minnesota | 27147 | 5982 | 26 |
1866753 | 1866753 | 2021-10-30 | Steele | Minnesota | 27147 | 5982 | 26 |
1863504 | 1863504 | 2021-10-29 | Steele | Minnesota | 27147 | 5982 | 26 |
1803150 | 1803150 | 2021-10-10 | Matagorda | Texas | 48321 | 5982 | 152 |
1666052 | 1666052 | 2021-08-29 | Sandusky | Ohio | 39143 | 5982 | 131 |
1645868 | 1645868 | 2021-08-23 | Hancock | Mississippi | 28045 | 5982 | 93 |
1646281 | 1646281 | 2021-08-23 | Cattaraugus | New York | 36009 | 5982 | 94 |
1636782 | 1636782 | 2021-08-20 | Huron | Ohio | 39077 | 5982 | 123 |
1626044 | 1626044 | 2021-08-17 | Scott | Kentucky | 21209 | 5982 | 36 |
1582338 | 1582338 | 2021-08-03 | Box Elder | Utah | 49003 | 5982 | 57 |
1554235 | 1554235 | 2021-07-26 | Noble | Indiana | 18113 | 5982 | 93 |
1518852 | 1518852 | 2021-07-15 | Pike | Kentucky | 21195 | 5982 | 110 |
1459010 | 1459010 | 2021-06-26 | Augusta | Virginia | 51015 | 5982 | 77 |
1449274 | 1449274 | 2021-06-23 | Augusta | Virginia | 51015 | 5982 | 77 |
1411270 | 1411270 | 2021-06-12 | Grundy | Illinois | 17063 | 5982 | 82 |
1347667 | 1347667 | 2021-05-23 | Granville | North Carolina | 37077 | 5982 | 81 |
1344419 | 1344419 | 2021-05-22 | Granville | North Carolina | 37077 | 5982 | 81 |
1341171 | 1341171 | 2021-05-21 | Granville | North Carolina | 37077 | 5982 | 81 |
1271023 | 1271023 | 2021-04-29 | Waupaca | Wisconsin | 55135 | 5982 | 161 |
1248448 | 1248448 | 2021-04-23 | Crittenden | Arkansas | 5035 | 5982 | 96 |
1229057 | 1229057 | 2021-04-17 | San Benito | California | 6069 | 5982 | 63 |
1119503 | 1119503 | 2021-03-14 | McCracken | Kentucky | 21145 | 5982 | 81 |
1115780 | 1115780 | 2021-03-13 | Boone | Illinois | 17007 | 5982 | 82 |
1113808 | 1113808 | 2021-03-12 | Ontario | New York | 36069 | 5982 | 90 |
1073901 | 1073901 | 2021-02-28 | Finney | Kansas | 20055 | 5982 | 48 |
1074979 | 1074979 | 2021-02-28 | Wilkes | North Carolina | 37193 | 5982 | 103 |
1070655 | 1070655 | 2021-02-27 | Finney | Kansas | 20055 | 5982 | 48 |
1071733 | 1071733 | 2021-02-27 | Wilkes | North Carolina | 37193 | 5982 | 103 |
1067410 | 1067410 | 2021-02-26 | Finney | Kansas | 20055 | 5982 | 48 |
1025415 | 1025415 | 2021-02-13 | Acadia | Louisiana | 22001 | 5982 | 177 |
1026571 | 1026571 | 2021-02-13 | Clearfield | Pennsylvania | 42033 | 5982 | 110 |
1022170 | 1022170 | 2021-02-12 | Acadia | Louisiana | 22001 | 5982 | 177 |
1017180 | 1017180 | 2021-02-10 | Anderson | Texas | 48001 | 5982 | 99 |
927652 | 927652 | 2021-01-14 | Floyd | Indiana | 18043 | 5982 | 110 |
849601 | 849601 | 2020-12-21 | Bannock | Idaho | 16005 | 5982 | 54 |
677865 | 677865 | 2020-10-29 | Black Hawk | Iowa | 19013 | 5982 | 102 |
627608 | 627608 | 2020-10-13 | York | South Carolina | 45091 | 5982 | 87 |
191901 | 191901 | 2020-05-30 | Hampden | Massachusetts | 25013 | 5982 | 572 |
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);