ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
39 rows where cases = 107 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1826635 | 1826635 | 2021-10-18 | Jackson | Colorado | 8057 | 107 | 0 |
1738922 | 1738922 | 2021-09-21 | Mineral | Colorado | 8079 | 107 | 1 |
1336243 | 1336243 | 2021-05-20 | Dolores | Colorado | 8033 | 107 | 0 |
784383 | 784383 | 2020-12-01 | Baca | Colorado | 8009 | 107 | 0 |
771456 | 771456 | 2020-11-27 | Sedgwick | Colorado | 8115 | 107 | 2 |
751970 | 751970 | 2020-11-21 | Ouray | Colorado | 8091 | 107 | 2 |
742188 | 742188 | 2020-11-18 | Archuleta | Colorado | 8007 | 107 | 0 |
725996 | 725996 | 2020-11-13 | Las Animas | Colorado | 8071 | 107 | 0 |
719485 | 719485 | 2020-11-11 | Conejos | Colorado | 8021 | 107 | 1 |
690331 | 690331 | 2020-11-02 | Park | Colorado | 8093 | 107 | 1 |
648146 | 648146 | 2020-10-20 | Kit Carson | Colorado | 8063 | 107 | 3 |
609230 | 609230 | 2020-10-08 | Otero | Colorado | 8089 | 107 | 6 |
605987 | 605987 | 2020-10-07 | Otero | Colorado | 8089 | 107 | 6 |
602745 | 602745 | 2020-10-06 | Otero | Colorado | 8089 | 107 | 6 |
599502 | 599502 | 2020-10-05 | Otero | Colorado | 8089 | 107 | 6 |
596259 | 596259 | 2020-10-04 | Otero | Colorado | 8089 | 107 | 6 |
440988 | 440988 | 2020-08-17 | Saguache | Colorado | 8109 | 107 | 2 |
421605 | 421605 | 2020-08-11 | Elbert | Colorado | 8039 | 107 | 2 |
399103 | 399103 | 2020-08-04 | Saguache | Colorado | 8109 | 107 | 2 |
395887 | 395887 | 2020-08-03 | Saguache | Colorado | 8109 | 107 | 2 |
392670 | 392670 | 2020-08-02 | Routt | Colorado | 8107 | 107 | 6 |
392671 | 392671 | 2020-08-02 | Saguache | Colorado | 8109 | 107 | 2 |
389454 | 389454 | 2020-08-01 | Saguache | Colorado | 8109 | 107 | 2 |
386224 | 386224 | 2020-07-31 | Montezuma | Colorado | 8083 | 107 | 4 |
386237 | 386237 | 2020-07-31 | Saguache | Colorado | 8109 | 107 | 2 |
383006 | 383006 | 2020-07-30 | Montezuma | Colorado | 8083 | 107 | 4 |
383019 | 383019 | 2020-07-30 | Saguache | Colorado | 8109 | 107 | 2 |
379802 | 379802 | 2020-07-29 | Saguache | Colorado | 8109 | 107 | 2 |
376585 | 376585 | 2020-07-28 | Saguache | Colorado | 8109 | 107 | 2 |
373371 | 373371 | 2020-07-27 | Saguache | Colorado | 8109 | 107 | 2 |
370159 | 370159 | 2020-07-26 | Saguache | Colorado | 8109 | 107 | 2 |
366949 | 366949 | 2020-07-25 | Saguache | Colorado | 8109 | 107 | 2 |
363742 | 363742 | 2020-07-24 | Saguache | Colorado | 8109 | 107 | 2 |
224849 | 224849 | 2020-06-10 | Alamosa | Colorado | 8003 | 107 | 3 |
115624 | 115624 | 2020-05-05 | Montrose | Colorado | 8085 | 107 | 11 |
78721 | 78721 | 2020-04-22 | Pueblo | Colorado | 8101 | 107 | 7 |
24099 | 24099 | 2020-04-01 | Larimer | Colorado | 8069 | 107 | 7 |
21918 | 21918 | 2020-03-31 | Boulder | Colorado | 8013 | 107 | 2 |
12561 | 12561 | 2020-03-26 | Weld | Colorado | 8123 | 107 | 4 |
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);