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-10-21 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 |
---|---|---|---|---|---|---|---|
653017 | 653017 | 2020-10-21 | Alamance | North Carolina | 37001 | 4852 | 72 |
653018 | 653018 | 2020-10-21 | Alexander | North Carolina | 37003 | 741 | 9 |
653019 | 653019 | 2020-10-21 | Alleghany | North Carolina | 37005 | 271 | 1 |
653020 | 653020 | 2020-10-21 | Anson | North Carolina | 37007 | 702 | 9 |
653021 | 653021 | 2020-10-21 | Ashe | North Carolina | 37009 | 370 | 1 |
653022 | 653022 | 2020-10-21 | Avery | North Carolina | 37011 | 581 | 0 |
653023 | 653023 | 2020-10-21 | Beaufort | North Carolina | 37013 | 1281 | 37 |
653024 | 653024 | 2020-10-21 | Bertie | North Carolina | 37015 | 703 | 19 |
653025 | 653025 | 2020-10-21 | Bladen | North Carolina | 37017 | 1060 | 19 |
653026 | 653026 | 2020-10-21 | Brunswick | North Carolina | 37019 | 2079 | 35 |
653027 | 653027 | 2020-10-21 | Buncombe | North Carolina | 37021 | 3815 | 109 |
653028 | 653028 | 2020-10-21 | Burke | North Carolina | 37023 | 2525 | 46 |
653029 | 653029 | 2020-10-21 | Cabarrus | North Carolina | 37025 | 4660 | 87 |
653030 | 653030 | 2020-10-21 | Caldwell | North Carolina | 37027 | 2227 | 19 |
653031 | 653031 | 2020-10-21 | Camden | North Carolina | 37029 | 133 | 3 |
653032 | 653032 | 2020-10-21 | Carteret | North Carolina | 37031 | 1016 | 5 |
653033 | 653033 | 2020-10-21 | Caswell | North Carolina | 37033 | 577 | 5 |
653034 | 653034 | 2020-10-21 | Catawba | North Carolina | 37035 | 4055 | 59 |
653035 | 653035 | 2020-10-21 | Chatham | North Carolina | 37037 | 1873 | 60 |
653036 | 653036 | 2020-10-21 | Cherokee | North Carolina | 37039 | 738 | 12 |
653037 | 653037 | 2020-10-21 | Chowan | North Carolina | 37041 | 496 | 10 |
653038 | 653038 | 2020-10-21 | Clay | North Carolina | 37043 | 186 | 3 |
653039 | 653039 | 2020-10-21 | Cleveland | North Carolina | 37045 | 2956 | 81 |
653040 | 653040 | 2020-10-21 | Columbus | North Carolina | 37047 | 1603 | 59 |
653041 | 653041 | 2020-10-21 | Craven | North Carolina | 37049 | 2189 | 56 |
653042 | 653042 | 2020-10-21 | Cumberland | North Carolina | 37051 | 6647 | 91 |
653043 | 653043 | 2020-10-21 | Currituck | North Carolina | 37053 | 220 | 4 |
653044 | 653044 | 2020-10-21 | Dare | North Carolina | 37055 | 344 | 3 |
653045 | 653045 | 2020-10-21 | Davidson | North Carolina | 37057 | 3509 | 43 |
653046 | 653046 | 2020-10-21 | Davie | North Carolina | 37059 | 722 | 7 |
653047 | 653047 | 2020-10-21 | Duplin | North Carolina | 37061 | 2687 | 54 |
653048 | 653048 | 2020-10-21 | Durham | North Carolina | 37063 | 8705 | 100 |
653049 | 653049 | 2020-10-21 | Edgecombe | North Carolina | 37065 | 1837 | 52 |
653050 | 653050 | 2020-10-21 | Forsyth | North Carolina | 37067 | 8264 | 114 |
653051 | 653051 | 2020-10-21 | Franklin | North Carolina | 37069 | 1386 | 31 |
653052 | 653052 | 2020-10-21 | Gaston | North Carolina | 37071 | 6881 | 107 |
653053 | 653053 | 2020-10-21 | Gates | North Carolina | 37073 | 164 | 3 |
653054 | 653054 | 2020-10-21 | Graham | North Carolina | 37075 | 237 | 7 |
653055 | 653055 | 2020-10-21 | Granville | North Carolina | 37077 | 1926 | 50 |
653056 | 653056 | 2020-10-21 | Greene | North Carolina | 37079 | 889 | 12 |
653057 | 653057 | 2020-10-21 | Guilford | North Carolina | 37081 | 10619 | 196 |
653058 | 653058 | 2020-10-21 | Halifax | North Carolina | 37083 | 1297 | 25 |
653059 | 653059 | 2020-10-21 | Harnett | North Carolina | 37085 | 2762 | 68 |
653060 | 653060 | 2020-10-21 | Haywood | North Carolina | 37087 | 692 | 36 |
653061 | 653061 | 2020-10-21 | Henderson | North Carolina | 37089 | 2379 | 67 |
653062 | 653062 | 2020-10-21 | Hertford | North Carolina | 37091 | 845 | 34 |
653063 | 653063 | 2020-10-21 | Hoke | North Carolina | 37093 | 1478 | 24 |
653064 | 653064 | 2020-10-21 | Hyde | North Carolina | 37095 | 175 | 5 |
653065 | 653065 | 2020-10-21 | Iredell | North Carolina | 37097 | 3619 | 34 |
653066 | 653066 | 2020-10-21 | Jackson | North Carolina | 37099 | 910 | 7 |
653067 | 653067 | 2020-10-21 | Johnston | North Carolina | 37101 | 5357 | 62 |
653068 | 653068 | 2020-10-21 | Jones | North Carolina | 37103 | 176 | 15 |
653069 | 653069 | 2020-10-21 | Lee | North Carolina | 37105 | 1987 | 18 |
653070 | 653070 | 2020-10-21 | Lenoir | North Carolina | 37107 | 1311 | 38 |
653071 | 653071 | 2020-10-21 | Lincoln | North Carolina | 37109 | 2206 | 16 |
653072 | 653072 | 2020-10-21 | Macon | North Carolina | 37113 | 709 | 7 |
653073 | 653073 | 2020-10-21 | Madison | North Carolina | 37115 | 161 | 1 |
653074 | 653074 | 2020-10-21 | Martin | North Carolina | 37117 | 603 | 16 |
653075 | 653075 | 2020-10-21 | McDowell | North Carolina | 37111 | 1238 | 31 |
653076 | 653076 | 2020-10-21 | Mecklenburg | North Carolina | 37119 | 32264 | 381 |
653077 | 653077 | 2020-10-21 | Mitchell | North Carolina | 37121 | 196 | 4 |
653078 | 653078 | 2020-10-21 | Montgomery | North Carolina | 37123 | 1154 | 38 |
653079 | 653079 | 2020-10-21 | Moore | North Carolina | 37125 | 2160 | 40 |
653080 | 653080 | 2020-10-21 | Nash | North Carolina | 37127 | 3162 | 65 |
653081 | 653081 | 2020-10-21 | New Hanover | North Carolina | 37129 | 5011 | 37 |
653082 | 653082 | 2020-10-21 | Northampton | North Carolina | 37131 | 530 | 18 |
653083 | 653083 | 2020-10-21 | Onslow | North Carolina | 37133 | 3039 | 27 |
653084 | 653084 | 2020-10-21 | Orange | North Carolina | 37135 | 2977 | 58 |
653085 | 653085 | 2020-10-21 | Pamlico | North Carolina | 37137 | 302 | 2 |
653086 | 653086 | 2020-10-21 | Pasquotank | North Carolina | 37139 | 830 | 33 |
653087 | 653087 | 2020-10-21 | Pender | North Carolina | 37141 | 1204 | 8 |
653088 | 653088 | 2020-10-21 | Perquimans | North Carolina | 37143 | 232 | 4 |
653089 | 653089 | 2020-10-21 | Person | North Carolina | 37145 | 588 | 9 |
653090 | 653090 | 2020-10-21 | Pitt | North Carolina | 37147 | 5902 | 35 |
653091 | 653091 | 2020-10-21 | Polk | North Carolina | 37149 | 381 | 11 |
653092 | 653092 | 2020-10-21 | Randolph | North Carolina | 37151 | 3542 | 60 |
653093 | 653093 | 2020-10-21 | Richmond | North Carolina | 37153 | 1364 | 24 |
653094 | 653094 | 2020-10-21 | Robeson | North Carolina | 37155 | 5702 | 90 |
653095 | 653095 | 2020-10-21 | Rockingham | North Carolina | 37157 | 1766 | 18 |
653096 | 653096 | 2020-10-21 | Rowan | North Carolina | 37159 | 3970 | 111 |
653097 | 653097 | 2020-10-21 | Rutherford | North Carolina | 37161 | 1636 | 57 |
653098 | 653098 | 2020-10-21 | Sampson | North Carolina | 37163 | 2579 | 28 |
653099 | 653099 | 2020-10-21 | Scotland | North Carolina | 37165 | 1576 | 22 |
653100 | 653100 | 2020-10-21 | Stanly | North Carolina | 37167 | 2374 | 57 |
653101 | 653101 | 2020-10-21 | Stokes | North Carolina | 37169 | 635 | 8 |
653102 | 653102 | 2020-10-21 | Surry | North Carolina | 37171 | 1661 | 29 |
653103 | 653103 | 2020-10-21 | Swain | North Carolina | 37173 | 227 | 4 |
653104 | 653104 | 2020-10-21 | Transylvania | North Carolina | 37175 | 395 | 9 |
653105 | 653105 | 2020-10-21 | Tyrrell | North Carolina | 37177 | 127 | 3 |
653106 | 653106 | 2020-10-21 | Union | North Carolina | 37179 | 5700 | 62 |
653107 | 653107 | 2020-10-21 | Vance | North Carolina | 37181 | 1158 | 46 |
653108 | 653108 | 2020-10-21 | Wake | North Carolina | 37183 | 20250 | 267 |
653109 | 653109 | 2020-10-21 | Warren | North Carolina | 37185 | 405 | 7 |
653110 | 653110 | 2020-10-21 | Washington | North Carolina | 37187 | 238 | 8 |
653111 | 653111 | 2020-10-21 | Watauga | North Carolina | 37189 | 1331 | 2 |
653112 | 653112 | 2020-10-21 | Wayne | North Carolina | 37191 | 4252 | 79 |
653113 | 653113 | 2020-10-21 | Wilkes | North Carolina | 37193 | 1587 | 37 |
653114 | 653114 | 2020-10-21 | Wilson | North Carolina | 37195 | 2757 | 62 |
653115 | 653115 | 2020-10-21 | Yadkin | North Carolina | 37197 | 940 | 9 |
653116 | 653116 | 2020-10-21 | Yancey | North Carolina | 37199 | 275 | 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);