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-13 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
4942 | 4942 | Alameda | Alameda | 1 | 2021-06-13 | 85754 | 1217 | |
4943 | 4943 | Berkeley | Alameda | 1 | 2021-06-13 | 3633 | 46 | |
4944 | 4944 | Alpine | Alpine | 3 | 2021-06-13 | 89 | 0 | TRUE |
4945 | 4945 | Amador | Amador | 5 | 2021-06-13 | 3685 | 47 | |
4946 | 4946 | Butte | Butte | 7 | 2021-06-13 | 12586 | 192 | TRUE |
4947 | 4947 | Calaveras | Calaveras | 9 | 2021-06-13 | 2200 | 56 | TRUE |
4948 | 4948 | Colusa | Colusa | 11 | 2021-06-13 | 2279 | 18 | TRUE |
4949 | 4949 | Contra Costa | Contra Costa | 13 | 2021-06-13 | 70328 | 808 | |
4950 | 4950 | Del Norte | Del Norte | 15 | 2021-06-13 | 1448 | 7 | TRUE |
4951 | 4951 | El Dorado | El Dorado | 17 | 2021-06-13 | 10339 | 116 | TRUE |
4952 | 4952 | Fresno | Fresno | 19 | 2021-06-13 | 102159 | 1719 | |
4953 | 4953 | Glenn | Glenn | 21 | 2021-06-13 | 2357 | 27 | TRUE |
4954 | 4954 | Humboldt | Humboldt | 23 | 2021-06-13 | 4415 | 46 | TRUE |
4955 | 4955 | Imperial | Imperial | 25 | 2021-06-13 | 28246 | 739 | TRUE |
4956 | 4956 | Inyo | Inyo | 27 | 2021-06-13 | 1434 | 38 | TRUE |
4957 | 4957 | Kern | Kern | 29 | 2021-06-13 | 110604 | 1400 | |
4958 | 4958 | Kings | Kings | 31 | 2021-06-13 | 23093 | 247 | |
4959 | 4959 | Lake | Lake | 33 | 2021-06-13 | 3536 | 45 | TRUE |
4960 | 4960 | Lassen | Lassen | 35 | 2021-06-13 | 5775 | 24 | TRUE |
4961 | 4961 | Long Beach | Los Angeles | 37 | 2021-06-13 | 53476 | 942 | TRUE |
4962 | 4962 | Los Angeles | Los Angeles | 37 | 2021-06-13 | 1181524 | 23123 | |
4963 | 4963 | Pasadena | Los Angeles | 37 | 2021-06-13 | 11307 | 349 | TRUE |
4964 | 4964 | Madera | Madera | 39 | 2021-06-13 | 16476 | 245 | TRUE |
4965 | 4965 | Marin | Marin | 41 | 2021-06-13 | 14177 | 212 | |
4966 | 4966 | Mariposa | Mariposa | 43 | 2021-06-13 | 461 | 7 | TRUE |
4967 | 4967 | Mendocino | Mendocino | 45 | 2021-06-13 | 4274 | 50 | TRUE |
4968 | 4968 | Merced | Merced | 47 | 2021-06-13 | 32253 | 474 | TRUE |
4969 | 4969 | Modoc | Modoc | 49 | 2021-06-13 | 534 | 4 | TRUE |
4970 | 4970 | Mono | Mono | 51 | 2021-06-13 | 1295 | 4 | TRUE |
4971 | 4971 | Monterey | Monterey | 53 | 2021-06-13 | 43791 | 419 | TRUE |
4972 | 4972 | Napa | Napa | 55 | 2021-06-13 | 9967 | 79 | TRUE |
4973 | 4973 | Nevada | Nevada | 57 | 2021-06-13 | 4874 | 75 | TRUE |
4974 | 4974 | Orange | Orange | 59 | 2021-06-13 | 255588 | 5095 | TRUE |
4975 | 4975 | Placer | Placer | 61 | 2021-06-13 | 23338 | 298 | TRUE |
4976 | 4976 | Plumas | Plumas | 63 | 2021-06-13 | 735 | 6 | TRUE |
4977 | 4977 | Riverside | Riverside | 65 | 2021-06-13 | 301312 | 4618 | TRUE |
4978 | 4978 | Sacramento | Sacramento | 67 | 2021-06-13 | 107186 | 1718 | TRUE |
4979 | 4979 | San Benito | San Benito | 69 | 2021-06-13 | 6095 | 63 | TRUE |
4980 | 4980 | San Bernardino | San Bernardino | 71 | 2021-06-13 | 298976 | 4833 | |
4981 | 4981 | San Diego | San Diego | 73 | 2021-06-13 | 281202 | 3770 | TRUE |
4982 | 4982 | San Francisco | San Francisco | 75 | 2021-06-13 | 36851 | 550 | |
4983 | 4983 | San Joaquin | San Joaquin | 77 | 2021-06-13 | 74401 | 1432 | TRUE |
4984 | 4984 | San Luis Obispo | San Luis Obispo | 79 | 2021-06-13 | 21405 | 261 | TRUE |
4985 | 4985 | San Mateo | San Mateo | 81 | 2021-06-13 | 42214 | 581 | TRUE |
4986 | 4986 | Santa Barbara | Santa Barbara | 83 | 2021-06-13 | 34577 | 452 | |
4987 | 4987 | Santa Clara | Santa Clara | 85 | 2021-06-13 | 118757 | 1695 | TRUE |
4988 | 4988 | Santa Cruz | Santa Cruz | 87 | 2021-06-13 | 16202 | 207 | TRUE |
4989 | 4989 | Shasta | Shasta | 89 | 2021-06-13 | 12580 | 232 | TRUE |
4990 | 4990 | Sierra | Sierra | 91 | 2021-06-13 | 113 | 0 | TRUE |
4991 | 4991 | Siskiyou | Siskiyou | 93 | 2021-06-13 | 2386 | 37 | TRUE |
4992 | 4992 | Solano | Solano | 95 | 2021-06-13 | 33569 | 244 | TRUE |
4993 | 4993 | Sonoma | Sonoma | 97 | 2021-06-13 | 30688 | 316 | TRUE |
4994 | 4994 | Stanislaus | Stanislaus | 99 | 2021-06-13 | 56509 | 1068 | TRUE |
4995 | 4995 | Sutter | Sutter | 101 | 2021-06-13 | 9614 | 106 | TRUE |
4996 | 4996 | Tehama | Tehama | 103 | 2021-06-13 | 5716 | 59 | TRUE |
4997 | 4997 | Trinity | Trinity | 105 | 2021-06-13 | 416 | 5 | TRUE |
4998 | 4998 | Tulare | Tulare | 107 | 2021-06-13 | 49758 | 849 | TRUE |
4999 | 4999 | Tuolumne | Tuolumne | 109 | 2021-06-13 | 4185 | 69 | TRUE |
5000 | 5000 | Ventura | Ventura | 111 | 2021-06-13 | 81554 | 1025 | |
5001 | 5001 | Yolo | Yolo | 113 | 2021-06-13 | 14049 | 209 | TRUE |
5002 | 5002 | Yuba | Yuba | 115 | 2021-06-13 | 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 );