ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
66 rows where cases = 55 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1836380 | 1836380 | 2021-10-21 | Hinsdale | Colorado | 8053 | 55 | 0 |
1833131 | 1833131 | 2021-10-20 | Hinsdale | Colorado | 8053 | 55 | 0 |
1829882 | 1829882 | 2021-10-19 | Hinsdale | Colorado | 8053 | 55 | 0 |
1826633 | 1826633 | 2021-10-18 | Hinsdale | Colorado | 8053 | 55 | 0 |
1596005 | 1596005 | 2021-08-08 | San Juan | Colorado | 8111 | 55 | 0 |
1592756 | 1592756 | 2021-08-07 | San Juan | Colorado | 8111 | 55 | 0 |
1589507 | 1589507 | 2021-08-06 | San Juan | Colorado | 8111 | 55 | 0 |
949931 | 949931 | 2021-01-21 | Mineral | Colorado | 8079 | 55 | 1 |
946685 | 946685 | 2021-01-20 | Mineral | Colorado | 8079 | 55 | 1 |
943415 | 943415 | 2021-01-19 | Dolores | Colorado | 8033 | 55 | 0 |
940170 | 940170 | 2021-01-18 | Dolores | Colorado | 8033 | 55 | 0 |
936925 | 936925 | 2021-01-17 | Dolores | Colorado | 8033 | 55 | 0 |
933680 | 933680 | 2021-01-16 | Dolores | Colorado | 8033 | 55 | 0 |
930435 | 930435 | 2021-01-15 | Dolores | Colorado | 8033 | 55 | 0 |
927190 | 927190 | 2021-01-14 | Dolores | Colorado | 8033 | 55 | 0 |
923944 | 923944 | 2021-01-13 | Dolores | Colorado | 8033 | 55 | 0 |
920699 | 920699 | 2021-01-12 | Dolores | Colorado | 8033 | 55 | 0 |
917454 | 917454 | 2021-01-11 | Dolores | Colorado | 8033 | 55 | 0 |
914209 | 914209 | 2021-01-10 | Dolores | Colorado | 8033 | 55 | 0 |
829844 | 829844 | 2020-12-15 | Kiowa | Colorado | 8061 | 55 | 1 |
764916 | 764916 | 2020-11-25 | Cheyenne | Colorado | 8017 | 55 | 0 |
751938 | 751938 | 2020-11-21 | Custer | Colorado | 8027 | 55 | 0 |
748692 | 748692 | 2020-11-20 | Custer | Colorado | 8027 | 55 | 0 |
674114 | 674114 | 2020-10-28 | Phillips | Colorado | 8095 | 55 | 0 |
648155 | 648155 | 2020-10-20 | Moffat | Colorado | 8081 | 55 | 1 |
596217 | 596217 | 2020-10-04 | Archuleta | Colorado | 8007 | 55 | 0 |
592975 | 592975 | 2020-10-03 | Archuleta | Colorado | 8007 | 55 | 0 |
589735 | 589735 | 2020-10-02 | Archuleta | Colorado | 8007 | 55 | 0 |
563807 | 563807 | 2020-09-24 | Archuleta | Colorado | 8007 | 55 | 0 |
563851 | 563851 | 2020-09-24 | Park | Colorado | 8093 | 55 | 1 |
560568 | 560568 | 2020-09-23 | Archuleta | Colorado | 8007 | 55 | 0 |
560611 | 560611 | 2020-09-23 | Park | Colorado | 8093 | 55 | 1 |
531492 | 531492 | 2020-09-14 | Washington | Colorado | 8121 | 55 | 0 |
525019 | 525019 | 2020-09-12 | Washington | Colorado | 8121 | 55 | 0 |
521783 | 521783 | 2020-09-11 | Washington | Colorado | 8121 | 55 | 0 |
444185 | 444185 | 2020-08-18 | Grand | Colorado | 8049 | 55 | 1 |
344532 | 344532 | 2020-07-18 | Yuma | Colorado | 8125 | 55 | 0 |
341333 | 341333 | 2020-07-17 | Yuma | Colorado | 8125 | 55 | 0 |
338136 | 338136 | 2020-07-16 | Yuma | Colorado | 8125 | 55 | 0 |
334941 | 334941 | 2020-07-15 | Yuma | Colorado | 8125 | 55 | 0 |
271611 | 271611 | 2020-06-25 | Elbert | Colorado | 8039 | 55 | 2 |
243535 | 243535 | 2020-06-16 | Rio Grande | Colorado | 8105 | 55 | 0 |
200194 | 200194 | 2020-06-02 | Mesa | Colorado | 8077 | 55 | 0 |
197121 | 197121 | 2020-06-01 | Mesa | Colorado | 8077 | 55 | 0 |
187919 | 187919 | 2020-05-29 | Mesa | Colorado | 8077 | 55 | 0 |
184863 | 184863 | 2020-05-28 | Mesa | Colorado | 8077 | 55 | 0 |
181809 | 181809 | 2020-05-27 | Mesa | Colorado | 8077 | 55 | 0 |
178765 | 178765 | 2020-05-26 | Mesa | Colorado | 8077 | 55 | 0 |
175721 | 175721 | 2020-05-25 | Mesa | Colorado | 8077 | 55 | 0 |
172677 | 172677 | 2020-05-24 | Mesa | Colorado | 8077 | 55 | 0 |
169601 | 169601 | 2020-05-23 | Alamosa | Colorado | 8003 | 55 | 2 |
160517 | 160517 | 2020-05-20 | Delta | Colorado | 8029 | 55 | 1 |
157491 | 157491 | 2020-05-19 | Delta | Colorado | 8029 | 55 | 1 |
154475 | 154475 | 2020-05-18 | Delta | Colorado | 8029 | 55 | 1 |
151463 | 151463 | 2020-05-17 | Delta | Colorado | 8029 | 55 | 1 |
148454 | 148454 | 2020-05-16 | Delta | Colorado | 8029 | 55 | 1 |
136464 | 136464 | 2020-05-12 | Delta | Colorado | 8029 | 55 | 1 |
133475 | 133475 | 2020-05-11 | Delta | Colorado | 8029 | 55 | 1 |
130484 | 130484 | 2020-05-10 | Delta | Colorado | 8029 | 55 | 1 |
104143 | 104143 | 2020-05-01 | Routt | Colorado | 8107 | 55 | 5 |
95593 | 95593 | 2020-04-28 | Routt | Colorado | 8107 | 55 | 4 |
81477 | 81477 | 2020-04-23 | Chaffee | Colorado | 8015 | 55 | 9 |
81497 | 81497 | 2020-04-23 | La Plata | Colorado | 8067 | 55 | 0 |
78683 | 78683 | 2020-04-22 | Chaffee | Colorado | 8015 | 55 | 9 |
51325 | 51325 | 2020-04-12 | Garfield | Colorado | 8045 | 55 | 2 |
8379 | 8379 | 2020-03-23 | Jefferson | Colorado | 8059 | 55 | 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);