ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where cases = 13471 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 11
- New Hampshire 7
- Minnesota 6
- Indiana 3
- North Carolina 3
- Pennsylvania 3
- Arkansas 2
- Louisiana 2
- Ohio 2
- Tennessee 2
- Wisconsin 2
- Alabama 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2358105 | 2358105 | 2022-03-30 | Belknap | New Hampshire | 33001 | 13471 | 173 |
2354852 | 2354852 | 2022-03-29 | Belknap | New Hampshire | 33001 | 13471 | 173 |
2325174 | 2325174 | 2022-03-20 | Otter Tail | Minnesota | 27111 | 13471 | 164 |
2321920 | 2321920 | 2022-03-19 | Otter Tail | Minnesota | 27111 | 13471 | 164 |
2318666 | 2318666 | 2022-03-18 | Otter Tail | Minnesota | 27111 | 13471 | 164 |
2302986 | 2302986 | 2022-03-13 | McDowell | North Carolina | 37111 | 13471 | 164 |
2299734 | 2299734 | 2022-03-12 | McDowell | North Carolina | 37111 | 13471 | 164 |
2296482 | 2296482 | 2022-03-11 | McDowell | North Carolina | 37111 | 13471 | 164 |
2122317 | 2122317 | 2022-01-17 | Unknown | Arkansas | 13471 | 0 | |
2049497 | 2049497 | 2021-12-25 | Scioto | Ohio | 39145 | 13471 | 194 |
2046247 | 2046247 | 2021-12-24 | Scioto | Ohio | 39145 | 13471 | 194 |
1870389 | 1870389 | 2021-10-31 | Merrimack | New Hampshire | 33013 | 13471 | 131 |
1867140 | 1867140 | 2021-10-30 | Merrimack | New Hampshire | 33013 | 13471 | 131 |
1863891 | 1863891 | 2021-10-29 | Merrimack | New Hampshire | 33013 | 13471 | 131 |
1860642 | 1860642 | 2021-10-28 | Merrimack | New Hampshire | 33013 | 13471 | 131 |
1857393 | 1857393 | 2021-10-27 | Merrimack | New Hampshire | 33013 | 13471 | 131 |
1621828 | 1621828 | 2021-08-16 | Garland | Arkansas | 5051 | 13471 | 292 |
1550941 | 1550941 | 2021-07-25 | Clark | Indiana | 18019 | 13471 | 207 |
1547694 | 1547694 | 2021-07-24 | Clark | Indiana | 18019 | 13471 | 207 |
1544447 | 1544447 | 2021-07-23 | Clark | Indiana | 18019 | 13471 | 207 |
1541646 | 1541646 | 2021-07-22 | Rapides | Louisiana | 22079 | 13471 | 330 |
1536281 | 1536281 | 2021-07-20 | Fayette | Pennsylvania | 42051 | 13471 | 331 |
1533033 | 1533033 | 2021-07-19 | Fayette | Pennsylvania | 42051 | 13471 | 330 |
1528877 | 1528877 | 2021-07-18 | Olmsted | Minnesota | 27109 | 13471 | 102 |
1525630 | 1525630 | 2021-07-17 | Olmsted | Minnesota | 27109 | 13471 | 102 |
1522383 | 1522383 | 2021-07-16 | Olmsted | Minnesota | 27109 | 13471 | 102 |
1338585 | 1338585 | 2021-05-20 | Sevier | Tennessee | 47155 | 13471 | 176 |
1289867 | 1289867 | 2021-05-05 | Maury | Tennessee | 47119 | 13471 | 171 |
1253875 | 1253875 | 2021-04-24 | Monroe | Pennsylvania | 42089 | 13471 | 299 |
1046975 | 1046975 | 2021-02-19 | Sheboygan | Wisconsin | 55117 | 13471 | 134 |
677037 | 677037 | 2020-10-28 | Waukesha | Wisconsin | 55133 | 13471 | 123 |
671734 | 671734 | 2020-10-27 | Orleans | Louisiana | 22071 | 13471 | 592 |
576576 | 576576 | 2020-09-28 | Mobile | Alabama | 1097 | 13471 | 292 |
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);