ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
53 rows where cases = 6609 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 22
- Ohio 8
- Wisconsin 5
- Indiana 4
- Kansas 4
- Louisiana 4
- Mississippi 4
- Minnesota 3
- Pennsylvania 3
- Illinois 2
- Missouri 2
- New York 2
- Texas 2
- Alabama 1
- Georgia 1
- Kentucky 1
- Maryland 1
- Nevada 1
- New Mexico 1
- North Carolina 1
- South Carolina 1
- Tennessee 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500197 | 2500197 | 2022-05-13 | Douglas | Illinois | 17041 | 6609 | 61 |
2476622 | 2476622 | 2022-05-05 | Boone | West Virginia | 54005 | 6609 | 75 |
2337750 | 2337750 | 2022-03-24 | Labette | Kansas | 20099 | 6609 | 74 |
2334496 | 2334496 | 2022-03-23 | Labette | Kansas | 20099 | 6609 | 74 |
2335652 | 2335652 | 2022-03-23 | Hocking | Ohio | 39073 | 6609 | 117 |
2331242 | 2331242 | 2022-03-22 | Labette | Kansas | 20099 | 6609 | 74 |
2332398 | 2332398 | 2022-03-22 | Hocking | Ohio | 39073 | 6609 | 117 |
2327990 | 2327990 | 2022-03-21 | Labette | Kansas | 20099 | 6609 | 74 |
2329145 | 2329145 | 2022-03-21 | Hocking | Ohio | 39073 | 6609 | 117 |
2325893 | 2325893 | 2022-03-20 | Hocking | Ohio | 39073 | 6609 | 117 |
2322640 | 2322640 | 2022-03-19 | Hocking | Ohio | 39073 | 6609 | 117 |
2319386 | 2319386 | 2022-03-18 | Hocking | Ohio | 39073 | 6609 | 117 |
2316132 | 2316132 | 2022-03-17 | Hocking | Ohio | 39073 | 6609 | 117 |
2287505 | 2287505 | 2022-03-08 | Hutchinson | Texas | 48233 | 6609 | 133 |
2270918 | 2270918 | 2022-03-03 | Abbeville | South Carolina | 45001 | 6609 | 67 |
2165166 | 2165166 | 2022-01-30 | Greene | Indiana | 18055 | 6609 | 123 |
2161911 | 2161911 | 2022-01-29 | Greene | Indiana | 18055 | 6609 | 123 |
2158656 | 2158656 | 2022-01-28 | Greene | Indiana | 18055 | 6609 | 123 |
2154589 | 2154589 | 2022-01-26 | Door | Wisconsin | 55029 | 6609 | 53 |
2122050 | 2122050 | 2022-01-16 | Clark | Wisconsin | 55019 | 6609 | 110 |
2118798 | 2118798 | 2022-01-15 | Clark | Wisconsin | 55019 | 6609 | 110 |
2115546 | 2115546 | 2022-01-14 | Clark | Wisconsin | 55019 | 6609 | 110 |
2098432 | 2098432 | 2022-01-09 | McKean | Pennsylvania | 42083 | 6609 | 118 |
2081409 | 2081409 | 2022-01-04 | Howell | Missouri | 29091 | 6609 | 175 |
2020408 | 2020408 | 2021-12-16 | Jefferson | Pennsylvania | 42065 | 6609 | 174 |
1927783 | 1927783 | 2021-11-18 | Stephenson | Illinois | 17177 | 6609 | 120 |
1919251 | 1919251 | 2021-11-15 | Alexander | North Carolina | 37003 | 6609 | 118 |
1904266 | 1904266 | 2021-11-10 | Douglas | Wisconsin | 55031 | 6609 | 66 |
1890166 | 1890166 | 2021-11-06 | Brown | Ohio | 39015 | 6609 | 99 |
1824585 | 1824585 | 2021-10-17 | Pontotoc | Mississippi | 28115 | 6609 | 101 |
1821336 | 1821336 | 2021-10-16 | Pontotoc | Mississippi | 28115 | 6609 | 101 |
1818087 | 1818087 | 2021-10-15 | Pontotoc | Mississippi | 28115 | 6609 | 101 |
1724672 | 1724672 | 2021-09-16 | Columbia | Pennsylvania | 42037 | 6609 | 140 |
1720523 | 1720523 | 2021-09-15 | Otter Tail | Minnesota | 27111 | 6609 | 90 |
1632155 | 1632155 | 2021-08-19 | Dubois | Indiana | 18037 | 6609 | 119 |
1574126 | 1574126 | 2021-08-01 | St. Charles | Louisiana | 22089 | 6609 | 99 |
1570878 | 1570878 | 2021-07-31 | St. Charles | Louisiana | 22089 | 6609 | 99 |
1567630 | 1567630 | 2021-07-30 | St. Charles | Louisiana | 22089 | 6609 | 99 |
1451350 | 1451350 | 2021-06-24 | Carson City | Nevada | 32510 | 6609 | 124 |
1406880 | 1406880 | 2021-06-10 | Hood | Texas | 48221 | 6609 | 132 |
1370338 | 1370338 | 2021-05-30 | St. Lawrence | New York | 36089 | 6609 | 96 |
1367092 | 1367092 | 2021-05-29 | St. Lawrence | New York | 36089 | 6609 | 96 |
1360068 | 1360068 | 2021-05-27 | Kandiyohi | Minnesota | 27067 | 6609 | 84 |
1358016 | 1358016 | 2021-05-26 | Gibson | Tennessee | 47053 | 6609 | 147 |
1308104 | 1308104 | 2021-05-11 | Crow Wing | Minnesota | 27035 | 6609 | 88 |
1148787 | 1148787 | 2021-03-23 | Iberia | Louisiana | 22045 | 6609 | 150 |
1136502 | 1136502 | 2021-03-19 | Valencia | New Mexico | 35061 | 6609 | 101 |
1122686 | 1122686 | 2021-03-15 | Bullitt | Kentucky | 21029 | 6609 | 50 |
1025519 | 1025519 | 2021-02-13 | Wicomico | Maryland | 24045 | 6609 | 137 |
1022500 | 1022500 | 2021-02-12 | Lauderdale | Mississippi | 28075 | 6609 | 219 |
855557 | 855557 | 2020-12-23 | DeKalb | Alabama | 1049 | 6609 | 55 |
791105 | 791105 | 2020-12-03 | Lowndes | Georgia | 13185 | 6609 | 128 |
535963 | 535963 | 2020-09-15 | Jackson | Missouri | 29095 | 6609 | 88 |
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);