ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
38 rows where cases = 8468 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 19
- Alabama 6
- Missouri 4
- Pennsylvania 4
- Ohio 3
- Wisconsin 3
- Arkansas 2
- Colorado 2
- Louisiana 2
- Montana 2
- Georgia 1
- Idaho 1
- Illinois 1
- Nebraska 1
- New Jersey 1
- New Mexico 1
- North Carolina 1
- Puerto Rico 1
- Texas 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492172 | 2492172 | 2022-05-10 | Gurabo | Puerto Rico | 72063 | 8468 | |
2466965 | 2466965 | 2022-05-02 | Trempealeau | Wisconsin | 55121 | 8468 | 64 |
2446508 | 2446508 | 2022-04-26 | Greene | Pennsylvania | 42059 | 8468 | 104 |
2443253 | 2443253 | 2022-04-25 | Greene | Pennsylvania | 42059 | 8468 | 104 |
2439997 | 2439997 | 2022-04-24 | Greene | Pennsylvania | 42059 | 8468 | 104 |
2436741 | 2436741 | 2022-04-23 | Greene | Pennsylvania | 42059 | 8468 | 104 |
2394839 | 2394839 | 2022-04-10 | Grimes | Texas | 48185 | 8468 | 119 |
2384012 | 2384012 | 2022-04-07 | Silver Bow | Montana | 30093 | 8468 | 130 |
2380757 | 2380757 | 2022-04-06 | Silver Bow | Montana | 30093 | 8468 | 130 |
2369343 | 2369343 | 2022-04-03 | Chambers | Alabama | 1017 | 8468 | 161 |
2366090 | 2366090 | 2022-04-02 | Chambers | Alabama | 1017 | 8468 | 161 |
2362837 | 2362837 | 2022-04-01 | Chambers | Alabama | 1017 | 8468 | 161 |
2359583 | 2359583 | 2022-03-31 | Chambers | Alabama | 1017 | 8468 | 161 |
2356329 | 2356329 | 2022-03-30 | Chambers | Alabama | 1017 | 8468 | 161 |
2359523 | 2359523 | 2022-03-30 | Oneida | Wisconsin | 55085 | 8468 | 135 |
2249104 | 2249104 | 2022-02-25 | Baxter | Arkansas | 5005 | 8468 | 228 |
2213105 | 2213105 | 2022-02-13 | Marshall | West Virginia | 54051 | 8468 | 146 |
2130339 | 2130339 | 2022-01-19 | Dodge | Nebraska | 31053 | 8468 | 84 |
2126000 | 2126000 | 2022-01-18 | Christian | Illinois | 17021 | 8468 | 118 |
1911001 | 1911001 | 2021-11-13 | Mississippi | Arkansas | 5093 | 8468 | 144 |
1825214 | 1825214 | 2021-10-17 | Jefferson | Ohio | 39081 | 8468 | 191 |
1712662 | 1712662 | 2021-09-13 | Coffee | Alabama | 1031 | 8468 | 149 |
1553929 | 1553929 | 2021-07-26 | Gordon | Georgia | 13129 | 8468 | 120 |
1516496 | 1516496 | 2021-07-14 | Surry | North Carolina | 37171 | 8468 | 171 |
1074496 | 1074496 | 2021-02-28 | Christian | Missouri | 29043 | 8468 | 78 |
1071250 | 1071250 | 2021-02-27 | Christian | Missouri | 29043 | 8468 | 78 |
1068005 | 1068005 | 2021-02-26 | Christian | Missouri | 29043 | 8468 | 78 |
973536 | 973536 | 2021-01-28 | Terrebonne | Louisiana | 22109 | 8468 | 176 |
928440 | 928440 | 2021-01-14 | Cape Girardeau | Missouri | 29031 | 8468 | 128 |
922566 | 922566 | 2021-01-12 | Richland | Ohio | 39139 | 8468 | 106 |
893291 | 893291 | 2021-01-03 | Allen | Ohio | 39003 | 8468 | 111 |
828152 | 828152 | 2020-12-14 | McKinley | New Mexico | 35031 | 8468 | 311 |
800941 | 800941 | 2020-12-06 | Kootenai | Idaho | 16055 | 8468 | 86 |
748392 | 748392 | 2020-11-19 | Rock | Wisconsin | 55105 | 8468 | 64 |
550853 | 550853 | 2020-09-20 | Adams | Colorado | 8001 | 8468 | 221 |
512020 | 512020 | 2020-09-08 | Arapahoe | Colorado | 8005 | 8468 | 370 |
513566 | 513566 | 2020-09-08 | Mercer | New Jersey | 34021 | 8468 | 632 |
244356 | 244356 | 2020-06-16 | Jefferson | Louisiana | 22051 | 8468 | 471 |
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);