ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where deaths = 1134 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 18
- Georgia 5
- Arkansas 4
- Arizona 3
- California 3
- Pennsylvania 3
- Washington 3
- Massachusetts 2
- Nevada 2
- Colorado 1
- District of Columbia 1
- Florida 1
- Kentucky 1
- Louisiana 1
- New Jersey 1
- North Carolina 1
- Texas 1
- Utah 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2440793 | 2440793 | 2022-04-24 | Snohomish | Washington | 53061 | 153141 | 1134 |
2437537 | 2437537 | 2022-04-23 | Snohomish | Washington | 53061 | 153141 | 1134 |
2434281 | 2434281 | 2022-04-22 | Snohomish | Washington | 53061 | 153141 | 1134 |
2339087 | 2339087 | 2022-03-24 | Chester | Pennsylvania | 42029 | 91263 | 1134 |
2315978 | 2315978 | 2022-03-17 | Guilford | North Carolina | 37081 | 115770 | 1134 |
2281680 | 2281680 | 2022-03-07 | Pulaski | Arkansas | 5119 | 102157 | 1134 |
2278427 | 2278427 | 2022-03-06 | Pulaski | Arkansas | 5119 | 102130 | 1134 |
2275174 | 2275174 | 2022-03-05 | Pulaski | Arkansas | 5119 | 102093 | 1134 |
2271921 | 2271921 | 2022-03-04 | Pulaski | Arkansas | 5119 | 102029 | 1134 |
2241018 | 2241018 | 2022-02-22 | Washoe | Nevada | 32031 | 101752 | 1134 |
2229594 | 2229594 | 2022-02-19 | Yavapai | Arizona | 4025 | 47192 | 1134 |
2085448 | 2085448 | 2022-01-05 | Westmoreland | Pennsylvania | 42129 | 61579 | 1134 |
1917451 | 1917451 | 2021-11-15 | Pinal | Arizona | 4021 | 76977 | 1134 |
1914201 | 1914201 | 2021-11-14 | Pinal | Arizona | 4021 | 76973 | 1134 |
1875364 | 1875364 | 2021-11-02 | El Paso | Colorado | 8041 | 103867 | 1134 |
1835755 | 1835755 | 2021-10-20 | Salt Lake | Utah | 49035 | 190744 | 1134 |
1782022 | 1782022 | 2021-10-04 | Jefferson | Louisiana | 22051 | 68664 | 1134 |
1755124 | 1755124 | 2021-09-26 | Ventura | California | 6111 | 98292 | 1134 |
1751876 | 1751876 | 2021-09-25 | Ventura | California | 6111 | 98292 | 1134 |
1748627 | 1748627 | 2021-09-24 | Ventura | California | 6111 | 98292 | 1134 |
1700087 | 1700087 | 2021-09-09 | DeKalb | Georgia | 13089 | 82866 | 1134 |
1670017 | 1670017 | 2021-08-30 | Travis | Texas | 48453 | 102283 | 1134 |
1599376 | 1599376 | 2021-08-09 | Cobb | Georgia | 13067 | 85918 | 1134 |
1596127 | 1596127 | 2021-08-08 | Cobb | Georgia | 13067 | 85156 | 1134 |
1592878 | 1592878 | 2021-08-07 | Cobb | Georgia | 13067 | 85156 | 1134 |
1589629 | 1589629 | 2021-08-06 | Cobb | Georgia | 13067 | 85156 | 1134 |
1375260 | 1375260 | 2021-06-01 | District of Columbia | District of Columbia | 11001 | 49000 | 1134 |
1226645 | 1226645 | 2021-04-16 | Jefferson | Kentucky | 21111 | 79525 | 1134 |
956082 | 956082 | 2021-01-22 | Milwaukee | Wisconsin | 55079 | 101042 | 1134 |
937897 | 937897 | 2021-01-17 | Hampden | Massachusetts | 25013 | 32936 | 1134 |
880554 | 880554 | 2020-12-30 | Montgomery | Pennsylvania | 42091 | 35592 | 1134 |
571280 | 571280 | 2020-09-26 | Suffolk | Massachusetts | 25025 | 24177 | 1134 |
492744 | 492744 | 2020-09-02 | Palm Beach | Florida | 12099 | 42516 | 1134 |
490898 | 490898 | 2020-09-01 | Clark | Nevada | 32003 | 59716 | 1134 |
168002 | 168002 | 2020-05-22 | Hudson | New Jersey | 34017 | 17897 | 1134 |
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);