ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 37135 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 |
---|---|---|---|---|---|---|---|
922408 | 922408 | 2021-01-12 | Orange | North Carolina | 37135 | 5792 | 68 |
919163 | 919163 | 2021-01-11 | Orange | North Carolina | 37135 | 5744 | 68 |
915918 | 915918 | 2021-01-10 | Orange | North Carolina | 37135 | 5682 | 68 |
912673 | 912673 | 2021-01-09 | Orange | North Carolina | 37135 | 5614 | 68 |
909428 | 909428 | 2021-01-08 | Orange | North Carolina | 37135 | 5530 | 68 |
906183 | 906183 | 2021-01-07 | Orange | North Carolina | 37135 | 5431 | 66 |
902937 | 902937 | 2021-01-06 | Orange | North Carolina | 37135 | 5359 | 66 |
899692 | 899692 | 2021-01-05 | Orange | North Carolina | 37135 | 5326 | 66 |
896447 | 896447 | 2021-01-04 | Orange | North Carolina | 37135 | 5272 | 65 |
893201 | 893201 | 2021-01-03 | Orange | North Carolina | 37135 | 5227 | 65 |
889955 | 889955 | 2021-01-02 | Orange | North Carolina | 37135 | 5192 | 65 |
886708 | 886708 | 2021-01-01 | Orange | North Carolina | 37135 | 5046 | 65 |
883463 | 883463 | 2020-12-31 | Orange | North Carolina | 37135 | 5046 | 65 |
880218 | 880218 | 2020-12-30 | Orange | North Carolina | 37135 | 4989 | 64 |
876973 | 876973 | 2020-12-29 | Orange | North Carolina | 37135 | 4949 | 63 |
873728 | 873728 | 2020-12-28 | Orange | North Carolina | 37135 | 4932 | 63 |
870483 | 870483 | 2020-12-27 | Orange | North Carolina | 37135 | 4891 | 63 |
867238 | 867238 | 2020-12-26 | Orange | North Carolina | 37135 | 4882 | 63 |
863993 | 863993 | 2020-12-25 | Orange | North Carolina | 37135 | 4738 | 63 |
860748 | 860748 | 2020-12-24 | Orange | North Carolina | 37135 | 4738 | 63 |
857503 | 857503 | 2020-12-23 | Orange | North Carolina | 37135 | 4738 | 63 |
854258 | 854258 | 2020-12-22 | Orange | North Carolina | 37135 | 4703 | 63 |
851013 | 851013 | 2020-12-21 | Orange | North Carolina | 37135 | 4681 | 63 |
847768 | 847768 | 2020-12-20 | Orange | North Carolina | 37135 | 4660 | 62 |
844523 | 844523 | 2020-12-19 | Orange | North Carolina | 37135 | 4604 | 62 |
841277 | 841277 | 2020-12-18 | Orange | North Carolina | 37135 | 4593 | 62 |
838032 | 838032 | 2020-12-17 | Orange | North Carolina | 37135 | 4528 | 62 |
834786 | 834786 | 2020-12-16 | Orange | North Carolina | 37135 | 4514 | 62 |
831540 | 831540 | 2020-12-15 | Orange | North Carolina | 37135 | 4485 | 62 |
828293 | 828293 | 2020-12-14 | Orange | North Carolina | 37135 | 4443 | 62 |
825047 | 825047 | 2020-12-13 | Orange | North Carolina | 37135 | 4405 | 62 |
821800 | 821800 | 2020-12-12 | Orange | North Carolina | 37135 | 4363 | 62 |
818554 | 818554 | 2020-12-11 | Orange | North Carolina | 37135 | 4316 | 62 |
815308 | 815308 | 2020-12-10 | Orange | North Carolina | 37135 | 4253 | 62 |
812063 | 812063 | 2020-12-09 | Orange | North Carolina | 37135 | 4215 | 62 |
808818 | 808818 | 2020-12-08 | Orange | North Carolina | 37135 | 4191 | 62 |
805573 | 805573 | 2020-12-07 | Orange | North Carolina | 37135 | 4163 | 62 |
802328 | 802328 | 2020-12-06 | Orange | North Carolina | 37135 | 4132 | 62 |
799083 | 799083 | 2020-12-05 | Orange | North Carolina | 37135 | 4080 | 62 |
795838 | 795838 | 2020-12-04 | Orange | North Carolina | 37135 | 4045 | 62 |
792593 | 792593 | 2020-12-03 | Orange | North Carolina | 37135 | 3993 | 62 |
789348 | 789348 | 2020-12-02 | Orange | North Carolina | 37135 | 3969 | 62 |
786103 | 786103 | 2020-12-01 | Orange | North Carolina | 37135 | 3934 | 62 |
782859 | 782859 | 2020-11-30 | Orange | North Carolina | 37135 | 3913 | 62 |
779613 | 779613 | 2020-11-29 | Orange | North Carolina | 37135 | 3889 | 62 |
776368 | 776368 | 2020-11-28 | Orange | North Carolina | 37135 | 3863 | 62 |
773123 | 773123 | 2020-11-27 | Orange | North Carolina | 37135 | 3831 | 62 |
769878 | 769878 | 2020-11-26 | Orange | North Carolina | 37135 | 3765 | 61 |
766632 | 766632 | 2020-11-25 | Orange | North Carolina | 37135 | 3765 | 61 |
763387 | 763387 | 2020-11-24 | Orange | North Carolina | 37135 | 3738 | 61 |
760142 | 760142 | 2020-11-23 | Orange | North Carolina | 37135 | 3714 | 61 |
756896 | 756896 | 2020-11-22 | Orange | North Carolina | 37135 | 3704 | 61 |
753649 | 753649 | 2020-11-21 | Orange | North Carolina | 37135 | 3660 | 61 |
750403 | 750403 | 2020-11-20 | Orange | North Carolina | 37135 | 3648 | 61 |
747157 | 747157 | 2020-11-19 | Orange | North Carolina | 37135 | 3593 | 61 |
743911 | 743911 | 2020-11-18 | Orange | North Carolina | 37135 | 3572 | 61 |
740664 | 740664 | 2020-11-17 | Orange | North Carolina | 37135 | 3539 | 61 |
737419 | 737419 | 2020-11-16 | Orange | North Carolina | 37135 | 3520 | 61 |
734175 | 734175 | 2020-11-15 | Orange | North Carolina | 37135 | 3502 | 61 |
730929 | 730929 | 2020-11-14 | Orange | North Carolina | 37135 | 3459 | 60 |
727685 | 727685 | 2020-11-13 | Orange | North Carolina | 37135 | 3425 | 60 |
724441 | 724441 | 2020-11-12 | Orange | North Carolina | 37135 | 3409 | 60 |
721198 | 721198 | 2020-11-11 | Orange | North Carolina | 37135 | 3375 | 60 |
717955 | 717955 | 2020-11-10 | Orange | North Carolina | 37135 | 3350 | 59 |
714712 | 714712 | 2020-11-09 | Orange | North Carolina | 37135 | 3329 | 59 |
711468 | 711468 | 2020-11-08 | Orange | North Carolina | 37135 | 3311 | 59 |
708224 | 708224 | 2020-11-07 | Orange | North Carolina | 37135 | 3290 | 59 |
704981 | 704981 | 2020-11-06 | Orange | North Carolina | 37135 | 3260 | 59 |
701738 | 701738 | 2020-11-05 | Orange | North Carolina | 37135 | 3236 | 59 |
698494 | 698494 | 2020-11-04 | Orange | North Carolina | 37135 | 3213 | 59 |
695251 | 695251 | 2020-11-03 | Orange | North Carolina | 37135 | 3191 | 59 |
692009 | 692009 | 2020-11-02 | Orange | North Carolina | 37135 | 3174 | 59 |
688765 | 688765 | 2020-11-01 | Orange | North Carolina | 37135 | 3160 | 59 |
685520 | 685520 | 2020-10-31 | Orange | North Carolina | 37135 | 3155 | 59 |
682277 | 682277 | 2020-10-30 | Orange | North Carolina | 37135 | 3132 | 59 |
679034 | 679034 | 2020-10-29 | Orange | North Carolina | 37135 | 3109 | 59 |
675791 | 675791 | 2020-10-28 | Orange | North Carolina | 37135 | 3088 | 58 |
672548 | 672548 | 2020-10-27 | Orange | North Carolina | 37135 | 3079 | 58 |
669306 | 669306 | 2020-10-26 | Orange | North Carolina | 37135 | 3059 | 58 |
666062 | 666062 | 2020-10-25 | Orange | North Carolina | 37135 | 3049 | 58 |
662817 | 662817 | 2020-10-24 | Orange | North Carolina | 37135 | 3029 | 58 |
659573 | 659573 | 2020-10-23 | Orange | North Carolina | 37135 | 3003 | 58 |
656329 | 656329 | 2020-10-22 | Orange | North Carolina | 37135 | 2989 | 58 |
653084 | 653084 | 2020-10-21 | Orange | North Carolina | 37135 | 2977 | 58 |
649839 | 649839 | 2020-10-20 | Orange | North Carolina | 37135 | 2967 | 58 |
646595 | 646595 | 2020-10-19 | Orange | North Carolina | 37135 | 2953 | 58 |
643349 | 643349 | 2020-10-18 | Orange | North Carolina | 37135 | 2938 | 58 |
640101 | 640101 | 2020-10-17 | Orange | North Carolina | 37135 | 2913 | 58 |
636855 | 636855 | 2020-10-16 | Orange | North Carolina | 37135 | 2907 | 57 |
633609 | 633609 | 2020-10-15 | Orange | North Carolina | 37135 | 2886 | 57 |
630364 | 630364 | 2020-10-14 | Orange | North Carolina | 37135 | 2874 | 57 |
627120 | 627120 | 2020-10-13 | Orange | North Carolina | 37135 | 2855 | 57 |
623878 | 623878 | 2020-10-12 | Orange | North Carolina | 37135 | 2843 | 57 |
620635 | 620635 | 2020-10-11 | Orange | North Carolina | 37135 | 2834 | 57 |
617393 | 617393 | 2020-10-10 | Orange | North Carolina | 37135 | 2817 | 57 |
614151 | 614151 | 2020-10-09 | Orange | North Carolina | 37135 | 2808 | 57 |
610910 | 610910 | 2020-10-08 | Orange | North Carolina | 37135 | 2795 | 57 |
607668 | 607668 | 2020-10-07 | Orange | North Carolina | 37135 | 2777 | 57 |
604425 | 604425 | 2020-10-06 | Orange | North Carolina | 37135 | 2765 | 57 |
601183 | 601183 | 2020-10-05 | Orange | North Carolina | 37135 | 2760 | 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);