ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Elbert" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
953157 | 953157 | 2021-01-22 | Elbert | Colorado | 8039 | 1106 | 12 |
949912 | 949912 | 2021-01-21 | Elbert | Colorado | 8039 | 1103 | 12 |
946666 | 946666 | 2021-01-20 | Elbert | Colorado | 8039 | 1099 | 12 |
943419 | 943419 | 2021-01-19 | Elbert | Colorado | 8039 | 1094 | 12 |
940174 | 940174 | 2021-01-18 | Elbert | Colorado | 8039 | 1090 | 12 |
936929 | 936929 | 2021-01-17 | Elbert | Colorado | 8039 | 1085 | 12 |
933684 | 933684 | 2021-01-16 | Elbert | Colorado | 8039 | 1083 | 12 |
930439 | 930439 | 2021-01-15 | Elbert | Colorado | 8039 | 1080 | 12 |
927194 | 927194 | 2021-01-14 | Elbert | Colorado | 8039 | 1080 | 12 |
923948 | 923948 | 2021-01-13 | Elbert | Colorado | 8039 | 1074 | 12 |
920703 | 920703 | 2021-01-12 | Elbert | Colorado | 8039 | 1072 | 12 |
917458 | 917458 | 2021-01-11 | Elbert | Colorado | 8039 | 1069 | 11 |
914213 | 914213 | 2021-01-10 | Elbert | Colorado | 8039 | 1062 | 11 |
910968 | 910968 | 2021-01-09 | Elbert | Colorado | 8039 | 1055 | 11 |
907723 | 907723 | 2021-01-08 | Elbert | Colorado | 8039 | 1048 | 11 |
904477 | 904477 | 2021-01-07 | Elbert | Colorado | 8039 | 1043 | 11 |
901232 | 901232 | 2021-01-06 | Elbert | Colorado | 8039 | 1028 | 10 |
897987 | 897987 | 2021-01-05 | Elbert | Colorado | 8039 | 1028 | 10 |
894742 | 894742 | 2021-01-04 | Elbert | Colorado | 8039 | 1012 | 10 |
891495 | 891495 | 2021-01-03 | Elbert | Colorado | 8039 | 1006 | 10 |
888248 | 888248 | 2021-01-02 | Elbert | Colorado | 8039 | 1002 | 10 |
885003 | 885003 | 2021-01-01 | Elbert | Colorado | 8039 | 996 | 10 |
881758 | 881758 | 2020-12-31 | Elbert | Colorado | 8039 | 987 | 9 |
878513 | 878513 | 2020-12-30 | Elbert | Colorado | 8039 | 969 | 9 |
875268 | 875268 | 2020-12-29 | Elbert | Colorado | 8039 | 964 | 8 |
872023 | 872023 | 2020-12-28 | Elbert | Colorado | 8039 | 959 | 8 |
868778 | 868778 | 2020-12-27 | Elbert | Colorado | 8039 | 955 | 8 |
865533 | 865533 | 2020-12-26 | Elbert | Colorado | 8039 | 954 | 8 |
862288 | 862288 | 2020-12-25 | Elbert | Colorado | 8039 | 950 | 8 |
859043 | 859043 | 2020-12-24 | Elbert | Colorado | 8039 | 942 | 8 |
855798 | 855798 | 2020-12-23 | Elbert | Colorado | 8039 | 931 | 8 |
852553 | 852553 | 2020-12-22 | Elbert | Colorado | 8039 | 912 | 7 |
849308 | 849308 | 2020-12-21 | Elbert | Colorado | 8039 | 901 | 7 |
846063 | 846063 | 2020-12-20 | Elbert | Colorado | 8039 | 893 | 7 |
842817 | 842817 | 2020-12-19 | Elbert | Colorado | 8039 | 885 | 7 |
839572 | 839572 | 2020-12-18 | Elbert | Colorado | 8039 | 857 | 6 |
836327 | 836327 | 2020-12-17 | Elbert | Colorado | 8039 | 849 | 6 |
833081 | 833081 | 2020-12-16 | Elbert | Colorado | 8039 | 841 | 5 |
829834 | 829834 | 2020-12-15 | Elbert | Colorado | 8039 | 835 | 5 |
826588 | 826588 | 2020-12-14 | Elbert | Colorado | 8039 | 817 | 5 |
823341 | 823341 | 2020-12-13 | Elbert | Colorado | 8039 | 817 | 5 |
820095 | 820095 | 2020-12-12 | Elbert | Colorado | 8039 | 806 | 5 |
816849 | 816849 | 2020-12-11 | Elbert | Colorado | 8039 | 790 | 5 |
813603 | 813603 | 2020-12-10 | Elbert | Colorado | 8039 | 775 | 5 |
810359 | 810359 | 2020-12-09 | Elbert | Colorado | 8039 | 759 | 5 |
807114 | 807114 | 2020-12-08 | Elbert | Colorado | 8039 | 747 | 5 |
803869 | 803869 | 2020-12-07 | Elbert | Colorado | 8039 | 735 | 5 |
800624 | 800624 | 2020-12-06 | Elbert | Colorado | 8039 | 709 | 5 |
797379 | 797379 | 2020-12-05 | Elbert | Colorado | 8039 | 695 | 5 |
794134 | 794134 | 2020-12-04 | Elbert | Colorado | 8039 | 676 | 5 |
790889 | 790889 | 2020-12-03 | Elbert | Colorado | 8039 | 650 | 5 |
787644 | 787644 | 2020-12-02 | Elbert | Colorado | 8039 | 633 | 5 |
784400 | 784400 | 2020-12-01 | Elbert | Colorado | 8039 | 624 | 5 |
781155 | 781155 | 2020-11-30 | Elbert | Colorado | 8039 | 608 | 5 |
777909 | 777909 | 2020-11-29 | Elbert | Colorado | 8039 | 596 | 5 |
774664 | 774664 | 2020-11-28 | Elbert | Colorado | 8039 | 583 | 5 |
771419 | 771419 | 2020-11-27 | Elbert | Colorado | 8039 | 570 | 5 |
768174 | 768174 | 2020-11-26 | Elbert | Colorado | 8039 | 557 | 5 |
764928 | 764928 | 2020-11-25 | Elbert | Colorado | 8039 | 540 | 5 |
761683 | 761683 | 2020-11-24 | Elbert | Colorado | 8039 | 534 | 5 |
758438 | 758438 | 2020-11-23 | Elbert | Colorado | 8039 | 526 | 5 |
755191 | 755191 | 2020-11-22 | Elbert | Colorado | 8039 | 515 | 5 |
751945 | 751945 | 2020-11-21 | Elbert | Colorado | 8039 | 503 | 5 |
748699 | 748699 | 2020-11-20 | Elbert | Colorado | 8039 | 475 | 5 |
745453 | 745453 | 2020-11-19 | Elbert | Colorado | 8039 | 447 | 5 |
742206 | 742206 | 2020-11-18 | Elbert | Colorado | 8039 | 431 | 4 |
738959 | 738959 | 2020-11-17 | Elbert | Colorado | 8039 | 419 | 4 |
735715 | 735715 | 2020-11-16 | Elbert | Colorado | 8039 | 406 | 4 |
732469 | 732469 | 2020-11-15 | Elbert | Colorado | 8039 | 392 | 4 |
729224 | 729224 | 2020-11-14 | Elbert | Colorado | 8039 | 371 | 4 |
725981 | 725981 | 2020-11-13 | Elbert | Colorado | 8039 | 361 | 3 |
722738 | 722738 | 2020-11-12 | Elbert | Colorado | 8039 | 347 | 3 |
719495 | 719495 | 2020-11-11 | Elbert | Colorado | 8039 | 335 | 3 |
716252 | 716252 | 2020-11-10 | Elbert | Colorado | 8039 | 325 | 3 |
713008 | 713008 | 2020-11-09 | Elbert | Colorado | 8039 | 314 | 3 |
709764 | 709764 | 2020-11-08 | Elbert | Colorado | 8039 | 304 | 3 |
706520 | 706520 | 2020-11-07 | Elbert | Colorado | 8039 | 292 | 3 |
703277 | 703277 | 2020-11-06 | Elbert | Colorado | 8039 | 282 | 3 |
700034 | 700034 | 2020-11-05 | Elbert | Colorado | 8039 | 274 | 3 |
696790 | 696790 | 2020-11-04 | Elbert | Colorado | 8039 | 268 | 3 |
693548 | 693548 | 2020-11-03 | Elbert | Colorado | 8039 | 261 | 3 |
690305 | 690305 | 2020-11-02 | Elbert | Colorado | 8039 | 254 | 3 |
687060 | 687060 | 2020-11-01 | Elbert | Colorado | 8039 | 246 | 3 |
683816 | 683816 | 2020-10-31 | Elbert | Colorado | 8039 | 242 | 3 |
680573 | 680573 | 2020-10-30 | Elbert | Colorado | 8039 | 232 | 3 |
677330 | 677330 | 2020-10-29 | Elbert | Colorado | 8039 | 226 | 3 |
674087 | 674087 | 2020-10-28 | Elbert | Colorado | 8039 | 224 | 3 |
670845 | 670845 | 2020-10-27 | Elbert | Colorado | 8039 | 219 | 3 |
667602 | 667602 | 2020-10-26 | Elbert | Colorado | 8039 | 215 | 3 |
664357 | 664357 | 2020-10-25 | Elbert | Colorado | 8039 | 204 | 3 |
661113 | 661113 | 2020-10-24 | Elbert | Colorado | 8039 | 200 | 3 |
657869 | 657869 | 2020-10-23 | Elbert | Colorado | 8039 | 193 | 3 |
654624 | 654624 | 2020-10-22 | Elbert | Colorado | 8039 | 191 | 3 |
651379 | 651379 | 2020-10-21 | Elbert | Colorado | 8039 | 190 | 3 |
648135 | 648135 | 2020-10-20 | Elbert | Colorado | 8039 | 184 | 3 |
644890 | 644890 | 2020-10-19 | Elbert | Colorado | 8039 | 183 | 3 |
641642 | 641642 | 2020-10-18 | Elbert | Colorado | 8039 | 180 | 3 |
638395 | 638395 | 2020-10-17 | Elbert | Colorado | 8039 | 180 | 3 |
635150 | 635150 | 2020-10-16 | Elbert | Colorado | 8039 | 179 | 3 |
631904 | 631904 | 2020-10-15 | Elbert | Colorado | 8039 | 177 | 3 |
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);