ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where cases = 5969 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 25
- Minnesota 6
- Wisconsin 5
- Pennsylvania 4
- Virginia 4
- Alabama 3
- Florida 3
- Indiana 3
- Michigan 3
- New York 3
- Texas 3
- Georgia 2
- Mississippi 2
- Montana 2
- Nebraska 2
- Puerto Rico 2
- Tennessee 2
- Arkansas 1
- California 1
- Illinois 1
- Iowa 1
- Kentucky 1
- Maryland 1
- New Mexico 1
- North Carolina 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2471631 | 2471631 | 2022-05-04 | Meeker | Minnesota | 27093 | 5969 | 75 |
2465610 | 2465610 | 2022-05-02 | Essex | New York | 36031 | 5969 | 59 |
2327011 | 2327011 | 2022-03-20 | Vernon | Wisconsin | 55123 | 5969 | 92 |
2323758 | 2323758 | 2022-03-19 | Vernon | Wisconsin | 55123 | 5969 | 92 |
2320504 | 2320504 | 2022-03-18 | Vernon | Wisconsin | 55123 | 5969 | 92 |
2303395 | 2303395 | 2022-03-13 | Juncos | Puerto Rico | 72077 | 5969 | |
2247423 | 2247423 | 2022-02-24 | Cass | Nebraska | 31025 | 5969 | 40 |
2244172 | 2244172 | 2022-02-23 | Cass | Nebraska | 31025 | 5969 | 40 |
2212695 | 2212695 | 2022-02-13 | Gray | Texas | 48179 | 5969 | 116 |
2209126 | 2209126 | 2022-02-12 | San Sebastian | Puerto Rico | 72131 | 5969 | |
2145330 | 2145330 | 2022-01-24 | Chattooga | Georgia | 13055 | 5969 | 116 |
2053870 | 2053870 | 2021-12-27 | Chambers | Alabama | 1017 | 5969 | 147 |
2037487 | 2037487 | 2021-12-21 | Marshall | West Virginia | 54051 | 5969 | 131 |
2023685 | 2023685 | 2021-12-17 | Tioga | Pennsylvania | 42117 | 5969 | 164 |
2017444 | 2017444 | 2021-12-15 | Marion | Tennessee | 47115 | 5969 | 77 |
1990269 | 1990269 | 2021-12-07 | Alcorn | Mississippi | 28003 | 5969 | 108 |
1985410 | 1985410 | 2021-12-05 | Wise | Virginia | 51195 | 5969 | 132 |
1982160 | 1982160 | 2021-12-04 | Wise | Virginia | 51195 | 5969 | 132 |
1978910 | 1978910 | 2021-12-03 | Wise | Virginia | 51195 | 5969 | 132 |
1973693 | 1973693 | 2021-12-02 | Muhlenberg | Kentucky | 21177 | 5969 | 97 |
1975414 | 1975414 | 2021-12-02 | Polk | Texas | 48373 | 5969 | 217 |
1971668 | 1971668 | 2021-12-01 | Perry | Pennsylvania | 42099 | 5969 | 134 |
1972165 | 1972165 | 2021-12-01 | Polk | Texas | 48373 | 5969 | 216 |
1899507 | 1899507 | 2021-11-09 | Silver Bow | Montana | 30093 | 5969 | 104 |
1860255 | 1860255 | 2021-10-28 | Steele | Minnesota | 27147 | 5969 | 26 |
1849135 | 1849135 | 2021-10-25 | Franklin | Alabama | 1059 | 5969 | 105 |
1824470 | 1824470 | 2021-10-17 | Itasca | Minnesota | 27061 | 5969 | 78 |
1821221 | 1821221 | 2021-10-16 | Itasca | Minnesota | 27061 | 5969 | 78 |
1817972 | 1817972 | 2021-10-15 | Itasca | Minnesota | 27061 | 5969 | 78 |
1782252 | 1782252 | 2021-10-04 | Mower | Minnesota | 27099 | 5969 | 39 |
1713376 | 1713376 | 2021-09-13 | Gibson | Indiana | 18051 | 5969 | 107 |
1517911 | 1517911 | 2021-07-15 | Mississippi | Arkansas | 5093 | 5969 | 110 |
1496279 | 1496279 | 2021-07-08 | Barry | Michigan | 26015 | 5969 | 69 |
1493032 | 1493032 | 2021-07-07 | Barry | Michigan | 26015 | 5969 | 69 |
1489785 | 1489785 | 2021-07-06 | Barry | Michigan | 26015 | 5969 | 69 |
1372468 | 1372468 | 2021-05-31 | Shelby | Indiana | 18145 | 5969 | 107 |
1369223 | 1369223 | 2021-05-30 | Shelby | Indiana | 18145 | 5969 | 107 |
1327461 | 1327461 | 2021-05-17 | St. Mary's | Maryland | 24037 | 5969 | 124 |
1316408 | 1316408 | 2021-05-13 | Barron | Wisconsin | 55005 | 5969 | 83 |
1271720 | 1271720 | 2021-04-30 | Ogle | Illinois | 17141 | 5969 | 87 |
1225809 | 1225809 | 2021-04-16 | San Benito | California | 6069 | 5969 | 63 |
1184814 | 1184814 | 2021-04-03 | Lafayette | Mississippi | 28071 | 5969 | 116 |
1185256 | 1185256 | 2021-04-03 | St. Lawrence | New York | 36089 | 5969 | 94 |
1147332 | 1147332 | 2021-03-22 | Bedford | Virginia | 51019 | 5969 | 97 |
1102545 | 1102545 | 2021-03-09 | Jackson | Florida | 12063 | 5969 | 153 |
1068368 | 1068368 | 2021-02-26 | Oswego | New York | 36075 | 5969 | 89 |
1065540 | 1065540 | 2021-02-25 | Lawrence | Pennsylvania | 42073 | 5969 | 181 |
1053522 | 1053522 | 2021-02-22 | Colbert | Alabama | 1033 | 5969 | 117 |
993476 | 993476 | 2021-02-03 | Lewis and Clark | Montana | 30049 | 5969 | 61 |
927381 | 927381 | 2021-01-14 | Glynn | Georgia | 13127 | 5969 | 138 |
805441 | 805441 | 2020-12-07 | Santa Fe | New Mexico | 35049 | 5969 | 41 |
792621 | 792621 | 2020-12-03 | Wayne | North Carolina | 37191 | 5969 | 117 |
702975 | 702975 | 2020-11-05 | Sheboygan | Wisconsin | 55117 | 5969 | 33 |
674667 | 674667 | 2020-10-28 | Johnson | Iowa | 19103 | 5969 | 31 |
618041 | 618041 | 2020-10-10 | Williamson | Tennessee | 47187 | 5969 | 46 |
367028 | 367028 | 2020-07-25 | Seminole | Florida | 12117 | 5969 | 65 |
363829 | 363829 | 2020-07-24 | Volusia | Florida | 12127 | 5969 | 96 |
165428 | 165428 | 2020-05-21 | Delaware | Pennsylvania | 42045 | 5969 | 491 |
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);