ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
52 rows where cases = 6762 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 20
- Michigan 8
- Alabama 6
- Georgia 5
- North Carolina 5
- Mississippi 3
- Ohio 3
- Virginia 3
- West Virginia 3
- Indiana 2
- Kentucky 2
- New York 2
- Vermont 2
- Arkansas 1
- Florida 1
- Missouri 1
- Montana 1
- New Hampshire 1
- Oklahoma 1
- Pennsylvania 1
- Tennessee 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2468262 | 2468262 | 2022-05-03 | Clare | Michigan | 26035 | 6762 | 157 |
2465007 | 2465007 | 2022-05-02 | Clare | Michigan | 26035 | 6762 | 157 |
2466672 | 2466672 | 2022-05-02 | Windham | Vermont | 50025 | 6762 | 36 |
2461751 | 2461751 | 2022-05-01 | Clare | Michigan | 26035 | 6762 | 157 |
2458495 | 2458495 | 2022-04-30 | Clare | Michigan | 26035 | 6762 | 157 |
2455239 | 2455239 | 2022-04-29 | Clare | Michigan | 26035 | 6762 | 157 |
2451983 | 2451983 | 2022-04-28 | Clare | Michigan | 26035 | 6762 | 157 |
2448727 | 2448727 | 2022-04-27 | Clare | Michigan | 26035 | 6762 | 157 |
2424345 | 2424345 | 2022-04-19 | Windham | Vermont | 50025 | 6762 | 35 |
2252428 | 2252428 | 2022-02-26 | Yell | Arkansas | 5149 | 6762 | 102 |
2236438 | 2236438 | 2022-02-21 | Gilmer | Georgia | 13123 | 6762 | 161 |
2169780 | 2169780 | 2022-01-31 | Gallia | Ohio | 39053 | 6762 | 94 |
2124460 | 2124460 | 2022-01-17 | Susquehanna | Pennsylvania | 42115 | 6762 | 96 |
2104418 | 2104418 | 2022-01-11 | Sullivan | New Hampshire | 33019 | 6762 | 56 |
2078498 | 2078498 | 2022-01-03 | Otsego | New York | 36077 | 6762 | 71 |
2034073 | 2034073 | 2021-12-20 | Danville city | Virginia | 51590 | 6762 | 204 |
2006618 | 2006618 | 2021-12-12 | Camden | Missouri | 29029 | 6762 | 148 |
1993565 | 1993565 | 2021-12-08 | Marshall | Mississippi | 28093 | 6762 | 142 |
1990317 | 1990317 | 2021-12-07 | Neshoba | Mississippi | 28099 | 6762 | 210 |
1944391 | 1944391 | 2021-11-23 | Greenup | Kentucky | 21089 | 6762 | 93 |
1875118 | 1875118 | 2021-11-02 | Covington | Alabama | 1039 | 6762 | 185 |
1873340 | 1873340 | 2021-11-01 | Warren | Mississippi | 28149 | 6762 | 176 |
1858722 | 1858722 | 2021-10-27 | Jefferson | West Virginia | 54037 | 6762 | 85 |
1764500 | 1764500 | 2021-09-28 | Marion | West Virginia | 54049 | 6762 | 71 |
1760111 | 1760111 | 2021-09-27 | Richmond | North Carolina | 37153 | 6762 | 132 |
1750488 | 1750488 | 2021-09-24 | Knox | Ohio | 39083 | 6762 | 122 |
1716643 | 1716643 | 2021-09-14 | Lawrence | Indiana | 18093 | 6762 | 151 |
1709289 | 1709289 | 2021-09-11 | Putnam | West Virginia | 54079 | 6762 | 105 |
1699333 | 1699333 | 2021-09-08 | Albemarle | Virginia | 51003 | 6762 | 85 |
1664425 | 1664425 | 2021-08-29 | Polk | Georgia | 13233 | 6762 | 103 |
1661177 | 1661177 | 2021-08-28 | Polk | Georgia | 13233 | 6762 | 103 |
1657929 | 1657929 | 2021-08-27 | Polk | Georgia | 13233 | 6762 | 103 |
1620402 | 1620402 | 2021-08-15 | Lenoir | North Carolina | 37107 | 6762 | 129 |
1617154 | 1617154 | 2021-08-14 | Lenoir | North Carolina | 37107 | 6762 | 129 |
1613906 | 1613906 | 2021-08-13 | Lenoir | North Carolina | 37107 | 6762 | 129 |
1558649 | 1558649 | 2021-07-27 | Columbus | North Carolina | 37047 | 6762 | 155 |
1338068 | 1338068 | 2021-05-20 | Geauga | Ohio | 39055 | 6762 | 149 |
1318394 | 1318394 | 2021-05-14 | Steuben | New York | 36101 | 6762 | 143 |
1315798 | 1315798 | 2021-05-13 | Cumberland | Tennessee | 47035 | 6762 | 133 |
1272687 | 1272687 | 2021-04-30 | Lewis and Clark | Montana | 30049 | 6762 | 87 |
1251973 | 1251973 | 2021-04-24 | Bulloch | Georgia | 13031 | 6762 | 112 |
1235368 | 1235368 | 2021-04-19 | Jackson | Alabama | 1071 | 6762 | 110 |
1232120 | 1232120 | 2021-04-18 | Jackson | Alabama | 1071 | 6762 | 110 |
1215881 | 1215881 | 2021-04-13 | Jackson | Alabama | 1071 | 6762 | 110 |
1028268 | 1028268 | 2021-02-14 | Grant | Indiana | 18053 | 6762 | 161 |
978912 | 978912 | 2021-01-30 | Talladega | Alabama | 1121 | 6762 | 116 |
975667 | 975667 | 2021-01-29 | Talladega | Alabama | 1121 | 6762 | 116 |
911749 | 911749 | 2021-01-09 | Hardin | Kentucky | 21093 | 6762 | 44 |
855880 | 855880 | 2020-12-23 | Hernando | Florida | 12053 | 6762 | 263 |
705990 | 705990 | 2020-11-06 | Henrico | Virginia | 51087 | 6762 | 240 |
359205 | 359205 | 2020-07-22 | Oklahoma | Oklahoma | 40109 | 6762 | 85 |
31815 | 31815 | 2020-04-04 | Wayne | Michigan | 26163 | 6762 | 252 |
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);