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 2020-12-10 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 |
---|---|---|---|---|---|---|---|
815241 | 815241 | 2020-12-10 | Alamance | North Carolina | 37001 | 8187 | 112 |
815242 | 815242 | 2020-12-10 | Alexander | North Carolina | 37003 | 1940 | 19 |
815243 | 815243 | 2020-12-10 | Alleghany | North Carolina | 37005 | 455 | 1 |
815244 | 815244 | 2020-12-10 | Anson | North Carolina | 37007 | 1051 | 18 |
815245 | 815245 | 2020-12-10 | Ashe | North Carolina | 37009 | 941 | 3 |
815246 | 815246 | 2020-12-10 | Avery | North Carolina | 37011 | 1114 | 11 |
815247 | 815247 | 2020-12-10 | Beaufort | North Carolina | 37013 | 1941 | 56 |
815248 | 815248 | 2020-12-10 | Bertie | North Carolina | 37015 | 1001 | 26 |
815249 | 815249 | 2020-12-10 | Bladen | North Carolina | 37017 | 1474 | 21 |
815250 | 815250 | 2020-12-10 | Brunswick | North Carolina | 37019 | 3482 | 66 |
815251 | 815251 | 2020-12-10 | Buncombe | North Carolina | 37021 | 6496 | 143 |
815252 | 815252 | 2020-12-10 | Burke | North Carolina | 37023 | 4813 | 69 |
815253 | 815253 | 2020-12-10 | Cabarrus | North Carolina | 37025 | 8241 | 111 |
815254 | 815254 | 2020-12-10 | Caldwell | North Carolina | 37027 | 4161 | 25 |
815255 | 815255 | 2020-12-10 | Camden | North Carolina | 37029 | 219 | 4 |
815256 | 815256 | 2020-12-10 | Carteret | North Carolina | 37031 | 2065 | 16 |
815257 | 815257 | 2020-12-10 | Caswell | North Carolina | 37033 | 924 | 8 |
815258 | 815258 | 2020-12-10 | Catawba | North Carolina | 37035 | 8197 | 105 |
815259 | 815259 | 2020-12-10 | Chatham | North Carolina | 37037 | 2509 | 65 |
815260 | 815260 | 2020-12-10 | Cherokee | North Carolina | 37039 | 1030 | 15 |
815261 | 815261 | 2020-12-10 | Chowan | North Carolina | 37041 | 691 | 19 |
815262 | 815262 | 2020-12-10 | Clay | North Carolina | 37043 | 304 | 5 |
815263 | 815263 | 2020-12-10 | Cleveland | North Carolina | 37045 | 4972 | 116 |
815264 | 815264 | 2020-12-10 | Columbus | North Carolina | 37047 | 2946 | 74 |
815265 | 815265 | 2020-12-10 | Craven | North Carolina | 37049 | 3762 | 75 |
815266 | 815266 | 2020-12-10 | Cumberland | North Carolina | 37051 | 10726 | 124 |
815267 | 815267 | 2020-12-10 | Currituck | North Carolina | 37053 | 445 | 6 |
815268 | 815268 | 2020-12-10 | Dare | North Carolina | 37055 | 752 | 4 |
815269 | 815269 | 2020-12-10 | Davidson | North Carolina | 37057 | 6260 | 58 |
815270 | 815270 | 2020-12-10 | Davie | North Carolina | 37059 | 1488 | 13 |
815271 | 815271 | 2020-12-10 | Duplin | North Carolina | 37061 | 3645 | 63 |
815272 | 815272 | 2020-12-10 | Durham | North Carolina | 37063 | 12431 | 128 |
815273 | 815273 | 2020-12-10 | Edgecombe | North Carolina | 37065 | 2788 | 75 |
815274 | 815274 | 2020-12-10 | Forsyth | North Carolina | 37067 | 15686 | 178 |
815275 | 815275 | 2020-12-10 | Franklin | North Carolina | 37069 | 2321 | 35 |
815276 | 815276 | 2020-12-10 | Gaston | North Carolina | 37071 | 11771 | 193 |
815277 | 815277 | 2020-12-10 | Gates | North Carolina | 37073 | 264 | 10 |
815278 | 815278 | 2020-12-10 | Graham | North Carolina | 37075 | 298 | 11 |
815279 | 815279 | 2020-12-10 | Granville | North Carolina | 37077 | 2847 | 59 |
815280 | 815280 | 2020-12-10 | Greene | North Carolina | 37079 | 1301 | 28 |
815281 | 815281 | 2020-12-10 | Guilford | North Carolina | 37081 | 19321 | 272 |
815282 | 815282 | 2020-12-10 | Halifax | North Carolina | 37083 | 2232 | 38 |
815283 | 815283 | 2020-12-10 | Harnett | North Carolina | 37085 | 4652 | 83 |
815284 | 815284 | 2020-12-10 | Haywood | North Carolina | 37087 | 1507 | 44 |
815285 | 815285 | 2020-12-10 | Henderson | North Carolina | 37089 | 3576 | 88 |
815286 | 815286 | 2020-12-10 | Hertford | North Carolina | 37091 | 1105 | 42 |
815287 | 815287 | 2020-12-10 | Hoke | North Carolina | 37093 | 2210 | 34 |
815288 | 815288 | 2020-12-10 | Hyde | North Carolina | 37095 | 196 | 5 |
815289 | 815289 | 2020-12-10 | Iredell | North Carolina | 37097 | 6806 | 58 |
815290 | 815290 | 2020-12-10 | Jackson | North Carolina | 37099 | 1669 | 10 |
815291 | 815291 | 2020-12-10 | Johnston | North Carolina | 37101 | 9137 | 86 |
815292 | 815292 | 2020-12-10 | Jones | North Carolina | 37103 | 315 | 15 |
815293 | 815293 | 2020-12-10 | Lee | North Carolina | 37105 | 2773 | 35 |
815294 | 815294 | 2020-12-10 | Lenoir | North Carolina | 37107 | 2548 | 58 |
815295 | 815295 | 2020-12-10 | Lincoln | North Carolina | 37109 | 4045 | 20 |
815296 | 815296 | 2020-12-10 | Macon | North Carolina | 37113 | 1024 | 9 |
815297 | 815297 | 2020-12-10 | Madison | North Carolina | 37115 | 617 | 17 |
815298 | 815298 | 2020-12-10 | Martin | North Carolina | 37117 | 953 | 21 |
815299 | 815299 | 2020-12-10 | McDowell | North Carolina | 37111 | 2264 | 36 |
815300 | 815300 | 2020-12-10 | Mecklenburg | North Carolina | 37119 | 49234 | 484 |
815301 | 815301 | 2020-12-10 | Mitchell | North Carolina | 37121 | 642 | 6 |
815302 | 815302 | 2020-12-10 | Montgomery | North Carolina | 37123 | 1544 | 43 |
815303 | 815303 | 2020-12-10 | Moore | North Carolina | 37125 | 3567 | 69 |
815304 | 815304 | 2020-12-10 | Nash | North Carolina | 37127 | 4909 | 113 |
815305 | 815305 | 2020-12-10 | New Hanover | North Carolina | 37129 | 7799 | 62 |
815306 | 815306 | 2020-12-10 | Northampton | North Carolina | 37131 | 901 | 27 |
815307 | 815307 | 2020-12-10 | Onslow | North Carolina | 37133 | 6486 | 47 |
815308 | 815308 | 2020-12-10 | Orange | North Carolina | 37135 | 4253 | 62 |
815309 | 815309 | 2020-12-10 | Pamlico | North Carolina | 37137 | 451 | 4 |
815310 | 815310 | 2020-12-10 | Pasquotank | North Carolina | 37139 | 1245 | 35 |
815311 | 815311 | 2020-12-10 | Pender | North Carolina | 37141 | 2107 | 18 |
815312 | 815312 | 2020-12-10 | Perquimans | North Carolina | 37143 | 389 | 4 |
815313 | 815313 | 2020-12-10 | Person | North Carolina | 37145 | 1183 | 14 |
815314 | 815314 | 2020-12-10 | Pitt | North Carolina | 37147 | 9038 | 58 |
815315 | 815315 | 2020-12-10 | Polk | North Carolina | 37149 | 536 | 13 |
815316 | 815316 | 2020-12-10 | Randolph | North Carolina | 37151 | 6255 | 100 |
815317 | 815317 | 2020-12-10 | Richmond | North Carolina | 37153 | 2152 | 40 |
815318 | 815318 | 2020-12-10 | Robeson | North Carolina | 37155 | 8018 | 114 |
815319 | 815319 | 2020-12-10 | Rockingham | North Carolina | 37157 | 3502 | 23 |
815320 | 815320 | 2020-12-10 | Rowan | North Carolina | 37159 | 6685 | 147 |
815321 | 815321 | 2020-12-10 | Rutherford | North Carolina | 37161 | 3017 | 92 |
815322 | 815322 | 2020-12-10 | Sampson | North Carolina | 37163 | 4061 | 52 |
815323 | 815323 | 2020-12-10 | Scotland | North Carolina | 37165 | 2154 | 45 |
815324 | 815324 | 2020-12-10 | Stanly | North Carolina | 37167 | 3371 | 78 |
815325 | 815325 | 2020-12-10 | Stokes | North Carolina | 37169 | 1395 | 22 |
815326 | 815326 | 2020-12-10 | Surry | North Carolina | 37171 | 3250 | 49 |
815327 | 815327 | 2020-12-10 | Swain | North Carolina | 37173 | 461 | 5 |
815328 | 815328 | 2020-12-10 | Transylvania | North Carolina | 37175 | 628 | 9 |
815329 | 815329 | 2020-12-10 | Tyrrell | North Carolina | 37177 | 155 | 3 |
815330 | 815330 | 2020-12-10 | Union | North Carolina | 37179 | 9186 | 82 |
815331 | 815331 | 2020-12-10 | Vance | North Carolina | 37181 | 2072 | 60 |
815332 | 815332 | 2020-12-10 | Wake | North Carolina | 37183 | 34454 | 319 |
815333 | 815333 | 2020-12-10 | Warren | North Carolina | 37185 | 891 | 8 |
815334 | 815334 | 2020-12-10 | Washington | North Carolina | 37187 | 353 | 8 |
815335 | 815335 | 2020-12-10 | Watauga | North Carolina | 37189 | 2213 | 8 |
815336 | 815336 | 2020-12-10 | Wayne | North Carolina | 37191 | 6369 | 121 |
815337 | 815337 | 2020-12-10 | Wilkes | North Carolina | 37193 | 3056 | 58 |
815338 | 815338 | 2020-12-10 | Wilson | North Carolina | 37195 | 4534 | 89 |
815339 | 815339 | 2020-12-10 | Yadkin | North Carolina | 37197 | 1829 | 19 |
815340 | 815340 | 2020-12-10 | Yancey | North Carolina | 37199 | 717 | 3 |
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);