ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
36 rows where cases = 116 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1914368 | 1914368 | 2021-11-14 | Jackson | Colorado | 8057 | 116 | 0 |
1911118 | 1911118 | 2021-11-13 | Jackson | Colorado | 8057 | 116 | 0 |
1907869 | 1907869 | 2021-11-12 | Jackson | Colorado | 8057 | 116 | 0 |
1904620 | 1904620 | 2021-11-11 | Jackson | Colorado | 8057 | 116 | 0 |
1901370 | 1901370 | 2021-11-10 | Jackson | Colorado | 8057 | 116 | 0 |
1898120 | 1898120 | 2021-11-09 | Jackson | Colorado | 8057 | 116 | 0 |
1894870 | 1894870 | 2021-11-08 | Jackson | Colorado | 8057 | 116 | 0 |
1777910 | 1777910 | 2021-10-03 | Mineral | Colorado | 8079 | 116 | 1 |
1774660 | 1774660 | 2021-10-02 | Mineral | Colorado | 8079 | 116 | 1 |
1771410 | 1771410 | 2021-10-01 | Mineral | Colorado | 8079 | 116 | 1 |
1745411 | 1745411 | 2021-09-23 | Kiowa | Colorado | 8061 | 116 | 4 |
1404409 | 1404409 | 2021-06-10 | Dolores | Colorado | 8033 | 116 | 1 |
820132 | 820132 | 2020-12-12 | Sedgwick | Colorado | 8115 | 116 | 2 |
816886 | 816886 | 2020-12-11 | Sedgwick | Colorado | 8115 | 116 | 2 |
813640 | 813640 | 2020-12-10 | Sedgwick | Colorado | 8115 | 116 | 2 |
810396 | 810396 | 2020-12-09 | Sedgwick | Colorado | 8115 | 116 | 2 |
755207 | 755207 | 2020-11-22 | Lincoln | Colorado | 8073 | 116 | 0 |
751952 | 751952 | 2020-11-21 | Huerfano | Colorado | 8055 | 116 | 4 |
751961 | 751961 | 2020-11-21 | Lincoln | Colorado | 8073 | 116 | 0 |
735730 | 735730 | 2020-11-16 | Las Animas | Colorado | 8071 | 116 | 0 |
732484 | 732484 | 2020-11-15 | Las Animas | Colorado | 8071 | 116 | 0 |
706556 | 706556 | 2020-11-07 | San Miguel | Colorado | 8113 | 116 | 0 |
657901 | 657901 | 2020-10-23 | Rio Grande | Colorado | 8105 | 116 | 3 |
635163 | 635163 | 2020-10-16 | Lake | Colorado | 8065 | 116 | 0 |
628694 | 628694 | 2020-10-14 | Saguache | Colorado | 8109 | 116 | 2 |
625421 | 625421 | 2020-10-13 | Grand | Colorado | 8049 | 116 | 1 |
625451 | 625451 | 2020-10-13 | Saguache | Colorado | 8109 | 116 | 2 |
622178 | 622178 | 2020-10-12 | Grand | Colorado | 8049 | 116 | 1 |
622208 | 622208 | 2020-10-12 | Saguache | Colorado | 8109 | 116 | 2 |
618965 | 618965 | 2020-10-11 | Saguache | Colorado | 8109 | 116 | 2 |
405505 | 405505 | 2020-08-06 | Fremont | Colorado | 8043 | 116 | 0 |
325323 | 325323 | 2020-07-12 | Chaffee | Colorado | 8015 | 116 | 19 |
293654 | 293654 | 2020-07-02 | La Plata | Colorado | 8067 | 116 | 1 |
290500 | 290500 | 2020-07-01 | La Plata | Colorado | 8067 | 116 | 1 |
234160 | 234160 | 2020-06-13 | Alamosa | Colorado | 8003 | 116 | 3 |
84315 | 84315 | 2020-04-24 | Pueblo | Colorado | 8101 | 116 | 9 |
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);