ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where date = "2021-07-13" 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 |
---|---|---|---|---|---|---|---|
1511506 | 1511506 | 2021-07-13 | Adams | Colorado | 8001 | 62573 | 762 |
1511507 | 1511507 | 2021-07-13 | Alamosa | Colorado | 8003 | 1750 | 37 |
1511508 | 1511508 | 2021-07-13 | Arapahoe | Colorado | 8005 | 64629 | 836 |
1511509 | 1511509 | 2021-07-13 | Archuleta | Colorado | 8007 | 1088 | 3 |
1511510 | 1511510 | 2021-07-13 | Baca | Colorado | 8009 | 325 | 4 |
1511511 | 1511511 | 2021-07-13 | Bent | Colorado | 8011 | 1545 | 22 |
1511512 | 1511512 | 2021-07-13 | Boulder | Colorado | 8013 | 24325 | 261 |
1511513 | 1511513 | 2021-07-13 | Broomfield | Colorado | 8014 | 5044 | 76 |
1511514 | 1511514 | 2021-07-13 | Chaffee | Colorado | 8015 | 1787 | 25 |
1511515 | 1511515 | 2021-07-13 | Cheyenne | Colorado | 8017 | 130 | 6 |
1511516 | 1511516 | 2021-07-13 | Clear Creek | Colorado | 8019 | 483 | 3 |
1511517 | 1511517 | 2021-07-13 | Conejos | Colorado | 8021 | 749 | 23 |
1511518 | 1511518 | 2021-07-13 | Costilla | Colorado | 8023 | 252 | 5 |
1511519 | 1511519 | 2021-07-13 | Crowley | Colorado | 8025 | 2216 | 17 |
1511520 | 1511520 | 2021-07-13 | Custer | Colorado | 8027 | 235 | 2 |
1511521 | 1511521 | 2021-07-13 | Delta | Colorado | 8029 | 3029 | 67 |
1511522 | 1511522 | 2021-07-13 | Denver | Colorado | 8031 | 74889 | 850 |
1511523 | 1511523 | 2021-07-13 | Dolores | Colorado | 8033 | 130 | 1 |
1511524 | 1511524 | 2021-07-13 | Douglas | Colorado | 8035 | 31467 | 268 |
1511525 | 1511525 | 2021-07-13 | Eagle | Colorado | 8037 | 6404 | 23 |
1511526 | 1511526 | 2021-07-13 | El Paso | Colorado | 8041 | 74353 | 886 |
1511527 | 1511527 | 2021-07-13 | Elbert | Colorado | 8039 | 1904 | 14 |
1511528 | 1511528 | 2021-07-13 | Fremont | Colorado | 8043 | 6574 | 65 |
1511529 | 1511529 | 2021-07-13 | Garfield | Colorado | 8045 | 6290 | 50 |
1511530 | 1511530 | 2021-07-13 | Gilpin | Colorado | 8047 | 286 | 3 |
1511531 | 1511531 | 2021-07-13 | Grand | Colorado | 8049 | 1513 | 7 |
1511532 | 1511532 | 2021-07-13 | Gunnison | Colorado | 8051 | 1407 | 6 |
1511533 | 1511533 | 2021-07-13 | Hinsdale | Colorado | 8053 | 27 | 0 |
1511534 | 1511534 | 2021-07-13 | Huerfano | Colorado | 8055 | 444 | 18 |
1511535 | 1511535 | 2021-07-13 | Jackson | Colorado | 8057 | 67 | 0 |
1511536 | 1511536 | 2021-07-13 | Jefferson | Colorado | 8059 | 49280 | 807 |
1511537 | 1511537 | 2021-07-13 | Kiowa | Colorado | 8061 | 95 | 3 |
1511538 | 1511538 | 2021-07-13 | Kit Carson | Colorado | 8063 | 653 | 12 |
1511539 | 1511539 | 2021-07-13 | La Plata | Colorado | 8067 | 4209 | 41 |
1511540 | 1511540 | 2021-07-13 | Lake | Colorado | 8065 | 839 | 0 |
1511541 | 1511541 | 2021-07-13 | Larimer | Colorado | 8069 | 28034 | 248 |
1511542 | 1511542 | 2021-07-13 | Las Animas | Colorado | 8071 | 1215 | 14 |
1511543 | 1511543 | 2021-07-13 | Lincoln | Colorado | 8073 | 1037 | 4 |
1511544 | 1511544 | 2021-07-13 | Logan | Colorado | 8075 | 4069 | 69 |
1511545 | 1511545 | 2021-07-13 | Mesa | Colorado | 8077 | 17676 | 259 |
1511546 | 1511546 | 2021-07-13 | Mineral | Colorado | 8079 | 94 | 1 |
1511547 | 1511547 | 2021-07-13 | Moffat | Colorado | 8081 | 1097 | 27 |
1511548 | 1511548 | 2021-07-13 | Montezuma | Colorado | 8083 | 2123 | 27 |
1511549 | 1511549 | 2021-07-13 | Montrose | Colorado | 8085 | 3872 | 66 |
1511550 | 1511550 | 2021-07-13 | Morgan | Colorado | 8087 | 2763 | 96 |
1511551 | 1511551 | 2021-07-13 | Otero | Colorado | 8089 | 2090 | 67 |
1511552 | 1511552 | 2021-07-13 | Ouray | Colorado | 8091 | 308 | 4 |
1511553 | 1511553 | 2021-07-13 | Park | Colorado | 8093 | 847 | 5 |
1511554 | 1511554 | 2021-07-13 | Phillips | Colorado | 8095 | 400 | 13 |
1511555 | 1511555 | 2021-07-13 | Pitkin | Colorado | 8097 | 2635 | 4 |
1511556 | 1511556 | 2021-07-13 | Prowers | Colorado | 8099 | 1281 | 22 |
1511557 | 1511557 | 2021-07-13 | Pueblo | Colorado | 8101 | 19693 | 422 |
1511558 | 1511558 | 2021-07-13 | Rio Blanco | Colorado | 8103 | 659 | 5 |
1511559 | 1511559 | 2021-07-13 | Rio Grande | Colorado | 8105 | 927 | 18 |
1511560 | 1511560 | 2021-07-13 | Routt | Colorado | 8107 | 2352 | 21 |
1511561 | 1511561 | 2021-07-13 | Saguache | Colorado | 8109 | 465 | 7 |
1511562 | 1511562 | 2021-07-13 | San Juan | Colorado | 8111 | 47 | 0 |
1511563 | 1511563 | 2021-07-13 | San Miguel | Colorado | 8113 | 934 | 1 |
1511564 | 1511564 | 2021-07-13 | Sedgwick | Colorado | 8115 | 235 | 3 |
1511565 | 1511565 | 2021-07-13 | Summit | Colorado | 8117 | 3794 | 8 |
1511566 | 1511566 | 2021-07-13 | Teller | Colorado | 8119 | 1936 | 18 |
1511567 | 1511567 | 2021-07-13 | Washington | Colorado | 8121 | 474 | 13 |
1511568 | 1511568 | 2021-07-13 | Weld | Colorado | 8123 | 33792 | 353 |
1511569 | 1511569 | 2021-07-13 | Yuma | Colorado | 8125 | 969 | 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);