latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
53 rows where "date" is on date 2020-04-05 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, new_deaths, date (date)
fips >30
county >30
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
29757 | 29757 | 2020-04-05 | Alameda | 1 | 611 | 50 | 30 | 2 |
29758 | 29758 | 2020-04-05 | Alpine | 3 | 1 | 0 | 0 | 0 |
29759 | 29759 | 2020-04-05 | Amador | 5 | 3 | 0 | 0 | 0 |
29760 | 29760 | 2020-04-05 | Butte | 7 | 10 | 0 | 0 | 0 |
29761 | 29761 | 2020-04-05 | Calaveras | 9 | 4 | 0 | 0 | 0 |
29762 | 29762 | 2020-04-05 | Colusa | 11 | 2 | 0 | 0 | 0 |
29763 | 29763 | 2020-04-05 | Contra Costa | 13 | 409 | 6 | 33 | 1 |
29764 | 29764 | 2020-04-05 | Del Norte | 15 | 2 | 0 | 0 | 0 |
29765 | 29765 | 2020-04-05 | El Dorado | 17 | 22 | 0 | 0 | 0 |
29766 | 29766 | 2020-04-05 | Fresno | 19 | 306 | 1 | 9 | 0 |
29767 | 29767 | 2020-04-05 | Glenn | 21 | 2 | 0 | 0 | 0 |
29768 | 29768 | 2020-04-05 | Humboldt | 23 | 44 | 0 | 0 | 0 |
29769 | 29769 | 2020-04-05 | Imperial | 25 | 65 | 2 | 10 | 1 |
29770 | 29770 | 2020-04-05 | Inyo | 27 | 11 | 0 | 1 | 0 |
29771 | 29771 | 2020-04-05 | Kern | 29 | 225 | 2 | 20 | 0 |
29772 | 29772 | 2020-04-05 | Kings | 31 | 5 | 0 | 0 | 0 |
29773 | 29773 | 2020-04-05 | Lake | 33 | 1 | 0 | ||
29774 | 29774 | 2020-04-05 | Los Angeles | 37 | 5955 | 132 | 630 | 13 |
29775 | 29775 | 2020-04-05 | Madera | 39 | 28 | 1 | 0 | 0 |
29776 | 29776 | 2020-04-05 | Marin | 41 | 141 | 7 | 4 | 0 |
29777 | 29777 | 2020-04-05 | Mendocino | 45 | 4 | 0 | 0 | 0 |
29778 | 29778 | 2020-04-05 | Merced | 47 | 29 | 1 | 2 | 1 |
29779 | 29779 | 2020-04-05 | Mono | 51 | 19 | 1 | 0 | 0 |
29780 | 29780 | 2020-04-05 | Monterey | 53 | 62 | 2 | 0 | 0 |
29781 | 29781 | 2020-04-05 | Napa | 55 | 20 | 2 | 0 | 0 |
29782 | 29782 | 2020-04-05 | Nevada | 57 | 31 | 1 | 0 | 0 |
29783 | 29783 | 2020-04-05 | Orange | 59 | 820 | 14 | 47 | 0 |
29784 | 29784 | 2020-04-05 | Placer | 61 | 103 | 3 | 2 | 1 |
29785 | 29785 | 2020-04-05 | Plumas | 63 | 3 | 0 | 0 | 0 |
29786 | 29786 | 2020-04-05 | Riverside | 65 | 799 | 19 | 134 | 1 |
29787 | 29787 | 2020-04-05 | Sacramento | 67 | 442 | 16 | 52 | 6 |
29788 | 29788 | 2020-04-05 | San Benito | 69 | 23 | 2 | 0 | 0 |
29789 | 29789 | 2020-04-05 | San Bernardino | 71 | 373 | 19 | 1 | 4 |
29790 | 29790 | 2020-04-05 | San Diego | 73 | 1326 | 19 | 117 | 1 |
29791 | 29791 | 2020-04-05 | San Francisco | 75 | 568 | 8 | 39 | 0 |
29792 | 29792 | 2020-04-05 | San Joaquin | 77 | 196 | 11 | 10 | 0 |
29793 | 29793 | 2020-04-05 | San Luis Obispo | 79 | 95 | 1 | 2 | 1 |
29794 | 29794 | 2020-04-05 | San Mateo | 81 | 555 | 13 | 17 | 0 |
29795 | 29795 | 2020-04-05 | Santa Barbara | 83 | 174 | 2 | 6 | 1 |
29796 | 29796 | 2020-04-05 | Santa Clara | 85 | 1369 | 47 | 43 | 2 |
29797 | 29797 | 2020-04-05 | Santa Cruz | 87 | 69 | 1 | 7 | 0 |
29798 | 29798 | 2020-04-05 | Shasta | 89 | 20 | 3 | 3 | 1 |
29799 | 29799 | 2020-04-05 | Siskiyou | 93 | 3 | 0 | 0 | 0 |
29800 | 29800 | 2020-04-05 | Solano | 95 | 73 | 1 | 0 | 0 |
29801 | 29801 | 2020-04-05 | Sonoma | 97 | 107 | 1 | 0 | 0 |
29802 | 29802 | 2020-04-05 | Stanislaus | 99 | 71 | 0 | 6 | 0 |
29803 | 29803 | 2020-04-05 | Sutter | 101 | 16 | 2 | 0 | 1 |
29804 | 29804 | 2020-04-05 | Tehama | 103 | 1 | 0 | 0 | 0 |
29805 | 29805 | 2020-04-05 | Tulare | 107 | 116 | 5 | 9 | 0 |
29806 | 29806 | 2020-04-05 | Tuolumne | 109 | 1 | 0 | 0 | 0 |
29807 | 29807 | 2020-04-05 | Ventura | 111 | 221 | 6 | 18 | 0 |
29808 | 29808 | 2020-04-05 | Yolo | 113 | 37 | 1 | 0 | 0 |
29809 | 29809 | 2020-04-05 | Yuba | 115 | 10 | 0 | 1 | 0 |
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 );