ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
19 rows where county = "Fulton" and deaths = 19 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 1
- Fulton · 19 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1685703 | 1685703 | 2021-09-04 | Fulton | Pennsylvania | 42057 | 1560 | 19 |
1682452 | 1682452 | 2021-09-03 | Fulton | Pennsylvania | 42057 | 1543 | 19 |
1679202 | 1679202 | 2021-09-02 | Fulton | Pennsylvania | 42057 | 1529 | 19 |
839441 | 839441 | 2020-12-18 | Fulton | Arkansas | 5049 | 740 | 19 |
817212 | 817212 | 2020-12-11 | Fulton | Illinois | 17057 | 1826 | 19 |
813966 | 813966 | 2020-12-10 | Fulton | Illinois | 17057 | 1805 | 19 |
794594 | 794594 | 2020-12-04 | Fulton | Indiana | 18049 | 994 | 19 |
791349 | 791349 | 2020-12-03 | Fulton | Indiana | 18049 | 966 | 19 |
788104 | 788104 | 2020-12-02 | Fulton | Indiana | 18049 | 944 | 19 |
784860 | 784860 | 2020-12-01 | Fulton | Indiana | 18049 | 922 | 19 |
781615 | 781615 | 2020-11-30 | Fulton | Indiana | 18049 | 903 | 19 |
778369 | 778369 | 2020-11-29 | Fulton | Indiana | 18049 | 888 | 19 |
775124 | 775124 | 2020-11-28 | Fulton | Indiana | 18049 | 880 | 19 |
771879 | 771879 | 2020-11-27 | Fulton | Indiana | 18049 | 877 | 19 |
768634 | 768634 | 2020-11-26 | Fulton | Indiana | 18049 | 866 | 19 |
737533 | 737533 | 2020-11-16 | Fulton | Ohio | 39051 | 1012 | 19 |
365278 | 365278 | 2020-07-24 | Fulton | New York | 36035 | 268 | 19 |
362072 | 362072 | 2020-07-23 | Fulton | New York | 36035 | 268 | 19 |
358866 | 358866 | 2020-07-22 | Fulton | New York | 36035 | 267 | 19 |
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);