ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40 rows where cases = 8727 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 |
---|---|---|---|---|---|---|---|
2413519 | 2413519 | 2022-04-16 | Greene | New York | 36039 | 8727 | 125 |
2350314 | 2350314 | 2022-03-28 | Oconee | Georgia | 13219 | 8727 | 105 |
2302351 | 2302351 | 2022-03-13 | Becker | Minnesota | 27005 | 8727 | 90 |
2299099 | 2299099 | 2022-03-12 | Becker | Minnesota | 27005 | 8727 | 90 |
2295847 | 2295847 | 2022-03-11 | Becker | Minnesota | 27005 | 8727 | 90 |
2198153 | 2198153 | 2022-02-09 | Aroostook | Maine | 23003 | 8727 | 116 |
2198577 | 2198577 | 2022-02-09 | Webster | Missouri | 29225 | 8727 | 132 |
2149940 | 2149940 | 2022-01-25 | Lyon | Nevada | 32019 | 8727 | 148 |
2107775 | 2107775 | 2022-01-12 | Tioga | New York | 36107 | 8727 | 79 |
2019161 | 2019161 | 2021-12-16 | Henderson | Kentucky | 21101 | 8727 | 129 |
1983024 | 1983024 | 2021-12-05 | Ogle | Illinois | 17141 | 8727 | 108 |
1979774 | 1979774 | 2021-12-04 | Ogle | Illinois | 17141 | 8727 | 108 |
1976524 | 1976524 | 2021-12-03 | Ogle | Illinois | 17141 | 8727 | 108 |
1940849 | 1940849 | 2021-11-22 | Marshall | Indiana | 18099 | 8727 | 151 |
1860173 | 1860173 | 2021-10-28 | Shiawassee | Michigan | 26155 | 8727 | 130 |
1856924 | 1856924 | 2021-10-27 | Shiawassee | Michigan | 26155 | 8727 | 130 |
1857154 | 1857154 | 2021-10-27 | Joplin | Missouri | 8727 | 150 | |
1843818 | 1843818 | 2021-10-23 | Cecil | Maryland | 24015 | 8727 | 175 |
1831375 | 1831375 | 2021-10-19 | Carson City | Nevada | 32510 | 8727 | 149 |
1725120 | 1725120 | 2021-09-16 | Henderson | Texas | 48213 | 8727 | 267 |
1721871 | 1721871 | 2021-09-15 | Henderson | Texas | 48213 | 8727 | 261 |
1718623 | 1718623 | 2021-09-14 | Henderson | Texas | 48213 | 8727 | 256 |
1542612 | 1542612 | 2021-07-22 | Pickaway | Ohio | 39129 | 8727 | 122 |
1527109 | 1527109 | 2021-07-17 | Walker | Texas | 48471 | 8727 | 133 |
1520614 | 1520614 | 2021-07-15 | Walker | Texas | 48471 | 8727 | 133 |
1446943 | 1446943 | 2021-06-23 | Adams | Illinois | 17001 | 8727 | 156 |
1326096 | 1326096 | 2021-05-16 | Cabell | West Virginia | 54011 | 8727 | 172 |
1234944 | 1234944 | 2021-04-18 | Walker | Texas | 48471 | 8727 | 125 |
1199630 | 1199630 | 2021-04-08 | DeKalb | Alabama | 1049 | 8727 | 181 |
1201918 | 1201918 | 2021-04-08 | Northumberland | Pennsylvania | 42097 | 8727 | 338 |
1160777 | 1160777 | 2021-03-27 | Jefferson | Arkansas | 5069 | 8727 | 162 |
1109235 | 1109235 | 2021-03-11 | Unknown | Guam | 8727 | 134 | |
1017599 | 1017599 | 2021-02-10 | Stafford | Virginia | 51179 | 8727 | 53 |
946496 | 946496 | 2021-01-20 | Apache | Arizona | 4001 | 8727 | 280 |
877326 | 877326 | 2020-12-29 | Washington | Pennsylvania | 42125 | 8727 | 122 |
788680 | 788680 | 2020-12-02 | Muskegon | Michigan | 26121 | 8727 | 191 |
778023 | 778023 | 2020-11-29 | St. Johns | Florida | 12109 | 8727 | 96 |
746343 | 746343 | 2020-11-19 | Ouachita | Louisiana | 22073 | 8727 | 200 |
700279 | 700279 | 2020-11-05 | Richmond | Georgia | 13245 | 8727 | 200 |
669403 | 669403 | 2020-10-26 | Butler | Ohio | 39017 | 8727 | 131 |
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);