ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where fips = 9001 and state = "Connecticut" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
920746 | 920746 | 2021-01-12 | Fairfield | Connecticut | 9001 | 64066 | 1806 |
917501 | 917501 | 2021-01-11 | Fairfield | Connecticut | 9001 | 63073 | 1797 |
914256 | 914256 | 2021-01-10 | Fairfield | Connecticut | 9001 | 61285 | 1779 |
911011 | 911011 | 2021-01-09 | Fairfield | Connecticut | 9001 | 61285 | 1779 |
907766 | 907766 | 2021-01-08 | Fairfield | Connecticut | 9001 | 61285 | 1779 |
904520 | 904520 | 2021-01-07 | Fairfield | Connecticut | 9001 | 60396 | 1772 |
901275 | 901275 | 2021-01-06 | Fairfield | Connecticut | 9001 | 59565 | 1763 |
898030 | 898030 | 2021-01-05 | Fairfield | Connecticut | 9001 | 58959 | 1755 |
894785 | 894785 | 2021-01-04 | Fairfield | Connecticut | 9001 | 58431 | 1750 |
891538 | 891538 | 2021-01-03 | Fairfield | Connecticut | 9001 | 57467 | 1740 |
888291 | 888291 | 2021-01-02 | Fairfield | Connecticut | 9001 | 57467 | 1740 |
885046 | 885046 | 2021-01-01 | Fairfield | Connecticut | 9001 | 56288 | 1720 |
881801 | 881801 | 2020-12-31 | Fairfield | Connecticut | 9001 | 56288 | 1720 |
878556 | 878556 | 2020-12-30 | Fairfield | Connecticut | 9001 | 55645 | 1713 |
875311 | 875311 | 2020-12-29 | Fairfield | Connecticut | 9001 | 55253 | 1700 |
872066 | 872066 | 2020-12-28 | Fairfield | Connecticut | 9001 | 55037 | 1697 |
868821 | 868821 | 2020-12-27 | Fairfield | Connecticut | 9001 | 53101 | 1669 |
865576 | 865576 | 2020-12-26 | Fairfield | Connecticut | 9001 | 53101 | 1669 |
862331 | 862331 | 2020-12-25 | Fairfield | Connecticut | 9001 | 53101 | 1669 |
859086 | 859086 | 2020-12-24 | Fairfield | Connecticut | 9001 | 53101 | 1669 |
855841 | 855841 | 2020-12-23 | Fairfield | Connecticut | 9001 | 52574 | 1660 |
852596 | 852596 | 2020-12-22 | Fairfield | Connecticut | 9001 | 52080 | 1653 |
849351 | 849351 | 2020-12-21 | Fairfield | Connecticut | 9001 | 51717 | 1647 |
846106 | 846106 | 2020-12-20 | Fairfield | Connecticut | 9001 | 50614 | 1628 |
842860 | 842860 | 2020-12-19 | Fairfield | Connecticut | 9001 | 50614 | 1628 |
839615 | 839615 | 2020-12-18 | Fairfield | Connecticut | 9001 | 50614 | 1628 |
836370 | 836370 | 2020-12-17 | Fairfield | Connecticut | 9001 | 50036 | 1619 |
833124 | 833124 | 2020-12-16 | Fairfield | Connecticut | 9001 | 49422 | 1612 |
829877 | 829877 | 2020-12-15 | Fairfield | Connecticut | 9001 | 48879 | 1607 |
826631 | 826631 | 2020-12-14 | Fairfield | Connecticut | 9001 | 48308 | 1602 |
823384 | 823384 | 2020-12-13 | Fairfield | Connecticut | 9001 | 46615 | 1588 |
820138 | 820138 | 2020-12-12 | Fairfield | Connecticut | 9001 | 46615 | 1588 |
816892 | 816892 | 2020-12-11 | Fairfield | Connecticut | 9001 | 46615 | 1588 |
813646 | 813646 | 2020-12-10 | Fairfield | Connecticut | 9001 | 45509 | 1581 |
810402 | 810402 | 2020-12-09 | Fairfield | Connecticut | 9001 | 44980 | 1577 |
807157 | 807157 | 2020-12-08 | Fairfield | Connecticut | 9001 | 44376 | 1567 |
803912 | 803912 | 2020-12-07 | Fairfield | Connecticut | 9001 | 43840 | 1566 |
800667 | 800667 | 2020-12-06 | Fairfield | Connecticut | 9001 | 41535 | 1545 |
797422 | 797422 | 2020-12-05 | Fairfield | Connecticut | 9001 | 41535 | 1545 |
794177 | 794177 | 2020-12-04 | Fairfield | Connecticut | 9001 | 41535 | 1545 |
790932 | 790932 | 2020-12-03 | Fairfield | Connecticut | 9001 | 41062 | 1534 |
787687 | 787687 | 2020-12-02 | Fairfield | Connecticut | 9001 | 39773 | 1532 |
784443 | 784443 | 2020-12-01 | Fairfield | Connecticut | 9001 | 38756 | 1516 |
781198 | 781198 | 2020-11-30 | Fairfield | Connecticut | 9001 | 38305 | 1507 |
777952 | 777952 | 2020-11-29 | Fairfield | Connecticut | 9001 | 37071 | 1491 |
774707 | 774707 | 2020-11-28 | Fairfield | Connecticut | 9001 | 37071 | 1491 |
771462 | 771462 | 2020-11-27 | Fairfield | Connecticut | 9001 | 37071 | 1491 |
768217 | 768217 | 2020-11-26 | Fairfield | Connecticut | 9001 | 36037 | 1488 |
764971 | 764971 | 2020-11-25 | Fairfield | Connecticut | 9001 | 36037 | 1488 |
761726 | 761726 | 2020-11-24 | Fairfield | Connecticut | 9001 | 35494 | 1478 |
758481 | 758481 | 2020-11-23 | Fairfield | Connecticut | 9001 | 35272 | 1477 |
755234 | 755234 | 2020-11-22 | Fairfield | Connecticut | 9001 | 33648 | 1471 |
751988 | 751988 | 2020-11-21 | Fairfield | Connecticut | 9001 | 33648 | 1471 |
748742 | 748742 | 2020-11-20 | Fairfield | Connecticut | 9001 | 33648 | 1471 |
745496 | 745496 | 2020-11-19 | Fairfield | Connecticut | 9001 | 33067 | 1466 |
742249 | 742249 | 2020-11-18 | Fairfield | Connecticut | 9001 | 32369 | 1463 |
739002 | 739002 | 2020-11-17 | Fairfield | Connecticut | 9001 | 31773 | 1460 |
735758 | 735758 | 2020-11-16 | Fairfield | Connecticut | 9001 | 31212 | 1459 |
732512 | 732512 | 2020-11-15 | Fairfield | Connecticut | 9001 | 29842 | 1454 |
729267 | 729267 | 2020-11-14 | Fairfield | Connecticut | 9001 | 29842 | 1454 |
726024 | 726024 | 2020-11-13 | Fairfield | Connecticut | 9001 | 29842 | 1454 |
722781 | 722781 | 2020-11-12 | Fairfield | Connecticut | 9001 | 29008 | 1455 |
719538 | 719538 | 2020-11-11 | Fairfield | Connecticut | 9001 | 28731 | 1451 |
716295 | 716295 | 2020-11-10 | Fairfield | Connecticut | 9001 | 28178 | 1451 |
713051 | 713051 | 2020-11-09 | Fairfield | Connecticut | 9001 | 27652 | 1450 |
709807 | 709807 | 2020-11-08 | Fairfield | Connecticut | 9001 | 26435 | 1447 |
706563 | 706563 | 2020-11-07 | Fairfield | Connecticut | 9001 | 26435 | 1447 |
703320 | 703320 | 2020-11-06 | Fairfield | Connecticut | 9001 | 26435 | 1447 |
700077 | 700077 | 2020-11-05 | Fairfield | Connecticut | 9001 | 26120 | 1445 |
696833 | 696833 | 2020-11-04 | Fairfield | Connecticut | 9001 | 25538 | 1443 |
693591 | 693591 | 2020-11-03 | Fairfield | Connecticut | 9001 | 25365 | 1442 |
690348 | 690348 | 2020-11-02 | Fairfield | Connecticut | 9001 | 25048 | 1439 |
687103 | 687103 | 2020-11-01 | Fairfield | Connecticut | 9001 | 24155 | 1436 |
683859 | 683859 | 2020-10-31 | Fairfield | Connecticut | 9001 | 24155 | 1436 |
680616 | 680616 | 2020-10-30 | Fairfield | Connecticut | 9001 | 24155 | 1436 |
677373 | 677373 | 2020-10-29 | Fairfield | Connecticut | 9001 | 23895 | 1435 |
674130 | 674130 | 2020-10-28 | Fairfield | Connecticut | 9001 | 23280 | 1435 |
670888 | 670888 | 2020-10-27 | Fairfield | Connecticut | 9001 | 23090 | 1433 |
667645 | 667645 | 2020-10-26 | Fairfield | Connecticut | 9001 | 22893 | 1431 |
664400 | 664400 | 2020-10-25 | Fairfield | Connecticut | 9001 | 22322 | 1430 |
661156 | 661156 | 2020-10-24 | Fairfield | Connecticut | 9001 | 22322 | 1430 |
657912 | 657912 | 2020-10-23 | Fairfield | Connecticut | 9001 | 22322 | 1430 |
654667 | 654667 | 2020-10-22 | Fairfield | Connecticut | 9001 | 22088 | 1429 |
651422 | 651422 | 2020-10-21 | Fairfield | Connecticut | 9001 | 21898 | 1429 |
648178 | 648178 | 2020-10-20 | Fairfield | Connecticut | 9001 | 21754 | 1428 |
644933 | 644933 | 2020-10-19 | Fairfield | Connecticut | 9001 | 21674 | 1429 |
641685 | 641685 | 2020-10-18 | Fairfield | Connecticut | 9001 | 21368 | 1427 |
638438 | 638438 | 2020-10-17 | Fairfield | Connecticut | 9001 | 21368 | 1427 |
635193 | 635193 | 2020-10-16 | Fairfield | Connecticut | 9001 | 21368 | 1427 |
631947 | 631947 | 2020-10-15 | Fairfield | Connecticut | 9001 | 21183 | 1427 |
628703 | 628703 | 2020-10-14 | Fairfield | Connecticut | 9001 | 21128 | 1427 |
625460 | 625460 | 2020-10-13 | Fairfield | Connecticut | 9001 | 21104 | 1426 |
622217 | 622217 | 2020-10-12 | Fairfield | Connecticut | 9001 | 21052 | 1426 |
618974 | 618974 | 2020-10-11 | Fairfield | Connecticut | 9001 | 20752 | 1426 |
615732 | 615732 | 2020-10-10 | Fairfield | Connecticut | 9001 | 20752 | 1426 |
612491 | 612491 | 2020-10-09 | Fairfield | Connecticut | 9001 | 20752 | 1426 |
609249 | 609249 | 2020-10-08 | Fairfield | Connecticut | 9001 | 20701 | 1425 |
606006 | 606006 | 2020-10-07 | Fairfield | Connecticut | 9001 | 20612 | 1425 |
602764 | 602764 | 2020-10-06 | Fairfield | Connecticut | 9001 | 20587 | 1425 |
599521 | 599521 | 2020-10-05 | Fairfield | Connecticut | 9001 | 20587 | 1423 |
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);