ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,729 rows where deaths = 3 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Tyrrell 107
- Washington 94
- Camden 93
- Carteret 79
- Gates 77
- Jones 73
- Stokes 64
- Mitchell 63
- Swain 61
- Dare 60
- Greene 59
- Ashe 55
- Davie 43
- Anson 41
- Pamlico 41
- Perquimans 38
- Clay 37
- Onslow 33
- New Hanover 29
- Gaston 27
- Pender 27
- Nash 26
- Rockingham 25
- Alleghany 23
- Caswell 23
- Jackson 21
- Chowan 20
- Hoke 20
- Alexander 17
- Caldwell 17
- …
state 1
- North Carolina · 1,729 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
980758 | 980758 | 2021-01-30 | Alleghany | North Carolina | 37005 | 821 | 3 |
977512 | 977512 | 2021-01-29 | Alleghany | North Carolina | 37005 | 821 | 3 |
974267 | 974267 | 2021-01-28 | Alleghany | North Carolina | 37005 | 819 | 3 |
971022 | 971022 | 2021-01-27 | Alleghany | North Carolina | 37005 | 814 | 3 |
967777 | 967777 | 2021-01-26 | Alleghany | North Carolina | 37005 | 810 | 3 |
964533 | 964533 | 2021-01-25 | Alleghany | North Carolina | 37005 | 809 | 3 |
961288 | 961288 | 2021-01-24 | Alleghany | North Carolina | 37005 | 808 | 3 |
958043 | 958043 | 2021-01-23 | Alleghany | North Carolina | 37005 | 800 | 3 |
954797 | 954797 | 2021-01-22 | Alleghany | North Carolina | 37005 | 798 | 3 |
951552 | 951552 | 2021-01-21 | Alleghany | North Carolina | 37005 | 793 | 3 |
948307 | 948307 | 2021-01-20 | Alleghany | North Carolina | 37005 | 783 | 3 |
945060 | 945060 | 2021-01-19 | Alleghany | North Carolina | 37005 | 771 | 3 |
941814 | 941814 | 2021-01-18 | Alleghany | North Carolina | 37005 | 768 | 3 |
938569 | 938569 | 2021-01-17 | Alleghany | North Carolina | 37005 | 768 | 3 |
935324 | 935324 | 2021-01-16 | Alleghany | North Carolina | 37005 | 761 | 3 |
932079 | 932079 | 2021-01-15 | Alleghany | North Carolina | 37005 | 757 | 3 |
928834 | 928834 | 2021-01-14 | Alleghany | North Carolina | 37005 | 752 | 3 |
925589 | 925589 | 2021-01-13 | Alleghany | North Carolina | 37005 | 744 | 3 |
922343 | 922343 | 2021-01-12 | Alleghany | North Carolina | 37005 | 739 | 3 |
919098 | 919098 | 2021-01-11 | Alleghany | North Carolina | 37005 | 737 | 3 |
915853 | 915853 | 2021-01-10 | Alleghany | North Carolina | 37005 | 736 | 3 |
912608 | 912608 | 2021-01-09 | Alleghany | North Carolina | 37005 | 733 | 3 |
909363 | 909363 | 2021-01-08 | Alleghany | North Carolina | 37005 | 724 | 3 |
909449 | 909449 | 2021-01-08 | Tyrrell | North Carolina | 37177 | 194 | 3 |
906204 | 906204 | 2021-01-07 | Tyrrell | North Carolina | 37177 | 191 | 3 |
902958 | 902958 | 2021-01-06 | Tyrrell | North Carolina | 37177 | 185 | 3 |
899713 | 899713 | 2021-01-05 | Tyrrell | North Carolina | 37177 | 184 | 3 |
896468 | 896468 | 2021-01-04 | Tyrrell | North Carolina | 37177 | 182 | 3 |
893222 | 893222 | 2021-01-03 | Tyrrell | North Carolina | 37177 | 182 | 3 |
889976 | 889976 | 2021-01-02 | Tyrrell | North Carolina | 37177 | 177 | 3 |
886729 | 886729 | 2021-01-01 | Tyrrell | North Carolina | 37177 | 169 | 3 |
883484 | 883484 | 2020-12-31 | Tyrrell | North Carolina | 37177 | 169 | 3 |
880239 | 880239 | 2020-12-30 | Tyrrell | North Carolina | 37177 | 169 | 3 |
876994 | 876994 | 2020-12-29 | Tyrrell | North Carolina | 37177 | 166 | 3 |
873749 | 873749 | 2020-12-28 | Tyrrell | North Carolina | 37177 | 165 | 3 |
870504 | 870504 | 2020-12-27 | Tyrrell | North Carolina | 37177 | 164 | 3 |
867259 | 867259 | 2020-12-26 | Tyrrell | North Carolina | 37177 | 163 | 3 |
864014 | 864014 | 2020-12-25 | Tyrrell | North Carolina | 37177 | 162 | 3 |
860769 | 860769 | 2020-12-24 | Tyrrell | North Carolina | 37177 | 162 | 3 |
857524 | 857524 | 2020-12-23 | Tyrrell | North Carolina | 37177 | 162 | 3 |
854279 | 854279 | 2020-12-22 | Tyrrell | North Carolina | 37177 | 162 | 3 |
851034 | 851034 | 2020-12-21 | Tyrrell | North Carolina | 37177 | 162 | 3 |
847789 | 847789 | 2020-12-20 | Tyrrell | North Carolina | 37177 | 162 | 3 |
844544 | 844544 | 2020-12-19 | Tyrrell | North Carolina | 37177 | 162 | 3 |
841298 | 841298 | 2020-12-18 | Tyrrell | North Carolina | 37177 | 161 | 3 |
838053 | 838053 | 2020-12-17 | Tyrrell | North Carolina | 37177 | 159 | 3 |
834807 | 834807 | 2020-12-16 | Tyrrell | North Carolina | 37177 | 159 | 3 |
831477 | 831477 | 2020-12-15 | Ashe | North Carolina | 37009 | 1018 | 3 |
831561 | 831561 | 2020-12-15 | Tyrrell | North Carolina | 37177 | 159 | 3 |
828230 | 828230 | 2020-12-14 | Ashe | North Carolina | 37009 | 1009 | 3 |
828314 | 828314 | 2020-12-14 | Tyrrell | North Carolina | 37177 | 159 | 3 |
824984 | 824984 | 2020-12-13 | Ashe | North Carolina | 37009 | 995 | 3 |
825068 | 825068 | 2020-12-13 | Tyrrell | North Carolina | 37177 | 158 | 3 |
821737 | 821737 | 2020-12-12 | Ashe | North Carolina | 37009 | 977 | 3 |
821821 | 821821 | 2020-12-12 | Tyrrell | North Carolina | 37177 | 158 | 3 |
818491 | 818491 | 2020-12-11 | Ashe | North Carolina | 37009 | 956 | 3 |
818575 | 818575 | 2020-12-11 | Tyrrell | North Carolina | 37177 | 157 | 3 |
818586 | 818586 | 2020-12-11 | Yancey | North Carolina | 37199 | 763 | 3 |
815245 | 815245 | 2020-12-10 | Ashe | North Carolina | 37009 | 941 | 3 |
815329 | 815329 | 2020-12-10 | Tyrrell | North Carolina | 37177 | 155 | 3 |
815340 | 815340 | 2020-12-10 | Yancey | North Carolina | 37199 | 717 | 3 |
812000 | 812000 | 2020-12-09 | Ashe | North Carolina | 37009 | 935 | 3 |
812084 | 812084 | 2020-12-09 | Tyrrell | North Carolina | 37177 | 153 | 3 |
808755 | 808755 | 2020-12-08 | Ashe | North Carolina | 37009 | 910 | 3 |
808819 | 808819 | 2020-12-08 | Pamlico | North Carolina | 37137 | 440 | 3 |
808839 | 808839 | 2020-12-08 | Tyrrell | North Carolina | 37177 | 151 | 3 |
805510 | 805510 | 2020-12-07 | Ashe | North Carolina | 37009 | 849 | 3 |
805574 | 805574 | 2020-12-07 | Pamlico | North Carolina | 37137 | 435 | 3 |
805594 | 805594 | 2020-12-07 | Tyrrell | North Carolina | 37177 | 149 | 3 |
802265 | 802265 | 2020-12-06 | Ashe | North Carolina | 37009 | 842 | 3 |
802329 | 802329 | 2020-12-06 | Pamlico | North Carolina | 37137 | 437 | 3 |
802349 | 802349 | 2020-12-06 | Tyrrell | North Carolina | 37177 | 144 | 3 |
799020 | 799020 | 2020-12-05 | Ashe | North Carolina | 37009 | 831 | 3 |
799084 | 799084 | 2020-12-05 | Pamlico | North Carolina | 37137 | 429 | 3 |
799104 | 799104 | 2020-12-05 | Tyrrell | North Carolina | 37177 | 142 | 3 |
795775 | 795775 | 2020-12-04 | Ashe | North Carolina | 37009 | 817 | 3 |
795839 | 795839 | 2020-12-04 | Pamlico | North Carolina | 37137 | 425 | 3 |
795859 | 795859 | 2020-12-04 | Tyrrell | North Carolina | 37177 | 142 | 3 |
792530 | 792530 | 2020-12-03 | Ashe | North Carolina | 37009 | 805 | 3 |
792594 | 792594 | 2020-12-03 | Pamlico | North Carolina | 37137 | 419 | 3 |
792614 | 792614 | 2020-12-03 | Tyrrell | North Carolina | 37177 | 141 | 3 |
789285 | 789285 | 2020-12-02 | Ashe | North Carolina | 37009 | 802 | 3 |
789349 | 789349 | 2020-12-02 | Pamlico | North Carolina | 37137 | 411 | 3 |
789369 | 789369 | 2020-12-02 | Tyrrell | North Carolina | 37177 | 141 | 3 |
786040 | 786040 | 2020-12-01 | Ashe | North Carolina | 37009 | 795 | 3 |
786104 | 786104 | 2020-12-01 | Pamlico | North Carolina | 37137 | 406 | 3 |
786124 | 786124 | 2020-12-01 | Tyrrell | North Carolina | 37177 | 140 | 3 |
782796 | 782796 | 2020-11-30 | Ashe | North Carolina | 37009 | 791 | 3 |
782860 | 782860 | 2020-11-30 | Pamlico | North Carolina | 37137 | 402 | 3 |
782880 | 782880 | 2020-11-30 | Tyrrell | North Carolina | 37177 | 140 | 3 |
779550 | 779550 | 2020-11-29 | Ashe | North Carolina | 37009 | 784 | 3 |
779614 | 779614 | 2020-11-29 | Pamlico | North Carolina | 37137 | 402 | 3 |
779634 | 779634 | 2020-11-29 | Tyrrell | North Carolina | 37177 | 140 | 3 |
776305 | 776305 | 2020-11-28 | Ashe | North Carolina | 37009 | 778 | 3 |
776369 | 776369 | 2020-11-28 | Pamlico | North Carolina | 37137 | 402 | 3 |
776389 | 776389 | 2020-11-28 | Tyrrell | North Carolina | 37177 | 140 | 3 |
773060 | 773060 | 2020-11-27 | Ashe | North Carolina | 37009 | 757 | 3 |
773124 | 773124 | 2020-11-27 | Pamlico | North Carolina | 37137 | 397 | 3 |
773144 | 773144 | 2020-11-27 | Tyrrell | North Carolina | 37177 | 140 | 3 |
769815 | 769815 | 2020-11-26 | Ashe | North Carolina | 37009 | 742 | 3 |
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);