ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where cases = 5619 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 29
- Missouri 5
- North Carolina 5
- Texas 5
- Michigan 4
- Wisconsin 4
- Florida 3
- Ohio 3
- Pennsylvania 3
- West Virginia 3
- Arizona 2
- Colorado 2
- Kentucky 2
- Minnesota 2
- Mississippi 2
- Montana 2
- New York 2
- Tennessee 2
- Virginia 2
- Alabama 1
- Arkansas 1
- Georgia 1
- Illinois 1
- Indiana 1
- Louisiana 1
- Maine 1
- New Mexico 1
- Puerto Rico 1
- South Carolina 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2440828 | 2440828 | 2022-04-24 | McDowell | West Virginia | 54047 | 5619 | 74 |
2437572 | 2437572 | 2022-04-23 | McDowell | West Virginia | 54047 | 5619 | 74 |
2434316 | 2434316 | 2022-04-22 | McDowell | West Virginia | 54047 | 5619 | 74 |
2354366 | 2354366 | 2022-03-29 | Menominee | Michigan | 26109 | 5619 | 69 |
2351114 | 2351114 | 2022-03-28 | Menominee | Michigan | 26109 | 5619 | 69 |
2331486 | 2331486 | 2022-03-22 | Franklin | Maine | 23007 | 5619 | 57 |
2214731 | 2214731 | 2022-02-14 | Audrain | Missouri | 29007 | 5619 | 96 |
2178913 | 2178913 | 2022-02-03 | Newton | Mississippi | 28101 | 5619 | 91 |
2152982 | 2152982 | 2022-01-26 | Miller | Missouri | 29131 | 5619 | 105 |
2137018 | 2137018 | 2022-01-21 | Lewis | New York | 36049 | 5619 | 45 |
2106161 | 2106161 | 2022-01-12 | Logan | Colorado | 8075 | 5619 | 98 |
2088025 | 2088025 | 2022-01-06 | Ravalli | Montana | 30081 | 5619 | 129 |
2084160 | 2084160 | 2022-01-05 | Grant | Kentucky | 21081 | 5619 | 46 |
2038992 | 2038992 | 2021-12-22 | Nicollet | Minnesota | 27103 | 5619 | 61 |
1987164 | 1987164 | 2021-12-06 | Marion | Missouri | 29127 | 5619 | 99 |
1974726 | 1974726 | 2021-12-02 | Ottawa | Ohio | 39123 | 5619 | 99 |
1970379 | 1970379 | 2021-12-01 | Clark | Kentucky | 21049 | 5619 | 45 |
1920402 | 1920402 | 2021-11-15 | Wise | Virginia | 51195 | 5619 | 129 |
1861285 | 1861285 | 2021-10-28 | Colleton | South Carolina | 45029 | 5619 | 190 |
1837769 | 1837769 | 2021-10-21 | Silver Bow | Montana | 30093 | 5619 | 98 |
1812105 | 1812105 | 2021-10-13 | Scotland | North Carolina | 37165 | 5619 | 105 |
1805160 | 1805160 | 2021-10-11 | Howell | Missouri | 29091 | 5619 | 71 |
1769740 | 1769740 | 2021-09-30 | Fulton | New York | 36035 | 5619 | 98 |
1767365 | 1767365 | 2021-09-29 | Howard | Texas | 48227 | 5619 | 116 |
1760133 | 1760133 | 2021-09-27 | Yadkin | North Carolina | 37197 | 5619 | 67 |
1721761 | 1721761 | 2021-09-15 | Weakley | Tennessee | 47183 | 5619 | 74 |
1689856 | 1689856 | 2021-09-05 | Oconto | Wisconsin | 55083 | 5619 | 75 |
1686606 | 1686606 | 2021-09-04 | Oconto | Wisconsin | 55083 | 5619 | 75 |
1683356 | 1683356 | 2021-09-03 | Oconto | Wisconsin | 55083 | 5619 | 75 |
1679012 | 1679012 | 2021-09-02 | Knox | Ohio | 39083 | 5619 | 117 |
1670666 | 1670666 | 2021-08-31 | Broomfield | Colorado | 8014 | 5619 | 76 |
1660698 | 1660698 | 2021-08-28 | Escambia | Alabama | 1053 | 5619 | 89 |
1645600 | 1645600 | 2021-08-23 | St. John the Baptist | Louisiana | 22095 | 5619 | 149 |
1536609 | 1536609 | 2021-07-20 | Warren | Tennessee | 47177 | 5619 | 84 |
1529471 | 1529471 | 2021-07-18 | Pender | North Carolina | 37141 | 5619 | 69 |
1526224 | 1526224 | 2021-07-17 | Pender | North Carolina | 37141 | 5619 | 69 |
1522977 | 1522977 | 2021-07-16 | Pender | North Carolina | 37141 | 5619 | 69 |
1523405 | 1523405 | 2021-07-16 | Unknown | Puerto Rico | 5619 | 2560 | |
1404247 | 1404247 | 2021-06-10 | Graham | Arizona | 4009 | 5619 | 83 |
1378832 | 1378832 | 2021-06-02 | Knox | Illinois | 17095 | 5619 | 183 |
1368547 | 1368547 | 2021-05-30 | Graham | Arizona | 4009 | 5619 | 83 |
1306165 | 1306165 | 2021-05-10 | Caldwell | Texas | 48055 | 5619 | 97 |
1251043 | 1251043 | 2021-04-23 | Hardin | Texas | 48199 | 5619 | 110 |
1231771 | 1231771 | 2021-04-17 | Augusta | Virginia | 51015 | 5619 | 69 |
1049076 | 1049076 | 2021-02-20 | Ashtabula | Ohio | 39007 | 5619 | 138 |
1040649 | 1040649 | 2021-02-18 | Crittenden | Arkansas | 5035 | 5619 | 93 |
1028990 | 1028990 | 2021-02-14 | Lamar | Mississippi | 28073 | 5619 | 74 |
1019074 | 1019074 | 2021-02-11 | Gratiot | Michigan | 26057 | 5619 | 102 |
1006154 | 1006154 | 2021-02-07 | Blue Earth | Minnesota | 27013 | 5619 | 34 |
975959 | 975959 | 2021-01-29 | Jackson | Florida | 12063 | 5619 | 133 |
978338 | 978338 | 2021-01-29 | Hood | Texas | 48221 | 5619 | 98 |
969029 | 969029 | 2021-01-26 | Calumet | Wisconsin | 55015 | 5619 | 41 |
775909 | 775909 | 2020-11-28 | Cape Girardeau | Missouri | 29031 | 5619 | 69 |
752931 | 752931 | 2020-11-21 | Berrien | Michigan | 26021 | 5619 | 106 |
715802 | 715802 | 2020-11-09 | Clark | Washington | 53011 | 5619 | 93 |
689103 | 689103 | 2020-11-01 | Northampton | Pennsylvania | 42095 | 5619 | 315 |
522253 | 522253 | 2020-09-11 | St. Joseph | Indiana | 18141 | 5619 | 102 |
515406 | 515406 | 2020-09-09 | Bibb | Georgia | 13021 | 5619 | 142 |
465084 | 465084 | 2020-08-24 | Bernalillo | New Mexico | 35001 | 5619 | 149 |
437818 | 437818 | 2020-08-16 | Lake | Florida | 12069 | 5619 | 83 |
395914 | 395914 | 2020-08-03 | Brevard | Florida | 12009 | 5619 | 117 |
270400 | 270400 | 2020-06-24 | Bucks | Pennsylvania | 42017 | 5619 | 559 |
153334 | 153334 | 2020-05-17 | Delaware | Pennsylvania | 42045 | 5619 | 478 |
129720 | 129720 | 2020-05-09 | Dallas | Texas | 48113 | 5619 | 143 |
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);