ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
70 rows where cases = 5427 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 29
- Utah 9
- Arkansas 7
- Mississippi 4
- Missouri 4
- Ohio 4
- Wisconsin 4
- Louisiana 3
- Minnesota 3
- Colorado 2
- Florida 2
- Idaho 2
- Indiana 2
- Michigan 2
- North Carolina 2
- Oklahoma 2
- Pennsylvania 2
- Puerto Rico 2
- Texas 2
- West Virginia 2
- Georgia 1
- Illinois 1
- Iowa 1
- Montana 1
- New Mexico 1
- New York 1
- South Carolina 1
- Tennessee 1
- Vermont 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2470379 | 2470379 | 2022-05-04 | Columbia | Arkansas | 5027 | 5427 | 95 |
2467123 | 2467123 | 2022-05-03 | Columbia | Arkansas | 5027 | 5427 | 95 |
2463868 | 2463868 | 2022-05-02 | Columbia | Arkansas | 5027 | 5427 | 95 |
2460612 | 2460612 | 2022-05-01 | Columbia | Arkansas | 5027 | 5427 | 95 |
2457356 | 2457356 | 2022-04-30 | Columbia | Arkansas | 5027 | 5427 | 95 |
2376301 | 2376301 | 2022-04-05 | Haralson | Georgia | 13143 | 5427 | 166 |
2349466 | 2349466 | 2022-03-27 | Sevier | Utah | 49041 | 5427 | 30 |
2346213 | 2346213 | 2022-03-26 | Sevier | Utah | 49041 | 5427 | 30 |
2342960 | 2342960 | 2022-03-25 | Sevier | Utah | 49041 | 5427 | 30 |
2339707 | 2339707 | 2022-03-24 | Sevier | Utah | 49041 | 5427 | 30 |
2336453 | 2336453 | 2022-03-23 | Sevier | Utah | 49041 | 5427 | 30 |
2290927 | 2290927 | 2022-03-09 | Caledonia | Vermont | 50005 | 5427 | 24 |
2259308 | 2259308 | 2022-02-28 | Blaine | Idaho | 16013 | 5427 | 30 |
2228868 | 2228868 | 2022-02-18 | Austin | Texas | 48015 | 5427 | 69 |
2225691 | 2225691 | 2022-02-17 | Frio | Texas | 48163 | 5427 | 86 |
2201488 | 2201488 | 2022-02-10 | Gladwin | Michigan | 26051 | 5427 | 105 |
2198234 | 2198234 | 2022-02-09 | Gladwin | Michigan | 26051 | 5427 | 105 |
2173326 | 2173326 | 2022-02-01 | Moca | Puerto Rico | 72099 | 5427 | |
2134229 | 2134229 | 2022-01-20 | Aguada | Puerto Rico | 72003 | 5427 | |
2057886 | 2057886 | 2021-12-28 | Scott | Indiana | 18143 | 5427 | 85 |
2008219 | 2008219 | 2021-12-12 | Greenbrier | West Virginia | 54025 | 5427 | 112 |
1996733 | 1996733 | 2021-12-09 | Nicollet | Minnesota | 27103 | 5427 | 61 |
1991946 | 1991946 | 2021-12-07 | Stevens | Washington | 53065 | 5427 | 106 |
1987257 | 1987257 | 2021-12-06 | Ravalli | Montana | 30081 | 5427 | 117 |
1941656 | 1941656 | 2021-11-22 | Marion | Missouri | 29127 | 5427 | 99 |
1943311 | 1943311 | 2021-11-22 | Trempealeau | Wisconsin | 55121 | 5427 | 52 |
1939747 | 1939747 | 2021-11-21 | Uintah | Utah | 49047 | 5427 | 54 |
1936497 | 1936497 | 2021-11-20 | Uintah | Utah | 49047 | 5427 | 54 |
1933247 | 1933247 | 2021-11-19 | Uintah | Utah | 49047 | 5427 | 54 |
1896911 | 1896911 | 2021-11-08 | Perry | Pennsylvania | 42099 | 5427 | 127 |
1877997 | 1877997 | 2021-11-02 | Sanpete | Utah | 49039 | 5427 | 39 |
1828943 | 1828943 | 2021-10-18 | Macon | Tennessee | 47111 | 5427 | 89 |
1762795 | 1762795 | 2021-09-28 | Alcorn | Mississippi | 28003 | 5427 | 90 |
1751814 | 1751814 | 2021-09-25 | Union | Arkansas | 5139 | 5427 | 126 |
1735980 | 1735980 | 2021-09-20 | Nez Perce | Idaho | 16069 | 5427 | 76 |
1736931 | 1736931 | 2021-09-20 | Howell | Missouri | 29091 | 5427 | 66 |
1718007 | 1718007 | 2021-09-14 | Mercer | Ohio | 39107 | 5427 | 88 |
1656174 | 1656174 | 2021-08-26 | Watauga | North Carolina | 37189 | 5427 | 33 |
1649259 | 1649259 | 2021-08-24 | Phelps | Missouri | 29161 | 5427 | 159 |
1636275 | 1636275 | 2021-08-20 | Scott | Missouri | 29201 | 5427 | 90 |
1629674 | 1629674 | 2021-08-18 | Warren | Mississippi | 28149 | 5427 | 130 |
1600904 | 1600904 | 2021-08-09 | Hoke | North Carolina | 37093 | 5427 | 56 |
1555293 | 1555293 | 2021-07-26 | Curry | New Mexico | 35009 | 5427 | 86 |
1474381 | 1474381 | 2021-07-01 | Darke | Ohio | 39037 | 5427 | 129 |
1447831 | 1447831 | 2021-06-23 | Washington | Mississippi | 28151 | 5427 | 138 |
1444586 | 1444586 | 2021-06-22 | Washington | Mississippi | 28151 | 5427 | 138 |
1386537 | 1386537 | 2021-06-04 | Genesee | New York | 36037 | 5427 | 124 |
1379354 | 1379354 | 2021-06-02 | St. Martin | Louisiana | 22099 | 5427 | 117 |
1314432 | 1314432 | 2021-05-13 | Vermilion | Louisiana | 22113 | 5427 | 119 |
1295873 | 1295873 | 2021-05-07 | Huron | Ohio | 39077 | 5427 | 119 |
1252385 | 1252385 | 2021-04-24 | Clinton | Iowa | 19045 | 5427 | 92 |
1174238 | 1174238 | 2021-03-31 | Coles | Illinois | 17029 | 5427 | 96 |
1104380 | 1104380 | 2021-03-09 | Le Flore | Oklahoma | 40079 | 5427 | 46 |
1066754 | 1066754 | 2021-02-26 | Fremont | Colorado | 8043 | 5427 | 48 |
1063509 | 1063509 | 2021-02-25 | Fremont | Colorado | 8043 | 5427 | 48 |
1046919 | 1046919 | 2021-02-19 | Barron | Wisconsin | 55005 | 5427 | 75 |
1000484 | 1000484 | 2021-02-05 | Bryan | Oklahoma | 40013 | 5427 | 50 |
964759 | 964759 | 2021-01-25 | Scioto | Ohio | 39145 | 5427 | 64 |
956893 | 956893 | 2021-01-23 | Morgan | Indiana | 18109 | 5427 | 100 |
927055 | 927055 | 2021-01-14 | Crawford | Arkansas | 5033 | 5427 | 73 |
915068 | 915068 | 2021-01-10 | Acadia | Louisiana | 22001 | 5427 | 164 |
895836 | 895836 | 2021-01-04 | Kandiyohi | Minnesota | 27067 | 5427 | 66 |
887863 | 887863 | 2021-01-01 | Monongalia | West Virginia | 54061 | 5427 | 31 |
816914 | 816914 | 2020-12-11 | Citrus | Florida | 12017 | 5427 | 203 |
819794 | 819794 | 2020-12-11 | St. Croix | Wisconsin | 55109 | 5427 | 22 |
653547 | 653547 | 2020-10-21 | Florence | South Carolina | 45041 | 5427 | 199 |
485825 | 485825 | 2020-08-30 | Dane | Wisconsin | 55025 | 5427 | 40 |
471083 | 471083 | 2020-08-26 | Dakota | Minnesota | 27037 | 5427 | 110 |
452632 | 452632 | 2020-08-20 | Chester | Pennsylvania | 42029 | 5427 | 351 |
178852 | 178852 | 2020-05-26 | Palm Beach | Florida | 12099 | 5427 | 315 |
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);