ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where cases = 5549 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 28
- Missouri 9
- Illinois 8
- Indiana 4
- Kentucky 4
- Michigan 4
- Arkansas 3
- Mississippi 3
- North Carolina 3
- Puerto Rico 3
- Tennessee 3
- California 2
- Georgia 2
- Louisiana 2
- Wisconsin 2
- Wyoming 2
- Alaska 1
- Arizona 1
- Idaho 1
- Iowa 1
- New Jersey 1
- New Mexico 1
- New York 1
- Ohio 1
- Pennsylvania 1
- South Dakota 1
- Texas 1
- Virginia 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2453847 | 2453847 | 2022-04-28 | Lincoln | West Virginia | 54043 | 5549 | 81 |
2308649 | 2308649 | 2022-03-15 | Assumption | Louisiana | 22007 | 5549 | 69 |
2305398 | 2305398 | 2022-03-14 | Assumption | Louisiana | 22007 | 5549 | 69 |
2279259 | 2279259 | 2022-03-06 | Adair | Kentucky | 21001 | 5549 | 99 |
2276006 | 2276006 | 2022-03-05 | Adair | Kentucky | 21001 | 5549 | 99 |
2272753 | 2272753 | 2022-03-04 | Adair | Kentucky | 21001 | 5549 | 99 |
2251699 | 2251699 | 2022-02-25 | Frio | Texas | 48163 | 5549 | 90 |
2199317 | 2199317 | 2022-02-09 | Cayey | Puerto Rico | 72035 | 5549 | |
2192830 | 2192830 | 2022-02-07 | Juana Diaz | Puerto Rico | 72075 | 5549 | |
2176106 | 2176106 | 2022-02-02 | Ashe | North Carolina | 37009 | 5549 | 67 |
2137505 | 2137505 | 2022-01-21 | Corozal | Puerto Rico | 72047 | 5549 | |
2089799 | 2089799 | 2022-01-07 | St. Francis | Arkansas | 5123 | 5549 | 74 |
2077656 | 2077656 | 2022-01-03 | Grant | Kentucky | 21081 | 5549 | 46 |
2039166 | 2039166 | 2021-12-22 | Lafayette | Missouri | 29107 | 5549 | 91 |
2040859 | 2040859 | 2021-12-22 | Teton | Wyoming | 56039 | 5549 | 14 |
1967655 | 1967655 | 2021-11-30 | Laclede | Missouri | 29105 | 5549 | 148 |
1966069 | 1966069 | 2021-11-29 | Trempealeau | Wisconsin | 55121 | 5549 | 52 |
1960230 | 1960230 | 2021-11-28 | Fulton | Illinois | 17057 | 5549 | 93 |
1961184 | 1961184 | 2021-11-28 | Pulaski | Missouri | 29169 | 5549 | 97 |
1956979 | 1956979 | 2021-11-27 | Fulton | Illinois | 17057 | 5549 | 93 |
1957933 | 1957933 | 2021-11-27 | Pulaski | Missouri | 29169 | 5549 | 97 |
1953728 | 1953728 | 2021-11-26 | Fulton | Illinois | 17057 | 5549 | 93 |
1954682 | 1954682 | 2021-11-26 | Pulaski | Missouri | 29169 | 5549 | 97 |
1950477 | 1950477 | 2021-11-25 | Fulton | Illinois | 17057 | 5549 | 93 |
1951431 | 1951431 | 2021-11-25 | Pulaski | Missouri | 29169 | 5549 | 97 |
1947226 | 1947226 | 2021-11-24 | Fulton | Illinois | 17057 | 5549 | 93 |
1948180 | 1948180 | 2021-11-24 | Pulaski | Missouri | 29169 | 5549 | 97 |
1919651 | 1919651 | 2021-11-15 | McKean | Pennsylvania | 42083 | 5549 | 97 |
1852922 | 1852922 | 2021-10-26 | Bonner | Idaho | 16017 | 5549 | 94 |
1854832 | 1854832 | 2021-10-26 | Codington | South Dakota | 46029 | 5549 | 84 |
1824376 | 1824376 | 2021-10-17 | Delta | Michigan | 26041 | 5549 | 103 |
1821127 | 1821127 | 2021-10-16 | Delta | Michigan | 26041 | 5549 | 103 |
1817878 | 1817878 | 2021-10-15 | Delta | Michigan | 26041 | 5549 | 103 |
1772737 | 1772737 | 2021-10-01 | Webster | Missouri | 29225 | 5549 | 86 |
1725584 | 1725584 | 2021-09-16 | Monroe | Wisconsin | 55081 | 5549 | 54 |
1719253 | 1719253 | 2021-09-15 | Baxter | Arkansas | 5005 | 5549 | 163 |
1665340 | 1665340 | 2021-08-29 | Bolivar | Mississippi | 28011 | 5549 | 140 |
1662092 | 1662092 | 2021-08-28 | Bolivar | Mississippi | 28011 | 5549 | 140 |
1658844 | 1658844 | 2021-08-27 | Bolivar | Mississippi | 28011 | 5549 | 140 |
1649191 | 1649191 | 2021-08-24 | Camden | Missouri | 29029 | 5549 | 111 |
1602279 | 1602279 | 2021-08-10 | Kenai Peninsula Borough | Alaska | 2122 | 5549 | 20 |
1605431 | 1605431 | 2021-08-10 | Campbell | Wyoming | 56005 | 5549 | 64 |
1581291 | 1581291 | 2021-08-03 | Otero | New Mexico | 35035 | 5549 | 86 |
1537663 | 1537663 | 2021-07-21 | Coffee | Georgia | 13069 | 5549 | 181 |
1314507 | 1314507 | 2021-05-13 | Branch | Michigan | 26023 | 5549 | 120 |
1310825 | 1310825 | 2021-05-12 | Clinton | Iowa | 19045 | 5549 | 93 |
1299124 | 1299124 | 2021-05-08 | Lawrence | Ohio | 39087 | 5549 | 102 |
1281550 | 1281550 | 2021-05-03 | Noble | Indiana | 18113 | 5549 | 86 |
1274396 | 1274396 | 2021-05-01 | Graham | Arizona | 4009 | 5549 | 78 |
1259929 | 1259929 | 2021-04-26 | Jefferson | New York | 36045 | 5549 | 65 |
1200110 | 1200110 | 2021-04-08 | Polk | Georgia | 13233 | 5549 | 89 |
1197027 | 1197027 | 2021-04-07 | Ogle | Illinois | 17141 | 5549 | 86 |
1172319 | 1172319 | 2021-03-30 | Granville | North Carolina | 37077 | 5549 | 79 |
1138656 | 1138656 | 2021-03-20 | Marshall | Indiana | 18099 | 5549 | 107 |
1128881 | 1128881 | 2021-03-17 | Dearborn | Indiana | 18029 | 5549 | 75 |
1125635 | 1125635 | 2021-03-16 | Dearborn | Indiana | 18029 | 5549 | 75 |
1063399 | 1063399 | 2021-02-25 | Mississippi | Arkansas | 5093 | 5549 | 112 |
1000928 | 1000928 | 2021-02-05 | Roane | Tennessee | 47145 | 5549 | 96 |
943757 | 943757 | 2021-01-19 | Boone | Illinois | 17007 | 5549 | 77 |
850957 | 850957 | 2020-12-21 | Burke | North Carolina | 37023 | 5549 | 74 |
807091 | 807091 | 2020-12-08 | Yolo | California | 6113 | 5549 | 84 |
760754 | 760754 | 2020-11-23 | Maury | Tennessee | 47119 | 5549 | 58 |
595705 | 595705 | 2020-10-03 | Henrico | Virginia | 51087 | 5549 | 219 |
470425 | 470425 | 2020-08-26 | St. Clair | Illinois | 17163 | 5549 | 174 |
391689 | 391689 | 2020-08-01 | Hamilton | Tennessee | 47065 | 5549 | 48 |
268411 | 268411 | 2020-06-24 | Imperial | California | 6025 | 5549 | 69 |
114114 | 114114 | 2020-05-04 | Morris | New Jersey | 34027 | 5549 | 449 |
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);