ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
29 rows where deaths = 1623 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 7
- Maryland 8
- Tennessee 8
- Alabama 7
- Florida 2
- New Jersey 2
- Massachusetts 1
- Pennsylvania 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2353116 | 2353116 | 2022-03-29 | Mobile | Alabama | 1097 | 113083 | 1623 |
2332847 | 2332847 | 2022-03-22 | Davidson | Tennessee | 47037 | 206711 | 1623 |
2329594 | 2329594 | 2022-03-21 | Davidson | Tennessee | 47037 | 206711 | 1623 |
2326342 | 2326342 | 2022-03-20 | Davidson | Tennessee | 47037 | 206615 | 1623 |
2323089 | 2323089 | 2022-03-19 | Davidson | Tennessee | 47037 | 206615 | 1623 |
2319835 | 2319835 | 2022-03-18 | Davidson | Tennessee | 47037 | 206615 | 1623 |
2316581 | 2316581 | 2022-03-17 | Davidson | Tennessee | 47037 | 206522 | 1623 |
2313328 | 2313328 | 2022-03-16 | Davidson | Tennessee | 47037 | 206522 | 1623 |
2127663 | 2127663 | 2022-01-18 | Bucks | Pennsylvania | 42017 | 112536 | 1623 |
1668386 | 1668386 | 2021-08-30 | Prince George's | Maryland | 24033 | 91650 | 1623 |
1665139 | 1665139 | 2021-08-29 | Prince George's | Maryland | 24033 | 91521 | 1623 |
1661891 | 1661891 | 2021-08-28 | Prince George's | Maryland | 24033 | 91345 | 1623 |
1650966 | 1650966 | 2021-08-25 | Jefferson | Alabama | 1073 | 96037 | 1623 |
1647717 | 1647717 | 2021-08-24 | Jefferson | Alabama | 1073 | 96037 | 1623 |
1644468 | 1644468 | 2021-08-23 | Jefferson | Alabama | 1073 | 96037 | 1623 |
1641218 | 1641218 | 2021-08-22 | Jefferson | Alabama | 1073 | 95624 | 1623 |
1637968 | 1637968 | 2021-08-21 | Jefferson | Alabama | 1073 | 95077 | 1623 |
1634718 | 1634718 | 2021-08-20 | Jefferson | Alabama | 1073 | 94190 | 1623 |
1473521 | 1473521 | 2021-07-01 | Montgomery | Maryland | 24031 | 71241 | 1623 |
1470275 | 1470275 | 2021-06-30 | Montgomery | Maryland | 24031 | 71231 | 1623 |
1467030 | 1467030 | 2021-06-29 | Montgomery | Maryland | 24031 | 71222 | 1623 |
1463785 | 1463785 | 2021-06-28 | Montgomery | Maryland | 24031 | 71213 | 1623 |
1460540 | 1460540 | 2021-06-27 | Montgomery | Maryland | 24031 | 71204 | 1623 |
1290903 | 1290903 | 2021-05-06 | Pinellas | Florida | 12103 | 79544 | 1623 |
1289888 | 1289888 | 2021-05-05 | Shelby | Tennessee | 47157 | 96050 | 1623 |
1196706 | 1196706 | 2021-04-07 | Hillsborough | Florida | 12057 | 124636 | 1623 |
1158615 | 1158615 | 2021-03-26 | Bristol | Massachusetts | 25005 | 58992 | 1623 |
860579 | 860579 | 2020-12-24 | Middlesex | New Jersey | 34023 | 42284 | 1623 |
818382 | 818382 | 2020-12-11 | Hudson | New Jersey | 34017 | 36507 | 1623 |
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);