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 2020-07-01 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 |
---|---|---|---|---|---|---|---|
292071 | 292071 | 2020-07-01 | Alamance | North Carolina | 37001 | 1151 | 37 |
292072 | 292072 | 2020-07-01 | Alexander | North Carolina | 37003 | 93 | 1 |
292073 | 292073 | 2020-07-01 | Alleghany | North Carolina | 37005 | 32 | 0 |
292074 | 292074 | 2020-07-01 | Anson | North Carolina | 37007 | 132 | 1 |
292075 | 292075 | 2020-07-01 | Ashe | North Carolina | 37009 | 54 | 1 |
292076 | 292076 | 2020-07-01 | Avery | North Carolina | 37011 | 12 | 0 |
292077 | 292077 | 2020-07-01 | Beaufort | North Carolina | 37013 | 83 | 0 |
292078 | 292078 | 2020-07-01 | Bertie | North Carolina | 37015 | 146 | 4 |
292079 | 292079 | 2020-07-01 | Bladen | North Carolina | 37017 | 379 | 3 |
292080 | 292080 | 2020-07-01 | Brunswick | North Carolina | 37019 | 546 | 8 |
292081 | 292081 | 2020-07-01 | Buncombe | North Carolina | 37021 | 603 | 38 |
292082 | 292082 | 2020-07-01 | Burke | North Carolina | 37023 | 1042 | 20 |
292083 | 292083 | 2020-07-01 | Cabarrus | North Carolina | 37025 | 1141 | 33 |
292084 | 292084 | 2020-07-01 | Caldwell | North Carolina | 37027 | 434 | 4 |
292085 | 292085 | 2020-07-01 | Camden | North Carolina | 37029 | 29 | 0 |
292086 | 292086 | 2020-07-01 | Carteret | North Carolina | 37031 | 87 | 3 |
292087 | 292087 | 2020-07-01 | Caswell | North Carolina | 37033 | 135 | 1 |
292088 | 292088 | 2020-07-01 | Catawba | North Carolina | 37035 | 811 | 12 |
292089 | 292089 | 2020-07-01 | Chatham | North Carolina | 37037 | 956 | 43 |
292090 | 292090 | 2020-07-01 | Cherokee | North Carolina | 37039 | 35 | 1 |
292091 | 292091 | 2020-07-01 | Chowan | North Carolina | 37041 | 24 | 0 |
292092 | 292092 | 2020-07-01 | Clay | North Carolina | 37043 | 10 | 0 |
292093 | 292093 | 2020-07-01 | Cleveland | North Carolina | 37045 | 315 | 4 |
292094 | 292094 | 2020-07-01 | Columbus | North Carolina | 37047 | 535 | 39 |
292095 | 292095 | 2020-07-01 | Craven | North Carolina | 37049 | 372 | 6 |
292096 | 292096 | 2020-07-01 | Cumberland | North Carolina | 37051 | 1218 | 41 |
292097 | 292097 | 2020-07-01 | Currituck | North Carolina | 37053 | 19 | 0 |
292098 | 292098 | 2020-07-01 | Dare | North Carolina | 37055 | 59 | 1 |
292099 | 292099 | 2020-07-01 | Davidson | North Carolina | 37057 | 989 | 15 |
292100 | 292100 | 2020-07-01 | Davie | North Carolina | 37059 | 203 | 3 |
292101 | 292101 | 2020-07-01 | Duplin | North Carolina | 37061 | 1486 | 27 |
292102 | 292102 | 2020-07-01 | Durham | North Carolina | 37063 | 3876 | 65 |
292103 | 292103 | 2020-07-01 | Edgecombe | North Carolina | 37065 | 317 | 9 |
292104 | 292104 | 2020-07-01 | Forsyth | North Carolina | 37067 | 3077 | 35 |
292105 | 292105 | 2020-07-01 | Franklin | North Carolina | 37069 | 357 | 21 |
292106 | 292106 | 2020-07-01 | Gaston | North Carolina | 37071 | 1139 | 11 |
292107 | 292107 | 2020-07-01 | Gates | North Carolina | 37073 | 27 | 2 |
292108 | 292108 | 2020-07-01 | Graham | North Carolina | 37075 | 10 | 0 |
292109 | 292109 | 2020-07-01 | Granville | North Carolina | 37077 | 807 | 21 |
292110 | 292110 | 2020-07-01 | Greene | North Carolina | 37079 | 175 | 3 |
292111 | 292111 | 2020-07-01 | Guilford | North Carolina | 37081 | 2891 | 115 |
292112 | 292112 | 2020-07-01 | Halifax | North Carolina | 37083 | 313 | 4 |
292113 | 292113 | 2020-07-01 | Harnett | North Carolina | 37085 | 648 | 30 |
292114 | 292114 | 2020-07-01 | Haywood | North Carolina | 37087 | 90 | 0 |
292115 | 292115 | 2020-07-01 | Henderson | North Carolina | 37089 | 655 | 50 |
292116 | 292116 | 2020-07-01 | Hertford | North Carolina | 37091 | 164 | 10 |
292117 | 292117 | 2020-07-01 | Hoke | North Carolina | 37093 | 383 | 3 |
292118 | 292118 | 2020-07-01 | Hyde | North Carolina | 37095 | 12 | 0 |
292119 | 292119 | 2020-07-01 | Iredell | North Carolina | 37097 | 785 | 7 |
292120 | 292120 | 2020-07-01 | Jackson | North Carolina | 37099 | 117 | 1 |
292121 | 292121 | 2020-07-01 | Johnston | North Carolina | 37101 | 1565 | 32 |
292122 | 292122 | 2020-07-01 | Jones | North Carolina | 37103 | 35 | 3 |
292123 | 292123 | 2020-07-01 | Lee | North Carolina | 37105 | 841 | 8 |
292124 | 292124 | 2020-07-01 | Lenoir | North Carolina | 37107 | 371 | 11 |
292125 | 292125 | 2020-07-01 | Lincoln | North Carolina | 37109 | 258 | 1 |
292126 | 292126 | 2020-07-01 | Macon | North Carolina | 37113 | 282 | 1 |
292127 | 292127 | 2020-07-01 | Madison | North Carolina | 37115 | 14 | 0 |
292128 | 292128 | 2020-07-01 | Martin | North Carolina | 37117 | 135 | 4 |
292129 | 292129 | 2020-07-01 | McDowell | North Carolina | 37111 | 237 | 1 |
292130 | 292130 | 2020-07-01 | Mecklenburg | North Carolina | 37119 | 11534 | 151 |
292131 | 292131 | 2020-07-01 | Mitchell | North Carolina | 37121 | 33 | 0 |
292132 | 292132 | 2020-07-01 | Montgomery | North Carolina | 37123 | 317 | 7 |
292133 | 292133 | 2020-07-01 | Moore | North Carolina | 37125 | 484 | 13 |
292134 | 292134 | 2020-07-01 | Nash | North Carolina | 37127 | 478 | 6 |
292135 | 292135 | 2020-07-01 | New Hanover | North Carolina | 37129 | 923 | 5 |
292136 | 292136 | 2020-07-01 | Northampton | North Carolina | 37131 | 183 | 15 |
292137 | 292137 | 2020-07-01 | Onslow | North Carolina | 37133 | 308 | 3 |
292138 | 292138 | 2020-07-01 | Orange | North Carolina | 37135 | 690 | 41 |
292139 | 292139 | 2020-07-01 | Pamlico | North Carolina | 37137 | 21 | 0 |
292140 | 292140 | 2020-07-01 | Pasquotank | North Carolina | 37139 | 210 | 17 |
292141 | 292141 | 2020-07-01 | Pender | North Carolina | 37141 | 262 | 1 |
292142 | 292142 | 2020-07-01 | Perquimans | North Carolina | 37143 | 36 | 2 |
292143 | 292143 | 2020-07-01 | Person | North Carolina | 37145 | 107 | 1 |
292144 | 292144 | 2020-07-01 | Pitt | North Carolina | 37147 | 709 | 6 |
292145 | 292145 | 2020-07-01 | Polk | North Carolina | 37149 | 73 | 4 |
292146 | 292146 | 2020-07-01 | Randolph | North Carolina | 37151 | 1206 | 30 |
292147 | 292147 | 2020-07-01 | Richmond | North Carolina | 37153 | 290 | 7 |
292148 | 292148 | 2020-07-01 | Robeson | North Carolina | 37155 | 1236 | 39 |
292149 | 292149 | 2020-07-01 | Rockingham | North Carolina | 37157 | 234 | 2 |
292150 | 292150 | 2020-07-01 | Rowan | North Carolina | 37159 | 1235 | 43 |
292151 | 292151 | 2020-07-01 | Rutherford | North Carolina | 37161 | 308 | 9 |
292152 | 292152 | 2020-07-01 | Sampson | North Carolina | 37163 | 1060 | 6 |
292153 | 292153 | 2020-07-01 | Scotland | North Carolina | 37165 | 138 | 2 |
292154 | 292154 | 2020-07-01 | Stanly | North Carolina | 37167 | 394 | 5 |
292155 | 292155 | 2020-07-01 | Stokes | North Carolina | 37169 | 129 | 1 |
292156 | 292156 | 2020-07-01 | Surry | North Carolina | 37171 | 482 | 2 |
292157 | 292157 | 2020-07-01 | Swain | North Carolina | 37173 | 55 | 1 |
292158 | 292158 | 2020-07-01 | Transylvania | North Carolina | 37175 | 22 | 1 |
292159 | 292159 | 2020-07-01 | Tyrrell | North Carolina | 37177 | 11 | 0 |
292160 | 292160 | 2020-07-01 | Union | North Carolina | 37179 | 1279 | 25 |
292161 | 292161 | 2020-07-01 | Vance | North Carolina | 37181 | 506 | 37 |
292162 | 292162 | 2020-07-01 | Wake | North Carolina | 37183 | 5379 | 48 |
292163 | 292163 | 2020-07-01 | Warren | North Carolina | 37185 | 160 | 5 |
292164 | 292164 | 2020-07-01 | Washington | North Carolina | 37187 | 38 | 3 |
292165 | 292165 | 2020-07-01 | Watauga | North Carolina | 37189 | 70 | 0 |
292166 | 292166 | 2020-07-01 | Wayne | North Carolina | 37191 | 1822 | 28 |
292167 | 292167 | 2020-07-01 | Wilkes | North Carolina | 37193 | 578 | 6 |
292168 | 292168 | 2020-07-01 | Wilson | North Carolina | 37195 | 726 | 19 |
292169 | 292169 | 2020-07-01 | Yadkin | North Carolina | 37197 | 334 | 4 |
292170 | 292170 | 2020-07-01 | Yancey | North Carolina | 37199 | 43 | 0 |
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);