ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Hartford" and state = "Connecticut" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053815 | 1053815 | 2021-02-22 | Hartford | Connecticut | 9003 | 69078 | 2258 |
1050568 | 1050568 | 2021-02-21 | Hartford | Connecticut | 9003 | 68527 | 2251 |
1047321 | 1047321 | 2021-02-20 | Hartford | Connecticut | 9003 | 68527 | 2251 |
1044076 | 1044076 | 2021-02-19 | Hartford | Connecticut | 9003 | 68527 | 2251 |
1040831 | 1040831 | 2021-02-18 | Hartford | Connecticut | 9003 | 68277 | 2246 |
1037586 | 1037586 | 2021-02-17 | Hartford | Connecticut | 9003 | 68159 | 2240 |
1034341 | 1034341 | 2021-02-16 | Hartford | Connecticut | 9003 | 68055 | 2236 |
1031095 | 1031095 | 2021-02-15 | Hartford | Connecticut | 9003 | 67994 | 2236 |
1027848 | 1027848 | 2021-02-14 | Hartford | Connecticut | 9003 | 67328 | 2223 |
1024603 | 1024603 | 2021-02-13 | Hartford | Connecticut | 9003 | 67328 | 2223 |
1021358 | 1021358 | 2021-02-12 | Hartford | Connecticut | 9003 | 67328 | 2223 |
1018113 | 1018113 | 2021-02-11 | Hartford | Connecticut | 9003 | 67142 | 2214 |
1014868 | 1014868 | 2021-02-10 | Hartford | Connecticut | 9003 | 66945 | 2208 |
1011623 | 1011623 | 2021-02-09 | Hartford | Connecticut | 9003 | 66761 | 2205 |
1008377 | 1008377 | 2021-02-08 | Hartford | Connecticut | 9003 | 66561 | 2199 |
1005131 | 1005131 | 2021-02-07 | Hartford | Connecticut | 9003 | 65496 | 2178 |
1001885 | 1001885 | 2021-02-06 | Hartford | Connecticut | 9003 | 65496 | 2178 |
998639 | 998639 | 2021-02-05 | Hartford | Connecticut | 9003 | 65496 | 2178 |
995393 | 995393 | 2021-02-04 | Hartford | Connecticut | 9003 | 65172 | 2160 |
992147 | 992147 | 2021-02-03 | Hartford | Connecticut | 9003 | 64924 | 2146 |
988901 | 988901 | 2021-02-02 | Hartford | Connecticut | 9003 | 64818 | 2141 |
985654 | 985654 | 2021-02-01 | Hartford | Connecticut | 9003 | 64265 | 2133 |
982407 | 982407 | 2021-01-31 | Hartford | Connecticut | 9003 | 63211 | 2107 |
979161 | 979161 | 2021-01-30 | Hartford | Connecticut | 9003 | 63211 | 2107 |
975916 | 975916 | 2021-01-29 | Hartford | Connecticut | 9003 | 63211 | 2107 |
972671 | 972671 | 2021-01-28 | Hartford | Connecticut | 9003 | 62913 | 2099 |
969426 | 969426 | 2021-01-27 | Hartford | Connecticut | 9003 | 62520 | 2086 |
966182 | 966182 | 2021-01-26 | Hartford | Connecticut | 9003 | 61904 | 2074 |
962937 | 962937 | 2021-01-25 | Hartford | Connecticut | 9003 | 61606 | 2069 |
959692 | 959692 | 2021-01-24 | Hartford | Connecticut | 9003 | 60027 | 2048 |
956446 | 956446 | 2021-01-23 | Hartford | Connecticut | 9003 | 60027 | 2048 |
953201 | 953201 | 2021-01-22 | Hartford | Connecticut | 9003 | 60027 | 2048 |
949956 | 949956 | 2021-01-21 | Hartford | Connecticut | 9003 | 59573 | 2037 |
946710 | 946710 | 2021-01-20 | Hartford | Connecticut | 9003 | 59147 | 2025 |
943463 | 943463 | 2021-01-19 | Hartford | Connecticut | 9003 | 58705 | 2017 |
940218 | 940218 | 2021-01-18 | Hartford | Connecticut | 9003 | 58134 | 2013 |
936973 | 936973 | 2021-01-17 | Hartford | Connecticut | 9003 | 56292 | 1992 |
933728 | 933728 | 2021-01-16 | Hartford | Connecticut | 9003 | 56292 | 1992 |
930483 | 930483 | 2021-01-15 | Hartford | Connecticut | 9003 | 56292 | 1992 |
927238 | 927238 | 2021-01-14 | Hartford | Connecticut | 9003 | 55926 | 1981 |
923992 | 923992 | 2021-01-13 | Hartford | Connecticut | 9003 | 55710 | 1978 |
920747 | 920747 | 2021-01-12 | Hartford | Connecticut | 9003 | 54900 | 1966 |
917502 | 917502 | 2021-01-11 | Hartford | Connecticut | 9003 | 53892 | 1958 |
914257 | 914257 | 2021-01-10 | Hartford | Connecticut | 9003 | 51890 | 1921 |
911012 | 911012 | 2021-01-09 | Hartford | Connecticut | 9003 | 51890 | 1921 |
907767 | 907767 | 2021-01-08 | Hartford | Connecticut | 9003 | 51890 | 1921 |
904521 | 904521 | 2021-01-07 | Hartford | Connecticut | 9003 | 51050 | 1917 |
901276 | 901276 | 2021-01-06 | Hartford | Connecticut | 9003 | 50223 | 1907 |
898031 | 898031 | 2021-01-05 | Hartford | Connecticut | 9003 | 49560 | 1900 |
894786 | 894786 | 2021-01-04 | Hartford | Connecticut | 9003 | 48913 | 1893 |
891539 | 891539 | 2021-01-03 | Hartford | Connecticut | 9003 | 47726 | 1878 |
888292 | 888292 | 2021-01-02 | Hartford | Connecticut | 9003 | 47726 | 1878 |
885047 | 885047 | 2021-01-01 | Hartford | Connecticut | 9003 | 46680 | 1852 |
881802 | 881802 | 2020-12-31 | Hartford | Connecticut | 9003 | 46680 | 1852 |
878557 | 878557 | 2020-12-30 | Hartford | Connecticut | 9003 | 46201 | 1838 |
875312 | 875312 | 2020-12-29 | Hartford | Connecticut | 9003 | 45746 | 1828 |
872067 | 872067 | 2020-12-28 | Hartford | Connecticut | 9003 | 45589 | 1823 |
868822 | 868822 | 2020-12-27 | Hartford | Connecticut | 9003 | 43253 | 1790 |
865577 | 865577 | 2020-12-26 | Hartford | Connecticut | 9003 | 43253 | 1790 |
862332 | 862332 | 2020-12-25 | Hartford | Connecticut | 9003 | 43253 | 1790 |
859087 | 859087 | 2020-12-24 | Hartford | Connecticut | 9003 | 43253 | 1790 |
855842 | 855842 | 2020-12-23 | Hartford | Connecticut | 9003 | 42786 | 1777 |
852597 | 852597 | 2020-12-22 | Hartford | Connecticut | 9003 | 42402 | 1766 |
849352 | 849352 | 2020-12-21 | Hartford | Connecticut | 9003 | 41961 | 1755 |
846107 | 846107 | 2020-12-20 | Hartford | Connecticut | 9003 | 40611 | 1733 |
842861 | 842861 | 2020-12-19 | Hartford | Connecticut | 9003 | 40611 | 1733 |
839616 | 839616 | 2020-12-18 | Hartford | Connecticut | 9003 | 40611 | 1733 |
836371 | 836371 | 2020-12-17 | Hartford | Connecticut | 9003 | 39787 | 1728 |
833125 | 833125 | 2020-12-16 | Hartford | Connecticut | 9003 | 39151 | 1716 |
829878 | 829878 | 2020-12-15 | Hartford | Connecticut | 9003 | 38457 | 1706 |
826632 | 826632 | 2020-12-14 | Hartford | Connecticut | 9003 | 38036 | 1701 |
823385 | 823385 | 2020-12-13 | Hartford | Connecticut | 9003 | 35878 | 1686 |
820139 | 820139 | 2020-12-12 | Hartford | Connecticut | 9003 | 35878 | 1686 |
816893 | 816893 | 2020-12-11 | Hartford | Connecticut | 9003 | 35878 | 1686 |
813647 | 813647 | 2020-12-10 | Hartford | Connecticut | 9003 | 35245 | 1674 |
810403 | 810403 | 2020-12-09 | Hartford | Connecticut | 9003 | 34516 | 1664 |
807158 | 807158 | 2020-12-08 | Hartford | Connecticut | 9003 | 33796 | 1653 |
803913 | 803913 | 2020-12-07 | Hartford | Connecticut | 9003 | 33035 | 1647 |
800668 | 800668 | 2020-12-06 | Hartford | Connecticut | 9003 | 30879 | 1630 |
797423 | 797423 | 2020-12-05 | Hartford | Connecticut | 9003 | 30879 | 1630 |
794178 | 794178 | 2020-12-04 | Hartford | Connecticut | 9003 | 30879 | 1630 |
790933 | 790933 | 2020-12-03 | Hartford | Connecticut | 9003 | 30549 | 1622 |
787688 | 787688 | 2020-12-02 | Hartford | Connecticut | 9003 | 29575 | 1617 |
784444 | 784444 | 2020-12-01 | Hartford | Connecticut | 9003 | 29049 | 1609 |
781199 | 781199 | 2020-11-30 | Hartford | Connecticut | 9003 | 28895 | 1604 |
777953 | 777953 | 2020-11-29 | Hartford | Connecticut | 9003 | 27844 | 1595 |
774708 | 774708 | 2020-11-28 | Hartford | Connecticut | 9003 | 27844 | 1595 |
771463 | 771463 | 2020-11-27 | Hartford | Connecticut | 9003 | 27844 | 1595 |
768218 | 768218 | 2020-11-26 | Hartford | Connecticut | 9003 | 27061 | 1587 |
764972 | 764972 | 2020-11-25 | Hartford | Connecticut | 9003 | 27061 | 1587 |
761727 | 761727 | 2020-11-24 | Hartford | Connecticut | 9003 | 26555 | 1573 |
758482 | 758482 | 2020-11-23 | Hartford | Connecticut | 9003 | 26424 | 1570 |
755235 | 755235 | 2020-11-22 | Hartford | Connecticut | 9003 | 25182 | 1553 |
751989 | 751989 | 2020-11-21 | Hartford | Connecticut | 9003 | 25182 | 1553 |
748743 | 748743 | 2020-11-20 | Hartford | Connecticut | 9003 | 25182 | 1553 |
745497 | 745497 | 2020-11-19 | Hartford | Connecticut | 9003 | 24706 | 1548 |
742250 | 742250 | 2020-11-18 | Hartford | Connecticut | 9003 | 24154 | 1544 |
739003 | 739003 | 2020-11-17 | Hartford | Connecticut | 9003 | 23636 | 1541 |
735759 | 735759 | 2020-11-16 | Hartford | Connecticut | 9003 | 23266 | 1538 |
732513 | 732513 | 2020-11-15 | Hartford | Connecticut | 9003 | 22083 | 1532 |
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);