ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
107 rows where cases = 4632 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Mississippi 18
- Texas 9
- Arkansas 8
- South Carolina 8
- Georgia 6
- Minnesota 5
- New Hampshire 5
- North Carolina 5
- Alabama 4
- Kentucky 4
- Ohio 4
- New York 3
- Puerto Rico 3
- Alaska 2
- Colorado 2
- Illinois 2
- Indiana 2
- Pennsylvania 2
- Virginia 2
- California 1
- Florida 1
- Iowa 1
- Maryland 1
- Missouri 1
- North Dakota 1
- Oklahoma 1
- Oregon 1
- South Dakota 1
- Utah 1
- Washington 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492628 | 2492628 | 2022-05-10 | Reeves | Texas | 48389 | 4632 | 74 |
2487154 | 2487154 | 2022-05-09 | Cass | Illinois | 17017 | 4632 | 44 |
2428105 | 2428105 | 2022-04-21 | Sharp | Arkansas | 5135 | 4632 | 105 |
2423655 | 2423655 | 2022-04-19 | Clatsop | Oregon | 41007 | 4632 | 49 |
2415081 | 2415081 | 2022-04-17 | Sharp | Arkansas | 5135 | 4632 | 105 |
2411825 | 2411825 | 2022-04-16 | Sharp | Arkansas | 5135 | 4632 | 105 |
2408569 | 2408569 | 2022-04-15 | Sharp | Arkansas | 5135 | 4632 | 105 |
2405313 | 2405313 | 2022-04-14 | Sharp | Arkansas | 5135 | 4632 | 105 |
2402058 | 2402058 | 2022-04-13 | Sharp | Arkansas | 5135 | 4632 | 105 |
2358667 | 2358667 | 2022-03-30 | Barranquitas | Puerto Rico | 72019 | 4632 | |
2302443 | 2302443 | 2022-03-13 | Calhoun | Mississippi | 28013 | 4632 | 70 |
2299191 | 2299191 | 2022-03-12 | Calhoun | Mississippi | 28013 | 4632 | 70 |
2295939 | 2295939 | 2022-03-11 | Calhoun | Mississippi | 28013 | 4632 | 70 |
2292687 | 2292687 | 2022-03-10 | Calhoun | Mississippi | 28013 | 4632 | 70 |
2289435 | 2289435 | 2022-03-09 | Calhoun | Mississippi | 28013 | 4632 | 70 |
2286184 | 2286184 | 2022-03-08 | Calhoun | Mississippi | 28013 | 4632 | 70 |
2282932 | 2282932 | 2022-03-07 | Calhoun | Mississippi | 28013 | 4632 | 70 |
2279679 | 2279679 | 2022-03-06 | Calhoun | Mississippi | 28013 | 4632 | 70 |
2276426 | 2276426 | 2022-03-05 | Calhoun | Mississippi | 28013 | 4632 | 70 |
2273173 | 2273173 | 2022-03-04 | Calhoun | Mississippi | 28013 | 4632 | 70 |
2269921 | 2269921 | 2022-03-03 | Calhoun | Mississippi | 28013 | 4632 | 70 |
2266668 | 2266668 | 2022-03-02 | Calhoun | Mississippi | 28013 | 4632 | 69 |
2263417 | 2263417 | 2022-03-01 | Calhoun | Mississippi | 28013 | 4632 | 69 |
2248684 | 2248684 | 2022-02-24 | Buchanan | Virginia | 51027 | 4632 | 96 |
2236417 | 2236417 | 2022-02-21 | Crisp | Georgia | 13081 | 4632 | 131 |
2237938 | 2237938 | 2022-02-21 | Hertford | North Carolina | 37091 | 4632 | 81 |
2197009 | 2197009 | 2022-02-09 | Marengo | Alabama | 1091 | 4632 | 97 |
2184115 | 2184115 | 2022-02-05 | Phillips | Arkansas | 5107 | 4632 | 84 |
2109418 | 2109418 | 2022-01-13 | Morgan | Colorado | 8087 | 4632 | 128 |
2106381 | 2106381 | 2022-01-12 | Pierce | Georgia | 13229 | 4632 | 108 |
2101745 | 2101745 | 2022-01-10 | Isabela | Puerto Rico | 72071 | 4632 | |
2059546 | 2059546 | 2021-12-28 | Edgefield | South Carolina | 45037 | 4632 | 60 |
2056297 | 2056297 | 2021-12-27 | Edgefield | South Carolina | 45037 | 4632 | 60 |
2053048 | 2053048 | 2021-12-26 | Edgefield | South Carolina | 45037 | 4632 | 60 |
2049798 | 2049798 | 2021-12-25 | Edgefield | South Carolina | 45037 | 4632 | 60 |
2046548 | 2046548 | 2021-12-24 | Edgefield | South Carolina | 45037 | 4632 | 60 |
2043298 | 2043298 | 2021-12-23 | Edgefield | South Carolina | 45037 | 4632 | 60 |
2033210 | 2033210 | 2021-12-20 | Henry | Ohio | 39069 | 4632 | 83 |
2020769 | 2020769 | 2021-12-16 | Cass | Texas | 48067 | 4632 | 159 |
2013038 | 2013038 | 2021-12-14 | Copiah | Mississippi | 28029 | 4632 | 95 |
2014684 | 2014684 | 2021-12-14 | Island | Washington | 53029 | 4632 | 54 |
1985862 | 1985862 | 2021-12-06 | Delta | Colorado | 8029 | 4632 | 101 |
1936875 | 1936875 | 2021-11-21 | Geneva | Alabama | 1061 | 4632 | 134 |
1929060 | 1929060 | 2021-11-18 | Montgomery | North Carolina | 37123 | 4632 | 110 |
1864441 | 1864441 | 2021-10-29 | Arecibo | Puerto Rico | 72013 | 4632 | |
1853840 | 1853840 | 2021-10-26 | Tate | Mississippi | 28137 | 4632 | 111 |
1854240 | 1854240 | 2021-10-26 | Otsego | New York | 36077 | 4632 | 55 |
1847410 | 1847410 | 2021-10-24 | Lafayette | Missouri | 29107 | 4632 | 73 |
1827405 | 1827405 | 2021-10-18 | Grayson | Kentucky | 21085 | 4632 | 86 |
1807346 | 1807346 | 2021-10-12 | Lee | Georgia | 13177 | 4632 | 78 |
1766699 | 1766699 | 2021-09-29 | Champaign | Ohio | 39021 | 4632 | 64 |
1758184 | 1758184 | 2021-09-27 | Pike | Alabama | 1109 | 4632 | 97 |
1754894 | 1754894 | 2021-09-26 | Clarke | Alabama | 1025 | 4632 | 79 |
1745007 | 1745007 | 2021-09-22 | Logan | West Virginia | 54045 | 4632 | 114 |
1740494 | 1740494 | 2021-09-21 | Columbia | New York | 36021 | 4632 | 108 |
1736465 | 1736465 | 2021-09-20 | Marshall | Kentucky | 21157 | 4632 | 75 |
1714428 | 1714428 | 2021-09-13 | Cheshire | New Hampshire | 33005 | 4632 | 42 |
1695112 | 1695112 | 2021-09-07 | Jackson | North Carolina | 37099 | 4632 | 62 |
1691694 | 1691694 | 2021-09-06 | Grafton | New Hampshire | 33009 | 4632 | 30 |
1688444 | 1688444 | 2021-09-05 | Grafton | New Hampshire | 33009 | 4632 | 30 |
1685194 | 1685194 | 2021-09-04 | Grafton | New Hampshire | 33009 | 4632 | 30 |
1681943 | 1681943 | 2021-09-03 | Grafton | New Hampshire | 33009 | 4632 | 30 |
1648178 | 1648178 | 2021-08-24 | Oconee | Georgia | 13219 | 4632 | 74 |
1580173 | 1580173 | 2021-08-03 | Clinton | Indiana | 18023 | 4632 | 60 |
1556207 | 1556207 | 2021-07-26 | Hill | Texas | 48217 | 4632 | 111 |
1541897 | 1541897 | 2021-07-22 | Winona | Minnesota | 27169 | 4632 | 52 |
1538650 | 1538650 | 2021-07-21 | Winona | Minnesota | 27169 | 4632 | 52 |
1535403 | 1535403 | 2021-07-20 | Winona | Minnesota | 27169 | 4632 | 52 |
1517832 | 1517832 | 2021-07-15 | Kenai Peninsula Borough | Alaska | 2122 | 4632 | 19 |
1514585 | 1514585 | 2021-07-14 | Kenai Peninsula Borough | Alaska | 2122 | 4632 | 19 |
1379651 | 1379651 | 2021-06-02 | Panola | Mississippi | 28107 | 4632 | 110 |
1370714 | 1370714 | 2021-05-30 | Bedford | Pennsylvania | 42009 | 4632 | 138 |
1356287 | 1356287 | 2021-05-26 | Des Moines | Iowa | 19057 | 4632 | 67 |
1358451 | 1358451 | 2021-05-26 | James City | Virginia | 51095 | 4632 | 72 |
1327706 | 1327706 | 2021-05-17 | Oktibbeha | Mississippi | 28105 | 4632 | 98 |
1309235 | 1309235 | 2021-05-11 | Codington | South Dakota | 46029 | 4632 | 81 |
1272400 | 1272400 | 2021-04-30 | Goodhue | Minnesota | 27049 | 4632 | 72 |
1221152 | 1221152 | 2021-04-14 | Williams | North Dakota | 38105 | 4632 | 38 |
1187730 | 1187730 | 2021-04-04 | Whitley | Kentucky | 21235 | 4632 | 47 |
1189270 | 1189270 | 2021-04-04 | Chambers | Texas | 48071 | 4632 | 47 |
1184483 | 1184483 | 2021-04-03 | Whitley | Kentucky | 21235 | 4632 | 47 |
1186023 | 1186023 | 2021-04-03 | Chambers | Texas | 48071 | 4632 | 47 |
1182776 | 1182776 | 2021-04-02 | Chambers | Texas | 48071 | 4632 | 47 |
1179529 | 1179529 | 2021-04-01 | Chambers | Texas | 48071 | 4632 | 47 |
1176282 | 1176282 | 2021-03-31 | Chambers | Texas | 48071 | 4632 | 47 |
1156588 | 1156588 | 2021-03-25 | Newberry | South Carolina | 45071 | 4632 | 94 |
1152810 | 1152810 | 2021-03-24 | Carteret | North Carolina | 37031 | 4632 | 45 |
1143874 | 1143874 | 2021-03-21 | Harrison | Texas | 48203 | 4632 | 102 |
1112168 | 1112168 | 2021-03-12 | Tehama | California | 6103 | 4632 | 53 |
1097119 | 1097119 | 2021-03-07 | Bolivar | Mississippi | 28011 | 4632 | 124 |
1098006 | 1098006 | 2021-03-07 | Mifflin | Pennsylvania | 42087 | 4632 | 170 |
995063 | 995063 | 2021-02-03 | Campbell | Wyoming | 56005 | 4632 | 56 |
976238 | 976238 | 2021-01-29 | Grundy | Illinois | 17063 | 4632 | 55 |
971255 | 971255 | 2021-01-27 | Union | Ohio | 39159 | 4632 | 30 |
959840 | 959840 | 2021-01-24 | Habersham | Georgia | 13137 | 4632 | 112 |
959887 | 959887 | 2021-01-24 | Polk | Georgia | 13233 | 4632 | 62 |
961569 | 961569 | 2021-01-24 | Le Flore | Oklahoma | 40079 | 4632 | 37 |
948293 | 948293 | 2021-01-20 | Steuben | New York | 36101 | 4632 | 131 |
905555 | 905555 | 2021-01-07 | Crow Wing | Minnesota | 27035 | 4632 | 68 |
851484 | 851484 | 2020-12-21 | Lancaster | South Carolina | 45057 | 4632 | 78 |
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);