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-04-30 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 |
---|---|---|---|---|---|---|---|---|
7626 | 7626 | Alameda | Alameda | 1 | 2021-04-30 | 83542 | 1217 | |
7627 | 7627 | Berkeley | Alameda | 1 | 2021-04-30 | 3564 | 46 | |
7628 | 7628 | Alpine | Alpine | 3 | 2021-04-30 | 88 | 0 | |
7629 | 7629 | Amador | Amador | 5 | 2021-04-30 | 3615 | 47 | |
7630 | 7630 | Butte | Butte | 7 | 2021-04-30 | 11812 | 182 | |
7631 | 7631 | Calaveras | Calaveras | 9 | 2021-04-30 | 2095 | 52 | |
7632 | 7632 | Colusa | Colusa | 11 | 2021-04-30 | 2221 | 16 | |
7633 | 7633 | Contra Costa | Contra Costa | 13 | 2021-04-30 | 67957 | 783 | |
7634 | 7634 | Del Norte | Del Norte | 15 | 2021-04-30 | 1329 | 7 | |
7635 | 7635 | El Dorado | El Dorado | 17 | 2021-04-30 | 9964 | 110 | |
7636 | 7636 | Fresno | Fresno | 19 | 2021-04-30 | 100797 | 1667 | |
7637 | 7637 | Glenn | Glenn | 21 | 2021-04-30 | 2309 | 25 | |
7638 | 7638 | Humboldt | Humboldt | 23 | 2021-04-30 | 3852 | 38 | |
7639 | 7639 | Imperial | Imperial | 25 | 2021-04-30 | 27829 | 718 | |
7640 | 7640 | Inyo | Inyo | 27 | 2021-04-30 | 1422 | 38 | |
7641 | 7641 | Kern | Kern | 29 | 2021-04-30 | 108545 | 1353 | |
7642 | 7642 | Kings | Kings | 31 | 2021-04-30 | 22881 | 246 | |
7643 | 7643 | Lake | Lake | 33 | 2021-04-30 | 3422 | 43 | |
7644 | 7644 | Lassen | Lassen | 35 | 2021-04-30 | 5691 | 24 | |
7645 | 7645 | Long Beach | Los Angeles | 37 | 2021-04-30 | 52938 | 931 | |
7646 | 7646 | Los Angeles | Los Angeles | 37 | 2021-04-30 | 1168929 | 22615 | |
7647 | 7647 | Pasadena | Los Angeles | 37 | 2021-04-30 | 11224 | 346 | |
7648 | 7648 | Madera | Madera | 39 | 2021-04-30 | 16291 | 240 | |
7649 | 7649 | Marin | Marin | 41 | 2021-04-30 | 13961 | 209 | |
7650 | 7650 | Mariposa | Mariposa | 43 | 2021-04-30 | 441 | 7 | |
7651 | 7651 | Mendocino | Mendocino | 45 | 2021-04-30 | 4029 | 48 | |
7652 | 7652 | Merced | Merced | 47 | 2021-04-30 | 31594 | 454 | |
7653 | 7653 | Modoc | Modoc | 49 | 2021-04-30 | 493 | 4 | |
7654 | 7654 | Mono | Mono | 51 | 2021-04-30 | 1277 | 4 | |
7655 | 7655 | Monterey | Monterey | 53 | 2021-04-30 | 43454 | 381 | |
7656 | 7656 | Napa | Napa | 55 | 2021-04-30 | 9787 | 77 | |
7657 | 7657 | Nevada | Nevada | 57 | 2021-04-30 | 4602 | 75 | |
7658 | 7658 | Orange | Orange | 59 | 2021-04-30 | 253848 | 4957 | |
7659 | 7659 | Placer | Placer | 61 | 2021-04-30 | 22222 | 289 | |
7660 | 7660 | Plumas | Plumas | 63 | 2021-04-30 | 703 | 6 | |
7661 | 7661 | Riverside | Riverside | 65 | 2021-04-30 | 298450 | 4574 | |
7662 | 7662 | Sacramento | Sacramento | 67 | 2021-04-30 | 102959 | 1663 | |
7663 | 7663 | San Benito | San Benito | 69 | 2021-04-30 | 6018 | 63 | |
7664 | 7664 | San Bernardino | San Bernardino | 71 | 2021-04-30 | 295899 | 4791 | |
7665 | 7665 | San Diego | San Diego | 73 | 2021-04-30 | 276156 | 3702 | |
7666 | 7666 | San Francisco | San Francisco | 75 | 2021-04-30 | 36074 | 534 | |
7667 | 7667 | San Joaquin | San Joaquin | 77 | 2021-04-30 | 72478 | 1346 | |
7668 | 7668 | San Luis Obispo | San Luis Obispo | 79 | 2021-04-30 | 21192 | 260 | |
7669 | 7669 | San Mateo | San Mateo | 81 | 2021-04-30 | 41477 | 567 | |
7670 | 7670 | Santa Barbara | Santa Barbara | 83 | 2021-04-30 | 34180 | 450 | |
7671 | 7671 | Santa Clara | Santa Clara | 85 | 2021-04-30 | 117202 | 1680 | |
7672 | 7672 | Santa Cruz | Santa Cruz | 87 | 2021-04-30 | 15999 | 204 | |
7673 | 7673 | Shasta | Shasta | 89 | 2021-04-30 | 11901 | 220 | |
7674 | 7674 | Sierra | Sierra | 91 | 2021-04-30 | 110 | 0 | |
7675 | 7675 | Siskiyou | Siskiyou | 93 | 2021-04-30 | 2071 | 21 | |
7676 | 7676 | Solano | Solano | 95 | 2021-04-30 | 32477 | 215 | |
7677 | 7677 | Sonoma | Sonoma | 97 | 2021-04-30 | 29856 | 312 | |
7678 | 7678 | Stanislaus | Stanislaus | 99 | 2021-04-30 | 54810 | 1043 | |
7679 | 7679 | Sutter | Sutter | 101 | 2021-04-30 | 9366 | 104 | |
7680 | 7680 | Tehama | Tehama | 103 | 2021-04-30 | 5507 | 58 | |
7681 | 7681 | Trinity | Trinity | 105 | 2021-04-30 | 398 | 5 | |
7682 | 7682 | Tulare | Tulare | 107 | 2021-04-30 | 49471 | 834 | |
7683 | 7683 | Tuolumne | Tuolumne | 109 | 2021-04-30 | 4105 | 64 | |
7684 | 7684 | Ventura | Ventura | 111 | 2021-04-30 | 80617 | 1009 | |
7685 | 7685 | Yolo | Yolo | 113 | 2021-04-30 | 13678 | 205 | |
7686 | 7686 | Yuba | Yuba | 115 | 2021-04-30 | 6185 | 40 |
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 );