ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
60 rows where deaths = 1171 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 18
- Pennsylvania 12
- Florida 7
- Arkansas 5
- Illinois 5
- Michigan 4
- Texas 4
- Washington 4
- Massachusetts 3
- Ohio 3
- District of Columbia 2
- Georgia 2
- New Jersey 2
- Virginia 2
- Arizona 1
- California 1
- Indiana 1
- Louisiana 1
- New York 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2389029 | 2389029 | 2022-04-09 | Pulaski | Arkansas | 5119 | 103033 | 1171 |
2385774 | 2385774 | 2022-04-08 | Pulaski | Arkansas | 5119 | 103023 | 1171 |
2382519 | 2382519 | 2022-04-07 | Pulaski | Arkansas | 5119 | 102996 | 1171 |
2379264 | 2379264 | 2022-04-06 | Pulaski | Arkansas | 5119 | 102976 | 1171 |
2376010 | 2376010 | 2022-04-05 | Pulaski | Arkansas | 5119 | 102953 | 1171 |
2350462 | 2350462 | 2022-03-28 | Kane | Illinois | 17089 | 125670 | 1171 |
2347209 | 2347209 | 2022-03-27 | Kane | Illinois | 17089 | 125578 | 1171 |
2343956 | 2343956 | 2022-03-26 | Kane | Illinois | 17089 | 125578 | 1171 |
2340703 | 2340703 | 2022-03-25 | Kane | Illinois | 17089 | 125578 | 1171 |
2337450 | 2337450 | 2022-03-24 | Kane | Illinois | 17089 | 125528 | 1171 |
2314736 | 2314736 | 2022-03-17 | Allen | Indiana | 18003 | 103587 | 1171 |
2216819 | 2216819 | 2022-02-15 | Escambia | Florida | 12033 | 76707 | 1171 |
2213568 | 2213568 | 2022-02-14 | Escambia | Florida | 12033 | 76707 | 1171 |
2210316 | 2210316 | 2022-02-13 | Escambia | Florida | 12033 | 76707 | 1171 |
2207063 | 2207063 | 2022-02-12 | Escambia | Florida | 12033 | 76707 | 1171 |
2203810 | 2203810 | 2022-02-11 | Escambia | Florida | 12033 | 76707 | 1171 |
2200557 | 2200557 | 2022-02-10 | Escambia | Florida | 12033 | 74740 | 1171 |
2197303 | 2197303 | 2022-02-09 | Escambia | Florida | 12033 | 74740 | 1171 |
2154195 | 2154195 | 2022-01-26 | Lubbock | Texas | 48303 | 92533 | 1171 |
2150471 | 2150471 | 2022-01-25 | Luzerne | Pennsylvania | 42079 | 68200 | 1171 |
2144455 | 2144455 | 2022-01-23 | Montgomery | Texas | 48339 | 124038 | 1171 |
2141200 | 2141200 | 2022-01-22 | Montgomery | Texas | 48339 | 123001 | 1171 |
2125230 | 2125230 | 2022-01-17 | Spokane | Washington | 53063 | 91203 | 1171 |
2121978 | 2121978 | 2022-01-16 | Spokane | Washington | 53063 | 91203 | 1171 |
2118726 | 2118726 | 2022-01-15 | Spokane | Washington | 53063 | 91203 | 1171 |
2115474 | 2115474 | 2022-01-14 | Spokane | Washington | 53063 | 91203 | 1171 |
2056193 | 2056193 | 2021-12-27 | York | Pennsylvania | 42133 | 82924 | 1171 |
2052944 | 2052944 | 2021-12-26 | York | Pennsylvania | 42133 | 82434 | 1171 |
2049694 | 2049694 | 2021-12-25 | York | Pennsylvania | 42133 | 82094 | 1171 |
2046444 | 2046444 | 2021-12-24 | York | Pennsylvania | 42133 | 81411 | 1171 |
1974740 | 1974740 | 2021-12-02 | Stark | Ohio | 39151 | 53512 | 1171 |
1970491 | 1970491 | 2021-12-01 | East Baton Rouge | Louisiana | 22033 | 64687 | 1171 |
1971491 | 1971491 | 2021-12-01 | Stark | Ohio | 39151 | 53155 | 1171 |
1966210 | 1966210 | 2021-11-30 | Pinal | Arizona | 4021 | 80703 | 1171 |
1968241 | 1968241 | 2021-11-30 | Stark | Ohio | 39151 | 52794 | 1171 |
1920309 | 1920309 | 2021-11-15 | Fairfax | Virginia | 51059 | 93134 | 1171 |
1904061 | 1904061 | 2021-11-10 | Fairfax | Virginia | 51059 | 92723 | 1171 |
1792494 | 1792494 | 2021-10-07 | Monroe | New York | 36055 | 81251 | 1171 |
1742208 | 1742208 | 2021-09-22 | District of Columbia | District of Columbia | 11001 | 59849 | 1171 |
1738959 | 1738959 | 2021-09-21 | District of Columbia | District of Columbia | 11001 | 59712 | 1171 |
1739070 | 1739070 | 2021-09-21 | DeKalb | Georgia | 13089 | 86381 | 1171 |
1555774 | 1555774 | 2021-07-26 | Lancaster | Pennsylvania | 42071 | 55761 | 1171 |
1552527 | 1552527 | 2021-07-25 | Lancaster | Pennsylvania | 42071 | 55727 | 1171 |
1549280 | 1549280 | 2021-07-24 | Lancaster | Pennsylvania | 42071 | 55707 | 1171 |
1546033 | 1546033 | 2021-07-23 | Lancaster | Pennsylvania | 42071 | 55679 | 1171 |
1542786 | 1542786 | 2021-07-22 | Lancaster | Pennsylvania | 42071 | 55655 | 1171 |
1539538 | 1539538 | 2021-07-21 | Lancaster | Pennsylvania | 42071 | 55621 | 1171 |
1536291 | 1536291 | 2021-07-20 | Lancaster | Pennsylvania | 42071 | 55599 | 1171 |
1172181 | 1172181 | 2021-03-30 | Morris | New Jersey | 34027 | 44681 | 1171 |
1168933 | 1168933 | 2021-03-29 | Morris | New Jersey | 34027 | 44401 | 1171 |
1102642 | 1102642 | 2021-03-09 | Fulton | Georgia | 13121 | 88207 | 1171 |
1043953 | 1043953 | 2021-02-19 | Alameda | California | 6001 | 79318 | 1171 |
733494 | 733494 | 2020-11-15 | Macomb | Michigan | 26099 | 27445 | 1171 |
730249 | 730249 | 2020-11-14 | Macomb | Michigan | 26099 | 27445 | 1171 |
678305 | 678305 | 2020-10-29 | Worcester | Massachusetts | 25027 | 16580 | 1171 |
671818 | 671818 | 2020-10-27 | Suffolk | Massachusetts | 25025 | 27992 | 1171 |
668576 | 668576 | 2020-10-26 | Suffolk | Massachusetts | 25025 | 27823 | 1171 |
506610 | 506610 | 2020-09-06 | Oakland | Michigan | 26125 | 18513 | 1171 |
503377 | 503377 | 2020-09-05 | Oakland | Michigan | 26125 | 18513 | 1171 |
488626 | 488626 | 2020-08-31 | Hidalgo | Texas | 48215 | 27479 | 1171 |
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);