ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where deaths = 1280 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 20
- California 3
- Massachusetts 3
- Michigan 3
- New Jersey 2
- South Carolina 2
- Colorado 1
- Delaware 1
- District of Columbia 1
- Florida 1
- Georgia 1
- Illinois 1
- Louisiana 1
- Maryland 1
- Minnesota 1
- Missouri 1
- New York 1
- Pennsylvania 1
- Tennessee 1
- Texas 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2351366 | 2351366 | 2022-03-28 | Kansas City | Missouri | 112560 | 1280 | |
2220870 | 2220870 | 2022-02-16 | East Baton Rouge | Louisiana | 22033 | 109338 | 1280 |
2216800 | 2216800 | 2022-02-15 | New Castle | Delaware | 10003 | 143852 | 1280 |
2217870 | 2217870 | 2022-02-15 | Ramsey | Minnesota | 27123 | 120608 | 1280 |
2203717 | 2203717 | 2022-02-11 | Adams | Colorado | 8001 | 128901 | 1280 |
2196043 | 2196043 | 2022-02-08 | Westmoreland | Pennsylvania | 42129 | 77129 | 1280 |
2193424 | 2193424 | 2022-02-07 | Fairfax | Virginia | 51059 | 168980 | 1280 |
2151739 | 2151739 | 2022-01-26 | District of Columbia | District of Columbia | 11001 | 129108 | 1280 |
2145564 | 2145564 | 2022-01-24 | Lake | Illinois | 17097 | 135535 | 1280 |
2066069 | 2066069 | 2021-12-30 | Spartanburg | South Carolina | 45083 | 65641 | 1280 |
2062819 | 2062819 | 2021-12-29 | Spartanburg | South Carolina | 45083 | 65385 | 1280 |
2029130 | 2029130 | 2021-12-19 | Genesee | Michigan | 26049 | 68584 | 1280 |
2025879 | 2025879 | 2021-12-18 | Genesee | Michigan | 26049 | 68584 | 1280 |
2022628 | 2022628 | 2021-12-17 | Genesee | Michigan | 26049 | 68584 | 1280 |
2006980 | 2006980 | 2021-12-12 | Monroe | New York | 36055 | 103794 | 1280 |
1756687 | 1756687 | 2021-09-26 | Morris | New Jersey | 34027 | 55783 | 1280 |
1753439 | 1753439 | 2021-09-25 | Morris | New Jersey | 34027 | 55724 | 1280 |
1700111 | 1700111 | 2021-09-09 | Gwinnett | Georgia | 13135 | 119533 | 1280 |
1446529 | 1446529 | 2021-06-23 | Alameda | California | 6001 | 89840 | 1280 |
1061237 | 1061237 | 2021-02-24 | Plymouth | Massachusetts | 25023 | 39735 | 1280 |
1019022 | 1019022 | 2021-02-11 | Prince George's | Maryland | 24033 | 70493 | 1280 |
984703 | 984703 | 2021-01-31 | Shelby | Tennessee | 47157 | 83029 | 1280 |
846020 | 846020 | 2020-12-20 | San Diego | California | 6073 | 126528 | 1280 |
842774 | 842774 | 2020-12-19 | San Diego | California | 6073 | 123035 | 1280 |
785374 | 785374 | 2020-12-01 | Worcester | Massachusetts | 25027 | 25146 | 1280 |
699201 | 699201 | 2020-11-04 | Dallas | Texas | 48113 | 106494 | 1280 |
571272 | 571272 | 2020-09-26 | Essex | Massachusetts | 25009 | 19637 | 1280 |
528277 | 528277 | 2020-09-13 | Broward | Florida | 12011 | 74434 | 1280 |
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);