ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where cases = 8135 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 18
- Georgia 6
- Texas 4
- California 2
- Florida 2
- Illinois 2
- Kansas 2
- New York 2
- Ohio 2
- Wisconsin 2
- Alabama 1
- Arizona 1
- Colorado 1
- Mississippi 1
- New Hampshire 1
- New Jersey 1
- North Carolina 1
- Washington 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2339562 | 2339562 | 2022-03-24 | Kendall | Texas | 48259 | 8135 | 118 |
2171131 | 2171131 | 2022-02-01 | Amador | California | 6005 | 8135 | 73 |
2169815 | 2169815 | 2022-01-31 | Ottawa | Ohio | 39123 | 8135 | 125 |
2155597 | 2155597 | 2022-01-27 | Geary | Kansas | 20061 | 8135 | 64 |
2152344 | 2152344 | 2022-01-26 | Geary | Kansas | 20061 | 8135 | 64 |
2153200 | 2153200 | 2022-01-26 | Carroll | New Hampshire | 33003 | 8135 | 41 |
2145318 | 2145318 | 2022-01-24 | Bryan | Georgia | 13029 | 8135 | 78 |
2021312 | 2021312 | 2021-12-16 | Pierce | Wisconsin | 55093 | 8135 | 58 |
1878616 | 1878616 | 2021-11-03 | Garfield | Colorado | 8045 | 8135 | 64 |
1757533 | 1757533 | 2021-09-26 | Caldwell | Texas | 48055 | 8135 | 134 |
1754285 | 1754285 | 2021-09-25 | Caldwell | Texas | 48055 | 8135 | 133 |
1745640 | 1745640 | 2021-09-23 | Polk | Georgia | 13233 | 8135 | 133 |
1722587 | 1722587 | 2021-09-16 | Humboldt | California | 6023 | 8135 | 83 |
1696245 | 1696245 | 2021-09-07 | Skagit | Washington | 53057 | 8135 | 88 |
1614622 | 1614622 | 2021-08-13 | Coryell | Texas | 48099 | 8135 | 95 |
1558804 | 1558804 | 2021-07-27 | Erie | Ohio | 39043 | 8135 | 166 |
1514615 | 1514615 | 2021-07-14 | Santa Cruz | Arizona | 4023 | 8135 | 181 |
1451572 | 1451572 | 2021-06-24 | Sampson | North Carolina | 37163 | 8135 | 114 |
1287736 | 1287736 | 2021-05-05 | Glynn | Georgia | 13127 | 8135 | 172 |
1232452 | 1232452 | 2021-04-18 | Nassau | Florida | 12089 | 8135 | 124 |
1079915 | 1079915 | 2021-03-02 | Fayette | Georgia | 13113 | 8135 | 143 |
1055389 | 1055389 | 2021-02-22 | Putnam | New York | 36079 | 8135 | 86 |
1056739 | 1056739 | 2021-02-22 | Laramie | Wyoming | 56021 | 8135 | 105 |
1011933 | 1011933 | 2021-02-09 | DeKalb | Illinois | 17037 | 8135 | 111 |
893025 | 893025 | 2021-01-03 | Cumberland | New Jersey | 34011 | 8135 | 231 |
869161 | 869161 | 2020-12-27 | LaSalle | Illinois | 17099 | 8135 | 219 |
817031 | 817031 | 2020-12-11 | Forsyth | Georgia | 13117 | 8135 | 67 |
819799 | 819799 | 2020-12-11 | Walworth | Wisconsin | 55127 | 8135 | 66 |
804004 | 804004 | 2020-12-07 | Bibb | Georgia | 13021 | 8135 | 243 |
681746 | 681746 | 2020-10-30 | Hinds | Mississippi | 28049 | 8135 | 180 |
489512 | 489512 | 2020-09-01 | Pasco | Florida | 12101 | 8135 | 180 |
385988 | 385988 | 2020-07-31 | Mobile | Alabama | 1097 | 8135 | 192 |
358863 | 358863 | 2020-07-22 | Erie | New York | 36029 | 8135 | 614 |
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);