ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
18 rows where county = "Union", deaths = 39 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
516180 | 516180 | 2020-09-09 | Union | Louisiana | 22111 | 891 | 39 |
512947 | 512947 | 2020-09-08 | Union | Louisiana | 22111 | 863 | 39 |
509715 | 509715 | 2020-09-07 | Union | Louisiana | 22111 | 858 | 39 |
506482 | 506482 | 2020-09-06 | Union | Louisiana | 22111 | 855 | 39 |
503248 | 503248 | 2020-09-05 | Union | Louisiana | 22111 | 855 | 39 |
500015 | 500015 | 2020-09-04 | Union | Louisiana | 22111 | 855 | 39 |
496781 | 496781 | 2020-09-03 | Union | Louisiana | 22111 | 852 | 39 |
493548 | 493548 | 2020-09-02 | Union | Louisiana | 22111 | 845 | 39 |
490314 | 490314 | 2020-09-01 | Union | Louisiana | 22111 | 829 | 39 |
487081 | 487081 | 2020-08-31 | Union | Louisiana | 22111 | 825 | 39 |
483846 | 483846 | 2020-08-30 | Union | Louisiana | 22111 | 823 | 39 |
480612 | 480612 | 2020-08-29 | Union | Louisiana | 22111 | 818 | 39 |
477379 | 477379 | 2020-08-28 | Union | Louisiana | 22111 | 818 | 39 |
474146 | 474146 | 2020-08-27 | Union | Louisiana | 22111 | 807 | 39 |
470914 | 470914 | 2020-08-26 | Union | Louisiana | 22111 | 806 | 39 |
467685 | 467685 | 2020-08-25 | Union | Louisiana | 22111 | 796 | 39 |
464456 | 464456 | 2020-08-24 | Union | Louisiana | 22111 | 788 | 39 |
461225 | 461225 | 2020-08-23 | Union | Louisiana | 22111 | 783 | 39 |
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);