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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 37183 702
- 37037 699
- 37025 693
- 37067 693
- 37101 693
- 37119 693
- 37133 693
- 37191 693
- 37019 691
- 37049 691
- 37085 691
- 37195 691
- 37189 690
- 37063 689
- 37097 688
- 37163 688
- 37071 687
- 37081 687
- 37093 687
- 37109 687
- 37125 687
- 37129 687
- 37031 685
- 37057 685
- 37069 685
- 37135 685
- 37139 685
- 37147 685
- 37159 685
- 37167 685
- …
county >30
- Wake 702
- Chatham 699
- Cabarrus 693
- Forsyth 693
- Johnston 693
- Mecklenburg 693
- Onslow 693
- Wayne 693
- Brunswick 691
- Craven 691
- Harnett 691
- Wilson 691
- Watauga 690
- Durham 689
- Iredell 688
- Sampson 688
- Gaston 687
- Guilford 687
- Hoke 687
- Lincoln 687
- Moore 687
- New Hanover 687
- Carteret 685
- Davidson 685
- Franklin 685
- Orange 685
- Pasquotank 685
- Pitt 685
- Rowan 685
- Stanly 685
- …
state 1
- North Carolina · 67,814 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2179448 | 2179448 | 2022-02-03 | Wayne | North Carolina | 37191 | 26360 | 359 |
2179449 | 2179449 | 2022-02-03 | Wilkes | North Carolina | 37193 | 16285 | 233 |
2179450 | 2179450 | 2022-02-03 | Wilson | North Carolina | 37195 | 20129 | 260 |
2179451 | 2179451 | 2022-02-03 | Yadkin | North Carolina | 37197 | 10094 | 98 |
2179452 | 2179452 | 2022-02-03 | Yancey | North Carolina | 37199 | 4425 | 46 |
2176102 | 2176102 | 2022-02-02 | Alamance | North Carolina | 37001 | 43777 | 415 |
2176103 | 2176103 | 2022-02-02 | Alexander | North Carolina | 37003 | 9872 | 124 |
2176104 | 2176104 | 2022-02-02 | Alleghany | North Carolina | 37005 | 2673 | 11 |
2176105 | 2176105 | 2022-02-02 | Anson | North Carolina | 37007 | 6142 | 88 |
2176106 | 2176106 | 2022-02-02 | Ashe | North Carolina | 37009 | 5549 | 67 |
2176107 | 2176107 | 2022-02-02 | Avery | North Carolina | 37011 | 3977 | 39 |
2176108 | 2176108 | 2022-02-02 | Beaufort | North Carolina | 37013 | 11327 | 143 |
2176109 | 2176109 | 2022-02-02 | Bertie | North Carolina | 37015 | 4037 | 62 |
2176110 | 2176110 | 2022-02-02 | Bladen | North Carolina | 37017 | 8780 | 109 |
2176111 | 2176111 | 2022-02-02 | Brunswick | North Carolina | 37019 | 27004 | 275 |
2176112 | 2176112 | 2022-02-02 | Buncombe | North Carolina | 37021 | 46229 | 501 |
2176113 | 2176113 | 2022-02-02 | Burke | North Carolina | 37023 | 22590 | 267 |
2176114 | 2176114 | 2022-02-02 | Cabarrus | North Carolina | 37025 | 52713 | 427 |
2176115 | 2176115 | 2022-02-02 | Caldwell | North Carolina | 37027 | 20410 | 244 |
2176116 | 2176116 | 2022-02-02 | Camden | North Carolina | 37029 | 1682 | 9 |
2176117 | 2176117 | 2022-02-02 | Carteret | North Carolina | 37031 | 12430 | 83 |
2176118 | 2176118 | 2022-02-02 | Caswell | North Carolina | 37033 | 4897 | 39 |
2176119 | 2176119 | 2022-02-02 | Catawba | North Carolina | 37035 | 44564 | 502 |
2176120 | 2176120 | 2022-02-02 | Chatham | North Carolina | 37037 | 11679 | 103 |
2176121 | 2176121 | 2022-02-02 | Cherokee | North Carolina | 37039 | 6590 | 91 |
2176122 | 2176122 | 2022-02-02 | Chowan | North Carolina | 37041 | 3976 | 48 |
2176123 | 2176123 | 2022-02-02 | Clay | North Carolina | 37043 | 2382 | 38 |
2176124 | 2176124 | 2022-02-02 | Cleveland | North Carolina | 37045 | 27868 | 338 |
2176125 | 2176125 | 2022-02-02 | Columbus | North Carolina | 37047 | 14995 | 240 |
2176126 | 2176126 | 2022-02-02 | Craven | North Carolina | 37049 | 21531 | 176 |
2176127 | 2176127 | 2022-02-02 | Cumberland | North Carolina | 37051 | 75902 | 518 |
2176128 | 2176128 | 2022-02-02 | Currituck | North Carolina | 37053 | 4513 | 32 |
2176129 | 2176129 | 2022-02-02 | Dare | North Carolina | 37055 | 6916 | 18 |
2176130 | 2176130 | 2022-02-02 | Davidson | North Carolina | 37057 | 40625 | 370 |
2176131 | 2176131 | 2022-02-02 | Davie | North Carolina | 37059 | 10306 | 82 |
2176132 | 2176132 | 2022-02-02 | Duplin | North Carolina | 37061 | 14788 | 207 |
2176133 | 2176133 | 2022-02-02 | Durham | North Carolina | 37063 | 66578 | 289 |
2176134 | 2176134 | 2022-02-02 | Edgecombe | North Carolina | 37065 | 12868 | 135 |
2176135 | 2176135 | 2022-02-02 | Forsyth | North Carolina | 37067 | 86895 | 697 |
2176136 | 2176136 | 2022-02-02 | Franklin | North Carolina | 37069 | 18719 | 65 |
2176137 | 2176137 | 2022-02-02 | Gaston | North Carolina | 37071 | 61380 | 708 |
2176138 | 2176138 | 2022-02-02 | Gates | North Carolina | 37073 | 1722 | 19 |
2176139 | 2176139 | 2022-02-02 | Graham | North Carolina | 37075 | 2084 | 30 |
2176140 | 2176140 | 2022-02-02 | Granville | North Carolina | 37077 | 13341 | 110 |
2176141 | 2176141 | 2022-02-02 | Greene | North Carolina | 37079 | 5434 | 55 |
2176142 | 2176142 | 2022-02-02 | Guilford | North Carolina | 37081 | 108642 | 998 |
2176143 | 2176143 | 2022-02-02 | Halifax | North Carolina | 37083 | 13269 | 162 |
2176144 | 2176144 | 2022-02-02 | Harnett | North Carolina | 37085 | 29952 | 291 |
2176145 | 2176145 | 2022-02-02 | Haywood | North Carolina | 37087 | 11762 | 172 |
2176146 | 2176146 | 2022-02-02 | Henderson | North Carolina | 37089 | 23091 | 262 |
2176147 | 2176147 | 2022-02-02 | Hertford | North Carolina | 37091 | 4553 | 80 |
2176148 | 2176148 | 2022-02-02 | Hoke | North Carolina | 37093 | 13546 | 95 |
2176149 | 2176149 | 2022-02-02 | Hyde | North Carolina | 37095 | 1215 | 13 |
2176150 | 2176150 | 2022-02-02 | Iredell | North Carolina | 37097 | 45385 | 391 |
2176151 | 2176151 | 2022-02-02 | Jackson | North Carolina | 37099 | 8542 | 81 |
2176152 | 2176152 | 2022-02-02 | Johnston | North Carolina | 37101 | 54394 | 368 |
2176153 | 2176153 | 2022-02-02 | Jones | North Carolina | 37103 | 2042 | 38 |
2176154 | 2176154 | 2022-02-02 | Lee | North Carolina | 37105 | 15142 | 129 |
2176155 | 2176155 | 2022-02-02 | Lenoir | North Carolina | 37107 | 14737 | 184 |
2176156 | 2176156 | 2022-02-02 | Lincoln | North Carolina | 37109 | 22694 | 122 |
2176157 | 2176157 | 2022-02-02 | Macon | North Carolina | 37113 | 6826 | 98 |
2176158 | 2176158 | 2022-02-02 | Madison | North Carolina | 37115 | 4364 | 75 |
2176159 | 2176159 | 2022-02-02 | Martin | North Carolina | 37117 | 5750 | 80 |
2176160 | 2176160 | 2022-02-02 | McDowell | North Carolina | 37111 | 12173 | 142 |
2176161 | 2176161 | 2022-02-02 | Mecklenburg | North Carolina | 37119 | 262965 | 1443 |
2176162 | 2176162 | 2022-02-02 | Mitchell | North Carolina | 37121 | 2992 | 28 |
2176163 | 2176163 | 2022-02-02 | Montgomery | North Carolina | 37123 | 6921 | 115 |
2176164 | 2176164 | 2022-02-02 | Moore | North Carolina | 37125 | 22716 | 283 |
2176165 | 2176165 | 2022-02-02 | Nash | North Carolina | 37127 | 25826 | 274 |
2176166 | 2176166 | 2022-02-02 | New Hanover | North Carolina | 37129 | 45223 | 328 |
2176167 | 2176167 | 2022-02-02 | Northampton | North Carolina | 37131 | 4108 | 71 |
2176168 | 2176168 | 2022-02-02 | Onslow | North Carolina | 37133 | 46838 | 321 |
2176169 | 2176169 | 2022-02-02 | Orange | North Carolina | 37135 | 23398 | 120 |
2176170 | 2176170 | 2022-02-02 | Pamlico | North Carolina | 37137 | 2434 | 27 |
2176171 | 2176171 | 2022-02-02 | Pasquotank | North Carolina | 37139 | 7507 | 111 |
2176172 | 2176172 | 2022-02-02 | Pender | North Carolina | 37141 | 14073 | 109 |
2176173 | 2176173 | 2022-02-02 | Perquimans | North Carolina | 37143 | 2525 | 17 |
2176174 | 2176174 | 2022-02-02 | Person | North Carolina | 37145 | 8576 | 98 |
2176175 | 2176175 | 2022-02-02 | Pitt | North Carolina | 37147 | 49427 | 146 |
2176176 | 2176176 | 2022-02-02 | Polk | North Carolina | 37149 | 3536 | 49 |
2176177 | 2176177 | 2022-02-02 | Randolph | North Carolina | 37151 | 33434 | 370 |
2176178 | 2176178 | 2022-02-02 | Richmond | North Carolina | 37153 | 11772 | 170 |
2176179 | 2176179 | 2022-02-02 | Robeson | North Carolina | 37155 | 37966 | 491 |
2176180 | 2176180 | 2022-02-02 | Rockingham | North Carolina | 37157 | 20518 | 247 |
2176181 | 2176181 | 2022-02-02 | Rowan | North Carolina | 37159 | 38817 | 535 |
2176182 | 2176182 | 2022-02-02 | Rutherford | North Carolina | 37161 | 16215 | 364 |
2176183 | 2176183 | 2022-02-02 | Sampson | North Carolina | 37163 | 17244 | 147 |
2176184 | 2176184 | 2022-02-02 | Scotland | North Carolina | 37165 | 9508 | 117 |
2176185 | 2176185 | 2022-02-02 | Stanly | North Carolina | 37167 | 18466 | 222 |
2176186 | 2176186 | 2022-02-02 | Stokes | North Carolina | 37169 | 10359 | 146 |
2176187 | 2176187 | 2022-02-02 | Surry | North Carolina | 37171 | 19457 | 291 |
2176188 | 2176188 | 2022-02-02 | Swain | North Carolina | 37173 | 3107 | 33 |
2176189 | 2176189 | 2022-02-02 | Transylvania | North Carolina | 37175 | 5738 | 62 |
2176190 | 2176190 | 2022-02-02 | Tyrrell | North Carolina | 37177 | 913 | 7 |
2176191 | 2176191 | 2022-02-02 | Union | North Carolina | 37179 | 58141 | 425 |
2176192 | 2176192 | 2022-02-02 | Vance | North Carolina | 37181 | 11264 | 110 |
2176193 | 2176193 | 2022-02-02 | Wake | North Carolina | 37183 | 268740 | 967 |
2176194 | 2176194 | 2022-02-02 | Warren | North Carolina | 37185 | 3956 | 38 |
2176195 | 2176195 | 2022-02-02 | Washington | North Carolina | 37187 | 2810 | 42 |
2176196 | 2176196 | 2022-02-02 | Watauga | North Carolina | 37189 | 10840 | 49 |
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);