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-08-02 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 |
---|---|---|---|---|---|---|---|---|
1892 | 1892 | Alameda | Alameda | 1 | 2021-08-02 | 93117 | 1236 | |
1893 | 1893 | Berkeley | Alameda | 1 | 2021-08-02 | 4004 | 50 | |
1894 | 1894 | Alpine | Alpine | 3 | 2021-08-02 | 89 | 0 | TRUE |
1895 | 1895 | Amador | Amador | 5 | 2021-08-02 | 3899 | 48 | |
1896 | 1896 | Butte | Butte | 7 | 2021-08-02 | 13442 | 200 | TRUE |
1897 | 1897 | Calaveras | Calaveras | 9 | 2021-08-02 | 2321 | 58 | |
1898 | 1898 | Colusa | Colusa | 11 | 2021-08-02 | 2381 | 18 | |
1899 | 1899 | Contra Costa | Contra Costa | 13 | 2021-08-02 | 77866 | 834 | |
1900 | 1900 | Del Norte | Del Norte | 15 | 2021-08-02 | 1732 | 9 | |
1901 | 1901 | El Dorado | El Dorado | 17 | 2021-08-02 | 11288 | 120 | |
1902 | 1902 | Fresno | Fresno | 19 | 2021-08-02 | 105339 | 1746 | |
1903 | 1903 | Glenn | Glenn | 21 | 2021-08-02 | 2403 | 27 | |
1904 | 1904 | Humboldt | Humboldt | 23 | 2021-08-02 | 5114 | 53 | TRUE |
1905 | 1905 | Imperial | Imperial | 25 | 2021-08-02 | 28809 | 745 | TRUE |
1906 | 1906 | Inyo | Inyo | 27 | 2021-08-02 | 1473 | 38 | TRUE |
1907 | 1907 | Kern | Kern | 29 | 2021-08-02 | 113810 | 1426 | |
1908 | 1908 | Kings | Kings | 31 | 2021-08-02 | 23788 | 251 | |
1909 | 1909 | Lake | Lake | 33 | 2021-08-02 | 4294 | 65 | |
1910 | 1910 | Lassen | Lassen | 35 | 2021-08-02 | 5898 | 26 | |
1911 | 1911 | Long Beach | Los Angeles | 37 | 2021-08-02 | 56191 | 953 | |
1912 | 1912 | Los Angeles | Los Angeles | 37 | 2021-08-02 | 1237942 | 23385 | |
1913 | 1913 | Pasadena | Los Angeles | 37 | 2021-08-02 | 11946 | 352 | |
1914 | 1914 | Madera | Madera | 39 | 2021-08-02 | 16911 | 249 | |
1915 | 1915 | Marin | Marin | 41 | 2021-08-02 | 14982 | 214 | |
1916 | 1916 | Mariposa | Mariposa | 43 | 2021-08-02 | 521 | 7 | |
1917 | 1917 | Mendocino | Mendocino | 45 | 2021-08-02 | 4799 | 52 | |
1918 | 1918 | Merced | Merced | 47 | 2021-08-02 | 33321 | 485 | TRUE |
1919 | 1919 | Modoc | Modoc | 49 | 2021-08-02 | 576 | 7 | TRUE |
1920 | 1920 | Mono | Mono | 51 | 2021-08-02 | 1336 | 5 | |
1921 | 1921 | Monterey | Monterey | 53 | 2021-08-02 | 44591 | 528 | |
1922 | 1922 | Napa | Napa | 55 | 2021-08-02 | 10503 | 81 | |
1923 | 1923 | Nevada | Nevada | 57 | 2021-08-02 | 5540 | 75 | |
1924 | 1924 | Orange | Orange | 59 | 2021-08-02 | 266167 | 5143 | |
1925 | 1925 | Placer | Placer | 61 | 2021-08-02 | 25146 | 307 | TRUE |
1926 | 1926 | Plumas | Plumas | 63 | 2021-08-02 | 792 | 6 | |
1927 | 1927 | Riverside | Riverside | 65 | 2021-08-02 | 309217 | 4667 | |
1928 | 1928 | Sacramento | Sacramento | 67 | 2021-08-02 | 117126 | 1784 | |
1929 | 1929 | San Benito | San Benito | 69 | 2021-08-02 | 6303 | 63 | |
1930 | 1930 | San Bernardino | San Bernardino | 71 | 2021-08-02 | 308052 | 4856 | |
1931 | 1931 | San Diego | San Diego | 73 | 2021-08-02 | 299021 | 3798 | |
1932 | 1932 | San Francisco | San Francisco | 75 | 2021-08-02 | 40689 | 565 | |
1933 | 1933 | San Joaquin | San Joaquin | 77 | 2021-08-02 | 76915 | 1460 | TRUE |
1934 | 1934 | San Luis Obispo | San Luis Obispo | 79 | 2021-08-02 | 21970 | 265 | TRUE |
1935 | 1935 | San Mateo | San Mateo | 81 | 2021-08-02 | 44938 | 588 | |
1936 | 1936 | Santa Barbara | Santa Barbara | 83 | 2021-08-02 | 35953 | 463 | |
1937 | 1937 | Santa Clara | Santa Clara | 85 | 2021-08-02 | 124115 | 1709 | |
1938 | 1938 | Santa Cruz | Santa Cruz | 87 | 2021-08-02 | 16779 | 207 | |
1939 | 1939 | Shasta | Shasta | 89 | 2021-08-02 | 13068 | 242 | |
1940 | 1940 | Sierra | Sierra | 91 | 2021-08-02 | 133 | 0 | |
1941 | 1941 | Siskiyou | Siskiyou | 93 | 2021-08-02 | 2580 | 40 | |
1942 | 1942 | Solano | Solano | 95 | 2021-08-02 | 36249 | 249 | |
1943 | 1943 | Sonoma | Sonoma | 97 | 2021-08-02 | 32880 | 330 | TRUE |
1944 | 1944 | Stanislaus | Stanislaus | 99 | 2021-08-02 | 59636 | 1097 | |
1945 | 1945 | Sutter | Sutter | 101 | 2021-08-02 | 10311 | 111 | |
1946 | 1946 | Tehama | Tehama | 103 | 2021-08-02 | 5892 | 66 | |
1947 | 1947 | Trinity | Trinity | 105 | 2021-08-02 | 469 | 6 | |
1948 | 1948 | Tulare | Tulare | 107 | 2021-08-02 | 50703 | 853 | |
1949 | 1949 | Tuolumne | Tuolumne | 109 | 2021-08-02 | 4658 | 73 | |
1950 | 1950 | Ventura | Ventura | 111 | 2021-08-02 | 84320 | 1039 | |
1951 | 1951 | Yolo | Yolo | 113 | 2021-08-02 | 15039 | 213 | |
1952 | 1952 | Yuba | Yuba | 115 | 2021-08-02 | 7108 | 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 );