ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
48 rows where cases = 162 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2255767 | 2255767 | 2022-02-27 | Jackson | Colorado | 8057 | 162 | 0 |
2252516 | 2252516 | 2022-02-26 | Jackson | Colorado | 8057 | 162 | 0 |
2249265 | 2249265 | 2022-02-25 | Jackson | Colorado | 8057 | 162 | 0 |
2246014 | 2246014 | 2022-02-24 | Jackson | Colorado | 8057 | 162 | 0 |
2242763 | 2242763 | 2022-02-23 | Jackson | Colorado | 8057 | 162 | 0 |
2239512 | 2239512 | 2022-02-22 | Jackson | Colorado | 8057 | 162 | 0 |
2236261 | 2236261 | 2022-02-21 | Jackson | Colorado | 8057 | 162 | 0 |
2233010 | 2233010 | 2022-02-20 | Jackson | Colorado | 8057 | 162 | 0 |
2229759 | 2229759 | 2022-02-19 | Jackson | Colorado | 8057 | 162 | 0 |
2226508 | 2226508 | 2022-02-18 | Jackson | Colorado | 8057 | 162 | 0 |
2223257 | 2223257 | 2022-02-17 | Jackson | Colorado | 8057 | 162 | 0 |
2220006 | 2220006 | 2022-02-16 | Jackson | Colorado | 8057 | 162 | 0 |
1800622 | 1800622 | 2021-10-10 | Cheyenne | Colorado | 8017 | 162 | 7 |
1797373 | 1797373 | 2021-10-09 | Cheyenne | Colorado | 8017 | 162 | 7 |
1794124 | 1794124 | 2021-10-08 | Cheyenne | Colorado | 8017 | 162 | 7 |
1790876 | 1790876 | 2021-10-07 | Cheyenne | Colorado | 8017 | 162 | 7 |
1787627 | 1787627 | 2021-10-06 | Cheyenne | Colorado | 8017 | 162 | 7 |
1784378 | 1784378 | 2021-10-05 | Cheyenne | Colorado | 8017 | 162 | 7 |
1037545 | 1037545 | 2021-02-17 | Gilpin | Colorado | 8047 | 162 | 3 |
1034300 | 1034300 | 2021-02-16 | Gilpin | Colorado | 8047 | 162 | 3 |
1031054 | 1031054 | 2021-02-15 | Gilpin | Colorado | 8047 | 162 | 3 |
1027807 | 1027807 | 2021-02-14 | Gilpin | Colorado | 8047 | 162 | 3 |
1024562 | 1024562 | 2021-02-13 | Gilpin | Colorado | 8047 | 162 | 3 |
1014817 | 1014817 | 2021-02-10 | Custer | Colorado | 8027 | 162 | 1 |
1011572 | 1011572 | 2021-02-09 | Custer | Colorado | 8027 | 162 | 1 |
1008326 | 1008326 | 2021-02-08 | Custer | Colorado | 8027 | 162 | 1 |
1005080 | 1005080 | 2021-02-07 | Custer | Colorado | 8027 | 162 | 1 |
842800 | 842800 | 2020-12-19 | Baca | Colorado | 8009 | 162 | 0 |
839555 | 839555 | 2020-12-18 | Baca | Colorado | 8009 | 162 | 0 |
836310 | 836310 | 2020-12-17 | Baca | Colorado | 8009 | 162 | 0 |
726013 | 726013 | 2020-11-13 | Rio Grande | Colorado | 8105 | 162 | 4 |
706533 | 706533 | 2020-11-07 | Lake | Colorado | 8065 | 162 | 0 |
696794 | 696794 | 2020-11-04 | Grand | Colorado | 8049 | 162 | 1 |
693552 | 693552 | 2020-11-03 | Grand | Colorado | 8049 | 162 | 1 |
583272 | 583272 | 2020-09-30 | Elbert | Colorado | 8039 | 162 | 3 |
505575 | 505575 | 2020-09-06 | Fremont | Colorado | 8043 | 162 | 0 |
502341 | 502341 | 2020-09-05 | Fremont | Colorado | 8043 | 162 | 0 |
499107 | 499107 | 2020-09-04 | Fremont | Colorado | 8043 | 162 | 0 |
492677 | 492677 | 2020-09-02 | Teller | Colorado | 8119 | 162 | 4 |
489444 | 489444 | 2020-09-01 | Teller | Colorado | 8119 | 162 | 3 |
486211 | 486211 | 2020-08-31 | Teller | Colorado | 8119 | 162 | 3 |
482932 | 482932 | 2020-08-30 | Delta | Colorado | 8029 | 162 | 2 |
482976 | 482976 | 2020-08-30 | Teller | Colorado | 8119 | 162 | 3 |
383013 | 383013 | 2020-07-30 | Pitkin | Colorado | 8097 | 162 | 2 |
357324 | 357324 | 2020-07-22 | Pitkin | Colorado | 8097 | 162 | 2 |
334917 | 334917 | 2020-07-15 | Mesa | Colorado | 8077 | 162 | 0 |
215589 | 215589 | 2020-06-07 | Garfield | Colorado | 8045 | 162 | 2 |
127533 | 127533 | 2020-05-09 | Summit | Colorado | 8117 | 162 | 2 |
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);