ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
161 rows where deaths = 4 and fips = 8117 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 |
---|---|---|---|---|---|---|---|
810397 | 810397 | 2020-12-09 | Summit | Colorado | 8117 | 1752 | 4 |
807152 | 807152 | 2020-12-08 | Summit | Colorado | 8117 | 1739 | 4 |
803907 | 803907 | 2020-12-07 | Summit | Colorado | 8117 | 1714 | 4 |
800662 | 800662 | 2020-12-06 | Summit | Colorado | 8117 | 1698 | 4 |
797417 | 797417 | 2020-12-05 | Summit | Colorado | 8117 | 1677 | 4 |
794172 | 794172 | 2020-12-04 | Summit | Colorado | 8117 | 1646 | 4 |
790927 | 790927 | 2020-12-03 | Summit | Colorado | 8117 | 1621 | 4 |
787682 | 787682 | 2020-12-02 | Summit | Colorado | 8117 | 1582 | 4 |
784438 | 784438 | 2020-12-01 | Summit | Colorado | 8117 | 1553 | 4 |
781193 | 781193 | 2020-11-30 | Summit | Colorado | 8117 | 1517 | 4 |
777947 | 777947 | 2020-11-29 | Summit | Colorado | 8117 | 1488 | 4 |
774702 | 774702 | 2020-11-28 | Summit | Colorado | 8117 | 1469 | 4 |
771457 | 771457 | 2020-11-27 | Summit | Colorado | 8117 | 1451 | 4 |
768212 | 768212 | 2020-11-26 | Summit | Colorado | 8117 | 1426 | 4 |
764966 | 764966 | 2020-11-25 | Summit | Colorado | 8117 | 1392 | 4 |
761721 | 761721 | 2020-11-24 | Summit | Colorado | 8117 | 1366 | 4 |
758476 | 758476 | 2020-11-23 | Summit | Colorado | 8117 | 1344 | 4 |
755229 | 755229 | 2020-11-22 | Summit | Colorado | 8117 | 1330 | 4 |
751983 | 751983 | 2020-11-21 | Summit | Colorado | 8117 | 1287 | 4 |
748737 | 748737 | 2020-11-20 | Summit | Colorado | 8117 | 1242 | 4 |
745491 | 745491 | 2020-11-19 | Summit | Colorado | 8117 | 1230 | 4 |
742244 | 742244 | 2020-11-18 | Summit | Colorado | 8117 | 1189 | 4 |
738997 | 738997 | 2020-11-17 | Summit | Colorado | 8117 | 1174 | 4 |
735753 | 735753 | 2020-11-16 | Summit | Colorado | 8117 | 1150 | 4 |
732507 | 732507 | 2020-11-15 | Summit | Colorado | 8117 | 1129 | 4 |
729262 | 729262 | 2020-11-14 | Summit | Colorado | 8117 | 1116 | 4 |
726019 | 726019 | 2020-11-13 | Summit | Colorado | 8117 | 1094 | 4 |
722776 | 722776 | 2020-11-12 | Summit | Colorado | 8117 | 1058 | 4 |
719533 | 719533 | 2020-11-11 | Summit | Colorado | 8117 | 1031 | 4 |
716290 | 716290 | 2020-11-10 | Summit | Colorado | 8117 | 1024 | 4 |
713046 | 713046 | 2020-11-09 | Summit | Colorado | 8117 | 979 | 4 |
709802 | 709802 | 2020-11-08 | Summit | Colorado | 8117 | 962 | 4 |
706558 | 706558 | 2020-11-07 | Summit | Colorado | 8117 | 937 | 4 |
703315 | 703315 | 2020-11-06 | Summit | Colorado | 8117 | 904 | 4 |
700072 | 700072 | 2020-11-05 | Summit | Colorado | 8117 | 874 | 4 |
696828 | 696828 | 2020-11-04 | Summit | Colorado | 8117 | 858 | 4 |
693586 | 693586 | 2020-11-03 | Summit | Colorado | 8117 | 827 | 4 |
690343 | 690343 | 2020-11-02 | Summit | Colorado | 8117 | 800 | 4 |
687098 | 687098 | 2020-11-01 | Summit | Colorado | 8117 | 779 | 4 |
683854 | 683854 | 2020-10-31 | Summit | Colorado | 8117 | 753 | 4 |
680611 | 680611 | 2020-10-30 | Summit | Colorado | 8117 | 751 | 4 |
677368 | 677368 | 2020-10-29 | Summit | Colorado | 8117 | 731 | 4 |
674125 | 674125 | 2020-10-28 | Summit | Colorado | 8117 | 719 | 4 |
670883 | 670883 | 2020-10-27 | Summit | Colorado | 8117 | 696 | 4 |
667640 | 667640 | 2020-10-26 | Summit | Colorado | 8117 | 679 | 4 |
664395 | 664395 | 2020-10-25 | Summit | Colorado | 8117 | 667 | 4 |
661151 | 661151 | 2020-10-24 | Summit | Colorado | 8117 | 653 | 4 |
657907 | 657907 | 2020-10-23 | Summit | Colorado | 8117 | 636 | 4 |
654662 | 654662 | 2020-10-22 | Summit | Colorado | 8117 | 621 | 4 |
651417 | 651417 | 2020-10-21 | Summit | Colorado | 8117 | 605 | 4 |
648173 | 648173 | 2020-10-20 | Summit | Colorado | 8117 | 593 | 4 |
644928 | 644928 | 2020-10-19 | Summit | Colorado | 8117 | 567 | 4 |
641680 | 641680 | 2020-10-18 | Summit | Colorado | 8117 | 563 | 4 |
638433 | 638433 | 2020-10-17 | Summit | Colorado | 8117 | 549 | 4 |
635188 | 635188 | 2020-10-16 | Summit | Colorado | 8117 | 540 | 4 |
631942 | 631942 | 2020-10-15 | Summit | Colorado | 8117 | 537 | 4 |
628698 | 628698 | 2020-10-14 | Summit | Colorado | 8117 | 529 | 4 |
625455 | 625455 | 2020-10-13 | Summit | Colorado | 8117 | 525 | 4 |
622212 | 622212 | 2020-10-12 | Summit | Colorado | 8117 | 523 | 4 |
618969 | 618969 | 2020-10-11 | Summit | Colorado | 8117 | 517 | 4 |
615727 | 615727 | 2020-10-10 | Summit | Colorado | 8117 | 516 | 4 |
612486 | 612486 | 2020-10-09 | Summit | Colorado | 8117 | 512 | 4 |
609244 | 609244 | 2020-10-08 | Summit | Colorado | 8117 | 505 | 4 |
606001 | 606001 | 2020-10-07 | Summit | Colorado | 8117 | 500 | 4 |
602759 | 602759 | 2020-10-06 | Summit | Colorado | 8117 | 492 | 4 |
599516 | 599516 | 2020-10-05 | Summit | Colorado | 8117 | 489 | 4 |
596273 | 596273 | 2020-10-04 | Summit | Colorado | 8117 | 487 | 4 |
593031 | 593031 | 2020-10-03 | Summit | Colorado | 8117 | 479 | 4 |
589791 | 589791 | 2020-10-02 | Summit | Colorado | 8117 | 473 | 4 |
586550 | 586550 | 2020-10-01 | Summit | Colorado | 8117 | 471 | 4 |
583310 | 583310 | 2020-09-30 | Summit | Colorado | 8117 | 465 | 4 |
580071 | 580071 | 2020-09-29 | Summit | Colorado | 8117 | 463 | 4 |
576830 | 576830 | 2020-09-28 | Summit | Colorado | 8117 | 463 | 4 |
573587 | 573587 | 2020-09-27 | Summit | Colorado | 8117 | 462 | 4 |
570345 | 570345 | 2020-09-26 | Summit | Colorado | 8117 | 458 | 4 |
567103 | 567103 | 2020-09-25 | Summit | Colorado | 8117 | 451 | 4 |
563863 | 563863 | 2020-09-24 | Summit | Colorado | 8117 | 447 | 4 |
560623 | 560623 | 2020-09-23 | Summit | Colorado | 8117 | 428 | 4 |
557387 | 557387 | 2020-09-22 | Summit | Colorado | 8117 | 422 | 4 |
554150 | 554150 | 2020-09-21 | Summit | Colorado | 8117 | 423 | 4 |
550911 | 550911 | 2020-09-20 | Summit | Colorado | 8117 | 423 | 4 |
547672 | 547672 | 2020-09-19 | Summit | Colorado | 8117 | 417 | 4 |
544434 | 544434 | 2020-09-18 | Summit | Colorado | 8117 | 408 | 4 |
541198 | 541198 | 2020-09-17 | Summit | Colorado | 8117 | 403 | 4 |
537961 | 537961 | 2020-09-16 | Summit | Colorado | 8117 | 391 | 4 |
534725 | 534725 | 2020-09-15 | Summit | Colorado | 8117 | 377 | 4 |
531490 | 531490 | 2020-09-14 | Summit | Colorado | 8117 | 376 | 4 |
528253 | 528253 | 2020-09-13 | Summit | Colorado | 8117 | 372 | 4 |
525017 | 525017 | 2020-09-12 | Summit | Colorado | 8117 | 370 | 4 |
521781 | 521781 | 2020-09-11 | Summit | Colorado | 8117 | 370 | 4 |
518544 | 518544 | 2020-09-10 | Summit | Colorado | 8117 | 368 | 4 |
515309 | 515309 | 2020-09-09 | Summit | Colorado | 8117 | 368 | 4 |
512076 | 512076 | 2020-09-08 | Summit | Colorado | 8117 | 368 | 4 |
508843 | 508843 | 2020-09-07 | Summit | Colorado | 8117 | 366 | 4 |
505611 | 505611 | 2020-09-06 | Summit | Colorado | 8117 | 366 | 4 |
502377 | 502377 | 2020-09-05 | Summit | Colorado | 8117 | 366 | 4 |
499143 | 499143 | 2020-09-04 | Summit | Colorado | 8117 | 366 | 4 |
495910 | 495910 | 2020-09-03 | Summit | Colorado | 8117 | 365 | 4 |
492676 | 492676 | 2020-09-02 | Summit | Colorado | 8117 | 365 | 4 |
489443 | 489443 | 2020-09-01 | Summit | Colorado | 8117 | 364 | 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);