ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
82 rows where county = "Chaffee", deaths = 20 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 |
---|---|---|---|---|---|---|---|
875255 | 875255 | 2020-12-29 | Chaffee | Colorado | 8015 | 1014 | 20 |
872010 | 872010 | 2020-12-28 | Chaffee | Colorado | 8015 | 1002 | 20 |
868765 | 868765 | 2020-12-27 | Chaffee | Colorado | 8015 | 1002 | 20 |
865520 | 865520 | 2020-12-26 | Chaffee | Colorado | 8015 | 998 | 20 |
862275 | 862275 | 2020-12-25 | Chaffee | Colorado | 8015 | 995 | 20 |
859030 | 859030 | 2020-12-24 | Chaffee | Colorado | 8015 | 976 | 20 |
855785 | 855785 | 2020-12-23 | Chaffee | Colorado | 8015 | 935 | 20 |
852540 | 852540 | 2020-12-22 | Chaffee | Colorado | 8015 | 927 | 20 |
836314 | 836314 | 2020-12-17 | Chaffee | Colorado | 8015 | 881 | 20 |
738946 | 738946 | 2020-11-17 | Chaffee | Colorado | 8015 | 508 | 20 |
735702 | 735702 | 2020-11-16 | Chaffee | Colorado | 8015 | 506 | 20 |
732456 | 732456 | 2020-11-15 | Chaffee | Colorado | 8015 | 501 | 20 |
729211 | 729211 | 2020-11-14 | Chaffee | Colorado | 8015 | 487 | 20 |
725968 | 725968 | 2020-11-13 | Chaffee | Colorado | 8015 | 484 | 20 |
722725 | 722725 | 2020-11-12 | Chaffee | Colorado | 8015 | 475 | 20 |
719482 | 719482 | 2020-11-11 | Chaffee | Colorado | 8015 | 473 | 20 |
716239 | 716239 | 2020-11-10 | Chaffee | Colorado | 8015 | 472 | 20 |
712995 | 712995 | 2020-11-09 | Chaffee | Colorado | 8015 | 469 | 20 |
709751 | 709751 | 2020-11-08 | Chaffee | Colorado | 8015 | 466 | 20 |
706507 | 706507 | 2020-11-07 | Chaffee | Colorado | 8015 | 461 | 20 |
703264 | 703264 | 2020-11-06 | Chaffee | Colorado | 8015 | 454 | 20 |
700021 | 700021 | 2020-11-05 | Chaffee | Colorado | 8015 | 445 | 20 |
696777 | 696777 | 2020-11-04 | Chaffee | Colorado | 8015 | 439 | 20 |
693535 | 693535 | 2020-11-03 | Chaffee | Colorado | 8015 | 435 | 20 |
690292 | 690292 | 2020-11-02 | Chaffee | Colorado | 8015 | 435 | 20 |
687047 | 687047 | 2020-11-01 | Chaffee | Colorado | 8015 | 433 | 20 |
683803 | 683803 | 2020-10-31 | Chaffee | Colorado | 8015 | 431 | 20 |
680560 | 680560 | 2020-10-30 | Chaffee | Colorado | 8015 | 422 | 20 |
677317 | 677317 | 2020-10-29 | Chaffee | Colorado | 8015 | 417 | 20 |
674074 | 674074 | 2020-10-28 | Chaffee | Colorado | 8015 | 402 | 20 |
670832 | 670832 | 2020-10-27 | Chaffee | Colorado | 8015 | 394 | 20 |
667589 | 667589 | 2020-10-26 | Chaffee | Colorado | 8015 | 393 | 20 |
664344 | 664344 | 2020-10-25 | Chaffee | Colorado | 8015 | 391 | 20 |
661100 | 661100 | 2020-10-24 | Chaffee | Colorado | 8015 | 386 | 20 |
657856 | 657856 | 2020-10-23 | Chaffee | Colorado | 8015 | 381 | 20 |
654611 | 654611 | 2020-10-22 | Chaffee | Colorado | 8015 | 375 | 20 |
651366 | 651366 | 2020-10-21 | Chaffee | Colorado | 8015 | 374 | 20 |
648122 | 648122 | 2020-10-20 | Chaffee | Colorado | 8015 | 373 | 20 |
644877 | 644877 | 2020-10-19 | Chaffee | Colorado | 8015 | 372 | 20 |
641629 | 641629 | 2020-10-18 | Chaffee | Colorado | 8015 | 370 | 20 |
638382 | 638382 | 2020-10-17 | Chaffee | Colorado | 8015 | 369 | 20 |
635137 | 635137 | 2020-10-16 | Chaffee | Colorado | 8015 | 359 | 20 |
631891 | 631891 | 2020-10-15 | Chaffee | Colorado | 8015 | 358 | 20 |
628647 | 628647 | 2020-10-14 | Chaffee | Colorado | 8015 | 358 | 20 |
625404 | 625404 | 2020-10-13 | Chaffee | Colorado | 8015 | 358 | 20 |
622161 | 622161 | 2020-10-12 | Chaffee | Colorado | 8015 | 357 | 20 |
618918 | 618918 | 2020-10-11 | Chaffee | Colorado | 8015 | 356 | 20 |
615676 | 615676 | 2020-10-10 | Chaffee | Colorado | 8015 | 356 | 20 |
612435 | 612435 | 2020-10-09 | Chaffee | Colorado | 8015 | 350 | 20 |
609193 | 609193 | 2020-10-08 | Chaffee | Colorado | 8015 | 350 | 20 |
605950 | 605950 | 2020-10-07 | Chaffee | Colorado | 8015 | 344 | 20 |
602708 | 602708 | 2020-10-06 | Chaffee | Colorado | 8015 | 340 | 20 |
599465 | 599465 | 2020-10-05 | Chaffee | Colorado | 8015 | 337 | 20 |
596222 | 596222 | 2020-10-04 | Chaffee | Colorado | 8015 | 337 | 20 |
271599 | 271599 | 2020-06-25 | Chaffee | Colorado | 8015 | 78 | 20 |
268464 | 268464 | 2020-06-24 | Chaffee | Colorado | 8015 | 78 | 20 |
265334 | 265334 | 2020-06-23 | Chaffee | Colorado | 8015 | 78 | 20 |
262206 | 262206 | 2020-06-22 | Chaffee | Colorado | 8015 | 78 | 20 |
259079 | 259079 | 2020-06-21 | Chaffee | Colorado | 8015 | 78 | 20 |
255952 | 255952 | 2020-06-20 | Chaffee | Colorado | 8015 | 78 | 20 |
252833 | 252833 | 2020-06-19 | Chaffee | Colorado | 8015 | 78 | 20 |
249718 | 249718 | 2020-06-18 | Chaffee | Colorado | 8015 | 78 | 20 |
246606 | 246606 | 2020-06-17 | Chaffee | Colorado | 8015 | 78 | 20 |
243493 | 243493 | 2020-06-16 | Chaffee | Colorado | 8015 | 78 | 20 |
240382 | 240382 | 2020-06-15 | Chaffee | Colorado | 8015 | 78 | 20 |
237274 | 237274 | 2020-06-14 | Chaffee | Colorado | 8015 | 78 | 20 |
234167 | 234167 | 2020-06-13 | Chaffee | Colorado | 8015 | 78 | 20 |
231061 | 231061 | 2020-06-12 | Chaffee | Colorado | 8015 | 78 | 20 |
227958 | 227958 | 2020-06-11 | Chaffee | Colorado | 8015 | 78 | 20 |
224856 | 224856 | 2020-06-10 | Chaffee | Colorado | 8015 | 78 | 20 |
221761 | 221761 | 2020-06-09 | Chaffee | Colorado | 8015 | 78 | 20 |
218666 | 218666 | 2020-06-08 | Chaffee | Colorado | 8015 | 78 | 20 |
215575 | 215575 | 2020-06-07 | Chaffee | Colorado | 8015 | 78 | 20 |
212488 | 212488 | 2020-06-06 | Chaffee | Colorado | 8015 | 78 | 20 |
209403 | 209403 | 2020-06-05 | Chaffee | Colorado | 8015 | 77 | 20 |
206322 | 206322 | 2020-06-04 | Chaffee | Colorado | 8015 | 76 | 20 |
203242 | 203242 | 2020-06-03 | Chaffee | Colorado | 8015 | 76 | 20 |
200166 | 200166 | 2020-06-02 | Chaffee | Colorado | 8015 | 77 | 20 |
197093 | 197093 | 2020-06-01 | Chaffee | Colorado | 8015 | 76 | 20 |
194023 | 194023 | 2020-05-31 | Chaffee | Colorado | 8015 | 72 | 20 |
190956 | 190956 | 2020-05-30 | Chaffee | Colorado | 8015 | 72 | 20 |
187891 | 187891 | 2020-05-29 | Chaffee | Colorado | 8015 | 72 | 20 |
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);