ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
27 rows where cases = 136 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2132169 | 2132169 | 2022-01-20 | Jackson | Colorado | 8057 | 136 | 0 |
1621954 | 1621954 | 2021-08-16 | Dolores | Colorado | 8033 | 136 | 1 |
1618707 | 1618707 | 2021-08-15 | Dolores | Colorado | 8033 | 136 | 1 |
1615459 | 1615459 | 2021-08-14 | Dolores | Colorado | 8033 | 136 | 1 |
1612210 | 1612210 | 2021-08-13 | Dolores | Colorado | 8033 | 136 | 1 |
1608962 | 1608962 | 2021-08-12 | Dolores | Colorado | 8033 | 136 | 1 |
927197 | 927197 | 2021-01-14 | Gilpin | Colorado | 8047 | 136 | 2 |
923951 | 923951 | 2021-01-13 | Gilpin | Colorado | 8047 | 136 | 2 |
891532 | 891532 | 2021-01-03 | Sedgwick | Colorado | 8115 | 136 | 2 |
771435 | 771435 | 2020-11-27 | Lincoln | Colorado | 8073 | 136 | 0 |
719535 | 719535 | 2020-11-11 | Washington | Colorado | 8121 | 136 | 1 |
567086 | 567086 | 2020-09-25 | Montezuma | Colorado | 8083 | 136 | 5 |
524980 | 524980 | 2020-09-12 | Elbert | Colorado | 8039 | 136 | 2 |
521744 | 521744 | 2020-09-11 | Elbert | Colorado | 8039 | 136 | 2 |
521776 | 521776 | 2020-09-11 | Routt | Colorado | 8107 | 136 | 8 |
434504 | 434504 | 2020-08-15 | Fremont | Colorado | 8043 | 136 | 0 |
421643 | 421643 | 2020-08-11 | Teller | Colorado | 8119 | 136 | 3 |
328532 | 328532 | 2020-07-13 | La Plata | Colorado | 8067 | 136 | 1 |
325346 | 325346 | 2020-07-12 | La Plata | Colorado | 8067 | 136 | 1 |
160542 | 160542 | 2020-05-20 | Montrose | Colorado | 8085 | 136 | 11 |
157516 | 157516 | 2020-05-19 | Montrose | Colorado | 8085 | 136 | 11 |
154500 | 154500 | 2020-05-18 | Montrose | Colorado | 8085 | 136 | 11 |
151488 | 151488 | 2020-05-17 | Montrose | Colorado | 8085 | 136 | 11 |
107011 | 107011 | 2020-05-02 | Summit | Colorado | 8117 | 136 | 2 |
98435 | 98435 | 2020-04-29 | Pueblo | Colorado | 8101 | 136 | 10 |
95590 | 95590 | 2020-04-28 | Pueblo | Colorado | 8101 | 136 | 9 |
14228 | 14228 | 2020-03-27 | Unknown | Colorado | 136 | 1 |
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);