ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
688 rows where county = "Jackson" and fips = 8057 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386212 | 386212 | 2020-07-31 | Jackson | Colorado | 8057 | 8 | 0 |
382994 | 382994 | 2020-07-30 | Jackson | Colorado | 8057 | 8 | 0 |
379777 | 379777 | 2020-07-29 | Jackson | Colorado | 8057 | 8 | 0 |
376560 | 376560 | 2020-07-28 | Jackson | Colorado | 8057 | 8 | 0 |
373346 | 373346 | 2020-07-27 | Jackson | Colorado | 8057 | 8 | 0 |
370134 | 370134 | 2020-07-26 | Jackson | Colorado | 8057 | 8 | 0 |
366924 | 366924 | 2020-07-25 | Jackson | Colorado | 8057 | 8 | 0 |
363717 | 363717 | 2020-07-24 | Jackson | Colorado | 8057 | 8 | 0 |
360510 | 360510 | 2020-07-23 | Jackson | Colorado | 8057 | 8 | 0 |
357305 | 357305 | 2020-07-22 | Jackson | Colorado | 8057 | 8 | 0 |
354102 | 354102 | 2020-07-21 | Jackson | Colorado | 8057 | 8 | 0 |
350900 | 350900 | 2020-07-20 | Jackson | Colorado | 8057 | 8 | 0 |
347699 | 347699 | 2020-07-19 | Jackson | Colorado | 8057 | 8 | 0 |
344499 | 344499 | 2020-07-18 | Jackson | Colorado | 8057 | 8 | 0 |
341300 | 341300 | 2020-07-17 | Jackson | Colorado | 8057 | 8 | 0 |
338103 | 338103 | 2020-07-16 | Jackson | Colorado | 8057 | 8 | 0 |
334908 | 334908 | 2020-07-15 | Jackson | Colorado | 8057 | 8 | 0 |
331715 | 331715 | 2020-07-14 | Jackson | Colorado | 8057 | 8 | 0 |
328529 | 328529 | 2020-07-13 | Jackson | Colorado | 8057 | 8 | 0 |
325343 | 325343 | 2020-07-12 | Jackson | Colorado | 8057 | 7 | 0 |
322162 | 322162 | 2020-07-11 | Jackson | Colorado | 8057 | 7 | 0 |
318983 | 318983 | 2020-07-10 | Jackson | Colorado | 8057 | 7 | 0 |
315810 | 315810 | 2020-07-09 | Jackson | Colorado | 8057 | 2 | 0 |
312635 | 312635 | 2020-07-08 | Jackson | Colorado | 8057 | 2 | 0 |
309465 | 309465 | 2020-07-07 | Jackson | Colorado | 8057 | 2 | 0 |
306297 | 306297 | 2020-07-06 | Jackson | Colorado | 8057 | 2 | 0 |
303133 | 303133 | 2020-07-05 | Jackson | Colorado | 8057 | 2 | 0 |
299969 | 299969 | 2020-07-04 | Jackson | Colorado | 8057 | 2 | 0 |
296807 | 296807 | 2020-07-03 | Jackson | Colorado | 8057 | 2 | 0 |
293651 | 293651 | 2020-07-02 | Jackson | Colorado | 8057 | 2 | 0 |
290497 | 290497 | 2020-07-01 | Jackson | Colorado | 8057 | 2 | 0 |
287346 | 287346 | 2020-06-30 | Jackson | Colorado | 8057 | 2 | 0 |
284200 | 284200 | 2020-06-29 | Jackson | Colorado | 8057 | 1 | 0 |
281054 | 281054 | 2020-06-28 | Jackson | Colorado | 8057 | 1 | 0 |
277907 | 277907 | 2020-06-27 | Jackson | Colorado | 8057 | 1 | 0 |
274759 | 274759 | 2020-06-26 | Jackson | Colorado | 8057 | 1 | 0 |
271619 | 271619 | 2020-06-25 | Jackson | Colorado | 8057 | 1 | 0 |
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);