ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where "date" is on date 2022-04-14 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2405381 | 2405381 | 2022-04-14 | Adams | Colorado | 8001 | 134531 | 1323 |
2405382 | 2405382 | 2022-04-14 | Alamosa | Colorado | 8003 | 4508 | 60 |
2405383 | 2405383 | 2022-04-14 | Arapahoe | Colorado | 8005 | 153729 | 1237 |
2405384 | 2405384 | 2022-04-14 | Archuleta | Colorado | 8007 | 2894 | 15 |
2405385 | 2405385 | 2022-04-14 | Baca | Colorado | 8009 | 843 | 8 |
2405386 | 2405386 | 2022-04-14 | Bent | Colorado | 8011 | 2537 | 47 |
2405387 | 2405387 | 2022-04-14 | Boulder | Colorado | 8013 | 64344 | 391 |
2405388 | 2405388 | 2022-04-14 | Broomfield | Colorado | 8014 | 13410 | 112 |
2405389 | 2405389 | 2022-04-14 | Chaffee | Colorado | 8015 | 4571 | 44 |
2405390 | 2405390 | 2022-04-14 | Cheyenne | Colorado | 8017 | 321 | 9 |
2405391 | 2405391 | 2022-04-14 | Clear Creek | Colorado | 8019 | 1559 | 12 |
2405392 | 2405392 | 2022-04-14 | Conejos | Colorado | 8021 | 1738 | 54 |
2405393 | 2405393 | 2022-04-14 | Costilla | Colorado | 8023 | 692 | 16 |
2405394 | 2405394 | 2022-04-14 | Crowley | Colorado | 8025 | 3297 | 28 |
2405395 | 2405395 | 2022-04-14 | Custer | Colorado | 8027 | 647 | 20 |
2405396 | 2405396 | 2022-04-14 | Delta | Colorado | 8029 | 6128 | 134 |
2405397 | 2405397 | 2022-04-14 | Denver | Colorado | 8031 | 170388 | 1284 |
2405398 | 2405398 | 2022-04-14 | Dolores | Colorado | 8033 | 364 | 8 |
2405399 | 2405399 | 2022-04-14 | Douglas | Colorado | 8035 | 78923 | 429 |
2405400 | 2405400 | 2022-04-14 | Eagle | Colorado | 8037 | 15988 | 35 |
2405401 | 2405401 | 2022-04-14 | El Paso | Colorado | 8041 | 185172 | 1612 |
2405402 | 2405402 | 2022-04-14 | Elbert | Colorado | 8039 | 4770 | 37 |
2405403 | 2405403 | 2022-04-14 | Fremont | Colorado | 8043 | 15248 | 178 |
2405404 | 2405404 | 2022-04-14 | Garfield | Colorado | 8045 | 14688 | 90 |
2405405 | 2405405 | 2022-04-14 | Gilpin | Colorado | 8047 | 951 | 4 |
2405406 | 2405406 | 2022-04-14 | Grand | Colorado | 8049 | 3514 | 26 |
2405407 | 2405407 | 2022-04-14 | Gunnison | Colorado | 8051 | 3384 | 14 |
2405408 | 2405408 | 2022-04-14 | Hinsdale | Colorado | 8053 | 123 | 0 |
2405409 | 2405409 | 2022-04-14 | Huerfano | Colorado | 8055 | 1443 | 31 |
2405410 | 2405410 | 2022-04-14 | Jackson | Colorado | 8057 | 164 | 0 |
2405411 | 2405411 | 2022-04-14 | Jefferson | Colorado | 8059 | 123536 | 1329 |
2405412 | 2405412 | 2022-04-14 | Kiowa | Colorado | 8061 | 335 | 6 |
2405413 | 2405413 | 2022-04-14 | Kit Carson | Colorado | 8063 | 1608 | 31 |
2405414 | 2405414 | 2022-04-14 | La Plata | Colorado | 8067 | 12788 | 81 |
2405415 | 2405415 | 2022-04-14 | Lake | Colorado | 8065 | 1794 | 2 |
2405416 | 2405416 | 2022-04-14 | Larimer | Colorado | 8069 | 77761 | 479 |
2405417 | 2405417 | 2022-04-14 | Las Animas | Colorado | 8071 | 3595 | 40 |
2405418 | 2405418 | 2022-04-14 | Lincoln | Colorado | 8073 | 2180 | 9 |
2405419 | 2405419 | 2022-04-14 | Logan | Colorado | 8075 | 7426 | 107 |
2405420 | 2405420 | 2022-04-14 | Mesa | Colorado | 8077 | 42481 | 532 |
2405421 | 2405421 | 2022-04-14 | Mineral | Colorado | 8079 | 230 | 1 |
2405422 | 2405422 | 2022-04-14 | Moffat | Colorado | 8081 | 3019 | 51 |
2405423 | 2405423 | 2022-04-14 | Montezuma | Colorado | 8083 | 6182 | 74 |
2405424 | 2405424 | 2022-04-14 | Montrose | Colorado | 8085 | 9283 | 158 |
2405425 | 2405425 | 2022-04-14 | Morgan | Colorado | 8087 | 5642 | 135 |
2405426 | 2405426 | 2022-04-14 | Otero | Colorado | 8089 | 4282 | 126 |
2405427 | 2405427 | 2022-04-14 | Ouray | Colorado | 8091 | 861 | 6 |
2405428 | 2405428 | 2022-04-14 | Park | Colorado | 8093 | 2830 | 20 |
2405429 | 2405429 | 2022-04-14 | Phillips | Colorado | 8095 | 883 | 18 |
2405430 | 2405430 | 2022-04-14 | Pitkin | Colorado | 8097 | 6481 | 6 |
2405431 | 2405431 | 2022-04-14 | Prowers | Colorado | 8099 | 2628 | 48 |
2405432 | 2405432 | 2022-04-14 | Pueblo | Colorado | 8101 | 46405 | 775 |
2405433 | 2405433 | 2022-04-14 | Rio Blanco | Colorado | 8103 | 1676 | 13 |
2405434 | 2405434 | 2022-04-14 | Rio Grande | Colorado | 8105 | 2801 | 46 |
2405435 | 2405435 | 2022-04-14 | Routt | Colorado | 8107 | 6433 | 25 |
2405436 | 2405436 | 2022-04-14 | Saguache | Colorado | 8109 | 1183 | 12 |
2405437 | 2405437 | 2022-04-14 | San Juan | Colorado | 8111 | 201 | 0 |
2405438 | 2405438 | 2022-04-14 | San Miguel | Colorado | 8113 | 2277 | 8 |
2405439 | 2405439 | 2022-04-14 | Sedgwick | Colorado | 8115 | 483 | 9 |
2405440 | 2405440 | 2022-04-14 | Summit | Colorado | 8117 | 9830 | 14 |
2405441 | 2405441 | 2022-04-14 | Teller | Colorado | 8119 | 4823 | 57 |
2405442 | 2405442 | 2022-04-14 | Washington | Colorado | 8121 | 1060 | 27 |
2405443 | 2405443 | 2022-04-14 | Weld | Colorado | 8123 | 83366 | 696 |
2405444 | 2405444 | 2022-04-14 | Yuma | Colorado | 8125 | 1874 | 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);