ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
44 rows where deaths = 1154 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 22
- Pennsylvania 6
- Ohio 4
- Washington 4
- Colorado 3
- Louisiana 3
- Minnesota 3
- South Carolina 3
- Michigan 2
- New Jersey 2
- New York 2
- Arkansas 1
- California 1
- Georgia 1
- Indiana 1
- Massachusetts 1
- Missouri 1
- New Mexico 1
- North Carolina 1
- Tennessee 1
- Texas 1
- Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490933 | 2490933 | 2022-05-10 | Caddo | Louisiana | 22017 | 67507 | 1154 |
2487676 | 2487676 | 2022-05-09 | Caddo | Louisiana | 22017 | 67485 | 1154 |
2469285 | 2469285 | 2022-05-03 | Chester | Pennsylvania | 42029 | 93842 | 1154 |
2338752 | 2338752 | 2022-03-24 | Guilford | North Carolina | 37081 | 116127 | 1154 |
2310947 | 2310947 | 2022-03-16 | Pulaski | Arkansas | 5119 | 102466 | 1154 |
2266791 | 2266791 | 2022-03-02 | Jackson | Missouri | 29095 | 95726 | 1154 |
2262701 | 2262701 | 2022-03-01 | Allen | Indiana | 18003 | 103324 | 1154 |
2097514 | 2097514 | 2022-01-09 | Ramsey | Minnesota | 27123 | 89495 | 1154 |
2094262 | 2094262 | 2022-01-08 | Ramsey | Minnesota | 27123 | 89495 | 1154 |
2091010 | 2091010 | 2022-01-07 | Ramsey | Minnesota | 27123 | 89495 | 1154 |
1951985 | 1951985 | 2021-11-25 | Stark | Ohio | 39151 | 51599 | 1154 |
1948734 | 1948734 | 2021-11-24 | Stark | Ohio | 39151 | 51599 | 1154 |
1944613 | 1944613 | 2021-11-23 | Genesee | Michigan | 26049 | 59051 | 1154 |
1945483 | 1945483 | 2021-11-23 | Stark | Ohio | 39151 | 51357 | 1154 |
1941362 | 1941362 | 2021-11-22 | Genesee | Michigan | 26049 | 59051 | 1154 |
1928908 | 1928908 | 2021-11-18 | Bernalillo | New Mexico | 35001 | 83014 | 1154 |
1891611 | 1891611 | 2021-11-07 | El Paso | Colorado | 8041 | 105341 | 1154 |
1888361 | 1888361 | 2021-11-06 | El Paso | Colorado | 8041 | 105341 | 1154 |
1885111 | 1885111 | 2021-11-05 | El Paso | Colorado | 8041 | 105341 | 1154 |
1874120 | 1874120 | 2021-11-01 | Berks | Pennsylvania | 42011 | 58840 | 1154 |
1870871 | 1870871 | 2021-10-31 | Berks | Pennsylvania | 42011 | 58840 | 1154 |
1848315 | 1848315 | 2021-10-24 | Spartanburg | South Carolina | 45083 | 61343 | 1154 |
1845065 | 1845065 | 2021-10-23 | Spartanburg | South Carolina | 45083 | 61343 | 1154 |
1841815 | 1841815 | 2021-10-22 | Spartanburg | South Carolina | 45083 | 61343 | 1154 |
1830757 | 1830757 | 2021-10-19 | Jefferson | Louisiana | 22051 | 69218 | 1154 |
1787088 | 1787088 | 2021-10-05 | Fairfax | Virginia | 51059 | 88896 | 1154 |
1734011 | 1734011 | 2021-09-19 | Monroe | New York | 36055 | 77584 | 1154 |
1730761 | 1730761 | 2021-09-18 | Monroe | New York | 36055 | 77365 | 1154 |
1377236 | 1377236 | 2021-06-01 | Lancaster | Pennsylvania | 42071 | 55146 | 1154 |
1373990 | 1373990 | 2021-05-31 | Lancaster | Pennsylvania | 42071 | 55136 | 1154 |
1370745 | 1370745 | 2021-05-30 | Lancaster | Pennsylvania | 42071 | 55120 | 1154 |
1307218 | 1307218 | 2021-05-11 | Gwinnett | Georgia | 13135 | 101636 | 1154 |
1081264 | 1081264 | 2021-03-02 | Camden | New Jersey | 34007 | 44423 | 1154 |
975552 | 975552 | 2021-01-28 | Milwaukee | Wisconsin | 55079 | 102528 | 1154 |
967948 | 967948 | 2021-01-26 | Cuyahoga | Ohio | 39035 | 86893 | 1154 |
949005 | 949005 | 2021-01-20 | Shelby | Tennessee | 47157 | 79051 | 1154 |
942981 | 942981 | 2021-01-18 | King | Washington | 53033 | 73017 | 1154 |
939736 | 939736 | 2021-01-17 | King | Washington | 53033 | 73017 | 1154 |
936491 | 936491 | 2021-01-16 | King | Washington | 53033 | 72255 | 1154 |
931976 | 931976 | 2021-01-15 | Monmouth | New Jersey | 34025 | 42298 | 1154 |
933246 | 933246 | 2021-01-15 | King | Washington | 53033 | 72255 | 1154 |
790845 | 790845 | 2020-12-03 | San Bernardino | California | 6071 | 99104 | 1154 |
652355 | 652355 | 2020-10-21 | Worcester | Massachusetts | 25027 | 15681 | 1154 |
605131 | 605131 | 2020-10-06 | Dallas | Texas | 48113 | 88863 | 1154 |
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);