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-05-20 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 |
---|---|---|---|---|---|---|---|
162041 | 162041 | 2020-05-20 | Alamance | North Carolina | 37001 | 229 | 12 |
162042 | 162042 | 2020-05-20 | Alexander | North Carolina | 37003 | 23 | 0 |
162043 | 162043 | 2020-05-20 | Alleghany | North Carolina | 37005 | 12 | 0 |
162044 | 162044 | 2020-05-20 | Anson | North Carolina | 37007 | 50 | 0 |
162045 | 162045 | 2020-05-20 | Ashe | North Carolina | 37009 | 28 | 0 |
162046 | 162046 | 2020-05-20 | Avery | North Carolina | 37011 | 1 | 0 |
162047 | 162047 | 2020-05-20 | Beaufort | North Carolina | 37013 | 30 | 0 |
162048 | 162048 | 2020-05-20 | Bertie | North Carolina | 37015 | 98 | 3 |
162049 | 162049 | 2020-05-20 | Bladen | North Carolina | 37017 | 81 | 2 |
162050 | 162050 | 2020-05-20 | Brunswick | North Carolina | 37019 | 74 | 4 |
162051 | 162051 | 2020-05-20 | Buncombe | North Carolina | 37021 | 183 | 7 |
162052 | 162052 | 2020-05-20 | Burke | North Carolina | 37023 | 210 | 14 |
162053 | 162053 | 2020-05-20 | Cabarrus | North Carolina | 37025 | 395 | 21 |
162054 | 162054 | 2020-05-20 | Caldwell | North Carolina | 37027 | 90 | 2 |
162055 | 162055 | 2020-05-20 | Camden | North Carolina | 37029 | 3 | 0 |
162056 | 162056 | 2020-05-20 | Carteret | North Carolina | 37031 | 35 | 3 |
162057 | 162057 | 2020-05-20 | Caswell | North Carolina | 37033 | 45 | 1 |
162058 | 162058 | 2020-05-20 | Catawba | North Carolina | 37035 | 118 | 3 |
162059 | 162059 | 2020-05-20 | Chatham | North Carolina | 37037 | 543 | 25 |
162060 | 162060 | 2020-05-20 | Cherokee | North Carolina | 37039 | 20 | 1 |
162061 | 162061 | 2020-05-20 | Chowan | North Carolina | 37041 | 14 | 0 |
162062 | 162062 | 2020-05-20 | Clay | North Carolina | 37043 | 5 | 0 |
162063 | 162063 | 2020-05-20 | Cleveland | North Carolina | 37045 | 60 | 2 |
162064 | 162064 | 2020-05-20 | Columbus | North Carolina | 37047 | 253 | 21 |
162065 | 162065 | 2020-05-20 | Craven | North Carolina | 37049 | 135 | 4 |
162066 | 162066 | 2020-05-20 | Cumberland | North Carolina | 37051 | 505 | 13 |
162067 | 162067 | 2020-05-20 | Currituck | North Carolina | 37053 | 11 | 0 |
162068 | 162068 | 2020-05-20 | Dare | North Carolina | 37055 | 18 | 1 |
162069 | 162069 | 2020-05-20 | Davidson | North Carolina | 37057 | 314 | 11 |
162070 | 162070 | 2020-05-20 | Davie | North Carolina | 37059 | 55 | 2 |
162071 | 162071 | 2020-05-20 | Duplin | North Carolina | 37061 | 470 | 12 |
162072 | 162072 | 2020-05-20 | Durham | North Carolina | 37063 | 1131 | 43 |
162073 | 162073 | 2020-05-20 | Edgecombe | North Carolina | 37065 | 174 | 8 |
162074 | 162074 | 2020-05-20 | Forsyth | North Carolina | 37067 | 749 | 7 |
162075 | 162075 | 2020-05-20 | Franklin | North Carolina | 37069 | 131 | 20 |
162076 | 162076 | 2020-05-20 | Gaston | North Carolina | 37071 | 210 | 6 |
162077 | 162077 | 2020-05-20 | Gates | North Carolina | 37073 | 14 | 0 |
162078 | 162078 | 2020-05-20 | Graham | North Carolina | 37075 | 2 | 0 |
162079 | 162079 | 2020-05-20 | Granville | North Carolina | 37077 | 208 | 6 |
162080 | 162080 | 2020-05-20 | Greene | North Carolina | 37079 | 50 | 2 |
162081 | 162081 | 2020-05-20 | Guilford | North Carolina | 37081 | 931 | 49 |
162082 | 162082 | 2020-05-20 | Halifax | North Carolina | 37083 | 125 | 1 |
162083 | 162083 | 2020-05-20 | Harnett | North Carolina | 37085 | 255 | 20 |
162084 | 162084 | 2020-05-20 | Haywood | North Carolina | 37087 | 26 | 0 |
162085 | 162085 | 2020-05-20 | Henderson | North Carolina | 37089 | 298 | 41 |
162086 | 162086 | 2020-05-20 | Hertford | North Carolina | 37091 | 60 | 1 |
162087 | 162087 | 2020-05-20 | Hoke | North Carolina | 37093 | 166 | 0 |
162088 | 162088 | 2020-05-20 | Hyde | North Carolina | 37095 | 1 | 0 |
162089 | 162089 | 2020-05-20 | Iredell | North Carolina | 37097 | 202 | 5 |
162090 | 162090 | 2020-05-20 | Jackson | North Carolina | 37099 | 24 | 1 |
162091 | 162091 | 2020-05-20 | Johnston | North Carolina | 37101 | 276 | 19 |
162092 | 162092 | 2020-05-20 | Jones | North Carolina | 37103 | 22 | 2 |
162093 | 162093 | 2020-05-20 | Lee | North Carolina | 37105 | 341 | 3 |
162094 | 162094 | 2020-05-20 | Lenoir | North Carolina | 37107 | 164 | 7 |
162095 | 162095 | 2020-05-20 | Lincoln | North Carolina | 37109 | 52 | 0 |
162096 | 162096 | 2020-05-20 | Macon | North Carolina | 37113 | 5 | 1 |
162097 | 162097 | 2020-05-20 | Madison | North Carolina | 37115 | 2 | 0 |
162098 | 162098 | 2020-05-20 | Martin | North Carolina | 37117 | 39 | 4 |
162099 | 162099 | 2020-05-20 | McDowell | North Carolina | 37111 | 33 | 1 |
162100 | 162100 | 2020-05-20 | Mecklenburg | North Carolina | 37119 | 2780 | 69 |
162101 | 162101 | 2020-05-20 | Mitchell | North Carolina | 37121 | 8 | 0 |
162102 | 162102 | 2020-05-20 | Montgomery | North Carolina | 37123 | 68 | 3 |
162103 | 162103 | 2020-05-20 | Moore | North Carolina | 37125 | 119 | 10 |
162104 | 162104 | 2020-05-20 | Nash | North Carolina | 37127 | 158 | 3 |
162105 | 162105 | 2020-05-20 | New Hanover | North Carolina | 37129 | 137 | 3 |
162106 | 162106 | 2020-05-20 | Northampton | North Carolina | 37131 | 131 | 11 |
162107 | 162107 | 2020-05-20 | Onslow | North Carolina | 37133 | 79 | 2 |
162108 | 162108 | 2020-05-20 | Orange | North Carolina | 37135 | 289 | 37 |
162109 | 162109 | 2020-05-20 | Pamlico | North Carolina | 37137 | 9 | 0 |
162110 | 162110 | 2020-05-20 | Pasquotank | North Carolina | 37139 | 90 | 7 |
162111 | 162111 | 2020-05-20 | Pender | North Carolina | 37141 | 50 | 1 |
162112 | 162112 | 2020-05-20 | Perquimans | North Carolina | 37143 | 22 | 2 |
162113 | 162113 | 2020-05-20 | Person | North Carolina | 37145 | 34 | 1 |
162114 | 162114 | 2020-05-20 | Pitt | North Carolina | 37147 | 228 | 2 |
162115 | 162115 | 2020-05-20 | Polk | North Carolina | 37149 | 35 | 3 |
162116 | 162116 | 2020-05-20 | Randolph | North Carolina | 37151 | 486 | 6 |
162117 | 162117 | 2020-05-20 | Richmond | North Carolina | 37153 | 121 | 2 |
162118 | 162118 | 2020-05-20 | Robeson | North Carolina | 37155 | 600 | 12 |
162119 | 162119 | 2020-05-20 | Rockingham | North Carolina | 37157 | 49 | 2 |
162120 | 162120 | 2020-05-20 | Rowan | North Carolina | 37159 | 570 | 27 |
162121 | 162121 | 2020-05-20 | Rutherford | North Carolina | 37161 | 156 | 7 |
162122 | 162122 | 2020-05-20 | Sampson | North Carolina | 37163 | 273 | 1 |
162123 | 162123 | 2020-05-20 | Scotland | North Carolina | 37165 | 56 | 0 |
162124 | 162124 | 2020-05-20 | Stanly | North Carolina | 37167 | 33 | 4 |
162125 | 162125 | 2020-05-20 | Stokes | North Carolina | 37169 | 39 | 0 |
162126 | 162126 | 2020-05-20 | Surry | North Carolina | 37171 | 102 | 1 |
162127 | 162127 | 2020-05-20 | Swain | North Carolina | 37173 | 6 | 0 |
162128 | 162128 | 2020-05-20 | Transylvania | North Carolina | 37175 | 8 | 0 |
162129 | 162129 | 2020-05-20 | Tyrrell | North Carolina | 37177 | 4 | 0 |
162130 | 162130 | 2020-05-20 | Union | North Carolina | 37179 | 371 | 17 |
162131 | 162131 | 2020-05-20 | Vance | North Carolina | 37181 | 202 | 17 |
162132 | 162132 | 2020-05-20 | Wake | North Carolina | 37183 | 1307 | 30 |
162133 | 162133 | 2020-05-20 | Warren | North Carolina | 37185 | 36 | 0 |
162134 | 162134 | 2020-05-20 | Washington | North Carolina | 37187 | 26 | 3 |
162135 | 162135 | 2020-05-20 | Watauga | North Carolina | 37189 | 12 | 0 |
162136 | 162136 | 2020-05-20 | Wayne | North Carolina | 37191 | 888 | 16 |
162137 | 162137 | 2020-05-20 | Wilkes | North Carolina | 37193 | 451 | 1 |
162138 | 162138 | 2020-05-20 | Wilson | North Carolina | 37195 | 256 | 9 |
162139 | 162139 | 2020-05-20 | Yadkin | North Carolina | 37197 | 123 | 1 |
162140 | 162140 | 2020-05-20 | Yancey | North Carolina | 37199 | 10 | 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);