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-19 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 |
---|---|---|---|---|---|---|---|---|
2746 | 2746 | Alameda | Alameda | 1 | 2021-07-19 | 88806 | 1221 | |
2747 | 2747 | Berkeley | Alameda | 1 | 2021-07-19 | 3778 | 50 | |
2748 | 2748 | Alpine | Alpine | 3 | 2021-07-19 | 89 | 0 | TRUE |
2749 | 2749 | Amador | Amador | 5 | 2021-07-19 | 3765 | 48 | TRUE |
2750 | 2750 | Butte | Butte | 7 | 2021-07-19 | 12901 | 198 | TRUE |
2751 | 2751 | Calaveras | Calaveras | 9 | 2021-07-19 | 2256 | 58 | TRUE |
2752 | 2752 | Colusa | Colusa | 11 | 2021-07-19 | 2339 | 18 | |
2753 | 2753 | Contra Costa | Contra Costa | 13 | 2021-07-19 | 73290 | 823 | |
2754 | 2754 | Del Norte | Del Norte | 15 | 2021-07-19 | 1529 | 8 | |
2755 | 2755 | El Dorado | El Dorado | 17 | 2021-07-19 | 10740 | 118 | |
2756 | 2756 | Fresno | Fresno | 19 | 2021-07-19 | 103298 | 1731 | |
2757 | 2757 | Glenn | Glenn | 21 | 2021-07-19 | 2385 | 27 | TRUE |
2758 | 2758 | Humboldt | Humboldt | 23 | 2021-07-19 | 4775 | 53 | |
2759 | 2759 | Imperial | Imperial | 25 | 2021-07-19 | 28568 | 745 | TRUE |
2760 | 2760 | Inyo | Inyo | 27 | 2021-07-19 | 1446 | 38 | TRUE |
2761 | 2761 | Kern | Kern | 29 | 2021-07-19 | 111894 | 1416 | |
2762 | 2762 | Kings | Kings | 31 | 2021-07-19 | 23285 | 248 | |
2763 | 2763 | Lake | Lake | 33 | 2021-07-19 | 3820 | 64 | |
2764 | 2764 | Lassen | Lassen | 35 | 2021-07-19 | 5858 | 26 | TRUE |
2765 | 2765 | Long Beach | Los Angeles | 37 | 2021-07-19 | 54471 | 948 | |
2766 | 2766 | Los Angeles | Los Angeles | 37 | 2021-07-19 | 1203188 | 23286 | |
2767 | 2767 | Pasadena | Los Angeles | 37 | 2021-07-19 | 11558 | 351 | |
2768 | 2768 | Madera | Madera | 39 | 2021-07-19 | 16686 | 248 | TRUE |
2769 | 2769 | Marin | Marin | 41 | 2021-07-19 | 14492 | 213 | |
2770 | 2770 | Mariposa | Mariposa | 43 | 2021-07-19 | 473 | 7 | |
2771 | 2771 | Mendocino | Mendocino | 45 | 2021-07-19 | 4502 | 50 | TRUE |
2772 | 2772 | Merced | Merced | 47 | 2021-07-19 | 32782 | 484 | |
2773 | 2773 | Modoc | Modoc | 49 | 2021-07-19 | 573 | 7 | TRUE |
2774 | 2774 | Mono | Mono | 51 | 2021-07-19 | 1308 | 5 | |
2775 | 2775 | Monterey | Monterey | 53 | 2021-07-19 | 44159 | 518 | |
2776 | 2776 | Napa | Napa | 55 | 2021-07-19 | 10205 | 80 | |
2777 | 2777 | Nevada | Nevada | 57 | 2021-07-19 | 5142 | 75 | |
2778 | 2778 | Orange | Orange | 59 | 2021-07-19 | 259380 | 5135 | |
2779 | 2779 | Placer | Placer | 61 | 2021-07-19 | 24176 | 304 | TRUE |
2780 | 2780 | Plumas | Plumas | 63 | 2021-07-19 | 742 | 6 | TRUE |
2781 | 2781 | Riverside | Riverside | 65 | 2021-07-19 | 302069 | 4647 | TRUE |
2782 | 2782 | Sacramento | Sacramento | 67 | 2021-07-19 | 111553 | 1762 | |
2783 | 2783 | San Benito | San Benito | 69 | 2021-07-19 | 6217 | 63 | |
2784 | 2784 | San Bernardino | San Bernardino | 71 | 2021-07-19 | 302429 | 4856 | |
2785 | 2785 | San Diego | San Diego | 73 | 2021-07-19 | 287694 | 3786 | |
2786 | 2786 | San Francisco | San Francisco | 75 | 2021-07-19 | 38074 | 558 | |
2787 | 2787 | San Joaquin | San Joaquin | 77 | 2021-07-19 | 75500 | 1446 | TRUE |
2788 | 2788 | San Luis Obispo | San Luis Obispo | 79 | 2021-07-19 | 21588 | 264 | TRUE |
2789 | 2789 | San Mateo | San Mateo | 81 | 2021-07-19 | 43068 | 584 | TRUE |
2790 | 2790 | Santa Barbara | Santa Barbara | 83 | 2021-07-19 | 35024 | 459 | |
2791 | 2791 | Santa Clara | Santa Clara | 85 | 2021-07-19 | 121007 | 1706 | |
2792 | 2792 | Santa Cruz | Santa Cruz | 87 | 2021-07-19 | 16425 | 207 | |
2793 | 2793 | Shasta | Shasta | 89 | 2021-07-19 | 12728 | 242 | |
2794 | 2794 | Sierra | Sierra | 91 | 2021-07-19 | 124 | 0 | TRUE |
2795 | 2795 | Siskiyou | Siskiyou | 93 | 2021-07-19 | 2491 | 40 | |
2796 | 2796 | Solano | Solano | 95 | 2021-07-19 | 34761 | 245 | |
2797 | 2797 | Sonoma | Sonoma | 97 | 2021-07-19 | 31763 | 327 | TRUE |
2798 | 2798 | Stanislaus | Stanislaus | 99 | 2021-07-19 | 58122 | 1082 | |
2799 | 2799 | Sutter | Sutter | 101 | 2021-07-19 | 9913 | 108 | |
2800 | 2800 | Tehama | Tehama | 103 | 2021-07-19 | 5800 | 66 | TRUE |
2801 | 2801 | Trinity | Trinity | 105 | 2021-07-19 | 440 | 6 | |
2802 | 2802 | Tulare | Tulare | 107 | 2021-07-19 | 49964 | 852 | TRUE |
2803 | 2803 | Tuolumne | Tuolumne | 109 | 2021-07-19 | 4300 | 73 | |
2804 | 2804 | Ventura | Ventura | 111 | 2021-07-19 | 82584 | 1033 | |
2805 | 2805 | Yolo | Yolo | 113 | 2021-07-19 | 14426 | 211 | |
2806 | 2806 | Yuba | Yuba | 115 | 2021-07-19 | 6730 | 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 );