ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 37139 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 |
---|---|---|---|---|---|---|---|
958110 | 958110 | 2021-01-23 | Pasquotank | North Carolina | 37139 | 2525 | 66 |
954864 | 954864 | 2021-01-22 | Pasquotank | North Carolina | 37139 | 2483 | 66 |
951619 | 951619 | 2021-01-21 | Pasquotank | North Carolina | 37139 | 2445 | 65 |
948374 | 948374 | 2021-01-20 | Pasquotank | North Carolina | 37139 | 2417 | 64 |
945127 | 945127 | 2021-01-19 | Pasquotank | North Carolina | 37139 | 2399 | 62 |
941881 | 941881 | 2021-01-18 | Pasquotank | North Carolina | 37139 | 2378 | 62 |
938636 | 938636 | 2021-01-17 | Pasquotank | North Carolina | 37139 | 2378 | 62 |
935391 | 935391 | 2021-01-16 | Pasquotank | North Carolina | 37139 | 2356 | 59 |
932146 | 932146 | 2021-01-15 | Pasquotank | North Carolina | 37139 | 2310 | 59 |
928901 | 928901 | 2021-01-14 | Pasquotank | North Carolina | 37139 | 2262 | 59 |
925656 | 925656 | 2021-01-13 | Pasquotank | North Carolina | 37139 | 2223 | 59 |
922410 | 922410 | 2021-01-12 | Pasquotank | North Carolina | 37139 | 2170 | 59 |
919165 | 919165 | 2021-01-11 | Pasquotank | North Carolina | 37139 | 2156 | 59 |
915920 | 915920 | 2021-01-10 | Pasquotank | North Carolina | 37139 | 2130 | 59 |
912675 | 912675 | 2021-01-09 | Pasquotank | North Carolina | 37139 | 2107 | 59 |
909430 | 909430 | 2021-01-08 | Pasquotank | North Carolina | 37139 | 2069 | 59 |
906185 | 906185 | 2021-01-07 | Pasquotank | North Carolina | 37139 | 1985 | 59 |
902939 | 902939 | 2021-01-06 | Pasquotank | North Carolina | 37139 | 1956 | 49 |
899694 | 899694 | 2021-01-05 | Pasquotank | North Carolina | 37139 | 1935 | 44 |
896449 | 896449 | 2021-01-04 | Pasquotank | North Carolina | 37139 | 1917 | 44 |
893203 | 893203 | 2021-01-03 | Pasquotank | North Carolina | 37139 | 1896 | 44 |
889957 | 889957 | 2021-01-02 | Pasquotank | North Carolina | 37139 | 1867 | 44 |
886710 | 886710 | 2021-01-01 | Pasquotank | North Carolina | 37139 | 1807 | 44 |
883465 | 883465 | 2020-12-31 | Pasquotank | North Carolina | 37139 | 1807 | 44 |
880220 | 880220 | 2020-12-30 | Pasquotank | North Carolina | 37139 | 1777 | 43 |
876975 | 876975 | 2020-12-29 | Pasquotank | North Carolina | 37139 | 1726 | 43 |
873730 | 873730 | 2020-12-28 | Pasquotank | North Carolina | 37139 | 1714 | 43 |
870485 | 870485 | 2020-12-27 | Pasquotank | North Carolina | 37139 | 1693 | 43 |
867240 | 867240 | 2020-12-26 | Pasquotank | North Carolina | 37139 | 1675 | 43 |
863995 | 863995 | 2020-12-25 | Pasquotank | North Carolina | 37139 | 1537 | 38 |
860750 | 860750 | 2020-12-24 | Pasquotank | North Carolina | 37139 | 1537 | 38 |
857505 | 857505 | 2020-12-23 | Pasquotank | North Carolina | 37139 | 1537 | 38 |
854260 | 854260 | 2020-12-22 | Pasquotank | North Carolina | 37139 | 1524 | 38 |
851015 | 851015 | 2020-12-21 | Pasquotank | North Carolina | 37139 | 1506 | 38 |
847770 | 847770 | 2020-12-20 | Pasquotank | North Carolina | 37139 | 1489 | 38 |
844525 | 844525 | 2020-12-19 | Pasquotank | North Carolina | 37139 | 1472 | 38 |
841279 | 841279 | 2020-12-18 | Pasquotank | North Carolina | 37139 | 1457 | 38 |
838034 | 838034 | 2020-12-17 | Pasquotank | North Carolina | 37139 | 1388 | 38 |
834788 | 834788 | 2020-12-16 | Pasquotank | North Carolina | 37139 | 1356 | 37 |
831542 | 831542 | 2020-12-15 | Pasquotank | North Carolina | 37139 | 1347 | 36 |
828295 | 828295 | 2020-12-14 | Pasquotank | North Carolina | 37139 | 1329 | 36 |
825049 | 825049 | 2020-12-13 | Pasquotank | North Carolina | 37139 | 1312 | 36 |
821802 | 821802 | 2020-12-12 | Pasquotank | North Carolina | 37139 | 1295 | 36 |
818556 | 818556 | 2020-12-11 | Pasquotank | North Carolina | 37139 | 1266 | 35 |
815310 | 815310 | 2020-12-10 | Pasquotank | North Carolina | 37139 | 1245 | 35 |
812065 | 812065 | 2020-12-09 | Pasquotank | North Carolina | 37139 | 1215 | 35 |
808820 | 808820 | 2020-12-08 | Pasquotank | North Carolina | 37139 | 1194 | 35 |
805575 | 805575 | 2020-12-07 | Pasquotank | North Carolina | 37139 | 1188 | 35 |
802330 | 802330 | 2020-12-06 | Pasquotank | North Carolina | 37139 | 1172 | 35 |
799085 | 799085 | 2020-12-05 | Pasquotank | North Carolina | 37139 | 1150 | 35 |
795840 | 795840 | 2020-12-04 | Pasquotank | North Carolina | 37139 | 1147 | 35 |
792595 | 792595 | 2020-12-03 | Pasquotank | North Carolina | 37139 | 1129 | 35 |
789350 | 789350 | 2020-12-02 | Pasquotank | North Carolina | 37139 | 1123 | 35 |
786105 | 786105 | 2020-12-01 | Pasquotank | North Carolina | 37139 | 1122 | 35 |
782861 | 782861 | 2020-11-30 | Pasquotank | North Carolina | 37139 | 1104 | 35 |
779615 | 779615 | 2020-11-29 | Pasquotank | North Carolina | 37139 | 1099 | 35 |
776370 | 776370 | 2020-11-28 | Pasquotank | North Carolina | 37139 | 1085 | 35 |
773125 | 773125 | 2020-11-27 | Pasquotank | North Carolina | 37139 | 1067 | 35 |
769880 | 769880 | 2020-11-26 | Pasquotank | North Carolina | 37139 | 1050 | 35 |
766634 | 766634 | 2020-11-25 | Pasquotank | North Carolina | 37139 | 1050 | 35 |
763389 | 763389 | 2020-11-24 | Pasquotank | North Carolina | 37139 | 1041 | 35 |
760144 | 760144 | 2020-11-23 | Pasquotank | North Carolina | 37139 | 1031 | 35 |
756898 | 756898 | 2020-11-22 | Pasquotank | North Carolina | 37139 | 1022 | 35 |
753651 | 753651 | 2020-11-21 | Pasquotank | North Carolina | 37139 | 1020 | 35 |
750405 | 750405 | 2020-11-20 | Pasquotank | North Carolina | 37139 | 1013 | 35 |
747159 | 747159 | 2020-11-19 | Pasquotank | North Carolina | 37139 | 1009 | 35 |
743913 | 743913 | 2020-11-18 | Pasquotank | North Carolina | 37139 | 1007 | 35 |
740666 | 740666 | 2020-11-17 | Pasquotank | North Carolina | 37139 | 1002 | 35 |
737421 | 737421 | 2020-11-16 | Pasquotank | North Carolina | 37139 | 997 | 35 |
734177 | 734177 | 2020-11-15 | Pasquotank | North Carolina | 37139 | 990 | 35 |
730931 | 730931 | 2020-11-14 | Pasquotank | North Carolina | 37139 | 975 | 35 |
727687 | 727687 | 2020-11-13 | Pasquotank | North Carolina | 37139 | 966 | 35 |
724443 | 724443 | 2020-11-12 | Pasquotank | North Carolina | 37139 | 964 | 35 |
721200 | 721200 | 2020-11-11 | Pasquotank | North Carolina | 37139 | 957 | 35 |
717957 | 717957 | 2020-11-10 | Pasquotank | North Carolina | 37139 | 946 | 35 |
714714 | 714714 | 2020-11-09 | Pasquotank | North Carolina | 37139 | 934 | 35 |
711470 | 711470 | 2020-11-08 | Pasquotank | North Carolina | 37139 | 930 | 35 |
708226 | 708226 | 2020-11-07 | Pasquotank | North Carolina | 37139 | 924 | 35 |
704983 | 704983 | 2020-11-06 | Pasquotank | North Carolina | 37139 | 916 | 35 |
701740 | 701740 | 2020-11-05 | Pasquotank | North Carolina | 37139 | 916 | 35 |
698496 | 698496 | 2020-11-04 | Pasquotank | North Carolina | 37139 | 909 | 35 |
695253 | 695253 | 2020-11-03 | Pasquotank | North Carolina | 37139 | 908 | 35 |
692011 | 692011 | 2020-11-02 | Pasquotank | North Carolina | 37139 | 907 | 35 |
688767 | 688767 | 2020-11-01 | Pasquotank | North Carolina | 37139 | 904 | 35 |
685522 | 685522 | 2020-10-31 | Pasquotank | North Carolina | 37139 | 902 | 35 |
682279 | 682279 | 2020-10-30 | Pasquotank | North Carolina | 37139 | 893 | 35 |
679036 | 679036 | 2020-10-29 | Pasquotank | North Carolina | 37139 | 881 | 35 |
675793 | 675793 | 2020-10-28 | Pasquotank | North Carolina | 37139 | 873 | 35 |
672550 | 672550 | 2020-10-27 | Pasquotank | North Carolina | 37139 | 863 | 35 |
669308 | 669308 | 2020-10-26 | Pasquotank | North Carolina | 37139 | 858 | 35 |
666064 | 666064 | 2020-10-25 | Pasquotank | North Carolina | 37139 | 856 | 35 |
662819 | 662819 | 2020-10-24 | Pasquotank | North Carolina | 37139 | 852 | 35 |
659575 | 659575 | 2020-10-23 | Pasquotank | North Carolina | 37139 | 840 | 35 |
656331 | 656331 | 2020-10-22 | Pasquotank | North Carolina | 37139 | 835 | 35 |
653086 | 653086 | 2020-10-21 | Pasquotank | North Carolina | 37139 | 830 | 33 |
649841 | 649841 | 2020-10-20 | Pasquotank | North Carolina | 37139 | 825 | 33 |
646597 | 646597 | 2020-10-19 | Pasquotank | North Carolina | 37139 | 823 | 33 |
643351 | 643351 | 2020-10-18 | Pasquotank | North Carolina | 37139 | 820 | 33 |
640103 | 640103 | 2020-10-17 | Pasquotank | North Carolina | 37139 | 816 | 33 |
636857 | 636857 | 2020-10-16 | Pasquotank | North Carolina | 37139 | 806 | 33 |
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);