ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
24 rows where deaths = 1844 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 12
- Florida 6
- Maryland 3
- Massachusetts 3
- Pennsylvania 3
- California 2
- Georgia 1
- Indiana 1
- Minnesota 1
- New Jersey 1
- New Mexico 1
- New York 1
- Texas 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2488362 | 2488362 | 2022-05-09 | Bernalillo | New Mexico | 35001 | 148997 | 1844 |
2379281 | 2379281 | 2022-04-06 | Alameda | California | 6001 | 270044 | 1844 |
2293555 | 2293555 | 2022-03-10 | Delaware | Pennsylvania | 42045 | 109118 | 1844 |
2270774 | 2270774 | 2022-03-03 | Bucks | Pennsylvania | 42017 | 121952 | 1844 |
2008714 | 2008714 | 2021-12-13 | Lee | Florida | 12071 | 127007 | 1844 |
2005463 | 2005463 | 2021-12-12 | Lee | Florida | 12071 | 127007 | 1844 |
2002212 | 2002212 | 2021-12-11 | Lee | Florida | 12071 | 127007 | 1844 |
1998962 | 1998962 | 2021-12-10 | Lee | Florida | 12071 | 127007 | 1844 |
1995711 | 1995711 | 2021-12-09 | Lee | Florida | 12071 | 126586 | 1844 |
1992460 | 1992460 | 2021-12-08 | Lee | Florida | 12071 | 126586 | 1844 |
1989302 | 1989302 | 2021-12-07 | Fulton | Georgia | 13121 | 135984 | 1844 |
1873056 | 1873056 | 2021-11-01 | Baltimore | Maryland | 24005 | 76986 | 1844 |
1869807 | 1869807 | 2021-10-31 | Baltimore | Maryland | 24005 | 76930 | 1844 |
1866558 | 1866558 | 2021-10-30 | Baltimore | Maryland | 24005 | 76854 | 1844 |
1742115 | 1742115 | 2021-09-22 | Santa Clara | California | 6085 | 140811 | 1844 |
1701008 | 1701008 | 2021-09-09 | Hennepin | Minnesota | 27053 | 137690 | 1844 |
1669027 | 1669027 | 2021-08-30 | Erie | New York | 36029 | 94435 | 1844 |
1421126 | 1421126 | 2021-06-15 | Marion | Indiana | 18097 | 103331 | 1844 |
1408632 | 1408632 | 2021-06-11 | Suffolk | Massachusetts | 25025 | 92983 | 1844 |
1405387 | 1405387 | 2021-06-10 | Suffolk | Massachusetts | 25025 | 92958 | 1844 |
1159195 | 1159195 | 2021-03-26 | Union | New Jersey | 34039 | 62820 | 1844 |
931405 | 931405 | 2021-01-15 | Essex | Massachusetts | 25009 | 69855 | 1844 |
913338 | 913338 | 2021-01-09 | Bexar | Texas | 48029 | 130459 | 1844 |
608008 | 608008 | 2020-10-07 | Philadelphia | Pennsylvania | 42101 | 38264 | 1844 |
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);