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-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 |
---|---|---|---|---|---|---|---|
1838014 | 1838014 | 2021-10-21 | Alamance | North Carolina | 37001 | 26115 | 333 |
1838015 | 1838015 | 2021-10-21 | Alexander | North Carolina | 37003 | 6404 | 115 |
1838016 | 1838016 | 2021-10-21 | Alleghany | North Carolina | 37005 | 1604 | 6 |
1838017 | 1838017 | 2021-10-21 | Anson | North Carolina | 37007 | 3799 | 78 |
1838018 | 1838018 | 2021-10-21 | Ashe | North Carolina | 37009 | 3415 | 48 |
1838019 | 1838019 | 2021-10-21 | Avery | North Carolina | 37011 | 2711 | 33 |
1838020 | 1838020 | 2021-10-21 | Beaufort | North Carolina | 37013 | 7061 | 126 |
1838021 | 1838021 | 2021-10-21 | Bertie | North Carolina | 37015 | 2451 | 51 |
1838022 | 1838022 | 2021-10-21 | Bladen | North Carolina | 37017 | 5439 | 94 |
1838023 | 1838023 | 2021-10-21 | Brunswick | North Carolina | 37019 | 16115 | 233 |
1838024 | 1838024 | 2021-10-21 | Buncombe | North Carolina | 37021 | 27813 | 427 |
1838025 | 1838025 | 2021-10-21 | Burke | North Carolina | 37023 | 15605 | 216 |
1838026 | 1838026 | 2021-10-21 | Cabarrus | North Carolina | 37025 | 32559 | 330 |
1838027 | 1838027 | 2021-10-21 | Caldwell | North Carolina | 37027 | 13144 | 213 |
1838028 | 1838028 | 2021-10-21 | Camden | North Carolina | 37029 | 1118 | 8 |
1838029 | 1838029 | 2021-10-21 | Carteret | North Carolina | 37031 | 8282 | 83 |
1838030 | 1838030 | 2021-10-21 | Caswell | North Carolina | 37033 | 3166 | 37 |
1838031 | 1838031 | 2021-10-21 | Catawba | North Carolina | 37035 | 28086 | 421 |
1838032 | 1838032 | 2021-10-21 | Chatham | North Carolina | 37037 | 6697 | 91 |
1838033 | 1838033 | 2021-10-21 | Cherokee | North Carolina | 37039 | 4623 | 75 |
1838034 | 1838034 | 2021-10-21 | Chowan | North Carolina | 37041 | 2270 | 40 |
1838035 | 1838035 | 2021-10-21 | Clay | North Carolina | 37043 | 1646 | 35 |
1838036 | 1838036 | 2021-10-21 | Cleveland | North Carolina | 37045 | 18215 | 302 |
1838037 | 1838037 | 2021-10-21 | Columbus | North Carolina | 37047 | 9989 | 222 |
1838038 | 1838038 | 2021-10-21 | Craven | North Carolina | 37049 | 14177 | 155 |
1838039 | 1838039 | 2021-10-21 | Cumberland | North Carolina | 37051 | 44682 | 462 |
1838040 | 1838040 | 2021-10-21 | Currituck | North Carolina | 37053 | 2695 | 25 |
1838041 | 1838041 | 2021-10-21 | Dare | North Carolina | 37055 | 3746 | 12 |
1838042 | 1838042 | 2021-10-21 | Davidson | North Carolina | 37057 | 25564 | 304 |
1838043 | 1838043 | 2021-10-21 | Davie | North Carolina | 37059 | 6347 | 73 |
1838044 | 1838044 | 2021-10-21 | Duplin | North Carolina | 37061 | 9891 | 179 |
1838045 | 1838045 | 2021-10-21 | Durham | North Carolina | 37063 | 34694 | 257 |
1838046 | 1838046 | 2021-10-21 | Edgecombe | North Carolina | 37065 | 7870 | 124 |
1838047 | 1838047 | 2021-10-21 | Forsyth | North Carolina | 37067 | 51239 | 553 |
1838048 | 1838048 | 2021-10-21 | Franklin | North Carolina | 37069 | 9807 | 61 |
1838049 | 1838049 | 2021-10-21 | Gaston | North Carolina | 37071 | 39665 | 603 |
1838050 | 1838050 | 2021-10-21 | Gates | North Carolina | 37073 | 1076 | 19 |
1838051 | 1838051 | 2021-10-21 | Graham | North Carolina | 37075 | 1323 | 28 |
1838052 | 1838052 | 2021-10-21 | Granville | North Carolina | 37077 | 7843 | 99 |
1838053 | 1838053 | 2021-10-21 | Greene | North Carolina | 37079 | 3283 | 56 |
1838054 | 1838054 | 2021-10-21 | Guilford | North Carolina | 37081 | 67150 | 862 |
1838055 | 1838055 | 2021-10-21 | Halifax | North Carolina | 37083 | 7820 | 136 |
1838056 | 1838056 | 2021-10-21 | Harnett | North Carolina | 37085 | 18276 | 250 |
1838057 | 1838057 | 2021-10-21 | Haywood | North Carolina | 37087 | 7359 | 138 |
1838058 | 1838058 | 2021-10-21 | Henderson | North Carolina | 37089 | 15055 | 196 |
1838059 | 1838059 | 2021-10-21 | Hertford | North Carolina | 37091 | 2823 | 70 |
1838060 | 1838060 | 2021-10-21 | Hoke | North Carolina | 37093 | 7063 | 81 |
1838061 | 1838061 | 2021-10-21 | Hyde | North Carolina | 37095 | 825 | 12 |
1838062 | 1838062 | 2021-10-21 | Iredell | North Carolina | 37097 | 28518 | 320 |
1838063 | 1838063 | 2021-10-21 | Jackson | North Carolina | 37099 | 5598 | 70 |
1838064 | 1838064 | 2021-10-21 | Johnston | North Carolina | 37101 | 32092 | 326 |
1838065 | 1838065 | 2021-10-21 | Jones | North Carolina | 37103 | 1314 | 31 |
1838066 | 1838066 | 2021-10-21 | Lee | North Carolina | 37105 | 9353 | 107 |
1838067 | 1838067 | 2021-10-21 | Lenoir | North Carolina | 37107 | 9409 | 149 |
1838068 | 1838068 | 2021-10-21 | Lincoln | North Carolina | 37109 | 14830 | 107 |
1838069 | 1838069 | 2021-10-21 | Macon | North Carolina | 37113 | 4911 | 57 |
1838070 | 1838070 | 2021-10-21 | Madison | North Carolina | 37115 | 2742 | 61 |
1838071 | 1838071 | 2021-10-21 | Martin | North Carolina | 37117 | 3609 | 70 |
1838072 | 1838072 | 2021-10-21 | McDowell | North Carolina | 37111 | 8541 | 124 |
1838073 | 1838073 | 2021-10-21 | Mecklenburg | North Carolina | 37119 | 155881 | 1224 |
1838074 | 1838074 | 2021-10-21 | Mitchell | North Carolina | 37121 | 2018 | 18 |
1838075 | 1838075 | 2021-10-21 | Montgomery | North Carolina | 37123 | 4489 | 108 |
1838076 | 1838076 | 2021-10-21 | Moore | North Carolina | 37125 | 13525 | 245 |
1838077 | 1838077 | 2021-10-21 | Nash | North Carolina | 37127 | 15212 | 233 |
1838078 | 1838078 | 2021-10-21 | New Hanover | North Carolina | 37129 | 28505 | 282 |
1838079 | 1838079 | 2021-10-21 | Northampton | North Carolina | 37131 | 2585 | 64 |
1838080 | 1838080 | 2021-10-21 | Onslow | North Carolina | 37133 | 28846 | 254 |
1838081 | 1838081 | 2021-10-21 | Orange | North Carolina | 37135 | 11716 | 110 |
1838082 | 1838082 | 2021-10-21 | Pamlico | North Carolina | 37137 | 1705 | 25 |
1838083 | 1838083 | 2021-10-21 | Pasquotank | North Carolina | 37139 | 5131 | 101 |
1838084 | 1838084 | 2021-10-21 | Pender | North Carolina | 37141 | 8766 | 100 |
1838085 | 1838085 | 2021-10-21 | Perquimans | North Carolina | 37143 | 1516 | 15 |
1838086 | 1838086 | 2021-10-21 | Person | North Carolina | 37145 | 5064 | 87 |
1838087 | 1838087 | 2021-10-21 | Pitt | North Carolina | 37147 | 29390 | 142 |
1838088 | 1838088 | 2021-10-21 | Polk | North Carolina | 37149 | 2305 | 44 |
1838089 | 1838089 | 2021-10-21 | Randolph | North Carolina | 37151 | 21563 | 306 |
1838090 | 1838090 | 2021-10-21 | Richmond | North Carolina | 37153 | 7054 | 136 |
1838091 | 1838091 | 2021-10-21 | Robeson | North Carolina | 37155 | 24814 | 424 |
1838092 | 1838092 | 2021-10-21 | Rockingham | North Carolina | 37157 | 11931 | 192 |
1838093 | 1838093 | 2021-10-21 | Rowan | North Carolina | 37159 | 26020 | 443 |
1838094 | 1838094 | 2021-10-21 | Rutherford | North Carolina | 37161 | 11320 | 308 |
1838095 | 1838095 | 2021-10-21 | Sampson | North Carolina | 37163 | 11190 | 133 |
1838096 | 1838096 | 2021-10-21 | Scotland | North Carolina | 37165 | 5674 | 106 |
1838097 | 1838097 | 2021-10-21 | Stanly | North Carolina | 37167 | 11531 | 180 |
1838098 | 1838098 | 2021-10-21 | Stokes | North Carolina | 37169 | 6146 | 106 |
1838099 | 1838099 | 2021-10-21 | Surry | North Carolina | 37171 | 12210 | 226 |
1838100 | 1838100 | 2021-10-21 | Swain | North Carolina | 37173 | 1943 | 23 |
1838101 | 1838101 | 2021-10-21 | Transylvania | North Carolina | 37175 | 3857 | 48 |
1838102 | 1838102 | 2021-10-21 | Tyrrell | North Carolina | 37177 | 545 | 7 |
1838103 | 1838103 | 2021-10-21 | Union | North Carolina | 37179 | 35964 | 332 |
1838104 | 1838104 | 2021-10-21 | Vance | North Carolina | 37181 | 6726 | 100 |
1838105 | 1838105 | 2021-10-21 | Wake | North Carolina | 37183 | 129589 | 883 |
1838106 | 1838106 | 2021-10-21 | Warren | North Carolina | 37185 | 2347 | 29 |
1838107 | 1838107 | 2021-10-21 | Washington | North Carolina | 37187 | 1568 | 37 |
1838108 | 1838108 | 2021-10-21 | Watauga | North Carolina | 37189 | 6549 | 38 |
1838109 | 1838109 | 2021-10-21 | Wayne | North Carolina | 37191 | 15945 | 297 |
1838110 | 1838110 | 2021-10-21 | Wilkes | North Carolina | 37193 | 10465 | 179 |
1838111 | 1838111 | 2021-10-21 | Wilson | North Carolina | 37195 | 13114 | 232 |
1838112 | 1838112 | 2021-10-21 | Yadkin | North Carolina | 37197 | 5935 | 73 |
1838113 | 1838113 | 2021-10-21 | Yancey | North Carolina | 37199 | 2792 | 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);