ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
31 rows where deaths = 20 and fips = 8049 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2141928 | 2141928 | 2022-01-23 | Grand | Colorado | 8049 | 3169 | 20 |
2138673 | 2138673 | 2022-01-22 | Grand | Colorado | 8049 | 3169 | 20 |
2135417 | 2135417 | 2022-01-21 | Grand | Colorado | 8049 | 3169 | 20 |
2132165 | 2132165 | 2022-01-20 | Grand | Colorado | 8049 | 3143 | 20 |
2128912 | 2128912 | 2022-01-19 | Grand | Colorado | 8049 | 3116 | 20 |
2125658 | 2125658 | 2022-01-18 | Grand | Colorado | 8049 | 3092 | 20 |
2122406 | 2122406 | 2022-01-17 | Grand | Colorado | 8049 | 3088 | 20 |
2119154 | 2119154 | 2022-01-16 | Grand | Colorado | 8049 | 3039 | 20 |
2115902 | 2115902 | 2022-01-15 | Grand | Colorado | 8049 | 3039 | 20 |
2112651 | 2112651 | 2022-01-14 | Grand | Colorado | 8049 | 3039 | 20 |
2109399 | 2109399 | 2022-01-13 | Grand | Colorado | 8049 | 2995 | 20 |
2106148 | 2106148 | 2022-01-12 | Grand | Colorado | 8049 | 2894 | 20 |
2102897 | 2102897 | 2022-01-11 | Grand | Colorado | 8049 | 2885 | 20 |
2099646 | 2099646 | 2022-01-10 | Grand | Colorado | 8049 | 2874 | 20 |
2096395 | 2096395 | 2022-01-09 | Grand | Colorado | 8049 | 2709 | 20 |
2093143 | 2093143 | 2022-01-08 | Grand | Colorado | 8049 | 2709 | 20 |
2089891 | 2089891 | 2022-01-07 | Grand | Colorado | 8049 | 2709 | 20 |
2086640 | 2086640 | 2022-01-06 | Grand | Colorado | 8049 | 2676 | 20 |
2083388 | 2083388 | 2022-01-05 | Grand | Colorado | 8049 | 2666 | 20 |
2080136 | 2080136 | 2022-01-04 | Grand | Colorado | 8049 | 2649 | 20 |
2076884 | 2076884 | 2022-01-03 | Grand | Colorado | 8049 | 2640 | 20 |
2073633 | 2073633 | 2022-01-02 | Grand | Colorado | 8049 | 2571 | 20 |
2070382 | 2070382 | 2022-01-01 | Grand | Colorado | 8049 | 2571 | 20 |
2067131 | 2067131 | 2021-12-31 | Grand | Colorado | 8049 | 2571 | 20 |
2063880 | 2063880 | 2021-12-30 | Grand | Colorado | 8049 | 2530 | 20 |
2060630 | 2060630 | 2021-12-29 | Grand | Colorado | 8049 | 2480 | 20 |
2057381 | 2057381 | 2021-12-28 | Grand | Colorado | 8049 | 2462 | 20 |
2054132 | 2054132 | 2021-12-27 | Grand | Colorado | 8049 | 2453 | 20 |
2050882 | 2050882 | 2021-12-26 | Grand | Colorado | 8049 | 2424 | 20 |
2047632 | 2047632 | 2021-12-25 | Grand | Colorado | 8049 | 2424 | 20 |
2044382 | 2044382 | 2021-12-24 | Grand | Colorado | 8049 | 2424 | 20 |
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);