ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where date = "2022-03-10" 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 |
---|---|---|---|---|---|---|---|
2293172 | 2293172 | 2022-03-10 | Alamance | North Carolina | 37001 | 46405 | 447 |
2293173 | 2293173 | 2022-03-10 | Alexander | North Carolina | 37003 | 10372 | 133 |
2293174 | 2293174 | 2022-03-10 | Alleghany | North Carolina | 37005 | 2930 | 12 |
2293175 | 2293175 | 2022-03-10 | Anson | North Carolina | 37007 | 6509 | 96 |
2293176 | 2293176 | 2022-03-10 | Ashe | North Carolina | 37009 | 6354 | 73 |
2293177 | 2293177 | 2022-03-10 | Avery | North Carolina | 37011 | 4414 | 42 |
2293178 | 2293178 | 2022-03-10 | Beaufort | North Carolina | 37013 | 12194 | 159 |
2293179 | 2293179 | 2022-03-10 | Bertie | North Carolina | 37015 | 4212 | 66 |
2293180 | 2293180 | 2022-03-10 | Bladen | North Carolina | 37017 | 9280 | 119 |
2293181 | 2293181 | 2022-03-10 | Brunswick | North Carolina | 37019 | 29514 | 306 |
2293182 | 2293182 | 2022-03-10 | Buncombe | North Carolina | 37021 | 51522 | 550 |
2293183 | 2293183 | 2022-03-10 | Burke | North Carolina | 37023 | 24783 | 302 |
2293184 | 2293184 | 2022-03-10 | Cabarrus | North Carolina | 37025 | 55109 | 463 |
2293185 | 2293185 | 2022-03-10 | Caldwell | North Carolina | 37027 | 22020 | 295 |
2293186 | 2293186 | 2022-03-10 | Camden | North Carolina | 37029 | 1723 | 9 |
2293187 | 2293187 | 2022-03-10 | Carteret | North Carolina | 37031 | 13986 | 85 |
2293188 | 2293188 | 2022-03-10 | Caswell | North Carolina | 37033 | 5209 | 44 |
2293189 | 2293189 | 2022-03-10 | Catawba | North Carolina | 37035 | 47363 | 555 |
2293190 | 2293190 | 2022-03-10 | Chatham | North Carolina | 37037 | 12562 | 108 |
2293191 | 2293191 | 2022-03-10 | Cherokee | North Carolina | 37039 | 7079 | 115 |
2293192 | 2293192 | 2022-03-10 | Chowan | North Carolina | 37041 | 4109 | 54 |
2293193 | 2293193 | 2022-03-10 | Clay | North Carolina | 37043 | 2617 | 39 |
2293194 | 2293194 | 2022-03-10 | Cleveland | North Carolina | 37045 | 29486 | 362 |
2293195 | 2293195 | 2022-03-10 | Columbus | North Carolina | 37047 | 15852 | 265 |
2293196 | 2293196 | 2022-03-10 | Craven | North Carolina | 37049 | 23885 | 191 |
2293197 | 2293197 | 2022-03-10 | Cumberland | North Carolina | 37051 | 82270 | 557 |
2293198 | 2293198 | 2022-03-10 | Currituck | North Carolina | 37053 | 4851 | 32 |
2293199 | 2293199 | 2022-03-10 | Dare | North Carolina | 37055 | 7328 | 23 |
2293200 | 2293200 | 2022-03-10 | Davidson | North Carolina | 37057 | 42792 | 390 |
2293201 | 2293201 | 2022-03-10 | Davie | North Carolina | 37059 | 11066 | 90 |
2293202 | 2293202 | 2022-03-10 | Duplin | North Carolina | 37061 | 16742 | 232 |
2293203 | 2293203 | 2022-03-10 | Durham | North Carolina | 37063 | 71296 | 298 |
2293204 | 2293204 | 2022-03-10 | Edgecombe | North Carolina | 37065 | 13392 | 141 |
2293205 | 2293205 | 2022-03-10 | Forsyth | North Carolina | 37067 | 91610 | 774 |
2293206 | 2293206 | 2022-03-10 | Franklin | North Carolina | 37069 | 20105 | 65 |
2293207 | 2293207 | 2022-03-10 | Gaston | North Carolina | 37071 | 64818 | 785 |
2293208 | 2293208 | 2022-03-10 | Gates | North Carolina | 37073 | 1861 | 19 |
2293209 | 2293209 | 2022-03-10 | Graham | North Carolina | 37075 | 2265 | 30 |
2293210 | 2293210 | 2022-03-10 | Granville | North Carolina | 37077 | 14118 | 111 |
2293211 | 2293211 | 2022-03-10 | Greene | North Carolina | 37079 | 5756 | 56 |
2293212 | 2293212 | 2022-03-10 | Guilford | North Carolina | 37081 | 115316 | 1120 |
2293213 | 2293213 | 2022-03-10 | Halifax | North Carolina | 37083 | 13881 | 177 |
2293214 | 2293214 | 2022-03-10 | Harnett | North Carolina | 37085 | 32257 | 317 |
2293215 | 2293215 | 2022-03-10 | Haywood | North Carolina | 37087 | 12836 | 194 |
2293216 | 2293216 | 2022-03-10 | Henderson | North Carolina | 37089 | 24653 | 287 |
2293217 | 2293217 | 2022-03-10 | Hertford | North Carolina | 37091 | 4688 | 81 |
2293218 | 2293218 | 2022-03-10 | Hoke | North Carolina | 37093 | 14507 | 103 |
2293219 | 2293219 | 2022-03-10 | Hyde | North Carolina | 37095 | 1304 | 13 |
2293220 | 2293220 | 2022-03-10 | Iredell | North Carolina | 37097 | 47976 | 439 |
2293221 | 2293221 | 2022-03-10 | Jackson | North Carolina | 37099 | 9234 | 86 |
2293222 | 2293222 | 2022-03-10 | Johnston | North Carolina | 37101 | 58517 | 427 |
2293223 | 2293223 | 2022-03-10 | Jones | North Carolina | 37103 | 2198 | 38 |
2293224 | 2293224 | 2022-03-10 | Lee | North Carolina | 37105 | 15830 | 138 |
2293225 | 2293225 | 2022-03-10 | Lenoir | North Carolina | 37107 | 15607 | 204 |
2293226 | 2293226 | 2022-03-10 | Lincoln | North Carolina | 37109 | 24126 | 158 |
2293227 | 2293227 | 2022-03-10 | Macon | North Carolina | 37113 | 7467 | 106 |
2293228 | 2293228 | 2022-03-10 | Madison | North Carolina | 37115 | 5036 | 79 |
2293229 | 2293229 | 2022-03-10 | Martin | North Carolina | 37117 | 6040 | 89 |
2293230 | 2293230 | 2022-03-10 | McDowell | North Carolina | 37111 | 13461 | 164 |
2293231 | 2293231 | 2022-03-10 | Mecklenburg | North Carolina | 37119 | 275930 | 1550 |
2293232 | 2293232 | 2022-03-10 | Mitchell | North Carolina | 37121 | 3263 | 34 |
2293233 | 2293233 | 2022-03-10 | Montgomery | North Carolina | 37123 | 7239 | 126 |
2293234 | 2293234 | 2022-03-10 | Moore | North Carolina | 37125 | 24031 | 315 |
2293235 | 2293235 | 2022-03-10 | Nash | North Carolina | 37127 | 26849 | 292 |
2293236 | 2293236 | 2022-03-10 | New Hanover | North Carolina | 37129 | 49438 | 379 |
2293237 | 2293237 | 2022-03-10 | Northampton | North Carolina | 37131 | 4304 | 82 |
2293238 | 2293238 | 2022-03-10 | Onslow | North Carolina | 37133 | 51659 | 367 |
2293239 | 2293239 | 2022-03-10 | Orange | North Carolina | 37135 | 25673 | 123 |
2293240 | 2293240 | 2022-03-10 | Pamlico | North Carolina | 37137 | 2586 | 27 |
2293241 | 2293241 | 2022-03-10 | Pasquotank | North Carolina | 37139 | 8330 | 111 |
2293242 | 2293242 | 2022-03-10 | Pender | North Carolina | 37141 | 15204 | 118 |
2293243 | 2293243 | 2022-03-10 | Perquimans | North Carolina | 37143 | 2737 | 18 |
2293244 | 2293244 | 2022-03-10 | Person | North Carolina | 37145 | 9172 | 104 |
2293245 | 2293245 | 2022-03-10 | Pitt | North Carolina | 37147 | 52196 | 152 |
2293246 | 2293246 | 2022-03-10 | Polk | North Carolina | 37149 | 3822 | 53 |
2293247 | 2293247 | 2022-03-10 | Randolph | North Carolina | 37151 | 35273 | 397 |
2293248 | 2293248 | 2022-03-10 | Richmond | North Carolina | 37153 | 12522 | 185 |
2293249 | 2293249 | 2022-03-10 | Robeson | North Carolina | 37155 | 40291 | 520 |
2293250 | 2293250 | 2022-03-10 | Rockingham | North Carolina | 37157 | 21806 | 264 |
2293251 | 2293251 | 2022-03-10 | Rowan | North Carolina | 37159 | 40913 | 563 |
2293252 | 2293252 | 2022-03-10 | Rutherford | North Carolina | 37161 | 17346 | 394 |
2293253 | 2293253 | 2022-03-10 | Sampson | North Carolina | 37163 | 18619 | 165 |
2293254 | 2293254 | 2022-03-10 | Scotland | North Carolina | 37165 | 9903 | 126 |
2293255 | 2293255 | 2022-03-10 | Stanly | North Carolina | 37167 | 19346 | 250 |
2293256 | 2293256 | 2022-03-10 | Stokes | North Carolina | 37169 | 11109 | 170 |
2293257 | 2293257 | 2022-03-10 | Surry | North Carolina | 37171 | 20908 | 328 |
2293258 | 2293258 | 2022-03-10 | Swain | North Carolina | 37173 | 3445 | 37 |
2293259 | 2293259 | 2022-03-10 | Transylvania | North Carolina | 37175 | 6087 | 69 |
2293260 | 2293260 | 2022-03-10 | Tyrrell | North Carolina | 37177 | 974 | 8 |
2293261 | 2293261 | 2022-03-10 | Union | North Carolina | 37179 | 61324 | 476 |
2293262 | 2293262 | 2022-03-10 | Vance | North Carolina | 37181 | 11783 | 112 |
2293263 | 2293263 | 2022-03-10 | Wake | North Carolina | 37183 | 287665 | 1036 |
2293264 | 2293264 | 2022-03-10 | Warren | North Carolina | 37185 | 4289 | 39 |
2293265 | 2293265 | 2022-03-10 | Washington | North Carolina | 37187 | 3002 | 50 |
2293266 | 2293266 | 2022-03-10 | Watauga | North Carolina | 37189 | 12244 | 56 |
2293267 | 2293267 | 2022-03-10 | Wayne | North Carolina | 37191 | 27941 | 381 |
2293268 | 2293268 | 2022-03-10 | Wilkes | North Carolina | 37193 | 17544 | 253 |
2293269 | 2293269 | 2022-03-10 | Wilson | North Carolina | 37195 | 21412 | 301 |
2293270 | 2293270 | 2022-03-10 | Yadkin | North Carolina | 37197 | 10708 | 107 |
2293271 | 2293271 | 2022-03-10 | Yancey | North Carolina | 37199 | 4890 | 51 |
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);