ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
90 rows where "date" is on date 2020-04-08 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Alamance 1
- Alexander 1
- Alleghany 1
- Anson 1
- Ashe 1
- Beaufort 1
- Bertie 1
- Bladen 1
- Brunswick 1
- Buncombe 1
- Burke 1
- Cabarrus 1
- Caldwell 1
- Carteret 1
- Caswell 1
- Catawba 1
- Chatham 1
- Cherokee 1
- Chowan 1
- Clay 1
- Cleveland 1
- Columbus 1
- Craven 1
- Cumberland 1
- Currituck 1
- Dare 1
- Davidson 1
- Davie 1
- Duplin 1
- Durham 1
- …
state 1
- North Carolina · 90 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
42180 | 42180 | 2020-04-08 | Alamance | North Carolina | 37001 | 27 | 0 |
42181 | 42181 | 2020-04-08 | Alexander | North Carolina | 37003 | 2 | 0 |
42182 | 42182 | 2020-04-08 | Alleghany | North Carolina | 37005 | 2 | 0 |
42183 | 42183 | 2020-04-08 | Anson | North Carolina | 37007 | 6 | 0 |
42184 | 42184 | 2020-04-08 | Ashe | North Carolina | 37009 | 2 | 0 |
42185 | 42185 | 2020-04-08 | Beaufort | North Carolina | 37013 | 9 | 0 |
42186 | 42186 | 2020-04-08 | Bertie | North Carolina | 37015 | 10 | 1 |
42187 | 42187 | 2020-04-08 | Bladen | North Carolina | 37017 | 1 | 0 |
42188 | 42188 | 2020-04-08 | Brunswick | North Carolina | 37019 | 26 | 1 |
42189 | 42189 | 2020-04-08 | Buncombe | North Carolina | 37021 | 33 | 1 |
42190 | 42190 | 2020-04-08 | Burke | North Carolina | 37023 | 29 | 2 |
42191 | 42191 | 2020-04-08 | Cabarrus | North Carolina | 37025 | 86 | 2 |
42192 | 42192 | 2020-04-08 | Caldwell | North Carolina | 37027 | 10 | 0 |
42193 | 42193 | 2020-04-08 | Carteret | North Carolina | 37031 | 18 | 1 |
42194 | 42194 | 2020-04-08 | Caswell | North Carolina | 37033 | 2 | 0 |
42195 | 42195 | 2020-04-08 | Catawba | North Carolina | 37035 | 28 | 1 |
42196 | 42196 | 2020-04-08 | Chatham | North Carolina | 37037 | 24 | 0 |
42197 | 42197 | 2020-04-08 | Cherokee | North Carolina | 37039 | 9 | 1 |
42198 | 42198 | 2020-04-08 | Chowan | North Carolina | 37041 | 1 | 0 |
42199 | 42199 | 2020-04-08 | Clay | North Carolina | 37043 | 3 | 0 |
42200 | 42200 | 2020-04-08 | Cleveland | North Carolina | 37045 | 26 | 0 |
42201 | 42201 | 2020-04-08 | Columbus | North Carolina | 37047 | 14 | 1 |
42202 | 42202 | 2020-04-08 | Craven | North Carolina | 37049 | 19 | 0 |
42203 | 42203 | 2020-04-08 | Cumberland | North Carolina | 37051 | 64 | 0 |
42204 | 42204 | 2020-04-08 | Currituck | North Carolina | 37053 | 3 | 0 |
42205 | 42205 | 2020-04-08 | Dare | North Carolina | 37055 | 7 | 0 |
42206 | 42206 | 2020-04-08 | Davidson | North Carolina | 37057 | 73 | 1 |
42207 | 42207 | 2020-04-08 | Davie | North Carolina | 37059 | 20 | 2 |
42208 | 42208 | 2020-04-08 | Duplin | North Carolina | 37061 | 8 | 0 |
42209 | 42209 | 2020-04-08 | Durham | North Carolina | 37063 | 236 | 1 |
42210 | 42210 | 2020-04-08 | Edgecombe | North Carolina | 37065 | 12 | 0 |
42211 | 42211 | 2020-04-08 | Forsyth | North Carolina | 37067 | 104 | 2 |
42212 | 42212 | 2020-04-08 | Franklin | North Carolina | 37069 | 23 | 1 |
42213 | 42213 | 2020-04-08 | Gaston | North Carolina | 37071 | 62 | 2 |
42214 | 42214 | 2020-04-08 | Gates | North Carolina | 37073 | 3 | 0 |
42215 | 42215 | 2020-04-08 | Granville | North Carolina | 37077 | 83 | 0 |
42216 | 42216 | 2020-04-08 | Greene | North Carolina | 37079 | 10 | 0 |
42217 | 42217 | 2020-04-08 | Guilford | North Carolina | 37081 | 122 | 8 |
42218 | 42218 | 2020-04-08 | Halifax | North Carolina | 37083 | 12 | 0 |
42219 | 42219 | 2020-04-08 | Harnett | North Carolina | 37085 | 34 | 2 |
42220 | 42220 | 2020-04-08 | Haywood | North Carolina | 37087 | 3 | 0 |
42221 | 42221 | 2020-04-08 | Henderson | North Carolina | 37089 | 50 | 2 |
42222 | 42222 | 2020-04-08 | Hertford | North Carolina | 37091 | 4 | 1 |
42223 | 42223 | 2020-04-08 | Hoke | North Carolina | 37093 | 13 | 0 |
42224 | 42224 | 2020-04-08 | Iredell | North Carolina | 37097 | 57 | 1 |
42225 | 42225 | 2020-04-08 | Johnston | North Carolina | 37101 | 51 | 4 |
42226 | 42226 | 2020-04-08 | Lee | North Carolina | 37105 | 5 | 0 |
42227 | 42227 | 2020-04-08 | Lenoir | North Carolina | 37107 | 11 | 0 |
42228 | 42228 | 2020-04-08 | Lincoln | North Carolina | 37109 | 11 | 0 |
42229 | 42229 | 2020-04-08 | Macon | North Carolina | 37113 | 1 | 1 |
42230 | 42230 | 2020-04-08 | Martin | North Carolina | 37117 | 4 | 0 |
42231 | 42231 | 2020-04-08 | McDowell | North Carolina | 37111 | 10 | 0 |
42232 | 42232 | 2020-04-08 | Mecklenburg | North Carolina | 37119 | 830 | 10 |
42233 | 42233 | 2020-04-08 | Mitchell | North Carolina | 37121 | 3 | 0 |
42234 | 42234 | 2020-04-08 | Montgomery | North Carolina | 37123 | 10 | 1 |
42235 | 42235 | 2020-04-08 | Moore | North Carolina | 37125 | 37 | 0 |
42236 | 42236 | 2020-04-08 | Nash | North Carolina | 37127 | 24 | 1 |
42237 | 42237 | 2020-04-08 | New Hanover | North Carolina | 37129 | 48 | 0 |
42238 | 42238 | 2020-04-08 | Northampton | North Carolina | 37131 | 52 | 0 |
42239 | 42239 | 2020-04-08 | Onslow | North Carolina | 37133 | 23 | 1 |
42240 | 42240 | 2020-04-08 | Orange | North Carolina | 37135 | 81 | 0 |
42241 | 42241 | 2020-04-08 | Pamlico | North Carolina | 37137 | 3 | 0 |
42242 | 42242 | 2020-04-08 | Pasquotank | North Carolina | 37139 | 10 | 0 |
42243 | 42243 | 2020-04-08 | Pender | North Carolina | 37141 | 2 | 0 |
42244 | 42244 | 2020-04-08 | Perquimans | North Carolina | 37143 | 2 | 0 |
42245 | 42245 | 2020-04-08 | Person | North Carolina | 37145 | 7 | 0 |
42246 | 42246 | 2020-04-08 | Pitt | North Carolina | 37147 | 51 | 0 |
42247 | 42247 | 2020-04-08 | Polk | North Carolina | 37149 | 8 | 0 |
42248 | 42248 | 2020-04-08 | Randolph | North Carolina | 37151 | 37 | 2 |
42249 | 42249 | 2020-04-08 | Richmond | North Carolina | 37153 | 1 | 0 |
42250 | 42250 | 2020-04-08 | Robeson | North Carolina | 37155 | 6 | 0 |
42251 | 42251 | 2020-04-08 | Rockingham | North Carolina | 37157 | 8 | 1 |
42252 | 42252 | 2020-04-08 | Rowan | North Carolina | 37159 | 64 | 2 |
42253 | 42253 | 2020-04-08 | Rutherford | North Carolina | 37161 | 25 | 0 |
42254 | 42254 | 2020-04-08 | Sampson | North Carolina | 37163 | 5 | 0 |
42255 | 42255 | 2020-04-08 | Scotland | North Carolina | 37165 | 3 | 0 |
42256 | 42256 | 2020-04-08 | Stanly | North Carolina | 37167 | 8 | 0 |
42257 | 42257 | 2020-04-08 | Stokes | North Carolina | 37169 | 8 | 0 |
42258 | 42258 | 2020-04-08 | Surry | North Carolina | 37171 | 10 | 0 |
42259 | 42259 | 2020-04-08 | Transylvania | North Carolina | 37175 | 6 | 0 |
42260 | 42260 | 2020-04-08 | Union | North Carolina | 37179 | 87 | 0 |
42261 | 42261 | 2020-04-08 | Vance | North Carolina | 37181 | 14 | 0 |
42262 | 42262 | 2020-04-08 | Wake | North Carolina | 37183 | 363 | 0 |
42263 | 42263 | 2020-04-08 | Warren | North Carolina | 37185 | 3 | 0 |
42264 | 42264 | 2020-04-08 | Washington | North Carolina | 37187 | 8 | 1 |
42265 | 42265 | 2020-04-08 | Watauga | North Carolina | 37189 | 8 | 0 |
42266 | 42266 | 2020-04-08 | Wayne | North Carolina | 37191 | 34 | 0 |
42267 | 42267 | 2020-04-08 | Wilkes | North Carolina | 37193 | 4 | 1 |
42268 | 42268 | 2020-04-08 | Wilson | North Carolina | 37195 | 38 | 2 |
42269 | 42269 | 2020-04-08 | Yadkin | North Carolina | 37197 | 9 | 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);