ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
37 rows where deaths = 1865 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 8
- Florida 9
- Massachusetts 9
- Georgia 6
- California 4
- New Jersey 4
- Michigan 2
- Pennsylvania 2
- Maryland 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2493246 | 2493246 | 2022-05-11 | Alameda | California | 6001 | 282539 | 1865 |
2424859 | 2424859 | 2022-04-20 | Alameda | California | 6001 | 273111 | 1865 |
2421873 | 2421873 | 2022-04-19 | Gwinnett | Georgia | 13135 | 208139 | 1865 |
2418617 | 2418617 | 2022-04-18 | Gwinnett | Georgia | 13135 | 208139 | 1865 |
2415361 | 2415361 | 2022-04-17 | Gwinnett | Georgia | 13135 | 208133 | 1865 |
2412105 | 2412105 | 2022-04-16 | Gwinnett | Georgia | 13135 | 208133 | 1865 |
2408849 | 2408849 | 2022-04-15 | Gwinnett | Georgia | 13135 | 208133 | 1865 |
2325030 | 2325030 | 2022-03-20 | Norfolk | Massachusetts | 25021 | 129860 | 1865 |
2321776 | 2321776 | 2022-03-19 | Norfolk | Massachusetts | 25021 | 129860 | 1865 |
2318522 | 2318522 | 2022-03-18 | Norfolk | Massachusetts | 25021 | 129860 | 1865 |
2293568 | 2293568 | 2022-03-10 | Lancaster | Pennsylvania | 42071 | 120391 | 1865 |
2136366 | 2136366 | 2022-01-21 | Montgomery | Maryland | 24031 | 152796 | 1865 |
2110934 | 2110934 | 2022-01-13 | Monmouth | New Jersey | 34025 | 145918 | 1865 |
2034588 | 2034588 | 2021-12-21 | San Joaquin | California | 6077 | 110086 | 1865 |
2031338 | 2031338 | 2021-12-20 | San Joaquin | California | 6077 | 110023 | 1865 |
2031563 | 2031563 | 2021-12-20 | Fulton | Georgia | 13121 | 140282 | 1865 |
1892585 | 1892585 | 2021-11-07 | Norfolk | Massachusetts | 25021 | 65426 | 1865 |
1889335 | 1889335 | 2021-11-06 | Norfolk | Massachusetts | 25021 | 65426 | 1865 |
1886085 | 1886085 | 2021-11-05 | Norfolk | Massachusetts | 25021 | 65426 | 1865 |
1882836 | 1882836 | 2021-11-04 | Norfolk | Massachusetts | 25021 | 65328 | 1865 |
1748755 | 1748755 | 2021-09-24 | Orange | Florida | 12095 | 220938 | 1865 |
1745505 | 1745505 | 2021-09-23 | Orange | Florida | 12095 | 217703 | 1865 |
1745521 | 1745521 | 2021-09-23 | Unknown | Florida | 46305 | 1865 | |
1742256 | 1742256 | 2021-09-22 | Orange | Florida | 12095 | 217703 | 1865 |
1739007 | 1739007 | 2021-09-21 | Orange | Florida | 12095 | 217703 | 1865 |
1735758 | 1735758 | 2021-09-20 | Orange | Florida | 12095 | 217703 | 1865 |
1732508 | 1732508 | 2021-09-19 | Orange | Florida | 12095 | 217703 | 1865 |
1729258 | 1729258 | 2021-09-18 | Orange | Florida | 12095 | 217703 | 1865 |
1652168 | 1652168 | 2021-08-25 | Suffolk | Massachusetts | 25025 | 98068 | 1865 |
1648920 | 1648920 | 2021-08-24 | Suffolk | Massachusetts | 25025 | 97922 | 1865 |
1191670 | 1191670 | 2021-04-05 | Union | New Jersey | 34039 | 65522 | 1865 |
983390 | 983390 | 2021-01-31 | Macomb | Michigan | 26099 | 56229 | 1865 |
980144 | 980144 | 2021-01-30 | Macomb | Michigan | 26099 | 56229 | 1865 |
980651 | 980651 | 2021-01-30 | Hudson | New Jersey | 34017 | 60990 | 1865 |
961184 | 961184 | 2021-01-24 | Middlesex | New Jersey | 34023 | 60635 | 1865 |
637196 | 637196 | 2020-10-16 | Philadelphia | Pennsylvania | 42101 | 40179 | 1865 |
415261 | 415261 | 2020-08-09 | Miami-Dade | Florida | 12086 | 132460 | 1865 |
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);