ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
24 rows where county = "Caldwell", deaths = 4 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
317405 | 317405 | 2020-07-09 | Caldwell | North Carolina | 37027 | 563 | 4 |
314231 | 314231 | 2020-07-08 | Caldwell | North Carolina | 37027 | 546 | 4 |
311060 | 311060 | 2020-07-07 | Caldwell | North Carolina | 37027 | 534 | 4 |
307892 | 307892 | 2020-07-06 | Caldwell | North Carolina | 37027 | 522 | 4 |
304725 | 304725 | 2020-07-05 | Caldwell | North Carolina | 37027 | 504 | 4 |
301562 | 301562 | 2020-07-04 | Caldwell | North Carolina | 37027 | 486 | 4 |
298399 | 298399 | 2020-07-03 | Caldwell | North Carolina | 37027 | 469 | 4 |
295239 | 295239 | 2020-07-02 | Caldwell | North Carolina | 37027 | 452 | 4 |
292084 | 292084 | 2020-07-01 | Caldwell | North Carolina | 37027 | 434 | 4 |
288932 | 288932 | 2020-06-30 | Caldwell | North Carolina | 37027 | 419 | 4 |
285782 | 285782 | 2020-06-29 | Caldwell | North Carolina | 37027 | 411 | 4 |
282637 | 282637 | 2020-06-28 | Caldwell | North Carolina | 37027 | 398 | 4 |
279491 | 279491 | 2020-06-27 | Caldwell | North Carolina | 37027 | 358 | 4 |
276343 | 276343 | 2020-06-26 | Caldwell | North Carolina | 37027 | 348 | 4 |
273197 | 273197 | 2020-06-25 | Caldwell | North Carolina | 37027 | 335 | 4 |
270058 | 270058 | 2020-06-24 | Caldwell | North Carolina | 37027 | 328 | 4 |
266924 | 266924 | 2020-06-23 | Caldwell | North Carolina | 37027 | 322 | 4 |
263796 | 263796 | 2020-06-22 | Caldwell | North Carolina | 37027 | 315 | 4 |
260668 | 260668 | 2020-06-21 | Caldwell | North Carolina | 37027 | 314 | 4 |
257541 | 257541 | 2020-06-20 | Caldwell | North Carolina | 37027 | 304 | 4 |
254418 | 254418 | 2020-06-19 | Caldwell | North Carolina | 37027 | 296 | 4 |
251303 | 251303 | 2020-06-18 | Caldwell | North Carolina | 37027 | 273 | 4 |
248188 | 248188 | 2020-06-17 | Caldwell | North Carolina | 37027 | 258 | 4 |
245075 | 245075 | 2020-06-16 | Caldwell | North Carolina | 37027 | 252 | 4 |
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);