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 2021-06-12 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 |
---|---|---|---|---|---|---|---|---|
5003 | 5003 | Alameda | Alameda | 1 | 2021-06-12 | 85707 | 1217 | TRUE |
5004 | 5004 | Berkeley | Alameda | 1 | 2021-06-12 | 3632 | 46 | |
5005 | 5005 | Alpine | Alpine | 3 | 2021-06-12 | 89 | 0 | TRUE |
5006 | 5006 | Amador | Amador | 5 | 2021-06-12 | 3677 | 47 | TRUE |
5007 | 5007 | Butte | Butte | 7 | 2021-06-12 | 12576 | 192 | |
5008 | 5008 | Calaveras | Calaveras | 9 | 2021-06-12 | 2200 | 56 | TRUE |
5009 | 5009 | Colusa | Colusa | 11 | 2021-06-12 | 2279 | 18 | TRUE |
5010 | 5010 | Contra Costa | Contra Costa | 13 | 2021-06-12 | 70276 | 808 | |
5011 | 5011 | Del Norte | Del Norte | 15 | 2021-06-12 | 1448 | 7 | TRUE |
5012 | 5012 | El Dorado | El Dorado | 17 | 2021-06-12 | 10339 | 116 | TRUE |
5013 | 5013 | Fresno | Fresno | 19 | 2021-06-12 | 102149 | 1717 | TRUE |
5014 | 5014 | Glenn | Glenn | 21 | 2021-06-12 | 2357 | 27 | TRUE |
5015 | 5015 | Humboldt | Humboldt | 23 | 2021-06-12 | 4415 | 46 | TRUE |
5016 | 5016 | Imperial | Imperial | 25 | 2021-06-12 | 28246 | 739 | TRUE |
5017 | 5017 | Inyo | Inyo | 27 | 2021-06-12 | 1434 | 38 | TRUE |
5018 | 5018 | Kern | Kern | 29 | 2021-06-12 | 110593 | 1400 | |
5019 | 5019 | Kings | Kings | 31 | 2021-06-12 | 23093 | 247 | |
5020 | 5020 | Lake | Lake | 33 | 2021-06-12 | 3536 | 45 | TRUE |
5021 | 5021 | Lassen | Lassen | 35 | 2021-06-12 | 5775 | 24 | TRUE |
5022 | 5022 | Long Beach | Los Angeles | 37 | 2021-06-12 | 53476 | 942 | |
5023 | 5023 | Los Angeles | Los Angeles | 37 | 2021-06-12 | 1181340 | 23123 | |
5024 | 5024 | Pasadena | Los Angeles | 37 | 2021-06-12 | 11307 | 349 | TRUE |
5025 | 5025 | Madera | Madera | 39 | 2021-06-12 | 16476 | 245 | TRUE |
5026 | 5026 | Marin | Marin | 41 | 2021-06-12 | 14170 | 212 | |
5027 | 5027 | Mariposa | Mariposa | 43 | 2021-06-12 | 461 | 7 | TRUE |
5028 | 5028 | Mendocino | Mendocino | 45 | 2021-06-12 | 4274 | 50 | TRUE |
5029 | 5029 | Merced | Merced | 47 | 2021-06-12 | 32253 | 474 | TRUE |
5030 | 5030 | Modoc | Modoc | 49 | 2021-06-12 | 534 | 4 | |
5031 | 5031 | Mono | Mono | 51 | 2021-06-12 | 1295 | 4 | TRUE |
5032 | 5032 | Monterey | Monterey | 53 | 2021-06-12 | 43791 | 419 | TRUE |
5033 | 5033 | Napa | Napa | 55 | 2021-06-12 | 9967 | 79 | TRUE |
5034 | 5034 | Nevada | Nevada | 57 | 2021-06-12 | 4874 | 75 | TRUE |
5035 | 5035 | Orange | Orange | 59 | 2021-06-12 | 255588 | 5095 | TRUE |
5036 | 5036 | Placer | Placer | 61 | 2021-06-12 | 23338 | 298 | TRUE |
5037 | 5037 | Plumas | Plumas | 63 | 2021-06-12 | 735 | 6 | TRUE |
5038 | 5038 | Riverside | Riverside | 65 | 2021-06-12 | 301312 | 4618 | TRUE |
5039 | 5039 | Sacramento | Sacramento | 67 | 2021-06-12 | 107186 | 1718 | TRUE |
5040 | 5040 | San Benito | San Benito | 69 | 2021-06-12 | 6095 | 63 | TRUE |
5041 | 5041 | San Bernardino | San Bernardino | 71 | 2021-06-12 | 298939 | 4833 | |
5042 | 5042 | San Diego | San Diego | 73 | 2021-06-12 | 281202 | 3770 | |
5043 | 5043 | San Francisco | San Francisco | 75 | 2021-06-12 | 36839 | 550 | |
5044 | 5044 | San Joaquin | San Joaquin | 77 | 2021-06-12 | 74401 | 1432 | TRUE |
5045 | 5045 | San Luis Obispo | San Luis Obispo | 79 | 2021-06-12 | 21405 | 261 | TRUE |
5046 | 5046 | San Mateo | San Mateo | 81 | 2021-06-12 | 42214 | 581 | TRUE |
5047 | 5047 | Santa Barbara | Santa Barbara | 83 | 2021-06-12 | 34572 | 452 | |
5048 | 5048 | Santa Clara | Santa Clara | 85 | 2021-06-12 | 118736 | 1695 | |
5049 | 5049 | Santa Cruz | Santa Cruz | 87 | 2021-06-12 | 16202 | 207 | TRUE |
5050 | 5050 | Shasta | Shasta | 89 | 2021-06-12 | 12580 | 232 | TRUE |
5051 | 5051 | Sierra | Sierra | 91 | 2021-06-12 | 113 | 0 | TRUE |
5052 | 5052 | Siskiyou | Siskiyou | 93 | 2021-06-12 | 2386 | 37 | TRUE |
5053 | 5053 | Solano | Solano | 95 | 2021-06-12 | 33569 | 244 | TRUE |
5054 | 5054 | Sonoma | Sonoma | 97 | 2021-06-12 | 30688 | 316 | |
5055 | 5055 | Stanislaus | Stanislaus | 99 | 2021-06-12 | 56509 | 1068 | TRUE |
5056 | 5056 | Sutter | Sutter | 101 | 2021-06-12 | 9614 | 106 | TRUE |
5057 | 5057 | Tehama | Tehama | 103 | 2021-06-12 | 5716 | 59 | |
5058 | 5058 | Trinity | Trinity | 105 | 2021-06-12 | 416 | 5 | TRUE |
5059 | 5059 | Tulare | Tulare | 107 | 2021-06-12 | 49758 | 849 | TRUE |
5060 | 5060 | Tuolumne | Tuolumne | 109 | 2021-06-12 | 4185 | 69 | TRUE |
5061 | 5061 | Ventura | Ventura | 111 | 2021-06-12 | 81554 | 1025 | TRUE |
5062 | 5062 | Yolo | Yolo | 113 | 2021-06-12 | 14049 | 209 | TRUE |
5063 | 5063 | Yuba | Yuba | 115 | 2021-06-12 | 6448 | 41 | 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 );