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-06-15 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update, date (date)
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
27085 | 27085 | Alameda | Alameda | 1 | 2020-06-15 | 4298 | 153 | |
27086 | 27086 | Berkeley | Alameda | 1 | 2020-06-15 | 116 | 2 | |
27087 | 27087 | Alpine | Alpine | 3 | 2020-06-15 | 1 | 0 | TRUE |
27088 | 27088 | Amador | Amador | 5 | 2020-06-15 | 11 | 0 | |
27089 | 27089 | Butte | Butte | 7 | 2020-06-15 | 78 | 1 | |
27090 | 27090 | Calaveras | Calaveras | 9 | 2020-06-15 | 26 | 0 | TRUE |
27091 | 27091 | Colusa | Colusa | 11 | 2020-06-15 | 7 | 0 | |
27092 | 27092 | Contra Costa | Contra Costa | 13 | 2020-06-15 | 1976 | 44 | |
27093 | 27093 | Del Norte | Del Norte | 15 | 2020-06-15 | 47 | 0 | |
27094 | 27094 | El Dorado | El Dorado | 17 | 2020-06-15 | 117 | 0 | |
27095 | 27095 | Fresno | Fresno | 19 | 2020-06-15 | 4969 | 55 | |
27096 | 27096 | Glenn | Glenn | 21 | 2020-06-15 | 32 | 0 | |
27097 | 27097 | Humboldt | Humboldt | 23 | 2020-06-15 | 106 | 4 | |
27098 | 27098 | Imperial | Imperial | 25 | 2020-06-15 | 4298 | 47 | |
27099 | 27099 | Inyo | Inyo | 27 | 2020-06-15 | 24 | 1 | |
27100 | 27100 | Kern | Kern | 29 | 2020-06-15 | 3367 | 53 | |
27101 | 27101 | Kings | Kings | 31 | 2020-06-15 | 1831 | 8 | |
27102 | 27102 | Lake | Lake | 33 | 2020-06-15 | 34 | 0 | |
27103 | 27103 | Lassen | Lassen | 35 | 2020-06-15 | 9 | 0 | |
27104 | 27104 | Long Beach | Los Angeles | 37 | 2020-06-15 | 2634 | 114 | |
27105 | 27105 | Los Angeles | Los Angeles | 37 | 2020-06-15 | 70150 | 2728 | |
27106 | 27106 | Pasadena | Los Angeles | 37 | 2020-06-15 | 1048 | 84 | |
27107 | 27107 | Madera | Madera | 39 | 2020-06-15 | 226 | 3 | |
27108 | 27108 | Marin | Marin | 41 | 2020-06-15 | 751 | 17 | |
27109 | 27109 | Mariposa | Mariposa | 43 | 2020-06-15 | 17 | 1 | |
27110 | 27110 | Mendocino | Mendocino | 45 | 2020-06-15 | 45 | 0 | |
27111 | 27111 | Merced | Merced | 47 | 2020-06-15 | 409 | 7 | TRUE |
27112 | 27112 | Modoc | Modoc | 49 | 2020-06-15 | 0 | 0 | |
27113 | 27113 | Mono | Mono | 51 | 2020-06-15 | 37 | 1 | |
27114 | 27114 | Monterey | Monterey | 53 | 2020-06-15 | 995 | 12 | |
27115 | 27115 | Napa | Napa | 55 | 2020-06-15 | 190 | 3 | |
27116 | 27116 | Nevada | Nevada | 57 | 2020-06-15 | 55 | 1 | |
27117 | 27117 | Orange | Orange | 59 | 2020-06-15 | 8759 | 221 | |
27118 | 27118 | Placer | Placer | 61 | 2020-06-15 | 390 | 9 | |
27119 | 27119 | Plumas | Plumas | 63 | 2020-06-15 | 5 | 0 | |
27120 | 27120 | Riverside | Riverside | 65 | 2020-06-15 | 11285 | 384 | |
27121 | 27121 | Sacramento | Sacramento | 67 | 2020-06-15 | 1794 | 63 | |
27122 | 27122 | San Benito | San Benito | 69 | 2020-06-15 | 129 | 2 | |
27123 | 27123 | San Bernardino | San Bernardino | 71 | 2020-06-15 | 7515 | 262 | |
27124 | 27124 | San Diego | San Diego | 73 | 2020-06-15 | 9610 | 320 | |
27125 | 27125 | San Francisco | San Francisco | 75 | 2020-06-15 | 2952 | 45 | |
27126 | 27126 | San Joaquin | San Joaquin | 77 | 2020-06-15 | 1717 | 42 | |
27127 | 27127 | San Luis Obispo | San Luis Obispo | 79 | 2020-06-15 | 347 | 1 | |
27128 | 27128 | San Mateo | San Mateo | 81 | 2020-06-15 | 2594 | 99 | |
27129 | 27129 | Santa Barbara | Santa Barbara | 83 | 2020-06-15 | 2069 | 18 | |
27130 | 27130 | Santa Clara | Santa Clara | 85 | 2020-06-15 | 3404 | 148 | |
27131 | 27131 | Santa Cruz | Santa Cruz | 87 | 2020-06-15 | 257 | 2 | |
27132 | 27132 | Shasta | Shasta | 89 | 2020-06-15 | 51 | 4 | |
27133 | 27133 | Sierra | Sierra | 91 | 2020-06-15 | 1 | 0 | |
27134 | 27134 | Siskiyou | Siskiyou | 93 | 2020-06-15 | 18 | 0 | |
27135 | 27135 | Solano | Solano | 95 | 2020-06-15 | 685 | 23 | |
27136 | 27136 | Sonoma | Sonoma | 97 | 2020-06-15 | 765 | 4 | |
27137 | 27137 | Stanislaus | Stanislaus | 99 | 2020-06-15 | 1242 | 35 | |
27138 | 27138 | Sutter | Sutter | 101 | 2020-06-15 | 88 | 3 | |
27139 | 27139 | Tehama | Tehama | 103 | 2020-06-15 | 27 | 1 | |
27140 | 27140 | Trinity | Trinity | 105 | 2020-06-15 | 2 | 0 | |
27141 | 27141 | Tulare | Tulare | 107 | 2020-06-15 | 2664 | 98 | |
27142 | 27142 | Tuolumne | Tuolumne | 109 | 2020-06-15 | 9 | 0 | |
27143 | 27143 | Ventura | Ventura | 111 | 2020-06-15 | 1633 | 41 | |
27144 | 27144 | Yolo | Yolo | 113 | 2020-06-15 | 255 | 24 | |
27145 | 27145 | Yuba | Yuba | 115 | 2020-06-15 | 36 | 1 |
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 );