ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
38 rows where cases = 9433 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501327 | 2501327 | 2022-05-13 | Scotts Bluff | Nebraska | 31157 | 9433 | 102 |
2467860 | 2467860 | 2022-05-03 | Marshall | Iowa | 19127 | 9433 | 111 |
2464605 | 2464605 | 2022-05-02 | Marshall | Iowa | 19127 | 9433 | 111 |
2461349 | 2461349 | 2022-05-01 | Marshall | Iowa | 19127 | 9433 | 111 |
2458093 | 2458093 | 2022-04-30 | Marshall | Iowa | 19127 | 9433 | 111 |
2454837 | 2454837 | 2022-04-29 | Marshall | Iowa | 19127 | 9433 | 111 |
2451581 | 2451581 | 2022-04-28 | Marshall | Iowa | 19127 | 9433 | 111 |
2448325 | 2448325 | 2022-04-27 | Marshall | Iowa | 19127 | 9433 | 111 |
2405251 | 2405251 | 2022-04-14 | Boone | Arkansas | 5009 | 9433 | 179 |
2323403 | 2323403 | 2022-03-19 | Waller | Texas | 48473 | 9433 | 105 |
2251750 | 2251750 | 2022-02-25 | Kerr | Texas | 48265 | 9433 | 174 |
2213534 | 2213534 | 2022-02-14 | Summit | Colorado | 8117 | 9433 | 14 |
2148307 | 2148307 | 2022-01-25 | Independence | Arkansas | 5063 | 9433 | 182 |
2132941 | 2132941 | 2022-01-20 | Greenup | Kentucky | 21089 | 9433 | 111 |
1945114 | 1945114 | 2021-11-23 | Elko | Nevada | 32007 | 9433 | 120 |
1829848 | 1829848 | 2021-10-19 | Tehama | California | 6103 | 9433 | 107 |
1826774 | 1826774 | 2021-10-18 | Catoosa | Georgia | 13047 | 9433 | 100 |
1762719 | 1762719 | 2021-09-28 | Clay | Minnesota | 27027 | 9433 | 97 |
1718436 | 1718436 | 2021-09-14 | Coffee | Tennessee | 47031 | 9433 | 136 |
1653910 | 1653910 | 2021-08-25 | Hanover | Virginia | 51085 | 9433 | 171 |
1627708 | 1627708 | 2021-08-17 | Liberty | Texas | 48291 | 9433 | 214 |
1363029 | 1363029 | 2021-05-28 | Madison | Kentucky | 21151 | 9433 | 111 |
1347960 | 1347960 | 2021-05-23 | Deschutes | Oregon | 41017 | 9433 | 78 |
1328503 | 1328503 | 2021-05-17 | Adams | Pennsylvania | 42001 | 9433 | 182 |
1319985 | 1319985 | 2021-05-15 | Sutter | California | 6101 | 9433 | 113 |
1322053 | 1322053 | 2021-05-15 | Mercer | Pennsylvania | 42085 | 9433 | 255 |
1316738 | 1316738 | 2021-05-14 | Sutter | California | 6101 | 9433 | 112 |
1244663 | 1244663 | 2021-04-21 | Starr | Texas | 48427 | 9433 | 296 |
1227134 | 1227134 | 2021-04-16 | Jasper | Missouri | 29097 | 9433 | 126 |
1223492 | 1223492 | 2021-04-15 | Lafourche | Louisiana | 22057 | 9433 | 202 |
1195350 | 1195350 | 2021-04-06 | Jackson | Oregon | 41029 | 9433 | 123 |
1037607 | 1037607 | 2021-02-17 | Citrus | Florida | 12017 | 9433 | 373 |
875498 | 875498 | 2020-12-29 | Muscogee | Georgia | 13215 | 9433 | 209 |
797493 | 797493 | 2020-12-05 | St. Johns | Florida | 12109 | 9433 | 99 |
758955 | 758955 | 2020-11-23 | Vanderburgh | Indiana | 18163 | 9433 | 113 |
668485 | 668485 | 2020-10-26 | Lafayette | Louisiana | 22055 | 9433 | 139 |
583251 | 583251 | 2020-09-30 | Adams | Colorado | 8001 | 9433 | 227 |
439710 | 439710 | 2020-08-16 | Allegheny | Pennsylvania | 42003 | 9433 | 288 |
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);