ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where date = "2021-11-15" 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 |
---|---|---|---|---|---|---|---|
1917589 | 1917589 | 2021-11-15 | Adams | Colorado | 8001 | 82296 | 936 |
1917590 | 1917590 | 2021-11-15 | Alamosa | Colorado | 8003 | 2723 | 45 |
1917591 | 1917591 | 2021-11-15 | Arapahoe | Colorado | 8005 | 86556 | 967 |
1917592 | 1917592 | 2021-11-15 | Archuleta | Colorado | 8007 | 1699 | 6 |
1917593 | 1917593 | 2021-11-15 | Baca | Colorado | 8009 | 526 | 5 |
1917594 | 1917594 | 2021-11-15 | Bent | Colorado | 8011 | 1806 | 30 |
1917595 | 1917595 | 2021-11-15 | Boulder | Colorado | 8013 | 33307 | 296 |
1917596 | 1917596 | 2021-11-15 | Broomfield | Colorado | 8014 | 7233 | 84 |
1917597 | 1917597 | 2021-11-15 | Chaffee | Colorado | 8015 | 2549 | 33 |
1917598 | 1917598 | 2021-11-15 | Cheyenne | Colorado | 8017 | 209 | 7 |
1917599 | 1917599 | 2021-11-15 | Clear Creek | Colorado | 8019 | 836 | 6 |
1917600 | 1917600 | 2021-11-15 | Conejos | Colorado | 8021 | 1085 | 38 |
1917601 | 1917601 | 2021-11-15 | Costilla | Colorado | 8023 | 412 | 12 |
1917602 | 1917602 | 2021-11-15 | Crowley | Colorado | 8025 | 2441 | 24 |
1917603 | 1917603 | 2021-11-15 | Custer | Colorado | 8027 | 445 | 10 |
1917604 | 1917604 | 2021-11-15 | Delta | Colorado | 8029 | 4383 | 94 |
1917605 | 1917605 | 2021-11-15 | Denver | Colorado | 8031 | 97065 | 974 |
1917606 | 1917606 | 2021-11-15 | Dolores | Colorado | 8033 | 247 | 5 |
1917607 | 1917607 | 2021-11-15 | Douglas | Colorado | 8035 | 44119 | 338 |
1917608 | 1917608 | 2021-11-15 | Eagle | Colorado | 8037 | 8903 | 32 |
1917609 | 1917609 | 2021-11-15 | El Paso | Colorado | 8041 | 109261 | 1192 |
1917610 | 1917610 | 2021-11-15 | Elbert | Colorado | 8039 | 2889 | 25 |
1917611 | 1917611 | 2021-11-15 | Fremont | Colorado | 8043 | 9459 | 108 |
1917612 | 1917612 | 2021-11-15 | Garfield | Colorado | 8045 | 8395 | 68 |
1917613 | 1917613 | 2021-11-15 | Gilpin | Colorado | 8047 | 510 | 3 |
1917614 | 1917614 | 2021-11-15 | Grand | Colorado | 8049 | 2233 | 16 |
1917615 | 1917615 | 2021-11-15 | Gunnison | Colorado | 8051 | 1907 | 12 |
1917616 | 1917616 | 2021-11-15 | Hinsdale | Colorado | 8053 | 64 | 0 |
1917617 | 1917617 | 2021-11-15 | Huerfano | Colorado | 8055 | 745 | 21 |
1917618 | 1917618 | 2021-11-15 | Jackson | Colorado | 8057 | 117 | 0 |
1917619 | 1917619 | 2021-11-15 | Jefferson | Colorado | 8059 | 68651 | 956 |
1917620 | 1917620 | 2021-11-15 | Kiowa | Colorado | 8061 | 251 | 4 |
1917621 | 1917621 | 2021-11-15 | Kit Carson | Colorado | 8063 | 1056 | 20 |
1917622 | 1917622 | 2021-11-15 | La Plata | Colorado | 8067 | 6536 | 55 |
1917623 | 1917623 | 2021-11-15 | Lake | Colorado | 8065 | 1078 | 1 |
1917624 | 1917624 | 2021-11-15 | Larimer | Colorado | 8069 | 42915 | 342 |
1917625 | 1917625 | 2021-11-15 | Las Animas | Colorado | 8071 | 2025 | 24 |
1917626 | 1917626 | 2021-11-15 | Lincoln | Colorado | 8073 | 1343 | 8 |
1917627 | 1917627 | 2021-11-15 | Logan | Colorado | 8075 | 4930 | 87 |
1917628 | 1917628 | 2021-11-15 | Mesa | Colorado | 8077 | 26386 | 365 |
1917629 | 1917629 | 2021-11-15 | Mineral | Colorado | 8079 | 144 | 1 |
1917630 | 1917630 | 2021-11-15 | Moffat | Colorado | 8081 | 2097 | 46 |
1917631 | 1917631 | 2021-11-15 | Montezuma | Colorado | 8083 | 3672 | 41 |
1917632 | 1917632 | 2021-11-15 | Montrose | Colorado | 8085 | 6279 | 98 |
1917633 | 1917633 | 2021-11-15 | Morgan | Colorado | 8087 | 3734 | 102 |
1917634 | 1917634 | 2021-11-15 | Otero | Colorado | 8089 | 2964 | 88 |
1917635 | 1917635 | 2021-11-15 | Ouray | Colorado | 8091 | 491 | 5 |
1917636 | 1917636 | 2021-11-15 | Park | Colorado | 8093 | 1586 | 10 |
1917637 | 1917637 | 2021-11-15 | Phillips | Colorado | 8095 | 554 | 15 |
1917638 | 1917638 | 2021-11-15 | Pitkin | Colorado | 8097 | 3231 | 6 |
1917639 | 1917639 | 2021-11-15 | Prowers | Colorado | 8099 | 1834 | 33 |
1917640 | 1917640 | 2021-11-15 | Pueblo | Colorado | 8101 | 28076 | 535 |
1917641 | 1917641 | 2021-11-15 | Rio Blanco | Colorado | 8103 | 1145 | 9 |
1917642 | 1917642 | 2021-11-15 | Rio Grande | Colorado | 8105 | 1674 | 24 |
1917643 | 1917643 | 2021-11-15 | Routt | Colorado | 8107 | 3706 | 23 |
1917644 | 1917644 | 2021-11-15 | Saguache | Colorado | 8109 | 752 | 8 |
1917645 | 1917645 | 2021-11-15 | San Juan | Colorado | 8111 | 105 | 0 |
1917646 | 1917646 | 2021-11-15 | San Miguel | Colorado | 8113 | 1232 | 5 |
1917647 | 1917647 | 2021-11-15 | Sedgwick | Colorado | 8115 | 339 | 5 |
1917648 | 1917648 | 2021-11-15 | Summit | Colorado | 8117 | 5088 | 11 |
1917649 | 1917649 | 2021-11-15 | Teller | Colorado | 8119 | 3129 | 38 |
1917650 | 1917650 | 2021-11-15 | Washington | Colorado | 8121 | 724 | 23 |
1917651 | 1917651 | 2021-11-15 | Weld | Colorado | 8123 | 50428 | 493 |
1917652 | 1917652 | 2021-11-15 | Yuma | Colorado | 8125 | 1326 | 18 |
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);