ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
80 rows where cases = 7053 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Illinois 8
- Kentucky 8
- Alabama 6
- Mississippi 5
- Montana 5
- Ohio 5
- Arkansas 4
- Michigan 4
- Minnesota 4
- Texas 4
- Wisconsin 4
- Maryland 3
- New Hampshire 3
- Georgia 2
- Missouri 2
- Puerto Rico 2
- California 1
- Florida 1
- New York 1
- North Carolina 1
- North Dakota 1
- Oklahoma 1
- South Carolina 1
- Tennessee 1
- Virgin Islands 1
- Virginia 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492157 | 2492157 | 2022-05-10 | Cayey | Puerto Rico | 72035 | 7053 | |
2461828 | 2461828 | 2022-05-01 | Cass | Minnesota | 27021 | 7053 | 80 |
2462277 | 2462277 | 2022-05-01 | Coos | New Hampshire | 33007 | 7053 | 113 |
2458572 | 2458572 | 2022-04-30 | Cass | Minnesota | 27021 | 7053 | 80 |
2459021 | 2459021 | 2022-04-30 | Coos | New Hampshire | 33007 | 7053 | 113 |
2455316 | 2455316 | 2022-04-29 | Cass | Minnesota | 27021 | 7053 | 80 |
2455765 | 2455765 | 2022-04-29 | Coos | New Hampshire | 33007 | 7053 | 113 |
2445865 | 2445865 | 2022-04-26 | Ravalli | Montana | 30081 | 7053 | 142 |
2447403 | 2447403 | 2022-04-26 | Lincoln | Wisconsin | 55069 | 7053 | 148 |
2442610 | 2442610 | 2022-04-25 | Ravalli | Montana | 30081 | 7053 | 141 |
2356849 | 2356849 | 2022-03-30 | Toombs | Georgia | 13279 | 7053 | 197 |
2354395 | 2354395 | 2022-03-29 | Wexford | Michigan | 26165 | 7053 | 106 |
2351143 | 2351143 | 2022-03-28 | Wexford | Michigan | 26165 | 7053 | 106 |
2312875 | 2312875 | 2022-03-16 | Hardin | Ohio | 39065 | 7053 | 150 |
2309622 | 2309622 | 2022-03-15 | Hardin | Ohio | 39065 | 7053 | 150 |
2306369 | 2306369 | 2022-03-14 | Hardin | Ohio | 39065 | 7053 | 150 |
2303118 | 2303118 | 2022-03-13 | Hardin | Ohio | 39065 | 7053 | 150 |
2281688 | 2281688 | 2022-03-07 | St. Francis | Arkansas | 5123 | 7053 | 87 |
2282137 | 2282137 | 2022-03-07 | Fayette | Illinois | 17051 | 7053 | 100 |
2282941 | 2282941 | 2022-03-07 | Covington | Mississippi | 28031 | 7053 | 109 |
2278268 | 2278268 | 2022-03-06 | Clarke | Alabama | 1025 | 7053 | 97 |
2278435 | 2278435 | 2022-03-06 | St. Francis | Arkansas | 5123 | 7053 | 87 |
2279688 | 2279688 | 2022-03-06 | Covington | Mississippi | 28031 | 7053 | 109 |
2275015 | 2275015 | 2022-03-05 | Clarke | Alabama | 1025 | 7053 | 97 |
2276435 | 2276435 | 2022-03-05 | Covington | Mississippi | 28031 | 7053 | 109 |
2271762 | 2271762 | 2022-03-04 | Clarke | Alabama | 1025 | 7053 | 97 |
2273182 | 2273182 | 2022-03-04 | Covington | Mississippi | 28031 | 7053 | 109 |
2268510 | 2268510 | 2022-03-03 | Clarke | Alabama | 1025 | 7053 | 96 |
2248668 | 2248668 | 2022-02-24 | St. Thomas | Virgin Islands | 78030 | 7053 | 59 |
2248874 | 2248874 | 2022-02-24 | Nicholas | West Virginia | 54067 | 7053 | 89 |
2222470 | 2222470 | 2022-02-16 | Hopkins | Texas | 48223 | 7053 | 167 |
2214665 | 2214665 | 2022-02-14 | George | Mississippi | 28039 | 7053 | 81 |
2206148 | 2206148 | 2022-02-11 | Cooke | Texas | 48097 | 7053 | 124 |
2170084 | 2170084 | 2022-01-31 | Rio Grande | Puerto Rico | 72119 | 7053 | |
2146466 | 2146466 | 2022-01-24 | Lafayette | Missouri | 29107 | 7053 | 105 |
2108744 | 2108744 | 2022-01-12 | Wharton | Texas | 48481 | 7053 | 193 |
2038267 | 2038267 | 2021-12-22 | Livingston | Illinois | 17105 | 7053 | 125 |
1992245 | 1992245 | 2021-12-08 | Independence | Arkansas | 5063 | 7053 | 165 |
1936901 | 1936901 | 2021-11-21 | Russell | Alabama | 1113 | 7053 | 65 |
1890155 | 1890155 | 2021-11-06 | Williams | North Dakota | 38105 | 7053 | 52 |
1814687 | 1814687 | 2021-10-14 | Tuscola | Michigan | 26157 | 7053 | 188 |
1811439 | 1811439 | 2021-10-13 | Tuscola | Michigan | 26157 | 7053 | 188 |
1745339 | 1745339 | 2021-09-23 | Lassen | California | 6035 | 7053 | 35 |
1732810 | 1732810 | 2021-09-19 | Ogle | Illinois | 17141 | 7053 | 93 |
1729560 | 1729560 | 2021-09-18 | Ogle | Illinois | 17141 | 7053 | 93 |
1726310 | 1726310 | 2021-09-17 | Ogle | Illinois | 17141 | 7053 | 93 |
1724336 | 1724336 | 2021-09-16 | Halifax | North Carolina | 37083 | 7053 | 126 |
1671636 | 1671636 | 2021-08-31 | St. Mary's | Maryland | 24037 | 7053 | 137 |
1630077 | 1630077 | 2021-08-18 | St. Lawrence | New York | 36089 | 7053 | 97 |
1602806 | 1602806 | 2021-08-10 | Boone | Illinois | 17007 | 7053 | 93 |
1460960 | 1460960 | 2021-06-27 | Lewis and Clark | Montana | 30049 | 7053 | 92 |
1457715 | 1457715 | 2021-06-26 | Lewis and Clark | Montana | 30049 | 7053 | 92 |
1454470 | 1454470 | 2021-06-25 | Lewis and Clark | Montana | 30049 | 7053 | 92 |
1450790 | 1450790 | 2021-06-24 | Allegany | Maryland | 24001 | 7053 | 212 |
1424646 | 1424646 | 2021-06-16 | Christian | Kentucky | 21047 | 7053 | 107 |
1356487 | 1356487 | 2021-05-26 | Christian | Kentucky | 21047 | 7053 | 104 |
1353241 | 1353241 | 2021-05-25 | Christian | Kentucky | 21047 | 7053 | 104 |
1349995 | 1349995 | 2021-05-24 | Christian | Kentucky | 21047 | 7053 | 104 |
1346748 | 1346748 | 2021-05-23 | Christian | Kentucky | 21047 | 7053 | 104 |
1343500 | 1343500 | 2021-05-22 | Christian | Kentucky | 21047 | 7053 | 104 |
1340252 | 1340252 | 2021-05-21 | Christian | Kentucky | 21047 | 7053 | 104 |
1337005 | 1337005 | 2021-05-20 | Christian | Kentucky | 21047 | 7053 | 104 |
1264682 | 1264682 | 2021-04-28 | Crawford | Arkansas | 5033 | 7053 | 119 |
1177571 | 1177571 | 2021-04-01 | Williamson | Illinois | 17199 | 7053 | 137 |
1170440 | 1170440 | 2021-03-30 | Walker | Alabama | 1127 | 7053 | 274 |
1158777 | 1158777 | 2021-03-26 | Rice | Minnesota | 27131 | 7053 | 98 |
1134021 | 1134021 | 2021-03-18 | Tipton | Tennessee | 47167 | 7053 | 104 |
1131364 | 1131364 | 2021-03-17 | Portage | Wisconsin | 55097 | 7053 | 67 |
1114801 | 1114801 | 2021-03-12 | Wise | Texas | 48497 | 7053 | 113 |
1108482 | 1108482 | 2021-03-10 | Suffolk city | Virginia | 51800 | 7053 | 171 |
1030762 | 1030762 | 2021-02-14 | Wood | Wisconsin | 55141 | 7053 | 84 |
1016073 | 1016073 | 2021-02-10 | Cass | Missouri | 29037 | 7053 | 73 |
994009 | 994009 | 2021-02-03 | Garfield | Oklahoma | 40047 | 7053 | 63 |
959716 | 959716 | 2021-01-24 | Columbia | Florida | 12023 | 7053 | 139 |
868445 | 868445 | 2020-12-26 | Jefferson | Wisconsin | 55055 | 7053 | 60 |
797539 | 797539 | 2020-12-05 | Columbia | Georgia | 13073 | 7053 | 82 |
799564 | 799564 | 2020-12-05 | Pickens | South Carolina | 45077 | 7053 | 93 |
740829 | 740829 | 2020-11-17 | Stark | Ohio | 39151 | 7053 | 194 |
228336 | 228336 | 2020-06-11 | Kane | Illinois | 17089 | 7053 | 227 |
107865 | 107865 | 2020-05-02 | Prince George's | Maryland | 24033 | 7053 | 269 |
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);