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 590
- 37037 587
- 37025 581
- 37067 581
- 37101 581
- 37119 581
- 37133 581
- 37191 580
- 37019 579
- 37049 579
- 37085 579
- 37189 578
- 37195 578
- 37063 577
- 37097 576
- 37163 576
- 37071 575
- 37081 575
- 37093 575
- 37109 575
- 37125 575
- 37129 575
- 37031 573
- 37057 573
- 37069 573
- 37135 573
- 37139 573
- 37147 573
- 37159 573
- 37167 573
- …
county >30
- Wake 590
- Chatham 587
- Cabarrus 581
- Forsyth 581
- Johnston 581
- Mecklenburg 581
- Onslow 581
- Wayne 580
- Brunswick 579
- Craven 579
- Harnett 579
- Watauga 578
- Wilson 578
- Durham 577
- Iredell 576
- Sampson 576
- Gaston 575
- Guilford 575
- Hoke 575
- Lincoln 575
- Moore 575
- New Hanover 575
- Carteret 573
- Davidson 573
- Franklin 573
- Orange 573
- Pasquotank 573
- Pitt 573
- Rowan 573
- Stanly 573
- …
state 1
- North Carolina · 56,609 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1812023 | 1812023 | 2021-10-13 | Alamance | North Carolina | 37001 | 25792 | 323 |
1812024 | 1812024 | 2021-10-13 | Alexander | North Carolina | 37003 | 6312 | 112 |
1812025 | 1812025 | 2021-10-13 | Alleghany | North Carolina | 37005 | 1586 | 5 |
1812026 | 1812026 | 2021-10-13 | Anson | North Carolina | 37007 | 3765 | 75 |
1812027 | 1812027 | 2021-10-13 | Ashe | North Carolina | 37009 | 3357 | 46 |
1812028 | 1812028 | 2021-10-13 | Avery | North Carolina | 37011 | 2673 | 32 |
1812029 | 1812029 | 2021-10-13 | Beaufort | North Carolina | 37013 | 6900 | 124 |
1812030 | 1812030 | 2021-10-13 | Bertie | North Carolina | 37015 | 2430 | 49 |
1812031 | 1812031 | 2021-10-13 | Bladen | North Carolina | 37017 | 5388 | 94 |
1812032 | 1812032 | 2021-10-13 | Brunswick | North Carolina | 37019 | 15873 | 228 |
1812033 | 1812033 | 2021-10-13 | Buncombe | North Carolina | 37021 | 27296 | 416 |
1812034 | 1812034 | 2021-10-13 | Burke | North Carolina | 37023 | 15385 | 212 |
1812035 | 1812035 | 2021-10-13 | Cabarrus | North Carolina | 37025 | 32149 | 325 |
1812036 | 1812036 | 2021-10-13 | Caldwell | North Carolina | 37027 | 12976 | 200 |
1812037 | 1812037 | 2021-10-13 | Camden | North Carolina | 37029 | 1078 | 8 |
1812038 | 1812038 | 2021-10-13 | Carteret | North Carolina | 37031 | 8144 | 79 |
1812039 | 1812039 | 2021-10-13 | Caswell | North Carolina | 37033 | 3123 | 37 |
1812040 | 1812040 | 2021-10-13 | Catawba | North Carolina | 37035 | 27749 | 409 |
1812041 | 1812041 | 2021-10-13 | Chatham | North Carolina | 37037 | 6604 | 91 |
1812042 | 1812042 | 2021-10-13 | Cherokee | North Carolina | 37039 | 4592 | 74 |
1812043 | 1812043 | 2021-10-13 | Chowan | North Carolina | 37041 | 2239 | 40 |
1812044 | 1812044 | 2021-10-13 | Clay | North Carolina | 37043 | 1620 | 35 |
1812045 | 1812045 | 2021-10-13 | Cleveland | North Carolina | 37045 | 17925 | 299 |
1812046 | 1812046 | 2021-10-13 | Columbus | North Carolina | 37047 | 9871 | 221 |
1812047 | 1812047 | 2021-10-13 | Craven | North Carolina | 37049 | 14006 | 152 |
1812048 | 1812048 | 2021-10-13 | Cumberland | North Carolina | 37051 | 43865 | 453 |
1812049 | 1812049 | 2021-10-13 | Currituck | North Carolina | 37053 | 2641 | 25 |
1812050 | 1812050 | 2021-10-13 | Dare | North Carolina | 37055 | 3668 | 12 |
1812051 | 1812051 | 2021-10-13 | Davidson | North Carolina | 37057 | 25245 | 292 |
1812052 | 1812052 | 2021-10-13 | Davie | North Carolina | 37059 | 6251 | 68 |
1812053 | 1812053 | 2021-10-13 | Duplin | North Carolina | 37061 | 9733 | 173 |
1812054 | 1812054 | 2021-10-13 | Durham | North Carolina | 37063 | 34392 | 256 |
1812055 | 1812055 | 2021-10-13 | Edgecombe | North Carolina | 37065 | 7785 | 124 |
1812056 | 1812056 | 2021-10-13 | Forsyth | North Carolina | 37067 | 50506 | 537 |
1812057 | 1812057 | 2021-10-13 | Franklin | North Carolina | 37069 | 9643 | 60 |
1812058 | 1812058 | 2021-10-13 | Gaston | North Carolina | 37071 | 39114 | 587 |
1812059 | 1812059 | 2021-10-13 | Gates | North Carolina | 37073 | 1054 | 18 |
1812060 | 1812060 | 2021-10-13 | Graham | North Carolina | 37075 | 1303 | 27 |
1812061 | 1812061 | 2021-10-13 | Granville | North Carolina | 37077 | 7764 | 99 |
1812062 | 1812062 | 2021-10-13 | Greene | North Carolina | 37079 | 3241 | 55 |
1812063 | 1812063 | 2021-10-13 | Guilford | North Carolina | 37081 | 66140 | 854 |
1812064 | 1812064 | 2021-10-13 | Halifax | North Carolina | 37083 | 7682 | 133 |
1812065 | 1812065 | 2021-10-13 | Harnett | North Carolina | 37085 | 17957 | 245 |
1812066 | 1812066 | 2021-10-13 | Haywood | North Carolina | 37087 | 7209 | 136 |
1812067 | 1812067 | 2021-10-13 | Henderson | North Carolina | 37089 | 14818 | 195 |
1812068 | 1812068 | 2021-10-13 | Hertford | North Carolina | 37091 | 2758 | 70 |
1812069 | 1812069 | 2021-10-13 | Hoke | North Carolina | 37093 | 6975 | 77 |
1812070 | 1812070 | 2021-10-13 | Hyde | North Carolina | 37095 | 820 | 12 |
1812071 | 1812071 | 2021-10-13 | Iredell | North Carolina | 37097 | 28148 | 312 |
1812072 | 1812072 | 2021-10-13 | Jackson | North Carolina | 37099 | 5480 | 70 |
1812073 | 1812073 | 2021-10-13 | Johnston | North Carolina | 37101 | 31680 | 317 |
1812074 | 1812074 | 2021-10-13 | Jones | North Carolina | 37103 | 1292 | 29 |
1812075 | 1812075 | 2021-10-13 | Lee | North Carolina | 37105 | 9267 | 104 |
1812076 | 1812076 | 2021-10-13 | Lenoir | North Carolina | 37107 | 9334 | 147 |
1812077 | 1812077 | 2021-10-13 | Lincoln | North Carolina | 37109 | 14597 | 107 |
1812078 | 1812078 | 2021-10-13 | Macon | North Carolina | 37113 | 4832 | 54 |
1812079 | 1812079 | 2021-10-13 | Madison | North Carolina | 37115 | 2694 | 56 |
1812080 | 1812080 | 2021-10-13 | Martin | North Carolina | 37117 | 3562 | 64 |
1812081 | 1812081 | 2021-10-13 | McDowell | North Carolina | 37111 | 8420 | 116 |
1812082 | 1812082 | 2021-10-13 | Mecklenburg | North Carolina | 37119 | 154206 | 1204 |
1812083 | 1812083 | 2021-10-13 | Mitchell | North Carolina | 37121 | 1960 | 18 |
1812084 | 1812084 | 2021-10-13 | Montgomery | North Carolina | 37123 | 4419 | 108 |
1812085 | 1812085 | 2021-10-13 | Moore | North Carolina | 37125 | 13339 | 245 |
1812086 | 1812086 | 2021-10-13 | Nash | North Carolina | 37127 | 15079 | 225 |
1812087 | 1812087 | 2021-10-13 | New Hanover | North Carolina | 37129 | 28236 | 281 |
1812088 | 1812088 | 2021-10-13 | Northampton | North Carolina | 37131 | 2550 | 62 |
1812089 | 1812089 | 2021-10-13 | Onslow | North Carolina | 37133 | 27735 | 244 |
1812090 | 1812090 | 2021-10-13 | Orange | North Carolina | 37135 | 11550 | 109 |
1812091 | 1812091 | 2021-10-13 | Pamlico | North Carolina | 37137 | 1676 | 24 |
1812092 | 1812092 | 2021-10-13 | Pasquotank | North Carolina | 37139 | 4940 | 98 |
1812093 | 1812093 | 2021-10-13 | Pender | North Carolina | 37141 | 8651 | 95 |
1812094 | 1812094 | 2021-10-13 | Perquimans | North Carolina | 37143 | 1481 | 15 |
1812095 | 1812095 | 2021-10-13 | Person | North Carolina | 37145 | 5022 | 87 |
1812096 | 1812096 | 2021-10-13 | Pitt | North Carolina | 37147 | 29097 | 138 |
1812097 | 1812097 | 2021-10-13 | Polk | North Carolina | 37149 | 2261 | 44 |
1812098 | 1812098 | 2021-10-13 | Randolph | North Carolina | 37151 | 21166 | 301 |
1812099 | 1812099 | 2021-10-13 | Richmond | North Carolina | 37153 | 6992 | 134 |
1812100 | 1812100 | 2021-10-13 | Robeson | North Carolina | 37155 | 24637 | 420 |
1812101 | 1812101 | 2021-10-13 | Rockingham | North Carolina | 37157 | 11597 | 192 |
1812102 | 1812102 | 2021-10-13 | Rowan | North Carolina | 37159 | 25773 | 429 |
1812103 | 1812103 | 2021-10-13 | Rutherford | North Carolina | 37161 | 11103 | 302 |
1812104 | 1812104 | 2021-10-13 | Sampson | North Carolina | 37163 | 11003 | 129 |
1812105 | 1812105 | 2021-10-13 | Scotland | North Carolina | 37165 | 5619 | 105 |
1812106 | 1812106 | 2021-10-13 | Stanly | North Carolina | 37167 | 11375 | 179 |
1812107 | 1812107 | 2021-10-13 | Stokes | North Carolina | 37169 | 5999 | 102 |
1812108 | 1812108 | 2021-10-13 | Surry | North Carolina | 37171 | 11982 | 220 |
1812109 | 1812109 | 2021-10-13 | Swain | North Carolina | 37173 | 1927 | 22 |
1812110 | 1812110 | 2021-10-13 | Transylvania | North Carolina | 37175 | 3828 | 48 |
1812111 | 1812111 | 2021-10-13 | Tyrrell | North Carolina | 37177 | 538 | 7 |
1812112 | 1812112 | 2021-10-13 | Union | North Carolina | 37179 | 35502 | 320 |
1812113 | 1812113 | 2021-10-13 | Vance | North Carolina | 37181 | 6584 | 97 |
1812114 | 1812114 | 2021-10-13 | Wake | North Carolina | 37183 | 128204 | 880 |
1812115 | 1812115 | 2021-10-13 | Warren | North Carolina | 37185 | 2314 | 28 |
1812116 | 1812116 | 2021-10-13 | Washington | North Carolina | 37187 | 1553 | 37 |
1812117 | 1812117 | 2021-10-13 | Watauga | North Carolina | 37189 | 6431 | 35 |
1812118 | 1812118 | 2021-10-13 | Wayne | North Carolina | 37191 | 15542 | 297 |
1812119 | 1812119 | 2021-10-13 | Wilkes | North Carolina | 37193 | 10350 | 173 |
1812120 | 1812120 | 2021-10-13 | Wilson | North Carolina | 37195 | 12944 | 226 |
1812121 | 1812121 | 2021-10-13 | Yadkin | North Carolina | 37197 | 5858 | 70 |
1812122 | 1812122 | 2021-10-13 | Yancey | North Carolina | 37199 | 2743 | 29 |
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);