ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
132 rows where cases = 4126 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 17
- Louisiana 9
- Mississippi 9
- Pennsylvania 9
- Indiana 7
- Oklahoma 7
- Minnesota 6
- North Carolina 6
- Georgia 5
- Iowa 5
- Kentucky 5
- Missouri 5
- Arkansas 4
- West Virginia 4
- Alabama 3
- Illinois 3
- Nebraska 3
- New Hampshire 3
- South Carolina 3
- Tennessee 3
- Colorado 2
- Kansas 2
- Ohio 2
- Virgin Islands 2
- Wyoming 2
- Florida 1
- Massachusetts 1
- New York 1
- South Dakota 1
- Utah 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2498966 | 2498966 | 2022-05-12 | Bosque | Texas | 48035 | 4126 | 70 |
2450841 | 2450841 | 2022-04-28 | Clay | Arkansas | 5021 | 4126 | 93 |
2420460 | 2420460 | 2022-04-18 | Fulton | Pennsylvania | 42057 | 4126 | 65 |
2292673 | 2292673 | 2022-03-10 | Wadena | Minnesota | 27159 | 4126 | 52 |
2279762 | 2279762 | 2022-03-06 | Benton | Missouri | 29015 | 4126 | 91 |
2276509 | 2276509 | 2022-03-05 | Benton | Missouri | 29015 | 4126 | 91 |
2273256 | 2273256 | 2022-03-04 | Benton | Missouri | 29015 | 4126 | 91 |
2223273 | 2223273 | 2022-02-17 | Otero | Colorado | 8089 | 4126 | 125 |
2137901 | 2137901 | 2022-01-21 | Jones | Texas | 48253 | 4126 | 82 |
2132812 | 2132812 | 2022-01-20 | Dickinson | Kansas | 20041 | 4126 | 64 |
2134715 | 2134715 | 2022-01-20 | Reeves | Texas | 48389 | 4126 | 64 |
2129559 | 2129559 | 2022-01-19 | Dickinson | Kansas | 20041 | 4126 | 64 |
2123564 | 2123564 | 2022-01-17 | Clay | Mississippi | 28025 | 4126 | 78 |
2120312 | 2120312 | 2022-01-16 | Clay | Mississippi | 28025 | 4126 | 78 |
2117060 | 2117060 | 2022-01-15 | Clay | Mississippi | 28025 | 4126 | 78 |
2113809 | 2113809 | 2022-01-14 | Clay | Mississippi | 28025 | 4126 | 78 |
2098456 | 2098456 | 2022-01-09 | Wyoming | Pennsylvania | 42131 | 4126 | 92 |
2078021 | 2078021 | 2022-01-03 | Wabasha | Minnesota | 27157 | 4126 | 12 |
2066606 | 2066606 | 2021-12-30 | Lee | Virginia | 51105 | 4126 | 67 |
2063287 | 2063287 | 2021-12-29 | St. Thomas | Virgin Islands | 78030 | 4126 | 46 |
2060037 | 2060037 | 2021-12-28 | St. Thomas | Virgin Islands | 78030 | 4126 | 46 |
2051061 | 2051061 | 2021-12-26 | Franklin | Georgia | 13119 | 4126 | 85 |
2047811 | 2047811 | 2021-12-25 | Franklin | Georgia | 13119 | 4126 | 85 |
2044561 | 2044561 | 2021-12-24 | Franklin | Georgia | 13119 | 4126 | 85 |
2040767 | 2040767 | 2021-12-22 | Wyoming | West Virginia | 54109 | 4126 | 76 |
2040860 | 2040860 | 2021-12-22 | Uinta | Wyoming | 56041 | 4126 | 31 |
2011897 | 2011897 | 2021-12-14 | Morgan | Colorado | 8087 | 4126 | 120 |
1996126 | 1996126 | 2021-12-09 | Randolph | Indiana | 18135 | 4126 | 109 |
1939978 | 1939978 | 2021-11-21 | Nicholas | West Virginia | 54067 | 4126 | 57 |
1918909 | 1918909 | 2021-11-15 | Miller | Missouri | 29131 | 4126 | 79 |
1916417 | 1916417 | 2021-11-14 | Susquehanna | Pennsylvania | 42115 | 4126 | 70 |
1902767 | 1902767 | 2021-11-10 | Adams | Nebraska | 31001 | 4126 | 54 |
1842470 | 1842470 | 2021-10-22 | Hancock | West Virginia | 54029 | 4126 | 112 |
1834234 | 1834234 | 2021-10-20 | Mille Lacs | Minnesota | 27095 | 4126 | 66 |
1801083 | 1801083 | 2021-10-10 | Clay | Indiana | 18021 | 4126 | 61 |
1797834 | 1797834 | 2021-10-09 | Clay | Indiana | 18021 | 4126 | 61 |
1794585 | 1794585 | 2021-10-08 | Clay | Indiana | 18021 | 4126 | 61 |
1782211 | 1782211 | 2021-10-04 | Carlton | Minnesota | 27017 | 4126 | 60 |
1778710 | 1778710 | 2021-10-03 | Mercer | Kentucky | 21167 | 4126 | 67 |
1775460 | 1775460 | 2021-10-02 | Mercer | Kentucky | 21167 | 4126 | 67 |
1772210 | 1772210 | 2021-10-01 | Mercer | Kentucky | 21167 | 4126 | 67 |
1764630 | 1764630 | 2021-09-29 | Bibb | Alabama | 1007 | 4126 | 83 |
1739140 | 1739140 | 2021-09-21 | Pierce | Georgia | 13229 | 4126 | 85 |
1741072 | 1741072 | 2021-09-21 | Edgefield | South Carolina | 45037 | 4126 | 50 |
1710890 | 1710890 | 2021-09-12 | Wayne | Mississippi | 28153 | 4126 | 62 |
1707643 | 1707643 | 2021-09-11 | Wayne | Mississippi | 28153 | 4126 | 62 |
1704396 | 1704396 | 2021-09-10 | Wayne | Mississippi | 28153 | 4126 | 62 |
1701745 | 1701745 | 2021-09-09 | Guernsey | Ohio | 39059 | 4126 | 55 |
1669480 | 1669480 | 2021-08-30 | Perry | Pennsylvania | 42099 | 4126 | 102 |
1657436 | 1657436 | 2021-08-27 | Clarke | Alabama | 1025 | 4126 | 68 |
1657590 | 1657590 | 2021-08-27 | Poinsett | Arkansas | 5111 | 4126 | 90 |
1632451 | 1632451 | 2021-08-19 | Calloway | Kentucky | 21035 | 4126 | 52 |
1622432 | 1622432 | 2021-08-16 | Jasper | Indiana | 18073 | 4126 | 59 |
1579065 | 1579065 | 2021-08-02 | Uvalde | Texas | 48463 | 4126 | 73 |
1575817 | 1575817 | 2021-08-01 | Uvalde | Texas | 48463 | 4126 | 73 |
1572569 | 1572569 | 2021-07-31 | Uvalde | Texas | 48463 | 4126 | 73 |
1555799 | 1555799 | 2021-07-26 | Venango | Pennsylvania | 42121 | 4126 | 102 |
1538407 | 1538407 | 2021-07-21 | St. John the Baptist | Louisiana | 22095 | 4126 | 141 |
1497489 | 1497489 | 2021-07-08 | Williamsburg | South Carolina | 45089 | 4126 | 103 |
1494242 | 1494242 | 2021-07-07 | Williamsburg | South Carolina | 45089 | 4126 | 103 |
1465993 | 1465993 | 2021-06-29 | Union | Arkansas | 5139 | 4126 | 115 |
1445919 | 1445919 | 2021-06-22 | Rusk | Texas | 48401 | 4126 | 109 |
1442674 | 1442674 | 2021-06-21 | Rusk | Texas | 48401 | 4126 | 109 |
1425623 | 1425623 | 2021-06-16 | Yadkin | North Carolina | 37197 | 4126 | 54 |
1422376 | 1422376 | 2021-06-15 | Yadkin | North Carolina | 37197 | 4126 | 54 |
1409718 | 1409718 | 2021-06-11 | Wayne | Pennsylvania | 42127 | 4126 | 82 |
1392320 | 1392320 | 2021-06-06 | Natchitoches | Louisiana | 22069 | 4126 | 93 |
1392944 | 1392944 | 2021-06-06 | Belknap | New Hampshire | 33001 | 4126 | 100 |
1389075 | 1389075 | 2021-06-05 | Natchitoches | Louisiana | 22069 | 4126 | 93 |
1389699 | 1389699 | 2021-06-05 | Belknap | New Hampshire | 33001 | 4126 | 100 |
1385830 | 1385830 | 2021-06-04 | Natchitoches | Louisiana | 22069 | 4126 | 93 |
1386454 | 1386454 | 2021-06-04 | Belknap | New Hampshire | 33001 | 4126 | 100 |
1382466 | 1382466 | 2021-06-03 | Franklin | Kentucky | 21073 | 4126 | 56 |
1382584 | 1382584 | 2021-06-03 | Natchitoches | Louisiana | 22069 | 4126 | 93 |
1363466 | 1363466 | 2021-05-28 | Camden | Missouri | 29029 | 4126 | 88 |
1319282 | 1319282 | 2021-05-14 | Matagorda | Texas | 48321 | 4126 | 110 |
1314435 | 1314435 | 2021-05-13 | Webster | Louisiana | 22119 | 4126 | 113 |
1300947 | 1300947 | 2021-05-09 | Randolph | Illinois | 17157 | 4126 | 90 |
1294454 | 1294454 | 2021-05-07 | Randolph | Illinois | 17157 | 4126 | 90 |
1285411 | 1285411 | 2021-05-04 | Morrison | Minnesota | 27097 | 4126 | 60 |
1282530 | 1282530 | 2021-05-03 | Platte | Nebraska | 31141 | 4126 | 48 |
1244292 | 1244292 | 2021-04-21 | Brookings | South Dakota | 46011 | 4126 | 37 |
1236457 | 1236457 | 2021-04-19 | Avoyelles | Louisiana | 22009 | 4126 | 122 |
1237992 | 1237992 | 2021-04-19 | Cherokee | Texas | 48073 | 4126 | 136 |
1238575 | 1238575 | 2021-04-19 | Sweetwater | Wyoming | 56037 | 4126 | 37 |
1234745 | 1234745 | 2021-04-18 | Cherokee | Texas | 48073 | 4126 | 136 |
1231497 | 1231497 | 2021-04-17 | Cherokee | Texas | 48073 | 4126 | 136 |
1227652 | 1227652 | 2021-04-16 | Ashland | Ohio | 39005 | 4126 | 88 |
1228249 | 1228249 | 2021-04-16 | Cherokee | Texas | 48073 | 4126 | 136 |
1211299 | 1211299 | 2021-04-11 | Haywood | North Carolina | 37087 | 4126 | 92 |
1208050 | 1208050 | 2021-04-10 | Haywood | North Carolina | 37087 | 4126 | 92 |
1204802 | 1204802 | 2021-04-09 | Haywood | North Carolina | 37087 | 4126 | 92 |
1199940 | 1199940 | 2021-04-08 | DeSoto | Florida | 12027 | 4126 | 86 |
1195303 | 1195303 | 2021-04-06 | Mayes | Oklahoma | 40097 | 4126 | 43 |
1192055 | 1192055 | 2021-04-05 | Mayes | Oklahoma | 40097 | 4126 | 43 |
1188806 | 1188806 | 2021-04-04 | Mayes | Oklahoma | 40097 | 4126 | 43 |
1189468 | 1189468 | 2021-04-04 | Van Zandt | Texas | 48467 | 4126 | 114 |
1185559 | 1185559 | 2021-04-03 | Mayes | Oklahoma | 40097 | 4126 | 43 |
1186221 | 1186221 | 2021-04-03 | Van Zandt | Texas | 48467 | 4126 | 114 |
1182312 | 1182312 | 2021-04-02 | Mayes | Oklahoma | 40097 | 4126 | 43 |
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);