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-03-21 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
10066 | 10066 | Alameda | Alameda | 1 | 2021-03-21 | 79720 | 1196 | |
10067 | 10067 | Berkeley | Alameda | 1 | 2021-03-21 | 3404 | 45 | TRUE |
10068 | 10068 | Alpine | Alpine | 3 | 2021-03-21 | 86 | 0 | TRUE |
10069 | 10069 | Amador | Amador | 5 | 2021-03-21 | 3487 | 44 | |
10070 | 10070 | Butte | Butte | 7 | 2021-03-21 | 11208 | 171 | TRUE |
10071 | 10071 | Calaveras | Calaveras | 9 | 2021-03-21 | 1968 | 50 | TRUE |
10072 | 10072 | Colusa | Colusa | 11 | 2021-03-21 | 2156 | 15 | TRUE |
10073 | 10073 | Contra Costa | Contra Costa | 13 | 2021-03-21 | 64642 | 734 | |
10074 | 10074 | Del Norte | Del Norte | 15 | 2021-03-21 | 1095 | 5 | TRUE |
10075 | 10075 | El Dorado | El Dorado | 17 | 2021-03-21 | 9340 | 107 | TRUE |
10076 | 10076 | Fresno | Fresno | 19 | 2021-03-21 | 98237 | 1546 | TRUE |
10077 | 10077 | Glenn | Glenn | 21 | 2021-03-21 | 2229 | 24 | TRUE |
10078 | 10078 | Humboldt | Humboldt | 23 | 2021-03-21 | 3419 | 35 | TRUE |
10079 | 10079 | Imperial | Imperial | 25 | 2021-03-21 | 26851 | 691 | TRUE |
10080 | 10080 | Inyo | Inyo | 27 | 2021-03-21 | 1377 | 37 | TRUE |
10081 | 10081 | Kern | Kern | 29 | 2021-03-21 | 105499 | 1075 | |
10082 | 10082 | Kings | Kings | 31 | 2021-03-21 | 22511 | 238 | |
10083 | 10083 | Lake | Lake | 33 | 2021-03-21 | 3240 | 43 | TRUE |
10084 | 10084 | Lassen | Lassen | 35 | 2021-03-21 | 5634 | 25 | TRUE |
10085 | 10085 | Long Beach | Los Angeles | 37 | 2021-03-21 | 51709 | 887 | |
10086 | 10086 | Los Angeles | Los Angeles | 37 | 2021-03-21 | 1151389 | 21579 | |
10087 | 10087 | Pasadena | Los Angeles | 37 | 2021-03-21 | 11080 | 330 | TRUE |
10088 | 10088 | Madera | Madera | 39 | 2021-03-21 | 15788 | 226 | TRUE |
10089 | 10089 | Marin | Marin | 41 | 2021-03-21 | 13545 | 203 | |
10090 | 10090 | Mariposa | Mariposa | 43 | 2021-03-21 | 402 | 7 | TRUE |
10091 | 10091 | Mendocino | Mendocino | 45 | 2021-03-21 | 3908 | 46 | |
10092 | 10092 | Merced | Merced | 47 | 2021-03-21 | 30142 | 428 | TRUE |
10093 | 10093 | Modoc | Modoc | 49 | 2021-03-21 | 467 | 4 | TRUE |
10094 | 10094 | Mono | Mono | 51 | 2021-03-21 | 1242 | 4 | TRUE |
10095 | 10095 | Monterey | Monterey | 53 | 2021-03-21 | 42734 | 337 | TRUE |
10096 | 10096 | Napa | Napa | 55 | 2021-03-21 | 9247 | 74 | TRUE |
10097 | 10097 | Nevada | Nevada | 57 | 2021-03-21 | 4162 | 74 | TRUE |
10098 | 10098 | Orange | Orange | 59 | 2021-03-21 | 249539 | 4607 | |
10099 | 10099 | Placer | Placer | 61 | 2021-03-21 | 20493 | 244 | TRUE |
10100 | 10100 | Plumas | Plumas | 63 | 2021-03-21 | 670 | 6 | TRUE |
10101 | 10101 | Riverside | Riverside | 65 | 2021-03-21 | 292967 | 4117 | TRUE |
10102 | 10102 | Sacramento | Sacramento | 67 | 2021-03-21 | 95964 | 1576 | TRUE |
10103 | 10103 | San Benito | San Benito | 69 | 2021-03-21 | 5823 | 61 | |
10104 | 10104 | San Bernardino | San Bernardino | 71 | 2021-03-21 | 289773 | 4710 | |
10105 | 10105 | San Diego | San Diego | 73 | 2021-03-21 | 267728 | 3494 | |
10106 | 10106 | San Francisco | San Francisco | 75 | 2021-03-21 | 34710 | 451 | TRUE |
10107 | 10107 | San Joaquin | San Joaquin | 77 | 2021-03-21 | 68714 | 1229 | TRUE |
10108 | 10108 | San Luis Obispo | San Luis Obispo | 79 | 2021-03-21 | 20189 | 253 | TRUE |
10109 | 10109 | San Mateo | San Mateo | 81 | 2021-03-21 | 39742 | 543 | TRUE |
10110 | 10110 | Santa Barbara | Santa Barbara | 83 | 2021-03-21 | 32859 | 435 | |
10111 | 10111 | Santa Clara | Santa Clara | 85 | 2021-03-21 | 112853 | 1638 | |
10112 | 10112 | Santa Cruz | Santa Cruz | 87 | 2021-03-21 | 15196 | 197 | TRUE |
10113 | 10113 | Shasta | Shasta | 89 | 2021-03-21 | 11113 | 195 | TRUE |
10114 | 10114 | Sierra | Sierra | 91 | 2021-03-21 | 101 | 0 | TRUE |
10115 | 10115 | Siskiyou | Siskiyou | 93 | 2021-03-21 | 1850 | 14 | TRUE |
10116 | 10116 | Solano | Solano | 95 | 2021-03-21 | 30745 | 181 | TRUE |
10117 | 10117 | Sonoma | Sonoma | 97 | 2021-03-21 | 28981 | 308 | |
10118 | 10118 | Stanislaus | Stanislaus | 99 | 2021-03-21 | 52033 | 979 | TRUE |
10119 | 10119 | Sutter | Sutter | 101 | 2021-03-21 | 9042 | 101 | TRUE |
10120 | 10120 | Tehama | Tehama | 103 | 2021-03-21 | 5213 | 54 | TRUE |
10121 | 10121 | Trinity | Trinity | 105 | 2021-03-21 | 384 | 5 | TRUE |
10122 | 10122 | Tulare | Tulare | 107 | 2021-03-21 | 48770 | 793 | TRUE |
10123 | 10123 | Tuolumne | Tuolumne | 109 | 2021-03-21 | 4008 | 59 | TRUE |
10124 | 10124 | Ventura | Ventura | 111 | 2021-03-21 | 79090 | 943 | TRUE |
10125 | 10125 | Yolo | Yolo | 113 | 2021-03-21 | 13064 | 191 | TRUE |
10126 | 10126 | Yuba | Yuba | 115 | 2021-03-21 | 5903 | 40 | 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 );