ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
24 rows where cases = 7990 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 17
- Utah 4
- Florida 2
- Kentucky 2
- Louisiana 2
- Texas 2
- Arizona 1
- Colorado 1
- Georgia 1
- Illinois 1
- Maine 1
- Mississippi 1
- New Hampshire 1
- Ohio 1
- Pennsylvania 1
- Tennessee 1
- Virginia 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2355946 | 2355946 | 2022-03-29 | Wood | Texas | 48499 | 7990 | 283 |
2284414 | 2284414 | 2022-03-07 | Uintah | Utah | 49047 | 7990 | 64 |
2281162 | 2281162 | 2022-03-06 | Uintah | Utah | 49047 | 7990 | 64 |
2277909 | 2277909 | 2022-03-05 | Uintah | Utah | 49047 | 7990 | 64 |
2274656 | 2274656 | 2022-03-04 | Uintah | Utah | 49047 | 7990 | 64 |
2167304 | 2167304 | 2022-01-30 | Wharton | Texas | 48481 | 7990 | 196 |
2149957 | 2149957 | 2022-01-25 | Unknown | New Hampshire | 7990 | 21 | |
1981170 | 1981170 | 2021-12-04 | Auglaize | Ohio | 39011 | 7990 | 120 |
1848979 | 1848979 | 2021-10-24 | Marion | West Virginia | 54049 | 7990 | 101 |
1833917 | 1833917 | 2021-10-20 | Jessamine | Kentucky | 21113 | 7990 | 94 |
1807974 | 1807974 | 2021-10-12 | Scott | Kentucky | 21209 | 7990 | 43 |
1508526 | 1508526 | 2021-07-12 | Rockdale | Georgia | 13247 | 7990 | 179 |
1403457 | 1403457 | 2021-06-09 | Greene | Tennessee | 47059 | 7990 | 159 |
1335704 | 1335704 | 2021-05-19 | Frederick | Virginia | 51069 | 7990 | 101 |
1225922 | 1225922 | 2021-04-16 | Columbia | Florida | 12023 | 7990 | 165 |
1084164 | 1084164 | 2021-03-03 | Jones | Mississippi | 28067 | 7990 | 147 |
1070114 | 1070114 | 2021-02-27 | Sumter | Florida | 12119 | 7990 | 238 |
1060598 | 1060598 | 2021-02-24 | Adams | Illinois | 17001 | 7990 | 142 |
1002745 | 1002745 | 2021-02-06 | St. Landry | Louisiana | 22097 | 7990 | 230 |
999499 | 999499 | 2021-02-05 | St. Landry | Louisiana | 22097 | 7990 | 230 |
963829 | 963829 | 2021-01-25 | York | Maine | 23031 | 7990 | 97 |
463529 | 463529 | 2020-08-24 | Arapahoe | Colorado | 8005 | 7990 | 366 |
386045 | 386045 | 2020-07-31 | Pinal | Arizona | 4021 | 7990 | 136 |
248564 | 248564 | 2020-06-17 | Montgomery | Pennsylvania | 42091 | 7990 | 778 |
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);