ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
27 rows where cases = 15468 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 13
- Tennessee 5
- Alabama 4
- South Carolina 3
- California 2
- Georgia 2
- Illinois 2
- Pennsylvania 2
- Wisconsin 2
- Arkansas 1
- Idaho 1
- Iowa 1
- New York 1
- Ohio 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2311417 | 2311417 | 2022-03-16 | Jackson | Illinois | 17077 | 15468 | 129 |
2245740 | 2245740 | 2022-02-24 | Autauga | Alabama | 1001 | 15468 | 192 |
2239447 | 2239447 | 2022-02-22 | Mendocino | California | 6045 | 15468 | 110 |
2147211 | 2147211 | 2022-01-24 | Indiana | Pennsylvania | 42063 | 15468 | 321 |
2128810 | 2128810 | 2022-01-19 | Pope | Arkansas | 5115 | 15468 | 171 |
1849127 | 1849127 | 2021-10-25 | Cullman | Alabama | 1043 | 15468 | 293 |
1802813 | 1802813 | 2021-10-10 | Lancaster | South Carolina | 45057 | 15468 | 217 |
1799564 | 1799564 | 2021-10-09 | Lancaster | South Carolina | 45057 | 15468 | 217 |
1796315 | 1796315 | 2021-10-08 | Lancaster | South Carolina | 45057 | 15468 | 217 |
1631397 | 1631397 | 2021-08-18 | Sheboygan | Wisconsin | 55117 | 15468 | 172 |
1576890 | 1576890 | 2021-08-02 | Rock Island | Illinois | 17161 | 15468 | 372 |
1557120 | 1557120 | 2021-07-27 | Bartow | Georgia | 13015 | 15468 | 241 |
1553894 | 1553894 | 2021-07-26 | Clarke | Georgia | 13059 | 15468 | 149 |
1545823 | 1545823 | 2021-07-23 | Greene | Ohio | 39057 | 15468 | 254 |
1526136 | 1526136 | 2021-07-17 | Saratoga | New York | 36091 | 15468 | 168 |
1390185 | 1390185 | 2021-06-05 | Beaver | Pennsylvania | 42007 | 15468 | 384 |
1289814 | 1289814 | 2021-05-05 | Blount | Tennessee | 47009 | 15468 | 193 |
1213400 | 1213400 | 2021-04-12 | Black Hawk | Iowa | 19013 | 15468 | 306 |
1196397 | 1196397 | 2021-04-07 | Lee | Alabama | 1081 | 15468 | 165 |
1193149 | 1193149 | 2021-04-06 | Lee | Alabama | 1081 | 15468 | 165 |
1189220 | 1189220 | 2021-04-04 | Sullivan | Tennessee | 47163 | 15468 | 281 |
1185973 | 1185973 | 2021-04-03 | Sullivan | Tennessee | 47163 | 15468 | 281 |
1182726 | 1182726 | 2021-04-02 | Sullivan | Tennessee | 47163 | 15468 | 281 |
1179479 | 1179479 | 2021-04-01 | Sullivan | Tennessee | 47163 | 15468 | 281 |
1008026 | 1008026 | 2021-02-07 | Rock | Wisconsin | 55105 | 15468 | 161 |
797340 | 797340 | 2020-12-05 | San Mateo | California | 6081 | 15468 | 176 |
651669 | 651669 | 2020-10-21 | Ada | Idaho | 16001 | 15468 | 159 |
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);