ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
99 rows where cases = 4757 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 9
- Kentucky 9
- Virginia 8
- Kansas 7
- Puerto Rico 6
- Texas 5
- Colorado 4
- Alabama 3
- Illinois 3
- Iowa 3
- Minnesota 3
- Missouri 3
- New York 3
- West Virginia 3
- Wisconsin 3
- Arkansas 2
- California 2
- Louisiana 2
- Michigan 2
- Montana 2
- North Carolina 2
- Ohio 2
- South Carolina 2
- South Dakota 2
- Florida 1
- Hawaii 1
- Indiana 1
- Mississippi 1
- Nebraska 1
- Oklahoma 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2449108 | 2449108 | 2022-04-27 | Lincoln | Montana | 30053 | 4757 | 88 |
2416006 | 2416006 | 2022-04-17 | Powell | Kentucky | 21197 | 4757 | 42 |
2412750 | 2412750 | 2022-04-16 | Powell | Kentucky | 21197 | 4757 | 42 |
2409494 | 2409494 | 2022-04-15 | Powell | Kentucky | 21197 | 4757 | 42 |
2406077 | 2406077 | 2022-04-14 | Jefferson | Kansas | 20087 | 4757 | 61 |
2406238 | 2406238 | 2022-04-14 | Powell | Kentucky | 21197 | 4757 | 42 |
2402821 | 2402821 | 2022-04-13 | Jefferson | Kansas | 20087 | 4757 | 61 |
2402982 | 2402982 | 2022-04-13 | Powell | Kentucky | 21197 | 4757 | 42 |
2399567 | 2399567 | 2022-04-12 | Jefferson | Kansas | 20087 | 4757 | 61 |
2399728 | 2399728 | 2022-04-12 | Powell | Kentucky | 21197 | 4757 | 42 |
2401015 | 2401015 | 2022-04-12 | Morovis | Puerto Rico | 72101 | 4757 | |
2396311 | 2396311 | 2022-04-11 | Jefferson | Kansas | 20087 | 4757 | 61 |
2396472 | 2396472 | 2022-04-11 | Powell | Kentucky | 21197 | 4757 | 42 |
2393056 | 2393056 | 2022-04-10 | Jefferson | Kansas | 20087 | 4757 | 61 |
2389800 | 2389800 | 2022-04-09 | Jefferson | Kansas | 20087 | 4757 | 61 |
2386544 | 2386544 | 2022-04-08 | Jefferson | Kansas | 20087 | 4757 | 61 |
2376231 | 2376231 | 2022-04-05 | Appling | Georgia | 13001 | 4757 | 123 |
2355771 | 2355771 | 2022-03-29 | Fayette | Texas | 48149 | 4757 | 104 |
2313079 | 2313079 | 2022-03-16 | Juniata | Pennsylvania | 42067 | 4757 | 175 |
2297933 | 2297933 | 2022-03-12 | Phillips | Arkansas | 5107 | 4757 | 96 |
2263273 | 2263273 | 2022-03-01 | Iosco | Michigan | 26069 | 4757 | 134 |
2260022 | 2260022 | 2022-02-28 | Iosco | Michigan | 26069 | 4757 | 134 |
2240986 | 2240986 | 2022-02-22 | Saunders | Nebraska | 31155 | 4757 | 28 |
2171092 | 2171092 | 2022-02-01 | Lincoln | Arkansas | 5079 | 4757 | 60 |
2160313 | 2160313 | 2022-01-28 | Naranjito | Puerto Rico | 72105 | 4757 | |
2155451 | 2155451 | 2022-01-27 | Sullivan | Indiana | 18153 | 4757 | 68 |
2151862 | 2151862 | 2022-01-26 | Fannin | Georgia | 13111 | 4757 | 124 |
2134528 | 2134528 | 2022-01-20 | Austin | Texas | 48015 | 4757 | 59 |
2086096 | 2086096 | 2022-01-05 | Gloucester | Virginia | 51073 | 4757 | 83 |
2050872 | 2050872 | 2021-12-26 | Delta | Colorado | 8029 | 4757 | 120 |
2047622 | 2047622 | 2021-12-25 | Delta | Colorado | 8029 | 4757 | 120 |
2044372 | 2044372 | 2021-12-24 | Delta | Colorado | 8029 | 4757 | 120 |
2023700 | 2023700 | 2021-12-17 | Arecibo | Puerto Rico | 72013 | 4757 | |
2008774 | 2008774 | 2021-12-13 | Chattooga | Georgia | 13055 | 4757 | 108 |
2003387 | 2003387 | 2021-12-11 | Dunklin | Missouri | 29069 | 4757 | 93 |
2004970 | 2004970 | 2021-12-11 | Hancock | West Virginia | 54029 | 4757 | 121 |
1988105 | 1988105 | 2021-12-06 | Lawrence | South Dakota | 46081 | 4757 | 68 |
1940503 | 1940503 | 2021-11-22 | Butts | Georgia | 13035 | 4757 | 123 |
1917410 | 1917410 | 2021-11-15 | Winston | Alabama | 1133 | 4757 | 106 |
1905898 | 1905898 | 2021-11-11 | Lafayette | Missouri | 29107 | 4757 | 74 |
1902649 | 1902649 | 2021-11-10 | Lafayette | Missouri | 29107 | 4757 | 74 |
1884773 | 1884773 | 2021-11-04 | Green | Wisconsin | 55045 | 4757 | 34 |
1845868 | 1845868 | 2021-10-24 | Clarke | Alabama | 1025 | 4757 | 84 |
1835900 | 1835900 | 2021-10-20 | Smyth | Virginia | 51173 | 4757 | 113 |
1826223 | 1826223 | 2021-10-17 | Greenbrier | West Virginia | 54025 | 4757 | 88 |
1777516 | 1777516 | 2021-10-02 | Randolph | West Virginia | 54083 | 4757 | 35 |
1746511 | 1746511 | 2021-09-23 | Morrison | Minnesota | 27097 | 4757 | 63 |
1685283 | 1685283 | 2021-09-04 | Montgomery | New York | 36057 | 4757 | 131 |
1682228 | 1682228 | 2021-09-03 | Brown | Ohio | 39015 | 4757 | 65 |
1666959 | 1666959 | 2021-08-29 | Shenandoah | Virginia | 51171 | 4757 | 137 |
1663711 | 1663711 | 2021-08-28 | Shenandoah | Virginia | 51171 | 4757 | 137 |
1660463 | 1660463 | 2021-08-27 | Shenandoah | Virginia | 51171 | 4757 | 137 |
1582948 | 1582948 | 2021-08-04 | Tuolumne | California | 6109 | 4757 | 73 |
1489590 | 1489590 | 2021-07-06 | Hopkins | Kentucky | 21107 | 4757 | 150 |
1469054 | 1469054 | 2021-06-29 | Sweetwater | Wyoming | 56037 | 4757 | 40 |
1444443 | 1444443 | 2021-06-22 | Douglas | Minnesota | 27041 | 4757 | 81 |
1413602 | 1413602 | 2021-06-12 | Fauquier | Virginia | 51061 | 4757 | 70 |
1407949 | 1407949 | 2021-06-11 | Maui | Hawaii | 15009 | 4757 | 55 |
1401527 | 1401527 | 2021-06-09 | Effingham | Illinois | 17049 | 4757 | 83 |
1396809 | 1396809 | 2021-06-07 | Toa Alta | Puerto Rico | 72135 | 4757 | |
1312657 | 1312657 | 2021-05-12 | Burnet | Texas | 48053 | 4757 | 65 |
1308111 | 1308111 | 2021-05-11 | Goodhue | Minnesota | 27049 | 4757 | 72 |
1309410 | 1309410 | 2021-05-11 | Burnet | Texas | 48053 | 4757 | 64 |
1302668 | 1302668 | 2021-05-09 | Toa Baja | Puerto Rico | 72137 | 4757 | |
1298875 | 1298875 | 2021-05-08 | Clinton | New York | 36019 | 4757 | 33 |
1234151 | 1234151 | 2021-04-18 | Auglaize | Ohio | 39011 | 4757 | 84 |
1194199 | 1194199 | 2021-04-06 | Nelson | Kentucky | 21179 | 4757 | 50 |
1168996 | 1168996 | 2021-03-29 | Herkimer | New York | 36043 | 4757 | 107 |
1144923 | 1144923 | 2021-03-22 | Tift | Georgia | 13277 | 4757 | 123 |
1141676 | 1141676 | 2021-03-21 | Tift | Georgia | 13277 | 4757 | 123 |
1138430 | 1138430 | 2021-03-20 | Tift | Georgia | 13277 | 4757 | 123 |
1135184 | 1135184 | 2021-03-19 | Tift | Georgia | 13277 | 4757 | 123 |
1104128 | 1104128 | 2021-03-09 | Edgecombe | North Carolina | 37065 | 4757 | 100 |
1088512 | 1088512 | 2021-03-04 | Franklin | Tennessee | 47051 | 4757 | 85 |
1073857 | 1073857 | 2021-02-28 | Sioux | Iowa | 19167 | 4757 | 69 |
1070611 | 1070611 | 2021-02-27 | Sioux | Iowa | 19167 | 4757 | 69 |
1067366 | 1067366 | 2021-02-26 | Sioux | Iowa | 19167 | 4757 | 69 |
1035210 | 1035210 | 2021-02-16 | Vermilion | Louisiana | 22113 | 4757 | 105 |
1031964 | 1031964 | 2021-02-15 | Vermilion | Louisiana | 22113 | 4757 | 105 |
968503 | 968503 | 2021-01-26 | Bastrop | Texas | 48021 | 4757 | 59 |
881466 | 881466 | 2020-12-30 | Waupaca | Wisconsin | 55135 | 4757 | 135 |
875391 | 875391 | 2020-12-29 | Walton | Florida | 12131 | 4757 | 45 |
810283 | 810283 | 2020-12-09 | Butte | California | 6007 | 4757 | 64 |
782533 | 782533 | 2020-11-30 | Missoula | Montana | 30063 | 4757 | 43 |
741038 | 741038 | 2020-11-17 | Carolina | Puerto Rico | 72031 | 4757 | |
719676 | 719676 | 2020-11-11 | Floyd | Georgia | 13115 | 4757 | 68 |
695732 | 695732 | 2020-11-03 | Pickens | South Carolina | 45077 | 4757 | 68 |
690719 | 690719 | 2020-11-02 | Rock Island | Illinois | 17161 | 4757 | 104 |
640034 | 640034 | 2020-10-17 | Alamance | North Carolina | 37001 | 4757 | 59 |
601628 | 601628 | 2020-10-05 | Anderson | South Carolina | 45007 | 4757 | 184 |
598995 | 598995 | 2020-10-04 | Richmond city | Virginia | 51760 | 4757 | 62 |
537615 | 537615 | 2020-09-15 | Racine | Wisconsin | 55101 | 4757 | 94 |
525414 | 525414 | 2020-09-12 | Winnebago | Illinois | 17201 | 4757 | 152 |
520397 | 520397 | 2020-09-10 | Cleveland | Oklahoma | 40027 | 4757 | 67 |
511776 | 511776 | 2020-09-08 | Baldwin | Alabama | 1003 | 4757 | 46 |
505044 | 505044 | 2020-09-05 | Henrico | Virginia | 51087 | 4757 | 194 |
497035 | 497035 | 2020-09-03 | DeSoto | Mississippi | 28033 | 4757 | 48 |
452864 | 452864 | 2020-08-20 | Minnehaha | South Dakota | 46099 | 4757 | 70 |
325315 | 325315 | 2020-07-12 | Adams | Colorado | 8001 | 4757 | 158 |
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);