ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
60 rows where date = "2020-03-27" and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
fips >30
county >30
- Alamance 1
- Beaufort 1
- Bertie 1
- Brunswick 1
- Buncombe 1
- Burke 1
- Cabarrus 1
- Caldwell 1
- Carteret 1
- Catawba 1
- Chatham 1
- Cherokee 1
- Cleveland 1
- Craven 1
- Cumberland 1
- Davidson 1
- Davie 1
- Duplin 1
- Durham 1
- Forsyth 1
- Franklin 1
- Gaston 1
- Granville 1
- Greene 1
- Guilford 1
- Harnett 1
- Henderson 1
- Hertford 1
- Hoke 1
- Iredell 1
- …
state 1
- North Carolina · 60 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
15123 | 15123 | 2020-03-27 | Alamance | North Carolina | 37001 | 5 | 0 |
15124 | 15124 | 2020-03-27 | Beaufort | North Carolina | 37013 | 3 | 0 |
15125 | 15125 | 2020-03-27 | Bertie | North Carolina | 37015 | 3 | 0 |
15126 | 15126 | 2020-03-27 | Brunswick | North Carolina | 37019 | 11 | 0 |
15127 | 15127 | 2020-03-27 | Buncombe | North Carolina | 37021 | 15 | 0 |
15128 | 15128 | 2020-03-27 | Burke | North Carolina | 37023 | 2 | 0 |
15129 | 15129 | 2020-03-27 | Cabarrus | North Carolina | 37025 | 21 | 1 |
15130 | 15130 | 2020-03-27 | Caldwell | North Carolina | 37027 | 3 | 0 |
15131 | 15131 | 2020-03-27 | Carteret | North Carolina | 37031 | 5 | 0 |
15132 | 15132 | 2020-03-27 | Catawba | North Carolina | 37035 | 7 | 0 |
15133 | 15133 | 2020-03-27 | Chatham | North Carolina | 37037 | 11 | 0 |
15134 | 15134 | 2020-03-27 | Cherokee | North Carolina | 37039 | 4 | 0 |
15135 | 15135 | 2020-03-27 | Cleveland | North Carolina | 37045 | 2 | 0 |
15136 | 15136 | 2020-03-27 | Craven | North Carolina | 37049 | 3 | 0 |
15137 | 15137 | 2020-03-27 | Cumberland | North Carolina | 37051 | 8 | 0 |
15138 | 15138 | 2020-03-27 | Davidson | North Carolina | 37057 | 4 | 0 |
15139 | 15139 | 2020-03-27 | Davie | North Carolina | 37059 | 2 | 0 |
15140 | 15140 | 2020-03-27 | Duplin | North Carolina | 37061 | 1 | 0 |
15141 | 15141 | 2020-03-27 | Durham | North Carolina | 37063 | 83 | 0 |
15142 | 15142 | 2020-03-27 | Forsyth | North Carolina | 37067 | 17 | 0 |
15143 | 15143 | 2020-03-27 | Franklin | North Carolina | 37069 | 5 | 0 |
15144 | 15144 | 2020-03-27 | Gaston | North Carolina | 37071 | 9 | 0 |
15145 | 15145 | 2020-03-27 | Granville | North Carolina | 37077 | 3 | 0 |
15146 | 15146 | 2020-03-27 | Greene | North Carolina | 37079 | 3 | 0 |
15147 | 15147 | 2020-03-27 | Guilford | North Carolina | 37081 | 31 | 0 |
15148 | 15148 | 2020-03-27 | Harnett | North Carolina | 37085 | 11 | 1 |
15149 | 15149 | 2020-03-27 | Henderson | North Carolina | 37089 | 6 | 0 |
15150 | 15150 | 2020-03-27 | Hertford | North Carolina | 37091 | 2 | 0 |
15151 | 15151 | 2020-03-27 | Hoke | North Carolina | 37093 | 2 | 0 |
15152 | 15152 | 2020-03-27 | Iredell | North Carolina | 37097 | 15 | 0 |
15153 | 15153 | 2020-03-27 | Johnston | North Carolina | 37101 | 9 | 1 |
15154 | 15154 | 2020-03-27 | Lee | North Carolina | 37105 | 2 | 0 |
15155 | 15155 | 2020-03-27 | Lenoir | North Carolina | 37107 | 3 | 0 |
15156 | 15156 | 2020-03-27 | Lincoln | North Carolina | 37109 | 1 | 0 |
15157 | 15157 | 2020-03-27 | McDowell | North Carolina | 37111 | 3 | 0 |
15158 | 15158 | 2020-03-27 | Mecklenburg | North Carolina | 37119 | 218 | 0 |
15159 | 15159 | 2020-03-27 | Montgomery | North Carolina | 37123 | 3 | 0 |
15160 | 15160 | 2020-03-27 | Moore | North Carolina | 37125 | 2 | 0 |
15161 | 15161 | 2020-03-27 | Nash | North Carolina | 37127 | 2 | 0 |
15162 | 15162 | 2020-03-27 | New Hanover | North Carolina | 37129 | 13 | 0 |
15163 | 15163 | 2020-03-27 | Northampton | North Carolina | 37131 | 3 | 0 |
15164 | 15164 | 2020-03-27 | Onslow | North Carolina | 37133 | 4 | 0 |
15165 | 15165 | 2020-03-27 | Orange | North Carolina | 37135 | 24 | 0 |
15166 | 15166 | 2020-03-27 | Pasquotank | North Carolina | 37139 | 1 | 0 |
15167 | 15167 | 2020-03-27 | Person | North Carolina | 37145 | 1 | 0 |
15168 | 15168 | 2020-03-27 | Pitt | North Carolina | 37147 | 10 | 0 |
15169 | 15169 | 2020-03-27 | Randolph | North Carolina | 37151 | 5 | 0 |
15170 | 15170 | 2020-03-27 | Robeson | North Carolina | 37155 | 2 | 0 |
15171 | 15171 | 2020-03-27 | Rowan | North Carolina | 37159 | 10 | 0 |
15172 | 15172 | 2020-03-27 | Sampson | North Carolina | 37163 | 1 | 0 |
15173 | 15173 | 2020-03-27 | Scotland | North Carolina | 37165 | 1 | 0 |
15174 | 15174 | 2020-03-27 | Stanly | North Carolina | 37167 | 2 | 0 |
15175 | 15175 | 2020-03-27 | Surry | North Carolina | 37171 | 1 | 0 |
15176 | 15176 | 2020-03-27 | Transylvania | North Carolina | 37175 | 2 | 0 |
15177 | 15177 | 2020-03-27 | Union | North Carolina | 37179 | 27 | 0 |
15178 | 15178 | 2020-03-27 | Vance | North Carolina | 37181 | 2 | 0 |
15179 | 15179 | 2020-03-27 | Wake | North Carolina | 37183 | 121 | 0 |
15180 | 15180 | 2020-03-27 | Watauga | North Carolina | 37189 | 4 | 0 |
15181 | 15181 | 2020-03-27 | Wayne | North Carolina | 37191 | 3 | 0 |
15182 | 15182 | 2020-03-27 | Wilson | North Carolina | 37195 | 7 | 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);