ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where cases = 10779 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 |
---|---|---|---|---|---|---|---|
2485527 | 2485527 | 2022-05-08 | Coos | Oregon | 41011 | 10779 | 153 |
2482269 | 2482269 | 2022-05-07 | Coos | Oregon | 41011 | 10779 | 153 |
2479011 | 2479011 | 2022-05-06 | Coos | Oregon | 41011 | 10779 | 153 |
2358518 | 2358518 | 2022-03-30 | Logan | Oklahoma | 40083 | 10779 | 158 |
2355264 | 2355264 | 2022-03-29 | Logan | Oklahoma | 40083 | 10779 | 158 |
2352011 | 2352011 | 2022-03-28 | Logan | Oklahoma | 40083 | 10779 | 158 |
2348759 | 2348759 | 2022-03-27 | Logan | Oklahoma | 40083 | 10779 | 158 |
2345506 | 2345506 | 2022-03-26 | Logan | Oklahoma | 40083 | 10779 | 158 |
2342253 | 2342253 | 2022-03-25 | Logan | Oklahoma | 40083 | 10779 | 158 |
2339000 | 2339000 | 2022-03-24 | Logan | Oklahoma | 40083 | 10779 | 158 |
2339848 | 2339848 | 2022-03-24 | Shenandoah | Virginia | 51171 | 10779 | 221 |
2332951 | 2332951 | 2022-03-22 | Burnet | Texas | 48053 | 10779 | 166 |
2333340 | 2333340 | 2022-03-22 | Shenandoah | Virginia | 51171 | 10779 | 221 |
2330087 | 2330087 | 2022-03-21 | Shenandoah | Virginia | 51171 | 10779 | 221 |
2308259 | 2308259 | 2022-03-15 | Harrison | Indiana | 18061 | 10779 | 137 |
2279605 | 2279605 | 2022-03-06 | Douglas | Minnesota | 27041 | 10779 | 115 |
2276352 | 2276352 | 2022-03-05 | Douglas | Minnesota | 27041 | 10779 | 115 |
2273099 | 2273099 | 2022-03-04 | Douglas | Minnesota | 27041 | 10779 | 115 |
2019561 | 2019561 | 2021-12-16 | Lamar | Mississippi | 28073 | 10779 | 140 |
2007965 | 2007965 | 2021-12-12 | Val Verde | Texas | 48465 | 10779 | 256 |
1979106 | 1979106 | 2021-12-04 | Blount | Alabama | 1009 | 10779 | 193 |
1897271 | 1897271 | 2021-11-08 | Coryell | Texas | 48099 | 10779 | 163 |
1865479 | 1865479 | 2021-10-30 | Crawford | Arkansas | 5033 | 10779 | 173 |
1856792 | 1856792 | 2021-10-27 | Androscoggin | Maine | 23001 | 10779 | 99 |
1766753 | 1766753 | 2021-09-29 | Pickaway | Ohio | 39129 | 10779 | 130 |
1695304 | 1695304 | 2021-09-07 | Wayne | Ohio | 39169 | 10779 | 231 |
1598340 | 1598340 | 2021-08-08 | Bastrop | Texas | 48021 | 10779 | 109 |
1595091 | 1595091 | 2021-08-07 | Bastrop | Texas | 48021 | 10779 | 109 |
1360823 | 1360823 | 2021-05-27 | Miami | Ohio | 39109 | 10779 | 221 |
859623 | 859623 | 2020-12-24 | Johnson | Iowa | 19103 | 10779 | 47 |
791134 | 791134 | 2020-12-03 | Richmond | Georgia | 13245 | 10779 | 222 |
793366 | 793366 | 2020-12-03 | Jefferson | Texas | 48245 | 10779 | 183 |
767281 | 767281 | 2020-11-25 | Williamson | Tennessee | 47187 | 10779 | 79 |
467066 | 467066 | 2020-08-25 | Ada | Idaho | 16001 | 10779 | 113 |
237758 | 237758 | 2020-06-14 | Marion | Indiana | 18097 | 10779 | 694 |
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);