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 2021-01-03 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
- 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 |
---|---|---|---|---|---|---|---|
893134 | 893134 | 2021-01-03 | Alamance | North Carolina | 37001 | 10876 | 117 |
893135 | 893135 | 2021-01-03 | Alexander | North Carolina | 37003 | 2806 | 30 |
893136 | 893136 | 2021-01-03 | Alleghany | North Carolina | 37005 | 674 | 2 |
893137 | 893137 | 2021-01-03 | Anson | North Carolina | 37007 | 1482 | 27 |
893138 | 893138 | 2021-01-03 | Ashe | North Carolina | 37009 | 1312 | 27 |
893139 | 893139 | 2021-01-03 | Avery | North Carolina | 37011 | 1378 | 15 |
893140 | 893140 | 2021-01-03 | Beaufort | North Carolina | 37013 | 2780 | 61 |
893141 | 893141 | 2021-01-03 | Bertie | North Carolina | 37015 | 1254 | 27 |
893142 | 893142 | 2021-01-03 | Bladen | North Carolina | 37017 | 1924 | 26 |
893143 | 893143 | 2021-01-03 | Brunswick | North Carolina | 37019 | 4659 | 74 |
893144 | 893144 | 2021-01-03 | Buncombe | North Carolina | 37021 | 9803 | 176 |
893145 | 893145 | 2021-01-03 | Burke | North Carolina | 37023 | 6452 | 75 |
893146 | 893146 | 2021-01-03 | Cabarrus | North Carolina | 37025 | 11763 | 151 |
893147 | 893147 | 2021-01-03 | Caldwell | North Carolina | 37027 | 6213 | 31 |
893148 | 893148 | 2021-01-03 | Camden | North Carolina | 37029 | 306 | 5 |
893149 | 893149 | 2021-01-03 | Carteret | North Carolina | 37031 | 2829 | 17 |
893150 | 893150 | 2021-01-03 | Caswell | North Carolina | 37033 | 1214 | 9 |
893151 | 893151 | 2021-01-03 | Catawba | North Carolina | 37035 | 11658 | 160 |
893152 | 893152 | 2021-01-03 | Chatham | North Carolina | 37037 | 2966 | 65 |
893153 | 893153 | 2021-01-03 | Cherokee | North Carolina | 37039 | 1345 | 15 |
893154 | 893154 | 2021-01-03 | Chowan | North Carolina | 37041 | 859 | 20 |
893155 | 893155 | 2021-01-03 | Clay | North Carolina | 37043 | 412 | 5 |
893156 | 893156 | 2021-01-03 | Cleveland | North Carolina | 37045 | 7019 | 144 |
893157 | 893157 | 2021-01-03 | Columbus | North Carolina | 37047 | 3801 | 83 |
893158 | 893158 | 2021-01-03 | Craven | North Carolina | 37049 | 5331 | 84 |
893159 | 893159 | 2021-01-03 | Cumberland | North Carolina | 37051 | 14430 | 140 |
893160 | 893160 | 2021-01-03 | Currituck | North Carolina | 37053 | 687 | 11 |
893161 | 893161 | 2021-01-03 | Dare | North Carolina | 37055 | 1122 | 5 |
893162 | 893162 | 2021-01-03 | Davidson | North Carolina | 37057 | 9200 | 86 |
893163 | 893163 | 2021-01-03 | Davie | North Carolina | 37059 | 2220 | 13 |
893164 | 893164 | 2021-01-03 | Duplin | North Carolina | 37061 | 4361 | 67 |
893165 | 893165 | 2021-01-03 | Durham | North Carolina | 37063 | 15340 | 146 |
893166 | 893166 | 2021-01-03 | Edgecombe | North Carolina | 37065 | 3304 | 82 |
893167 | 893167 | 2021-01-03 | Forsyth | North Carolina | 37067 | 21367 | 225 |
893168 | 893168 | 2021-01-03 | Franklin | North Carolina | 37069 | 3292 | 37 |
893169 | 893169 | 2021-01-03 | Gaston | North Carolina | 37071 | 16321 | 245 |
893170 | 893170 | 2021-01-03 | Gates | North Carolina | 37073 | 370 | 12 |
893171 | 893171 | 2021-01-03 | Graham | North Carolina | 37075 | 422 | 11 |
893172 | 893172 | 2021-01-03 | Granville | North Carolina | 37077 | 3734 | 64 |
893173 | 893173 | 2021-01-03 | Greene | North Carolina | 37079 | 1576 | 31 |
893174 | 893174 | 2021-01-03 | Guilford | North Carolina | 37081 | 25761 | 318 |
893175 | 893175 | 2021-01-03 | Halifax | North Carolina | 37083 | 3050 | 52 |
893176 | 893176 | 2021-01-03 | Harnett | North Carolina | 37085 | 6162 | 95 |
893177 | 893177 | 2021-01-03 | Haywood | North Carolina | 37087 | 2303 | 66 |
893178 | 893178 | 2021-01-03 | Henderson | North Carolina | 37089 | 5600 | 92 |
893179 | 893179 | 2021-01-03 | Hertford | North Carolina | 37091 | 1423 | 50 |
893180 | 893180 | 2021-01-03 | Hoke | North Carolina | 37093 | 2856 | 35 |
893181 | 893181 | 2021-01-03 | Hyde | North Carolina | 37095 | 365 | 5 |
893182 | 893182 | 2021-01-03 | Iredell | North Carolina | 37097 | 9838 | 102 |
893183 | 893183 | 2021-01-03 | Jackson | North Carolina | 37099 | 2386 | 18 |
893184 | 893184 | 2021-01-03 | Johnston | North Carolina | 37101 | 12111 | 113 |
893185 | 893185 | 2021-01-03 | Jones | North Carolina | 37103 | 429 | 16 |
893186 | 893186 | 2021-01-03 | Lee | North Carolina | 37105 | 3654 | 44 |
893187 | 893187 | 2021-01-03 | Lenoir | North Carolina | 37107 | 3397 | 74 |
893188 | 893188 | 2021-01-03 | Lincoln | North Carolina | 37109 | 5649 | 26 |
893189 | 893189 | 2021-01-03 | Macon | North Carolina | 37113 | 1524 | 9 |
893190 | 893190 | 2021-01-03 | Madison | North Carolina | 37115 | 848 | 19 |
893191 | 893191 | 2021-01-03 | Martin | North Carolina | 37117 | 1453 | 25 |
893192 | 893192 | 2021-01-03 | McDowell | North Carolina | 37111 | 3252 | 39 |
893193 | 893193 | 2021-01-03 | Mecklenburg | North Carolina | 37119 | 65497 | 583 |
893194 | 893194 | 2021-01-03 | Mitchell | North Carolina | 37121 | 903 | 9 |
893195 | 893195 | 2021-01-03 | Montgomery | North Carolina | 37123 | 1978 | 47 |
893196 | 893196 | 2021-01-03 | Moore | North Carolina | 37125 | 5118 | 76 |
893197 | 893197 | 2021-01-03 | Nash | North Carolina | 37127 | 6297 | 121 |
893198 | 893198 | 2021-01-03 | New Hanover | North Carolina | 37129 | 9946 | 91 |
893199 | 893199 | 2021-01-03 | Northampton | North Carolina | 37131 | 1110 | 27 |
893200 | 893200 | 2021-01-03 | Onslow | North Carolina | 37133 | 9317 | 69 |
893201 | 893201 | 2021-01-03 | Orange | North Carolina | 37135 | 5227 | 65 |
893202 | 893202 | 2021-01-03 | Pamlico | North Carolina | 37137 | 546 | 5 |
893203 | 893203 | 2021-01-03 | Pasquotank | North Carolina | 37139 | 1896 | 44 |
893204 | 893204 | 2021-01-03 | Pender | North Carolina | 37141 | 2926 | 22 |
893205 | 893205 | 2021-01-03 | Perquimans | North Carolina | 37143 | 576 | 5 |
893206 | 893206 | 2021-01-03 | Person | North Carolina | 37145 | 1732 | 21 |
893207 | 893207 | 2021-01-03 | Pitt | North Carolina | 37147 | 12013 | 69 |
893208 | 893208 | 2021-01-03 | Polk | North Carolina | 37149 | 785 | 13 |
893209 | 893209 | 2021-01-03 | Randolph | North Carolina | 37151 | 8484 | 127 |
893210 | 893210 | 2021-01-03 | Richmond | North Carolina | 37153 | 2716 | 50 |
893211 | 893211 | 2021-01-03 | Robeson | North Carolina | 37155 | 10231 | 139 |
893212 | 893212 | 2021-01-03 | Rockingham | North Carolina | 37157 | 4655 | 28 |
893213 | 893213 | 2021-01-03 | Rowan | North Carolina | 37159 | 9615 | 173 |
893214 | 893214 | 2021-01-03 | Rutherford | North Carolina | 37161 | 4588 | 118 |
893215 | 893215 | 2021-01-03 | Sampson | North Carolina | 37163 | 5057 | 61 |
893216 | 893216 | 2021-01-03 | Scotland | North Carolina | 37165 | 2613 | 54 |
893217 | 893217 | 2021-01-03 | Stanly | North Carolina | 37167 | 4529 | 78 |
893218 | 893218 | 2021-01-03 | Stokes | North Carolina | 37169 | 2135 | 30 |
893219 | 893219 | 2021-01-03 | Surry | North Carolina | 37171 | 4620 | 78 |
893220 | 893220 | 2021-01-03 | Swain | North Carolina | 37173 | 717 | 8 |
893221 | 893221 | 2021-01-03 | Transylvania | North Carolina | 37175 | 979 | 11 |
893222 | 893222 | 2021-01-03 | Tyrrell | North Carolina | 37177 | 182 | 3 |
893223 | 893223 | 2021-01-03 | Union | North Carolina | 37179 | 13215 | 101 |
893224 | 893224 | 2021-01-03 | Vance | North Carolina | 37181 | 2790 | 69 |
893225 | 893225 | 2021-01-03 | Wake | North Carolina | 37183 | 45944 | 348 |
893226 | 893226 | 2021-01-03 | Warren | North Carolina | 37185 | 1112 | 9 |
893227 | 893227 | 2021-01-03 | Washington | North Carolina | 37187 | 503 | 12 |
893228 | 893228 | 2021-01-03 | Watauga | North Carolina | 37189 | 2742 | 16 |
893229 | 893229 | 2021-01-03 | Wayne | North Carolina | 37191 | 7656 | 150 |
893230 | 893230 | 2021-01-03 | Wilkes | North Carolina | 37193 | 4085 | 73 |
893231 | 893231 | 2021-01-03 | Wilson | North Carolina | 37195 | 5732 | 108 |
893232 | 893232 | 2021-01-03 | Yadkin | North Carolina | 37197 | 2516 | 28 |
893233 | 893233 | 2021-01-03 | Yancey | North Carolina | 37199 | 1054 | 5 |
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);