ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
25 rows where county = "Northampton" and deaths = 15 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
state 2
- North Carolina 24
- Virginia 1
county 1
- Northampton · 25 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
317457 | 317457 | 2020-07-09 | Northampton | North Carolina | 37131 | 189 | 15 |
314283 | 314283 | 2020-07-08 | Northampton | North Carolina | 37131 | 189 | 15 |
311112 | 311112 | 2020-07-07 | Northampton | North Carolina | 37131 | 189 | 15 |
307944 | 307944 | 2020-07-06 | Northampton | North Carolina | 37131 | 191 | 15 |
304777 | 304777 | 2020-07-05 | Northampton | North Carolina | 37131 | 190 | 15 |
301614 | 301614 | 2020-07-04 | Northampton | North Carolina | 37131 | 188 | 15 |
298451 | 298451 | 2020-07-03 | Northampton | North Carolina | 37131 | 186 | 15 |
295291 | 295291 | 2020-07-02 | Northampton | North Carolina | 37131 | 185 | 15 |
292136 | 292136 | 2020-07-01 | Northampton | North Carolina | 37131 | 183 | 15 |
288984 | 288984 | 2020-06-30 | Northampton | North Carolina | 37131 | 181 | 15 |
285834 | 285834 | 2020-06-29 | Northampton | North Carolina | 37131 | 180 | 15 |
282689 | 282689 | 2020-06-28 | Northampton | North Carolina | 37131 | 180 | 15 |
279543 | 279543 | 2020-06-27 | Northampton | North Carolina | 37131 | 179 | 15 |
276395 | 276395 | 2020-06-26 | Northampton | North Carolina | 37131 | 179 | 15 |
273249 | 273249 | 2020-06-25 | Northampton | North Carolina | 37131 | 177 | 15 |
270110 | 270110 | 2020-06-24 | Northampton | North Carolina | 37131 | 178 | 15 |
266976 | 266976 | 2020-06-23 | Northampton | North Carolina | 37131 | 177 | 15 |
263848 | 263848 | 2020-06-22 | Northampton | North Carolina | 37131 | 175 | 15 |
260720 | 260720 | 2020-06-21 | Northampton | North Carolina | 37131 | 175 | 15 |
257593 | 257593 | 2020-06-20 | Northampton | North Carolina | 37131 | 173 | 15 |
254470 | 254470 | 2020-06-19 | Northampton | North Carolina | 37131 | 176 | 15 |
251355 | 251355 | 2020-06-18 | Northampton | North Carolina | 37131 | 174 | 15 |
248240 | 248240 | 2020-06-17 | Northampton | North Carolina | 37131 | 171 | 15 |
245127 | 245127 | 2020-06-16 | Northampton | North Carolina | 37131 | 171 | 15 |
163072 | 163072 | 2020-05-20 | Northampton | Virginia | 51131 | 205 | 15 |
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);