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-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 |
---|---|---|---|---|---|---|---|---|
3112 | 3112 | Alameda | Alameda | 1 | 2021-07-13 | 87824 | 1220 | |
3113 | 3113 | Berkeley | Alameda | 1 | 2021-07-13 | 3722 | 50 | |
3114 | 3114 | Alpine | Alpine | 3 | 2021-07-13 | 89 | 0 | TRUE |
3115 | 3115 | Amador | Amador | 5 | 2021-07-13 | 3747 | 48 | TRUE |
3116 | 3116 | Butte | Butte | 7 | 2021-07-13 | 12802 | 198 | |
3117 | 3117 | Calaveras | Calaveras | 9 | 2021-07-13 | 2235 | 58 | TRUE |
3118 | 3118 | Colusa | Colusa | 11 | 2021-07-13 | 2322 | 18 | TRUE |
3119 | 3119 | Contra Costa | Contra Costa | 13 | 2021-07-13 | 72326 | 821 | |
3120 | 3120 | Del Norte | Del Norte | 15 | 2021-07-13 | 1516 | 8 | |
3121 | 3121 | El Dorado | El Dorado | 17 | 2021-07-13 | 10604 | 118 | TRUE |
3122 | 3122 | Fresno | Fresno | 19 | 2021-07-13 | 102853 | 1730 | |
3123 | 3123 | Glenn | Glenn | 21 | 2021-07-13 | 2380 | 27 | TRUE |
3124 | 3124 | Humboldt | Humboldt | 23 | 2021-07-13 | 4691 | 52 | |
3125 | 3125 | Imperial | Imperial | 25 | 2021-07-13 | 28559 | 745 | |
3126 | 3126 | Inyo | Inyo | 27 | 2021-07-13 | 1444 | 38 | TRUE |
3127 | 3127 | Kern | Kern | 29 | 2021-07-13 | 111437 | 1412 | TRUE |
3128 | 3128 | Kings | Kings | 31 | 2021-07-13 | 23146 | 248 | TRUE |
3129 | 3129 | Lake | Lake | 33 | 2021-07-13 | 3692 | 63 | TRUE |
3130 | 3130 | Lassen | Lassen | 35 | 2021-07-13 | 5851 | 26 | |
3131 | 3131 | Long Beach | Los Angeles | 37 | 2021-07-13 | 54105 | 947 | |
3132 | 3132 | Los Angeles | Los Angeles | 37 | 2021-07-13 | 1194430 | 23256 | |
3133 | 3133 | Pasadena | Los Angeles | 37 | 2021-07-13 | 11457 | 351 | |
3134 | 3134 | Madera | Madera | 39 | 2021-07-13 | 16686 | 248 | |
3135 | 3135 | Marin | Marin | 41 | 2021-07-13 | 14374 | 213 | |
3136 | 3136 | Mariposa | Mariposa | 43 | 2021-07-13 | 469 | 7 | |
3137 | 3137 | Mendocino | Mendocino | 45 | 2021-07-13 | 4448 | 50 | TRUE |
3138 | 3138 | Merced | Merced | 47 | 2021-07-13 | 32526 | 483 | |
3139 | 3139 | Modoc | Modoc | 49 | 2021-07-13 | 573 | 7 | TRUR |
3140 | 3140 | Mono | Mono | 51 | 2021-07-13 | 1304 | 5 | |
3141 | 3141 | Monterey | Monterey | 53 | 2021-07-13 | 44073 | 507 | |
3142 | 3142 | Napa | Napa | 55 | 2021-07-13 | 10143 | 80 | |
3143 | 3143 | Nevada | Nevada | 57 | 2021-07-13 | 5061 | 75 | |
3144 | 3144 | Orange | Orange | 59 | 2021-07-13 | 257826 | 5133 | |
3145 | 3145 | Placer | Placer | 61 | 2021-07-13 | 23943 | 303 | TRUE |
3146 | 3146 | Plumas | Plumas | 63 | 2021-07-13 | 742 | 6 | TRUE |
3147 | 3147 | Riverside | Riverside | 65 | 2021-07-13 | 302069 | 4647 | TRUE |
3148 | 3148 | Sacramento | Sacramento | 67 | 2021-07-13 | 110435 | 1754 | |
3149 | 3149 | San Benito | San Benito | 69 | 2021-07-13 | 6192 | 63 | |
3150 | 3150 | San Bernardino | San Bernardino | 71 | 2021-07-13 | 301554 | 4854 | |
3151 | 3151 | San Diego | San Diego | 73 | 2021-07-13 | 284996 | 3785 | |
3152 | 3152 | San Francisco | San Francisco | 75 | 2021-07-13 | 37577 | 557 | |
3153 | 3153 | San Joaquin | San Joaquin | 77 | 2021-07-13 | 75133 | 1442 | TRUE |
3154 | 3154 | San Luis Obispo | San Luis Obispo | 79 | 2021-07-13 | 21588 | 264 | |
3155 | 3155 | San Mateo | San Mateo | 81 | 2021-07-13 | 42870 | 583 | |
3156 | 3156 | Santa Barbara | Santa Barbara | 83 | 2021-07-13 | 34808 | 458 | |
3157 | 3157 | Santa Clara | Santa Clara | 85 | 2021-07-13 | 120192 | 1702 | |
3158 | 3158 | Santa Cruz | Santa Cruz | 87 | 2021-07-13 | 16351 | 207 | TRUE |
3159 | 3159 | Shasta | Shasta | 89 | 2021-07-13 | 12614 | 238 | TRUE |
3160 | 3160 | Sierra | Sierra | 91 | 2021-07-13 | 123 | 0 | |
3161 | 3161 | Siskiyou | Siskiyou | 93 | 2021-07-13 | 2464 | 40 | |
3162 | 3162 | Solano | Solano | 95 | 2021-07-13 | 34377 | 245 | TRUE |
3163 | 3163 | Sonoma | Sonoma | 97 | 2021-07-13 | 31435 | 323 | TRUE |
3164 | 3164 | Stanislaus | Stanislaus | 99 | 2021-07-13 | 57671 | 1079 | |
3165 | 3165 | Sutter | Sutter | 101 | 2021-07-13 | 9819 | 108 | |
3166 | 3166 | Tehama | Tehama | 103 | 2021-07-13 | 5782 | 60 | |
3167 | 3167 | Trinity | Trinity | 105 | 2021-07-13 | 430 | 6 | |
3168 | 3168 | Tulare | Tulare | 107 | 2021-07-13 | 49915 | 852 | TRUE |
3169 | 3169 | Tuolumne | Tuolumne | 109 | 2021-07-13 | 4275 | 72 | |
3170 | 3170 | Ventura | Ventura | 111 | 2021-07-13 | 82080 | 1032 | TRUE |
3171 | 3171 | Yolo | Yolo | 113 | 2021-07-13 | 14272 | 210 | |
3172 | 3172 | Yuba | Yuba | 115 | 2021-07-13 | 6636 | 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 );