ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
37 rows where cases = 12430 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 16
- Oklahoma 7
- Alabama 5
- Indiana 5
- Mississippi 3
- Oregon 3
- Louisiana 2
- North Carolina 2
- Tennessee 2
- Arizona 1
- California 1
- Illinois 1
- Maryland 1
- Pennsylvania 1
- Rhode Island 1
- South Carolina 1
- Vermont 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502504 | 2502504 | 2022-05-13 | Washington | Vermont | 50023 | 12430 | 51 |
2381290 | 2381290 | 2022-04-06 | Le Flore | Oklahoma | 40079 | 12430 | 108 |
2378035 | 2378035 | 2022-04-05 | Le Flore | Oklahoma | 40079 | 12430 | 108 |
2374781 | 2374781 | 2022-04-04 | Le Flore | Oklahoma | 40079 | 12430 | 108 |
2371529 | 2371529 | 2022-04-03 | Le Flore | Oklahoma | 40079 | 12430 | 108 |
2368276 | 2368276 | 2022-04-02 | Le Flore | Oklahoma | 40079 | 12430 | 108 |
2365023 | 2365023 | 2022-04-01 | Le Flore | Oklahoma | 40079 | 12430 | 108 |
2361770 | 2361770 | 2022-03-31 | Le Flore | Oklahoma | 40079 | 12430 | 108 |
2278278 | 2278278 | 2022-03-06 | Dale | Alabama | 1045 | 12430 | 219 |
2275025 | 2275025 | 2022-03-05 | Dale | Alabama | 1045 | 12430 | 219 |
2271772 | 2271772 | 2022-03-04 | Dale | Alabama | 1045 | 12430 | 219 |
2262017 | 2262017 | 2022-03-01 | Dale | Alabama | 1045 | 12430 | 217 |
2197206 | 2197206 | 2022-02-09 | Tuolumne | California | 6109 | 12430 | 163 |
2176117 | 2176117 | 2022-02-02 | Carteret | North Carolina | 37031 | 12430 | 83 |
2029315 | 2029315 | 2021-12-19 | Lauderdale | Mississippi | 28075 | 12430 | 323 |
2026064 | 2026064 | 2021-12-18 | Lauderdale | Mississippi | 28075 | 12430 | 323 |
2022813 | 2022813 | 2021-12-17 | Lauderdale | Mississippi | 28075 | 12430 | 323 |
1849854 | 1849854 | 2021-10-25 | Kosciusko | Indiana | 18085 | 12430 | 154 |
1786653 | 1786653 | 2021-10-05 | Anderson | Tennessee | 47001 | 12430 | 205 |
1663961 | 1663961 | 2021-08-29 | Limestone | Alabama | 1083 | 12430 | 171 |
1643419 | 1643419 | 2021-08-22 | Deschutes | Oregon | 41017 | 12430 | 89 |
1640169 | 1640169 | 2021-08-21 | Deschutes | Oregon | 41017 | 12430 | 89 |
1636919 | 1636919 | 2021-08-20 | Deschutes | Oregon | 41017 | 12430 | 89 |
1437353 | 1437353 | 2021-06-20 | LaPorte | Indiana | 18091 | 12430 | 223 |
1434106 | 1434106 | 2021-06-19 | LaPorte | Indiana | 18091 | 12430 | 223 |
1297670 | 1297670 | 2021-05-08 | LaSalle | Illinois | 17099 | 12430 | 296 |
1255565 | 1255565 | 2021-04-25 | Madison | Indiana | 18095 | 12430 | 357 |
1223515 | 1223515 | 2021-04-15 | Tangipahoa | Louisiana | 22105 | 12430 | 289 |
1171089 | 1171089 | 2021-03-30 | Clark | Indiana | 18019 | 12430 | 195 |
1080695 | 1080695 | 2021-03-02 | Washington | Maryland | 24043 | 12430 | 254 |
984715 | 984715 | 2021-01-31 | Washington | Tennessee | 47179 | 12430 | 219 |
967803 | 967803 | 2021-01-26 | Davidson | North Carolina | 37057 | 12430 | 115 |
851454 | 851454 | 2020-12-21 | Unknown | Rhode Island | 12430 | 154 | |
785282 | 785282 | 2020-12-01 | Lafayette | Louisiana | 22055 | 12430 | 152 |
637168 | 637168 | 2020-10-16 | Delaware | Pennsylvania | 42045 | 12430 | 804 |
534532 | 534532 | 2020-09-15 | Yuma | Arizona | 4027 | 12430 | 337 |
517452 | 517452 | 2020-09-09 | Richland | South Carolina | 45079 | 12430 | 207 |
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);