ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
62 rows where cases = 7101 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- North Carolina 12
- Alabama 5
- Louisiana 5
- Michigan 5
- Georgia 4
- Minnesota 3
- Mississippi 3
- Ohio 3
- Pennsylvania 3
- Texas 3
- Virginia 3
- Missouri 2
- Florida 1
- Idaho 1
- Illinois 1
- Indiana 1
- Maine 1
- New Mexico 1
- Oregon 1
- Puerto Rico 1
- Tennessee 1
- West Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2491141 | 2491141 | 2022-05-10 | Cass | Minnesota | 27021 | 7101 | 81 |
2475852 | 2475852 | 2022-05-05 | Aguada | Puerto Rico | 72003 | 7101 | |
2468929 | 2468929 | 2022-05-03 | Cherokee | North Carolina | 37039 | 7101 | 118 |
2465673 | 2465673 | 2022-05-02 | Cherokee | North Carolina | 37039 | 7101 | 118 |
2462418 | 2462418 | 2022-05-01 | Cherokee | North Carolina | 37039 | 7101 | 118 |
2459162 | 2459162 | 2022-04-30 | Cherokee | North Carolina | 37039 | 7101 | 118 |
2455906 | 2455906 | 2022-04-29 | Cherokee | North Carolina | 37039 | 7101 | 118 |
2452650 | 2452650 | 2022-04-28 | Cherokee | North Carolina | 37039 | 7101 | 118 |
2449394 | 2449394 | 2022-04-27 | Cherokee | North Carolina | 37039 | 7101 | 118 |
2371263 | 2371263 | 2022-04-03 | Cherokee | North Carolina | 37039 | 7101 | 117 |
2368010 | 2368010 | 2022-04-02 | Cherokee | North Carolina | 37039 | 7101 | 117 |
2364757 | 2364757 | 2022-04-01 | Cherokee | North Carolina | 37039 | 7101 | 117 |
2359587 | 2359587 | 2022-03-31 | Clarke | Alabama | 1025 | 7101 | 99 |
2313069 | 2313069 | 2022-03-16 | Elk | Pennsylvania | 42047 | 7101 | 97 |
2282940 | 2282940 | 2022-03-07 | Copiah | Mississippi | 28029 | 7101 | 114 |
2269138 | 2269138 | 2022-03-03 | Iroquois | Illinois | 17075 | 7101 | 113 |
2247175 | 2247175 | 2022-02-24 | George | Mississippi | 28039 | 7101 | 86 |
2223466 | 2223466 | 2022-02-17 | Lumpkin | Georgia | 13187 | 7101 | 121 |
2212958 | 2212958 | 2022-02-13 | Gloucester | Virginia | 51073 | 7101 | 95 |
2209705 | 2209705 | 2022-02-12 | Gloucester | Virginia | 51073 | 7101 | 95 |
2206452 | 2206452 | 2022-02-11 | Gloucester | Virginia | 51073 | 7101 | 95 |
2194894 | 2194894 | 2022-02-08 | West Baton Rouge | Louisiana | 22121 | 7101 | 82 |
2161057 | 2161057 | 2022-01-28 | Mineral | West Virginia | 54057 | 7101 | 143 |
2141704 | 2141704 | 2022-01-23 | Marion | Alabama | 1093 | 7101 | 134 |
2087858 | 2087858 | 2022-01-06 | Union | Mississippi | 28145 | 7101 | 100 |
2065927 | 2065927 | 2021-12-30 | Pike | Pennsylvania | 42103 | 7101 | 73 |
2062471 | 2062471 | 2021-12-29 | Madison | Ohio | 39097 | 7101 | 99 |
2058299 | 2058299 | 2021-12-28 | Aroostook | Maine | 23003 | 7101 | 101 |
1988862 | 1988862 | 2021-12-07 | Chilton | Alabama | 1021 | 7101 | 171 |
1975908 | 1975908 | 2021-12-03 | Russell | Alabama | 1113 | 7101 | 65 |
1971423 | 1971423 | 2021-12-01 | Brown | Ohio | 39015 | 7101 | 115 |
1925980 | 1925980 | 2021-11-17 | Shelby | Ohio | 39149 | 7101 | 130 |
1875839 | 1875839 | 2021-11-02 | Jackson | Indiana | 18071 | 7101 | 95 |
1832359 | 1832359 | 2021-10-19 | Jim Wells | Texas | 48249 | 7101 | 173 |
1812372 | 1812372 | 2021-10-13 | Polk | Oregon | 41053 | 7101 | 80 |
1655535 | 1655535 | 2021-08-26 | Kandiyohi | Minnesota | 27067 | 7101 | 87 |
1642453 | 1642453 | 2021-08-22 | Gratiot | Michigan | 26057 | 7101 | 125 |
1639203 | 1639203 | 2021-08-21 | Gratiot | Michigan | 26057 | 7101 | 125 |
1635953 | 1635953 | 2021-08-20 | Gratiot | Michigan | 26057 | 7101 | 125 |
1634005 | 1634005 | 2021-08-19 | Jefferson | Tennessee | 47089 | 7101 | 130 |
1607006 | 1607006 | 2021-08-11 | Lincoln | Missouri | 29113 | 7101 | 54 |
1557128 | 1557128 | 2021-07-27 | Bulloch | Georgia | 13031 | 7101 | 122 |
1551349 | 1551349 | 2021-07-25 | Acadia | Louisiana | 22001 | 7101 | 198 |
1548102 | 1548102 | 2021-07-24 | Acadia | Louisiana | 22001 | 7101 | 198 |
1544855 | 1544855 | 2021-07-23 | Acadia | Louisiana | 22001 | 7101 | 198 |
1542307 | 1542307 | 2021-07-22 | Eddy | New Mexico | 35015 | 7101 | 143 |
1385997 | 1385997 | 2021-06-04 | Van Buren | Michigan | 26159 | 7101 | 128 |
1244126 | 1244126 | 2021-04-21 | Lawrence | Pennsylvania | 42073 | 7101 | 200 |
1235921 | 1235921 | 2021-04-19 | Madison | Idaho | 16065 | 7101 | 24 |
1234758 | 1234758 | 2021-04-18 | Coryell | Texas | 48099 | 7101 | 85 |
1231510 | 1231510 | 2021-04-17 | Coryell | Texas | 48099 | 7101 | 85 |
1219157 | 1219157 | 2021-04-14 | Walker | Alabama | 1127 | 7101 | 275 |
1168521 | 1168521 | 2021-03-29 | Rice | Minnesota | 27131 | 7101 | 98 |
1133398 | 1133398 | 2021-03-18 | Stanly | North Carolina | 37167 | 7101 | 112 |
1090482 | 1090482 | 2021-03-05 | Ionia | Michigan | 26067 | 7101 | 76 |
1050607 | 1050607 | 2021-02-21 | Highlands | Florida | 12055 | 7101 | 298 |
836499 | 836499 | 2020-12-17 | Douglas | Georgia | 13097 | 7101 | 103 |
824235 | 824235 | 2020-12-13 | Rapides | Louisiana | 22079 | 7101 | 201 |
743917 | 743917 | 2020-11-18 | Pitt | North Carolina | 37147 | 7101 | 44 |
745124 | 745124 | 2020-11-18 | La Crosse | Wisconsin | 55063 | 7101 | 31 |
704516 | 704516 | 2020-11-06 | Boone | Missouri | 29019 | 7101 | 18 |
573794 | 573794 | 2020-09-27 | Richmond | Georgia | 13245 | 7101 | 162 |
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);