ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
36 rows where deaths = 1778 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 14
- Florida 7
- Massachusetts 6
- Washington 4
- California 3
- New Jersey 3
- Georgia 2
- New York 2
- Pennsylvania 2
- Texas 2
- Illinois 1
- Indiana 1
- Maryland 1
- Michigan 1
- Puerto Rico 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2405559 | 2405559 | 2022-04-14 | Cobb | Georgia | 13067 | 174470 | 1778 |
2383585 | 2383585 | 2022-04-07 | Hampden | Massachusetts | 25013 | 132988 | 1778 |
2337427 | 2337427 | 2022-03-24 | DuPage | Illinois | 17043 | 208727 | 1778 |
2306069 | 2306069 | 2022-03-14 | Camden | New Jersey | 34007 | 124667 | 1778 |
2262452 | 2262452 | 2022-03-01 | Gwinnett | Georgia | 13135 | 205174 | 1778 |
2262745 | 2262745 | 2022-03-01 | Lake | Indiana | 18089 | 105538 | 1778 |
2212268 | 2212268 | 2022-02-13 | Delaware | Pennsylvania | 42045 | 107946 | 1778 |
2209015 | 2209015 | 2022-02-12 | Delaware | Pennsylvania | 42045 | 107890 | 1778 |
2057438 | 2057438 | 2021-12-28 | Brevard | Florida | 12009 | 83648 | 1778 |
2058331 | 2058331 | 2021-12-28 | Prince George's | Maryland | 24033 | 119509 | 1778 |
2054189 | 2054189 | 2021-12-27 | Brevard | Florida | 12009 | 83648 | 1778 |
2050939 | 2050939 | 2021-12-26 | Brevard | Florida | 12009 | 83648 | 1778 |
2047689 | 2047689 | 2021-12-25 | Brevard | Florida | 12009 | 83648 | 1778 |
2044439 | 2044439 | 2021-12-24 | Brevard | Florida | 12009 | 83648 | 1778 |
2041190 | 2041190 | 2021-12-23 | Brevard | Florida | 12009 | 82434 | 1778 |
2037940 | 2037940 | 2021-12-22 | Brevard | Florida | 12009 | 82434 | 1778 |
1964656 | 1964656 | 2021-11-29 | Monmouth | New Jersey | 34025 | 97773 | 1778 |
1961405 | 1961405 | 2021-11-28 | Monmouth | New Jersey | 34025 | 97561 | 1778 |
1692985 | 1692985 | 2021-09-06 | King | Washington | 53033 | 137787 | 1778 |
1689736 | 1689736 | 2021-09-05 | King | Washington | 53033 | 137787 | 1778 |
1686486 | 1686486 | 2021-09-04 | King | Washington | 53033 | 137787 | 1778 |
1683235 | 1683235 | 2021-09-03 | King | Washington | 53033 | 137787 | 1778 |
1328099 | 1328099 | 2021-05-17 | Erie | New York | 36029 | 88507 | 1778 |
1324853 | 1324853 | 2021-05-16 | Erie | New York | 36029 | 88434 | 1778 |
1311245 | 1311245 | 2021-05-12 | Norfolk | Massachusetts | 25021 | 54368 | 1778 |
1307998 | 1307998 | 2021-05-11 | Norfolk | Massachusetts | 25021 | 54298 | 1778 |
1304752 | 1304752 | 2021-05-10 | Norfolk | Massachusetts | 25021 | 54288 | 1778 |
1301506 | 1301506 | 2021-05-09 | Norfolk | Massachusetts | 25021 | 54266 | 1778 |
1298258 | 1298258 | 2021-05-08 | Norfolk | Massachusetts | 25021 | 54214 | 1778 |
1073207 | 1073207 | 2021-02-28 | Santa Clara | California | 6085 | 110621 | 1778 |
1069961 | 1069961 | 2021-02-27 | Santa Clara | California | 6085 | 110422 | 1778 |
1066716 | 1066716 | 2021-02-26 | Santa Clara | California | 6085 | 110237 | 1778 |
965027 | 965027 | 2021-01-25 | Unknown | Puerto Rico | 4232 | 1778 | |
947692 | 947692 | 2021-01-20 | Macomb | Michigan | 26099 | 54488 | 1778 |
910148 | 910148 | 2021-01-08 | El Paso | Texas | 48141 | 102055 | 1778 |
903602 | 903602 | 2021-01-06 | Bexar | Texas | 48029 | 126909 | 1778 |
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);