ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
82 rows where cases = 4459 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 25
- Illinois 9
- Minnesota 9
- Georgia 8
- Kentucky 7
- Louisiana 7
- Ohio 6
- Michigan 5
- North Carolina 4
- Texas 4
- New York 3
- Wisconsin 3
- Mississippi 2
- Pennsylvania 2
- Puerto Rico 2
- Alabama 1
- Arkansas 1
- California 1
- Colorado 1
- Indiana 1
- Maryland 1
- Missouri 1
- South Dakota 1
- Tennessee 1
- Utah 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2388444 | 2388444 | 2022-04-08 | Shelby | Texas | 48419 | 4459 | 134 |
2314519 | 2314519 | 2022-03-17 | Meriwether | Georgia | 13199 | 4459 | 140 |
2311266 | 2311266 | 2022-03-16 | Meriwether | Georgia | 13199 | 4459 | 140 |
2311284 | 2311284 | 2022-03-16 | Putnam | Georgia | 13237 | 4459 | 102 |
2244849 | 2244849 | 2022-02-23 | Fajardo | Puerto Rico | 72053 | 4459 | |
2173068 | 2173068 | 2022-02-01 | Paulding | Ohio | 39125 | 4459 | 69 |
2165790 | 2165790 | 2022-01-30 | Hubbard | Minnesota | 27057 | 4459 | 53 |
2162535 | 2162535 | 2022-01-29 | Hubbard | Minnesota | 27057 | 4459 | 53 |
2159280 | 2159280 | 2022-01-28 | Hubbard | Minnesota | 27057 | 4459 | 53 |
2058572 | 2058572 | 2021-12-28 | Marion | Mississippi | 28091 | 4459 | 114 |
2056341 | 2056341 | 2021-12-27 | Davison | South Dakota | 46035 | 4459 | 73 |
2036462 | 2036462 | 2021-12-21 | Hocking | Ohio | 39073 | 4459 | 94 |
1993286 | 1993286 | 2021-12-08 | West Baton Rouge | Louisiana | 22121 | 4459 | 79 |
1960967 | 1960967 | 2021-11-28 | Le Sueur | Minnesota | 27079 | 4459 | 33 |
1957716 | 1957716 | 2021-11-27 | Le Sueur | Minnesota | 27079 | 4459 | 33 |
1954465 | 1954465 | 2021-11-26 | Le Sueur | Minnesota | 27079 | 4459 | 33 |
1915429 | 1915429 | 2021-11-14 | Brown | Minnesota | 27015 | 4459 | 56 |
1912179 | 1912179 | 2021-11-13 | Brown | Minnesota | 27015 | 4459 | 56 |
1908929 | 1908929 | 2021-11-12 | Brown | Minnesota | 27015 | 4459 | 56 |
1904789 | 1904789 | 2021-11-11 | Emanuel | Georgia | 13107 | 4459 | 133 |
1901539 | 1901539 | 2021-11-10 | Emanuel | Georgia | 13107 | 4459 | 133 |
1899120 | 1899120 | 2021-11-09 | Houghton | Michigan | 26061 | 4459 | 56 |
1895870 | 1895870 | 2021-11-08 | Houghton | Michigan | 26061 | 4459 | 56 |
1872047 | 1872047 | 2021-11-01 | Glenn | California | 6021 | 4459 | 46 |
1856760 | 1856760 | 2021-10-27 | Morehouse | Louisiana | 22067 | 4459 | 116 |
1824252 | 1824252 | 2021-10-17 | East Feliciana | Louisiana | 22037 | 4459 | 142 |
1821003 | 1821003 | 2021-10-16 | East Feliciana | Louisiana | 22037 | 4459 | 142 |
1817754 | 1817754 | 2021-10-15 | East Feliciana | Louisiana | 22037 | 4459 | 142 |
1814506 | 1814506 | 2021-10-14 | East Feliciana | Louisiana | 22037 | 4459 | 142 |
1811257 | 1811257 | 2021-10-13 | East Feliciana | Louisiana | 22037 | 4459 | 142 |
1784115 | 1784115 | 2021-10-04 | Park | Wyoming | 56029 | 4459 | 48 |
1774521 | 1774521 | 2021-10-02 | Johnson | Arkansas | 5071 | 4459 | 56 |
1769801 | 1769801 | 2021-09-30 | Cherokee | North Carolina | 37039 | 4459 | 68 |
1764280 | 1764280 | 2021-09-28 | Uintah | Utah | 49047 | 4459 | 38 |
1743958 | 1743958 | 2021-09-22 | Champaign | Ohio | 39021 | 4459 | 64 |
1723617 | 1723617 | 2021-09-16 | Worcester | Maryland | 24047 | 4459 | 111 |
1695473 | 1695473 | 2021-09-07 | Pike | Pennsylvania | 42103 | 4459 | 55 |
1633305 | 1633305 | 2021-08-19 | Montgomery | New York | 36057 | 4459 | 128 |
1626521 | 1626521 | 2021-08-17 | Pulaski | Missouri | 29169 | 4459 | 60 |
1587947 | 1587947 | 2021-08-05 | Stokes | North Carolina | 37169 | 4459 | 81 |
1574858 | 1574858 | 2021-08-01 | Tompkins | New York | 36109 | 4459 | 53 |
1516616 | 1516616 | 2021-07-14 | Madison | Ohio | 39097 | 4459 | 66 |
1493687 | 1493687 | 2021-07-07 | Alexander | North Carolina | 37003 | 4459 | 84 |
1485930 | 1485930 | 2021-07-05 | Jefferson | Illinois | 17081 | 4459 | 123 |
1482684 | 1482684 | 2021-07-04 | Jefferson | Illinois | 17081 | 4459 | 123 |
1479437 | 1479437 | 2021-07-03 | Jefferson | Illinois | 17081 | 4459 | 123 |
1476191 | 1476191 | 2021-07-02 | Jefferson | Illinois | 17081 | 4459 | 123 |
1326297 | 1326297 | 2021-05-17 | Russell | Alabama | 1113 | 4459 | 38 |
1323622 | 1323622 | 2021-05-16 | Franklin | Illinois | 17055 | 4459 | 87 |
1323999 | 1323999 | 2021-05-16 | Barren | Kentucky | 21009 | 4459 | 92 |
1320753 | 1320753 | 2021-05-15 | Barren | Kentucky | 21009 | 4459 | 92 |
1311012 | 1311012 | 2021-05-12 | Barren | Kentucky | 21009 | 4459 | 92 |
1307766 | 1307766 | 2021-05-11 | Barren | Kentucky | 21009 | 4459 | 92 |
1300926 | 1300926 | 2021-05-09 | Marion | Illinois | 17121 | 4459 | 121 |
1279645 | 1279645 | 2021-05-02 | Knox | Ohio | 39083 | 4459 | 110 |
1244364 | 1244364 | 2021-04-21 | Cheatham | Tennessee | 47021 | 4459 | 54 |
1235727 | 1235727 | 2021-04-19 | Baldwin | Georgia | 13009 | 4459 | 126 |
1155189 | 1155189 | 2021-03-25 | Henderson | Kentucky | 21101 | 4459 | 71 |
1151527 | 1151527 | 2021-03-24 | Henry | Illinois | 17073 | 4459 | 88 |
1150837 | 1150837 | 2021-03-23 | Monroe | Wisconsin | 55081 | 4459 | 35 |
1147590 | 1147590 | 2021-03-22 | Monroe | Wisconsin | 55081 | 4459 | 35 |
1141805 | 1141805 | 2021-03-21 | Macoupin | Illinois | 17117 | 4459 | 109 |
1140264 | 1140264 | 2021-03-20 | Guaynabo | Puerto Rico | 72061 | 4459 | |
1091069 | 1091069 | 2021-03-05 | Genesee | New York | 36037 | 4459 | 118 |
1015569 | 1015569 | 2021-02-10 | Boyd | Kentucky | 21019 | 4459 | 41 |
999068 | 999068 | 2021-02-05 | Jackson | Indiana | 18071 | 4459 | 60 |
995722 | 995722 | 2021-02-04 | Jackson | Illinois | 17077 | 4459 | 70 |
990658 | 990658 | 2021-02-02 | Belmont | Ohio | 39013 | 4459 | 50 |
983352 | 983352 | 2021-01-31 | Branch | Michigan | 26023 | 4459 | 105 |
980106 | 980106 | 2021-01-30 | Branch | Michigan | 26023 | 4459 | 105 |
975032 | 975032 | 2021-01-28 | Coryell | Texas | 48099 | 4459 | 53 |
946348 | 946348 | 2021-01-19 | Oconto | Wisconsin | 55083 | 4459 | 49 |
918292 | 918292 | 2021-01-11 | Pulaski | Kentucky | 21199 | 4459 | 65 |
892719 | 892719 | 2021-01-03 | Washington | Mississippi | 28151 | 4459 | 117 |
862289 | 862289 | 2020-12-25 | Fremont | Colorado | 8043 | 4459 | 17 |
852741 | 852741 | 2020-12-22 | Gordon | Georgia | 13129 | 4459 | 61 |
782855 | 782855 | 2020-11-30 | Nash | North Carolina | 37127 | 4459 | 108 |
603778 | 603778 | 2020-10-06 | Washtenaw | Michigan | 26161 | 4459 | 126 |
588935 | 588935 | 2020-10-01 | Ellis | Texas | 48139 | 4459 | 68 |
466928 | 466928 | 2020-08-25 | Cherokee | Georgia | 13057 | 4459 | 72 |
359277 | 359277 | 2020-07-22 | Chester | Pennsylvania | 42029 | 4459 | 342 |
324500 | 324500 | 2020-07-11 | Collin | Texas | 48085 | 4459 | 56 |
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);