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-07-14 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
3051 | 3051 | Alameda | Alameda | 1 | 2021-07-14 | 88013 | 1220 | |
3052 | 3052 | Berkeley | Alameda | 1 | 2021-07-14 | 3730 | 50 | |
3053 | 3053 | Alpine | Alpine | 3 | 2021-07-14 | 89 | 0 | TRUE |
3054 | 3054 | Amador | Amador | 5 | 2021-07-14 | 3751 | 48 | |
3055 | 3055 | Butte | Butte | 7 | 2021-07-14 | 12813 | 198 | TRUE |
3056 | 3056 | Calaveras | Calaveras | 9 | 2021-07-14 | 2251 | 58 | |
3057 | 3057 | Colusa | Colusa | 11 | 2021-07-14 | 2322 | 18 | TRUE |
3058 | 3058 | Contra Costa | Contra Costa | 13 | 2021-07-14 | 72442 | 821 | |
3059 | 3059 | Del Norte | Del Norte | 15 | 2021-07-14 | 1518 | 8 | |
3060 | 3060 | El Dorado | El Dorado | 17 | 2021-07-14 | 10633 | 118 | |
3061 | 3061 | Fresno | Fresno | 19 | 2021-07-14 | 102909 | 1730 | |
3062 | 3062 | Glenn | Glenn | 21 | 2021-07-14 | 2382 | 27 | |
3063 | 3063 | Humboldt | Humboldt | 23 | 2021-07-14 | 4703 | 53 | |
3064 | 3064 | Imperial | Imperial | 25 | 2021-07-14 | 28559 | 745 | TRUE |
3065 | 3065 | Inyo | Inyo | 27 | 2021-07-14 | 1446 | 38 | |
3066 | 3066 | Kern | Kern | 29 | 2021-07-14 | 111571 | 1413 | |
3067 | 3067 | Kings | Kings | 31 | 2021-07-14 | 23146 | 248 | TRUE |
3068 | 3068 | Lake | Lake | 33 | 2021-07-14 | 3692 | 63 | TRUE |
3069 | 3069 | Lassen | Lassen | 35 | 2021-07-14 | 5857 | 26 | |
3070 | 3070 | Long Beach | Los Angeles | 37 | 2021-07-14 | 54201 | 947 | |
3071 | 3071 | Los Angeles | Los Angeles | 37 | 2021-07-14 | 1195492 | 23265 | |
3072 | 3072 | Pasadena | Los Angeles | 37 | 2021-07-14 | 11471 | 351 | |
3073 | 3073 | Madera | Madera | 39 | 2021-07-14 | 16686 | 248 | TRUE |
3074 | 3074 | Marin | Marin | 41 | 2021-07-14 | 14392 | 213 | |
3075 | 3075 | Mariposa | Mariposa | 43 | 2021-07-14 | 469 | 7 | |
3076 | 3076 | Mendocino | Mendocino | 45 | 2021-07-14 | 4460 | 50 | |
3077 | 3077 | Merced | Merced | 47 | 2021-07-14 | 32541 | 483 | |
3078 | 3078 | Modoc | Modoc | 49 | 2021-07-14 | 573 | 7 | TRUE |
3079 | 3079 | Mono | Mono | 51 | 2021-07-14 | 1304 | 5 | TRUE |
3080 | 3080 | Monterey | Monterey | 53 | 2021-07-14 | 44087 | 507 | |
3081 | 3081 | Napa | Napa | 55 | 2021-07-14 | 10146 | 80 | |
3082 | 3082 | Nevada | Nevada | 57 | 2021-07-14 | 5061 | 75 | |
3083 | 3083 | Orange | Orange | 59 | 2021-07-14 | 257826 | 5133 | TRUE |
3084 | 3084 | Placer | Placer | 61 | 2021-07-14 | 24176 | 304 | |
3085 | 3085 | Plumas | Plumas | 63 | 2021-07-14 | 742 | 6 | TRUE |
3086 | 3086 | Riverside | Riverside | 65 | 2021-07-14 | 302069 | 4647 | |
3087 | 3087 | Sacramento | Sacramento | 67 | 2021-07-14 | 110639 | 1754 | |
3088 | 3088 | San Benito | San Benito | 69 | 2021-07-14 | 6196 | 63 | |
3089 | 3089 | San Bernardino | San Bernardino | 71 | 2021-07-14 | 301802 | 4854 | |
3090 | 3090 | San Diego | San Diego | 73 | 2021-07-14 | 285268 | 3786 | |
3091 | 3091 | San Francisco | San Francisco | 75 | 2021-07-14 | 37661 | 557 | |
3092 | 3092 | San Joaquin | San Joaquin | 77 | 2021-07-14 | 75500 | 1446 | |
3093 | 3093 | San Luis Obispo | San Luis Obispo | 79 | 2021-07-14 | 21588 | 264 | TRUE |
3094 | 3094 | San Mateo | San Mateo | 81 | 2021-07-14 | 42947 | 583 | |
3095 | 3095 | Santa Barbara | Santa Barbara | 83 | 2021-07-14 | 34849 | 458 | |
3096 | 3096 | Santa Clara | Santa Clara | 85 | 2021-07-14 | 120313 | 1702 | |
3097 | 3097 | Santa Cruz | Santa Cruz | 87 | 2021-07-14 | 16351 | 207 | TRUE |
3098 | 3098 | Shasta | Shasta | 89 | 2021-07-14 | 12614 | 238 | TRUE |
3099 | 3099 | Sierra | Sierra | 91 | 2021-07-14 | 123 | 0 | TRUE |
3100 | 3100 | Siskiyou | Siskiyou | 93 | 2021-07-14 | 2466 | 40 | |
3101 | 3101 | Solano | Solano | 95 | 2021-07-14 | 34461 | 245 | |
3102 | 3102 | Sonoma | Sonoma | 97 | 2021-07-14 | 31547 | 323 | |
3103 | 3103 | Stanislaus | Stanislaus | 99 | 2021-07-14 | 57733 | 1080 | |
3104 | 3104 | Sutter | Sutter | 101 | 2021-07-14 | 9838 | 108 | |
3105 | 3105 | Tehama | Tehama | 103 | 2021-07-14 | 5791 | 61 | |
3106 | 3106 | Trinity | Trinity | 105 | 2021-07-14 | 432 | 6 | |
3107 | 3107 | Tulare | Tulare | 107 | 2021-07-14 | 49964 | 852 | |
3108 | 3108 | Tuolumne | Tuolumne | 109 | 2021-07-14 | 4280 | 72 | |
3109 | 3109 | Ventura | Ventura | 111 | 2021-07-14 | 82160 | 1032 | |
3110 | 3110 | Yolo | Yolo | 113 | 2021-07-14 | 14291 | 211 | |
3111 | 3111 | Yuba | Yuba | 115 | 2021-07-14 | 6651 | 41 |
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 );