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-03-21 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 |
---|---|---|---|---|---|---|---|
1143054 | 1143054 | 2021-03-21 | Alamance | North Carolina | 37001 | 16417 | 237 |
1143055 | 1143055 | 2021-03-21 | Alexander | North Carolina | 37003 | 4031 | 82 |
1143056 | 1143056 | 2021-03-21 | Alleghany | North Carolina | 37005 | 936 | 5 |
1143057 | 1143057 | 2021-03-21 | Anson | North Carolina | 37007 | 2399 | 53 |
1143058 | 1143058 | 2021-03-21 | Ashe | North Carolina | 37009 | 1923 | 40 |
1143059 | 1143059 | 2021-03-21 | Avery | North Carolina | 37011 | 1944 | 20 |
1143060 | 1143060 | 2021-03-21 | Beaufort | North Carolina | 37013 | 4403 | 87 |
1143061 | 1143061 | 2021-03-21 | Bertie | North Carolina | 37015 | 1686 | 41 |
1143062 | 1143062 | 2021-03-21 | Bladen | North Carolina | 37017 | 3055 | 41 |
1143063 | 1143063 | 2021-03-21 | Brunswick | North Carolina | 37019 | 8400 | 142 |
1143064 | 1143064 | 2021-03-21 | Buncombe | North Carolina | 37021 | 16119 | 304 |
1143065 | 1143065 | 2021-03-21 | Burke | North Carolina | 37023 | 9469 | 145 |
1143066 | 1143066 | 2021-03-21 | Cabarrus | North Carolina | 37025 | 19254 | 239 |
1143067 | 1143067 | 2021-03-21 | Caldwell | North Carolina | 37027 | 8850 | 97 |
1143068 | 1143068 | 2021-03-21 | Camden | North Carolina | 37029 | 617 | 5 |
1143069 | 1143069 | 2021-03-21 | Carteret | North Carolina | 37031 | 4610 | 45 |
1143070 | 1143070 | 2021-03-21 | Caswell | North Carolina | 37033 | 2041 | 25 |
1143071 | 1143071 | 2021-03-21 | Catawba | North Carolina | 37035 | 17972 | 289 |
1143072 | 1143072 | 2021-03-21 | Chatham | North Carolina | 37037 | 4277 | 80 |
1143073 | 1143073 | 2021-03-21 | Cherokee | North Carolina | 37039 | 2191 | 19 |
1143074 | 1143074 | 2021-03-21 | Chowan | North Carolina | 37041 | 1392 | 22 |
1143075 | 1143075 | 2021-03-21 | Clay | North Carolina | 37043 | 669 | 18 |
1143076 | 1143076 | 2021-03-21 | Cleveland | North Carolina | 37045 | 10701 | 218 |
1143077 | 1143077 | 2021-03-21 | Columbus | North Carolina | 37047 | 6062 | 147 |
1143078 | 1143078 | 2021-03-21 | Craven | North Carolina | 37049 | 8720 | 117 |
1143079 | 1143079 | 2021-03-21 | Cumberland | North Carolina | 37051 | 25242 | 289 |
1143080 | 1143080 | 2021-03-21 | Currituck | North Carolina | 37053 | 1435 | 15 |
1143081 | 1143081 | 2021-03-21 | Dare | North Carolina | 37055 | 1934 | 8 |
1143082 | 1143082 | 2021-03-21 | Davidson | North Carolina | 37057 | 15037 | 177 |
1143083 | 1143083 | 2021-03-21 | Davie | North Carolina | 37059 | 3697 | 35 |
1143084 | 1143084 | 2021-03-21 | Duplin | North Carolina | 37061 | 5886 | 128 |
1143085 | 1143085 | 2021-03-21 | Durham | North Carolina | 37063 | 23152 | 214 |
1143086 | 1143086 | 2021-03-21 | Edgecombe | North Carolina | 37065 | 4871 | 100 |
1143087 | 1143087 | 2021-03-21 | Forsyth | North Carolina | 37067 | 32874 | 357 |
1143088 | 1143088 | 2021-03-21 | Franklin | North Carolina | 37069 | 5796 | 46 |
1143089 | 1143089 | 2021-03-21 | Gaston | North Carolina | 37071 | 24450 | 398 |
1143090 | 1143090 | 2021-03-21 | Gates | North Carolina | 37073 | 694 | 12 |
1143091 | 1143091 | 2021-03-21 | Graham | North Carolina | 37075 | 569 | 12 |
1143092 | 1143092 | 2021-03-21 | Granville | North Carolina | 37077 | 5481 | 76 |
1143093 | 1143093 | 2021-03-21 | Greene | North Carolina | 37079 | 2170 | 42 |
1143094 | 1143094 | 2021-03-21 | Guilford | North Carolina | 37081 | 41677 | 584 |
1143095 | 1143095 | 2021-03-21 | Halifax | North Carolina | 37083 | 5101 | 103 |
1143096 | 1143096 | 2021-03-21 | Harnett | North Carolina | 37085 | 10169 | 161 |
1143097 | 1143097 | 2021-03-21 | Haywood | North Carolina | 37087 | 3959 | 90 |
1143098 | 1143098 | 2021-03-21 | Henderson | North Carolina | 37089 | 9352 | 152 |
1143099 | 1143099 | 2021-03-21 | Hertford | North Carolina | 37091 | 1987 | 63 |
1143100 | 1143100 | 2021-03-21 | Hoke | North Carolina | 37093 | 4277 | 55 |
1143101 | 1143101 | 2021-03-21 | Hyde | North Carolina | 37095 | 630 | 8 |
1143102 | 1143102 | 2021-03-21 | Iredell | North Carolina | 37097 | 17070 | 202 |
1143103 | 1143103 | 2021-03-21 | Jackson | North Carolina | 37099 | 3437 | 55 |
1143104 | 1143104 | 2021-03-21 | Johnston | North Carolina | 37101 | 18919 | 206 |
1143105 | 1143105 | 2021-03-21 | Jones | North Carolina | 37103 | 764 | 16 |
1143106 | 1143106 | 2021-03-21 | Lee | North Carolina | 37105 | 5592 | 73 |
1143107 | 1143107 | 2021-03-21 | Lenoir | North Carolina | 37107 | 5592 | 109 |
1143108 | 1143108 | 2021-03-21 | Lincoln | North Carolina | 37109 | 9129 | 77 |
1143109 | 1143109 | 2021-03-21 | Macon | North Carolina | 37113 | 2636 | 31 |
1143110 | 1143110 | 2021-03-21 | Madison | North Carolina | 37115 | 1424 | 40 |
1143111 | 1143111 | 2021-03-21 | Martin | North Carolina | 37117 | 2122 | 37 |
1143112 | 1143112 | 2021-03-21 | McDowell | North Carolina | 37111 | 4992 | 62 |
1143113 | 1143113 | 2021-03-21 | Mecklenburg | North Carolina | 37119 | 100377 | 905 |
1143114 | 1143114 | 2021-03-21 | Mitchell | North Carolina | 37121 | 1287 | 16 |
1143115 | 1143115 | 2021-03-21 | Montgomery | North Carolina | 37123 | 3168 | 89 |
1143116 | 1143116 | 2021-03-21 | Moore | North Carolina | 37125 | 8256 | 182 |
1143117 | 1143117 | 2021-03-21 | Nash | North Carolina | 37127 | 10204 | 174 |
1143118 | 1143118 | 2021-03-21 | New Hanover | North Carolina | 37129 | 17035 | 159 |
1143119 | 1143119 | 2021-03-21 | Northampton | North Carolina | 37131 | 1764 | 39 |
1143120 | 1143120 | 2021-03-21 | Onslow | North Carolina | 37133 | 15162 | 139 |
1143121 | 1143121 | 2021-03-21 | Orange | North Carolina | 37135 | 7905 | 99 |
1143122 | 1143122 | 2021-03-21 | Pamlico | North Carolina | 37137 | 1013 | 11 |
1143123 | 1143123 | 2021-03-21 | Pasquotank | North Carolina | 37139 | 3153 | 78 |
1143124 | 1143124 | 2021-03-21 | Pender | North Carolina | 37141 | 4932 | 67 |
1143125 | 1143125 | 2021-03-21 | Perquimans | North Carolina | 37143 | 937 | 9 |
1143126 | 1143126 | 2021-03-21 | Person | North Carolina | 37145 | 3154 | 67 |
1143127 | 1143127 | 2021-03-21 | Pitt | North Carolina | 37147 | 17996 | 84 |
1143128 | 1143128 | 2021-03-21 | Polk | North Carolina | 37149 | 1389 | 27 |
1143129 | 1143129 | 2021-03-21 | Randolph | North Carolina | 37151 | 13953 | 208 |
1143130 | 1143130 | 2021-03-21 | Richmond | North Carolina | 37153 | 4311 | 92 |
1143131 | 1143131 | 2021-03-21 | Robeson | North Carolina | 37155 | 15570 | 221 |
1143132 | 1143132 | 2021-03-21 | Rockingham | North Carolina | 37157 | 7010 | 68 |
1143133 | 1143133 | 2021-03-21 | Rowan | North Carolina | 37159 | 15406 | 292 |
1143134 | 1143134 | 2021-03-21 | Rutherford | North Carolina | 37161 | 6875 | 201 |
1143135 | 1143135 | 2021-03-21 | Sampson | North Carolina | 37163 | 7248 | 96 |
1143136 | 1143136 | 2021-03-21 | Scotland | North Carolina | 37165 | 3544 | 80 |
1143137 | 1143137 | 2021-03-21 | Stanly | North Carolina | 37167 | 7133 | 112 |
1143138 | 1143138 | 2021-03-21 | Stokes | North Carolina | 37169 | 3741 | 75 |
1143139 | 1143139 | 2021-03-21 | Surry | North Carolina | 37171 | 7556 | 140 |
1143140 | 1143140 | 2021-03-21 | Swain | North Carolina | 37173 | 1180 | 16 |
1143141 | 1143141 | 2021-03-21 | Transylvania | North Carolina | 37175 | 2006 | 28 |
1143142 | 1143142 | 2021-03-21 | Tyrrell | North Carolina | 37177 | 306 | 6 |
1143143 | 1143143 | 2021-03-21 | Union | North Carolina | 37179 | 21727 | 206 |
1143144 | 1143144 | 2021-03-21 | Vance | North Carolina | 37181 | 4542 | 85 |
1143145 | 1143145 | 2021-03-21 | Wake | North Carolina | 37183 | 78725 | 586 |
1143146 | 1143146 | 2021-03-21 | Warren | North Carolina | 37185 | 1668 | 18 |
1143147 | 1143147 | 2021-03-21 | Washington | North Carolina | 37187 | 1008 | 31 |
1143148 | 1143148 | 2021-03-21 | Watauga | North Carolina | 37189 | 4154 | 30 |
1143149 | 1143149 | 2021-03-21 | Wayne | North Carolina | 37191 | 10451 | 233 |
1143150 | 1143150 | 2021-03-21 | Wilkes | North Carolina | 37193 | 6214 | 104 |
1143151 | 1143151 | 2021-03-21 | Wilson | North Carolina | 37195 | 8821 | 152 |
1143152 | 1143152 | 2021-03-21 | Yadkin | North Carolina | 37197 | 3765 | 47 |
1143153 | 1143153 | 2021-03-21 | Yancey | North Carolina | 37199 | 1494 | 26 |
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);