ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
29 rows where deaths = 1901 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 9
- Massachusetts 9
- Florida 7
- California 3
- Texas 3
- New Jersey 2
- Pennsylvania 2
- Georgia 1
- Indiana 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500816 | 2500816 | 2022-05-13 | Norfolk | Massachusetts | 25021 | 141128 | 1901 |
2497558 | 2497558 | 2022-05-12 | Norfolk | Massachusetts | 25021 | 140637 | 1901 |
2494300 | 2494300 | 2022-05-11 | Norfolk | Massachusetts | 25021 | 140123 | 1901 |
2198205 | 2198205 | 2022-02-09 | Plymouth | Massachusetts | 25023 | 112765 | 1901 |
2171299 | 2171299 | 2022-02-01 | Lee | Florida | 12071 | 175773 | 1901 |
2168046 | 2168046 | 2022-01-31 | Lee | Florida | 12071 | 175773 | 1901 |
2164791 | 2164791 | 2022-01-30 | Lee | Florida | 12071 | 175773 | 1901 |
2161536 | 2161536 | 2022-01-29 | Lee | Florida | 12071 | 175773 | 1901 |
2158280 | 2158280 | 2022-01-28 | Lee | Florida | 12071 | 175773 | 1901 |
2155027 | 2155027 | 2022-01-27 | Lee | Florida | 12071 | 168971 | 1901 |
2151774 | 2151774 | 2022-01-26 | Lee | Florida | 12071 | 168971 | 1901 |
2103077 | 2103077 | 2022-01-11 | Fulton | Georgia | 13121 | 182536 | 1901 |
2034564 | 2034564 | 2021-12-21 | Kern | California | 6029 | 161760 | 1901 |
1993342 | 1993342 | 2021-12-08 | Norfolk | Massachusetts | 25021 | 71595 | 1901 |
1804858 | 1804858 | 2021-10-11 | Suffolk | Massachusetts | 25025 | 105356 | 1901 |
1801609 | 1801609 | 2021-10-10 | Suffolk | Massachusetts | 25025 | 105356 | 1901 |
1798360 | 1798360 | 2021-10-09 | Suffolk | Massachusetts | 25025 | 105356 | 1901 |
1795111 | 1795111 | 2021-10-08 | Suffolk | Massachusetts | 25025 | 105356 | 1901 |
1783951 | 1783951 | 2021-10-04 | King | Washington | 53033 | 153568 | 1901 |
1773781 | 1773781 | 2021-10-01 | Cameron | Texas | 48061 | 63769 | 1901 |
1770531 | 1770531 | 2021-09-30 | Cameron | Texas | 48061 | 63628 | 1901 |
1767282 | 1767282 | 2021-09-29 | Cameron | Texas | 48061 | 63553 | 1901 |
1625691 | 1625691 | 2021-08-17 | Marion | Indiana | 18097 | 111070 | 1901 |
1321554 | 1321554 | 2021-05-15 | Passaic | New Jersey | 34031 | 72335 | 1901 |
1283055 | 1283055 | 2021-05-03 | Allegheny | Pennsylvania | 42003 | 97975 | 1901 |
1279808 | 1279808 | 2021-05-02 | Allegheny | Pennsylvania | 42003 | 97760 | 1901 |
1240390 | 1240390 | 2021-04-20 | Union | New Jersey | 34039 | 69121 | 1901 |
891445 | 891445 | 2021-01-03 | Orange | California | 6059 | 170802 | 1901 |
888198 | 888198 | 2021-01-02 | Orange | California | 6059 | 170802 | 1901 |
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);