ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
87 rows where cases = 5221 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Texas 11
- Georgia 10
- Wisconsin 9
- Mississippi 8
- North Carolina 5
- Puerto Rico 5
- Illinois 4
- Indiana 4
- Missouri 4
- New York 4
- West Virginia 4
- Kentucky 3
- Tennessee 3
- Kansas 2
- New Mexico 2
- Virginia 2
- Arkansas 1
- Michigan 1
- Ohio 1
- South Dakota 1
- Utah 1
- Washington 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501166 | 2501166 | 2022-05-13 | Ray | Missouri | 29177 | 5221 | 94 |
2492166 | 2492166 | 2022-05-10 | Fajardo | Puerto Rico | 72053 | 5221 | |
2463377 | 2463377 | 2022-05-01 | Carbon | Utah | 49007 | 5221 | 46 |
2442450 | 2442450 | 2022-04-25 | Winston | Mississippi | 28159 | 5221 | 104 |
2439194 | 2439194 | 2022-04-24 | Winston | Mississippi | 28159 | 5221 | 104 |
2435938 | 2435938 | 2022-04-23 | Winston | Mississippi | 28159 | 5221 | 104 |
2432682 | 2432682 | 2022-04-22 | Winston | Mississippi | 28159 | 5221 | 104 |
2429426 | 2429426 | 2022-04-21 | Winston | Mississippi | 28159 | 5221 | 104 |
2426170 | 2426170 | 2022-04-20 | Winston | Mississippi | 28159 | 5221 | 104 |
2422193 | 2422193 | 2022-04-19 | Spencer | Indiana | 18147 | 5221 | 61 |
2422914 | 2422914 | 2022-04-19 | Winston | Mississippi | 28159 | 5221 | 104 |
2424640 | 2424640 | 2022-04-19 | Vilas | Wisconsin | 55125 | 5221 | 89 |
2418937 | 2418937 | 2022-04-18 | Spencer | Indiana | 18147 | 5221 | 61 |
2419657 | 2419657 | 2022-04-18 | Winston | Mississippi | 28159 | 5221 | 104 |
2421384 | 2421384 | 2022-04-18 | Vilas | Wisconsin | 55125 | 5221 | 89 |
2418128 | 2418128 | 2022-04-17 | Vilas | Wisconsin | 55125 | 5221 | 89 |
2414872 | 2414872 | 2022-04-16 | Vilas | Wisconsin | 55125 | 5221 | 89 |
2411616 | 2411616 | 2022-04-15 | Vilas | Wisconsin | 55125 | 5221 | 89 |
2408360 | 2408360 | 2022-04-14 | Vilas | Wisconsin | 55125 | 5221 | 89 |
2374418 | 2374418 | 2022-04-04 | Lincoln | New Mexico | 35027 | 5221 | 65 |
2353845 | 2353845 | 2022-03-29 | Spencer | Indiana | 18147 | 5221 | 60 |
2356250 | 2356250 | 2022-03-29 | Iowa | Wisconsin | 55049 | 5221 | 27 |
2268934 | 2268934 | 2022-03-03 | Dodge | Georgia | 13091 | 5221 | 146 |
2254641 | 2254641 | 2022-02-26 | San Lorenzo | Puerto Rico | 72129 | 5221 | |
2246175 | 2246175 | 2022-02-24 | Dodge | Georgia | 13091 | 5221 | 143 |
2216353 | 2216353 | 2022-02-14 | Lincoln | West Virginia | 54043 | 5221 | 65 |
2193212 | 2193212 | 2022-02-07 | Karnes | Texas | 48255 | 5221 | 63 |
2187653 | 2187653 | 2022-02-06 | Franklin | Georgia | 13119 | 5221 | 92 |
2184400 | 2184400 | 2022-02-05 | Franklin | Georgia | 13119 | 5221 | 92 |
2181148 | 2181148 | 2022-02-04 | Franklin | Georgia | 13119 | 5221 | 92 |
2122779 | 2122779 | 2022-01-17 | Jersey | Illinois | 17083 | 5221 | 77 |
2119527 | 2119527 | 2022-01-16 | Jersey | Illinois | 17083 | 5221 | 77 |
2116275 | 2116275 | 2022-01-15 | Jersey | Illinois | 17083 | 5221 | 77 |
2113024 | 2113024 | 2022-01-14 | Jersey | Illinois | 17083 | 5221 | 77 |
2098483 | 2098483 | 2022-01-09 | Dorado | Puerto Rico | 72051 | 5221 | |
1994778 | 1994778 | 2021-12-08 | Cooke | Texas | 48097 | 5221 | 105 |
1970430 | 1970430 | 2021-12-01 | Marshall | Kentucky | 21157 | 5221 | 80 |
1921299 | 1921299 | 2021-11-16 | Adams | Indiana | 18001 | 5221 | 80 |
1919812 | 1919812 | 2021-11-15 | Brookings | South Dakota | 46011 | 5221 | 39 |
1899703 | 1899703 | 2021-11-09 | Columbia | New York | 36021 | 5221 | 112 |
1897737 | 1897737 | 2021-11-08 | Randolph | West Virginia | 54083 | 5221 | 50 |
1878344 | 1878344 | 2021-11-02 | Teton | Wyoming | 56039 | 5221 | 14 |
1811669 | 1811669 | 2021-10-13 | Laclede | Missouri | 29105 | 5221 | 126 |
1791581 | 1791581 | 2021-10-07 | Montgomery | Kansas | 20125 | 5221 | 105 |
1788332 | 1788332 | 2021-10-06 | Montgomery | Kansas | 20125 | 5221 | 105 |
1787272 | 1787272 | 2021-10-05 | Wayne | West Virginia | 54099 | 5221 | 62 |
1756795 | 1756795 | 2021-09-26 | Bladen | North Carolina | 37017 | 5221 | 92 |
1753547 | 1753547 | 2021-09-25 | Bladen | North Carolina | 37017 | 5221 | 92 |
1750299 | 1750299 | 2021-09-24 | Bladen | North Carolina | 37017 | 5221 | 92 |
1745637 | 1745637 | 2021-09-23 | Pickens | Georgia | 13227 | 5221 | 97 |
1747700 | 1747700 | 2021-09-23 | Hardin | Tennessee | 47071 | 5221 | 78 |
1722805 | 1722805 | 2021-09-16 | Chattahoochee | Georgia | 13053 | 5221 | 17 |
1719025 | 1719025 | 2021-09-14 | Ohio | West Virginia | 54069 | 5221 | 92 |
1535001 | 1535001 | 2021-07-20 | Boyd | Kentucky | 21019 | 5221 | 76 |
1516373 | 1516373 | 2021-07-14 | Herkimer | New York | 36043 | 5221 | 110 |
1469516 | 1469516 | 2021-06-30 | Habersham | Georgia | 13137 | 5221 | 164 |
1468470 | 1468470 | 2021-06-29 | Chambers | Texas | 48071 | 5221 | 57 |
1465225 | 1465225 | 2021-06-28 | Chambers | Texas | 48071 | 5221 | 57 |
1461980 | 1461980 | 2021-06-27 | Chambers | Texas | 48071 | 5221 | 57 |
1458735 | 1458735 | 2021-06-26 | Chambers | Texas | 48071 | 5221 | 57 |
1455490 | 1455490 | 2021-06-25 | Chambers | Texas | 48071 | 5221 | 57 |
1452245 | 1452245 | 2021-06-24 | Chambers | Texas | 48071 | 5221 | 57 |
1448999 | 1448999 | 2021-06-23 | Chambers | Texas | 48071 | 5221 | 57 |
1445754 | 1445754 | 2021-06-22 | Chambers | Texas | 48071 | 5221 | 57 |
1441683 | 1441683 | 2021-06-21 | Otero | New Mexico | 35035 | 5221 | 79 |
1442509 | 1442509 | 2021-06-21 | Chambers | Texas | 48071 | 5221 | 57 |
1426699 | 1426699 | 2021-06-16 | Lewis | Washington | 53041 | 5221 | 73 |
1404287 | 1404287 | 2021-06-10 | Hot Spring | Arkansas | 5059 | 5221 | 74 |
1396330 | 1396330 | 2021-06-07 | Carteret | North Carolina | 37031 | 5221 | 56 |
1377002 | 1377002 | 2021-06-01 | Athens | Ohio | 39009 | 5221 | 60 |
1312369 | 1312369 | 2021-05-12 | Guaynabo | Puerto Rico | 72061 | 5221 | |
1309122 | 1309122 | 2021-05-11 | Guaynabo | Puerto Rico | 72061 | 5221 | |
1276160 | 1276160 | 2021-05-01 | Genesee | New York | 36037 | 5221 | 121 |
1247048 | 1247048 | 2021-04-22 | Pender | North Carolina | 37141 | 5221 | 69 |
1219056 | 1219056 | 2021-04-13 | Shawano | Wisconsin | 55115 | 5221 | 81 |
1152462 | 1152462 | 2021-03-24 | Newton | Missouri | 29145 | 5221 | 73 |
1144169 | 1144169 | 2021-03-21 | Pittsylvania | Virginia | 51143 | 5221 | 75 |
1122968 | 1122968 | 2021-03-15 | Midland | Michigan | 26111 | 5221 | 66 |
1083139 | 1083139 | 2021-03-03 | Coffee | Georgia | 13069 | 5221 | 151 |
1059300 | 1059300 | 2021-02-23 | Dyer | Tennessee | 47045 | 5221 | 100 |
994999 | 994999 | 2021-02-03 | Columbia | Wisconsin | 55021 | 5221 | 53 |
983177 | 983177 | 2021-01-31 | McCracken | Kentucky | 21145 | 5221 | 56 |
958712 | 958712 | 2021-01-23 | Lawrence | Tennessee | 47099 | 5221 | 69 |
943690 | 943690 | 2021-01-19 | Walker | Georgia | 13295 | 5221 | 63 |
932024 | 932024 | 2021-01-15 | Chautauqua | New York | 36013 | 5221 | 51 |
884533 | 884533 | 2020-12-31 | Stafford | Virginia | 51179 | 5221 | 24 |
801889 | 801889 | 2020-12-06 | Franklin | Missouri | 29071 | 5221 | 91 |
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);