latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
17 rows where county = "Fresno" and deaths = 7 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: new_confirmed_cases, new_deaths, date (date)
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
28430 | 28430 | 2020-04-30 | Fresno | 19 | 1091 | 7 | 49 | 0 |
28488 | 28488 | 2020-04-29 | Fresno | 19 | 1042 | 7 | 49 | 0 |
28546 | 28546 | 2020-04-28 | Fresno | 19 | 993 | 7 | 103 | 0 |
28600 | 28600 | 2020-04-27 | Fresno | 19 | 890 | 7 | 89 | 0 |
28653 | 28653 | 2020-04-26 | Fresno | 19 | 801 | 7 | 30 | 0 |
28706 | 28706 | 2020-04-25 | Fresno | 19 | 771 | 7 | 19 | 0 |
28759 | 28759 | 2020-04-24 | Fresno | 19 | 752 | 7 | 35 | 0 |
28812 | 28812 | 2020-04-23 | Fresno | 19 | 717 | 7 | 34 | 0 |
28865 | 28865 | 2020-04-22 | Fresno | 19 | 683 | 7 | 34 | 0 |
28918 | 28918 | 2020-04-21 | Fresno | 19 | 649 | 7 | 18 | 0 |
28971 | 28971 | 2020-04-20 | Fresno | 19 | 631 | 7 | 36 | 0 |
29024 | 29024 | 2020-04-19 | Fresno | 19 | 595 | 7 | 20 | 0 |
29077 | 29077 | 2020-04-18 | Fresno | 19 | 575 | 7 | 22 | 0 |
29130 | 29130 | 2020-04-17 | Fresno | 19 | 553 | 7 | 28 | 0 |
29183 | 29183 | 2020-04-16 | Fresno | 19 | 525 | 7 | 24 | 0 |
29236 | 29236 | 2020-04-15 | Fresno | 19 | 501 | 7 | 22 | 0 |
29289 | 29289 | 2020-04-14 | Fresno | 19 | 479 | 7 | 22 | 2 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_county_totals] ( [date] TEXT, [county] TEXT, [fips] INTEGER, [confirmed_cases] INTEGER, [deaths] INTEGER, [new_confirmed_cases] INTEGER, [new_deaths] INTEGER );