ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
59 rows where cases = 106 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 |
---|---|---|---|---|---|---|---|
2141930 | 2141930 | 2022-01-23 | Hinsdale | Colorado | 8053 | 106 | 0 |
2138675 | 2138675 | 2022-01-22 | Hinsdale | Colorado | 8053 | 106 | 0 |
2135419 | 2135419 | 2022-01-21 | Hinsdale | Colorado | 8053 | 106 | 0 |
2132167 | 2132167 | 2022-01-20 | Hinsdale | Colorado | 8053 | 106 | 0 |
2128914 | 2128914 | 2022-01-19 | Hinsdale | Colorado | 8053 | 106 | 0 |
2028163 | 2028163 | 2021-12-19 | San Juan | Colorado | 8111 | 106 | 0 |
2024912 | 2024912 | 2021-12-18 | San Juan | Colorado | 8111 | 106 | 0 |
2021661 | 2021661 | 2021-12-17 | San Juan | Colorado | 8111 | 106 | 0 |
2018410 | 2018410 | 2021-12-16 | San Juan | Colorado | 8111 | 106 | 0 |
1992404 | 1992404 | 2021-12-08 | San Juan | Colorado | 8111 | 106 | 0 |
1989153 | 1989153 | 2021-12-07 | San Juan | Colorado | 8111 | 106 | 0 |
1966404 | 1966404 | 2021-11-30 | San Juan | Colorado | 8111 | 106 | 0 |
1963152 | 1963152 | 2021-11-29 | San Juan | Colorado | 8111 | 106 | 0 |
1959901 | 1959901 | 2021-11-28 | San Juan | Colorado | 8111 | 106 | 0 |
1956650 | 1956650 | 2021-11-27 | San Juan | Colorado | 8111 | 106 | 0 |
1953399 | 1953399 | 2021-11-26 | San Juan | Colorado | 8111 | 106 | 0 |
1950148 | 1950148 | 2021-11-25 | San Juan | Colorado | 8111 | 106 | 0 |
1946897 | 1946897 | 2021-11-24 | San Juan | Colorado | 8111 | 106 | 0 |
1829884 | 1829884 | 2021-10-19 | Jackson | Colorado | 8057 | 106 | 0 |
1735673 | 1735673 | 2021-09-20 | Mineral | Colorado | 8079 | 106 | 1 |
936917 | 936917 | 2021-01-17 | Cheyenne | Colorado | 8017 | 106 | 5 |
933672 | 933672 | 2021-01-16 | Cheyenne | Colorado | 8017 | 106 | 5 |
930427 | 930427 | 2021-01-15 | Cheyenne | Colorado | 8017 | 106 | 5 |
927182 | 927182 | 2021-01-14 | Cheyenne | Colorado | 8017 | 106 | 5 |
923936 | 923936 | 2021-01-13 | Cheyenne | Colorado | 8017 | 106 | 5 |
836330 | 836330 | 2020-12-17 | Gilpin | Colorado | 8047 | 106 | 1 |
781138 | 781138 | 2020-11-30 | Baca | Colorado | 8009 | 106 | 0 |
768211 | 768211 | 2020-11-26 | Sedgwick | Colorado | 8115 | 106 | 1 |
738941 | 738941 | 2020-11-17 | Archuleta | Colorado | 8007 | 106 | 0 |
687100 | 687100 | 2020-11-01 | Washington | Colorado | 8121 | 106 | 0 |
683856 | 683856 | 2020-10-31 | Washington | Colorado | 8121 | 106 | 0 |
680599 | 680599 | 2020-10-30 | Park | Colorado | 8093 | 106 | 1 |
622206 | 622206 | 2020-10-12 | Rio Grande | Colorado | 8105 | 106 | 2 |
605967 | 605967 | 2020-10-07 | Grand | Colorado | 8049 | 106 | 1 |
593017 | 593017 | 2020-10-03 | Otero | Colorado | 8089 | 106 | 6 |
437762 | 437762 | 2020-08-16 | Saguache | Colorado | 8109 | 106 | 2 |
434536 | 434536 | 2020-08-15 | Saguache | Colorado | 8109 | 106 | 2 |
431311 | 431311 | 2020-08-14 | Saguache | Colorado | 8109 | 106 | 2 |
428083 | 428083 | 2020-08-13 | Saguache | Colorado | 8109 | 106 | 2 |
424859 | 424859 | 2020-08-12 | Saguache | Colorado | 8109 | 106 | 2 |
421638 | 421638 | 2020-08-11 | Saguache | Colorado | 8109 | 106 | 2 |
418417 | 418417 | 2020-08-10 | Saguache | Colorado | 8109 | 106 | 2 |
415196 | 415196 | 2020-08-09 | Saguache | Colorado | 8109 | 106 | 2 |
411976 | 411976 | 2020-08-08 | Saguache | Colorado | 8109 | 106 | 2 |
408757 | 408757 | 2020-08-07 | Saguache | Colorado | 8109 | 106 | 2 |
405537 | 405537 | 2020-08-06 | Saguache | Colorado | 8109 | 106 | 2 |
402319 | 402319 | 2020-08-05 | Saguache | Colorado | 8109 | 106 | 2 |
389453 | 389453 | 2020-08-01 | Routt | Colorado | 8107 | 106 | 6 |
379807 | 379807 | 2020-07-29 | Teller | Colorado | 8119 | 106 | 2 |
360535 | 360535 | 2020-07-23 | Saguache | Colorado | 8109 | 106 | 2 |
357330 | 357330 | 2020-07-22 | Saguache | Colorado | 8109 | 106 | 2 |
354127 | 354127 | 2020-07-21 | Saguache | Colorado | 8109 | 106 | 2 |
350925 | 350925 | 2020-07-20 | Saguache | Colorado | 8109 | 106 | 2 |
347724 | 347724 | 2020-07-19 | Saguache | Colorado | 8109 | 106 | 2 |
284203 | 284203 | 2020-06-29 | La Plata | Colorado | 8067 | 106 | 1 |
112741 | 112741 | 2020-05-04 | Montrose | Colorado | 8085 | 106 | 11 |
92764 | 92764 | 2020-04-27 | Summit | Colorado | 8117 | 106 | 2 |
75898 | 75898 | 2020-04-21 | Broomfield | Colorado | 8014 | 106 | 2 |
9616 | 9616 | 2020-03-24 | El Paso | Colorado | 8041 | 106 | 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);