ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where date = "2021-04-27" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1261553 | 1261553 | 2021-04-27 | Adams | Colorado | 8001 | 56578 | 699 |
1261554 | 1261554 | 2021-04-27 | Alamosa | Colorado | 8003 | 1438 | 30 |
1261555 | 1261555 | 2021-04-27 | Arapahoe | Colorado | 8005 | 58115 | 771 |
1261556 | 1261556 | 2021-04-27 | Archuleta | Colorado | 8007 | 892 | 1 |
1261557 | 1261557 | 2021-04-27 | Baca | Colorado | 8009 | 280 | 4 |
1261558 | 1261558 | 2021-04-27 | Bent | Colorado | 8011 | 1513 | 21 |
1261559 | 1261559 | 2021-04-27 | Boulder | Colorado | 8013 | 22764 | 253 |
1261560 | 1261560 | 2021-04-27 | Broomfield | Colorado | 8014 | 4621 | 75 |
1261561 | 1261561 | 2021-04-27 | Chaffee | Colorado | 8015 | 1601 | 25 |
1261562 | 1261562 | 2021-04-27 | Cheyenne | Colorado | 8017 | 128 | 6 |
1261563 | 1261563 | 2021-04-27 | Clear Creek | Colorado | 8019 | 433 | 3 |
1261564 | 1261564 | 2021-04-27 | Conejos | Colorado | 8021 | 499 | 10 |
1261565 | 1261565 | 2021-04-27 | Costilla | Colorado | 8023 | 207 | 2 |
1261566 | 1261566 | 2021-04-27 | Crowley | Colorado | 8025 | 2161 | 15 |
1261567 | 1261567 | 2021-04-27 | Custer | Colorado | 8027 | 188 | 1 |
1261568 | 1261568 | 2021-04-27 | Delta | Colorado | 8029 | 2660 | 61 |
1261569 | 1261569 | 2021-04-27 | Denver | Colorado | 8031 | 69820 | 800 |
1261570 | 1261570 | 2021-04-27 | Dolores | Colorado | 8033 | 77 | 0 |
1261571 | 1261571 | 2021-04-27 | Douglas | Colorado | 8035 | 27976 | 252 |
1261572 | 1261572 | 2021-04-27 | Eagle | Colorado | 8037 | 6176 | 22 |
1261573 | 1261573 | 2021-04-27 | El Paso | Colorado | 8041 | 62982 | 783 |
1261574 | 1261574 | 2021-04-27 | Elbert | Colorado | 8039 | 1641 | 13 |
1261575 | 1261575 | 2021-04-27 | Fremont | Colorado | 8043 | 5960 | 55 |
1261576 | 1261576 | 2021-04-27 | Garfield | Colorado | 8045 | 5730 | 38 |
1261577 | 1261577 | 2021-04-27 | Gilpin | Colorado | 8047 | 220 | 3 |
1261578 | 1261578 | 2021-04-27 | Grand | Colorado | 8049 | 1440 | 7 |
1261579 | 1261579 | 2021-04-27 | Gunnison | Colorado | 8051 | 1317 | 6 |
1261580 | 1261580 | 2021-04-27 | Hinsdale | Colorado | 8053 | 19 | 0 |
1261581 | 1261581 | 2021-04-27 | Huerfano | Colorado | 8055 | 372 | 17 |
1261582 | 1261582 | 2021-04-27 | Jackson | Colorado | 8057 | 56 | 0 |
1261583 | 1261583 | 2021-04-27 | Jefferson | Colorado | 8059 | 44558 | 748 |
1261584 | 1261584 | 2021-04-27 | Kiowa | Colorado | 8061 | 93 | 3 |
1261585 | 1261585 | 2021-04-27 | Kit Carson | Colorado | 8063 | 601 | 11 |
1261586 | 1261586 | 2021-04-27 | La Plata | Colorado | 8067 | 3782 | 39 |
1261587 | 1261587 | 2021-04-27 | Lake | Colorado | 8065 | 769 | 0 |
1261588 | 1261588 | 2021-04-27 | Larimer | Colorado | 8069 | 25127 | 232 |
1261589 | 1261589 | 2021-04-27 | Las Animas | Colorado | 8071 | 1097 | 11 |
1261590 | 1261590 | 2021-04-27 | Lincoln | Colorado | 8073 | 1016 | 4 |
1261591 | 1261591 | 2021-04-27 | Logan | Colorado | 8075 | 3922 | 67 |
1261592 | 1261592 | 2021-04-27 | Mesa | Colorado | 8077 | 14228 | 210 |
1261593 | 1261593 | 2021-04-27 | Mineral | Colorado | 8079 | 86 | 1 |
1261594 | 1261594 | 2021-04-27 | Moffat | Colorado | 8081 | 742 | 22 |
1261595 | 1261595 | 2021-04-27 | Montezuma | Colorado | 8083 | 1866 | 24 |
1261596 | 1261596 | 2021-04-27 | Montrose | Colorado | 8085 | 3403 | 57 |
1261597 | 1261597 | 2021-04-27 | Morgan | Colorado | 8087 | 2609 | 93 |
1261598 | 1261598 | 2021-04-27 | Otero | Colorado | 8089 | 1939 | 63 |
1261599 | 1261599 | 2021-04-27 | Ouray | Colorado | 8091 | 281 | 3 |
1261600 | 1261600 | 2021-04-27 | Park | Colorado | 8093 | 720 | 5 |
1261601 | 1261601 | 2021-04-27 | Phillips | Colorado | 8095 | 363 | 13 |
1261602 | 1261602 | 2021-04-27 | Pitkin | Colorado | 8097 | 2580 | 4 |
1261603 | 1261603 | 2021-04-27 | Prowers | Colorado | 8099 | 1202 | 21 |
1261604 | 1261604 | 2021-04-27 | Pueblo | Colorado | 8101 | 17475 | 371 |
1261605 | 1261605 | 2021-04-27 | Rio Blanco | Colorado | 8103 | 552 | 4 |
1261606 | 1261606 | 2021-04-27 | Rio Grande | Colorado | 8105 | 781 | 14 |
1261607 | 1261607 | 2021-04-27 | Routt | Colorado | 8107 | 2169 | 20 |
1261608 | 1261608 | 2021-04-27 | Saguache | Colorado | 8109 | 363 | 4 |
1261609 | 1261609 | 2021-04-27 | San Juan | Colorado | 8111 | 48 | 0 |
1261610 | 1261610 | 2021-04-27 | San Miguel | Colorado | 8113 | 870 | 0 |
1261611 | 1261611 | 2021-04-27 | Sedgwick | Colorado | 8115 | 209 | 2 |
1261612 | 1261612 | 2021-04-27 | Summit | Colorado | 8117 | 3673 | 7 |
1261613 | 1261613 | 2021-04-27 | Teller | Colorado | 8119 | 1623 | 14 |
1261614 | 1261614 | 2021-04-27 | Washington | Colorado | 8121 | 444 | 12 |
1261615 | 1261615 | 2021-04-27 | Weld | Colorado | 8123 | 30185 | 333 |
1261616 | 1261616 | 2021-04-27 | Yuma | Colorado | 8125 | 868 | 17 |
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);