ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where date = "2020-12-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 |
---|---|---|---|---|---|---|---|
823320 | 823320 | 2020-12-13 | Adams | Colorado | 8001 | 35516 | 430 |
823321 | 823321 | 2020-12-13 | Alamosa | Colorado | 8003 | 798 | 21 |
823322 | 823322 | 2020-12-13 | Arapahoe | Colorado | 8005 | 33424 | 517 |
823323 | 823323 | 2020-12-13 | Archuleta | Colorado | 8007 | 414 | 0 |
823324 | 823324 | 2020-12-13 | Baca | Colorado | 8009 | 154 | 0 |
823325 | 823325 | 2020-12-13 | Bent | Colorado | 8011 | 664 | 3 |
823326 | 823326 | 2020-12-13 | Boulder | Colorado | 8013 | 13073 | 148 |
823327 | 823327 | 2020-12-13 | Broomfield | Colorado | 8014 | 2446 | 57 |
823328 | 823328 | 2020-12-13 | Chaffee | Colorado | 8015 | 821 | 22 |
823329 | 823329 | 2020-12-13 | Cheyenne | Colorado | 8017 | 85 | 3 |
823330 | 823330 | 2020-12-13 | Clear Creek | Colorado | 8019 | 232 | 2 |
823331 | 823331 | 2020-12-13 | Conejos | Colorado | 8021 | 245 | 4 |
823332 | 823332 | 2020-12-13 | Costilla | Colorado | 8023 | 113 | 2 |
823333 | 823333 | 2020-12-13 | Crowley | Colorado | 8025 | 1430 | 10 |
823334 | 823334 | 2020-12-13 | Custer | Colorado | 8027 | 120 | 0 |
823335 | 823335 | 2020-12-13 | Delta | Colorado | 8029 | 1073 | 17 |
823336 | 823336 | 2020-12-13 | Denver | Colorado | 8031 | 42590 | 612 |
823337 | 823337 | 2020-12-13 | Dolores | Colorado | 8033 | 40 | 0 |
823338 | 823338 | 2020-12-13 | Douglas | Colorado | 8035 | 13793 | 146 |
823339 | 823339 | 2020-12-13 | Eagle | Colorado | 8037 | 2851 | 12 |
823340 | 823340 | 2020-12-13 | El Paso | Colorado | 8041 | 35359 | 431 |
823341 | 823341 | 2020-12-13 | Elbert | Colorado | 8039 | 817 | 5 |
823342 | 823342 | 2020-12-13 | Fremont | Colorado | 8043 | 3701 | 12 |
823343 | 823343 | 2020-12-13 | Garfield | Colorado | 8045 | 2995 | 17 |
823344 | 823344 | 2020-12-13 | Gilpin | Colorado | 8047 | 105 | 1 |
823345 | 823345 | 2020-12-13 | Grand | Colorado | 8049 | 521 | 5 |
823346 | 823346 | 2020-12-13 | Gunnison | Colorado | 8051 | 542 | 7 |
823347 | 823347 | 2020-12-13 | Hinsdale | Colorado | 8053 | 12 | 0 |
823348 | 823348 | 2020-12-13 | Huerfano | Colorado | 8055 | 236 | 11 |
823349 | 823349 | 2020-12-13 | Jackson | Colorado | 8057 | 25 | 0 |
823350 | 823350 | 2020-12-13 | Jefferson | Colorado | 8059 | 25748 | 552 |
823351 | 823351 | 2020-12-13 | Kiowa | Colorado | 8061 | 53 | 0 |
823352 | 823352 | 2020-12-13 | Kit Carson | Colorado | 8063 | 390 | 8 |
823353 | 823353 | 2020-12-13 | La Plata | Colorado | 8067 | 1889 | 10 |
823354 | 823354 | 2020-12-13 | Lake | Colorado | 8065 | 354 | 0 |
823355 | 823355 | 2020-12-13 | Larimer | Colorado | 8069 | 13069 | 95 |
823356 | 823356 | 2020-12-13 | Las Animas | Colorado | 8071 | 374 | 3 |
823357 | 823357 | 2020-12-13 | Lincoln | Colorado | 8073 | 691 | 1 |
823358 | 823358 | 2020-12-13 | Logan | Colorado | 8075 | 2757 | 49 |
823359 | 823359 | 2020-12-13 | Mesa | Colorado | 8077 | 7515 | 96 |
823360 | 823360 | 2020-12-13 | Mineral | Colorado | 8079 | 37 | 1 |
823361 | 823361 | 2020-12-13 | Moffat | Colorado | 8081 | 428 | 16 |
823362 | 823362 | 2020-12-13 | Montezuma | Colorado | 8083 | 990 | 11 |
823363 | 823363 | 2020-12-13 | Montrose | Colorado | 8085 | 1632 | 22 |
823364 | 823364 | 2020-12-13 | Morgan | Colorado | 8087 | 1901 | 63 |
823365 | 823365 | 2020-12-13 | Otero | Colorado | 8089 | 1305 | 18 |
823366 | 823366 | 2020-12-13 | Ouray | Colorado | 8091 | 137 | 3 |
823367 | 823367 | 2020-12-13 | Park | Colorado | 8093 | 314 | 4 |
823368 | 823368 | 2020-12-13 | Phillips | Colorado | 8095 | 206 | 4 |
823369 | 823369 | 2020-12-13 | Pitkin | Colorado | 8097 | 682 | 2 |
823370 | 823370 | 2020-12-13 | Prowers | Colorado | 8099 | 865 | 17 |
823371 | 823371 | 2020-12-13 | Pueblo | Colorado | 8101 | 11415 | 216 |
823372 | 823372 | 2020-12-13 | Rio Blanco | Colorado | 8103 | 221 | 2 |
823373 | 823373 | 2020-12-13 | Rio Grande | Colorado | 8105 | 299 | 5 |
823374 | 823374 | 2020-12-13 | Routt | Colorado | 8107 | 879 | 17 |
823375 | 823375 | 2020-12-13 | Saguache | Colorado | 8109 | 239 | 4 |
823376 | 823376 | 2020-12-13 | San Juan | Colorado | 8111 | 26 | 0 |
823377 | 823377 | 2020-12-13 | San Miguel | Colorado | 8113 | 288 | 0 |
823378 | 823378 | 2020-12-13 | Sedgwick | Colorado | 8115 | 117 | 2 |
823379 | 823379 | 2020-12-13 | Summit | Colorado | 8117 | 1826 | 5 |
823380 | 823380 | 2020-12-13 | Teller | Colorado | 8119 | 856 | 6 |
823381 | 823381 | 2020-12-13 | Washington | Colorado | 8121 | 299 | 10 |
823382 | 823382 | 2020-12-13 | Weld | Colorado | 8123 | 17240 | 241 |
823383 | 823383 | 2020-12-13 | Yuma | Colorado | 8125 | 442 | 4 |
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);