ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where deaths = 1606 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 13
- Florida 9
- Alabama 4
- California 4
- Michigan 4
- Massachusetts 3
- Pennsylvania 2
- Georgia 1
- Illinois 1
- Maryland 1
- New York 1
- Texas 1
- Utah 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2444586 | 2444586 | 2022-04-26 | Sarasota | Florida | 12115 | 90282 | 1606 |
2441330 | 2441330 | 2022-04-25 | Sarasota | Florida | 12115 | 90282 | 1606 |
2438074 | 2438074 | 2022-04-24 | Sarasota | Florida | 12115 | 90282 | 1606 |
2434818 | 2434818 | 2022-04-23 | Sarasota | Florida | 12115 | 90282 | 1606 |
2431562 | 2431562 | 2022-04-22 | Sarasota | Florida | 12115 | 90282 | 1606 |
2428306 | 2428306 | 2022-04-21 | Sarasota | Florida | 12115 | 89528 | 1606 |
2428629 | 2428629 | 2022-04-21 | Will | Illinois | 17197 | 163812 | 1606 |
2425050 | 2425050 | 2022-04-20 | Sarasota | Florida | 12115 | 89528 | 1606 |
2336450 | 2336450 | 2022-03-23 | Salt Lake | Utah | 49035 | 340835 | 1606 |
2304321 | 2304321 | 2022-03-14 | Mobile | Alabama | 1097 | 112931 | 1606 |
2219968 | 2219968 | 2022-02-16 | Stanislaus | California | 6099 | 133147 | 1606 |
1746370 | 1746370 | 2021-09-23 | Hampden | Massachusetts | 25013 | 61541 | 1606 |
1742336 | 1742336 | 2021-09-22 | Fulton | Georgia | 13121 | 126384 | 1606 |
1608737 | 1608737 | 2021-08-12 | Jefferson | Alabama | 1073 | 89977 | 1606 |
1605488 | 1605488 | 2021-08-11 | Jefferson | Alabama | 1073 | 89507 | 1606 |
1602238 | 1602238 | 2021-08-10 | Jefferson | Alabama | 1073 | 89043 | 1606 |
1403975 | 1403975 | 2021-06-09 | King | Washington | 53033 | 110719 | 1606 |
1385892 | 1385892 | 2021-06-04 | Montgomery | Maryland | 24031 | 71009 | 1606 |
1263962 | 1263962 | 2021-04-27 | Cameron | Texas | 48061 | 40089 | 1606 |
1170572 | 1170572 | 2021-03-30 | Fresno | California | 6019 | 99085 | 1606 |
1167324 | 1167324 | 2021-03-29 | Fresno | California | 6019 | 99004 | 1606 |
1169438 | 1169438 | 2021-03-29 | Montgomery | Pennsylvania | 42091 | 59243 | 1606 |
1164076 | 1164076 | 2021-03-28 | Fresno | California | 6019 | 98901 | 1606 |
1152121 | 1152121 | 2021-03-24 | Bristol | Massachusetts | 25005 | 58584 | 1606 |
1012553 | 1012553 | 2021-02-09 | Suffolk | Massachusetts | 25025 | 74098 | 1606 |
886029 | 886029 | 2021-01-01 | Macomb | Michigan | 26099 | 49744 | 1606 |
882784 | 882784 | 2020-12-31 | Macomb | Michigan | 26099 | 49744 | 1606 |
879539 | 879539 | 2020-12-30 | Macomb | Michigan | 26099 | 49744 | 1606 |
873062 | 873062 | 2020-12-28 | Oakland | Michigan | 26125 | 60147 | 1606 |
847698 | 847698 | 2020-12-20 | Westchester | New York | 36119 | 62939 | 1606 |
703383 | 703383 | 2020-11-06 | Palm Beach | Florida | 12099 | 54622 | 1606 |
700140 | 700140 | 2020-11-05 | Palm Beach | Florida | 12099 | 54258 | 1606 |
289318 | 289318 | 2020-06-30 | Philadelphia | Pennsylvania | 42101 | 26133 | 1606 |
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);