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 |
---|---|---|---|---|---|---|---|
1053777 | 1053777 | 2021-02-22 | Hinsdale | Colorado | 8053 | 16 | 0 |
1050530 | 1050530 | 2021-02-21 | Hinsdale | Colorado | 8053 | 16 | 0 |
1047283 | 1047283 | 2021-02-20 | Hinsdale | Colorado | 8053 | 17 | 0 |
1044038 | 1044038 | 2021-02-19 | Hinsdale | Colorado | 8053 | 17 | 0 |
1040793 | 1040793 | 2021-02-18 | Hinsdale | Colorado | 8053 | 17 | 0 |
1037548 | 1037548 | 2021-02-17 | Hinsdale | Colorado | 8053 | 16 | 0 |
1034303 | 1034303 | 2021-02-16 | Hinsdale | Colorado | 8053 | 16 | 0 |
1031057 | 1031057 | 2021-02-15 | Hinsdale | Colorado | 8053 | 17 | 0 |
1027810 | 1027810 | 2021-02-14 | Hinsdale | Colorado | 8053 | 16 | 0 |
1024565 | 1024565 | 2021-02-13 | Hinsdale | Colorado | 8053 | 16 | 0 |
1021320 | 1021320 | 2021-02-12 | Hinsdale | Colorado | 8053 | 16 | 0 |
1018075 | 1018075 | 2021-02-11 | Hinsdale | Colorado | 8053 | 16 | 0 |
1014830 | 1014830 | 2021-02-10 | Hinsdale | Colorado | 8053 | 17 | 0 |
1011585 | 1011585 | 2021-02-09 | Hinsdale | Colorado | 8053 | 16 | 0 |
1008339 | 1008339 | 2021-02-08 | Hinsdale | Colorado | 8053 | 15 | 0 |
1005093 | 1005093 | 2021-02-07 | Hinsdale | Colorado | 8053 | 16 | 0 |
1001847 | 1001847 | 2021-02-06 | Hinsdale | Colorado | 8053 | 15 | 0 |
998601 | 998601 | 2021-02-05 | Hinsdale | Colorado | 8053 | 15 | 0 |
995355 | 995355 | 2021-02-04 | Hinsdale | Colorado | 8053 | 16 | 0 |
992109 | 992109 | 2021-02-03 | Hinsdale | Colorado | 8053 | 15 | 0 |
988863 | 988863 | 2021-02-02 | Hinsdale | Colorado | 8053 | 16 | 0 |
985616 | 985616 | 2021-02-01 | Hinsdale | Colorado | 8053 | 15 | 0 |
982369 | 982369 | 2021-01-31 | Hinsdale | Colorado | 8053 | 16 | 0 |
979123 | 979123 | 2021-01-30 | Hinsdale | Colorado | 8053 | 16 | 0 |
975878 | 975878 | 2021-01-29 | Hinsdale | Colorado | 8053 | 16 | 0 |
972633 | 972633 | 2021-01-28 | Hinsdale | Colorado | 8053 | 15 | 0 |
969388 | 969388 | 2021-01-27 | Hinsdale | Colorado | 8053 | 16 | 0 |
966144 | 966144 | 2021-01-26 | Hinsdale | Colorado | 8053 | 15 | 0 |
962899 | 962899 | 2021-01-25 | Hinsdale | Colorado | 8053 | 15 | 0 |
959654 | 959654 | 2021-01-24 | Hinsdale | Colorado | 8053 | 15 | 0 |
956408 | 956408 | 2021-01-23 | Hinsdale | Colorado | 8053 | 16 | 0 |
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 |
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);