ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40 rows where "date" is on date 2020-03-26 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
12523 | 12523 | 2020-03-26 | Adams | Colorado | 8001 | 50 | 0 |
12524 | 12524 | 2020-03-26 | Arapahoe | Colorado | 8005 | 119 | 1 |
12525 | 12525 | 2020-03-26 | Boulder | Colorado | 8013 | 66 | 0 |
12526 | 12526 | 2020-03-26 | Broomfield | Colorado | 8014 | 10 | 0 |
12527 | 12527 | 2020-03-26 | Chaffee | Colorado | 8015 | 5 | 1 |
12528 | 12528 | 2020-03-26 | Clear Creek | Colorado | 8019 | 3 | 0 |
12529 | 12529 | 2020-03-26 | Crowley | Colorado | 8025 | 1 | 1 |
12530 | 12530 | 2020-03-26 | Delta | Colorado | 8029 | 1 | 0 |
12531 | 12531 | 2020-03-26 | Denver | Colorado | 8031 | 262 | 3 |
12532 | 12532 | 2020-03-26 | Douglas | Colorado | 8035 | 67 | 0 |
12533 | 12533 | 2020-03-26 | Eagle | Colorado | 8037 | 147 | 1 |
12534 | 12534 | 2020-03-26 | El Paso | Colorado | 8041 | 137 | 7 |
12535 | 12535 | 2020-03-26 | Elbert | Colorado | 8039 | 3 | 0 |
12536 | 12536 | 2020-03-26 | Fremont | Colorado | 8043 | 1 | 0 |
12537 | 12537 | 2020-03-26 | Garfield | Colorado | 8045 | 16 | 0 |
12538 | 12538 | 2020-03-26 | Grand | Colorado | 8049 | 2 | 0 |
12539 | 12539 | 2020-03-26 | Gunnison | Colorado | 8051 | 57 | 1 |
12540 | 12540 | 2020-03-26 | Hinsdale | Colorado | 8053 | 1 | 0 |
12541 | 12541 | 2020-03-26 | Huerfano | Colorado | 8055 | 1 | 0 |
12542 | 12542 | 2020-03-26 | Jefferson | Colorado | 8059 | 131 | 3 |
12543 | 12543 | 2020-03-26 | Kit Carson | Colorado | 8063 | 1 | 0 |
12544 | 12544 | 2020-03-26 | La Plata | Colorado | 8067 | 5 | 0 |
12545 | 12545 | 2020-03-26 | Larimer | Colorado | 8069 | 61 | 1 |
12546 | 12546 | 2020-03-26 | Logan | Colorado | 8075 | 2 | 0 |
12547 | 12547 | 2020-03-26 | Mesa | Colorado | 8077 | 6 | 0 |
12548 | 12548 | 2020-03-26 | Montrose | Colorado | 8085 | 4 | 0 |
12549 | 12549 | 2020-03-26 | Morgan | Colorado | 8087 | 3 | 0 |
12550 | 12550 | 2020-03-26 | Otero | Colorado | 8089 | 1 | 0 |
12551 | 12551 | 2020-03-26 | Park | Colorado | 8093 | 1 | 0 |
12552 | 12552 | 2020-03-26 | Pitkin | Colorado | 8097 | 23 | 0 |
12553 | 12553 | 2020-03-26 | Pueblo | Colorado | 8101 | 5 | 0 |
12554 | 12554 | 2020-03-26 | Rio Grande | Colorado | 8105 | 2 | 0 |
12555 | 12555 | 2020-03-26 | Routt | Colorado | 8107 | 9 | 0 |
12556 | 12556 | 2020-03-26 | San Miguel | Colorado | 8113 | 1 | 0 |
12557 | 12557 | 2020-03-26 | Summit | Colorado | 8117 | 9 | 0 |
12558 | 12558 | 2020-03-26 | Teller | Colorado | 8119 | 7 | 1 |
12559 | 12559 | 2020-03-26 | Unknown | Colorado | 102 | 0 | |
12560 | 12560 | 2020-03-26 | Washington | Colorado | 8121 | 1 | 0 |
12561 | 12561 | 2020-03-26 | Weld | Colorado | 8123 | 107 | 4 |
12562 | 12562 | 2020-03-26 | Yuma | Colorado | 8125 | 2 | 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);