ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
26 rows where cases = 22137 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 11
- Florida 8
- Iowa 7
- Mississippi 3
- Arkansas 1
- Georgia 1
- New Jersey 1
- Ohio 1
- Utah 1
- Washington 1
- West Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2473696 | 2473696 | 2022-05-05 | White | Arkansas | 5145 | 22137 | 292 |
2352971 | 2352971 | 2022-03-28 | Wood | West Virginia | 54107 | 22137 | 341 |
2126215 | 2126215 | 2022-01-18 | Dubuque | Iowa | 19061 | 22137 | 271 |
2122963 | 2122963 | 2022-01-17 | Dubuque | Iowa | 19061 | 22137 | 271 |
2119711 | 2119711 | 2022-01-16 | Dubuque | Iowa | 19061 | 22137 | 271 |
2116459 | 2116459 | 2022-01-15 | Dubuque | Iowa | 19061 | 22137 | 271 |
2113208 | 2113208 | 2022-01-14 | Dubuque | Iowa | 19061 | 22137 | 271 |
2109956 | 2109956 | 2022-01-13 | Dubuque | Iowa | 19061 | 22137 | 271 |
2106705 | 2106705 | 2022-01-12 | Dubuque | Iowa | 19061 | 22137 | 271 |
1870077 | 1870077 | 2021-10-31 | Rankin | Mississippi | 28121 | 22137 | 392 |
1866828 | 1866828 | 2021-10-30 | Rankin | Mississippi | 28121 | 22137 | 392 |
1863579 | 1863579 | 2021-10-29 | Rankin | Mississippi | 28121 | 22137 | 392 |
1832830 | 1832830 | 2021-10-19 | Washington | Wisconsin | 55131 | 22137 | 219 |
1716388 | 1716388 | 2021-09-14 | Muscogee | Georgia | 13215 | 22137 | 544 |
1563549 | 1563549 | 2021-07-29 | Clay | Florida | 12019 | 22137 | 352 |
1560301 | 1560301 | 2021-07-28 | Clay | Florida | 12019 | 22137 | 352 |
1557054 | 1557054 | 2021-07-27 | Clay | Florida | 12019 | 22137 | 352 |
1553807 | 1553807 | 2021-07-26 | Clay | Florida | 12019 | 22137 | 352 |
1550560 | 1550560 | 2021-07-25 | Clay | Florida | 12019 | 22137 | 352 |
1547313 | 1547313 | 2021-07-24 | Clay | Florida | 12019 | 22137 | 352 |
1544066 | 1544066 | 2021-07-23 | Clay | Florida | 12019 | 22137 | 352 |
1058894 | 1058894 | 2021-02-23 | Warren | Ohio | 39165 | 22137 | 269 |
920097 | 920097 | 2021-01-11 | Weber | Utah | 49057 | 22137 | 112 |
914305 | 914305 | 2021-01-10 | Leon | Florida | 12073 | 22137 | 184 |
576353 | 576353 | 2020-09-27 | King | Washington | 53033 | 22137 | 787 |
520026 | 520026 | 2020-09-10 | Bergen | New Jersey | 34003 | 22137 | 2040 |
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);