ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
63 rows where cases = 6637 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Ohio 8
- Mississippi 7
- South Carolina 7
- New York 4
- Virginia 4
- Alabama 3
- New Mexico 3
- Pennsylvania 3
- Wisconsin 3
- Kansas 2
- Michigan 2
- Texas 2
- Arkansas 1
- Colorado 1
- Georgia 1
- Illinois 1
- Indiana 1
- Kentucky 1
- Louisiana 1
- Maryland 1
- Massachusetts 1
- Minnesota 1
- Missouri 1
- North Carolina 1
- Puerto Rico 1
- Tennessee 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2469355 | 2469355 | 2022-05-03 | Cayey | Puerto Rico | 72035 | 6637 | |
2397794 | 2397794 | 2022-04-11 | Abbeville | South Carolina | 45001 | 6637 | 69 |
2394539 | 2394539 | 2022-04-10 | Abbeville | South Carolina | 45001 | 6637 | 69 |
2391283 | 2391283 | 2022-04-09 | Abbeville | South Carolina | 45001 | 6637 | 69 |
2388027 | 2388027 | 2022-04-08 | Abbeville | South Carolina | 45001 | 6637 | 69 |
2384772 | 2384772 | 2022-04-07 | Abbeville | South Carolina | 45001 | 6637 | 69 |
2381517 | 2381517 | 2022-04-06 | Abbeville | South Carolina | 45001 | 6637 | 69 |
2378262 | 2378262 | 2022-04-05 | Abbeville | South Carolina | 45001 | 6637 | 69 |
2358424 | 2358424 | 2022-03-30 | Hocking | Ohio | 39073 | 6637 | 118 |
2355170 | 2355170 | 2022-03-29 | Hocking | Ohio | 39073 | 6637 | 118 |
2351917 | 2351917 | 2022-03-28 | Hocking | Ohio | 39073 | 6637 | 118 |
2348389 | 2348389 | 2022-03-27 | Grant | New Mexico | 35017 | 6637 | 81 |
2348665 | 2348665 | 2022-03-27 | Hocking | Ohio | 39073 | 6637 | 118 |
2345136 | 2345136 | 2022-03-26 | Grant | New Mexico | 35017 | 6637 | 81 |
2345412 | 2345412 | 2022-03-26 | Hocking | Ohio | 39073 | 6637 | 118 |
2341883 | 2341883 | 2022-03-25 | Grant | New Mexico | 35017 | 6637 | 81 |
2342159 | 2342159 | 2022-03-25 | Hocking | Ohio | 39073 | 6637 | 118 |
2338906 | 2338906 | 2022-03-24 | Hocking | Ohio | 39073 | 6637 | 118 |
2310269 | 2310269 | 2022-03-15 | Hutchinson | Texas | 48233 | 6637 | 135 |
2188620 | 2188620 | 2022-02-06 | Adams | Mississippi | 28001 | 6637 | 133 |
2185367 | 2185367 | 2022-02-05 | Adams | Mississippi | 28001 | 6637 | 133 |
2182115 | 2182115 | 2022-02-04 | Adams | Mississippi | 28001 | 6637 | 133 |
2168774 | 2168774 | 2022-01-31 | Mercer | Kentucky | 21167 | 6637 | 95 |
2169173 | 2169173 | 2022-01-31 | Tate | Mississippi | 28137 | 6637 | 128 |
2157842 | 2157842 | 2022-01-27 | Door | Wisconsin | 55029 | 6637 | 53 |
2111251 | 2111251 | 2022-01-13 | Morrow | Ohio | 39117 | 6637 | 77 |
2085901 | 2085901 | 2022-01-05 | Matagorda | Texas | 48321 | 6637 | 162 |
2065465 | 2065465 | 2021-12-30 | Chenango | New York | 36017 | 6637 | 101 |
2023659 | 2023659 | 2021-12-17 | Jefferson | Pennsylvania | 42065 | 6637 | 176 |
1970865 | 1970865 | 2021-12-01 | Camden | Missouri | 29029 | 6637 | 146 |
1923985 | 1923985 | 2021-11-17 | Independence | Arkansas | 5063 | 6637 | 160 |
1847322 | 1847322 | 2021-10-24 | Neshoba | Mississippi | 28099 | 6637 | 206 |
1844072 | 1844072 | 2021-10-23 | Neshoba | Mississippi | 28099 | 6637 | 206 |
1840822 | 1840822 | 2021-10-22 | Neshoba | Mississippi | 28099 | 6637 | 206 |
1833497 | 1833497 | 2021-10-20 | Henry | Illinois | 17073 | 6637 | 106 |
1814281 | 1814281 | 2021-10-14 | Crawford | Kansas | 20037 | 6637 | 113 |
1811032 | 1811032 | 2021-10-13 | Crawford | Kansas | 20037 | 6637 | 113 |
1717143 | 1717143 | 2021-09-14 | Barry | Michigan | 26015 | 6637 | 74 |
1713895 | 1713895 | 2021-09-13 | Barry | Michigan | 26015 | 6637 | 74 |
1627234 | 1627234 | 2021-08-17 | Indiana | Pennsylvania | 42063 | 6637 | 180 |
1608436 | 1608436 | 2021-08-11 | Harrisonburg city | Virginia | 51660 | 6637 | 95 |
1561198 | 1561198 | 2021-07-28 | Berkshire | Massachusetts | 25003 | 6637 | 290 |
1419019 | 1419019 | 2021-06-14 | St. Lawrence | New York | 36089 | 6637 | 96 |
1413572 | 1413572 | 2021-06-12 | Bedford | Virginia | 51019 | 6637 | 109 |
1386034 | 1386034 | 2021-06-04 | Kandiyohi | Minnesota | 27067 | 6637 | 84 |
1376832 | 1376832 | 2021-06-01 | Sullivan | New York | 36105 | 6637 | 74 |
1373586 | 1373586 | 2021-05-31 | Sullivan | New York | 36105 | 6637 | 74 |
1213802 | 1213802 | 2021-04-12 | Allegany | Maryland | 24001 | 6637 | 205 |
1177276 | 1177276 | 2021-04-01 | Bulloch | Georgia | 13031 | 6637 | 110 |
1072713 | 1072713 | 2021-02-27 | Hanover | Virginia | 51085 | 6637 | 123 |
1042503 | 1042503 | 2021-02-18 | Rockingham | North Carolina | 37157 | 6637 | 57 |
1004185 | 1004185 | 2021-02-06 | Tipton | Tennessee | 47167 | 6637 | 92 |
988546 | 988546 | 2021-02-01 | Portage | Wisconsin | 55097 | 6637 | 62 |
985299 | 985299 | 2021-01-31 | Portage | Wisconsin | 55097 | 6637 | 62 |
969177 | 969177 | 2021-01-27 | Talladega | Alabama | 1121 | 6637 | 114 |
972147 | 972147 | 2021-01-27 | Roanoke city | Virginia | 51770 | 6637 | 116 |
750716 | 750716 | 2020-11-20 | Dauphin | Pennsylvania | 42043 | 6637 | 211 |
751311 | 751311 | 2020-11-20 | Cache | Utah | 49005 | 6637 | 14 |
660849 | 660849 | 2020-10-24 | Baldwin | Alabama | 1003 | 6637 | 69 |
622183 | 622183 | 2020-10-12 | Jefferson | Colorado | 8059 | 6637 | 265 |
615482 | 615482 | 2020-10-10 | Shelby | Alabama | 1117 | 6637 | 58 |
577302 | 577302 | 2020-09-28 | St. Joseph | Indiana | 18141 | 6637 | 119 |
529120 | 529120 | 2020-09-13 | St. Tammany | Louisiana | 22103 | 6637 | 246 |
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);