ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
23 rows where cases = 16609 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 9
- North Carolina 6
- Michigan 5
- Georgia 3
- Kentucky 3
- Idaho 2
- District of Columbia 1
- Montana 1
- New Jersey 1
- Ohio 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2260680 | 2260680 | 2022-02-28 | Duplin | North Carolina | 37061 | 16609 | 230 |
2217752 | 2217752 | 2022-02-15 | Grand Traverse | Michigan | 26055 | 16609 | 205 |
2214501 | 2214501 | 2022-02-14 | Grand Traverse | Michigan | 26055 | 16609 | 205 |
2165753 | 2165753 | 2022-01-30 | Shiawassee | Michigan | 26155 | 16609 | 211 |
2162498 | 2162498 | 2022-01-29 | Shiawassee | Michigan | 26155 | 16609 | 211 |
2159243 | 2159243 | 2022-01-28 | Shiawassee | Michigan | 26155 | 16609 | 211 |
2080334 | 2080334 | 2022-01-04 | Jackson | Georgia | 13157 | 16609 | 238 |
1982951 | 1982951 | 2021-12-05 | Twin Falls | Idaho | 16083 | 16609 | 234 |
1979701 | 1979701 | 2021-12-04 | Twin Falls | Idaho | 16083 | 16609 | 234 |
1940507 | 1940507 | 2021-11-22 | Carroll | Georgia | 13045 | 16609 | 333 |
1922509 | 1922509 | 2021-11-16 | Brunswick | North Carolina | 37019 | 16609 | 243 |
1824143 | 1824143 | 2021-10-17 | Daviess | Kentucky | 21059 | 16609 | 259 |
1820894 | 1820894 | 2021-10-16 | Daviess | Kentucky | 21059 | 16609 | 259 |
1817645 | 1817645 | 2021-10-15 | Daviess | Kentucky | 21059 | 16609 | 259 |
1631852 | 1631852 | 2021-08-19 | Clarke | Georgia | 13059 | 16609 | 151 |
1490673 | 1490673 | 2021-07-06 | Trumbull | Ohio | 39155 | 16609 | 485 |
1373673 | 1373673 | 2021-05-31 | Robeson | North Carolina | 37155 | 16609 | 244 |
1370428 | 1370428 | 2021-05-30 | Robeson | North Carolina | 37155 | 16609 | 244 |
1367182 | 1367182 | 2021-05-29 | Robeson | North Carolina | 37155 | 16609 | 244 |
1363936 | 1363936 | 2021-05-28 | Robeson | North Carolina | 37155 | 16609 | 244 |
1155807 | 1155807 | 2021-03-25 | Yellowstone | Montana | 30111 | 16609 | 246 |
657925 | 657925 | 2020-10-23 | District of Columbia | District of Columbia | 11001 | 16609 | 642 |
122919 | 122919 | 2020-05-07 | Bergen | New Jersey | 34003 | 16609 | 1319 |
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);