ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where date = "2021-10-05" 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 |
---|---|---|---|---|---|---|---|
1786030 | 1786030 | 2021-10-05 | Alamance | North Carolina | 37001 | 25288 | 310 |
1786031 | 1786031 | 2021-10-05 | Alexander | North Carolina | 37003 | 6177 | 111 |
1786032 | 1786032 | 2021-10-05 | Alleghany | North Carolina | 37005 | 1556 | 5 |
1786033 | 1786033 | 2021-10-05 | Anson | North Carolina | 37007 | 3690 | 74 |
1786034 | 1786034 | 2021-10-05 | Ashe | North Carolina | 37009 | 3294 | 46 |
1786035 | 1786035 | 2021-10-05 | Avery | North Carolina | 37011 | 2607 | 32 |
1786036 | 1786036 | 2021-10-05 | Beaufort | North Carolina | 37013 | 6755 | 121 |
1786037 | 1786037 | 2021-10-05 | Bertie | North Carolina | 37015 | 2376 | 49 |
1786038 | 1786038 | 2021-10-05 | Bladen | North Carolina | 37017 | 5333 | 93 |
1786039 | 1786039 | 2021-10-05 | Brunswick | North Carolina | 37019 | 15532 | 223 |
1786040 | 1786040 | 2021-10-05 | Buncombe | North Carolina | 37021 | 26417 | 407 |
1786041 | 1786041 | 2021-10-05 | Burke | North Carolina | 37023 | 15083 | 201 |
1786042 | 1786042 | 2021-10-05 | Cabarrus | North Carolina | 37025 | 31603 | 312 |
1786043 | 1786043 | 2021-10-05 | Caldwell | North Carolina | 37027 | 12740 | 158 |
1786044 | 1786044 | 2021-10-05 | Camden | North Carolina | 37029 | 1049 | 8 |
1786045 | 1786045 | 2021-10-05 | Carteret | North Carolina | 37031 | 7936 | 58 |
1786046 | 1786046 | 2021-10-05 | Caswell | North Carolina | 37033 | 3061 | 34 |
1786047 | 1786047 | 2021-10-05 | Catawba | North Carolina | 37035 | 27210 | 397 |
1786048 | 1786048 | 2021-10-05 | Chatham | North Carolina | 37037 | 6510 | 91 |
1786049 | 1786049 | 2021-10-05 | Cherokee | North Carolina | 37039 | 4511 | 71 |
1786050 | 1786050 | 2021-10-05 | Chowan | North Carolina | 37041 | 2204 | 40 |
1786051 | 1786051 | 2021-10-05 | Clay | North Carolina | 37043 | 1560 | 34 |
1786052 | 1786052 | 2021-10-05 | Cleveland | North Carolina | 37045 | 17518 | 290 |
1786053 | 1786053 | 2021-10-05 | Columbus | North Carolina | 37047 | 9778 | 214 |
1786054 | 1786054 | 2021-10-05 | Craven | North Carolina | 37049 | 13733 | 149 |
1786055 | 1786055 | 2021-10-05 | Cumberland | North Carolina | 37051 | 42867 | 440 |
1786056 | 1786056 | 2021-10-05 | Currituck | North Carolina | 37053 | 2562 | 25 |
1786057 | 1786057 | 2021-10-05 | Dare | North Carolina | 37055 | 3593 | 12 |
1786058 | 1786058 | 2021-10-05 | Davidson | North Carolina | 37057 | 24808 | 276 |
1786059 | 1786059 | 2021-10-05 | Davie | North Carolina | 37059 | 6063 | 65 |
1786060 | 1786060 | 2021-10-05 | Duplin | North Carolina | 37061 | 9540 | 170 |
1786061 | 1786061 | 2021-10-05 | Durham | North Carolina | 37063 | 33855 | 253 |
1786062 | 1786062 | 2021-10-05 | Edgecombe | North Carolina | 37065 | 7646 | 122 |
1786063 | 1786063 | 2021-10-05 | Forsyth | North Carolina | 37067 | 49557 | 521 |
1786064 | 1786064 | 2021-10-05 | Franklin | North Carolina | 37069 | 9418 | 60 |
1786065 | 1786065 | 2021-10-05 | Gaston | North Carolina | 37071 | 38259 | 574 |
1786066 | 1786066 | 2021-10-05 | Gates | North Carolina | 37073 | 1003 | 17 |
1786067 | 1786067 | 2021-10-05 | Graham | North Carolina | 37075 | 1279 | 27 |
1786068 | 1786068 | 2021-10-05 | Granville | North Carolina | 37077 | 7618 | 96 |
1786069 | 1786069 | 2021-10-05 | Greene | North Carolina | 37079 | 3196 | 53 |
1786070 | 1786070 | 2021-10-05 | Guilford | North Carolina | 37081 | 64746 | 838 |
1786071 | 1786071 | 2021-10-05 | Halifax | North Carolina | 37083 | 7527 | 132 |
1786072 | 1786072 | 2021-10-05 | Harnett | North Carolina | 37085 | 17572 | 238 |
1786073 | 1786073 | 2021-10-05 | Haywood | North Carolina | 37087 | 7015 | 135 |
1786074 | 1786074 | 2021-10-05 | Henderson | North Carolina | 37089 | 14507 | 189 |
1786075 | 1786075 | 2021-10-05 | Hertford | North Carolina | 37091 | 2686 | 69 |
1786076 | 1786076 | 2021-10-05 | Hoke | North Carolina | 37093 | 6881 | 74 |
1786077 | 1786077 | 2021-10-05 | Hyde | North Carolina | 37095 | 811 | 11 |
1786078 | 1786078 | 2021-10-05 | Iredell | North Carolina | 37097 | 27713 | 304 |
1786079 | 1786079 | 2021-10-05 | Jackson | North Carolina | 37099 | 5352 | 69 |
1786080 | 1786080 | 2021-10-05 | Johnston | North Carolina | 37101 | 31218 | 308 |
1786081 | 1786081 | 2021-10-05 | Jones | North Carolina | 37103 | 1268 | 29 |
1786082 | 1786082 | 2021-10-05 | Lee | North Carolina | 37105 | 9087 | 100 |
1786083 | 1786083 | 2021-10-05 | Lenoir | North Carolina | 37107 | 9188 | 145 |
1786084 | 1786084 | 2021-10-05 | Lincoln | North Carolina | 37109 | 14333 | 92 |
1786085 | 1786085 | 2021-10-05 | Macon | North Carolina | 37113 | 4721 | 54 |
1786086 | 1786086 | 2021-10-05 | Madison | North Carolina | 37115 | 2628 | 55 |
1786087 | 1786087 | 2021-10-05 | Martin | North Carolina | 37117 | 3478 | 63 |
1786088 | 1786088 | 2021-10-05 | McDowell | North Carolina | 37111 | 8218 | 112 |
1786089 | 1786089 | 2021-10-05 | Mecklenburg | North Carolina | 37119 | 152121 | 1166 |
1786090 | 1786090 | 2021-10-05 | Mitchell | North Carolina | 37121 | 1916 | 18 |
1786091 | 1786091 | 2021-10-05 | Montgomery | North Carolina | 37123 | 4353 | 107 |
1786092 | 1786092 | 2021-10-05 | Moore | North Carolina | 37125 | 13120 | 238 |
1786093 | 1786093 | 2021-10-05 | Nash | North Carolina | 37127 | 14857 | 222 |
1786094 | 1786094 | 2021-10-05 | New Hanover | North Carolina | 37129 | 27827 | 271 |
1786095 | 1786095 | 2021-10-05 | Northampton | North Carolina | 37131 | 2507 | 62 |
1786096 | 1786096 | 2021-10-05 | Onslow | North Carolina | 37133 | 26921 | 236 |
1786097 | 1786097 | 2021-10-05 | Orange | North Carolina | 37135 | 11345 | 109 |
1786098 | 1786098 | 2021-10-05 | Pamlico | North Carolina | 37137 | 1629 | 20 |
1786099 | 1786099 | 2021-10-05 | Pasquotank | North Carolina | 37139 | 4752 | 98 |
1786100 | 1786100 | 2021-10-05 | Pender | North Carolina | 37141 | 8550 | 94 |
1786101 | 1786101 | 2021-10-05 | Perquimans | North Carolina | 37143 | 1454 | 15 |
1786102 | 1786102 | 2021-10-05 | Person | North Carolina | 37145 | 4940 | 86 |
1786103 | 1786103 | 2021-10-05 | Pitt | North Carolina | 37147 | 28620 | 138 |
1786104 | 1786104 | 2021-10-05 | Polk | North Carolina | 37149 | 2225 | 42 |
1786105 | 1786105 | 2021-10-05 | Randolph | North Carolina | 37151 | 20703 | 291 |
1786106 | 1786106 | 2021-10-05 | Richmond | North Carolina | 37153 | 6901 | 134 |
1786107 | 1786107 | 2021-10-05 | Robeson | North Carolina | 37155 | 24385 | 408 |
1786108 | 1786108 | 2021-10-05 | Rockingham | North Carolina | 37157 | 11279 | 192 |
1786109 | 1786109 | 2021-10-05 | Rowan | North Carolina | 37159 | 25404 | 418 |
1786110 | 1786110 | 2021-10-05 | Rutherford | North Carolina | 37161 | 10863 | 293 |
1786111 | 1786111 | 2021-10-05 | Sampson | North Carolina | 37163 | 10817 | 127 |
1786112 | 1786112 | 2021-10-05 | Scotland | North Carolina | 37165 | 5527 | 104 |
1786113 | 1786113 | 2021-10-05 | Stanly | North Carolina | 37167 | 11163 | 164 |
1786114 | 1786114 | 2021-10-05 | Stokes | North Carolina | 37169 | 5872 | 99 |
1786115 | 1786115 | 2021-10-05 | Surry | North Carolina | 37171 | 11703 | 217 |
1786116 | 1786116 | 2021-10-05 | Swain | North Carolina | 37173 | 1875 | 22 |
1786117 | 1786117 | 2021-10-05 | Transylvania | North Carolina | 37175 | 3740 | 43 |
1786118 | 1786118 | 2021-10-05 | Tyrrell | North Carolina | 37177 | 525 | 6 |
1786119 | 1786119 | 2021-10-05 | Union | North Carolina | 37179 | 34852 | 302 |
1786120 | 1786120 | 2021-10-05 | Vance | North Carolina | 37181 | 6399 | 94 |
1786121 | 1786121 | 2021-10-05 | Wake | North Carolina | 37183 | 126153 | 859 |
1786122 | 1786122 | 2021-10-05 | Warren | North Carolina | 37185 | 2274 | 27 |
1786123 | 1786123 | 2021-10-05 | Washington | North Carolina | 37187 | 1521 | 35 |
1786124 | 1786124 | 2021-10-05 | Watauga | North Carolina | 37189 | 6325 | 34 |
1786125 | 1786125 | 2021-10-05 | Wayne | North Carolina | 37191 | 15309 | 296 |
1786126 | 1786126 | 2021-10-05 | Wilkes | North Carolina | 37193 | 10226 | 167 |
1786127 | 1786127 | 2021-10-05 | Wilson | North Carolina | 37195 | 12752 | 220 |
1786128 | 1786128 | 2021-10-05 | Yadkin | North Carolina | 37197 | 5750 | 70 |
1786129 | 1786129 | 2021-10-05 | Yancey | North Carolina | 37199 | 2692 | 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);