ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
25 rows where cases = 10156 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 15
- Georgia 3
- Mississippi 3
- North Carolina 3
- Michigan 2
- Ohio 2
- Puerto Rico 2
- Wisconsin 2
- Alaska 1
- Arizona 1
- Arkansas 1
- Florida 1
- Indiana 1
- New York 1
- Pennsylvania 1
- Texas 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2405594 | 2405594 | 2022-04-14 | Habersham | Georgia | 13137 | 10156 | 264 |
2332706 | 2332706 | 2022-03-22 | Vega Baja | Puerto Rico | 72145 | 10156 | |
2267356 | 2267356 | 2022-03-02 | Logan | Ohio | 39091 | 10156 | 166 |
2256984 | 2256984 | 2022-02-27 | Washington | Mississippi | 28151 | 10156 | 194 |
2253733 | 2253733 | 2022-02-26 | Washington | Mississippi | 28151 | 10156 | 194 |
2250482 | 2250482 | 2022-02-25 | Washington | Mississippi | 28151 | 10156 | 194 |
2217754 | 2217754 | 2022-02-15 | Hillsdale | Michigan | 26059 | 10156 | 184 |
2214503 | 2214503 | 2022-02-14 | Hillsdale | Michigan | 26059 | 10156 | 184 |
2176849 | 2176849 | 2022-02-02 | Burnet | Texas | 48053 | 10156 | 143 |
2082002 | 2082002 | 2022-01-04 | Seneca | Ohio | 39147 | 10156 | 192 |
2031526 | 2031526 | 2021-12-20 | Catoosa | Georgia | 13047 | 10156 | 123 |
2021272 | 2021272 | 2021-12-16 | Calumet | Wisconsin | 55015 | 10156 | 84 |
1929033 | 1929033 | 2021-11-18 | Franklin | North Carolina | 37069 | 10156 | 63 |
1713183 | 1713183 | 2021-09-13 | Walker | Georgia | 13295 | 10156 | 102 |
1490450 | 1490450 | 2021-07-06 | Burke | North Carolina | 37023 | 10156 | 164 |
1341574 | 1341574 | 2021-05-21 | Carolina | Puerto Rico | 72031 | 10156 | |
1141480 | 1141480 | 2021-03-21 | Citrus | Florida | 12017 | 10156 | 420 |
1036318 | 1036318 | 2021-02-16 | Fayette | Pennsylvania | 42051 | 10156 | 251 |
959515 | 959515 | 2021-01-24 | Faulkner | Arkansas | 5045 | 10156 | 124 |
790595 | 790595 | 2020-12-02 | Washington | Wisconsin | 55131 | 10156 | 77 |
717921 | 717921 | 2020-11-10 | Forsyth | North Carolina | 37067 | 10156 | 137 |
709568 | 709568 | 2020-11-08 | Anchorage | Alaska | 2020 | 10156 | 50 |
544878 | 544878 | 2020-09-18 | Lake | Indiana | 18089 | 10156 | 333 |
521585 | 521585 | 2020-09-11 | Pinal | Arizona | 4021 | 10156 | 193 |
500691 | 500691 | 2020-09-04 | Erie | New York | 36029 | 10156 | 607 |
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);