ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45 rows where cases = 8038 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 22
- Utah 7
- Texas 6
- Ohio 4
- Arizona 3
- Georgia 3
- Maine 3
- Pennsylvania 3
- Illinois 2
- Alabama 1
- Connecticut 1
- Florida 1
- Indiana 1
- Louisiana 1
- Minnesota 1
- Mississippi 1
- Missouri 1
- New Jersey 1
- New York 1
- North Carolina 1
- South Dakota 1
- Virginia 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2450373 | 2450373 | 2022-04-27 | Uintah | Utah | 49047 | 8038 | 71 |
2447116 | 2447116 | 2022-04-26 | Uintah | Utah | 49047 | 8038 | 71 |
2443861 | 2443861 | 2022-04-25 | Uintah | Utah | 49047 | 8038 | 71 |
2440605 | 2440605 | 2022-04-24 | Uintah | Utah | 49047 | 8038 | 71 |
2437349 | 2437349 | 2022-04-23 | Uintah | Utah | 49047 | 8038 | 71 |
2434093 | 2434093 | 2022-04-22 | Uintah | Utah | 49047 | 8038 | 71 |
2404210 | 2404210 | 2022-04-13 | Tioga | Pennsylvania | 42117 | 8038 | 192 |
2270820 | 2270820 | 2022-03-03 | Snyder | Pennsylvania | 42109 | 8038 | 151 |
2222201 | 2222201 | 2022-02-16 | Brookings | South Dakota | 46011 | 8038 | 48 |
2190055 | 2190055 | 2022-02-06 | Titus | Texas | 48449 | 8038 | 118 |
2179351 | 2179351 | 2022-02-03 | Wyoming | New York | 36121 | 8038 | 80 |
2157811 | 2157811 | 2022-01-27 | Preston | West Virginia | 54077 | 8038 | 117 |
2146101 | 2146101 | 2022-01-24 | Aroostook | Maine | 23003 | 8038 | 111 |
2142846 | 2142846 | 2022-01-23 | Aroostook | Maine | 23003 | 8038 | 111 |
2139591 | 2139591 | 2022-01-22 | Aroostook | Maine | 23003 | 8038 | 111 |
2129312 | 2129312 | 2022-01-19 | Morgan | Illinois | 17137 | 8038 | 128 |
2100956 | 2100956 | 2022-01-10 | Phelps | Missouri | 29161 | 8038 | 205 |
2061798 | 2061798 | 2021-12-29 | Hancock | Mississippi | 28045 | 8038 | 132 |
1992822 | 1992822 | 2021-12-08 | DeKalb | Indiana | 18033 | 8038 | 115 |
1831756 | 1831756 | 2021-10-19 | Washington | Ohio | 39167 | 8038 | 138 |
1566118 | 1566118 | 2021-07-29 | Tooele | Utah | 49045 | 8038 | 49 |
1541023 | 1541023 | 2021-07-22 | Walker | Georgia | 13295 | 8038 | 91 |
1393245 | 1393245 | 2021-06-06 | Erie | Ohio | 39043 | 8038 | 161 |
1380264 | 1380264 | 2021-06-02 | Erie | Ohio | 39043 | 8038 | 160 |
1377019 | 1377019 | 2021-06-01 | Erie | Ohio | 39043 | 8038 | 160 |
1368555 | 1368555 | 2021-05-30 | Santa Cruz | Arizona | 4023 | 8038 | 180 |
1365309 | 1365309 | 2021-05-29 | Santa Cruz | Arizona | 4023 | 8038 | 180 |
1364723 | 1364723 | 2021-05-28 | Liberty | Texas | 48291 | 8038 | 187 |
1275636 | 1275636 | 2021-05-01 | Clay | Minnesota | 27027 | 8038 | 91 |
1257094 | 1257094 | 2021-04-25 | Clearfield | Pennsylvania | 42033 | 8038 | 135 |
1203220 | 1203220 | 2021-04-09 | Nassau | Florida | 12089 | 8038 | 121 |
1196810 | 1196810 | 2021-04-07 | Gordon | Georgia | 13129 | 8038 | 110 |
1131184 | 1131184 | 2021-03-17 | Portsmouth city | Virginia | 51740 | 8038 | 161 |
1099261 | 1099261 | 2021-03-08 | Tolland | Connecticut | 9013 | 8038 | 172 |
1007679 | 1007679 | 2021-02-07 | Walker | Texas | 48471 | 8038 | 107 |
897818 | 897818 | 2021-01-05 | Cochise | Arizona | 4003 | 8038 | 143 |
784553 | 784553 | 2020-12-01 | Clarke | Georgia | 13059 | 8038 | 55 |
748435 | 748435 | 2020-11-20 | Baldwin | Alabama | 1003 | 8038 | 84 |
743748 | 743748 | 2020-11-18 | Somerset | New Jersey | 34035 | 8038 | 605 |
735036 | 735036 | 2020-11-15 | Smith | Texas | 48423 | 8038 | 187 |
731790 | 731790 | 2020-11-14 | Smith | Texas | 48423 | 8038 | 187 |
728545 | 728545 | 2020-11-13 | Smith | Texas | 48423 | 8038 | 187 |
619351 | 619351 | 2020-10-11 | St. Clair | Illinois | 17163 | 8038 | 202 |
604389 | 604389 | 2020-10-06 | Durham | North Carolina | 37063 | 8038 | 98 |
448287 | 448287 | 2020-08-19 | Lafayette | Louisiana | 22055 | 8038 | 104 |
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);