ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
29 rows where deaths = 1834 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 9
- Massachusetts 13
- Kentucky 5
- California 2
- Georgia 2
- Indiana 2
- Tennessee 2
- Michigan 1
- New York 1
- Pennsylvania 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500325 | 2500325 | 2022-05-13 | Lake | Indiana | 18089 | 108660 | 1834 |
2165674 | 2165674 | 2022-01-30 | Plymouth | Massachusetts | 25023 | 110264 | 1834 |
2162419 | 2162419 | 2022-01-29 | Plymouth | Massachusetts | 25023 | 110264 | 1834 |
2159164 | 2159164 | 2022-01-28 | Plymouth | Massachusetts | 25023 | 110264 | 1834 |
2074420 | 2074420 | 2022-01-02 | Jefferson | Kentucky | 21111 | 144121 | 1834 |
2071169 | 2071169 | 2022-01-01 | Jefferson | Kentucky | 21111 | 143268 | 1834 |
2067918 | 2067918 | 2021-12-31 | Jefferson | Kentucky | 21111 | 141826 | 1834 |
2064667 | 2064667 | 2021-12-30 | Jefferson | Kentucky | 21111 | 139490 | 1834 |
2061417 | 2061417 | 2021-12-29 | Jefferson | Kentucky | 21111 | 138406 | 1834 |
1973053 | 1973053 | 2021-12-02 | Fulton | Georgia | 13121 | 135380 | 1834 |
1969803 | 1969803 | 2021-12-01 | Fulton | Georgia | 13121 | 135211 | 1834 |
1835169 | 1835169 | 2021-10-20 | Montgomery | Pennsylvania | 42091 | 84226 | 1834 |
1736627 | 1736627 | 2021-09-20 | Norfolk | Massachusetts | 25021 | 60967 | 1834 |
1733377 | 1733377 | 2021-09-19 | Norfolk | Massachusetts | 25021 | 60682 | 1834 |
1730127 | 1730127 | 2021-09-18 | Norfolk | Massachusetts | 25021 | 60682 | 1834 |
1726877 | 1726877 | 2021-09-17 | Norfolk | Massachusetts | 25021 | 60682 | 1834 |
1722618 | 1722618 | 2021-09-16 | Santa Clara | California | 6085 | 139564 | 1834 |
1653534 | 1653534 | 2021-08-25 | Shelby | Tennessee | 47157 | 121506 | 1834 |
1650287 | 1650287 | 2021-08-24 | Shelby | Tennessee | 47157 | 120984 | 1834 |
1639792 | 1639792 | 2021-08-21 | Erie | New York | 36029 | 93015 | 1834 |
1628406 | 1628406 | 2021-08-18 | Sacramento | California | 6067 | 127580 | 1834 |
1408145 | 1408145 | 2021-06-11 | Marion | Indiana | 18097 | 103183 | 1834 |
1353456 | 1353456 | 2021-05-25 | Suffolk | Massachusetts | 25025 | 92571 | 1834 |
1350210 | 1350210 | 2021-05-24 | Suffolk | Massachusetts | 25025 | 92556 | 1834 |
1333973 | 1333973 | 2021-05-19 | Suffolk | Massachusetts | 25025 | 92313 | 1834 |
1330726 | 1330726 | 2021-05-18 | Suffolk | Massachusetts | 25025 | 92264 | 1834 |
1327479 | 1327479 | 2021-05-17 | Suffolk | Massachusetts | 25025 | 92228 | 1834 |
983340 | 983340 | 2021-01-31 | Worcester | Massachusetts | 25027 | 59449 | 1834 |
967163 | 967163 | 2021-01-26 | Macomb | Michigan | 26099 | 55605 | 1834 |
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);