ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where deaths = 1481 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 11
- Georgia 6
- Texas 6
- Maryland 5
- New Jersey 5
- California 4
- Florida 4
- Connecticut 3
- Pennsylvania 3
- Massachusetts 2
- New York 2
- South Carolina 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2372141 | 2372141 | 2022-04-03 | Nueces | Texas | 48355 | 92949 | 1481 |
2368888 | 2368888 | 2022-04-02 | Nueces | Texas | 48355 | 92949 | 1481 |
2365635 | 2365635 | 2022-04-01 | Nueces | Texas | 48355 | 92949 | 1481 |
2362382 | 2362382 | 2022-03-31 | Nueces | Texas | 48355 | 92937 | 1481 |
2342392 | 2342392 | 2022-03-25 | York | Pennsylvania | 42133 | 118330 | 1481 |
2336221 | 2336221 | 2022-03-23 | Collin | Texas | 48085 | 208040 | 1481 |
2264454 | 2264454 | 2022-03-01 | Spartanburg | South Carolina | 45083 | 93980 | 1481 |
2176069 | 2176069 | 2022-02-02 | Monroe | New York | 36055 | 145885 | 1481 |
2168122 | 2168122 | 2022-01-31 | DeKalb | Georgia | 13089 | 139447 | 1481 |
2160198 | 2160198 | 2022-01-28 | Berks | Pennsylvania | 42011 | 98455 | 1481 |
2083354 | 2083354 | 2022-01-05 | Stanislaus | California | 6099 | 96951 | 1481 |
2080102 | 2080102 | 2022-01-04 | Stanislaus | California | 6099 | 96951 | 1481 |
1994956 | 1994956 | 2021-12-08 | Travis | Texas | 48453 | 122841 | 1481 |
1968377 | 1968377 | 2021-11-30 | Bucks | Pennsylvania | 42017 | 78969 | 1481 |
1961396 | 1961396 | 2021-11-28 | Camden | New Jersey | 34007 | 71710 | 1481 |
1958145 | 1958145 | 2021-11-27 | Camden | New Jersey | 34007 | 71601 | 1481 |
1954894 | 1954894 | 2021-11-26 | Camden | New Jersey | 34007 | 71525 | 1481 |
1920781 | 1920781 | 2021-11-16 | Alameda | California | 6001 | 123757 | 1481 |
1531194 | 1531194 | 2021-07-19 | Fulton | Georgia | 13121 | 100938 | 1481 |
1527947 | 1527947 | 2021-07-18 | Fulton | Georgia | 13121 | 100625 | 1481 |
1524700 | 1524700 | 2021-07-17 | Fulton | Georgia | 13121 | 100625 | 1481 |
1521452 | 1521452 | 2021-07-16 | Fulton | Georgia | 13121 | 100625 | 1481 |
1518204 | 1518204 | 2021-07-15 | Fulton | Georgia | 13121 | 100536 | 1481 |
1304733 | 1304733 | 2021-05-10 | Prince George's | Maryland | 24033 | 83944 | 1481 |
1301487 | 1301487 | 2021-05-09 | Prince George's | Maryland | 24033 | 83904 | 1481 |
1285241 | 1285241 | 2021-05-04 | Baltimore | Maryland | 24005 | 63976 | 1481 |
1245260 | 1245260 | 2021-04-22 | Alameda | California | 6001 | 85783 | 1481 |
1236566 | 1236566 | 2021-04-19 | Hampden | Massachusetts | 25013 | 49135 | 1481 |
1191077 | 1191077 | 2021-04-05 | Montgomery | Maryland | 24031 | 67349 | 1481 |
1187829 | 1187829 | 2021-04-04 | Montgomery | Maryland | 24031 | 67258 | 1481 |
1109058 | 1109058 | 2021-03-11 | Pinellas | Florida | 12103 | 68494 | 1481 |
1105812 | 1105812 | 2021-03-10 | Pinellas | Florida | 12103 | 68258 | 1481 |
1099320 | 1099320 | 2021-03-08 | Pinellas | Florida | 12103 | 67961 | 1481 |
937903 | 937903 | 2021-01-17 | Suffolk | Massachusetts | 25025 | 65398 | 1481 |
902772 | 902772 | 2021-01-06 | Passaic | New Jersey | 34031 | 44350 | 1481 |
687104 | 687104 | 2020-11-01 | Hartford | Connecticut | 9003 | 18184 | 1481 |
683860 | 683860 | 2020-10-31 | Hartford | Connecticut | 9003 | 18184 | 1481 |
680617 | 680617 | 2020-10-30 | Hartford | Connecticut | 9003 | 18184 | 1481 |
625479 | 625479 | 2020-10-13 | Broward | Florida | 12011 | 79611 | 1481 |
320465 | 320465 | 2020-07-10 | Hudson | New Jersey | 34017 | 19235 | 1481 |
186375 | 186375 | 2020-05-28 | Westchester | New York | 36119 | 33292 | 1481 |
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);