ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Hinsdale" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
953163 | 953163 | 2021-01-22 | Hinsdale | Colorado | 8053 | 15 | 0 |
949918 | 949918 | 2021-01-21 | Hinsdale | Colorado | 8053 | 16 | 0 |
946672 | 946672 | 2021-01-20 | Hinsdale | Colorado | 8053 | 15 | 0 |
943425 | 943425 | 2021-01-19 | Hinsdale | Colorado | 8053 | 16 | 0 |
940180 | 940180 | 2021-01-18 | Hinsdale | Colorado | 8053 | 15 | 0 |
936935 | 936935 | 2021-01-17 | Hinsdale | Colorado | 8053 | 15 | 0 |
933690 | 933690 | 2021-01-16 | Hinsdale | Colorado | 8053 | 15 | 0 |
930445 | 930445 | 2021-01-15 | Hinsdale | Colorado | 8053 | 15 | 0 |
927200 | 927200 | 2021-01-14 | Hinsdale | Colorado | 8053 | 16 | 0 |
923954 | 923954 | 2021-01-13 | Hinsdale | Colorado | 8053 | 16 | 0 |
920709 | 920709 | 2021-01-12 | Hinsdale | Colorado | 8053 | 15 | 0 |
917464 | 917464 | 2021-01-11 | Hinsdale | Colorado | 8053 | 15 | 0 |
914219 | 914219 | 2021-01-10 | Hinsdale | Colorado | 8053 | 15 | 0 |
910974 | 910974 | 2021-01-09 | Hinsdale | Colorado | 8053 | 15 | 0 |
907729 | 907729 | 2021-01-08 | Hinsdale | Colorado | 8053 | 15 | 0 |
904483 | 904483 | 2021-01-07 | Hinsdale | Colorado | 8053 | 15 | 0 |
901238 | 901238 | 2021-01-06 | Hinsdale | Colorado | 8053 | 14 | 0 |
897993 | 897993 | 2021-01-05 | Hinsdale | Colorado | 8053 | 14 | 0 |
894748 | 894748 | 2021-01-04 | Hinsdale | Colorado | 8053 | 14 | 0 |
891501 | 891501 | 2021-01-03 | Hinsdale | Colorado | 8053 | 14 | 0 |
888254 | 888254 | 2021-01-02 | Hinsdale | Colorado | 8053 | 14 | 0 |
885009 | 885009 | 2021-01-01 | Hinsdale | Colorado | 8053 | 14 | 0 |
881764 | 881764 | 2020-12-31 | Hinsdale | Colorado | 8053 | 13 | 0 |
878519 | 878519 | 2020-12-30 | Hinsdale | Colorado | 8053 | 12 | 0 |
875274 | 875274 | 2020-12-29 | Hinsdale | Colorado | 8053 | 12 | 0 |
872029 | 872029 | 2020-12-28 | Hinsdale | Colorado | 8053 | 12 | 0 |
868784 | 868784 | 2020-12-27 | Hinsdale | Colorado | 8053 | 12 | 0 |
865539 | 865539 | 2020-12-26 | Hinsdale | Colorado | 8053 | 12 | 0 |
862294 | 862294 | 2020-12-25 | Hinsdale | Colorado | 8053 | 12 | 0 |
859049 | 859049 | 2020-12-24 | Hinsdale | Colorado | 8053 | 12 | 0 |
855804 | 855804 | 2020-12-23 | Hinsdale | Colorado | 8053 | 12 | 0 |
852559 | 852559 | 2020-12-22 | Hinsdale | Colorado | 8053 | 12 | 0 |
849314 | 849314 | 2020-12-21 | Hinsdale | Colorado | 8053 | 12 | 0 |
846069 | 846069 | 2020-12-20 | Hinsdale | Colorado | 8053 | 12 | 0 |
842823 | 842823 | 2020-12-19 | Hinsdale | Colorado | 8053 | 12 | 0 |
839578 | 839578 | 2020-12-18 | Hinsdale | Colorado | 8053 | 12 | 0 |
836333 | 836333 | 2020-12-17 | Hinsdale | Colorado | 8053 | 12 | 0 |
833087 | 833087 | 2020-12-16 | Hinsdale | Colorado | 8053 | 12 | 0 |
829840 | 829840 | 2020-12-15 | Hinsdale | Colorado | 8053 | 12 | 0 |
826594 | 826594 | 2020-12-14 | Hinsdale | Colorado | 8053 | 12 | 0 |
823347 | 823347 | 2020-12-13 | Hinsdale | Colorado | 8053 | 12 | 0 |
820101 | 820101 | 2020-12-12 | Hinsdale | Colorado | 8053 | 12 | 0 |
816855 | 816855 | 2020-12-11 | Hinsdale | Colorado | 8053 | 12 | 0 |
813609 | 813609 | 2020-12-10 | Hinsdale | Colorado | 8053 | 11 | 0 |
810365 | 810365 | 2020-12-09 | Hinsdale | Colorado | 8053 | 10 | 0 |
807120 | 807120 | 2020-12-08 | Hinsdale | Colorado | 8053 | 10 | 0 |
803875 | 803875 | 2020-12-07 | Hinsdale | Colorado | 8053 | 10 | 0 |
800630 | 800630 | 2020-12-06 | Hinsdale | Colorado | 8053 | 10 | 0 |
797385 | 797385 | 2020-12-05 | Hinsdale | Colorado | 8053 | 10 | 0 |
794140 | 794140 | 2020-12-04 | Hinsdale | Colorado | 8053 | 10 | 0 |
790895 | 790895 | 2020-12-03 | Hinsdale | Colorado | 8053 | 9 | 0 |
787650 | 787650 | 2020-12-02 | Hinsdale | Colorado | 8053 | 9 | 0 |
784406 | 784406 | 2020-12-01 | Hinsdale | Colorado | 8053 | 8 | 0 |
781161 | 781161 | 2020-11-30 | Hinsdale | Colorado | 8053 | 8 | 0 |
777915 | 777915 | 2020-11-29 | Hinsdale | Colorado | 8053 | 9 | 0 |
774670 | 774670 | 2020-11-28 | Hinsdale | Colorado | 8053 | 9 | 0 |
771425 | 771425 | 2020-11-27 | Hinsdale | Colorado | 8053 | 9 | 0 |
768180 | 768180 | 2020-11-26 | Hinsdale | Colorado | 8053 | 9 | 0 |
764934 | 764934 | 2020-11-25 | Hinsdale | Colorado | 8053 | 8 | 0 |
761689 | 761689 | 2020-11-24 | Hinsdale | Colorado | 8053 | 7 | 0 |
758444 | 758444 | 2020-11-23 | Hinsdale | Colorado | 8053 | 7 | 0 |
755197 | 755197 | 2020-11-22 | Hinsdale | Colorado | 8053 | 8 | 0 |
751951 | 751951 | 2020-11-21 | Hinsdale | Colorado | 8053 | 6 | 0 |
748705 | 748705 | 2020-11-20 | Hinsdale | Colorado | 8053 | 6 | 0 |
745459 | 745459 | 2020-11-19 | Hinsdale | Colorado | 8053 | 6 | 0 |
742212 | 742212 | 2020-11-18 | Hinsdale | Colorado | 8053 | 6 | 0 |
738965 | 738965 | 2020-11-17 | Hinsdale | Colorado | 8053 | 6 | 0 |
735721 | 735721 | 2020-11-16 | Hinsdale | Colorado | 8053 | 5 | 0 |
732475 | 732475 | 2020-11-15 | Hinsdale | Colorado | 8053 | 4 | 0 |
729230 | 729230 | 2020-11-14 | Hinsdale | Colorado | 8053 | 5 | 0 |
725987 | 725987 | 2020-11-13 | Hinsdale | Colorado | 8053 | 5 | 0 |
722744 | 722744 | 2020-11-12 | Hinsdale | Colorado | 8053 | 5 | 0 |
719501 | 719501 | 2020-11-11 | Hinsdale | Colorado | 8053 | 5 | 0 |
716258 | 716258 | 2020-11-10 | Hinsdale | Colorado | 8053 | 4 | 0 |
713014 | 713014 | 2020-11-09 | Hinsdale | Colorado | 8053 | 4 | 0 |
709770 | 709770 | 2020-11-08 | Hinsdale | Colorado | 8053 | 4 | 0 |
706526 | 706526 | 2020-11-07 | Hinsdale | Colorado | 8053 | 4 | 0 |
703283 | 703283 | 2020-11-06 | Hinsdale | Colorado | 8053 | 4 | 0 |
700040 | 700040 | 2020-11-05 | Hinsdale | Colorado | 8053 | 4 | 0 |
696796 | 696796 | 2020-11-04 | Hinsdale | Colorado | 8053 | 4 | 0 |
693554 | 693554 | 2020-11-03 | Hinsdale | Colorado | 8053 | 4 | 0 |
690311 | 690311 | 2020-11-02 | Hinsdale | Colorado | 8053 | 4 | 0 |
687066 | 687066 | 2020-11-01 | Hinsdale | Colorado | 8053 | 4 | 0 |
683822 | 683822 | 2020-10-31 | Hinsdale | Colorado | 8053 | 4 | 0 |
680579 | 680579 | 2020-10-30 | Hinsdale | Colorado | 8053 | 3 | 0 |
677336 | 677336 | 2020-10-29 | Hinsdale | Colorado | 8053 | 3 | 0 |
674093 | 674093 | 2020-10-28 | Hinsdale | Colorado | 8053 | 3 | 0 |
670851 | 670851 | 2020-10-27 | Hinsdale | Colorado | 8053 | 3 | 0 |
667608 | 667608 | 2020-10-26 | Hinsdale | Colorado | 8053 | 3 | 0 |
664363 | 664363 | 2020-10-25 | Hinsdale | Colorado | 8053 | 3 | 0 |
661119 | 661119 | 2020-10-24 | Hinsdale | Colorado | 8053 | 3 | 0 |
657875 | 657875 | 2020-10-23 | Hinsdale | Colorado | 8053 | 3 | 0 |
654630 | 654630 | 2020-10-22 | Hinsdale | Colorado | 8053 | 3 | 0 |
651385 | 651385 | 2020-10-21 | Hinsdale | Colorado | 8053 | 3 | 0 |
648141 | 648141 | 2020-10-20 | Hinsdale | Colorado | 8053 | 3 | 0 |
644896 | 644896 | 2020-10-19 | Hinsdale | Colorado | 8053 | 3 | 0 |
641648 | 641648 | 2020-10-18 | Hinsdale | Colorado | 8053 | 3 | 0 |
638401 | 638401 | 2020-10-17 | Hinsdale | Colorado | 8053 | 3 | 0 |
635156 | 635156 | 2020-10-16 | Hinsdale | Colorado | 8053 | 3 | 0 |
631910 | 631910 | 2020-10-15 | Hinsdale | Colorado | 8053 | 3 | 0 |
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);