ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
49 rows where cases = 121 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2291537 | 2291537 | 2022-03-10 | Hinsdale | Colorado | 8053 | 121 | 0 |
2288285 | 2288285 | 2022-03-09 | Hinsdale | Colorado | 8053 | 121 | 0 |
2285034 | 2285034 | 2022-03-08 | Hinsdale | Colorado | 8053 | 121 | 0 |
2281782 | 2281782 | 2022-03-07 | Hinsdale | Colorado | 8053 | 121 | 0 |
2278529 | 2278529 | 2022-03-06 | Hinsdale | Colorado | 8053 | 121 | 0 |
2275276 | 2275276 | 2022-03-05 | Hinsdale | Colorado | 8053 | 121 | 0 |
2272023 | 2272023 | 2022-03-04 | Hinsdale | Colorado | 8053 | 121 | 0 |
2268771 | 2268771 | 2022-03-03 | Hinsdale | Colorado | 8053 | 121 | 0 |
2265518 | 2265518 | 2022-03-02 | Hinsdale | Colorado | 8053 | 121 | 0 |
2073664 | 2073664 | 2022-01-02 | San Juan | Colorado | 8111 | 121 | 0 |
2070413 | 2070413 | 2022-01-01 | San Juan | Colorado | 8111 | 121 | 0 |
2067162 | 2067162 | 2021-12-31 | San Juan | Colorado | 8111 | 121 | 0 |
2063911 | 2063911 | 2021-12-30 | San Juan | Colorado | 8111 | 121 | 0 |
1943619 | 1943619 | 2021-11-23 | Jackson | Colorado | 8057 | 121 | 0 |
1787658 | 1787658 | 2021-10-06 | Mineral | Colorado | 8079 | 121 | 1 |
1764903 | 1764903 | 2021-09-29 | Kiowa | Colorado | 8061 | 121 | 4 |
1410900 | 1410900 | 2021-06-12 | Dolores | Colorado | 8033 | 121 | 1 |
988845 | 988845 | 2021-02-02 | Cheyenne | Colorado | 8017 | 121 | 5 |
985598 | 985598 | 2021-02-01 | Cheyenne | Colorado | 8017 | 121 | 5 |
875271 | 875271 | 2020-12-29 | Gilpin | Colorado | 8047 | 121 | 1 |
872026 | 872026 | 2020-12-28 | Gilpin | Colorado | 8047 | 121 | 1 |
868781 | 868781 | 2020-12-27 | Gilpin | Colorado | 8047 | 121 | 1 |
865536 | 865536 | 2020-12-26 | Gilpin | Colorado | 8047 | 121 | 1 |
862291 | 862291 | 2020-12-25 | Gilpin | Colorado | 8047 | 121 | 1 |
761690 | 761690 | 2020-11-24 | Huerfano | Colorado | 8055 | 121 | 4 |
667634 | 667634 | 2020-10-26 | Rio Grande | Colorado | 8105 | 121 | 3 |
648148 | 648148 | 2020-10-20 | Lake | Colorado | 8065 | 121 | 0 |
489406 | 489406 | 2020-09-01 | Elbert | Colorado | 8039 | 121 | 2 |
486173 | 486173 | 2020-08-31 | Elbert | Colorado | 8039 | 121 | 2 |
482938 | 482938 | 2020-08-30 | Elbert | Colorado | 8039 | 121 | 2 |
479704 | 479704 | 2020-08-29 | Elbert | Colorado | 8039 | 121 | 2 |
463568 | 463568 | 2020-08-24 | Montezuma | Colorado | 8083 | 121 | 5 |
460339 | 460339 | 2020-08-23 | Montezuma | Colorado | 8083 | 121 | 5 |
457112 | 457112 | 2020-08-22 | Montezuma | Colorado | 8083 | 121 | 5 |
453884 | 453884 | 2020-08-21 | Montezuma | Colorado | 8083 | 121 | 5 |
415157 | 415157 | 2020-08-09 | Delta | Colorado | 8029 | 121 | 1 |
411937 | 411937 | 2020-08-08 | Delta | Colorado | 8029 | 121 | 1 |
402324 | 402324 | 2020-08-05 | Teller | Colorado | 8119 | 121 | 3 |
328509 | 328509 | 2020-07-13 | Chaffee | Colorado | 8015 | 121 | 19 |
309474 | 309474 | 2020-07-07 | Mesa | Colorado | 8077 | 121 | 0 |
299972 | 299972 | 2020-07-04 | La Plata | Colorado | 8067 | 121 | 1 |
172663 | 172663 | 2020-05-24 | Garfield | Colorado | 8045 | 121 | 2 |
124532 | 124532 | 2020-05-08 | Montrose | Colorado | 8085 | 121 | 11 |
98441 | 98441 | 2020-04-29 | Summit | Colorado | 8117 | 121 | 2 |
87123 | 87123 | 2020-04-25 | Pueblo | Colorado | 8101 | 121 | 9 |
81492 | 81492 | 2020-04-23 | Gunnison | Colorado | 8051 | 121 | 4 |
78698 | 78698 | 2020-04-22 | Gunnison | Colorado | 8051 | 121 | 4 |
75914 | 75914 | 2020-04-21 | Gunnison | Colorado | 8051 | 121 | 3 |
19851 | 19851 | 2020-03-30 | Douglas | Colorado | 8035 | 121 | 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);