ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where date = "2021-07-21" 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 |
---|---|---|---|---|---|---|---|
1537484 | 1537484 | 2021-07-21 | Adams | Colorado | 8001 | 62916 | 764 |
1537485 | 1537485 | 2021-07-21 | Alamosa | Colorado | 8003 | 1779 | 37 |
1537486 | 1537486 | 2021-07-21 | Arapahoe | Colorado | 8005 | 64974 | 843 |
1537487 | 1537487 | 2021-07-21 | Archuleta | Colorado | 8007 | 1111 | 3 |
1537488 | 1537488 | 2021-07-21 | Baca | Colorado | 8009 | 325 | 4 |
1537489 | 1537489 | 2021-07-21 | Bent | Colorado | 8011 | 1549 | 22 |
1537490 | 1537490 | 2021-07-21 | Boulder | Colorado | 8013 | 24483 | 261 |
1537491 | 1537491 | 2021-07-21 | Broomfield | Colorado | 8014 | 5080 | 76 |
1537492 | 1537492 | 2021-07-21 | Chaffee | Colorado | 8015 | 1807 | 25 |
1537493 | 1537493 | 2021-07-21 | Cheyenne | Colorado | 8017 | 130 | 6 |
1537494 | 1537494 | 2021-07-21 | Clear Creek | Colorado | 8019 | 490 | 3 |
1537495 | 1537495 | 2021-07-21 | Conejos | Colorado | 8021 | 755 | 24 |
1537496 | 1537496 | 2021-07-21 | Costilla | Colorado | 8023 | 254 | 5 |
1537497 | 1537497 | 2021-07-21 | Crowley | Colorado | 8025 | 2217 | 17 |
1537498 | 1537498 | 2021-07-21 | Custer | Colorado | 8027 | 237 | 2 |
1537499 | 1537499 | 2021-07-21 | Delta | Colorado | 8029 | 3087 | 70 |
1537500 | 1537500 | 2021-07-21 | Denver | Colorado | 8031 | 75274 | 848 |
1537501 | 1537501 | 2021-07-21 | Dolores | Colorado | 8033 | 130 | 1 |
1537502 | 1537502 | 2021-07-21 | Douglas | Colorado | 8035 | 31637 | 272 |
1537503 | 1537503 | 2021-07-21 | Eagle | Colorado | 8037 | 6458 | 23 |
1537504 | 1537504 | 2021-07-21 | El Paso | Colorado | 8041 | 75043 | 894 |
1537505 | 1537505 | 2021-07-21 | Elbert | Colorado | 8039 | 1913 | 14 |
1537506 | 1537506 | 2021-07-21 | Fremont | Colorado | 8043 | 6608 | 64 |
1537507 | 1537507 | 2021-07-21 | Garfield | Colorado | 8045 | 6382 | 52 |
1537508 | 1537508 | 2021-07-21 | Gilpin | Colorado | 8047 | 286 | 3 |
1537509 | 1537509 | 2021-07-21 | Grand | Colorado | 8049 | 1522 | 7 |
1537510 | 1537510 | 2021-07-21 | Gunnison | Colorado | 8051 | 1408 | 6 |
1537511 | 1537511 | 2021-07-21 | Hinsdale | Colorado | 8053 | 31 | 0 |
1537512 | 1537512 | 2021-07-21 | Huerfano | Colorado | 8055 | 451 | 18 |
1537513 | 1537513 | 2021-07-21 | Jackson | Colorado | 8057 | 67 | 0 |
1537514 | 1537514 | 2021-07-21 | Jefferson | Colorado | 8059 | 49557 | 811 |
1537515 | 1537515 | 2021-07-21 | Kiowa | Colorado | 8061 | 95 | 3 |
1537516 | 1537516 | 2021-07-21 | Kit Carson | Colorado | 8063 | 656 | 12 |
1537517 | 1537517 | 2021-07-21 | La Plata | Colorado | 8067 | 4247 | 41 |
1537518 | 1537518 | 2021-07-21 | Lake | Colorado | 8065 | 843 | 1 |
1537519 | 1537519 | 2021-07-21 | Larimer | Colorado | 8069 | 28331 | 248 |
1537520 | 1537520 | 2021-07-21 | Las Animas | Colorado | 8071 | 1233 | 14 |
1537521 | 1537521 | 2021-07-21 | Lincoln | Colorado | 8073 | 1041 | 4 |
1537522 | 1537522 | 2021-07-21 | Logan | Colorado | 8075 | 4071 | 69 |
1537523 | 1537523 | 2021-07-21 | Mesa | Colorado | 8077 | 17966 | 260 |
1537524 | 1537524 | 2021-07-21 | Mineral | Colorado | 8079 | 94 | 1 |
1537525 | 1537525 | 2021-07-21 | Moffat | Colorado | 8081 | 1154 | 26 |
1537526 | 1537526 | 2021-07-21 | Montezuma | Colorado | 8083 | 2148 | 27 |
1537527 | 1537527 | 2021-07-21 | Montrose | Colorado | 8085 | 3942 | 68 |
1537528 | 1537528 | 2021-07-21 | Morgan | Colorado | 8087 | 2769 | 96 |
1537529 | 1537529 | 2021-07-21 | Otero | Colorado | 8089 | 2094 | 67 |
1537530 | 1537530 | 2021-07-21 | Ouray | Colorado | 8091 | 309 | 4 |
1537531 | 1537531 | 2021-07-21 | Park | Colorado | 8093 | 855 | 5 |
1537532 | 1537532 | 2021-07-21 | Phillips | Colorado | 8095 | 401 | 13 |
1537533 | 1537533 | 2021-07-21 | Pitkin | Colorado | 8097 | 2643 | 4 |
1537534 | 1537534 | 2021-07-21 | Prowers | Colorado | 8099 | 1285 | 22 |
1537535 | 1537535 | 2021-07-21 | Pueblo | Colorado | 8101 | 19786 | 424 |
1537536 | 1537536 | 2021-07-21 | Rio Blanco | Colorado | 8103 | 676 | 5 |
1537537 | 1537537 | 2021-07-21 | Rio Grande | Colorado | 8105 | 939 | 18 |
1537538 | 1537538 | 2021-07-21 | Routt | Colorado | 8107 | 2391 | 21 |
1537539 | 1537539 | 2021-07-21 | Saguache | Colorado | 8109 | 469 | 7 |
1537540 | 1537540 | 2021-07-21 | San Juan | Colorado | 8111 | 47 | 0 |
1537541 | 1537541 | 2021-07-21 | San Miguel | Colorado | 8113 | 943 | 1 |
1537542 | 1537542 | 2021-07-21 | Sedgwick | Colorado | 8115 | 235 | 3 |
1537543 | 1537543 | 2021-07-21 | Summit | Colorado | 8117 | 3834 | 8 |
1537544 | 1537544 | 2021-07-21 | Teller | Colorado | 8119 | 1955 | 18 |
1537545 | 1537545 | 2021-07-21 | Washington | Colorado | 8121 | 476 | 13 |
1537546 | 1537546 | 2021-07-21 | Weld | Colorado | 8123 | 34041 | 355 |
1537547 | 1537547 | 2021-07-21 | Yuma | Colorado | 8125 | 975 | 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);