ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
56 rows where cases = 7219 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2399109 | 2399109 | 2022-04-12 | Lumpkin | Georgia | 13187 | 7219 | 131 |
2400996 | 2400996 | 2022-04-12 | Gurabo | Puerto Rico | 72063 | 7219 | |
2395854 | 2395854 | 2022-04-11 | Lumpkin | Georgia | 13187 | 7219 | 131 |
2397741 | 2397741 | 2022-04-11 | Gurabo | Puerto Rico | 72063 | 7219 | |
2398303 | 2398303 | 2022-04-11 | St. Thomas | Virgin Islands | 78030 | 7219 | 59 |
2395048 | 2395048 | 2022-04-10 | St. Thomas | Virgin Islands | 78030 | 7219 | 59 |
2391792 | 2391792 | 2022-04-09 | St. Thomas | Virgin Islands | 78030 | 7219 | 59 |
2388536 | 2388536 | 2022-04-08 | St. Thomas | Virgin Islands | 78030 | 7219 | 59 |
2378089 | 2378089 | 2022-04-05 | Jefferson | Oregon | 41031 | 7219 | 89 |
2359354 | 2359354 | 2022-03-30 | Pulaski | Virginia | 51155 | 7219 | 135 |
2258484 | 2258484 | 2022-02-27 | Isle of Wight | Virginia | 51093 | 7219 | 106 |
2254636 | 2254636 | 2022-02-26 | Rio Grande | Puerto Rico | 72119 | 7219 | |
2255233 | 2255233 | 2022-02-26 | Isle of Wight | Virginia | 51093 | 7219 | 106 |
2251982 | 2251982 | 2022-02-25 | Isle of Wight | Virginia | 51093 | 7219 | 106 |
2233919 | 2233919 | 2022-02-20 | West Baton Rouge | Louisiana | 22121 | 7219 | 82 |
2230668 | 2230668 | 2022-02-19 | West Baton Rouge | Louisiana | 22121 | 7219 | 82 |
2227417 | 2227417 | 2022-02-18 | West Baton Rouge | Louisiana | 22121 | 7219 | 82 |
2172155 | 2172155 | 2022-02-01 | Dorchester | Maryland | 24019 | 7219 | 100 |
2170617 | 2170617 | 2022-01-31 | St. Croix | Virgin Islands | 78010 | 7219 | 42 |
2084494 | 2084494 | 2022-01-05 | Morrison | Minnesota | 27097 | 7219 | 89 |
2079884 | 2079884 | 2022-01-04 | Covington | Alabama | 1039 | 7219 | 200 |
2054566 | 2054566 | 2021-12-27 | Woodford | Illinois | 17203 | 7219 | 110 |
2036260 | 2036260 | 2021-12-21 | Tioga | New York | 36107 | 7219 | 76 |
2031123 | 2031123 | 2021-12-20 | Chilton | Alabama | 1021 | 7219 | 172 |
2019572 | 2019572 | 2021-12-16 | Monroe | Mississippi | 28095 | 7219 | 180 |
2013117 | 2013117 | 2021-12-14 | Butler | Missouri | 29023 | 7219 | 130 |
1961500 | 1961500 | 2021-11-28 | Warren | New York | 36113 | 7219 | 96 |
1951719 | 1951719 | 2021-11-25 | Madison | New York | 36053 | 7219 | 108 |
1920655 | 1920655 | 2021-11-16 | Tallapoosa | Alabama | 1123 | 7219 | 202 |
1808447 | 1808447 | 2021-10-12 | Pettis | Missouri | 29159 | 7219 | 100 |
1766529 | 1766529 | 2021-09-29 | Wayne | New York | 36117 | 7219 | 79 |
1761646 | 1761646 | 2021-09-28 | Garfield | Colorado | 8045 | 7219 | 59 |
1739695 | 1739695 | 2021-09-21 | Jessamine | Kentucky | 21113 | 7219 | 84 |
1720192 | 1720192 | 2021-09-15 | Henderson | Kentucky | 21101 | 7219 | 88 |
1712559 | 1712559 | 2021-09-12 | Calumet | Wisconsin | 55015 | 7219 | 57 |
1709312 | 1709312 | 2021-09-11 | Calumet | Wisconsin | 55015 | 7219 | 57 |
1706065 | 1706065 | 2021-09-10 | Calumet | Wisconsin | 55015 | 7219 | 57 |
1666497 | 1666497 | 2021-08-29 | Lawrence | Tennessee | 47099 | 7219 | 103 |
1663249 | 1663249 | 2021-08-28 | Lawrence | Tennessee | 47099 | 7219 | 103 |
1660001 | 1660001 | 2021-08-27 | Lawrence | Tennessee | 47099 | 7219 | 103 |
1627974 | 1627974 | 2021-08-17 | Rockingham | Virginia | 51165 | 7219 | 115 |
1490599 | 1490599 | 2021-07-06 | Ashtabula | Ohio | 39007 | 7219 | 179 |
1459450 | 1459450 | 2021-06-27 | Crawford | Arkansas | 5033 | 7219 | 120 |
1456205 | 1456205 | 2021-06-26 | Crawford | Arkansas | 5033 | 7219 | 120 |
1452960 | 1452960 | 2021-06-25 | Crawford | Arkansas | 5033 | 7219 | 120 |
1265888 | 1265888 | 2021-04-28 | Blue Earth | Minnesota | 27013 | 7219 | 41 |
1225213 | 1225213 | 2021-04-15 | Wise | Texas | 48497 | 7219 | 118 |
934465 | 934465 | 2021-01-16 | Hardin | Kentucky | 21093 | 7219 | 53 |
745952 | 745952 | 2020-11-19 | Porter | Indiana | 18127 | 7219 | 71 |
719609 | 719609 | 2020-11-11 | St. Johns | Florida | 12109 | 7219 | 88 |
713067 | 713067 | 2020-11-09 | Bay | Florida | 12005 | 7219 | 142 |
601719 | 601719 | 2020-10-05 | Minnehaha | South Dakota | 46099 | 7219 | 84 |
567485 | 567485 | 2020-09-25 | St. Clair | Illinois | 17163 | 7219 | 189 |
434289 | 434289 | 2020-08-15 | Montgomery | Alabama | 1101 | 7219 | 156 |
421717 | 421717 | 2020-08-11 | Seminole | Florida | 12117 | 7219 | 130 |
269390 | 269390 | 2020-06-24 | Baltimore city | Maryland | 24510 | 7219 | 325 |
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);