latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
61 rows where "date" is on date 2020-05-02 sorted by did_not_update
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, did_not_update
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date | confirmed_cases | deaths | did_not_update ▼ |
---|---|---|---|---|---|---|---|---|
29769 | 29769 | Alameda | Alameda | 1 | 2020-05-02 | 1668 | 97 | |
29772 | 29772 | Amador | Amador | 5 | 2020-05-02 | 8 | 0 | |
29776 | 29776 | Contra Costa | Contra Costa | 13 | 2020-05-02 | 923 | 28 | |
29779 | 29779 | Fresno | Fresno | 19 | 2020-05-02 | 1180 | 8 | |
29781 | 29781 | Humboldt | Humboldt | 23 | 2020-05-02 | 54 | 0 | |
29784 | 29784 | Kern | Kern | 29 | 2020-05-02 | 969 | 8 | |
29785 | 29785 | Kings | Kings | 31 | 2020-05-02 | 158 | 1 | |
29788 | 29788 | Long Beach | Los Angeles | 37 | 2020-05-02 | 745 | 37 | |
29789 | 29789 | Los Angeles | Los Angeles | 37 | 2020-05-02 | 23774 | 1121 | |
29790 | 29790 | Pasadena | Los Angeles | 37 | 2020-05-02 | 417 | 54 | |
29791 | 29791 | Madera | Madera | 39 | 2020-05-02 | 51 | 2 | |
29792 | 29792 | Marin | Marin | 41 | 2020-05-02 | 239 | 13 | |
29795 | 29795 | Merced | Merced | 47 | 2020-05-02 | 140 | 3 | |
29798 | 29798 | Monterey | Monterey | 53 | 2020-05-02 | 226 | 6 | |
29799 | 29799 | Napa | Napa | 55 | 2020-05-02 | 70 | 2 | |
29801 | 29801 | Orange | Orange | 59 | 2020-05-02 | 2612 | 52 | |
29802 | 29802 | Placer | Placer | 61 | 2020-05-02 | 159 | 8 | |
29804 | 29804 | Riverside | Riverside | 65 | 2020-05-02 | 4164 | 161 | |
29805 | 29805 | Sacramento | Sacramento | 67 | 2020-05-02 | 1107 | 42 | |
29806 | 29806 | San Benito | San Benito | 69 | 2020-05-02 | 51 | 2 | |
29807 | 29807 | San Bernardino | San Bernardino | 71 | 2020-05-02 | 2182 | 117 | |
29808 | 29808 | San Diego | San Diego | 73 | 2020-05-02 | 3842 | 138 | |
29809 | 29809 | San Francisco | San Francisco | 75 | 2020-05-02 | 1543 | 29 | |
29810 | 29810 | San Joaquin | San Joaquin | 77 | 2020-05-02 | 558 | 25 | |
29811 | 29811 | San Luis Obispo | San Luis Obispo | 79 | 2020-05-02 | 196 | 1 | |
29812 | 29812 | San Mateo | San Mateo | 81 | 2020-05-02 | 1233 | 51 | |
29813 | 29813 | Santa Barbara | Santa Barbara | 83 | 2020-05-02 | 508 | 8 | |
29814 | 29814 | Santa Clara | Santa Clara | 85 | 2020-05-02 | 2256 | 118 | |
29815 | 29815 | Santa Cruz | Santa Cruz | 87 | 2020-05-02 | 134 | 2 | |
29818 | 29818 | Siskiyou | Siskiyou | 93 | 2020-05-02 | 5 | 0 | |
29820 | 29820 | Sonoma | Sonoma | 97 | 2020-05-02 | 252 | 2 | |
29821 | 29821 | Stanislaus | Stanislaus | 99 | 2020-05-02 | 400 | 14 | |
29822 | 29822 | Sutter | Sutter | 101 | 2020-05-02 | 31 | 2 | |
29825 | 29825 | Tulare | Tulare | 107 | 2020-05-02 | 720 | 40 | |
29826 | 29826 | Tuolumne | Tuolumne | 109 | 2020-05-02 | 2 | 0 | |
29827 | 29827 | Ventura | Ventura | 111 | 2020-05-02 | 559 | 19 | |
29828 | 29828 | Yolo | Yolo | 113 | 2020-05-02 | 171 | 16 | |
29829 | 29829 | Yuba | Yuba | 115 | 2020-05-02 | 19 | 1 | |
29770 | 29770 | Berkeley | Alameda | 1 | 2020-05-02 | 54 | 1 | TRUE |
29771 | 29771 | Alpine | Alpine | 3 | 2020-05-02 | 1 | 0 | TRUE |
29773 | 29773 | Butte | Butte | 7 | 2020-05-02 | 17 | 0 | TRUE |
29774 | 29774 | Calaveras | Calaveras | 9 | 2020-05-02 | 13 | 0 | TRUE |
29775 | 29775 | Colusa | Colusa | 11 | 2020-05-02 | 3 | 0 | TRUE |
29777 | 29777 | Del Norte | Del Norte | 15 | 2020-05-02 | 3 | 0 | TRUE |
29778 | 29778 | El Dorado | El Dorado | 17 | 2020-05-02 | 47 | 0 | TRUE |
29780 | 29780 | Glenn | Glenn | 21 | 2020-05-02 | 5 | 0 | TRUE |
29782 | 29782 | Imperial | Imperial | 25 | 2020-05-02 | 358 | 9 | TRUE |
29783 | 29783 | Inyo | Inyo | 27 | 2020-05-02 | 19 | 1 | TRUE |
29786 | 29786 | Lake | Lake | 33 | 2020-05-02 | 7 | 0 | TRUE |
29787 | 29787 | Lassen | Lassen | 35 | 2020-05-02 | 0 | 0 | TRUE |
29793 | 29793 | Mariposa | Mariposa | 43 | 2020-05-02 | 13 | 0 | TRUE |
29794 | 29794 | Mendocino | Mendocino | 45 | 2020-05-02 | 12 | 0 | TRUE |
29796 | 29796 | Modoc | Modoc | 49 | 2020-05-02 | 0 | 0 | TRUE |
29797 | 29797 | Mono | Mono | 51 | 2020-05-02 | 26 | 1 | TRUE |
29800 | 29800 | Nevada | Nevada | 57 | 2020-05-02 | 41 | 1 | TRUE |
29803 | 29803 | Plumas | Plumas | 63 | 2020-05-02 | 4 | 0 | TRUE |
29816 | 29816 | Shasta | Shasta | 89 | 2020-05-02 | 31 | 4 | TRUE |
29817 | 29817 | Sierra | Sierra | 91 | 2020-05-02 | 0 | 0 | TRUE |
29819 | 29819 | Solano | Solano | 95 | 2020-05-02 | 266 | 5 | TRUE |
29823 | 29823 | Tehama | Tehama | 103 | 2020-05-02 | 1 | 1 | TRUE |
29824 | 29824 | Trinity | Trinity | 105 | 2020-05-02 | 0 | 0 | TRUE |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_agency_totals] ( [agency] TEXT, [county] TEXT, [fips] INTEGER, [date] TEXT, [confirmed_cases] INTEGER, [deaths] INTEGER, [did_not_update] TEXT );