ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Unknown" and state = "Connecticut" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
920753 | 920753 | 2021-01-12 | Unknown | Connecticut | 803 | 2 | |
917508 | 917508 | 2021-01-11 | Unknown | Connecticut | 779 | 1 | |
914263 | 914263 | 2021-01-10 | Unknown | Connecticut | 770 | 1 | |
911018 | 911018 | 2021-01-09 | Unknown | Connecticut | 770 | 1 | |
907773 | 907773 | 2021-01-08 | Unknown | Connecticut | 770 | 1 | |
904527 | 904527 | 2021-01-07 | Unknown | Connecticut | 755 | 1 | |
901282 | 901282 | 2021-01-06 | Unknown | Connecticut | 723 | 0 | |
898037 | 898037 | 2021-01-05 | Unknown | Connecticut | 710 | 0 | |
894792 | 894792 | 2021-01-04 | Unknown | Connecticut | 703 | 0 | |
891545 | 891545 | 2021-01-03 | Unknown | Connecticut | 684 | 0 | |
888298 | 888298 | 2021-01-02 | Unknown | Connecticut | 684 | 0 | |
885053 | 885053 | 2021-01-01 | Unknown | Connecticut | 665 | 0 | |
881808 | 881808 | 2020-12-31 | Unknown | Connecticut | 665 | 0 | |
878563 | 878563 | 2020-12-30 | Unknown | Connecticut | 647 | 0 | |
875318 | 875318 | 2020-12-29 | Unknown | Connecticut | 650 | 0 | |
872073 | 872073 | 2020-12-28 | Unknown | Connecticut | 671 | 1 | |
868828 | 868828 | 2020-12-27 | Unknown | Connecticut | 644 | 0 | |
865583 | 865583 | 2020-12-26 | Unknown | Connecticut | 644 | 0 | |
862338 | 862338 | 2020-12-25 | Unknown | Connecticut | 644 | 0 | |
859093 | 859093 | 2020-12-24 | Unknown | Connecticut | 644 | 0 | |
855848 | 855848 | 2020-12-23 | Unknown | Connecticut | 674 | 0 | |
852603 | 852603 | 2020-12-22 | Unknown | Connecticut | 673 | 0 | |
849358 | 849358 | 2020-12-21 | Unknown | Connecticut | 690 | 2 | |
846113 | 846113 | 2020-12-20 | Unknown | Connecticut | 662 | 0 | |
842867 | 842867 | 2020-12-19 | Unknown | Connecticut | 662 | 0 | |
839622 | 839622 | 2020-12-18 | Unknown | Connecticut | 662 | 0 | |
836377 | 836377 | 2020-12-17 | Unknown | Connecticut | 647 | 0 | |
833131 | 833131 | 2020-12-16 | Unknown | Connecticut | 713 | 0 | |
829884 | 829884 | 2020-12-15 | Unknown | Connecticut | 812 | 1 | |
826638 | 826638 | 2020-12-14 | Unknown | Connecticut | 1144 | 1 | |
823391 | 823391 | 2020-12-13 | Unknown | Connecticut | 1055 | 1 | |
820145 | 820145 | 2020-12-12 | Unknown | Connecticut | 1055 | 1 | |
816899 | 816899 | 2020-12-11 | Unknown | Connecticut | 1055 | 1 | |
813653 | 813653 | 2020-12-10 | Unknown | Connecticut | 1023 | 1 | |
810409 | 810409 | 2020-12-09 | Unknown | Connecticut | 1016 | 0 | |
807164 | 807164 | 2020-12-08 | Unknown | Connecticut | 952 | 0 | |
803919 | 803919 | 2020-12-07 | Unknown | Connecticut | 907 | 0 | |
800674 | 800674 | 2020-12-06 | Unknown | Connecticut | 810 | 1 | |
797429 | 797429 | 2020-12-05 | Unknown | Connecticut | 810 | 1 | |
794184 | 794184 | 2020-12-04 | Unknown | Connecticut | 810 | 1 | |
790939 | 790939 | 2020-12-03 | Unknown | Connecticut | 801 | 1 | |
787694 | 787694 | 2020-12-02 | Unknown | Connecticut | 733 | 0 | |
784450 | 784450 | 2020-12-01 | Unknown | Connecticut | 654 | 1 | |
781205 | 781205 | 2020-11-30 | Unknown | Connecticut | 702 | 2 | |
777959 | 777959 | 2020-11-29 | Unknown | Connecticut | 631 | 0 | |
774714 | 774714 | 2020-11-28 | Unknown | Connecticut | 631 | 0 | |
771469 | 771469 | 2020-11-27 | Unknown | Connecticut | 631 | 0 | |
768224 | 768224 | 2020-11-26 | Unknown | Connecticut | 495 | 0 | |
764978 | 764978 | 2020-11-25 | Unknown | Connecticut | 495 | 0 | |
761733 | 761733 | 2020-11-24 | Unknown | Connecticut | 465 | 0 | |
758488 | 758488 | 2020-11-23 | Unknown | Connecticut | 573 | 0 | |
755241 | 755241 | 2020-11-22 | Unknown | Connecticut | 466 | 0 | |
751995 | 751995 | 2020-11-21 | Unknown | Connecticut | 466 | 0 | |
748749 | 748749 | 2020-11-20 | Unknown | Connecticut | 466 | 0 | |
745503 | 745503 | 2020-11-19 | Unknown | Connecticut | 403 | 0 | |
742256 | 742256 | 2020-11-18 | Unknown | Connecticut | 408 | 0 | |
739009 | 739009 | 2020-11-17 | Unknown | Connecticut | 436 | 0 | |
735765 | 735765 | 2020-11-16 | Unknown | Connecticut | 421 | 0 | |
732519 | 732519 | 2020-11-15 | Unknown | Connecticut | 379 | 0 | |
729274 | 729274 | 2020-11-14 | Unknown | Connecticut | 379 | 0 | |
726031 | 726031 | 2020-11-13 | Unknown | Connecticut | 379 | 0 | |
722788 | 722788 | 2020-11-12 | Unknown | Connecticut | 319 | 0 | |
719545 | 719545 | 2020-11-11 | Unknown | Connecticut | 318 | 0 | |
716302 | 716302 | 2020-11-10 | Unknown | Connecticut | 291 | 0 | |
713058 | 713058 | 2020-11-09 | Unknown | Connecticut | 308 | 1 | |
709814 | 709814 | 2020-11-08 | Unknown | Connecticut | 207 | 0 | |
706570 | 706570 | 2020-11-07 | Unknown | Connecticut | 207 | 0 | |
703327 | 703327 | 2020-11-06 | Unknown | Connecticut | 207 | 0 | |
700084 | 700084 | 2020-11-05 | Unknown | Connecticut | 202 | 0 | |
696840 | 696840 | 2020-11-04 | Unknown | Connecticut | 239 | 0 | |
693598 | 693598 | 2020-11-03 | Unknown | Connecticut | 185 | 0 | |
690355 | 690355 | 2020-11-02 | Unknown | Connecticut | 219 | 1 | |
687110 | 687110 | 2020-11-01 | Unknown | Connecticut | 141 | 0 | |
683866 | 683866 | 2020-10-31 | Unknown | Connecticut | 141 | 0 | |
680623 | 680623 | 2020-10-30 | Unknown | Connecticut | 141 | 0 | |
677380 | 677380 | 2020-10-29 | Unknown | Connecticut | 155 | 0 | |
674137 | 674137 | 2020-10-28 | Unknown | Connecticut | 150 | 0 | |
670895 | 670895 | 2020-10-27 | Unknown | Connecticut | 153 | 0 | |
667652 | 667652 | 2020-10-26 | Unknown | Connecticut | 189 | 1 | |
664407 | 664407 | 2020-10-25 | Unknown | Connecticut | 137 | 0 | |
661163 | 661163 | 2020-10-24 | Unknown | Connecticut | 137 | 0 | |
657919 | 657919 | 2020-10-23 | Unknown | Connecticut | 137 | 0 | |
654674 | 654674 | 2020-10-22 | Unknown | Connecticut | 137 | 0 | |
651429 | 651429 | 2020-10-21 | Unknown | Connecticut | 153 | 0 | |
648185 | 648185 | 2020-10-20 | Unknown | Connecticut | 141 | 0 | |
644940 | 644940 | 2020-10-19 | Unknown | Connecticut | 157 | 0 | |
641692 | 641692 | 2020-10-18 | Unknown | Connecticut | 125 | 0 | |
638445 | 638445 | 2020-10-17 | Unknown | Connecticut | 125 | 0 | |
635200 | 635200 | 2020-10-16 | Unknown | Connecticut | 125 | 0 | |
631954 | 631954 | 2020-10-15 | Unknown | Connecticut | 129 | 0 | |
628710 | 628710 | 2020-10-14 | Unknown | Connecticut | 148 | 0 | |
625467 | 625467 | 2020-10-13 | Unknown | Connecticut | 140 | 0 | |
622224 | 622224 | 2020-10-12 | Unknown | Connecticut | 162 | 0 | |
618981 | 618981 | 2020-10-11 | Unknown | Connecticut | 123 | 0 | |
615739 | 615739 | 2020-10-10 | Unknown | Connecticut | 123 | 0 | |
612498 | 612498 | 2020-10-09 | Unknown | Connecticut | 123 | 0 | |
609256 | 609256 | 2020-10-08 | Unknown | Connecticut | 109 | 0 | |
606013 | 606013 | 2020-10-07 | Unknown | Connecticut | 123 | 0 | |
602771 | 602771 | 2020-10-06 | Unknown | Connecticut | 156 | 0 | |
599528 | 599528 | 2020-10-05 | Unknown | Connecticut | 157 | 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);