ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
105 rows where cases = 4389 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 12
- Illinois 11
- Texas 8
- Indiana 7
- Georgia 6
- Alabama 5
- Kansas 5
- Tennessee 5
- Mississippi 4
- Missouri 4
- Ohio 4
- Puerto Rico 4
- Arkansas 3
- Louisiana 3
- New York 3
- Florida 2
- Minnesota 2
- Montana 2
- Wisconsin 2
- California 1
- Delaware 1
- Iowa 1
- Kentucky 1
- Maryland 1
- Michigan 1
- New Hampshire 1
- New Mexico 1
- Oklahoma 1
- South Carolina 1
- South Dakota 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2448099 | 2448099 | 2022-04-27 | Hancock | Illinois | 17067 | 4389 | 58 |
2444843 | 2444843 | 2022-04-26 | Hancock | Illinois | 17067 | 4389 | 58 |
2403028 | 2403028 | 2022-04-13 | Jackson | Louisiana | 22049 | 4389 | 75 |
2399774 | 2399774 | 2022-04-12 | Jackson | Louisiana | 22049 | 4389 | 75 |
2401572 | 2401572 | 2022-04-12 | Bristol city | Virginia | 51520 | 4389 | 79 |
2396518 | 2396518 | 2022-04-11 | Jackson | Louisiana | 22049 | 4389 | 75 |
2398317 | 2398317 | 2022-04-11 | Bristol city | Virginia | 51520 | 4389 | 79 |
2395062 | 2395062 | 2022-04-10 | Bristol city | Virginia | 51520 | 4389 | 78 |
2391806 | 2391806 | 2022-04-09 | Bristol city | Virginia | 51520 | 4389 | 78 |
2388550 | 2388550 | 2022-04-08 | Bristol city | Virginia | 51520 | 4389 | 78 |
2385295 | 2385295 | 2022-04-07 | Bristol city | Virginia | 51520 | 4389 | 78 |
2353743 | 2353743 | 2022-03-29 | Piatt | Illinois | 17147 | 4389 | 29 |
2350491 | 2350491 | 2022-03-28 | Piatt | Illinois | 17147 | 4389 | 29 |
2337432 | 2337432 | 2022-03-24 | Ford | Illinois | 17053 | 4389 | 73 |
2334178 | 2334178 | 2022-03-23 | Ford | Illinois | 17053 | 4389 | 73 |
2330924 | 2330924 | 2022-03-22 | Ford | Illinois | 17053 | 4389 | 73 |
2291993 | 2291993 | 2022-03-10 | Franklin | Indiana | 18047 | 4389 | 64 |
2282209 | 2282209 | 2022-03-07 | White | Illinois | 17193 | 4389 | 58 |
2245175 | 2245175 | 2022-02-23 | Deaf Smith | Texas | 48117 | 4389 | 109 |
2216515 | 2216515 | 2022-02-15 | Henry | Alabama | 1067 | 4389 | 68 |
2218116 | 2218116 | 2022-02-15 | Hill | Montana | 30041 | 4389 | 71 |
2196097 | 2196097 | 2022-02-08 | Morovis | Puerto Rico | 72101 | 4389 | |
2167257 | 2167257 | 2022-01-30 | Reeves | Texas | 48389 | 4389 | 64 |
2151192 | 2151192 | 2022-01-25 | Powhatan | Virginia | 51145 | 4389 | 36 |
2131948 | 2131948 | 2022-01-20 | Pickens | Alabama | 1107 | 4389 | 92 |
2125875 | 2125875 | 2022-01-18 | McDuffie | Georgia | 13189 | 4389 | 80 |
2052113 | 2052113 | 2021-12-26 | Audrain | Missouri | 29007 | 4389 | 82 |
2048863 | 2048863 | 2021-12-25 | Audrain | Missouri | 29007 | 4389 | 82 |
2045613 | 2045613 | 2021-12-24 | Audrain | Missouri | 29007 | 4389 | 82 |
2042363 | 2042363 | 2021-12-23 | Audrain | Missouri | 29007 | 4389 | 82 |
2029293 | 2029293 | 2021-12-19 | Covington | Mississippi | 28031 | 4389 | 95 |
2026042 | 2026042 | 2021-12-18 | Covington | Mississippi | 28031 | 4389 | 95 |
2022791 | 2022791 | 2021-12-17 | Covington | Mississippi | 28031 | 4389 | 95 |
2017408 | 2017408 | 2021-12-15 | DeKalb | Tennessee | 47041 | 4389 | 79 |
1983253 | 1983253 | 2021-12-05 | Barton | Kansas | 20009 | 4389 | 68 |
1985300 | 1985300 | 2021-12-05 | Carroll | Virginia | 51035 | 4389 | 105 |
1980003 | 1980003 | 2021-12-04 | Barton | Kansas | 20009 | 4389 | 68 |
1982050 | 1982050 | 2021-12-04 | Carroll | Virginia | 51035 | 4389 | 105 |
1976753 | 1976753 | 2021-12-03 | Barton | Kansas | 20009 | 4389 | 68 |
1978800 | 1978800 | 2021-12-03 | Carroll | Virginia | 51035 | 4389 | 105 |
1946421 | 1946421 | 2021-11-23 | Island | Washington | 53029 | 4389 | 50 |
1897990 | 1897990 | 2021-11-09 | Jackson | Arkansas | 5067 | 4389 | 46 |
1895390 | 1895390 | 2021-11-08 | Wells | Indiana | 18179 | 4389 | 92 |
1876917 | 1876917 | 2021-11-02 | Cibola | New Mexico | 35006 | 4389 | 141 |
1870728 | 1870728 | 2021-10-31 | Pike | Ohio | 39131 | 4389 | 71 |
1832599 | 1832599 | 2021-10-19 | Isle of Wight | Virginia | 51093 | 4389 | 85 |
1828869 | 1828869 | 2021-10-18 | Meade | South Dakota | 46093 | 4389 | 45 |
1809274 | 1809274 | 2021-10-12 | Vega Baja | Puerto Rico | 72145 | 4389 | |
1806024 | 1806024 | 2021-10-11 | Vega Baja | Puerto Rico | 72145 | 4389 | |
1790687 | 1790687 | 2021-10-07 | Winston | Alabama | 1133 | 4389 | 99 |
1751780 | 1751780 | 2021-09-25 | Johnson | Arkansas | 5071 | 4389 | 56 |
1732572 | 1732572 | 2021-09-19 | Decatur | Georgia | 13087 | 4389 | 87 |
1729322 | 1729322 | 2021-09-18 | Decatur | Georgia | 13087 | 4389 | 87 |
1726072 | 1726072 | 2021-09-17 | Decatur | Georgia | 13087 | 4389 | 87 |
1724727 | 1724727 | 2021-09-16 | Arecibo | Puerto Rico | 72013 | 4389 | |
1707379 | 1707379 | 2021-09-11 | Worcester | Maryland | 24047 | 4389 | 110 |
1679531 | 1679531 | 2021-09-02 | White | Tennessee | 47185 | 4389 | 78 |
1625852 | 1625852 | 2021-08-17 | Cowley | Kansas | 20035 | 4389 | 111 |
1622605 | 1622605 | 2021-08-16 | Cowley | Kansas | 20035 | 4389 | 111 |
1622753 | 1622753 | 2021-08-16 | Knox | Kentucky | 21121 | 4389 | 47 |
1580945 | 1580945 | 2021-08-03 | Union | Mississippi | 28145 | 4389 | 79 |
1562830 | 1562830 | 2021-07-28 | Waller | Texas | 48473 | 4389 | 52 |
1491134 | 1491134 | 2021-07-06 | Rhea | Tennessee | 47143 | 4389 | 82 |
1452185 | 1452185 | 2021-06-24 | Rhea | Tennessee | 47143 | 4389 | 82 |
1442598 | 1442598 | 2021-06-21 | Jim Wells | Texas | 48249 | 4389 | 107 |
1439353 | 1439353 | 2021-06-20 | Jim Wells | Texas | 48249 | 4389 | 107 |
1414601 | 1414601 | 2021-06-13 | DeKalb | Indiana | 18033 | 4389 | 88 |
1411356 | 1411356 | 2021-06-12 | DeKalb | Indiana | 18033 | 4389 | 88 |
1402257 | 1402257 | 2021-06-09 | Isanti | Minnesota | 27059 | 4389 | 64 |
1378918 | 1378918 | 2021-06-02 | Harrison | Indiana | 18061 | 4389 | 75 |
1375672 | 1375672 | 2021-06-01 | Harrison | Indiana | 18061 | 4389 | 75 |
1376210 | 1376210 | 2021-06-01 | Hillsdale | Michigan | 26059 | 4389 | 93 |
1332744 | 1332744 | 2021-05-19 | Chilton | Alabama | 1021 | 4389 | 113 |
1329497 | 1329497 | 2021-05-18 | Chilton | Alabama | 1021 | 4389 | 113 |
1328109 | 1328109 | 2021-05-17 | Livingston | New York | 36051 | 4389 | 58 |
1325102 | 1325102 | 2021-05-16 | Madison | Ohio | 39097 | 4389 | 63 |
1270746 | 1270746 | 2021-04-29 | Campbell | Virginia | 51031 | 4389 | 84 |
1265081 | 1265081 | 2021-04-28 | Thomas | Georgia | 13275 | 4389 | 123 |
1223688 | 1223688 | 2021-04-15 | Douglas | Minnesota | 27041 | 4389 | 70 |
1176748 | 1176748 | 2021-03-31 | Mercer | West Virginia | 54055 | 4389 | 123 |
1169861 | 1169861 | 2021-03-29 | Hill | Texas | 48217 | 4389 | 104 |
1151755 | 1151755 | 2021-03-24 | Muscatine | Iowa | 19139 | 4389 | 94 |
1108096 | 1108096 | 2021-03-10 | Chambers | Texas | 48071 | 4389 | 43 |
1104850 | 1104850 | 2021-03-09 | Chambers | Texas | 48071 | 4389 | 43 |
1095651 | 1095651 | 2021-03-06 | Pierce | Wisconsin | 55093 | 4389 | 39 |
1042725 | 1042725 | 2021-02-18 | Osage | Oklahoma | 40113 | 4389 | 44 |
1031280 | 1031280 | 2021-02-15 | Murray | Georgia | 13213 | 4389 | 62 |
1009962 | 1009962 | 2021-02-08 | Sullivan | New York | 36105 | 4389 | 58 |
982836 | 982836 | 2021-01-31 | Jackson | Indiana | 18071 | 4389 | 49 |
979476 | 979476 | 2021-01-30 | Effingham | Illinois | 17049 | 4389 | 75 |
974494 | 974494 | 2021-01-28 | Seneca | Ohio | 39147 | 4389 | 66 |
895091 | 895091 | 2021-01-04 | Coles | Illinois | 17029 | 4389 | 74 |
876854 | 876854 | 2020-12-29 | Chemung | New York | 36015 | 4389 | 94 |
870298 | 870298 | 2020-12-27 | Merrimack | New Hampshire | 33013 | 4389 | 60 |
810229 | 810229 | 2020-12-09 | Garland | Arkansas | 5051 | 4389 | 120 |
744012 | 744012 | 2020-11-18 | Clark | Ohio | 39023 | 4389 | 62 |
679651 | 679651 | 2020-10-29 | Montgomery | Tennessee | 47125 | 4389 | 60 |
623576 | 623576 | 2020-10-12 | Yellowstone | Montana | 30111 | 4389 | 74 |
618600 | 618600 | 2020-10-10 | Kenosha | Wisconsin | 55059 | 4389 | 68 |
541556 | 541556 | 2020-09-17 | McHenry | Illinois | 17111 | 4389 | 119 |
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);