ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
85 rows where cases = 5857 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Louisiana 11
- Tennessee 10
- Indiana 9
- Rhode Island 7
- Idaho 4
- Minnesota 4
- South Carolina 4
- Virginia 3
- West Virginia 3
- Wisconsin 3
- Georgia 2
- Illinois 2
- Iowa 2
- North Carolina 2
- Texas 2
- Alabama 1
- Arizona 1
- Arkansas 1
- California 1
- Florida 1
- Maryland 1
- Michigan 1
- Mississippi 1
- Missouri 1
- New Mexico 1
- New York 1
- Ohio 1
- Oklahoma 1
- Pennsylvania 1
- Puerto Rico 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2468144 | 2468144 | 2022-05-03 | Grant | Louisiana | 22043 | 5857 | 94 |
2469546 | 2469546 | 2022-05-03 | Chester | Tennessee | 47023 | 5857 | 97 |
2464889 | 2464889 | 2022-05-02 | Grant | Louisiana | 22043 | 5857 | 94 |
2466290 | 2466290 | 2022-05-02 | Chester | Tennessee | 47023 | 5857 | 97 |
2461633 | 2461633 | 2022-05-01 | Grant | Louisiana | 22043 | 5857 | 94 |
2463035 | 2463035 | 2022-05-01 | Chester | Tennessee | 47023 | 5857 | 97 |
2458377 | 2458377 | 2022-04-30 | Grant | Louisiana | 22043 | 5857 | 94 |
2459779 | 2459779 | 2022-04-30 | Chester | Tennessee | 47023 | 5857 | 97 |
2455121 | 2455121 | 2022-04-29 | Grant | Louisiana | 22043 | 5857 | 94 |
2456523 | 2456523 | 2022-04-29 | Chester | Tennessee | 47023 | 5857 | 97 |
2451865 | 2451865 | 2022-04-28 | Grant | Louisiana | 22043 | 5857 | 94 |
2453267 | 2453267 | 2022-04-28 | Chester | Tennessee | 47023 | 5857 | 97 |
2450011 | 2450011 | 2022-04-27 | Chester | Tennessee | 47023 | 5857 | 97 |
2447327 | 2447327 | 2022-04-26 | Hampshire | West Virginia | 54027 | 5857 | 72 |
2406979 | 2406979 | 2022-04-14 | San Miguel | New Mexico | 35047 | 5857 | 55 |
2339186 | 2339186 | 2022-03-24 | Manati | Puerto Rico | 72091 | 5857 | |
2308016 | 2308016 | 2022-03-15 | Monroe | Georgia | 13207 | 5857 | 172 |
2257938 | 2257938 | 2022-02-27 | Jasper | South Carolina | 45053 | 5857 | 92 |
2254687 | 2254687 | 2022-02-26 | Jasper | South Carolina | 45053 | 5857 | 92 |
2251436 | 2251436 | 2022-02-25 | Jasper | South Carolina | 45053 | 5857 | 92 |
2218919 | 2218919 | 2022-02-15 | Fairfield | South Carolina | 45039 | 5857 | 101 |
2156037 | 2156037 | 2022-01-27 | Le Sueur | Minnesota | 27079 | 5857 | 47 |
2131585 | 2131585 | 2022-01-19 | Botetourt | Virginia | 51023 | 5857 | 67 |
2043813 | 2043813 | 2021-12-23 | Charlottesville city | Virginia | 51540 | 5857 | 63 |
1988466 | 1988466 | 2021-12-06 | Washington | Texas | 48477 | 5857 | 133 |
1939412 | 1939412 | 2021-11-21 | Henderson | Tennessee | 47077 | 5857 | 105 |
1936162 | 1936162 | 2021-11-20 | Henderson | Tennessee | 47077 | 5857 | 105 |
1932912 | 1932912 | 2021-11-19 | Henderson | Tennessee | 47077 | 5857 | 105 |
1918489 | 1918489 | 2021-11-15 | Iberville | Louisiana | 22047 | 5857 | 127 |
1915302 | 1915302 | 2021-11-14 | Calvert | Maryland | 24009 | 5857 | 101 |
1892487 | 1892487 | 2021-11-07 | Evangeline | Louisiana | 22039 | 5857 | 140 |
1889237 | 1889237 | 2021-11-06 | Evangeline | Louisiana | 22039 | 5857 | 140 |
1885987 | 1885987 | 2021-11-05 | Evangeline | Louisiana | 22039 | 5857 | 140 |
1882738 | 1882738 | 2021-11-04 | Evangeline | Louisiana | 22039 | 5857 | 140 |
1872566 | 1872566 | 2021-11-01 | Clinton | Indiana | 18023 | 5857 | 78 |
1821973 | 1821973 | 2021-10-16 | Madison | Ohio | 39097 | 5857 | 76 |
1809279 | 1809279 | 2021-10-12 | Bristol | Rhode Island | 44001 | 5857 | 149 |
1804209 | 1804209 | 2021-10-11 | Nez Perce | Idaho | 16069 | 5857 | 91 |
1806029 | 1806029 | 2021-10-11 | Bristol | Rhode Island | 44001 | 5857 | 149 |
1800960 | 1800960 | 2021-10-10 | Nez Perce | Idaho | 16069 | 5857 | 91 |
1801720 | 1801720 | 2021-10-10 | Goodhue | Minnesota | 27049 | 5857 | 82 |
1802779 | 1802779 | 2021-10-10 | Bristol | Rhode Island | 44001 | 5857 | 149 |
1797711 | 1797711 | 2021-10-09 | Nez Perce | Idaho | 16069 | 5857 | 91 |
1798471 | 1798471 | 2021-10-09 | Goodhue | Minnesota | 27049 | 5857 | 82 |
1799530 | 1799530 | 2021-10-09 | Bristol | Rhode Island | 44001 | 5857 | 149 |
1794462 | 1794462 | 2021-10-08 | Nez Perce | Idaho | 16069 | 5857 | 91 |
1795222 | 1795222 | 2021-10-08 | Goodhue | Minnesota | 27049 | 5857 | 82 |
1796281 | 1796281 | 2021-10-08 | Bristol | Rhode Island | 44001 | 5857 | 149 |
1793032 | 1793032 | 2021-10-07 | Bristol | Rhode Island | 44001 | 5857 | 149 |
1789783 | 1789783 | 2021-10-06 | Bristol | Rhode Island | 44001 | 5857 | 149 |
1755640 | 1755640 | 2021-09-26 | Montgomery | Indiana | 18107 | 5857 | 107 |
1752392 | 1752392 | 2021-09-25 | Montgomery | Indiana | 18107 | 5857 | 107 |
1749143 | 1749143 | 2021-09-24 | Montgomery | Indiana | 18107 | 5857 | 107 |
1732006 | 1732006 | 2021-09-18 | Jefferson | West Virginia | 54037 | 5857 | 69 |
1697874 | 1697874 | 2021-09-08 | Panola | Mississippi | 28107 | 5857 | 115 |
1677566 | 1677566 | 2021-09-02 | Macoupin | Illinois | 17117 | 5857 | 122 |
1601853 | 1601853 | 2021-08-09 | Summit | Utah | 49043 | 5857 | 15 |
1517958 | 1517958 | 2021-07-15 | Lassen | California | 6035 | 5857 | 26 |
1403530 | 1403530 | 2021-06-09 | Atascosa | Texas | 48013 | 5857 | 150 |
1383710 | 1383710 | 2021-06-03 | Columbia | Pennsylvania | 42037 | 5857 | 133 |
1349690 | 1349690 | 2021-05-24 | Dearborn | Indiana | 18029 | 5857 | 81 |
1346443 | 1346443 | 2021-05-23 | Dearborn | Indiana | 18029 | 5857 | 81 |
1345410 | 1345410 | 2021-05-22 | Augusta | Virginia | 51015 | 5857 | 73 |
1310164 | 1310164 | 2021-05-12 | Mississippi | Arkansas | 5093 | 5857 | 107 |
1288837 | 1288837 | 2021-05-05 | Lincoln | Missouri | 29113 | 5857 | 41 |
1270957 | 1270957 | 2021-04-29 | Barron | Wisconsin | 55005 | 5857 | 81 |
1266498 | 1266498 | 2021-04-28 | Granville | North Carolina | 37077 | 5857 | 80 |
1267710 | 1267710 | 2021-04-28 | Barron | Wisconsin | 55005 | 5857 | 81 |
1152782 | 1152782 | 2021-03-24 | St. Lawrence | New York | 36089 | 5857 | 94 |
1078151 | 1078151 | 2021-03-01 | Columbus | North Carolina | 37047 | 5857 | 142 |
1073344 | 1073344 | 2021-02-28 | Monroe | Florida | 12087 | 5857 | 46 |
1065396 | 1065396 | 2021-02-25 | Bryan | Oklahoma | 40013 | 5857 | 55 |
1047733 | 1047733 | 2021-02-20 | Dubois | Indiana | 18037 | 5857 | 107 |
1005579 | 1005579 | 2021-02-07 | Morgan | Indiana | 18109 | 5857 | 124 |
972176 | 972176 | 2021-01-27 | Chelan | Washington | 53007 | 5857 | 49 |
923586 | 923586 | 2021-01-12 | Wood | West Virginia | 54107 | 5857 | 62 |
878355 | 878355 | 2020-12-30 | Santa Cruz | Arizona | 4023 | 5857 | 95 |
856224 | 856224 | 2020-12-23 | Vermilion | Illinois | 17183 | 5857 | 83 |
754953 | 754953 | 2020-11-22 | Etowah | Alabama | 1055 | 5857 | 64 |
752421 | 752421 | 2020-11-21 | Johnson | Indiana | 18081 | 5857 | 170 |
752497 | 752497 | 2020-11-21 | Dallas | Iowa | 19049 | 5857 | 55 |
709417 | 709417 | 2020-11-07 | Dodge | Wisconsin | 55027 | 5857 | 44 |
687619 | 687619 | 2020-11-01 | Dubuque | Iowa | 19061 | 5857 | 61 |
326343 | 326343 | 2020-07-12 | Kent | Michigan | 26081 | 5857 | 144 |
306444 | 306444 | 2020-07-06 | Cobb | Georgia | 13067 | 5857 | 246 |
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);