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-11-07 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 |
---|---|---|---|---|---|---|---|
708157 | 708157 | 2020-11-07 | Alamance | North Carolina | 37001 | 5646 | 93 |
708158 | 708158 | 2020-11-07 | Alexander | North Carolina | 37003 | 1120 | 12 |
708159 | 708159 | 2020-11-07 | Alleghany | North Carolina | 37005 | 348 | 1 |
708160 | 708160 | 2020-11-07 | Anson | North Carolina | 37007 | 767 | 13 |
708161 | 708161 | 2020-11-07 | Ashe | North Carolina | 37009 | 547 | 3 |
708162 | 708162 | 2020-11-07 | Avery | North Carolina | 37011 | 680 | 2 |
708163 | 708163 | 2020-11-07 | Beaufort | North Carolina | 37013 | 1486 | 47 |
708164 | 708164 | 2020-11-07 | Bertie | North Carolina | 37015 | 747 | 21 |
708165 | 708165 | 2020-11-07 | Bladen | North Carolina | 37017 | 1132 | 19 |
708166 | 708166 | 2020-11-07 | Brunswick | North Carolina | 37019 | 2350 | 52 |
708167 | 708167 | 2020-11-07 | Buncombe | North Carolina | 37021 | 4511 | 118 |
708168 | 708168 | 2020-11-07 | Burke | North Carolina | 37023 | 2976 | 57 |
708169 | 708169 | 2020-11-07 | Cabarrus | North Carolina | 37025 | 5345 | 95 |
708170 | 708170 | 2020-11-07 | Caldwell | North Carolina | 37027 | 2847 | 19 |
708171 | 708171 | 2020-11-07 | Camden | North Carolina | 37029 | 145 | 3 |
708172 | 708172 | 2020-11-07 | Carteret | North Carolina | 37031 | 1324 | 5 |
708173 | 708173 | 2020-11-07 | Caswell | North Carolina | 37033 | 675 | 6 |
708174 | 708174 | 2020-11-07 | Catawba | North Carolina | 37035 | 5092 | 63 |
708175 | 708175 | 2020-11-07 | Chatham | North Carolina | 37037 | 2061 | 63 |
708176 | 708176 | 2020-11-07 | Cherokee | North Carolina | 37039 | 820 | 15 |
708177 | 708177 | 2020-11-07 | Chowan | North Carolina | 37041 | 548 | 18 |
708178 | 708178 | 2020-11-07 | Clay | North Carolina | 37043 | 255 | 3 |
708179 | 708179 | 2020-11-07 | Cleveland | North Carolina | 37045 | 3544 | 91 |
708180 | 708180 | 2020-11-07 | Columbus | North Carolina | 37047 | 1900 | 66 |
708181 | 708181 | 2020-11-07 | Craven | North Carolina | 37049 | 2536 | 64 |
708182 | 708182 | 2020-11-07 | Cumberland | North Carolina | 37051 | 7702 | 105 |
708183 | 708183 | 2020-11-07 | Currituck | North Carolina | 37053 | 243 | 4 |
708184 | 708184 | 2020-11-07 | Dare | North Carolina | 37055 | 432 | 3 |
708185 | 708185 | 2020-11-07 | Davidson | North Carolina | 37057 | 4100 | 47 |
708186 | 708186 | 2020-11-07 | Davie | North Carolina | 37059 | 854 | 8 |
708187 | 708187 | 2020-11-07 | Duplin | North Carolina | 37061 | 2951 | 54 |
708188 | 708188 | 2020-11-07 | Durham | North Carolina | 37063 | 9749 | 105 |
708189 | 708189 | 2020-11-07 | Edgecombe | North Carolina | 37065 | 2156 | 65 |
708190 | 708190 | 2020-11-07 | Forsyth | North Carolina | 37067 | 9818 | 129 |
708191 | 708191 | 2020-11-07 | Franklin | North Carolina | 37069 | 1588 | 32 |
708192 | 708192 | 2020-11-07 | Gaston | North Carolina | 37071 | 8269 | 145 |
708193 | 708193 | 2020-11-07 | Gates | North Carolina | 37073 | 172 | 3 |
708194 | 708194 | 2020-11-07 | Graham | North Carolina | 37075 | 256 | 10 |
708195 | 708195 | 2020-11-07 | Granville | North Carolina | 37077 | 2164 | 52 |
708196 | 708196 | 2020-11-07 | Greene | North Carolina | 37079 | 1020 | 16 |
708197 | 708197 | 2020-11-07 | Guilford | North Carolina | 37081 | 12802 | 215 |
708198 | 708198 | 2020-11-07 | Halifax | North Carolina | 37083 | 1574 | 31 |
708199 | 708199 | 2020-11-07 | Harnett | North Carolina | 37085 | 3224 | 75 |
708200 | 708200 | 2020-11-07 | Haywood | North Carolina | 37087 | 802 | 36 |
708201 | 708201 | 2020-11-07 | Henderson | North Carolina | 37089 | 2659 | 68 |
708202 | 708202 | 2020-11-07 | Hertford | North Carolina | 37091 | 883 | 35 |
708203 | 708203 | 2020-11-07 | Hoke | North Carolina | 37093 | 1659 | 27 |
708204 | 708204 | 2020-11-07 | Hyde | North Carolina | 37095 | 178 | 5 |
708205 | 708205 | 2020-11-07 | Iredell | North Carolina | 37097 | 4204 | 34 |
708206 | 708206 | 2020-11-07 | Jackson | North Carolina | 37099 | 1178 | 8 |
708207 | 708207 | 2020-11-07 | Johnston | North Carolina | 37101 | 6218 | 69 |
708208 | 708208 | 2020-11-07 | Jones | North Carolina | 37103 | 211 | 15 |
708209 | 708209 | 2020-11-07 | Lee | North Carolina | 37105 | 2219 | 24 |
708210 | 708210 | 2020-11-07 | Lenoir | North Carolina | 37107 | 1643 | 42 |
708211 | 708211 | 2020-11-07 | Lincoln | North Carolina | 37109 | 2700 | 16 |
708212 | 708212 | 2020-11-07 | Macon | North Carolina | 37113 | 801 | 7 |
708213 | 708213 | 2020-11-07 | Madison | North Carolina | 37115 | 334 | 7 |
708214 | 708214 | 2020-11-07 | Martin | North Carolina | 37117 | 699 | 20 |
708215 | 708215 | 2020-11-07 | McDowell | North Carolina | 37111 | 1452 | 34 |
708216 | 708216 | 2020-11-07 | Mecklenburg | North Carolina | 37119 | 36106 | 406 |
708217 | 708217 | 2020-11-07 | Mitchell | North Carolina | 37121 | 320 | 4 |
708218 | 708218 | 2020-11-07 | Montgomery | North Carolina | 37123 | 1244 | 39 |
708219 | 708219 | 2020-11-07 | Moore | North Carolina | 37125 | 2397 | 56 |
708220 | 708220 | 2020-11-07 | Nash | North Carolina | 37127 | 3739 | 83 |
708221 | 708221 | 2020-11-07 | New Hanover | North Carolina | 37129 | 5688 | 44 |
708222 | 708222 | 2020-11-07 | Northampton | North Carolina | 37131 | 622 | 22 |
708223 | 708223 | 2020-11-07 | Onslow | North Carolina | 37133 | 3844 | 33 |
708224 | 708224 | 2020-11-07 | Orange | North Carolina | 37135 | 3290 | 59 |
708225 | 708225 | 2020-11-07 | Pamlico | North Carolina | 37137 | 336 | 3 |
708226 | 708226 | 2020-11-07 | Pasquotank | North Carolina | 37139 | 924 | 35 |
708227 | 708227 | 2020-11-07 | Pender | North Carolina | 37141 | 1534 | 17 |
708228 | 708228 | 2020-11-07 | Perquimans | North Carolina | 37143 | 269 | 4 |
708229 | 708229 | 2020-11-07 | Person | North Carolina | 37145 | 761 | 10 |
708230 | 708230 | 2020-11-07 | Pitt | North Carolina | 37147 | 6624 | 41 |
708231 | 708231 | 2020-11-07 | Polk | North Carolina | 37149 | 413 | 13 |
708232 | 708232 | 2020-11-07 | Randolph | North Carolina | 37151 | 4225 | 69 |
708233 | 708233 | 2020-11-07 | Richmond | North Carolina | 37153 | 1532 | 35 |
708234 | 708234 | 2020-11-07 | Robeson | North Carolina | 37155 | 6478 | 101 |
708235 | 708235 | 2020-11-07 | Rockingham | North Carolina | 37157 | 2345 | 19 |
708236 | 708236 | 2020-11-07 | Rowan | North Carolina | 37159 | 4482 | 122 |
708237 | 708237 | 2020-11-07 | Rutherford | North Carolina | 37161 | 1870 | 77 |
708238 | 708238 | 2020-11-07 | Sampson | North Carolina | 37163 | 3032 | 31 |
708239 | 708239 | 2020-11-07 | Scotland | North Carolina | 37165 | 1722 | 31 |
708240 | 708240 | 2020-11-07 | Stanly | North Carolina | 37167 | 2551 | 74 |
708241 | 708241 | 2020-11-07 | Stokes | North Carolina | 37169 | 794 | 13 |
708242 | 708242 | 2020-11-07 | Surry | North Carolina | 37171 | 2157 | 38 |
708243 | 708243 | 2020-11-07 | Swain | North Carolina | 37173 | 316 | 5 |
708244 | 708244 | 2020-11-07 | Transylvania | North Carolina | 37175 | 455 | 9 |
708245 | 708245 | 2020-11-07 | Tyrrell | North Carolina | 37177 | 134 | 3 |
708246 | 708246 | 2020-11-07 | Union | North Carolina | 37179 | 6365 | 66 |
708247 | 708247 | 2020-11-07 | Vance | North Carolina | 37181 | 1316 | 47 |
708248 | 708248 | 2020-11-07 | Wake | North Carolina | 37183 | 23139 | 280 |
708249 | 708249 | 2020-11-07 | Warren | North Carolina | 37185 | 522 | 7 |
708250 | 708250 | 2020-11-07 | Washington | North Carolina | 37187 | 275 | 8 |
708251 | 708251 | 2020-11-07 | Watauga | North Carolina | 37189 | 1491 | 6 |
708252 | 708252 | 2020-11-07 | Wayne | North Carolina | 37191 | 4978 | 99 |
708253 | 708253 | 2020-11-07 | Wilkes | North Carolina | 37193 | 2051 | 42 |
708254 | 708254 | 2020-11-07 | Wilson | North Carolina | 37195 | 3363 | 70 |
708255 | 708255 | 2020-11-07 | Yadkin | North Carolina | 37197 | 1159 | 11 |
708256 | 708256 | 2020-11-07 | Yancey | North Carolina | 37199 | 384 | 2 |
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);