ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
15 rows where cases = 15479 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 8
- Alabama 3
- Montana 3
- Texas 3
- Michigan 2
- Arkansas 1
- Colorado 1
- New Hampshire 1
- Pennsylvania 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2315310 | 2315310 | 2022-03-17 | Isabella | Michigan | 26073 | 15479 | 202 |
2312057 | 2312057 | 2022-03-16 | Isabella | Michigan | 26073 | 15479 | 202 |
2248991 | 2248991 | 2022-02-25 | Autauga | Alabama | 1001 | 15479 | 194 |
2166073 | 2166073 | 2022-01-30 | Lewis and Clark | Montana | 30049 | 15479 | 162 |
2162818 | 2162818 | 2022-01-29 | Lewis and Clark | Montana | 30049 | 15479 | 162 |
2159563 | 2159563 | 2022-01-28 | Lewis and Clark | Montana | 30049 | 15479 | 162 |
2053900 | 2053900 | 2021-12-27 | Lauderdale | Alabama | 1077 | 15479 | 317 |
1928881 | 1928881 | 2021-11-18 | Merrimack | New Hampshire | 33013 | 15479 | 143 |
1758188 | 1758188 | 2021-09-27 | St. Clair | Alabama | 1115 | 15479 | 305 |
1669836 | 1669836 | 2021-08-30 | Comal | Texas | 48091 | 15479 | 369 |
1666589 | 1666589 | 2021-08-29 | Comal | Texas | 48091 | 15479 | 369 |
1663341 | 1663341 | 2021-08-28 | Comal | Texas | 48091 | 15479 | 369 |
1617505 | 1617505 | 2021-08-14 | Monroe | Pennsylvania | 42089 | 15479 | 323 |
1433533 | 1433533 | 2021-06-19 | Sebastian | Arkansas | 5131 | 15479 | 285 |
1138199 | 1138199 | 2021-03-20 | Pueblo | Colorado | 8101 | 15479 | 365 |
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);