ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
99 rows where date = "2020-05-10" and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
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 |
---|---|---|---|---|---|---|---|
131989 | 131989 | 2020-05-10 | Alamance | North Carolina | 37001 | 172 | 5 |
131990 | 131990 | 2020-05-10 | Alexander | North Carolina | 37003 | 12 | 0 |
131991 | 131991 | 2020-05-10 | Alleghany | North Carolina | 37005 | 8 | 0 |
131992 | 131992 | 2020-05-10 | Anson | North Carolina | 37007 | 38 | 0 |
131993 | 131993 | 2020-05-10 | Ashe | North Carolina | 37009 | 10 | 0 |
131994 | 131994 | 2020-05-10 | Beaufort | North Carolina | 37013 | 25 | 0 |
131995 | 131995 | 2020-05-10 | Bertie | North Carolina | 37015 | 61 | 2 |
131996 | 131996 | 2020-05-10 | Bladen | North Carolina | 37017 | 52 | 1 |
131997 | 131997 | 2020-05-10 | Brunswick | North Carolina | 37019 | 50 | 4 |
131998 | 131998 | 2020-05-10 | Buncombe | North Carolina | 37021 | 100 | 4 |
131999 | 131999 | 2020-05-10 | Burke | North Carolina | 37023 | 136 | 11 |
132000 | 132000 | 2020-05-10 | Cabarrus | North Carolina | 37025 | 352 | 17 |
132001 | 132001 | 2020-05-10 | Caldwell | North Carolina | 37027 | 60 | 0 |
132002 | 132002 | 2020-05-10 | Camden | North Carolina | 37029 | 2 | 0 |
132003 | 132003 | 2020-05-10 | Carteret | North Carolina | 37031 | 31 | 3 |
132004 | 132004 | 2020-05-10 | Caswell | North Carolina | 37033 | 39 | 1 |
132005 | 132005 | 2020-05-10 | Catawba | North Carolina | 37035 | 79 | 1 |
132006 | 132006 | 2020-05-10 | Chatham | North Carolina | 37037 | 455 | 11 |
132007 | 132007 | 2020-05-10 | Cherokee | North Carolina | 37039 | 18 | 1 |
132008 | 132008 | 2020-05-10 | Chowan | North Carolina | 37041 | 11 | 0 |
132009 | 132009 | 2020-05-10 | Clay | North Carolina | 37043 | 5 | 0 |
132010 | 132010 | 2020-05-10 | Cleveland | North Carolina | 37045 | 50 | 2 |
132011 | 132011 | 2020-05-10 | Columbus | North Carolina | 37047 | 200 | 14 |
132012 | 132012 | 2020-05-10 | Craven | North Carolina | 37049 | 54 | 4 |
132013 | 132013 | 2020-05-10 | Cumberland | North Carolina | 37051 | 348 | 9 |
132014 | 132014 | 2020-05-10 | Currituck | North Carolina | 37053 | 9 | 0 |
132015 | 132015 | 2020-05-10 | Dare | North Carolina | 37055 | 15 | 1 |
132016 | 132016 | 2020-05-10 | Davidson | North Carolina | 37057 | 202 | 10 |
132017 | 132017 | 2020-05-10 | Davie | North Carolina | 37059 | 35 | 2 |
132018 | 132018 | 2020-05-10 | Duplin | North Carolina | 37061 | 242 | 3 |
132019 | 132019 | 2020-05-10 | Durham | North Carolina | 37063 | 886 | 34 |
132020 | 132020 | 2020-05-10 | Edgecombe | North Carolina | 37065 | 153 | 7 |
132021 | 132021 | 2020-05-10 | Forsyth | North Carolina | 37067 | 373 | 5 |
132022 | 132022 | 2020-05-10 | Franklin | North Carolina | 37069 | 111 | 20 |
132023 | 132023 | 2020-05-10 | Gaston | North Carolina | 37071 | 172 | 5 |
132024 | 132024 | 2020-05-10 | Gates | North Carolina | 37073 | 11 | 0 |
132025 | 132025 | 2020-05-10 | Graham | North Carolina | 37075 | 2 | 0 |
132026 | 132026 | 2020-05-10 | Granville | North Carolina | 37077 | 165 | 6 |
132027 | 132027 | 2020-05-10 | Greene | North Carolina | 37079 | 34 | 1 |
132028 | 132028 | 2020-05-10 | Guilford | North Carolina | 37081 | 592 | 38 |
132029 | 132029 | 2020-05-10 | Halifax | North Carolina | 37083 | 91 | 1 |
132030 | 132030 | 2020-05-10 | Harnett | North Carolina | 37085 | 217 | 13 |
132031 | 132031 | 2020-05-10 | Haywood | North Carolina | 37087 | 16 | 0 |
132032 | 132032 | 2020-05-10 | Henderson | North Carolina | 37089 | 226 | 27 |
132033 | 132033 | 2020-05-10 | Hertford | North Carolina | 37091 | 49 | 1 |
132034 | 132034 | 2020-05-10 | Hoke | North Carolina | 37093 | 120 | 0 |
132035 | 132035 | 2020-05-10 | Hyde | North Carolina | 37095 | 1 | 0 |
132036 | 132036 | 2020-05-10 | Iredell | North Carolina | 37097 | 151 | 5 |
132037 | 132037 | 2020-05-10 | Jackson | North Carolina | 37099 | 21 | 1 |
132038 | 132038 | 2020-05-10 | Johnston | North Carolina | 37101 | 205 | 17 |
132039 | 132039 | 2020-05-10 | Jones | North Carolina | 37103 | 18 | 2 |
132040 | 132040 | 2020-05-10 | Lee | North Carolina | 37105 | 268 | 1 |
132041 | 132041 | 2020-05-10 | Lenoir | North Carolina | 37107 | 118 | 4 |
132042 | 132042 | 2020-05-10 | Lincoln | North Carolina | 37109 | 39 | 0 |
132043 | 132043 | 2020-05-10 | Macon | North Carolina | 37113 | 3 | 1 |
132044 | 132044 | 2020-05-10 | Madison | North Carolina | 37115 | 1 | 0 |
132045 | 132045 | 2020-05-10 | Martin | North Carolina | 37117 | 29 | 1 |
132046 | 132046 | 2020-05-10 | McDowell | North Carolina | 37111 | 29 | 1 |
132047 | 132047 | 2020-05-10 | Mecklenburg | North Carolina | 37119 | 2074 | 63 |
132048 | 132048 | 2020-05-10 | Mitchell | North Carolina | 37121 | 5 | 0 |
132049 | 132049 | 2020-05-10 | Montgomery | North Carolina | 37123 | 41 | 2 |
132050 | 132050 | 2020-05-10 | Moore | North Carolina | 37125 | 111 | 9 |
132051 | 132051 | 2020-05-10 | Nash | North Carolina | 37127 | 119 | 3 |
132052 | 132052 | 2020-05-10 | New Hanover | North Carolina | 37129 | 97 | 3 |
132053 | 132053 | 2020-05-10 | Northampton | North Carolina | 37131 | 104 | 7 |
132054 | 132054 | 2020-05-10 | Onslow | North Carolina | 37133 | 53 | 2 |
132055 | 132055 | 2020-05-10 | Orange | North Carolina | 37135 | 252 | 33 |
132056 | 132056 | 2020-05-10 | Pamlico | North Carolina | 37137 | 8 | 0 |
132057 | 132057 | 2020-05-10 | Pasquotank | North Carolina | 37139 | 82 | 3 |
132058 | 132058 | 2020-05-10 | Pender | North Carolina | 37141 | 39 | 1 |
132059 | 132059 | 2020-05-10 | Perquimans | North Carolina | 37143 | 17 | 2 |
132060 | 132060 | 2020-05-10 | Person | North Carolina | 37145 | 30 | 1 |
132061 | 132061 | 2020-05-10 | Pitt | North Carolina | 37147 | 165 | 2 |
132062 | 132062 | 2020-05-10 | Polk | North Carolina | 37149 | 29 | 0 |
132063 | 132063 | 2020-05-10 | Randolph | North Carolina | 37151 | 338 | 6 |
132064 | 132064 | 2020-05-10 | Richmond | North Carolina | 37153 | 90 | 2 |
132065 | 132065 | 2020-05-10 | Robeson | North Carolina | 37155 | 388 | 6 |
132066 | 132066 | 2020-05-10 | Rockingham | North Carolina | 37157 | 40 | 2 |
132067 | 132067 | 2020-05-10 | Rowan | North Carolina | 37159 | 483 | 25 |
132068 | 132068 | 2020-05-10 | Rutherford | North Carolina | 37161 | 151 | 7 |
132069 | 132069 | 2020-05-10 | Sampson | North Carolina | 37163 | 156 | 1 |
132070 | 132070 | 2020-05-10 | Scotland | North Carolina | 37165 | 40 | 0 |
132071 | 132071 | 2020-05-10 | Stanly | North Carolina | 37167 | 29 | 4 |
132072 | 132072 | 2020-05-10 | Stokes | North Carolina | 37169 | 11 | 0 |
132073 | 132073 | 2020-05-10 | Surry | North Carolina | 37171 | 41 | 1 |
132074 | 132074 | 2020-05-10 | Swain | North Carolina | 37173 | 5 | 0 |
132075 | 132075 | 2020-05-10 | Transylvania | North Carolina | 37175 | 7 | 0 |
132076 | 132076 | 2020-05-10 | Tyrrell | North Carolina | 37177 | 4 | 0 |
132077 | 132077 | 2020-05-10 | Union | North Carolina | 37179 | 297 | 17 |
132078 | 132078 | 2020-05-10 | Vance | North Carolina | 37181 | 161 | 13 |
132079 | 132079 | 2020-05-10 | Wake | North Carolina | 37183 | 1030 | 23 |
132080 | 132080 | 2020-05-10 | Warren | North Carolina | 37185 | 23 | 0 |
132081 | 132081 | 2020-05-10 | Washington | North Carolina | 37187 | 25 | 3 |
132082 | 132082 | 2020-05-10 | Watauga | North Carolina | 37189 | 9 | 0 |
132083 | 132083 | 2020-05-10 | Wayne | North Carolina | 37191 | 743 | 13 |
132084 | 132084 | 2020-05-10 | Wilkes | North Carolina | 37193 | 239 | 1 |
132085 | 132085 | 2020-05-10 | Wilson | North Carolina | 37195 | 212 | 8 |
132086 | 132086 | 2020-05-10 | Yadkin | North Carolina | 37197 | 54 | 1 |
132087 | 132087 | 2020-05-10 | Yancey | North Carolina | 37199 | 9 | 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);