ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where cases = 4566 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Mississippi 12
- Ohio 7
- Texas 7
- Arkansas 5
- Georgia 5
- Tennessee 5
- Missouri 4
- California 3
- Kentucky 3
- Louisiana 3
- Virginia 3
- Wisconsin 3
- Alabama 2
- Alaska 2
- Illinois 2
- Iowa 2
- Maryland 2
- Nebraska 2
- North Carolina 2
- Puerto Rico 2
- South Carolina 2
- Colorado 1
- Florida 1
- Indiana 1
- Michigan 1
- Minnesota 1
- Montana 1
- New York 1
- Oregon 1
- Pennsylvania 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2476909 | 2476909 | 2022-05-06 | Hempstead | Arkansas | 5057 | 4566 | 68 |
2473651 | 2473651 | 2022-05-05 | Hempstead | Arkansas | 5057 | 4566 | 68 |
2470394 | 2470394 | 2022-05-04 | Hempstead | Arkansas | 5057 | 4566 | 68 |
2445845 | 2445845 | 2022-04-26 | Hill | Montana | 30041 | 4566 | 73 |
2442309 | 2442309 | 2022-04-25 | Houston | Minnesota | 27055 | 4566 | 18 |
2365194 | 2365194 | 2022-04-01 | Guayama | Puerto Rico | 72057 | 4566 | |
2237409 | 2237409 | 2022-02-21 | Calhoun | Mississippi | 28013 | 4566 | 62 |
2239143 | 2239143 | 2022-02-21 | Adams | Wisconsin | 55001 | 4566 | 49 |
2234158 | 2234158 | 2022-02-20 | Calhoun | Mississippi | 28013 | 4566 | 62 |
2230907 | 2230907 | 2022-02-19 | Calhoun | Mississippi | 28013 | 4566 | 62 |
2227656 | 2227656 | 2022-02-18 | Calhoun | Mississippi | 28013 | 4566 | 62 |
2200300 | 2200300 | 2022-02-10 | Nome Census Area | Alaska | 2180 | 4566 | 5 |
2197046 | 2197046 | 2022-02-09 | Nome Census Area | Alaska | 2180 | 4566 | 5 |
2155192 | 2155192 | 2022-01-27 | Tattnall | Georgia | 13267 | 4566 | 121 |
2138553 | 2138553 | 2022-01-22 | Lincoln | Arkansas | 5079 | 4566 | 60 |
2137921 | 2137921 | 2022-01-21 | Limestone | Texas | 48293 | 4566 | 116 |
2118557 | 2118557 | 2022-01-15 | Windham | Vermont | 50025 | 4566 | 31 |
2101448 | 2101448 | 2022-01-10 | Carroll | Ohio | 39019 | 4566 | 98 |
2010794 | 2010794 | 2021-12-13 | Edgefield | South Carolina | 45037 | 4566 | 60 |
2011387 | 2011387 | 2021-12-13 | Pulaski | Virginia | 51155 | 4566 | 101 |
1990523 | 1990523 | 2021-12-07 | Adams | Nebraska | 31001 | 4566 | 55 |
1988160 | 1988160 | 2021-12-06 | Grainger | Tennessee | 47057 | 4566 | 72 |
1983831 | 1983831 | 2021-12-05 | Simpson | Mississippi | 28127 | 4566 | 117 |
1980581 | 1980581 | 2021-12-04 | Simpson | Mississippi | 28127 | 4566 | 117 |
1977331 | 1977331 | 2021-12-03 | Simpson | Mississippi | 28127 | 4566 | 117 |
1973767 | 1973767 | 2021-12-02 | Sabine | Louisiana | 22085 | 4566 | 96 |
1966363 | 1966363 | 2021-11-30 | Delta | Colorado | 8029 | 4566 | 97 |
1967600 | 1967600 | 2021-11-30 | Yazoo | Mississippi | 28163 | 4566 | 92 |
1963048 | 1963048 | 2021-11-29 | Glenn | California | 6021 | 4566 | 51 |
1887249 | 1887249 | 2021-11-05 | Trujillo Alto | Puerto Rico | 72139 | 4566 | |
1836138 | 1836138 | 2021-10-21 | Geneva | Alabama | 1061 | 4566 | 126 |
1838228 | 1838228 | 2021-10-21 | Morrow | Ohio | 39117 | 4566 | 56 |
1828949 | 1828949 | 2021-10-18 | McNairy | Tennessee | 47109 | 4566 | 67 |
1760201 | 1760201 | 2021-09-27 | Champaign | Ohio | 39021 | 4566 | 64 |
1749613 | 1749613 | 2021-09-24 | Worcester | Maryland | 24047 | 4566 | 113 |
1735871 | 1735871 | 2021-09-20 | Lumpkin | Georgia | 13187 | 4566 | 88 |
1721681 | 1721681 | 2021-09-15 | Claiborne | Tennessee | 47025 | 4566 | 80 |
1700666 | 1700666 | 2021-09-09 | Boyle | Kentucky | 21021 | 4566 | 80 |
1698730 | 1698730 | 2021-09-08 | Venango | Pennsylvania | 42121 | 4566 | 108 |
1692358 | 1692358 | 2021-09-06 | Marion | South Carolina | 45067 | 4566 | 116 |
1612128 | 1612128 | 2021-08-13 | Union | Arkansas | 5139 | 4566 | 116 |
1607004 | 1607004 | 2021-08-11 | Lawrence | Missouri | 29109 | 4566 | 95 |
1600504 | 1600504 | 2021-08-09 | Laclede | Missouri | 29105 | 4566 | 92 |
1579168 | 1579168 | 2021-08-02 | Danville city | Virginia | 51590 | 4566 | 144 |
1569743 | 1569743 | 2021-07-31 | Franklin | Alabama | 1059 | 4566 | 81 |
1564798 | 1564798 | 2021-07-29 | Platte | Missouri | 29165 | 4566 | 53 |
1556223 | 1556223 | 2021-07-26 | Jim Wells | Texas | 48249 | 4566 | 108 |
1552976 | 1552976 | 2021-07-25 | Jim Wells | Texas | 48249 | 4566 | 108 |
1471788 | 1471788 | 2021-06-30 | Hill | Texas | 48217 | 4566 | 110 |
1468543 | 1468543 | 2021-06-29 | Hill | Texas | 48217 | 4566 | 110 |
1465298 | 1465298 | 2021-06-28 | Hill | Texas | 48217 | 4566 | 110 |
1446868 | 1446868 | 2021-06-23 | Thomas | Georgia | 13275 | 4566 | 125 |
1444966 | 1444966 | 2021-06-22 | Madison | New York | 36053 | 4566 | 89 |
1427393 | 1427393 | 2021-06-17 | Thomas | Georgia | 13275 | 4566 | 124 |
1392625 | 1392625 | 2021-06-06 | Marshall | Mississippi | 28093 | 4566 | 105 |
1389380 | 1389380 | 2021-06-05 | Marshall | Mississippi | 28093 | 4566 | 105 |
1386135 | 1386135 | 2021-06-04 | Marshall | Mississippi | 28093 | 4566 | 105 |
1314004 | 1314004 | 2021-05-13 | Lawrence | Indiana | 18093 | 4566 | 123 |
1287025 | 1287025 | 2021-05-04 | James City | Virginia | 51095 | 4566 | 72 |
1242932 | 1242932 | 2021-04-21 | Shelby | Kentucky | 21211 | 4566 | 70 |
1219749 | 1219749 | 2021-04-14 | Macoupin | Illinois | 17117 | 4566 | 110 |
1215766 | 1215766 | 2021-04-12 | Douglas | Wisconsin | 55031 | 4566 | 49 |
1171001 | 1171001 | 2021-03-30 | Effingham | Illinois | 17049 | 4566 | 82 |
1101011 | 1101011 | 2021-03-08 | Auglaize | Ohio | 39011 | 4566 | 82 |
1097765 | 1097765 | 2021-03-07 | Auglaize | Ohio | 39011 | 4566 | 82 |
1094517 | 1094517 | 2021-03-06 | Auglaize | Ohio | 39011 | 4566 | 82 |
1091271 | 1091271 | 2021-03-05 | Auglaize | Ohio | 39011 | 4566 | 82 |
1085439 | 1085439 | 2021-03-03 | Harrison | Texas | 48203 | 4566 | 95 |
1063480 | 1063480 | 2021-02-25 | Tehama | California | 6103 | 4566 | 52 |
1061088 | 1061088 | 2021-02-24 | Nelson | Kentucky | 21179 | 4566 | 35 |
1054760 | 1054760 | 2021-02-22 | Branch | Michigan | 26023 | 4566 | 110 |
1054926 | 1054926 | 2021-02-22 | Bolivar | Mississippi | 28011 | 4566 | 120 |
1032482 | 1032482 | 2021-02-15 | Dodge | Nebraska | 31053 | 4566 | 52 |
1005348 | 1005348 | 2021-02-07 | Tift | Georgia | 13277 | 4566 | 110 |
985292 | 985292 | 2021-01-31 | Oconto | Wisconsin | 55083 | 4566 | 54 |
950811 | 950811 | 2021-01-21 | St. Charles | Louisiana | 22089 | 4566 | 80 |
945081 | 945081 | 2021-01-19 | Columbus | North Carolina | 37047 | 4566 | 102 |
924493 | 924493 | 2021-01-13 | Cerro Gordo | Iowa | 19033 | 4566 | 65 |
906790 | 906790 | 2021-01-07 | Loudon | Tennessee | 47105 | 4566 | 45 |
828879 | 828879 | 2020-12-14 | Hamblen | Tennessee | 47063 | 4566 | 68 |
812331 | 812331 | 2020-12-09 | Jackson | Oregon | 41029 | 4566 | 44 |
749977 | 749977 | 2020-11-20 | Jasper | Missouri | 29097 | 4566 | 58 |
668212 | 668212 | 2020-10-26 | Scott | Iowa | 19163 | 4566 | 39 |
645784 | 645784 | 2020-10-19 | Rapides | Louisiana | 22079 | 4566 | 153 |
581717 | 581717 | 2020-09-29 | Johnston | North Carolina | 37101 | 4566 | 57 |
473348 | 473348 | 2020-08-27 | Santa Rosa | Florida | 12113 | 4566 | 55 |
149349 | 149349 | 2020-05-16 | Baltimore | Maryland | 24005 | 4566 | 240 |
28564 | 28564 | 2020-04-03 | Los Angeles | California | 6037 | 4566 | 89 |
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);