ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
118 rows where cases = 4026 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 14
- Indiana 11
- Mississippi 7
- Alabama 5
- Colorado 5
- North Carolina 5
- Ohio 5
- South Carolina 5
- South Dakota 5
- Tennessee 5
- Virginia 5
- Iowa 4
- New York 4
- Puerto Rico 4
- Illinois 3
- Kentucky 3
- Michigan 3
- Missouri 3
- Montana 3
- Arkansas 2
- Georgia 2
- Kansas 2
- Louisiana 2
- Minnesota 2
- Pennsylvania 2
- Maryland 1
- New Hampshire 1
- New Mexico 1
- Oklahoma 1
- Utah 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502107 | 2502107 | 2022-05-13 | Union | South Dakota | 46127 | 4026 | 52 |
2498849 | 2498849 | 2022-05-12 | Union | South Dakota | 46127 | 4026 | 52 |
2495591 | 2495591 | 2022-05-11 | Union | South Dakota | 46127 | 4026 | 52 |
2441648 | 2441648 | 2022-04-25 | Warren | Illinois | 17187 | 4026 | 87 |
2297398 | 2297398 | 2022-03-11 | Zavala | Texas | 48507 | 4026 | 67 |
2294146 | 2294146 | 2022-03-10 | Zavala | Texas | 48507 | 4026 | 67 |
2290894 | 2290894 | 2022-03-09 | Zavala | Texas | 48507 | 4026 | 67 |
2287112 | 2287112 | 2022-03-08 | Catano | Puerto Rico | 72033 | 4026 | |
2283860 | 2283860 | 2022-03-07 | Catano | Puerto Rico | 72033 | 4026 | |
2280608 | 2280608 | 2022-03-06 | Catano | Puerto Rico | 72033 | 4026 | |
2236774 | 2236774 | 2022-02-21 | Vermillion | Indiana | 18165 | 4026 | 71 |
2233523 | 2233523 | 2022-02-20 | Vermillion | Indiana | 18165 | 4026 | 71 |
2230272 | 2230272 | 2022-02-19 | Vermillion | Indiana | 18165 | 4026 | 71 |
2227021 | 2227021 | 2022-02-18 | Vermillion | Indiana | 18165 | 4026 | 71 |
2224479 | 2224479 | 2022-02-17 | Yalobusha | Mississippi | 28161 | 4026 | 52 |
2203485 | 2203485 | 2022-02-11 | Clay | Alabama | 1027 | 4026 | 73 |
2170459 | 2170459 | 2022-01-31 | Lavaca | Texas | 48285 | 4026 | 106 |
2129084 | 2129084 | 2022-01-19 | Elbert | Georgia | 13105 | 4026 | 94 |
2120492 | 2120492 | 2022-01-16 | Vernon | Missouri | 29217 | 4026 | 90 |
2117240 | 2117240 | 2022-01-15 | Vernon | Missouri | 29217 | 4026 | 90 |
2100857 | 2100857 | 2022-01-10 | Stone | Mississippi | 28131 | 4026 | 67 |
2098562 | 2098562 | 2022-01-09 | Fairfield | South Carolina | 45039 | 4026 | 96 |
2095310 | 2095310 | 2022-01-08 | Fairfield | South Carolina | 45039 | 4026 | 96 |
2095792 | 2095792 | 2022-01-08 | Orleans | Vermont | 50019 | 4026 | 31 |
2092058 | 2092058 | 2022-01-07 | Fairfield | South Carolina | 45039 | 4026 | 96 |
2082555 | 2082555 | 2022-01-04 | Dimmit | Texas | 48127 | 4026 | 47 |
2058577 | 2058577 | 2021-12-28 | Newton | Mississippi | 28101 | 4026 | 84 |
2059677 | 2059677 | 2021-12-28 | Haywood | Tennessee | 47075 | 4026 | 82 |
2028589 | 2028589 | 2021-12-19 | Fountain | Indiana | 18045 | 4026 | 70 |
2025338 | 2025338 | 2021-12-18 | Fountain | Indiana | 18045 | 4026 | 70 |
2022087 | 2022087 | 2021-12-17 | Fountain | Indiana | 18045 | 4026 | 70 |
2014053 | 2014053 | 2021-12-14 | Jasper | South Carolina | 45053 | 4026 | 82 |
1982641 | 1982641 | 2021-12-05 | Morgan | Colorado | 8087 | 4026 | 115 |
1979391 | 1979391 | 2021-12-04 | Morgan | Colorado | 8087 | 4026 | 115 |
1981484 | 1981484 | 2021-12-04 | Mayaguez | Puerto Rico | 72097 | 4026 | |
1976141 | 1976141 | 2021-12-03 | Morgan | Colorado | 8087 | 4026 | 115 |
1883160 | 1883160 | 2021-11-04 | McDonald | Missouri | 29119 | 4026 | 58 |
1879525 | 1879525 | 2021-11-03 | Union | Louisiana | 22111 | 4026 | 105 |
1879715 | 1879715 | 2021-11-03 | Le Sueur | Minnesota | 27079 | 4026 | 33 |
1855101 | 1855101 | 2021-10-26 | Jasper | Texas | 48241 | 4026 | 150 |
1792503 | 1792503 | 2021-10-07 | Orleans | New York | 36073 | 4026 | 86 |
1763455 | 1763455 | 2021-09-28 | Coshocton | Ohio | 39031 | 4026 | 70 |
1760256 | 1760256 | 2021-09-27 | Pike | Ohio | 39131 | 4026 | 45 |
1747644 | 1747644 | 2021-09-23 | Meade | South Dakota | 46093 | 4026 | 38 |
1733793 | 1733793 | 2021-09-19 | Ravalli | Montana | 30081 | 4026 | 55 |
1730543 | 1730543 | 2021-09-18 | Ravalli | Montana | 30081 | 4026 | 55 |
1727293 | 1727293 | 2021-09-17 | Ravalli | Montana | 30081 | 4026 | 55 |
1722455 | 1722455 | 2021-09-16 | Winston | Alabama | 1133 | 4026 | 82 |
1711282 | 1711282 | 2021-09-12 | Otsego | New York | 36077 | 4026 | 50 |
1692000 | 1692000 | 2021-09-06 | Guernsey | Ohio | 39059 | 4026 | 55 |
1667702 | 1667702 | 2021-08-30 | Unknown | Georgia | 4026 | 5 | |
1610806 | 1610806 | 2021-08-12 | Logan | Ohio | 39091 | 4026 | 79 |
1607308 | 1607308 | 2021-08-11 | Cortland | New York | 36023 | 4026 | 64 |
1512016 | 1512016 | 2021-07-13 | Miami | Indiana | 18103 | 4026 | 73 |
1495171 | 1495171 | 2021-07-08 | Independence | Arkansas | 5063 | 4026 | 125 |
1435673 | 1435673 | 2021-06-19 | Pike | Pennsylvania | 42103 | 4026 | 54 |
1436307 | 1436307 | 2021-06-19 | Charlottesville city | Virginia | 51540 | 4026 | 57 |
1433060 | 1433060 | 2021-06-18 | Charlottesville city | Virginia | 51540 | 4026 | 57 |
1426569 | 1426569 | 2021-06-16 | Charlottesville city | Virginia | 51540 | 4026 | 57 |
1414621 | 1414621 | 2021-06-13 | Huntington | Indiana | 18069 | 4026 | 83 |
1411376 | 1411376 | 2021-06-12 | Huntington | Indiana | 18069 | 4026 | 83 |
1408131 | 1408131 | 2021-06-11 | Huntington | Indiana | 18069 | 4026 | 83 |
1401185 | 1401185 | 2021-06-09 | Logan | Colorado | 8075 | 4026 | 68 |
1392035 | 1392035 | 2021-06-06 | Plymouth | Iowa | 19149 | 4026 | 81 |
1388790 | 1388790 | 2021-06-05 | Plymouth | Iowa | 19149 | 4026 | 80 |
1375607 | 1375607 | 2021-06-01 | Morgan | Illinois | 17137 | 4026 | 104 |
1365480 | 1365480 | 2021-05-29 | La Plata | Colorado | 8067 | 4026 | 41 |
1363218 | 1363218 | 2021-05-28 | Delta | Michigan | 26041 | 4026 | 94 |
1358017 | 1358017 | 2021-05-26 | Giles | Tennessee | 47055 | 4026 | 101 |
1334589 | 1334589 | 2021-05-19 | Columbia | New York | 36021 | 4026 | 102 |
1315256 | 1315256 | 2021-05-13 | Yadkin | North Carolina | 37197 | 4026 | 49 |
1310069 | 1310069 | 2021-05-12 | Tallapoosa | Alabama | 1123 | 4026 | 152 |
1311788 | 1311788 | 2021-05-12 | Belknap | New Hampshire | 33001 | 4026 | 100 |
1301732 | 1301732 | 2021-05-09 | Neshoba | Mississippi | 28099 | 4026 | 176 |
1297083 | 1297083 | 2021-05-08 | Tallapoosa | Alabama | 1123 | 4026 | 152 |
1298484 | 1298484 | 2021-05-08 | Neshoba | Mississippi | 28099 | 4026 | 176 |
1295238 | 1295238 | 2021-05-07 | Neshoba | Mississippi | 28099 | 4026 | 176 |
1270262 | 1270262 | 2021-04-29 | Williamsburg | South Carolina | 45089 | 4026 | 98 |
1252946 | 1252946 | 2021-04-24 | Nobles | Minnesota | 27105 | 4026 | 48 |
1246228 | 1246228 | 2021-04-22 | Natchitoches | Louisiana | 22069 | 4026 | 85 |
1218312 | 1218312 | 2021-04-13 | Brookings | South Dakota | 46011 | 4026 | 37 |
1172960 | 1172960 | 2021-03-30 | Marshall | Tennessee | 47117 | 4026 | 57 |
1137923 | 1137923 | 2021-03-20 | Covington | Alabama | 1039 | 4026 | 110 |
1132453 | 1132453 | 2021-03-18 | Graves | Kentucky | 21083 | 4026 | 81 |
1123798 | 1123798 | 2021-03-15 | Putnam | Ohio | 39137 | 4026 | 95 |
1119885 | 1119885 | 2021-03-14 | Monroe | Mississippi | 28095 | 4026 | 130 |
1091374 | 1091374 | 2021-03-05 | Custer | Oklahoma | 40039 | 4026 | 72 |
1065900 | 1065900 | 2021-02-25 | Cherokee | Texas | 48073 | 4026 | 120 |
1013890 | 1013890 | 2021-02-09 | Lincoln | Tennessee | 47103 | 4026 | 55 |
1008873 | 1008873 | 2021-02-08 | Buena Vista | Iowa | 19021 | 4026 | 36 |
989643 | 989643 | 2021-02-02 | Henderson | Kentucky | 21101 | 4026 | 57 |
950304 | 950304 | 2021-01-21 | Marion | Illinois | 17121 | 4026 | 113 |
950559 | 950559 | 2021-01-21 | Crawford | Kansas | 20037 | 4026 | 35 |
947313 | 947313 | 2021-01-20 | Crawford | Kansas | 20037 | 4026 | 35 |
942213 | 942213 | 2021-01-18 | Mifflin | Pennsylvania | 42087 | 4026 | 136 |
913579 | 913579 | 2021-01-09 | Box Elder | Utah | 49003 | 4026 | 28 |
894026 | 894026 | 2021-01-03 | Navarro | Texas | 48349 | 4026 | 62 |
890780 | 890780 | 2021-01-02 | Navarro | Texas | 48349 | 4026 | 62 |
887533 | 887533 | 2021-01-01 | Navarro | Texas | 48349 | 4026 | 62 |
884288 | 884288 | 2020-12-31 | Navarro | Texas | 48349 | 4026 | 62 |
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);