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-06-25 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 |
---|---|---|---|---|---|---|---|
273184 | 273184 | 2020-06-25 | Alamance | North Carolina | 37001 | 1009 | 36 |
273185 | 273185 | 2020-06-25 | Alexander | North Carolina | 37003 | 76 | 0 |
273186 | 273186 | 2020-06-25 | Alleghany | North Carolina | 37005 | 31 | 0 |
273187 | 273187 | 2020-06-25 | Anson | North Carolina | 37007 | 115 | 1 |
273188 | 273188 | 2020-06-25 | Ashe | North Carolina | 37009 | 50 | 1 |
273189 | 273189 | 2020-06-25 | Avery | North Carolina | 37011 | 8 | 0 |
273190 | 273190 | 2020-06-25 | Beaufort | North Carolina | 37013 | 62 | 0 |
273191 | 273191 | 2020-06-25 | Bertie | North Carolina | 37015 | 139 | 4 |
273192 | 273192 | 2020-06-25 | Bladen | North Carolina | 37017 | 341 | 3 |
273193 | 273193 | 2020-06-25 | Brunswick | North Carolina | 37019 | 419 | 5 |
273194 | 273194 | 2020-06-25 | Buncombe | North Carolina | 37021 | 519 | 36 |
273195 | 273195 | 2020-06-25 | Burke | North Carolina | 37023 | 954 | 17 |
273196 | 273196 | 2020-06-25 | Cabarrus | North Carolina | 37025 | 936 | 27 |
273197 | 273197 | 2020-06-25 | Caldwell | North Carolina | 37027 | 335 | 4 |
273198 | 273198 | 2020-06-25 | Camden | North Carolina | 37029 | 23 | 0 |
273199 | 273199 | 2020-06-25 | Carteret | North Carolina | 37031 | 64 | 3 |
273200 | 273200 | 2020-06-25 | Caswell | North Carolina | 37033 | 125 | 1 |
273201 | 273201 | 2020-06-25 | Catawba | North Carolina | 37035 | 641 | 10 |
273202 | 273202 | 2020-06-25 | Chatham | North Carolina | 37037 | 910 | 42 |
273203 | 273203 | 2020-06-25 | Cherokee | North Carolina | 37039 | 32 | 1 |
273204 | 273204 | 2020-06-25 | Chowan | North Carolina | 37041 | 19 | 0 |
273205 | 273205 | 2020-06-25 | Clay | North Carolina | 37043 | 9 | 0 |
273206 | 273206 | 2020-06-25 | Cleveland | North Carolina | 37045 | 248 | 3 |
273207 | 273207 | 2020-06-25 | Columbus | North Carolina | 37047 | 492 | 35 |
273208 | 273208 | 2020-06-25 | Craven | North Carolina | 37049 | 332 | 6 |
273209 | 273209 | 2020-06-25 | Cumberland | North Carolina | 37051 | 1065 | 40 |
273210 | 273210 | 2020-06-25 | Currituck | North Carolina | 37053 | 16 | 0 |
273211 | 273211 | 2020-06-25 | Dare | North Carolina | 37055 | 34 | 1 |
273212 | 273212 | 2020-06-25 | Davidson | North Carolina | 37057 | 831 | 15 |
273213 | 273213 | 2020-06-25 | Davie | North Carolina | 37059 | 169 | 3 |
273214 | 273214 | 2020-06-25 | Duplin | North Carolina | 37061 | 1373 | 20 |
273215 | 273215 | 2020-06-25 | Durham | North Carolina | 37063 | 3479 | 63 |
273216 | 273216 | 2020-06-25 | Edgecombe | North Carolina | 37065 | 290 | 9 |
273217 | 273217 | 2020-06-25 | Forsyth | North Carolina | 37067 | 2715 | 31 |
273218 | 273218 | 2020-06-25 | Franklin | North Carolina | 37069 | 301 | 21 |
273219 | 273219 | 2020-06-25 | Gaston | North Carolina | 37071 | 869 | 11 |
273220 | 273220 | 2020-06-25 | Gates | North Carolina | 37073 | 26 | 2 |
273221 | 273221 | 2020-06-25 | Graham | North Carolina | 37075 | 8 | 0 |
273222 | 273222 | 2020-06-25 | Granville | North Carolina | 37077 | 767 | 19 |
273223 | 273223 | 2020-06-25 | Greene | North Carolina | 37079 | 160 | 2 |
273224 | 273224 | 2020-06-25 | Guilford | North Carolina | 37081 | 2586 | 111 |
273225 | 273225 | 2020-06-25 | Halifax | North Carolina | 37083 | 281 | 4 |
273226 | 273226 | 2020-06-25 | Harnett | North Carolina | 37085 | 553 | 30 |
273227 | 273227 | 2020-06-25 | Haywood | North Carolina | 37087 | 75 | 0 |
273228 | 273228 | 2020-06-25 | Henderson | North Carolina | 37089 | 540 | 50 |
273229 | 273229 | 2020-06-25 | Hertford | North Carolina | 37091 | 157 | 10 |
273230 | 273230 | 2020-06-25 | Hoke | North Carolina | 37093 | 337 | 3 |
273231 | 273231 | 2020-06-25 | Hyde | North Carolina | 37095 | 6 | 0 |
273232 | 273232 | 2020-06-25 | Iredell | North Carolina | 37097 | 624 | 7 |
273233 | 273233 | 2020-06-25 | Jackson | North Carolina | 37099 | 83 | 1 |
273234 | 273234 | 2020-06-25 | Johnston | North Carolina | 37101 | 1284 | 29 |
273235 | 273235 | 2020-06-25 | Jones | North Carolina | 37103 | 29 | 3 |
273236 | 273236 | 2020-06-25 | Lee | North Carolina | 37105 | 741 | 7 |
273237 | 273237 | 2020-06-25 | Lenoir | North Carolina | 37107 | 348 | 10 |
273238 | 273238 | 2020-06-25 | Lincoln | North Carolina | 37109 | 208 | 0 |
273239 | 273239 | 2020-06-25 | Macon | North Carolina | 37113 | 262 | 1 |
273240 | 273240 | 2020-06-25 | Madison | North Carolina | 37115 | 9 | 0 |
273241 | 273241 | 2020-06-25 | Martin | North Carolina | 37117 | 121 | 4 |
273242 | 273242 | 2020-06-25 | McDowell | North Carolina | 37111 | 208 | 1 |
273243 | 273243 | 2020-06-25 | Mecklenburg | North Carolina | 37119 | 9614 | 147 |
273244 | 273244 | 2020-06-25 | Mitchell | North Carolina | 37121 | 26 | 0 |
273245 | 273245 | 2020-06-25 | Montgomery | North Carolina | 37123 | 269 | 7 |
273246 | 273246 | 2020-06-25 | Moore | North Carolina | 37125 | 396 | 12 |
273247 | 273247 | 2020-06-25 | Nash | North Carolina | 37127 | 380 | 4 |
273248 | 273248 | 2020-06-25 | New Hanover | North Carolina | 37129 | 673 | 5 |
273249 | 273249 | 2020-06-25 | Northampton | North Carolina | 37131 | 177 | 15 |
273250 | 273250 | 2020-06-25 | Onslow | North Carolina | 37133 | 229 | 3 |
273251 | 273251 | 2020-06-25 | Orange | North Carolina | 37135 | 578 | 41 |
273252 | 273252 | 2020-06-25 | Pamlico | North Carolina | 37137 | 18 | 0 |
273253 | 273253 | 2020-06-25 | Pasquotank | North Carolina | 37139 | 172 | 15 |
273254 | 273254 | 2020-06-25 | Pender | North Carolina | 37141 | 213 | 1 |
273255 | 273255 | 2020-06-25 | Perquimans | North Carolina | 37143 | 32 | 2 |
273256 | 273256 | 2020-06-25 | Person | North Carolina | 37145 | 96 | 1 |
273257 | 273257 | 2020-06-25 | Pitt | North Carolina | 37147 | 611 | 5 |
273258 | 273258 | 2020-06-25 | Polk | North Carolina | 37149 | 67 | 4 |
273259 | 273259 | 2020-06-25 | Randolph | North Carolina | 37151 | 1090 | 28 |
273260 | 273260 | 2020-06-25 | Richmond | North Carolina | 37153 | 246 | 5 |
273261 | 273261 | 2020-06-25 | Robeson | North Carolina | 37155 | 1185 | 37 |
273262 | 273262 | 2020-06-25 | Rockingham | North Carolina | 37157 | 179 | 2 |
273263 | 273263 | 2020-06-25 | Rowan | North Carolina | 37159 | 1090 | 41 |
273264 | 273264 | 2020-06-25 | Rutherford | North Carolina | 37161 | 269 | 9 |
273265 | 273265 | 2020-06-25 | Sampson | North Carolina | 37163 | 947 | 5 |
273266 | 273266 | 2020-06-25 | Scotland | North Carolina | 37165 | 130 | 0 |
273267 | 273267 | 2020-06-25 | Stanly | North Carolina | 37167 | 308 | 5 |
273268 | 273268 | 2020-06-25 | Stokes | North Carolina | 37169 | 115 | 1 |
273269 | 273269 | 2020-06-25 | Surry | North Carolina | 37171 | 418 | 2 |
273270 | 273270 | 2020-06-25 | Swain | North Carolina | 37173 | 50 | 0 |
273271 | 273271 | 2020-06-25 | Transylvania | North Carolina | 37175 | 19 | 1 |
273272 | 273272 | 2020-06-25 | Tyrrell | North Carolina | 37177 | 7 | 0 |
273273 | 273273 | 2020-06-25 | Union | North Carolina | 37179 | 1042 | 24 |
273274 | 273274 | 2020-06-25 | Vance | North Carolina | 37181 | 486 | 36 |
273275 | 273275 | 2020-06-25 | Wake | North Carolina | 37183 | 4469 | 44 |
273276 | 273276 | 2020-06-25 | Warren | North Carolina | 37185 | 154 | 5 |
273277 | 273277 | 2020-06-25 | Washington | North Carolina | 37187 | 37 | 3 |
273278 | 273278 | 2020-06-25 | Watauga | North Carolina | 37189 | 51 | 0 |
273279 | 273279 | 2020-06-25 | Wayne | North Carolina | 37191 | 1712 | 24 |
273280 | 273280 | 2020-06-25 | Wilkes | North Carolina | 37193 | 561 | 6 |
273281 | 273281 | 2020-06-25 | Wilson | North Carolina | 37195 | 644 | 18 |
273282 | 273282 | 2020-06-25 | Yadkin | North Carolina | 37197 | 293 | 4 |
273283 | 273283 | 2020-06-25 | Yancey | North Carolina | 37199 | 43 | 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);