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-11-28 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
16959 | 16959 | Alameda | Alameda | 1 | 2020-11-28 | 28641 | 516 | |
16960 | 16960 | Berkeley | Alameda | 1 | 2020-11-28 | 1147 | 10 | TRUE |
16961 | 16961 | Alpine | Alpine | 3 | 2020-11-28 | 50 | 0 | TRUE |
16962 | 16962 | Amador | Amador | 5 | 2020-11-28 | 563 | 16 | |
16963 | 16963 | Butte | Butte | 7 | 2020-11-28 | 3894 | 59 | TRUE |
16964 | 16964 | Calaveras | Calaveras | 9 | 2020-11-28 | 450 | 22 | TRUE |
16965 | 16965 | Colusa | Colusa | 11 | 2020-11-28 | 694 | 6 | TRUE |
16966 | 16966 | Contra Costa | Contra Costa | 13 | 2020-11-28 | 23895 | 261 | |
16967 | 16967 | Del Norte | Del Norte | 15 | 2020-11-28 | 313 | 1 | TRUE |
16968 | 16968 | El Dorado | El Dorado | 17 | 2020-11-28 | 2315 | 4 | TRUE |
16969 | 16969 | Fresno | Fresno | 19 | 2020-11-28 | 43125 | 481 | |
16970 | 16970 | Glenn | Glenn | 21 | 2020-11-28 | 884 | 8 | TRUE |
16971 | 16971 | Humboldt | Humboldt | 23 | 2020-11-28 | 850 | 9 | TRUE |
16972 | 16972 | Imperial | Imperial | 25 | 2020-11-28 | 15862 | 356 | TRUE |
16973 | 16973 | Inyo | Inyo | 27 | 2020-11-28 | 290 | 16 | TRUE |
16974 | 16974 | Kern | Kern | 29 | 2020-11-28 | 41328 | 448 | |
16975 | 16975 | Kings | Kings | 31 | 2020-11-28 | 11093 | 87 | |
16976 | 16976 | Lake | Lake | 33 | 2020-11-28 | 886 | 19 | TRUE |
16977 | 16977 | Lassen | Lassen | 35 | 2020-11-28 | 1773 | 3 | TRUE |
16978 | 16978 | Long Beach | Los Angeles | 37 | 2020-11-28 | 15713 | 274 | |
16979 | 16979 | Los Angeles | Los Angeles | 37 | 2020-11-28 | 371877 | 7217 | |
16980 | 16980 | Pasadena | Los Angeles | 37 | 2020-11-28 | 3635 | 132 | |
16981 | 16981 | Madera | Madera | 39 | 2020-11-28 | 6047 | 85 | TRUE |
16982 | 16982 | Marin | Marin | 41 | 2020-11-28 | 7755 | 129 | |
16983 | 16983 | Mariposa | Mariposa | 43 | 2020-11-28 | 130 | 2 | |
16984 | 16984 | Mendocino | Mendocino | 45 | 2020-11-28 | 1570 | 23 | |
16985 | 16985 | Merced | Merced | 47 | 2020-11-28 | 11537 | 179 | TRUE |
16986 | 16986 | Modoc | Modoc | 49 | 2020-11-28 | 131 | 0 | TRUE |
16987 | 16987 | Mono | Mono | 51 | 2020-11-28 | 547 | 3 | |
16988 | 16988 | Monterey | Monterey | 53 | 2020-11-28 | 14791 | 121 | |
16989 | 16989 | Napa | Napa | 55 | 2020-11-28 | 2931 | 16 | TRUE |
16990 | 16990 | Nevada | Nevada | 57 | 2020-11-28 | 1183 | 9 | TRUE |
16991 | 16991 | Orange | Orange | 59 | 2020-11-28 | 76761 | 1577 | |
16992 | 16992 | Placer | Placer | 61 | 2020-11-28 | 6354 | 68 | TRUE |
16993 | 16993 | Plumas | Plumas | 63 | 2020-11-28 | 215 | 0 | |
16994 | 16994 | Riverside | Riverside | 65 | 2020-11-28 | 82286 | 1437 | TRUE |
16995 | 16995 | Sacramento | Sacramento | 67 | 2020-11-28 | 36630 | 576 | TRUE |
16996 | 16996 | San Benito | San Benito | 69 | 2020-11-28 | 1865 | 16 | |
16997 | 16997 | San Bernardino | San Bernardino | 71 | 2020-11-28 | 92164 | 1457 | |
16998 | 16998 | San Diego | San Diego | 73 | 2020-11-28 | 80018 | 997 | |
16999 | 16999 | San Francisco | San Francisco | 75 | 2020-11-28 | 15342 | 160 | |
17000 | 17000 | San Joaquin | San Joaquin | 77 | 2020-11-28 | 25675 | 502 | TRUE |
17001 | 17001 | San Luis Obispo | San Luis Obispo | 79 | 2020-11-28 | 6129 | 36 | TRUE |
17002 | 17002 | San Mateo | San Mateo | 81 | 2020-11-28 | 14148 | 170 | |
17003 | 17003 | Santa Barbara | Santa Barbara | 83 | 2020-11-28 | 11205 | 135 | TRUE |
17004 | 17004 | Santa Clara | Santa Clara | 85 | 2020-11-28 | 36000 | 432 | |
17005 | 17005 | Santa Cruz | Santa Cruz | 87 | 2020-11-28 | 4424 | 28 | |
17006 | 17006 | Shasta | Shasta | 89 | 2020-11-28 | 4718 | 47 | TRUE |
17007 | 17007 | Sierra | Sierra | 91 | 2020-11-28 | 19 | 0 | TRUE |
17008 | 17008 | Siskiyou | Siskiyou | 93 | 2020-11-28 | 624 | 2 | TRUE |
17009 | 17009 | Solano | Solano | 95 | 2020-11-28 | 10036 | 81 | TRUE |
17010 | 17010 | Sonoma | Sonoma | 97 | 2020-11-28 | 12049 | 157 | TRUE |
17011 | 17011 | Stanislaus | Stanislaus | 99 | 2020-11-28 | 21585 | 424 | |
17012 | 17012 | Sutter | Sutter | 101 | 2020-11-28 | 3332 | 16 | |
17013 | 17013 | Tehama | Tehama | 103 | 2020-11-28 | 1589 | 25 | TRUE |
17014 | 17014 | Trinity | Trinity | 105 | 2020-11-28 | 158 | 0 | TRUE |
17015 | 17015 | Tulare | Tulare | 107 | 2020-11-28 | 20550 | 308 | TRUE |
17016 | 17016 | Tuolumne | Tuolumne | 109 | 2020-11-28 | 981 | 8 | TRUE |
17017 | 17017 | Ventura | Ventura | 111 | 2020-11-28 | 18394 | 175 | TRUE |
17018 | 17018 | Yolo | Yolo | 113 | 2020-11-28 | 4736 | 75 | |
17019 | 17019 | Yuba | Yuba | 115 | 2020-11-28 | 2036 | 10 |
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 );