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-10-09 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 |
---|---|---|---|---|---|---|---|
1799025 | 1799025 | 2021-10-09 | Alamance | North Carolina | 37001 | 25524 | 323 |
1799026 | 1799026 | 2021-10-09 | Alexander | North Carolina | 37003 | 6238 | 111 |
1799027 | 1799027 | 2021-10-09 | Alleghany | North Carolina | 37005 | 1573 | 5 |
1799028 | 1799028 | 2021-10-09 | Anson | North Carolina | 37007 | 3720 | 75 |
1799029 | 1799029 | 2021-10-09 | Ashe | North Carolina | 37009 | 3328 | 46 |
1799030 | 1799030 | 2021-10-09 | Avery | North Carolina | 37011 | 2638 | 32 |
1799031 | 1799031 | 2021-10-09 | Beaufort | North Carolina | 37013 | 6786 | 124 |
1799032 | 1799032 | 2021-10-09 | Bertie | North Carolina | 37015 | 2386 | 49 |
1799033 | 1799033 | 2021-10-09 | Bladen | North Carolina | 37017 | 5358 | 93 |
1799034 | 1799034 | 2021-10-09 | Brunswick | North Carolina | 37019 | 15701 | 224 |
1799035 | 1799035 | 2021-10-09 | Buncombe | North Carolina | 37021 | 26856 | 410 |
1799036 | 1799036 | 2021-10-09 | Burke | North Carolina | 37023 | 15238 | 202 |
1799037 | 1799037 | 2021-10-09 | Cabarrus | North Carolina | 37025 | 31851 | 319 |
1799038 | 1799038 | 2021-10-09 | Caldwell | North Carolina | 37027 | 12849 | 198 |
1799039 | 1799039 | 2021-10-09 | Camden | North Carolina | 37029 | 1067 | 8 |
1799040 | 1799040 | 2021-10-09 | Carteret | North Carolina | 37031 | 8017 | 71 |
1799041 | 1799041 | 2021-10-09 | Caswell | North Carolina | 37033 | 3092 | 36 |
1799042 | 1799042 | 2021-10-09 | Catawba | North Carolina | 37035 | 27487 | 405 |
1799043 | 1799043 | 2021-10-09 | Chatham | North Carolina | 37037 | 6554 | 91 |
1799044 | 1799044 | 2021-10-09 | Cherokee | North Carolina | 37039 | 4537 | 74 |
1799045 | 1799045 | 2021-10-09 | Chowan | North Carolina | 37041 | 2209 | 40 |
1799046 | 1799046 | 2021-10-09 | Clay | North Carolina | 37043 | 1595 | 34 |
1799047 | 1799047 | 2021-10-09 | Cleveland | North Carolina | 37045 | 17709 | 295 |
1799048 | 1799048 | 2021-10-09 | Columbus | North Carolina | 37047 | 9816 | 219 |
1799049 | 1799049 | 2021-10-09 | Craven | North Carolina | 37049 | 13856 | 151 |
1799050 | 1799050 | 2021-10-09 | Cumberland | North Carolina | 37051 | 43333 | 447 |
1799051 | 1799051 | 2021-10-09 | Currituck | North Carolina | 37053 | 2596 | 25 |
1799052 | 1799052 | 2021-10-09 | Dare | North Carolina | 37055 | 3604 | 12 |
1799053 | 1799053 | 2021-10-09 | Davidson | North Carolina | 37057 | 25006 | 287 |
1799054 | 1799054 | 2021-10-09 | Davie | North Carolina | 37059 | 6152 | 67 |
1799055 | 1799055 | 2021-10-09 | Duplin | North Carolina | 37061 | 9649 | 172 |
1799056 | 1799056 | 2021-10-09 | Durham | North Carolina | 37063 | 34130 | 255 |
1799057 | 1799057 | 2021-10-09 | Edgecombe | North Carolina | 37065 | 7688 | 123 |
1799058 | 1799058 | 2021-10-09 | Forsyth | North Carolina | 37067 | 50000 | 530 |
1799059 | 1799059 | 2021-10-09 | Franklin | North Carolina | 37069 | 9465 | 60 |
1799060 | 1799060 | 2021-10-09 | Gaston | North Carolina | 37071 | 38627 | 582 |
1799061 | 1799061 | 2021-10-09 | Gates | North Carolina | 37073 | 1025 | 17 |
1799062 | 1799062 | 2021-10-09 | Graham | North Carolina | 37075 | 1288 | 27 |
1799063 | 1799063 | 2021-10-09 | Granville | North Carolina | 37077 | 7690 | 99 |
1799064 | 1799064 | 2021-10-09 | Greene | North Carolina | 37079 | 3217 | 53 |
1799065 | 1799065 | 2021-10-09 | Guilford | North Carolina | 37081 | 65461 | 845 |
1799066 | 1799066 | 2021-10-09 | Halifax | North Carolina | 37083 | 7568 | 132 |
1799067 | 1799067 | 2021-10-09 | Harnett | North Carolina | 37085 | 17735 | 241 |
1799068 | 1799068 | 2021-10-09 | Haywood | North Carolina | 37087 | 7081 | 135 |
1799069 | 1799069 | 2021-10-09 | Henderson | North Carolina | 37089 | 14660 | 190 |
1799070 | 1799070 | 2021-10-09 | Hertford | North Carolina | 37091 | 2716 | 69 |
1799071 | 1799071 | 2021-10-09 | Hoke | North Carolina | 37093 | 6933 | 77 |
1799072 | 1799072 | 2021-10-09 | Hyde | North Carolina | 37095 | 818 | 11 |
1799073 | 1799073 | 2021-10-09 | Iredell | North Carolina | 37097 | 27929 | 310 |
1799074 | 1799074 | 2021-10-09 | Jackson | North Carolina | 37099 | 5414 | 69 |
1799075 | 1799075 | 2021-10-09 | Johnston | North Carolina | 37101 | 31402 | 316 |
1799076 | 1799076 | 2021-10-09 | Jones | North Carolina | 37103 | 1284 | 29 |
1799077 | 1799077 | 2021-10-09 | Lee | North Carolina | 37105 | 9164 | 102 |
1799078 | 1799078 | 2021-10-09 | Lenoir | North Carolina | 37107 | 9254 | 146 |
1799079 | 1799079 | 2021-10-09 | Lincoln | North Carolina | 37109 | 14446 | 92 |
1799080 | 1799080 | 2021-10-09 | Macon | North Carolina | 37113 | 4760 | 54 |
1799081 | 1799081 | 2021-10-09 | Madison | North Carolina | 37115 | 2661 | 55 |
1799082 | 1799082 | 2021-10-09 | Martin | North Carolina | 37117 | 3512 | 63 |
1799083 | 1799083 | 2021-10-09 | McDowell | North Carolina | 37111 | 8323 | 114 |
1799084 | 1799084 | 2021-10-09 | Mecklenburg | North Carolina | 37119 | 153083 | 1188 |
1799085 | 1799085 | 2021-10-09 | Mitchell | North Carolina | 37121 | 1945 | 18 |
1799086 | 1799086 | 2021-10-09 | Montgomery | North Carolina | 37123 | 4382 | 108 |
1799087 | 1799087 | 2021-10-09 | Moore | North Carolina | 37125 | 13226 | 238 |
1799088 | 1799088 | 2021-10-09 | Nash | North Carolina | 37127 | 14947 | 223 |
1799089 | 1799089 | 2021-10-09 | New Hanover | North Carolina | 37129 | 28036 | 275 |
1799090 | 1799090 | 2021-10-09 | Northampton | North Carolina | 37131 | 2517 | 62 |
1799091 | 1799091 | 2021-10-09 | Onslow | North Carolina | 37133 | 27286 | 241 |
1799092 | 1799092 | 2021-10-09 | Orange | North Carolina | 37135 | 11440 | 109 |
1799093 | 1799093 | 2021-10-09 | Pamlico | North Carolina | 37137 | 1647 | 23 |
1799094 | 1799094 | 2021-10-09 | Pasquotank | North Carolina | 37139 | 4846 | 98 |
1799095 | 1799095 | 2021-10-09 | Pender | North Carolina | 37141 | 8585 | 95 |
1799096 | 1799096 | 2021-10-09 | Perquimans | North Carolina | 37143 | 1463 | 15 |
1799097 | 1799097 | 2021-10-09 | Person | North Carolina | 37145 | 4984 | 87 |
1799098 | 1799098 | 2021-10-09 | Pitt | North Carolina | 37147 | 28711 | 138 |
1799099 | 1799099 | 2021-10-09 | Polk | North Carolina | 37149 | 2235 | 43 |
1799100 | 1799100 | 2021-10-09 | Randolph | North Carolina | 37151 | 20926 | 296 |
1799101 | 1799101 | 2021-10-09 | Richmond | North Carolina | 37153 | 6927 | 134 |
1799102 | 1799102 | 2021-10-09 | Robeson | North Carolina | 37155 | 24495 | 415 |
1799103 | 1799103 | 2021-10-09 | Rockingham | North Carolina | 37157 | 11435 | 192 |
1799104 | 1799104 | 2021-10-09 | Rowan | North Carolina | 37159 | 25580 | 426 |
1799105 | 1799105 | 2021-10-09 | Rutherford | North Carolina | 37161 | 10970 | 293 |
1799106 | 1799106 | 2021-10-09 | Sampson | North Carolina | 37163 | 10910 | 128 |
1799107 | 1799107 | 2021-10-09 | Scotland | North Carolina | 37165 | 5569 | 104 |
1799108 | 1799108 | 2021-10-09 | Stanly | North Carolina | 37167 | 11276 | 173 |
1799109 | 1799109 | 2021-10-09 | Stokes | North Carolina | 37169 | 5922 | 101 |
1799110 | 1799110 | 2021-10-09 | Surry | North Carolina | 37171 | 11815 | 220 |
1799111 | 1799111 | 2021-10-09 | Swain | North Carolina | 37173 | 1900 | 22 |
1799112 | 1799112 | 2021-10-09 | Transylvania | North Carolina | 37175 | 3785 | 45 |
1799113 | 1799113 | 2021-10-09 | Tyrrell | North Carolina | 37177 | 530 | 7 |
1799114 | 1799114 | 2021-10-09 | Union | North Carolina | 37179 | 35163 | 311 |
1799115 | 1799115 | 2021-10-09 | Vance | North Carolina | 37181 | 6471 | 97 |
1799116 | 1799116 | 2021-10-09 | Wake | North Carolina | 37183 | 126366 | 869 |
1799117 | 1799117 | 2021-10-09 | Warren | North Carolina | 37185 | 2292 | 27 |
1799118 | 1799118 | 2021-10-09 | Washington | North Carolina | 37187 | 1539 | 35 |
1799119 | 1799119 | 2021-10-09 | Watauga | North Carolina | 37189 | 6386 | 34 |
1799120 | 1799120 | 2021-10-09 | Wayne | North Carolina | 37191 | 15404 | 297 |
1799121 | 1799121 | 2021-10-09 | Wilkes | North Carolina | 37193 | 10280 | 172 |
1799122 | 1799122 | 2021-10-09 | Wilson | North Carolina | 37195 | 12863 | 222 |
1799123 | 1799123 | 2021-10-09 | Yadkin | North Carolina | 37197 | 5795 | 70 |
1799124 | 1799124 | 2021-10-09 | Yancey | North Carolina | 37199 | 2728 | 29 |
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);