ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
77,809 rows where state = "North Carolina" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 101
- 37183 802
- 37037 799
- 37025 793
- 37067 793
- 37101 793
- 37119 793
- 37133 793
- 37191 792
- 37019 791
- 37049 791
- 37085 791
- 37189 790
- 37195 790
- 37063 789
- 37097 788
- 37163 788
- 37071 787
- 37081 787
- 37093 787
- 37109 787
- 37125 787
- 37129 787
- 37031 785
- 37057 785
- 37069 785
- 37135 785
- 37139 785
- 37147 785
- 37159 785
- 37167 785
- 37021 784
- 37035 784
- 37039 783
- 37051 783
- 37059 783
- 37077 783
- 37089 783
- 37105 783
- 37127 783
- 37155 783
- 37165 783
- 37179 783
- 37001 782
- 37181 782
- 37123 781
- 37151 781
- 37175 781
- 37015 780
- 37023 780
- 37027 780
- 37045 780
- 37061 780
- 37091 780
- 37107 780
- 37111 780
- 37131 780
- 37013 779
- 37079 778
- 37145 778
- 37171 778
- 37065 777
- 37143 777
- 37149 777
- 37005 776
- 37033 776
- 37047 776
- 37053 776
- 37083 776
- 37137 776
- 37187 776
- 37197 776
- 37003 775
- 37161 775
- 37007 774
- 37043 774
- 37117 774
- 37157 774
- 37193 774
- 37055 772
- 37073 772
- 37113 772
- 37121 772
- 37169 772
- 37017 771
- 37041 771
- 37087 771
- 37009 770
- 37185 770
- 37141 769
- 37153 767
- 37103 765
- 37099 761
- 37177 760
- 37115 749
- 37029 747
- 37075 746
- 37095 745
- 37173 745
- 37199 741
- 37011 725
- - 1
county 101
- Wake 802
- Chatham 799
- Cabarrus 793
- Forsyth 793
- Johnston 793
- Mecklenburg 793
- Onslow 793
- Wayne 792
- Brunswick 791
- Craven 791
- Harnett 791
- Watauga 790
- Wilson 790
- Durham 789
- Iredell 788
- Sampson 788
- Gaston 787
- Guilford 787
- Hoke 787
- Lincoln 787
- Moore 787
- New Hanover 787
- Carteret 785
- Davidson 785
- Franklin 785
- Orange 785
- Pasquotank 785
- Pitt 785
- Rowan 785
- Stanly 785
- Buncombe 784
- Catawba 784
- Cherokee 783
- Cumberland 783
- Davie 783
- Granville 783
- Henderson 783
- Lee 783
- Nash 783
- Robeson 783
- Scotland 783
- Union 783
- Alamance 782
- Vance 782
- Montgomery 781
- Randolph 781
- Transylvania 781
- Bertie 780
- Burke 780
- Caldwell 780
- Cleveland 780
- Duplin 780
- Hertford 780
- Lenoir 780
- McDowell 780
- Northampton 780
- Beaufort 779
- Greene 778
- Person 778
- Surry 778
- Edgecombe 777
- Perquimans 777
- Polk 777
- Alleghany 776
- Caswell 776
- Columbus 776
- Currituck 776
- Halifax 776
- Pamlico 776
- Washington 776
- Yadkin 776
- Alexander 775
- Rutherford 775
- Anson 774
- Clay 774
- Martin 774
- Rockingham 774
- Wilkes 774
- Dare 772
- Gates 772
- Macon 772
- Mitchell 772
- Stokes 772
- Bladen 771
- Chowan 771
- Haywood 771
- Ashe 770
- Warren 770
- Pender 769
- Richmond 767
- Jones 765
- Jackson 761
- Tyrrell 760
- Madison 749
- Camden 747
- Graham 746
- Hyde 745
- Swain 745
- Yancey 741
- Avery 725
- Unknown 1
state 1
- North Carolina · 77,809 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
484 | 484 | 2020-03-03 | Wake | North Carolina | 37183 | 1 | 0 |
521 | 521 | 2020-03-04 | Wake | North Carolina | 37183 | 1 | 0 |
568 | 568 | 2020-03-05 | Wake | North Carolina | 37183 | 1 | 0 |
631 | 631 | 2020-03-06 | Chatham | North Carolina | 37037 | 1 | 0 |
632 | 632 | 2020-03-06 | Wake | North Carolina | 37183 | 1 | 0 |
720 | 720 | 2020-03-07 | Chatham | North Carolina | 37037 | 1 | 0 |
721 | 721 | 2020-03-07 | Wake | North Carolina | 37183 | 1 | 0 |
827 | 827 | 2020-03-08 | Chatham | North Carolina | 37037 | 1 | 0 |
828 | 828 | 2020-03-08 | Wake | North Carolina | 37183 | 1 | 0 |
954 | 954 | 2020-03-09 | Chatham | North Carolina | 37037 | 1 | 0 |
955 | 955 | 2020-03-09 | Wake | North Carolina | 37183 | 6 | 0 |
1105 | 1105 | 2020-03-10 | Chatham | North Carolina | 37037 | 1 | 0 |
1106 | 1106 | 2020-03-10 | Wake | North Carolina | 37183 | 6 | 0 |
1292 | 1292 | 2020-03-11 | Chatham | North Carolina | 37037 | 1 | 0 |
1293 | 1293 | 2020-03-11 | Wake | North Carolina | 37183 | 7 | 0 |
1529 | 1529 | 2020-03-12 | Cabarrus | North Carolina | 37025 | 1 | 0 |
1530 | 1530 | 2020-03-12 | Chatham | North Carolina | 37037 | 1 | 0 |
1531 | 1531 | 2020-03-12 | Forsyth | North Carolina | 37067 | 2 | 0 |
1532 | 1532 | 2020-03-12 | Johnston | North Carolina | 37101 | 1 | 0 |
1533 | 1533 | 2020-03-12 | Mecklenburg | North Carolina | 37119 | 2 | 0 |
1534 | 1534 | 2020-03-12 | Onslow | North Carolina | 37133 | 1 | 0 |
1535 | 1535 | 2020-03-12 | Wake | North Carolina | 37183 | 8 | 0 |
1823 | 1823 | 2020-03-13 | Cabarrus | North Carolina | 37025 | 1 | 0 |
1824 | 1824 | 2020-03-13 | Chatham | North Carolina | 37037 | 1 | 0 |
1825 | 1825 | 2020-03-13 | Forsyth | North Carolina | 37067 | 2 | 0 |
1826 | 1826 | 2020-03-13 | Johnston | North Carolina | 37101 | 1 | 0 |
1827 | 1827 | 2020-03-13 | Mecklenburg | North Carolina | 37119 | 2 | 0 |
1828 | 1828 | 2020-03-13 | Onslow | North Carolina | 37133 | 1 | 0 |
1829 | 1829 | 2020-03-13 | Wake | North Carolina | 37183 | 9 | 0 |
1830 | 1830 | 2020-03-13 | Wayne | North Carolina | 37191 | 1 | 0 |
2174 | 2174 | 2020-03-14 | Brunswick | North Carolina | 37019 | 1 | 0 |
2175 | 2175 | 2020-03-14 | Cabarrus | North Carolina | 37025 | 1 | 0 |
2176 | 2176 | 2020-03-14 | Chatham | North Carolina | 37037 | 1 | 0 |
2177 | 2177 | 2020-03-14 | Craven | North Carolina | 37049 | 1 | 0 |
2178 | 2178 | 2020-03-14 | Forsyth | North Carolina | 37067 | 2 | 0 |
2179 | 2179 | 2020-03-14 | Harnett | North Carolina | 37085 | 2 | 0 |
2180 | 2180 | 2020-03-14 | Johnston | North Carolina | 37101 | 2 | 0 |
2181 | 2181 | 2020-03-14 | Mecklenburg | North Carolina | 37119 | 2 | 0 |
2182 | 2182 | 2020-03-14 | Onslow | North Carolina | 37133 | 1 | 0 |
2183 | 2183 | 2020-03-14 | Wake | North Carolina | 37183 | 11 | 0 |
2184 | 2184 | 2020-03-14 | Wayne | North Carolina | 37191 | 1 | 0 |
2586 | 2586 | 2020-03-15 | Brunswick | North Carolina | 37019 | 1 | 0 |
2587 | 2587 | 2020-03-15 | Cabarrus | North Carolina | 37025 | 1 | 0 |
2588 | 2588 | 2020-03-15 | Chatham | North Carolina | 37037 | 1 | 0 |
2589 | 2589 | 2020-03-15 | Craven | North Carolina | 37049 | 1 | 0 |
2590 | 2590 | 2020-03-15 | Forsyth | North Carolina | 37067 | 2 | 0 |
2591 | 2591 | 2020-03-15 | Harnett | North Carolina | 37085 | 2 | 0 |
2592 | 2592 | 2020-03-15 | Johnston | North Carolina | 37101 | 2 | 0 |
2593 | 2593 | 2020-03-15 | Mecklenburg | North Carolina | 37119 | 4 | 0 |
2594 | 2594 | 2020-03-15 | Onslow | North Carolina | 37133 | 1 | 0 |
2595 | 2595 | 2020-03-15 | Wake | North Carolina | 37183 | 14 | 0 |
2596 | 2596 | 2020-03-15 | Watauga | North Carolina | 37189 | 1 | 0 |
2597 | 2597 | 2020-03-15 | Wayne | North Carolina | 37191 | 1 | 0 |
2598 | 2598 | 2020-03-15 | Wilson | North Carolina | 37195 | 1 | 0 |
3047 | 3047 | 2020-03-16 | Brunswick | North Carolina | 37019 | 1 | 0 |
3048 | 3048 | 2020-03-16 | Cabarrus | North Carolina | 37025 | 1 | 0 |
3049 | 3049 | 2020-03-16 | Chatham | North Carolina | 37037 | 1 | 0 |
3050 | 3050 | 2020-03-16 | Craven | North Carolina | 37049 | 1 | 0 |
3051 | 3051 | 2020-03-16 | Durham | North Carolina | 37063 | 1 | 0 |
3052 | 3052 | 2020-03-16 | Forsyth | North Carolina | 37067 | 2 | 0 |
3053 | 3053 | 2020-03-16 | Harnett | North Carolina | 37085 | 2 | 0 |
3054 | 3054 | 2020-03-16 | Johnston | North Carolina | 37101 | 2 | 0 |
3055 | 3055 | 2020-03-16 | Mecklenburg | North Carolina | 37119 | 4 | 0 |
3056 | 3056 | 2020-03-16 | Onslow | North Carolina | 37133 | 1 | 0 |
3057 | 3057 | 2020-03-16 | Wake | North Carolina | 37183 | 15 | 0 |
3058 | 3058 | 2020-03-16 | Watauga | North Carolina | 37189 | 1 | 0 |
3059 | 3059 | 2020-03-16 | Wayne | North Carolina | 37191 | 1 | 0 |
3060 | 3060 | 2020-03-16 | Wilson | North Carolina | 37195 | 1 | 0 |
3566 | 3566 | 2020-03-17 | Brunswick | North Carolina | 37019 | 1 | 0 |
3567 | 3567 | 2020-03-17 | Cabarrus | North Carolina | 37025 | 1 | 0 |
3568 | 3568 | 2020-03-17 | Chatham | North Carolina | 37037 | 1 | 0 |
3569 | 3569 | 2020-03-17 | Craven | North Carolina | 37049 | 1 | 0 |
3570 | 3570 | 2020-03-17 | Durham | North Carolina | 37063 | 1 | 0 |
3571 | 3571 | 2020-03-17 | Forsyth | North Carolina | 37067 | 2 | 0 |
3572 | 3572 | 2020-03-17 | Harnett | North Carolina | 37085 | 3 | 0 |
3573 | 3573 | 2020-03-17 | Iredell | North Carolina | 37097 | 1 | 0 |
3574 | 3574 | 2020-03-17 | Johnston | North Carolina | 37101 | 2 | 0 |
3575 | 3575 | 2020-03-17 | Mecklenburg | North Carolina | 37119 | 7 | 0 |
3576 | 3576 | 2020-03-17 | Onslow | North Carolina | 37133 | 1 | 0 |
3577 | 3577 | 2020-03-17 | Sampson | North Carolina | 37163 | 1 | 0 |
3578 | 3578 | 2020-03-17 | Wake | North Carolina | 37183 | 17 | 0 |
3579 | 3579 | 2020-03-17 | Watauga | North Carolina | 37189 | 1 | 0 |
3580 | 3580 | 2020-03-17 | Wayne | North Carolina | 37191 | 1 | 0 |
3581 | 3581 | 2020-03-17 | Wilson | North Carolina | 37195 | 1 | 0 |
4169 | 4169 | 2020-03-18 | Brunswick | North Carolina | 37019 | 1 | 0 |
4170 | 4170 | 2020-03-18 | Cabarrus | North Carolina | 37025 | 1 | 0 |
4171 | 4171 | 2020-03-18 | Chatham | North Carolina | 37037 | 3 | 0 |
4172 | 4172 | 2020-03-18 | Craven | North Carolina | 37049 | 1 | 0 |
4173 | 4173 | 2020-03-18 | Durham | North Carolina | 37063 | 12 | 0 |
4174 | 4174 | 2020-03-18 | Forsyth | North Carolina | 37067 | 2 | 0 |
4175 | 4175 | 2020-03-18 | Gaston | North Carolina | 37071 | 1 | 0 |
4176 | 4176 | 2020-03-18 | Guilford | North Carolina | 37081 | 1 | 0 |
4177 | 4177 | 2020-03-18 | Harnett | North Carolina | 37085 | 4 | 0 |
4178 | 4178 | 2020-03-18 | Hoke | North Carolina | 37093 | 1 | 0 |
4179 | 4179 | 2020-03-18 | Iredell | North Carolina | 37097 | 1 | 0 |
4180 | 4180 | 2020-03-18 | Johnston | North Carolina | 37101 | 2 | 0 |
4181 | 4181 | 2020-03-18 | Lincoln | North Carolina | 37109 | 1 | 0 |
4182 | 4182 | 2020-03-18 | Mecklenburg | North Carolina | 37119 | 11 | 0 |
4183 | 4183 | 2020-03-18 | Moore | North Carolina | 37125 | 1 | 0 |
4184 | 4184 | 2020-03-18 | New Hanover | North Carolina | 37129 | 1 | 0 |
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);