ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
49 rows where deaths = 95 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 11
state 1
- Colorado · 49 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2057363 | 2057363 | 2021-12-28 | Broomfield | Colorado | 8014 | 8419 | 95 |
2054145 | 2054145 | 2021-12-27 | Logan | Colorado | 8075 | 5281 | 95 |
2050895 | 2050895 | 2021-12-26 | Logan | Colorado | 8075 | 5259 | 95 |
2047645 | 2047645 | 2021-12-25 | Logan | Colorado | 8075 | 5259 | 95 |
2044395 | 2044395 | 2021-12-24 | Logan | Colorado | 8075 | 5259 | 95 |
2041115 | 2041115 | 2021-12-23 | Broomfield | Colorado | 8014 | 8142 | 95 |
2041146 | 2041146 | 2021-12-23 | Logan | Colorado | 8075 | 5254 | 95 |
2037865 | 2037865 | 2021-12-22 | Broomfield | Colorado | 8014 | 8108 | 95 |
2037896 | 2037896 | 2021-12-22 | Logan | Colorado | 8075 | 5247 | 95 |
2034615 | 2034615 | 2021-12-21 | Broomfield | Colorado | 8014 | 8062 | 95 |
2034646 | 2034646 | 2021-12-21 | Logan | Colorado | 8075 | 5236 | 95 |
2031396 | 2031396 | 2021-12-20 | Logan | Colorado | 8075 | 5233 | 95 |
2028145 | 2028145 | 2021-12-19 | Logan | Colorado | 8075 | 5228 | 95 |
2024894 | 2024894 | 2021-12-18 | Logan | Colorado | 8075 | 5228 | 95 |
2021643 | 2021643 | 2021-12-17 | Logan | Colorado | 8075 | 5228 | 95 |
2018392 | 2018392 | 2021-12-16 | Logan | Colorado | 8075 | 5223 | 95 |
2015142 | 2015142 | 2021-12-15 | Logan | Colorado | 8075 | 5218 | 95 |
2011891 | 2011891 | 2021-12-14 | Logan | Colorado | 8075 | 5198 | 95 |
2008640 | 2008640 | 2021-12-13 | Logan | Colorado | 8075 | 5196 | 95 |
1966393 | 1966393 | 2021-11-30 | Otero | Colorado | 8089 | 3189 | 95 |
1963141 | 1963141 | 2021-11-29 | Otero | Colorado | 8089 | 3177 | 95 |
1940355 | 1940355 | 2021-11-22 | Delta | Colorado | 8029 | 4474 | 95 |
1937105 | 1937105 | 2021-11-21 | Delta | Colorado | 8029 | 4467 | 95 |
1933855 | 1933855 | 2021-11-20 | Delta | Colorado | 8029 | 4467 | 95 |
1930603 | 1930603 | 2021-11-19 | Delta | Colorado | 8029 | 4467 | 95 |
1927353 | 1927353 | 2021-11-18 | Delta | Colorado | 8029 | 4442 | 95 |
1924103 | 1924103 | 2021-11-17 | Delta | Colorado | 8029 | 4414 | 95 |
1920854 | 1920854 | 2021-11-16 | Delta | Colorado | 8029 | 4394 | 95 |
1914382 | 1914382 | 2021-11-14 | Montrose | Colorado | 8085 | 6193 | 95 |
1911132 | 1911132 | 2021-11-13 | Montrose | Colorado | 8085 | 6193 | 95 |
1907883 | 1907883 | 2021-11-12 | Montrose | Colorado | 8085 | 6193 | 95 |
1872117 | 1872117 | 2021-11-01 | Fremont | Colorado | 8043 | 8776 | 95 |
1417418 | 1417418 | 2021-06-14 | Morgan | Colorado | 8087 | 2720 | 95 |
1414172 | 1414172 | 2021-06-13 | Morgan | Colorado | 8087 | 2719 | 95 |
1410927 | 1410927 | 2021-06-12 | Morgan | Colorado | 8087 | 2719 | 95 |
1407682 | 1407682 | 2021-06-11 | Morgan | Colorado | 8087 | 2718 | 95 |
1404436 | 1404436 | 2021-06-10 | Morgan | Colorado | 8087 | 2718 | 95 |
1401191 | 1401191 | 2021-06-09 | Morgan | Colorado | 8087 | 2718 | 95 |
1397946 | 1397946 | 2021-06-08 | Morgan | Colorado | 8087 | 2717 | 95 |
1394699 | 1394699 | 2021-06-07 | Morgan | Colorado | 8087 | 2716 | 95 |
1391454 | 1391454 | 2021-06-06 | Morgan | Colorado | 8087 | 2716 | 95 |
1388209 | 1388209 | 2021-06-05 | Morgan | Colorado | 8087 | 2715 | 95 |
1384964 | 1384964 | 2021-06-04 | Morgan | Colorado | 8087 | 2714 | 95 |
1381718 | 1381718 | 2021-06-03 | Morgan | Colorado | 8087 | 2711 | 95 |
826602 | 826602 | 2020-12-14 | Larimer | Colorado | 8069 | 13069 | 95 |
823355 | 823355 | 2020-12-13 | Larimer | Colorado | 8069 | 13069 | 95 |
700019 | 700019 | 2020-11-05 | Boulder | Colorado | 8013 | 6590 | 95 |
200177 | 200177 | 2020-06-02 | El Paso | Colorado | 8041 | 1761 | 95 |
101295 | 101295 | 2020-04-30 | Weld | Colorado | 8123 | 1776 | 95 |
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);