ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
38 rows where deaths = 1664 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 14
- Florida 9
- Massachusetts 8
- Tennessee 7
- New Jersey 4
- Connecticut 1
- Georgia 1
- Maryland 1
- Minnesota 1
- Missouri 1
- New Mexico 1
- New York 1
- Pennsylvania 1
- Texas 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2423970 | 2423970 | 2022-04-19 | Davidson | Tennessee | 47037 | 208020 | 1664 |
2420714 | 2420714 | 2022-04-18 | Davidson | Tennessee | 47037 | 208020 | 1664 |
2417458 | 2417458 | 2022-04-17 | Davidson | Tennessee | 47037 | 207807 | 1664 |
2414202 | 2414202 | 2022-04-16 | Davidson | Tennessee | 47037 | 207807 | 1664 |
2410946 | 2410946 | 2022-04-15 | Davidson | Tennessee | 47037 | 207807 | 1664 |
2407690 | 2407690 | 2022-04-14 | Davidson | Tennessee | 47037 | 207635 | 1664 |
2404434 | 2404434 | 2022-04-13 | Davidson | Tennessee | 47037 | 207635 | 1664 |
2331536 | 2331536 | 2022-03-22 | Plymouth | Massachusetts | 25023 | 114856 | 1664 |
2283325 | 2283325 | 2022-03-07 | Bernalillo | New Mexico | 35001 | 145388 | 1664 |
2171329 | 2171329 | 2022-02-01 | Volusia | Florida | 12127 | 107570 | 1664 |
2168076 | 2168076 | 2022-01-31 | Volusia | Florida | 12127 | 107570 | 1664 |
2168146 | 2168146 | 2022-01-31 | Gwinnett | Georgia | 13135 | 197947 | 1664 |
2164821 | 2164821 | 2022-01-30 | Volusia | Florida | 12127 | 107570 | 1664 |
2161566 | 2161566 | 2022-01-29 | Volusia | Florida | 12127 | 107570 | 1664 |
2158310 | 2158310 | 2022-01-28 | Volusia | Florida | 12127 | 107570 | 1664 |
2155057 | 2155057 | 2022-01-27 | Volusia | Florida | 12127 | 102609 | 1664 |
2151804 | 2151804 | 2022-01-26 | Volusia | Florida | 12127 | 102609 | 1664 |
2061600 | 2061600 | 2021-12-29 | Plymouth | Massachusetts | 25023 | 77712 | 1664 |
1869836 | 1869836 | 2021-10-31 | Hampden | Massachusetts | 25013 | 65739 | 1664 |
1866587 | 1866587 | 2021-10-30 | Hampden | Massachusetts | 25013 | 65739 | 1664 |
1863338 | 1863338 | 2021-10-29 | Hampden | Massachusetts | 25013 | 65739 | 1664 |
1723608 | 1723608 | 2021-09-16 | Montgomery | Maryland | 24031 | 78181 | 1664 |
1472131 | 1472131 | 2021-06-30 | King | Washington | 53033 | 112567 | 1664 |
1384082 | 1384082 | 2021-06-03 | Cameron | Texas | 48061 | 41309 | 1664 |
1223571 | 1223571 | 2021-04-15 | Bristol | Massachusetts | 25005 | 62667 | 1664 |
1220324 | 1220324 | 2021-04-14 | Bristol | Massachusetts | 25005 | 62470 | 1664 |
1200959 | 1200959 | 2021-04-08 | Hennepin | Minnesota | 27053 | 111536 | 1664 |
1113168 | 1113168 | 2021-03-12 | Norfolk | Massachusetts | 25021 | 46955 | 1664 |
970715 | 970715 | 2021-01-27 | St. Louis | Missouri | 29189 | 82071 | 1664 |
883393 | 883393 | 2020-12-31 | Westchester | New York | 36119 | 69660 | 1664 |
854086 | 854086 | 2020-12-22 | Hudson | New Jersey | 34017 | 40567 | 1664 |
810403 | 810403 | 2020-12-09 | Hartford | Connecticut | 9003 | 34516 | 1664 |
784462 | 784462 | 2020-12-01 | Broward | Florida | 12011 | 108325 | 1664 |
781217 | 781217 | 2020-11-30 | Broward | Florida | 12011 | 107524 | 1664 |
340105 | 340105 | 2020-07-16 | Philadelphia | Pennsylvania | 42101 | 28024 | 1664 |
241840 | 241840 | 2020-06-15 | Bergen | New Jersey | 34003 | 18848 | 1664 |
235623 | 235623 | 2020-06-13 | Bergen | New Jersey | 34003 | 18805 | 1664 |
195467 | 195467 | 2020-05-31 | Essex | New Jersey | 34013 | 17629 | 1664 |
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);