ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45 rows where cases = 8461 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500182 | 2500182 | 2022-05-13 | Bureau | Illinois | 17011 | 8461 | 140 |
2423717 | 2423717 | 2022-04-19 | Greene | Pennsylvania | 42059 | 8461 | 104 |
2372056 | 2372056 | 2022-04-03 | Grimes | Texas | 48185 | 8461 | 119 |
2354730 | 2354730 | 2022-03-29 | Silver Bow | Montana | 30093 | 8461 | 130 |
2349764 | 2349764 | 2022-03-27 | Oneida | Wisconsin | 55085 | 8461 | 135 |
2346511 | 2346511 | 2022-03-26 | Oneida | Wisconsin | 55085 | 8461 | 135 |
2343258 | 2343258 | 2022-03-25 | Oneida | Wisconsin | 55085 | 8461 | 135 |
2340005 | 2340005 | 2022-03-24 | Oneida | Wisconsin | 55085 | 8461 | 135 |
2163465 | 2163465 | 2022-01-29 | Clinton | Pennsylvania | 42035 | 8461 | 117 |
2107986 | 2107986 | 2022-01-12 | Logan | Ohio | 39091 | 8461 | 137 |
2058292 | 2058292 | 2021-12-28 | Washington | Louisiana | 22117 | 8461 | 222 |
2055210 | 2055210 | 2021-12-27 | Douglas | Minnesota | 27041 | 8461 | 102 |
2036235 | 2036235 | 2021-12-21 | Madison | New York | 36053 | 8461 | 113 |
2006363 | 2006363 | 2021-12-12 | Cass | Michigan | 26027 | 8461 | 108 |
2003112 | 2003112 | 2021-12-11 | Cass | Michigan | 26027 | 8461 | 108 |
1999862 | 1999862 | 2021-12-10 | Cass | Michigan | 26027 | 8461 | 108 |
1833364 | 1833364 | 2021-10-20 | Polk | Georgia | 13233 | 8461 | 149 |
1825076 | 1825076 | 2021-10-17 | McDowell | North Carolina | 37111 | 8461 | 121 |
1821827 | 1821827 | 2021-10-16 | McDowell | North Carolina | 37111 | 8461 | 121 |
1818578 | 1818578 | 2021-10-15 | McDowell | North Carolina | 37111 | 8461 | 121 |
1812381 | 1812381 | 2021-10-13 | Yamhill | Oregon | 41071 | 8461 | 109 |
1782964 | 1782964 | 2021-10-04 | Geauga | Ohio | 39055 | 8461 | 158 |
1769068 | 1769068 | 2021-09-30 | Kennebec | Maine | 23011 | 8461 | 91 |
1721033 | 1721033 | 2021-09-15 | St. Lawrence | New York | 36089 | 8461 | 111 |
1710158 | 1710158 | 2021-09-12 | Morgan | Indiana | 18109 | 8461 | 160 |
1706911 | 1706911 | 2021-09-11 | Morgan | Indiana | 18109 | 8461 | 160 |
1703663 | 1703663 | 2021-09-10 | Morgan | Indiana | 18109 | 8461 | 160 |
1695011 | 1695011 | 2021-09-07 | Chemung | New York | 36015 | 8461 | 141 |
1289421 | 1289421 | 2021-05-05 | Tuscarawas | Ohio | 39157 | 8461 | 243 |
1247931 | 1247931 | 2021-04-22 | Victoria | Texas | 48469 | 8461 | 201 |
1107646 | 1107646 | 2021-03-10 | Payne | Oklahoma | 40119 | 8461 | 49 |
1048930 | 1048930 | 2021-02-20 | Caldwell | North Carolina | 37027 | 8461 | 66 |
988908 | 988908 | 2021-02-02 | Windham | Connecticut | 9015 | 8461 | 149 |
941907 | 941907 | 2021-01-18 | Wayne | North Carolina | 37191 | 8461 | 168 |
938662 | 938662 | 2021-01-17 | Wayne | North Carolina | 37191 | 8461 | 168 |
898119 | 898119 | 2021-01-05 | Bartow | Georgia | 13015 | 8461 | 131 |
888225 | 888225 | 2021-01-02 | Yolo | California | 6113 | 8461 | 117 |
826448 | 826448 | 2020-12-14 | Craighead | Arkansas | 5031 | 8461 | 105 |
768673 | 768673 | 2020-11-26 | Porter | Indiana | 18127 | 8461 | 89 |
706574 | 706574 | 2020-11-07 | Sussex | Delaware | 10005 | 8461 | 240 |
684680 | 684680 | 2020-10-31 | Calcasieu | Louisiana | 22019 | 8461 | 230 |
681437 | 681437 | 2020-10-30 | Calcasieu | Louisiana | 22019 | 8461 | 230 |
660244 | 660244 | 2020-10-23 | Brazos | Texas | 48041 | 8461 | 66 |
542666 | 542666 | 2020-09-17 | Washoe | Nevada | 32031 | 8461 | 153 |
283540 | 283540 | 2020-06-28 | Travis | Texas | 48453 | 8461 | 117 |
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);