ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
29 rows where cases = 14917 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 11
- Tennessee 10
- Texas 8
- Pennsylvania 2
- Wisconsin 2
- Iowa 1
- Mississippi 1
- Missouri 1
- Nebraska 1
- New Jersey 1
- Ohio 1
- Oregon 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2352624 | 2352624 | 2022-03-28 | Orange | Texas | 48361 | 14917 | 351 |
2349372 | 2349372 | 2022-03-27 | Orange | Texas | 48361 | 14917 | 351 |
2346119 | 2346119 | 2022-03-26 | Orange | Texas | 48361 | 14917 | 351 |
2342866 | 2342866 | 2022-03-25 | Orange | Texas | 48361 | 14917 | 351 |
2339613 | 2339613 | 2022-03-24 | Orange | Texas | 48361 | 14917 | 351 |
2336359 | 2336359 | 2022-03-23 | Orange | Texas | 48361 | 14917 | 351 |
2332830 | 2332830 | 2022-03-22 | Bedford | Tennessee | 47003 | 14917 | 228 |
2333105 | 2333105 | 2022-03-22 | Orange | Texas | 48361 | 14917 | 351 |
2329577 | 2329577 | 2022-03-21 | Bedford | Tennessee | 47003 | 14917 | 228 |
2329852 | 2329852 | 2022-03-21 | Orange | Texas | 48361 | 14917 | 351 |
2326325 | 2326325 | 2022-03-20 | Bedford | Tennessee | 47003 | 14917 | 228 |
2323072 | 2323072 | 2022-03-19 | Bedford | Tennessee | 47003 | 14917 | 228 |
2319818 | 2319818 | 2022-03-18 | Bedford | Tennessee | 47003 | 14917 | 228 |
2316564 | 2316564 | 2022-03-17 | Bedford | Tennessee | 47003 | 14917 | 228 |
2313311 | 2313311 | 2022-03-16 | Bedford | Tennessee | 47003 | 14917 | 228 |
2290246 | 2290246 | 2022-03-09 | Benton | Oregon | 41003 | 14917 | 63 |
2217932 | 2217932 | 2022-02-15 | Lafayette | Mississippi | 28071 | 14917 | 173 |
2156380 | 2156380 | 2022-01-27 | Hall | Nebraska | 31079 | 14917 | 120 |
1853877 | 1853877 | 2021-10-26 | Clay | Missouri | 29047 | 14917 | 215 |
1711547 | 1711547 | 2021-09-12 | Wood | Ohio | 39173 | 14917 | 207 |
1572031 | 1572031 | 2021-07-31 | Schuylkill | Pennsylvania | 42107 | 14917 | 413 |
1568783 | 1568783 | 2021-07-30 | Schuylkill | Pennsylvania | 42107 | 14917 | 413 |
1520373 | 1520373 | 2021-07-15 | Washington | Tennessee | 47179 | 14917 | 254 |
1517125 | 1517125 | 2021-07-14 | Washington | Tennessee | 47179 | 14917 | 254 |
1236225 | 1236225 | 2021-04-19 | Woodbury | Iowa | 19193 | 14917 | 221 |
1221626 | 1221626 | 2021-04-14 | Blount | Tennessee | 47009 | 14917 | 194 |
1136453 | 1136453 | 2021-03-19 | Cumberland | New Jersey | 34011 | 14917 | 394 |
1056693 | 1056693 | 2021-02-22 | Marathon | Wisconsin | 55073 | 14917 | 204 |
793818 | 793818 | 2020-12-03 | Outagamie | Wisconsin | 55087 | 14917 | 133 |
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);