ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
26 rows where county = "Natchitoches", deaths = 26 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
649023 | 649023 | 2020-10-20 | Natchitoches | Louisiana | 22069 | 1409 | 26 |
645779 | 645779 | 2020-10-19 | Natchitoches | Louisiana | 22069 | 1381 | 26 |
642532 | 642532 | 2020-10-18 | Natchitoches | Louisiana | 22069 | 1377 | 26 |
639285 | 639285 | 2020-10-17 | Natchitoches | Louisiana | 22069 | 1353 | 26 |
636039 | 636039 | 2020-10-16 | Natchitoches | Louisiana | 22069 | 1353 | 26 |
632793 | 632793 | 2020-10-15 | Natchitoches | Louisiana | 22069 | 1325 | 26 |
629549 | 629549 | 2020-10-14 | Natchitoches | Louisiana | 22069 | 1306 | 26 |
626305 | 626305 | 2020-10-13 | Natchitoches | Louisiana | 22069 | 1299 | 26 |
623063 | 623063 | 2020-10-12 | Natchitoches | Louisiana | 22069 | 1273 | 26 |
619819 | 619819 | 2020-10-11 | Natchitoches | Louisiana | 22069 | 1278 | 26 |
616577 | 616577 | 2020-10-10 | Natchitoches | Louisiana | 22069 | 1255 | 26 |
613336 | 613336 | 2020-10-09 | Natchitoches | Louisiana | 22069 | 1255 | 26 |
610094 | 610094 | 2020-10-08 | Natchitoches | Louisiana | 22069 | 1250 | 26 |
606852 | 606852 | 2020-10-07 | Natchitoches | Louisiana | 22069 | 1244 | 26 |
603610 | 603610 | 2020-10-06 | Natchitoches | Louisiana | 22069 | 1233 | 26 |
600367 | 600367 | 2020-10-05 | Natchitoches | Louisiana | 22069 | 1226 | 26 |
597125 | 597125 | 2020-10-04 | Natchitoches | Louisiana | 22069 | 1225 | 26 |
593883 | 593883 | 2020-10-03 | Natchitoches | Louisiana | 22069 | 1200 | 26 |
590642 | 590642 | 2020-10-02 | Natchitoches | Louisiana | 22069 | 1200 | 26 |
587401 | 587401 | 2020-10-01 | Natchitoches | Louisiana | 22069 | 1185 | 26 |
584161 | 584161 | 2020-09-30 | Natchitoches | Louisiana | 22069 | 1176 | 26 |
580921 | 580921 | 2020-09-29 | Natchitoches | Louisiana | 22069 | 1166 | 26 |
577680 | 577680 | 2020-09-28 | Natchitoches | Louisiana | 22069 | 1144 | 26 |
574438 | 574438 | 2020-09-27 | Natchitoches | Louisiana | 22069 | 1141 | 26 |
571195 | 571195 | 2020-09-26 | Natchitoches | Louisiana | 22069 | 1129 | 26 |
567953 | 567953 | 2020-09-25 | Natchitoches | Louisiana | 22069 | 1129 | 26 |
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);