ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where fips = 37047 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922364 | 922364 | 2021-01-12 | Columbus | North Carolina | 37047 | 4278 | 90 |
919119 | 919119 | 2021-01-11 | Columbus | North Carolina | 37047 | 4256 | 90 |
915874 | 915874 | 2021-01-10 | Columbus | North Carolina | 37047 | 4244 | 90 |
912629 | 912629 | 2021-01-09 | Columbus | North Carolina | 37047 | 4201 | 90 |
909384 | 909384 | 2021-01-08 | Columbus | North Carolina | 37047 | 4136 | 90 |
906139 | 906139 | 2021-01-07 | Columbus | North Carolina | 37047 | 4023 | 87 |
902893 | 902893 | 2021-01-06 | Columbus | North Carolina | 37047 | 3895 | 87 |
899648 | 899648 | 2021-01-05 | Columbus | North Carolina | 37047 | 3836 | 85 |
896403 | 896403 | 2021-01-04 | Columbus | North Carolina | 37047 | 3814 | 85 |
893157 | 893157 | 2021-01-03 | Columbus | North Carolina | 37047 | 3801 | 83 |
889911 | 889911 | 2021-01-02 | Columbus | North Carolina | 37047 | 3775 | 83 |
886664 | 886664 | 2021-01-01 | Columbus | North Carolina | 37047 | 3629 | 83 |
883419 | 883419 | 2020-12-31 | Columbus | North Carolina | 37047 | 3629 | 83 |
880174 | 880174 | 2020-12-30 | Columbus | North Carolina | 37047 | 3607 | 83 |
876929 | 876929 | 2020-12-29 | Columbus | North Carolina | 37047 | 3522 | 82 |
873684 | 873684 | 2020-12-28 | Columbus | North Carolina | 37047 | 3505 | 82 |
870439 | 870439 | 2020-12-27 | Columbus | North Carolina | 37047 | 3494 | 82 |
867194 | 867194 | 2020-12-26 | Columbus | North Carolina | 37047 | 3482 | 82 |
863949 | 863949 | 2020-12-25 | Columbus | North Carolina | 37047 | 3327 | 80 |
860704 | 860704 | 2020-12-24 | Columbus | North Carolina | 37047 | 3327 | 80 |
857459 | 857459 | 2020-12-23 | Columbus | North Carolina | 37047 | 3327 | 80 |
854214 | 854214 | 2020-12-22 | Columbus | North Carolina | 37047 | 3289 | 80 |
850969 | 850969 | 2020-12-21 | Columbus | North Carolina | 37047 | 3268 | 79 |
847724 | 847724 | 2020-12-20 | Columbus | North Carolina | 37047 | 3254 | 79 |
844479 | 844479 | 2020-12-19 | Columbus | North Carolina | 37047 | 3207 | 78 |
841233 | 841233 | 2020-12-18 | Columbus | North Carolina | 37047 | 3162 | 78 |
837988 | 837988 | 2020-12-17 | Columbus | North Carolina | 37047 | 3125 | 77 |
834742 | 834742 | 2020-12-16 | Columbus | North Carolina | 37047 | 3080 | 77 |
831496 | 831496 | 2020-12-15 | Columbus | North Carolina | 37047 | 3061 | 74 |
828249 | 828249 | 2020-12-14 | Columbus | North Carolina | 37047 | 3051 | 74 |
825003 | 825003 | 2020-12-13 | Columbus | North Carolina | 37047 | 3037 | 74 |
821756 | 821756 | 2020-12-12 | Columbus | North Carolina | 37047 | 3011 | 74 |
818510 | 818510 | 2020-12-11 | Columbus | North Carolina | 37047 | 2982 | 74 |
815264 | 815264 | 2020-12-10 | Columbus | North Carolina | 37047 | 2946 | 74 |
812019 | 812019 | 2020-12-09 | Columbus | North Carolina | 37047 | 2932 | 74 |
808774 | 808774 | 2020-12-08 | Columbus | North Carolina | 37047 | 2902 | 74 |
805529 | 805529 | 2020-12-07 | Columbus | North Carolina | 37047 | 2891 | 74 |
802284 | 802284 | 2020-12-06 | Columbus | North Carolina | 37047 | 2883 | 74 |
799039 | 799039 | 2020-12-05 | Columbus | North Carolina | 37047 | 2855 | 74 |
795794 | 795794 | 2020-12-04 | Columbus | North Carolina | 37047 | 2833 | 73 |
792549 | 792549 | 2020-12-03 | Columbus | North Carolina | 37047 | 2824 | 73 |
789304 | 789304 | 2020-12-02 | Columbus | North Carolina | 37047 | 2788 | 73 |
786059 | 786059 | 2020-12-01 | Columbus | North Carolina | 37047 | 2766 | 71 |
782815 | 782815 | 2020-11-30 | Columbus | North Carolina | 37047 | 2757 | 71 |
779569 | 779569 | 2020-11-29 | Columbus | North Carolina | 37047 | 2754 | 71 |
776324 | 776324 | 2020-11-28 | Columbus | North Carolina | 37047 | 2735 | 71 |
773079 | 773079 | 2020-11-27 | Columbus | North Carolina | 37047 | 2704 | 71 |
769834 | 769834 | 2020-11-26 | Columbus | North Carolina | 37047 | 2557 | 71 |
766588 | 766588 | 2020-11-25 | Columbus | North Carolina | 37047 | 2557 | 71 |
763343 | 763343 | 2020-11-24 | Columbus | North Carolina | 37047 | 2533 | 70 |
760098 | 760098 | 2020-11-23 | Columbus | North Carolina | 37047 | 2521 | 70 |
756852 | 756852 | 2020-11-22 | Columbus | North Carolina | 37047 | 2508 | 70 |
753605 | 753605 | 2020-11-21 | Columbus | North Carolina | 37047 | 2430 | 70 |
750359 | 750359 | 2020-11-20 | Columbus | North Carolina | 37047 | 2404 | 70 |
747113 | 747113 | 2020-11-19 | Columbus | North Carolina | 37047 | 2345 | 69 |
743867 | 743867 | 2020-11-18 | Columbus | North Carolina | 37047 | 2267 | 68 |
740620 | 740620 | 2020-11-17 | Columbus | North Carolina | 37047 | 2241 | 67 |
737375 | 737375 | 2020-11-16 | Columbus | North Carolina | 37047 | 2195 | 67 |
734131 | 734131 | 2020-11-15 | Columbus | North Carolina | 37047 | 2183 | 67 |
730885 | 730885 | 2020-11-14 | Columbus | North Carolina | 37047 | 2163 | 67 |
727641 | 727641 | 2020-11-13 | Columbus | North Carolina | 37047 | 2130 | 67 |
724397 | 724397 | 2020-11-12 | Columbus | North Carolina | 37047 | 2102 | 67 |
721154 | 721154 | 2020-11-11 | Columbus | North Carolina | 37047 | 2024 | 67 |
717911 | 717911 | 2020-11-10 | Columbus | North Carolina | 37047 | 1981 | 66 |
714668 | 714668 | 2020-11-09 | Columbus | North Carolina | 37047 | 1955 | 66 |
711424 | 711424 | 2020-11-08 | Columbus | North Carolina | 37047 | 1907 | 66 |
708180 | 708180 | 2020-11-07 | Columbus | North Carolina | 37047 | 1900 | 66 |
704937 | 704937 | 2020-11-06 | Columbus | North Carolina | 37047 | 1891 | 64 |
701694 | 701694 | 2020-11-05 | Columbus | North Carolina | 37047 | 1832 | 64 |
698450 | 698450 | 2020-11-04 | Columbus | North Carolina | 37047 | 1815 | 64 |
695207 | 695207 | 2020-11-03 | Columbus | North Carolina | 37047 | 1796 | 63 |
691965 | 691965 | 2020-11-02 | Columbus | North Carolina | 37047 | 1790 | 62 |
688721 | 688721 | 2020-11-01 | Columbus | North Carolina | 37047 | 1787 | 62 |
685476 | 685476 | 2020-10-31 | Columbus | North Carolina | 37047 | 1776 | 62 |
682233 | 682233 | 2020-10-30 | Columbus | North Carolina | 37047 | 1732 | 62 |
678990 | 678990 | 2020-10-29 | Columbus | North Carolina | 37047 | 1714 | 62 |
675747 | 675747 | 2020-10-28 | Columbus | North Carolina | 37047 | 1704 | 62 |
672504 | 672504 | 2020-10-27 | Columbus | North Carolina | 37047 | 1673 | 62 |
669262 | 669262 | 2020-10-26 | Columbus | North Carolina | 37047 | 1671 | 61 |
666018 | 666018 | 2020-10-25 | Columbus | North Carolina | 37047 | 1667 | 61 |
662773 | 662773 | 2020-10-24 | Columbus | North Carolina | 37047 | 1659 | 60 |
659529 | 659529 | 2020-10-23 | Columbus | North Carolina | 37047 | 1628 | 60 |
656285 | 656285 | 2020-10-22 | Columbus | North Carolina | 37047 | 1626 | 59 |
653040 | 653040 | 2020-10-21 | Columbus | North Carolina | 37047 | 1603 | 59 |
649795 | 649795 | 2020-10-20 | Columbus | North Carolina | 37047 | 1591 | 59 |
646551 | 646551 | 2020-10-19 | Columbus | North Carolina | 37047 | 1583 | 59 |
643305 | 643305 | 2020-10-18 | Columbus | North Carolina | 37047 | 1574 | 59 |
640057 | 640057 | 2020-10-17 | Columbus | North Carolina | 37047 | 1570 | 59 |
636811 | 636811 | 2020-10-16 | Columbus | North Carolina | 37047 | 1557 | 59 |
633565 | 633565 | 2020-10-15 | Columbus | North Carolina | 37047 | 1552 | 59 |
630320 | 630320 | 2020-10-14 | Columbus | North Carolina | 37047 | 1535 | 59 |
627076 | 627076 | 2020-10-13 | Columbus | North Carolina | 37047 | 1524 | 59 |
623834 | 623834 | 2020-10-12 | Columbus | North Carolina | 37047 | 1507 | 58 |
620591 | 620591 | 2020-10-11 | Columbus | North Carolina | 37047 | 1504 | 58 |
617349 | 617349 | 2020-10-10 | Columbus | North Carolina | 37047 | 1497 | 58 |
614107 | 614107 | 2020-10-09 | Columbus | North Carolina | 37047 | 1493 | 58 |
610866 | 610866 | 2020-10-08 | Columbus | North Carolina | 37047 | 1476 | 57 |
607624 | 607624 | 2020-10-07 | Columbus | North Carolina | 37047 | 1460 | 57 |
604381 | 604381 | 2020-10-06 | Columbus | North Carolina | 37047 | 1443 | 57 |
601139 | 601139 | 2020-10-05 | Columbus | North Carolina | 37047 | 1429 | 57 |
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);