ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where date = "2020-07-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 |
---|---|---|---|---|---|---|---|
311047 | 311047 | 2020-07-07 | Alamance | North Carolina | 37001 | 1309 | 37 |
311048 | 311048 | 2020-07-07 | Alexander | North Carolina | 37003 | 134 | 1 |
311049 | 311049 | 2020-07-07 | Alleghany | North Carolina | 37005 | 37 | 0 |
311050 | 311050 | 2020-07-07 | Anson | North Carolina | 37007 | 162 | 1 |
311051 | 311051 | 2020-07-07 | Ashe | North Carolina | 37009 | 60 | 1 |
311052 | 311052 | 2020-07-07 | Avery | North Carolina | 37011 | 18 | 0 |
311053 | 311053 | 2020-07-07 | Beaufort | North Carolina | 37013 | 110 | 0 |
311054 | 311054 | 2020-07-07 | Bertie | North Carolina | 37015 | 151 | 4 |
311055 | 311055 | 2020-07-07 | Bladen | North Carolina | 37017 | 406 | 4 |
311056 | 311056 | 2020-07-07 | Brunswick | North Carolina | 37019 | 698 | 9 |
311057 | 311057 | 2020-07-07 | Buncombe | North Carolina | 37021 | 711 | 39 |
311058 | 311058 | 2020-07-07 | Burke | North Carolina | 37023 | 1129 | 20 |
311059 | 311059 | 2020-07-07 | Cabarrus | North Carolina | 37025 | 1399 | 33 |
311060 | 311060 | 2020-07-07 | Caldwell | North Carolina | 37027 | 534 | 4 |
311061 | 311061 | 2020-07-07 | Camden | North Carolina | 37029 | 33 | 0 |
311062 | 311062 | 2020-07-07 | Carteret | North Carolina | 37031 | 110 | 3 |
311063 | 311063 | 2020-07-07 | Caswell | North Carolina | 37033 | 147 | 2 |
311064 | 311064 | 2020-07-07 | Catawba | North Carolina | 37035 | 1018 | 13 |
311065 | 311065 | 2020-07-07 | Chatham | North Carolina | 37037 | 999 | 43 |
311066 | 311066 | 2020-07-07 | Cherokee | North Carolina | 37039 | 48 | 2 |
311067 | 311067 | 2020-07-07 | Chowan | North Carolina | 37041 | 30 | 0 |
311068 | 311068 | 2020-07-07 | Clay | North Carolina | 37043 | 11 | 0 |
311069 | 311069 | 2020-07-07 | Cleveland | North Carolina | 37045 | 407 | 5 |
311070 | 311070 | 2020-07-07 | Columbus | North Carolina | 37047 | 570 | 39 |
311071 | 311071 | 2020-07-07 | Craven | North Carolina | 37049 | 405 | 7 |
311072 | 311072 | 2020-07-07 | Cumberland | North Carolina | 37051 | 1402 | 41 |
311073 | 311073 | 2020-07-07 | Currituck | North Carolina | 37053 | 21 | 0 |
311074 | 311074 | 2020-07-07 | Dare | North Carolina | 37055 | 80 | 1 |
311075 | 311075 | 2020-07-07 | Davidson | North Carolina | 37057 | 1114 | 15 |
311076 | 311076 | 2020-07-07 | Davie | North Carolina | 37059 | 234 | 3 |
311077 | 311077 | 2020-07-07 | Duplin | North Carolina | 37061 | 1595 | 28 |
311078 | 311078 | 2020-07-07 | Durham | North Carolina | 37063 | 4208 | 67 |
311079 | 311079 | 2020-07-07 | Edgecombe | North Carolina | 37065 | 352 | 9 |
311080 | 311080 | 2020-07-07 | Forsyth | North Carolina | 37067 | 3423 | 37 |
311081 | 311081 | 2020-07-07 | Franklin | North Carolina | 37069 | 403 | 21 |
311082 | 311082 | 2020-07-07 | Gaston | North Carolina | 37071 | 1443 | 12 |
311083 | 311083 | 2020-07-07 | Gates | North Carolina | 37073 | 27 | 2 |
311084 | 311084 | 2020-07-07 | Graham | North Carolina | 37075 | 10 | 0 |
311085 | 311085 | 2020-07-07 | Granville | North Carolina | 37077 | 850 | 21 |
311086 | 311086 | 2020-07-07 | Greene | North Carolina | 37079 | 192 | 3 |
311087 | 311087 | 2020-07-07 | Guilford | North Carolina | 37081 | 3208 | 119 |
311088 | 311088 | 2020-07-07 | Halifax | North Carolina | 37083 | 329 | 4 |
311089 | 311089 | 2020-07-07 | Harnett | North Carolina | 37085 | 712 | 30 |
311090 | 311090 | 2020-07-07 | Haywood | North Carolina | 37087 | 107 | 0 |
311091 | 311091 | 2020-07-07 | Henderson | North Carolina | 37089 | 738 | 51 |
311092 | 311092 | 2020-07-07 | Hertford | North Carolina | 37091 | 174 | 10 |
311093 | 311093 | 2020-07-07 | Hoke | North Carolina | 37093 | 415 | 3 |
311094 | 311094 | 2020-07-07 | Hyde | North Carolina | 37095 | 20 | 0 |
311095 | 311095 | 2020-07-07 | Iredell | North Carolina | 37097 | 945 | 7 |
311096 | 311096 | 2020-07-07 | Jackson | North Carolina | 37099 | 147 | 1 |
311097 | 311097 | 2020-07-07 | Johnston | North Carolina | 37101 | 1821 | 33 |
311098 | 311098 | 2020-07-07 | Jones | North Carolina | 37103 | 39 | 3 |
311099 | 311099 | 2020-07-07 | Lee | North Carolina | 37105 | 875 | 8 |
311100 | 311100 | 2020-07-07 | Lenoir | North Carolina | 37107 | 391 | 11 |
311101 | 311101 | 2020-07-07 | Lincoln | North Carolina | 37109 | 334 | 1 |
311102 | 311102 | 2020-07-07 | Macon | North Carolina | 37113 | 293 | 1 |
311103 | 311103 | 2020-07-07 | Madison | North Carolina | 37115 | 15 | 0 |
311104 | 311104 | 2020-07-07 | Martin | North Carolina | 37117 | 148 | 4 |
311105 | 311105 | 2020-07-07 | McDowell | North Carolina | 37111 | 280 | 2 |
311106 | 311106 | 2020-07-07 | Mecklenburg | North Carolina | 37119 | 13317 | 160 |
311107 | 311107 | 2020-07-07 | Mitchell | North Carolina | 37121 | 51 | 0 |
311108 | 311108 | 2020-07-07 | Montgomery | North Carolina | 37123 | 358 | 9 |
311109 | 311109 | 2020-07-07 | Moore | North Carolina | 37125 | 543 | 13 |
311110 | 311110 | 2020-07-07 | Nash | North Carolina | 37127 | 552 | 6 |
311111 | 311111 | 2020-07-07 | New Hanover | North Carolina | 37129 | 1161 | 7 |
311112 | 311112 | 2020-07-07 | Northampton | North Carolina | 37131 | 189 | 15 |
311113 | 311113 | 2020-07-07 | Onslow | North Carolina | 37133 | 359 | 3 |
311114 | 311114 | 2020-07-07 | Orange | North Carolina | 37135 | 848 | 42 |
311115 | 311115 | 2020-07-07 | Pamlico | North Carolina | 37137 | 26 | 0 |
311116 | 311116 | 2020-07-07 | Pasquotank | North Carolina | 37139 | 225 | 17 |
311117 | 311117 | 2020-07-07 | Pender | North Carolina | 37141 | 303 | 2 |
311118 | 311118 | 2020-07-07 | Perquimans | North Carolina | 37143 | 37 | 2 |
311119 | 311119 | 2020-07-07 | Person | North Carolina | 37145 | 123 | 1 |
311120 | 311120 | 2020-07-07 | Pitt | North Carolina | 37147 | 844 | 6 |
311121 | 311121 | 2020-07-07 | Polk | North Carolina | 37149 | 89 | 4 |
311122 | 311122 | 2020-07-07 | Randolph | North Carolina | 37151 | 1330 | 31 |
311123 | 311123 | 2020-07-07 | Richmond | North Carolina | 37153 | 326 | 7 |
311124 | 311124 | 2020-07-07 | Robeson | North Carolina | 37155 | 1429 | 44 |
311125 | 311125 | 2020-07-07 | Rockingham | North Carolina | 37157 | 267 | 2 |
311126 | 311126 | 2020-07-07 | Rowan | North Carolina | 37159 | 1387 | 44 |
311127 | 311127 | 2020-07-07 | Rutherford | North Carolina | 37161 | 360 | 10 |
311128 | 311128 | 2020-07-07 | Sampson | North Carolina | 37163 | 1117 | 7 |
311129 | 311129 | 2020-07-07 | Scotland | North Carolina | 37165 | 152 | 2 |
311130 | 311130 | 2020-07-07 | Stanly | North Carolina | 37167 | 481 | 5 |
311131 | 311131 | 2020-07-07 | Stokes | North Carolina | 37169 | 147 | 1 |
311132 | 311132 | 2020-07-07 | Surry | North Carolina | 37171 | 525 | 2 |
311133 | 311133 | 2020-07-07 | Swain | North Carolina | 37173 | 61 | 1 |
311134 | 311134 | 2020-07-07 | Transylvania | North Carolina | 37175 | 37 | 1 |
311135 | 311135 | 2020-07-07 | Tyrrell | North Carolina | 37177 | 19 | 0 |
311136 | 311136 | 2020-07-07 | Union | North Carolina | 37179 | 1551 | 25 |
311137 | 311137 | 2020-07-07 | Vance | North Carolina | 37181 | 532 | 39 |
311138 | 311138 | 2020-07-07 | Wake | North Carolina | 37183 | 6416 | 52 |
311139 | 311139 | 2020-07-07 | Warren | North Carolina | 37185 | 174 | 5 |
311140 | 311140 | 2020-07-07 | Washington | North Carolina | 37187 | 41 | 3 |
311141 | 311141 | 2020-07-07 | Watauga | North Carolina | 37189 | 104 | 0 |
311142 | 311142 | 2020-07-07 | Wayne | North Carolina | 37191 | 1926 | 29 |
311143 | 311143 | 2020-07-07 | Wilkes | North Carolina | 37193 | 592 | 6 |
311144 | 311144 | 2020-07-07 | Wilson | North Carolina | 37195 | 800 | 23 |
311145 | 311145 | 2020-07-07 | Yadkin | North Carolina | 37197 | 357 | 5 |
311146 | 311146 | 2020-07-07 | Yancey | North Carolina | 37199 | 51 | 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);