ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
99 rows where "date" is on date 2020-05-15 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
- 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
- Duplin 1
- …
state 1
- North Carolina · 99 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
146962 | 146962 | 2020-05-15 | Alamance | North Carolina | 37001 | 195 | 9 |
146963 | 146963 | 2020-05-15 | Alexander | North Carolina | 37003 | 15 | 0 |
146964 | 146964 | 2020-05-15 | Alleghany | North Carolina | 37005 | 10 | 0 |
146965 | 146965 | 2020-05-15 | Anson | North Carolina | 37007 | 43 | 0 |
146966 | 146966 | 2020-05-15 | Ashe | North Carolina | 37009 | 17 | 0 |
146967 | 146967 | 2020-05-15 | Beaufort | North Carolina | 37013 | 26 | 0 |
146968 | 146968 | 2020-05-15 | Bertie | North Carolina | 37015 | 76 | 3 |
146969 | 146969 | 2020-05-15 | Bladen | North Carolina | 37017 | 68 | 2 |
146970 | 146970 | 2020-05-15 | Brunswick | North Carolina | 37019 | 51 | 4 |
146971 | 146971 | 2020-05-15 | Buncombe | North Carolina | 37021 | 138 | 4 |
146972 | 146972 | 2020-05-15 | Burke | North Carolina | 37023 | 174 | 14 |
146973 | 146973 | 2020-05-15 | Cabarrus | North Carolina | 37025 | 370 | 20 |
146974 | 146974 | 2020-05-15 | Caldwell | North Carolina | 37027 | 74 | 1 |
146975 | 146975 | 2020-05-15 | Camden | North Carolina | 37029 | 2 | 0 |
146976 | 146976 | 2020-05-15 | Carteret | North Carolina | 37031 | 35 | 3 |
146977 | 146977 | 2020-05-15 | Caswell | North Carolina | 37033 | 43 | 1 |
146978 | 146978 | 2020-05-15 | Catawba | North Carolina | 37035 | 92 | 2 |
146979 | 146979 | 2020-05-15 | Chatham | North Carolina | 37037 | 495 | 24 |
146980 | 146980 | 2020-05-15 | Cherokee | North Carolina | 37039 | 17 | 1 |
146981 | 146981 | 2020-05-15 | Chowan | North Carolina | 37041 | 12 | 0 |
146982 | 146982 | 2020-05-15 | Clay | North Carolina | 37043 | 5 | 0 |
146983 | 146983 | 2020-05-15 | Cleveland | North Carolina | 37045 | 54 | 2 |
146984 | 146984 | 2020-05-15 | Columbus | North Carolina | 37047 | 226 | 17 |
146985 | 146985 | 2020-05-15 | Craven | North Carolina | 37049 | 81 | 4 |
146986 | 146986 | 2020-05-15 | Cumberland | North Carolina | 37051 | 435 | 11 |
146987 | 146987 | 2020-05-15 | Currituck | North Carolina | 37053 | 11 | 0 |
146988 | 146988 | 2020-05-15 | Dare | North Carolina | 37055 | 18 | 1 |
146989 | 146989 | 2020-05-15 | Davidson | North Carolina | 37057 | 255 | 10 |
146990 | 146990 | 2020-05-15 | Davie | North Carolina | 37059 | 43 | 2 |
146991 | 146991 | 2020-05-15 | Duplin | North Carolina | 37061 | 338 | 7 |
146992 | 146992 | 2020-05-15 | Durham | North Carolina | 37063 | 938 | 37 |
146993 | 146993 | 2020-05-15 | Edgecombe | North Carolina | 37065 | 164 | 7 |
146994 | 146994 | 2020-05-15 | Forsyth | North Carolina | 37067 | 568 | 5 |
146995 | 146995 | 2020-05-15 | Franklin | North Carolina | 37069 | 121 | 20 |
146996 | 146996 | 2020-05-15 | Gaston | North Carolina | 37071 | 195 | 6 |
146997 | 146997 | 2020-05-15 | Gates | North Carolina | 37073 | 13 | 0 |
146998 | 146998 | 2020-05-15 | Graham | North Carolina | 37075 | 2 | 0 |
146999 | 146999 | 2020-05-15 | Granville | North Carolina | 37077 | 181 | 6 |
147000 | 147000 | 2020-05-15 | Greene | North Carolina | 37079 | 40 | 1 |
147001 | 147001 | 2020-05-15 | Guilford | North Carolina | 37081 | 725 | 46 |
147002 | 147002 | 2020-05-15 | Halifax | North Carolina | 37083 | 101 | 1 |
147003 | 147003 | 2020-05-15 | Harnett | North Carolina | 37085 | 237 | 17 |
147004 | 147004 | 2020-05-15 | Haywood | North Carolina | 37087 | 21 | 0 |
147005 | 147005 | 2020-05-15 | Henderson | North Carolina | 37089 | 273 | 36 |
147006 | 147006 | 2020-05-15 | Hertford | North Carolina | 37091 | 50 | 1 |
147007 | 147007 | 2020-05-15 | Hoke | North Carolina | 37093 | 140 | 0 |
147008 | 147008 | 2020-05-15 | Hyde | North Carolina | 37095 | 1 | 0 |
147009 | 147009 | 2020-05-15 | Iredell | North Carolina | 37097 | 170 | 5 |
147010 | 147010 | 2020-05-15 | Jackson | North Carolina | 37099 | 22 | 1 |
147011 | 147011 | 2020-05-15 | Johnston | North Carolina | 37101 | 233 | 19 |
147012 | 147012 | 2020-05-15 | Jones | North Carolina | 37103 | 21 | 2 |
147013 | 147013 | 2020-05-15 | Lee | North Carolina | 37105 | 301 | 3 |
147014 | 147014 | 2020-05-15 | Lenoir | North Carolina | 37107 | 139 | 5 |
147015 | 147015 | 2020-05-15 | Lincoln | North Carolina | 37109 | 44 | 0 |
147016 | 147016 | 2020-05-15 | Macon | North Carolina | 37113 | 3 | 1 |
147017 | 147017 | 2020-05-15 | Madison | North Carolina | 37115 | 1 | 0 |
147018 | 147018 | 2020-05-15 | Martin | North Carolina | 37117 | 34 | 4 |
147019 | 147019 | 2020-05-15 | McDowell | North Carolina | 37111 | 29 | 1 |
147020 | 147020 | 2020-05-15 | Mecklenburg | North Carolina | 37119 | 2385 | 63 |
147021 | 147021 | 2020-05-15 | Mitchell | North Carolina | 37121 | 5 | 0 |
147022 | 147022 | 2020-05-15 | Montgomery | North Carolina | 37123 | 48 | 3 |
147023 | 147023 | 2020-05-15 | Moore | North Carolina | 37125 | 113 | 10 |
147024 | 147024 | 2020-05-15 | Nash | North Carolina | 37127 | 146 | 3 |
147025 | 147025 | 2020-05-15 | New Hanover | North Carolina | 37129 | 118 | 3 |
147026 | 147026 | 2020-05-15 | Northampton | North Carolina | 37131 | 129 | 9 |
147027 | 147027 | 2020-05-15 | Onslow | North Carolina | 37133 | 67 | 2 |
147028 | 147028 | 2020-05-15 | Orange | North Carolina | 37135 | 266 | 34 |
147029 | 147029 | 2020-05-15 | Pamlico | North Carolina | 37137 | 8 | 0 |
147030 | 147030 | 2020-05-15 | Pasquotank | North Carolina | 37139 | 83 | 5 |
147031 | 147031 | 2020-05-15 | Pender | North Carolina | 37141 | 42 | 1 |
147032 | 147032 | 2020-05-15 | Perquimans | North Carolina | 37143 | 21 | 2 |
147033 | 147033 | 2020-05-15 | Person | North Carolina | 37145 | 32 | 1 |
147034 | 147034 | 2020-05-15 | Pitt | North Carolina | 37147 | 196 | 2 |
147035 | 147035 | 2020-05-15 | Polk | North Carolina | 37149 | 31 | 3 |
147036 | 147036 | 2020-05-15 | Randolph | North Carolina | 37151 | 422 | 6 |
147037 | 147037 | 2020-05-15 | Richmond | North Carolina | 37153 | 104 | 2 |
147038 | 147038 | 2020-05-15 | Robeson | North Carolina | 37155 | 531 | 12 |
147039 | 147039 | 2020-05-15 | Rockingham | North Carolina | 37157 | 44 | 2 |
147040 | 147040 | 2020-05-15 | Rowan | North Carolina | 37159 | 521 | 27 |
147041 | 147041 | 2020-05-15 | Rutherford | North Carolina | 37161 | 153 | 7 |
147042 | 147042 | 2020-05-15 | Sampson | North Carolina | 37163 | 219 | 1 |
147043 | 147043 | 2020-05-15 | Scotland | North Carolina | 37165 | 48 | 0 |
147044 | 147044 | 2020-05-15 | Stanly | North Carolina | 37167 | 31 | 4 |
147045 | 147045 | 2020-05-15 | Stokes | North Carolina | 37169 | 23 | 0 |
147046 | 147046 | 2020-05-15 | Surry | North Carolina | 37171 | 67 | 1 |
147047 | 147047 | 2020-05-15 | Swain | North Carolina | 37173 | 6 | 0 |
147048 | 147048 | 2020-05-15 | Transylvania | North Carolina | 37175 | 7 | 0 |
147049 | 147049 | 2020-05-15 | Tyrrell | North Carolina | 37177 | 4 | 0 |
147050 | 147050 | 2020-05-15 | Union | North Carolina | 37179 | 337 | 17 |
147051 | 147051 | 2020-05-15 | Vance | North Carolina | 37181 | 183 | 17 |
147052 | 147052 | 2020-05-15 | Wake | North Carolina | 37183 | 1143 | 28 |
147053 | 147053 | 2020-05-15 | Warren | North Carolina | 37185 | 26 | 0 |
147054 | 147054 | 2020-05-15 | Washington | North Carolina | 37187 | 26 | 3 |
147055 | 147055 | 2020-05-15 | Watauga | North Carolina | 37189 | 9 | 0 |
147056 | 147056 | 2020-05-15 | Wayne | North Carolina | 37191 | 801 | 15 |
147057 | 147057 | 2020-05-15 | Wilkes | North Carolina | 37193 | 287 | 1 |
147058 | 147058 | 2020-05-15 | Wilson | North Carolina | 37195 | 222 | 9 |
147059 | 147059 | 2020-05-15 | Yadkin | North Carolina | 37197 | 92 | 1 |
147060 | 147060 | 2020-05-15 | Yancey | North Carolina | 37199 | 8 | 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);