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-01-23 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 |
---|---|---|---|---|---|---|---|---|
13543 | 13543 | Alameda | Alameda | 1 | 2021-01-23 | 68003 | 1067 | |
13544 | 13544 | Berkeley | Alameda | 1 | 2021-01-23 | 2520 | 42 | |
13545 | 13545 | Alpine | Alpine | 3 | 2021-01-23 | 73 | 0 | TRUE |
13546 | 13546 | Amador | Amador | 5 | 2021-01-23 | 3011 | 32 | |
13547 | 13547 | Butte | Butte | 7 | 2021-01-23 | 9757 | 134 | TRUE |
13548 | 13548 | Calaveras | Calaveras | 9 | 2021-01-23 | 1407 | 23 | TRUE |
13549 | 13549 | Colusa | Colusa | 11 | 2021-01-23 | 1854 | 9 | TRUE |
13550 | 13550 | Contra Costa | Contra Costa | 13 | 2021-01-23 | 54416 | 487 | |
13551 | 13551 | Del Norte | Del Norte | 15 | 2021-01-23 | 873 | 2 | |
13552 | 13552 | El Dorado | El Dorado | 17 | 2021-01-23 | 8002 | 59 | TRUE |
13553 | 13553 | Fresno | Fresno | 19 | 2021-01-23 | 88578 | 1043 | |
13554 | 13554 | Glenn | Glenn | 21 | 2021-01-23 | 1927 | 22 | |
13555 | 13555 | Humboldt | Humboldt | 23 | 2021-01-23 | 2494 | 25 | TRUE |
13556 | 13556 | Imperial | Imperial | 25 | 2021-01-23 | 25445 | 493 | TRUE |
13557 | 13557 | Inyo | Inyo | 27 | 2021-01-23 | 1007 | 29 | TRUE |
13558 | 13558 | Kern | Kern | 29 | 2021-01-23 | 89095 | 590 | |
13559 | 13559 | Kings | Kings | 31 | 2021-01-23 | 19703 | 160 | TRUE |
13560 | 13560 | Lake | Lake | 33 | 2021-01-23 | 2656 | 32 | TRUE |
13561 | 13561 | Lassen | Lassen | 35 | 2021-01-23 | 5269 | 16 | |
13562 | 13562 | Long Beach | Los Angeles | 37 | 2021-01-23 | 46281 | 596 | |
13563 | 13563 | Los Angeles | Los Angeles | 37 | 2021-01-23 | 1009493 | 14364 | |
13564 | 13564 | Pasadena | Los Angeles | 37 | 2021-01-23 | 9731 | 224 | |
13565 | 13565 | Madera | Madera | 39 | 2021-01-23 | 13583 | 151 | TRUE |
13566 | 13566 | Marin | Marin | 41 | 2021-01-23 | 11930 | 163 | |
13567 | 13567 | Mariposa | Mariposa | 43 | 2021-01-23 | 346 | 4 | TRUE |
13568 | 13568 | Mendocino | Mendocino | 45 | 2021-01-23 | 3256 | 35 | |
13569 | 13569 | Merced | Merced | 47 | 2021-01-23 | 25048 | 324 | TRUE |
13570 | 13570 | Modoc | Modoc | 49 | 2021-01-23 | 387 | 3 | |
13571 | 13571 | Mono | Mono | 51 | 2021-01-23 | 1135 | 4 | TRUE |
13572 | 13572 | Monterey | Monterey | 53 | 2021-01-23 | 37285 | 259 | |
13573 | 13573 | Napa | Napa | 55 | 2021-01-23 | 7761 | 45 | TRUE |
13574 | 13574 | Nevada | Nevada | 57 | 2021-01-23 | 3292 | 73 | TRUE |
13575 | 13575 | Orange | Orange | 59 | 2021-01-23 | 221493 | 2625 | |
13576 | 13576 | Placer | Placer | 61 | 2021-01-23 | 17675 | 188 | TRUE |
13577 | 13577 | Plumas | Plumas | 63 | 2021-01-23 | 605 | 5 | TRUE |
13578 | 13578 | Riverside | Riverside | 65 | 2021-01-23 | 258352 | 2777 | TRUE |
13579 | 13579 | Sacramento | Sacramento | 67 | 2021-01-23 | 82066 | 1157 | TRUE |
13580 | 13580 | San Benito | San Benito | 69 | 2021-01-23 | 5134 | 48 | |
13581 | 13581 | San Bernardino | San Bernardino | 71 | 2021-01-23 | 262858 | 3896 | |
13582 | 13582 | San Diego | San Diego | 73 | 2021-01-23 | 225558 | 2344 | |
13583 | 13583 | San Francisco | San Francisco | 75 | 2021-01-23 | 29601 | 278 | |
13584 | 13584 | San Joaquin | San Joaquin | 77 | 2021-01-23 | 59395 | 808 | TRUE |
13585 | 13585 | San Luis Obispo | San Luis Obispo | 79 | 2021-01-23 | 16437 | 151 | TRUE |
13586 | 13586 | San Mateo | San Mateo | 81 | 2021-01-23 | 33731 | 340 | |
13587 | 13587 | Santa Barbara | Santa Barbara | 83 | 2021-01-23 | 26514 | 264 | |
13588 | 13588 | Santa Clara | Santa Clara | 85 | 2021-01-23 | 98941 | 1290 | TRUE |
13589 | 13589 | Santa Cruz | Santa Cruz | 87 | 2021-01-23 | 12649 | 130 | TRUE |
13590 | 13590 | Shasta | Shasta | 89 | 2021-01-23 | 9920 | 129 | TRUE |
13591 | 13591 | Sierra | Sierra | 91 | 2021-01-23 | 88 | 0 | TRUE |
13592 | 13592 | Siskiyou | Siskiyou | 93 | 2021-01-23 | 1484 | 13 | TRUE |
13593 | 13593 | Solano | Solano | 95 | 2021-01-23 | 26494 | 111 | TRUE |
13594 | 13594 | Sonoma | Sonoma | 97 | 2021-01-23 | 24761 | 247 | |
13595 | 13595 | Stanislaus | Stanislaus | 99 | 2021-01-23 | 43938 | 788 | |
13596 | 13596 | Sutter | Sutter | 101 | 2021-01-23 | 7927 | 83 | TRUE |
13597 | 13597 | Tehama | Tehama | 103 | 2021-01-23 | 4468 | 46 | |
13598 | 13598 | Trinity | Trinity | 105 | 2021-01-23 | 305 | 4 | TRUE |
13599 | 13599 | Tulare | Tulare | 107 | 2021-01-23 | 42759 | 531 | TRUE |
13600 | 13600 | Tuolumne | Tuolumne | 109 | 2021-01-23 | 3443 | 40 | TRUE |
13601 | 13601 | Ventura | Ventura | 111 | 2021-01-23 | 63893 | 507 | TRUE |
13602 | 13602 | Yolo | Yolo | 113 | 2021-01-23 | 10966 | 138 | |
13603 | 13603 | Yuba | Yuba | 115 | 2021-01-23 | 5049 | 29 | 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 );