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-02-27 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 |
---|---|---|---|---|---|---|---|---|
11408 | 11408 | Alameda | Alameda | 1 | 2021-02-27 | 77655 | 1176 | |
11409 | 11409 | Berkeley | Alameda | 1 | 2021-02-27 | 3265 | 45 | |
11410 | 11410 | Alpine | Alpine | 3 | 2021-02-27 | 82 | 0 | TRUE |
11411 | 11411 | Amador | Amador | 5 | 2021-02-27 | 3429 | 41 | |
11412 | 11412 | Butte | Butte | 7 | 2021-02-27 | 10962 | 160 | TRUE |
11413 | 11413 | Calaveras | Calaveras | 9 | 2021-02-27 | 1905 | 47 | TRUE |
11414 | 11414 | Colusa | Colusa | 11 | 2021-02-27 | 2129 | 13 | TRUE |
11415 | 11415 | Contra Costa | Contra Costa | 13 | 2021-02-27 | 62507 | 681 | |
11416 | 11416 | Del Norte | Del Norte | 15 | 2021-02-27 | 1001 | 5 | |
11417 | 11417 | El Dorado | El Dorado | 17 | 2021-02-27 | 9120 | 100 | TRUE |
11418 | 11418 | Fresno | Fresno | 19 | 2021-02-27 | 95739 | 1443 | |
11419 | 11419 | Glenn | Glenn | 21 | 2021-02-27 | 2181 | 23 | TRUE |
11420 | 11420 | Humboldt | Humboldt | 23 | 2021-02-27 | 3180 | 33 | TRUE |
11421 | 11421 | Imperial | Imperial | 25 | 2021-02-27 | 26594 | 593 | |
11422 | 11422 | Inyo | Inyo | 27 | 2021-02-27 | 1298 | 37 | TRUE |
11423 | 11423 | Kern | Kern | 29 | 2021-02-27 | 103143 | 827 | |
11424 | 11424 | Kings | Kings | 31 | 2021-02-27 | 22042 | 218 | |
11425 | 11425 | Lake | Lake | 33 | 2021-02-27 | 3117 | 41 | TRUE |
11426 | 11426 | Lassen | Lassen | 35 | 2021-02-27 | 5601 | 19 | TRUE |
11427 | 11427 | Long Beach | Los Angeles | 37 | 2021-02-27 | 51226 | 837 | |
11428 | 11428 | Los Angeles | Los Angeles | 37 | 2021-02-27 | 1128837 | 20182 | |
11429 | 11429 | Pasadena | Los Angeles | 37 | 2021-02-27 | 10877 | 314 | |
11430 | 11430 | Madera | Madera | 39 | 2021-02-27 | 15356 | 209 | TRUE |
11431 | 11431 | Marin | Marin | 41 | 2021-02-27 | 13193 | 197 | |
11432 | 11432 | Mariposa | Mariposa | 43 | 2021-02-27 | 395 | 7 | |
11433 | 11433 | Mendocino | Mendocino | 45 | 2021-02-27 | 3805 | 43 | |
11434 | 11434 | Merced | Merced | 47 | 2021-02-27 | 28971 | 397 | |
11435 | 11435 | Modoc | Modoc | 49 | 2021-02-27 | 453 | 4 | TRUE |
11436 | 11436 | Mono | Mono | 51 | 2021-02-27 | 1211 | 4 | TRUE |
11437 | 11437 | Monterey | Monterey | 53 | 2021-02-27 | 42261 | 328 | |
11438 | 11438 | Napa | Napa | 55 | 2021-02-27 | 8973 | 66 | TRUE |
11439 | 11439 | Nevada | Nevada | 57 | 2021-02-27 | 3940 | 74 | TRUE |
11440 | 11440 | Orange | Orange | 59 | 2021-02-27 | 246264 | 3904 | |
11441 | 11441 | Placer | Placer | 61 | 2021-02-27 | 19763 | 232 | TRUE |
11442 | 11442 | Plumas | Plumas | 63 | 2021-02-27 | 653 | 6 | TRUE |
11443 | 11443 | Riverside | Riverside | 65 | 2021-02-27 | 289450 | 3767 | TRUE |
11444 | 11444 | Sacramento | Sacramento | 67 | 2021-02-27 | 93160 | 1472 | TRUE |
11445 | 11445 | San Benito | San Benito | 69 | 2021-02-27 | 5676 | 59 | |
11446 | 11446 | San Bernardino | San Bernardino | 71 | 2021-02-27 | 286291 | 4613 | |
11447 | 11447 | San Diego | San Diego | 73 | 2021-02-27 | 260094 | 3284 | |
11448 | 11448 | San Francisco | San Francisco | 75 | 2021-02-27 | 33970 | 412 | |
11449 | 11449 | San Joaquin | San Joaquin | 77 | 2021-02-27 | 66709 | 1101 | TRUE |
11450 | 11450 | San Luis Obispo | San Luis Obispo | 79 | 2021-02-27 | 19643 | 227 | TRUE |
11451 | 11451 | San Mateo | San Mateo | 81 | 2021-02-27 | 38729 | 515 | |
11452 | 11452 | Santa Barbara | Santa Barbara | 83 | 2021-02-27 | 31951 | 411 | |
11453 | 11453 | Santa Clara | Santa Clara | 85 | 2021-02-27 | 110053 | 1589 | |
11454 | 11454 | Santa Cruz | Santa Cruz | 87 | 2021-02-27 | 14628 | 183 | |
11455 | 11455 | Shasta | Shasta | 89 | 2021-02-27 | 10996 | 174 | |
11456 | 11456 | Sierra | Sierra | 91 | 2021-02-27 | 99 | 0 | TRUE |
11457 | 11457 | Siskiyou | Siskiyou | 93 | 2021-02-27 | 1755 | 14 | TRUE |
11458 | 11458 | Solano | Solano | 95 | 2021-02-27 | 30024 | 164 | TRUE |
11459 | 11459 | Sonoma | Sonoma | 97 | 2021-02-27 | 28053 | 298 | |
11460 | 11460 | Stanislaus | Stanislaus | 99 | 2021-02-27 | 50401 | 946 | |
11461 | 11461 | Sutter | Sutter | 101 | 2021-02-27 | 8860 | 97 | TRUE |
11462 | 11462 | Tehama | Tehama | 103 | 2021-02-27 | 5086 | 52 | TRUE |
11463 | 11463 | Trinity | Trinity | 105 | 2021-02-27 | 370 | 5 | TRUE |
11464 | 11464 | Tulare | Tulare | 107 | 2021-02-27 | 47869 | 758 | TRUE |
11465 | 11465 | Tuolumne | Tuolumne | 109 | 2021-02-27 | 3950 | 59 | TRUE |
11466 | 11466 | Ventura | Ventura | 111 | 2021-02-27 | 77256 | 844 | |
11467 | 11467 | Yolo | Yolo | 113 | 2021-02-27 | 12661 | 185 | TRUE |
11468 | 11468 | Yuba | Yuba | 115 | 2021-02-27 | 5750 | 37 | 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 );