ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
74 rows where cases = 5911 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 29
- Oklahoma 8
- Indiana 7
- Georgia 6
- North Carolina 5
- Puerto Rico 4
- Texas 4
- Wisconsin 4
- Louisiana 3
- Minnesota 3
- Ohio 3
- Tennessee 3
- Arkansas 2
- Florida 2
- Kentucky 2
- Missouri 2
- Pennsylvania 2
- West Virginia 2
- Alabama 1
- Connecticut 1
- Hawaii 1
- Illinois 1
- Maine 1
- Michigan 1
- Mississippi 1
- South Carolina 1
- Vermont 1
- Virginia 1
- Washington 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500339 | 2500339 | 2022-05-13 | Owen | Indiana | 18119 | 5911 | 121 |
2490573 | 2490573 | 2022-05-10 | Randolph | Indiana | 18135 | 5911 | 148 |
2487316 | 2487316 | 2022-05-09 | Randolph | Indiana | 18135 | 5911 | 148 |
2438139 | 2438139 | 2022-04-24 | Emanuel | Georgia | 13107 | 5911 | 158 |
2434883 | 2434883 | 2022-04-23 | Emanuel | Georgia | 13107 | 5911 | 158 |
2431627 | 2431627 | 2022-04-22 | Emanuel | Georgia | 13107 | 5911 | 158 |
2428371 | 2428371 | 2022-04-21 | Emanuel | Georgia | 13107 | 5911 | 158 |
2425115 | 2425115 | 2022-04-20 | Emanuel | Georgia | 13107 | 5911 | 158 |
2374969 | 2374969 | 2022-04-04 | Manati | Puerto Rico | 72091 | 5911 | |
2364022 | 2364022 | 2022-04-01 | Knox | Maine | 23013 | 5911 | 33 |
2221319 | 2221319 | 2022-02-16 | Randolph | Missouri | 29175 | 5911 | 100 |
2218854 | 2218854 | 2022-02-15 | Juncos | Puerto Rico | 72077 | 5911 | |
2212352 | 2212352 | 2022-02-13 | Juncos | Puerto Rico | 72077 | 5911 | |
2189561 | 2189561 | 2022-02-06 | Corozal | Puerto Rico | 72047 | 5911 | |
2126818 | 2126818 | 2022-01-18 | Copiah | Mississippi | 28029 | 5911 | 96 |
2092536 | 2092536 | 2022-01-07 | Franklin | Vermont | 50011 | 5911 | 57 |
2021234 | 2021234 | 2021-12-16 | Marshall | West Virginia | 54051 | 5911 | 130 |
2006251 | 2006251 | 2021-12-12 | Iberville | Louisiana | 22047 | 5911 | 129 |
2003000 | 2003000 | 2021-12-11 | Iberville | Louisiana | 22047 | 5911 | 129 |
1999750 | 1999750 | 2021-12-10 | Iberville | Louisiana | 22047 | 5911 | 129 |
1988140 | 1988140 | 2021-12-06 | Carroll | Tennessee | 47017 | 5911 | 113 |
1968058 | 1968058 | 2021-11-30 | Jackson | North Carolina | 37099 | 5911 | 72 |
1937025 | 1937025 | 2021-11-21 | Union | Arkansas | 5139 | 5911 | 141 |
1928101 | 1928101 | 2021-11-18 | Bell | Kentucky | 21013 | 5911 | 99 |
1834232 | 1834232 | 2021-10-20 | McLeod | Minnesota | 27085 | 5911 | 70 |
1784076 | 1784076 | 2021-10-04 | Pierce | Wisconsin | 55093 | 5911 | 44 |
1735503 | 1735503 | 2021-09-20 | Boone | Arkansas | 5009 | 5911 | 108 |
1737295 | 1737295 | 2021-09-20 | Alexander | North Carolina | 37003 | 5911 | 103 |
1713051 | 1713051 | 2021-09-13 | Bryan | Georgia | 13029 | 5911 | 46 |
1714644 | 1714644 | 2021-09-13 | Watauga | North Carolina | 37189 | 5911 | 34 |
1650819 | 1650819 | 2021-08-24 | Putnam | West Virginia | 54079 | 5911 | 99 |
1627135 | 1627135 | 2021-08-17 | McClain | Oklahoma | 40087 | 5911 | 74 |
1623888 | 1623888 | 2021-08-16 | McClain | Oklahoma | 40087 | 5911 | 74 |
1620641 | 1620641 | 2021-08-15 | McClain | Oklahoma | 40087 | 5911 | 74 |
1617298 | 1617298 | 2021-08-14 | Jefferson | Ohio | 39081 | 5911 | 162 |
1617393 | 1617393 | 2021-08-14 | McClain | Oklahoma | 40087 | 5911 | 74 |
1614145 | 1614145 | 2021-08-13 | McClain | Oklahoma | 40087 | 5911 | 74 |
1610896 | 1610896 | 2021-08-12 | McClain | Oklahoma | 40087 | 5911 | 74 |
1606007 | 1606007 | 2021-08-11 | Maui | Hawaii | 15009 | 5911 | 62 |
1607648 | 1607648 | 2021-08-11 | McClain | Oklahoma | 40087 | 5911 | 74 |
1587289 | 1587289 | 2021-08-05 | Benton | Minnesota | 27009 | 5911 | 98 |
1558103 | 1558103 | 2021-07-27 | Otter Tail | Minnesota | 27111 | 5911 | 87 |
1549085 | 1549085 | 2021-07-24 | Lawrence | Ohio | 39087 | 5911 | 104 |
1534007 | 1534007 | 2021-07-20 | Coffee | Alabama | 1031 | 5911 | 131 |
1533374 | 1533374 | 2021-07-19 | Atascosa | Texas | 48013 | 5911 | 151 |
1528257 | 1528257 | 2021-07-18 | Noble | Indiana | 18113 | 5911 | 93 |
1530127 | 1530127 | 2021-07-18 | Atascosa | Texas | 48013 | 5911 | 151 |
1525010 | 1525010 | 2021-07-17 | Noble | Indiana | 18113 | 5911 | 93 |
1526880 | 1526880 | 2021-07-17 | Atascosa | Texas | 48013 | 5911 | 151 |
1521762 | 1521762 | 2021-07-16 | Noble | Indiana | 18113 | 5911 | 93 |
1516789 | 1516789 | 2021-07-14 | Columbia | Pennsylvania | 42037 | 5911 | 136 |
1417045 | 1417045 | 2021-06-13 | Columbia | Wisconsin | 55021 | 5911 | 71 |
1413799 | 1413799 | 2021-06-12 | Columbia | Wisconsin | 55021 | 5911 | 71 |
1410554 | 1410554 | 2021-06-11 | Columbia | Wisconsin | 55021 | 5911 | 71 |
1387760 | 1387760 | 2021-06-04 | Skagit | Washington | 53057 | 5911 | 74 |
1354805 | 1354805 | 2021-05-25 | Monroe | Tennessee | 47123 | 5911 | 96 |
1351559 | 1351559 | 2021-05-24 | Monroe | Tennessee | 47123 | 5911 | 96 |
1333366 | 1333366 | 2021-05-19 | Grundy | Illinois | 17063 | 5911 | 80 |
1155439 | 1155439 | 2021-03-25 | Montcalm | Michigan | 26117 | 5911 | 97 |
1090270 | 1090270 | 2021-03-05 | Laurel | Kentucky | 21125 | 5911 | 31 |
1083081 | 1083081 | 2021-03-03 | Monroe | Florida | 12087 | 5911 | 46 |
1076946 | 1076946 | 2021-03-01 | Dubois | Indiana | 18037 | 5911 | 112 |
1078378 | 1078378 | 2021-03-01 | Bryan | Oklahoma | 40013 | 5911 | 55 |
1071865 | 1071865 | 2021-02-27 | Scioto | Ohio | 39145 | 5911 | 104 |
1058752 | 1058752 | 2021-02-23 | Wilkes | North Carolina | 37193 | 5911 | 101 |
994554 | 994554 | 2021-02-03 | Hale | Texas | 48189 | 5911 | 147 |
927243 | 927243 | 2021-01-14 | Tolland | Connecticut | 9013 | 5911 | 122 |
837659 | 837659 | 2020-12-17 | St. Francois | Missouri | 29187 | 5911 | 58 |
826312 | 826312 | 2020-12-13 | Natrona | Wyoming | 56025 | 5911 | 62 |
715175 | 715175 | 2020-11-09 | Florence | South Carolina | 45041 | 5911 | 205 |
705319 | 705319 | 2020-11-06 | Northampton | Pennsylvania | 42095 | 5911 | 317 |
637864 | 637864 | 2020-10-16 | Henrico | Virginia | 51087 | 5911 | 222 |
436167 | 436167 | 2020-08-15 | Guilford | North Carolina | 37081 | 5911 | 158 |
373444 | 373444 | 2020-07-27 | Pasco | Florida | 12101 | 5911 | 68 |
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);