ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where "date" is on date 2021-02-01 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
- Alamance 1
- Alexander 1
- Alleghany 1
- Anson 1
- Ashe 1
- Avery 1
- Beaufort 1
- Bertie 1
- Bladen 1
- Brunswick 1
- Buncombe 1
- Burke 1
- Cabarrus 1
- Caldwell 1
- Camden 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
- …
state 1
- North Carolina · 100 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
987250 | 987250 | 2021-02-01 | Alamance | North Carolina | 37001 | 13852 | 172 |
987251 | 987251 | 2021-02-01 | Alexander | North Carolina | 37003 | 3514 | 59 |
987252 | 987252 | 2021-02-01 | Alleghany | North Carolina | 37005 | 830 | 4 |
987253 | 987253 | 2021-02-01 | Anson | North Carolina | 37007 | 2046 | 42 |
987254 | 987254 | 2021-02-01 | Ashe | North Carolina | 37009 | 1688 | 34 |
987255 | 987255 | 2021-02-01 | Avery | North Carolina | 37011 | 1684 | 16 |
987256 | 987256 | 2021-02-01 | Beaufort | North Carolina | 37013 | 3802 | 71 |
987257 | 987257 | 2021-02-01 | Bertie | North Carolina | 37015 | 1535 | 35 |
987258 | 987258 | 2021-02-01 | Bladen | North Carolina | 37017 | 2633 | 34 |
987259 | 987259 | 2021-02-01 | Brunswick | North Carolina | 37019 | 6623 | 102 |
987260 | 987260 | 2021-02-01 | Buncombe | North Carolina | 37021 | 13402 | 263 |
987261 | 987261 | 2021-02-01 | Burke | North Carolina | 37023 | 8532 | 106 |
987262 | 987262 | 2021-02-01 | Cabarrus | North Carolina | 37025 | 16063 | 194 |
987263 | 987263 | 2021-02-01 | Caldwell | North Carolina | 37027 | 7892 | 40 |
987264 | 987264 | 2021-02-01 | Camden | North Carolina | 37029 | 470 | 5 |
987265 | 987265 | 2021-02-01 | Carteret | North Carolina | 37031 | 3780 | 19 |
987266 | 987266 | 2021-02-01 | Caswell | North Carolina | 37033 | 1755 | 15 |
987267 | 987267 | 2021-02-01 | Catawba | North Carolina | 37035 | 15732 | 240 |
987268 | 987268 | 2021-02-01 | Chatham | North Carolina | 37037 | 3744 | 70 |
987269 | 987269 | 2021-02-01 | Cherokee | North Carolina | 37039 | 1882 | 17 |
987270 | 987270 | 2021-02-01 | Chowan | North Carolina | 37041 | 1222 | 21 |
987271 | 987271 | 2021-02-01 | Clay | North Carolina | 37043 | 597 | 5 |
987272 | 987272 | 2021-02-01 | Cleveland | North Carolina | 37045 | 9386 | 189 |
987273 | 987273 | 2021-02-01 | Columbus | North Carolina | 37047 | 5187 | 115 |
987274 | 987274 | 2021-02-01 | Craven | North Carolina | 37049 | 7215 | 106 |
987275 | 987275 | 2021-02-01 | Cumberland | North Carolina | 37051 | 20407 | 207 |
987276 | 987276 | 2021-02-01 | Currituck | North Carolina | 37053 | 1122 | 14 |
987277 | 987277 | 2021-02-01 | Dare | North Carolina | 37055 | 1698 | 6 |
987278 | 987278 | 2021-02-01 | Davidson | North Carolina | 37057 | 13058 | 127 |
987279 | 987279 | 2021-02-01 | Davie | North Carolina | 37059 | 3033 | 20 |
987280 | 987280 | 2021-02-01 | Duplin | North Carolina | 37061 | 5284 | 115 |
987281 | 987281 | 2021-02-01 | Durham | North Carolina | 37063 | 19847 | 187 |
987282 | 987282 | 2021-02-01 | Edgecombe | North Carolina | 37065 | 4010 | 90 |
987283 | 987283 | 2021-02-01 | Forsyth | North Carolina | 37067 | 27913 | 280 |
987284 | 987284 | 2021-02-01 | Franklin | North Carolina | 37069 | 4652 | 41 |
987285 | 987285 | 2021-02-01 | Gaston | North Carolina | 37071 | 21506 | 325 |
987286 | 987286 | 2021-02-01 | Gates | North Carolina | 37073 | 550 | 12 |
987287 | 987287 | 2021-02-01 | Graham | North Carolina | 37075 | 530 | 12 |
987288 | 987288 | 2021-02-01 | Granville | North Carolina | 37077 | 4709 | 73 |
987289 | 987289 | 2021-02-01 | Greene | North Carolina | 37079 | 1966 | 35 |
987290 | 987290 | 2021-02-01 | Guilford | North Carolina | 37081 | 35206 | 414 |
987291 | 987291 | 2021-02-01 | Halifax | North Carolina | 37083 | 4341 | 81 |
987292 | 987292 | 2021-02-01 | Harnett | North Carolina | 37085 | 8311 | 117 |
987293 | 987293 | 2021-02-01 | Haywood | North Carolina | 37087 | 3361 | 76 |
987294 | 987294 | 2021-02-01 | Henderson | North Carolina | 37089 | 7730 | 127 |
987295 | 987295 | 2021-02-01 | Hertford | North Carolina | 37091 | 1804 | 55 |
987296 | 987296 | 2021-02-01 | Hoke | North Carolina | 37093 | 3692 | 47 |
987297 | 987297 | 2021-02-01 | Hyde | North Carolina | 37095 | 588 | 6 |
987298 | 987298 | 2021-02-01 | Iredell | North Carolina | 37097 | 14237 | 157 |
987299 | 987299 | 2021-02-01 | Jackson | North Carolina | 37099 | 3017 | 24 |
987300 | 987300 | 2021-02-01 | Johnston | North Carolina | 37101 | 15813 | 163 |
987301 | 987301 | 2021-02-01 | Jones | North Carolina | 37103 | 592 | 16 |
987302 | 987302 | 2021-02-01 | Lee | North Carolina | 37105 | 4859 | 56 |
987303 | 987303 | 2021-02-01 | Lenoir | North Carolina | 37107 | 4630 | 91 |
987304 | 987304 | 2021-02-01 | Lincoln | North Carolina | 37109 | 7939 | 50 |
987305 | 987305 | 2021-02-01 | Macon | North Carolina | 37113 | 2268 | 12 |
987306 | 987306 | 2021-02-01 | Madison | North Carolina | 37115 | 1221 | 30 |
987307 | 987307 | 2021-02-01 | Martin | North Carolina | 37117 | 1875 | 29 |
987308 | 987308 | 2021-02-01 | McDowell | North Carolina | 37111 | 4353 | 50 |
987309 | 987309 | 2021-02-01 | Mecklenburg | North Carolina | 37119 | 86860 | 786 |
987310 | 987310 | 2021-02-01 | Mitchell | North Carolina | 37121 | 1149 | 13 |
987311 | 987311 | 2021-02-01 | Montgomery | North Carolina | 37123 | 2742 | 68 |
987312 | 987312 | 2021-02-01 | Moore | North Carolina | 37125 | 7084 | 130 |
987313 | 987313 | 2021-02-01 | Nash | North Carolina | 37127 | 8157 | 138 |
987314 | 987314 | 2021-02-01 | New Hanover | North Carolina | 37129 | 13784 | 130 |
987315 | 987315 | 2021-02-01 | Northampton | North Carolina | 37131 | 1521 | 27 |
987316 | 987316 | 2021-02-01 | Onslow | North Carolina | 37133 | 13122 | 114 |
987317 | 987317 | 2021-02-01 | Orange | North Carolina | 37135 | 6823 | 82 |
987318 | 987318 | 2021-02-01 | Pamlico | North Carolina | 37137 | 768 | 7 |
987319 | 987319 | 2021-02-01 | Pasquotank | North Carolina | 37139 | 2708 | 74 |
987320 | 987320 | 2021-02-01 | Pender | North Carolina | 37141 | 4124 | 47 |
987321 | 987321 | 2021-02-01 | Perquimans | North Carolina | 37143 | 773 | 5 |
987322 | 987322 | 2021-02-01 | Person | North Carolina | 37145 | 2503 | 50 |
987323 | 987323 | 2021-02-01 | Pitt | North Carolina | 37147 | 15450 | 71 |
987324 | 987324 | 2021-02-01 | Polk | North Carolina | 37149 | 1190 | 19 |
987325 | 987325 | 2021-02-01 | Randolph | North Carolina | 37151 | 11508 | 179 |
987326 | 987326 | 2021-02-01 | Richmond | North Carolina | 37153 | 3682 | 71 |
987327 | 987327 | 2021-02-01 | Robeson | North Carolina | 37155 | 13424 | 180 |
987328 | 987328 | 2021-02-01 | Rockingham | North Carolina | 37157 | 6278 | 43 |
987329 | 987329 | 2021-02-01 | Rowan | North Carolina | 37159 | 13080 | 246 |
987330 | 987330 | 2021-02-01 | Rutherford | North Carolina | 37161 | 6262 | 173 |
987331 | 987331 | 2021-02-01 | Sampson | North Carolina | 37163 | 6148 | 80 |
987332 | 987332 | 2021-02-01 | Scotland | North Carolina | 37165 | 3172 | 65 |
987333 | 987333 | 2021-02-01 | Stanly | North Carolina | 37167 | 6024 | 93 |
987334 | 987334 | 2021-02-01 | Stokes | North Carolina | 37169 | 3173 | 56 |
987335 | 987335 | 2021-02-01 | Surry | North Carolina | 37171 | 6359 | 111 |
987336 | 987336 | 2021-02-01 | Swain | North Carolina | 37173 | 1068 | 15 |
987337 | 987337 | 2021-02-01 | Transylvania | North Carolina | 37175 | 1634 | 15 |
987338 | 987338 | 2021-02-01 | Tyrrell | North Carolina | 37177 | 264 | 6 |
987339 | 987339 | 2021-02-01 | Union | North Carolina | 37179 | 18345 | 152 |
987340 | 987340 | 2021-02-01 | Vance | North Carolina | 37181 | 3712 | 75 |
987341 | 987341 | 2021-02-01 | Wake | North Carolina | 37183 | 66925 | 427 |
987342 | 987342 | 2021-02-01 | Warren | North Carolina | 37185 | 1423 | 13 |
987343 | 987343 | 2021-02-01 | Washington | North Carolina | 37187 | 799 | 22 |
987344 | 987344 | 2021-02-01 | Watauga | North Carolina | 37189 | 3350 | 24 |
987345 | 987345 | 2021-02-01 | Wayne | North Carolina | 37191 | 9310 | 186 |
987346 | 987346 | 2021-02-01 | Wilkes | North Carolina | 37193 | 5399 | 91 |
987347 | 987347 | 2021-02-01 | Wilson | North Carolina | 37195 | 7416 | 133 |
987348 | 987348 | 2021-02-01 | Yadkin | North Carolina | 37197 | 3322 | 39 |
987349 | 987349 | 2021-02-01 | Yancey | North Carolina | 37199 | 1335 | 22 |
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);