ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where date = "2022-03-10" 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 |
---|---|---|---|---|---|---|---|
2291510 | 2291510 | 2022-03-10 | Adams | Colorado | 8001 | 131358 | 1308 |
2291511 | 2291511 | 2022-03-10 | Alamosa | Colorado | 8003 | 4453 | 60 |
2291512 | 2291512 | 2022-03-10 | Arapahoe | Colorado | 8005 | 149811 | 1235 |
2291513 | 2291513 | 2022-03-10 | Archuleta | Colorado | 8007 | 2847 | 15 |
2291514 | 2291514 | 2022-03-10 | Baca | Colorado | 8009 | 825 | 8 |
2291515 | 2291515 | 2022-03-10 | Bent | Colorado | 8011 | 2494 | 47 |
2291516 | 2291516 | 2022-03-10 | Boulder | Colorado | 8013 | 61640 | 383 |
2291517 | 2291517 | 2022-03-10 | Broomfield | Colorado | 8014 | 13003 | 112 |
2291518 | 2291518 | 2022-03-10 | Chaffee | Colorado | 8015 | 4344 | 42 |
2291519 | 2291519 | 2022-03-10 | Cheyenne | Colorado | 8017 | 321 | 9 |
2291520 | 2291520 | 2022-03-10 | Clear Creek | Colorado | 8019 | 1503 | 11 |
2291521 | 2291521 | 2022-03-10 | Conejos | Colorado | 8021 | 1702 | 52 |
2291522 | 2291522 | 2022-03-10 | Costilla | Colorado | 8023 | 664 | 15 |
2291523 | 2291523 | 2022-03-10 | Crowley | Colorado | 8025 | 3147 | 28 |
2291524 | 2291524 | 2022-03-10 | Custer | Colorado | 8027 | 627 | 19 |
2291525 | 2291525 | 2022-03-10 | Delta | Colorado | 8029 | 5936 | 131 |
2291526 | 2291526 | 2022-03-10 | Denver | Colorado | 8031 | 165532 | 1275 |
2291527 | 2291527 | 2022-03-10 | Dolores | Colorado | 8033 | 354 | 8 |
2291528 | 2291528 | 2022-03-10 | Douglas | Colorado | 8035 | 76661 | 429 |
2291529 | 2291529 | 2022-03-10 | Eagle | Colorado | 8037 | 15707 | 35 |
2291530 | 2291530 | 2022-03-10 | El Paso | Colorado | 8041 | 180295 | 1595 |
2291531 | 2291531 | 2022-03-10 | Elbert | Colorado | 8039 | 4676 | 37 |
2291532 | 2291532 | 2022-03-10 | Fremont | Colorado | 8043 | 14716 | 177 |
2291533 | 2291533 | 2022-03-10 | Garfield | Colorado | 8045 | 14274 | 88 |
2291534 | 2291534 | 2022-03-10 | Gilpin | Colorado | 8047 | 928 | 4 |
2291535 | 2291535 | 2022-03-10 | Grand | Colorado | 8049 | 3438 | 23 |
2291536 | 2291536 | 2022-03-10 | Gunnison | Colorado | 8051 | 3300 | 14 |
2291537 | 2291537 | 2022-03-10 | Hinsdale | Colorado | 8053 | 121 | 0 |
2291538 | 2291538 | 2022-03-10 | Huerfano | Colorado | 8055 | 1427 | 31 |
2291539 | 2291539 | 2022-03-10 | Jackson | Colorado | 8057 | 164 | 0 |
2291540 | 2291540 | 2022-03-10 | Jefferson | Colorado | 8059 | 119005 | 1306 |
2291541 | 2291541 | 2022-03-10 | Kiowa | Colorado | 8061 | 330 | 6 |
2291542 | 2291542 | 2022-03-10 | Kit Carson | Colorado | 8063 | 1586 | 30 |
2291543 | 2291543 | 2022-03-10 | La Plata | Colorado | 8067 | 12560 | 80 |
2291544 | 2291544 | 2022-03-10 | Lake | Colorado | 8065 | 1779 | 2 |
2291545 | 2291545 | 2022-03-10 | Larimer | Colorado | 8069 | 74498 | 460 |
2291546 | 2291546 | 2022-03-10 | Las Animas | Colorado | 8071 | 3523 | 40 |
2291547 | 2291547 | 2022-03-10 | Lincoln | Colorado | 8073 | 2081 | 9 |
2291548 | 2291548 | 2022-03-10 | Logan | Colorado | 8075 | 7241 | 106 |
2291549 | 2291549 | 2022-03-10 | Mesa | Colorado | 8077 | 41626 | 528 |
2291550 | 2291550 | 2022-03-10 | Mineral | Colorado | 8079 | 224 | 1 |
2291551 | 2291551 | 2022-03-10 | Moffat | Colorado | 8081 | 2952 | 51 |
2291552 | 2291552 | 2022-03-10 | Montezuma | Colorado | 8083 | 6057 | 68 |
2291553 | 2291553 | 2022-03-10 | Montrose | Colorado | 8085 | 9110 | 158 |
2291554 | 2291554 | 2022-03-10 | Morgan | Colorado | 8087 | 5498 | 134 |
2291555 | 2291555 | 2022-03-10 | Otero | Colorado | 8089 | 4218 | 125 |
2291556 | 2291556 | 2022-03-10 | Ouray | Colorado | 8091 | 842 | 6 |
2291557 | 2291557 | 2022-03-10 | Park | Colorado | 8093 | 2751 | 20 |
2291558 | 2291558 | 2022-03-10 | Phillips | Colorado | 8095 | 864 | 18 |
2291559 | 2291559 | 2022-03-10 | Pitkin | Colorado | 8097 | 6246 | 6 |
2291560 | 2291560 | 2022-03-10 | Prowers | Colorado | 8099 | 2587 | 48 |
2291561 | 2291561 | 2022-03-10 | Pueblo | Colorado | 8101 | 44609 | 771 |
2291562 | 2291562 | 2022-03-10 | Rio Blanco | Colorado | 8103 | 1652 | 13 |
2291563 | 2291563 | 2022-03-10 | Rio Grande | Colorado | 8105 | 2748 | 46 |
2291564 | 2291564 | 2022-03-10 | Routt | Colorado | 8107 | 6283 | 24 |
2291565 | 2291565 | 2022-03-10 | Saguache | Colorado | 8109 | 1154 | 12 |
2291566 | 2291566 | 2022-03-10 | San Juan | Colorado | 8111 | 193 | 0 |
2291567 | 2291567 | 2022-03-10 | San Miguel | Colorado | 8113 | 2230 | 8 |
2291568 | 2291568 | 2022-03-10 | Sedgwick | Colorado | 8115 | 478 | 9 |
2291569 | 2291569 | 2022-03-10 | Summit | Colorado | 8117 | 9597 | 14 |
2291570 | 2291570 | 2022-03-10 | Teller | Colorado | 8119 | 4737 | 55 |
2291571 | 2291571 | 2022-03-10 | Washington | Colorado | 8121 | 1039 | 27 |
2291572 | 2291572 | 2022-03-10 | Weld | Colorado | 8123 | 81124 | 686 |
2291573 | 2291573 | 2022-03-10 | Yuma | Colorado | 8125 | 1849 | 23 |
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);