ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Pasquotank" 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 |
---|---|---|---|---|---|---|---|
1055479 | 1055479 | 2021-02-22 | Pasquotank | North Carolina | 37139 | 3015 | 74 |
1052233 | 1052233 | 2021-02-21 | Pasquotank | North Carolina | 37139 | 3009 | 74 |
1048986 | 1048986 | 2021-02-20 | Pasquotank | North Carolina | 37139 | 3007 | 74 |
1045739 | 1045739 | 2021-02-19 | Pasquotank | North Carolina | 37139 | 2995 | 74 |
1042494 | 1042494 | 2021-02-18 | Pasquotank | North Carolina | 37139 | 2981 | 74 |
1039249 | 1039249 | 2021-02-17 | Pasquotank | North Carolina | 37139 | 2954 | 74 |
1036004 | 1036004 | 2021-02-16 | Pasquotank | North Carolina | 37139 | 2946 | 74 |
1032759 | 1032759 | 2021-02-15 | Pasquotank | North Carolina | 37139 | 2945 | 74 |
1029513 | 1029513 | 2021-02-14 | Pasquotank | North Carolina | 37139 | 2942 | 74 |
1026266 | 1026266 | 2021-02-13 | Pasquotank | North Carolina | 37139 | 2924 | 74 |
1023021 | 1023021 | 2021-02-12 | Pasquotank | North Carolina | 37139 | 2905 | 74 |
1019776 | 1019776 | 2021-02-11 | Pasquotank | North Carolina | 37139 | 2879 | 74 |
1016531 | 1016531 | 2021-02-10 | Pasquotank | North Carolina | 37139 | 2858 | 74 |
1013286 | 1013286 | 2021-02-09 | Pasquotank | North Carolina | 37139 | 2849 | 74 |
1010041 | 1010041 | 2021-02-08 | Pasquotank | North Carolina | 37139 | 2843 | 74 |
1006795 | 1006795 | 2021-02-07 | Pasquotank | North Carolina | 37139 | 2824 | 74 |
1003549 | 1003549 | 2021-02-06 | Pasquotank | North Carolina | 37139 | 2807 | 74 |
1000303 | 1000303 | 2021-02-05 | Pasquotank | North Carolina | 37139 | 2767 | 74 |
997057 | 997057 | 2021-02-04 | Pasquotank | North Carolina | 37139 | 2757 | 74 |
993811 | 993811 | 2021-02-03 | Pasquotank | North Carolina | 37139 | 2742 | 74 |
990565 | 990565 | 2021-02-02 | Pasquotank | North Carolina | 37139 | 2714 | 74 |
987319 | 987319 | 2021-02-01 | Pasquotank | North Carolina | 37139 | 2708 | 74 |
984072 | 984072 | 2021-01-31 | Pasquotank | North Carolina | 37139 | 2696 | 74 |
980825 | 980825 | 2021-01-30 | Pasquotank | North Carolina | 37139 | 2627 | 71 |
977579 | 977579 | 2021-01-29 | Pasquotank | North Carolina | 37139 | 2627 | 71 |
974334 | 974334 | 2021-01-28 | Pasquotank | North Carolina | 37139 | 2607 | 71 |
971089 | 971089 | 2021-01-27 | Pasquotank | North Carolina | 37139 | 2593 | 71 |
967844 | 967844 | 2021-01-26 | Pasquotank | North Carolina | 37139 | 2582 | 71 |
964600 | 964600 | 2021-01-25 | Pasquotank | North Carolina | 37139 | 2576 | 71 |
961355 | 961355 | 2021-01-24 | Pasquotank | North Carolina | 37139 | 2558 | 71 |
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 |
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);