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-01 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 |
---|---|---|---|---|---|---|---|---|
1953 | 1953 | Alameda | Alameda | 1 | 2021-08-01 | 91889 | 1232 | TRUE |
1954 | 1954 | Berkeley | Alameda | 1 | 2021-08-01 | 3963 | 50 | |
1955 | 1955 | Alpine | Alpine | 3 | 2021-08-01 | 89 | 0 | TRUE |
1956 | 1956 | Amador | Amador | 5 | 2021-08-01 | 3873 | 48 | TRUE |
1957 | 1957 | Butte | Butte | 7 | 2021-08-01 | 13406 | 200 | TRUE |
1958 | 1958 | Calaveras | Calaveras | 9 | 2021-08-01 | 2316 | 58 | TRUE |
1959 | 1959 | Colusa | Colusa | 11 | 2021-08-01 | 2357 | 18 | TRUE |
1960 | 1960 | Contra Costa | Contra Costa | 13 | 2021-08-01 | 77708 | 834 | |
1961 | 1961 | Del Norte | Del Norte | 15 | 2021-08-01 | 1668 | 8 | TRUE |
1962 | 1962 | El Dorado | El Dorado | 17 | 2021-08-01 | 11125 | 120 | TRUE |
1963 | 1963 | Fresno | Fresno | 19 | 2021-08-01 | 104639 | 1746 | TRUE |
1964 | 1964 | Glenn | Glenn | 21 | 2021-08-01 | 2399 | 27 | TRUE |
1965 | 1965 | Humboldt | Humboldt | 23 | 2021-08-01 | 5114 | 53 | TRUE |
1966 | 1966 | Imperial | Imperial | 25 | 2021-08-01 | 28809 | 745 | TRUE |
1967 | 1967 | Inyo | Inyo | 27 | 2021-08-01 | 1473 | 38 | TRUE |
1968 | 1968 | Kern | Kern | 29 | 2021-08-01 | 113216 | 1425 | TRUE |
1969 | 1969 | Kings | Kings | 31 | 2021-08-01 | 23765 | 251 | |
1970 | 1970 | Lake | Lake | 33 | 2021-08-01 | 4238 | 65 | TRUE |
1971 | 1971 | Lassen | Lassen | 35 | 2021-08-01 | 5888 | 26 | TRUE |
1972 | 1972 | Long Beach | Los Angeles | 37 | 2021-08-01 | 55885 | 953 | TRUE |
1973 | 1973 | Los Angeles | Los Angeles | 37 | 2021-08-01 | 1235581 | 23380 | |
1974 | 1974 | Pasadena | Los Angeles | 37 | 2021-08-01 | 11877 | 352 | TRUE |
1975 | 1975 | Madera | Madera | 39 | 2021-08-01 | 16911 | 249 | TRUE |
1976 | 1976 | Marin | Marin | 41 | 2021-08-01 | 14958 | 214 | |
1977 | 1977 | Mariposa | Mariposa | 43 | 2021-08-01 | 500 | 7 | TRUE |
1978 | 1978 | Mendocino | Mendocino | 45 | 2021-08-01 | 4710 | 52 | TRUE |
1979 | 1979 | Merced | Merced | 47 | 2021-08-01 | 33321 | 485 | TRUE |
1980 | 1980 | Modoc | Modoc | 49 | 2021-08-01 | 576 | 7 | TRUE |
1981 | 1981 | Mono | Mono | 51 | 2021-08-01 | 1326 | 5 | TRUE |
1982 | 1982 | Monterey | Monterey | 53 | 2021-08-01 | 44523 | 528 | TRUE |
1983 | 1983 | Napa | Napa | 55 | 2021-08-01 | 10442 | 81 | TRUE |
1984 | 1984 | Nevada | Nevada | 57 | 2021-08-01 | 5416 | 75 | TRUE |
1985 | 1985 | Orange | Orange | 59 | 2021-08-01 | 264171 | 5141 | TRUE |
1986 | 1986 | Placer | Placer | 61 | 2021-08-01 | 25146 | 307 | TRUE |
1987 | 1987 | Plumas | Plumas | 63 | 2021-08-01 | 772 | 6 | TRUE |
1988 | 1988 | Riverside | Riverside | 65 | 2021-08-01 | 308546 | 4662 | TRUE |
1989 | 1989 | Sacramento | Sacramento | 67 | 2021-08-01 | 115732 | 1781 | TRUE |
1990 | 1990 | San Benito | San Benito | 69 | 2021-08-01 | 6282 | 63 | TRUE |
1991 | 1991 | San Bernardino | San Bernardino | 71 | 2021-08-01 | 306769 | 4856 | |
1992 | 1992 | San Diego | San Diego | 73 | 2021-08-01 | 298002 | 3798 | |
1993 | 1993 | San Francisco | San Francisco | 75 | 2021-08-01 | 40544 | 563 | |
1994 | 1994 | San Joaquin | San Joaquin | 77 | 2021-08-01 | 76915 | 1460 | TRUE |
1995 | 1995 | San Luis Obispo | San Luis Obispo | 79 | 2021-08-01 | 21970 | 265 | TRUE |
1996 | 1996 | San Mateo | San Mateo | 81 | 2021-08-01 | 44430 | 588 | TRUE |
1997 | 1997 | Santa Barbara | Santa Barbara | 83 | 2021-08-01 | 35741 | 462 | TRUE |
1998 | 1998 | Santa Clara | Santa Clara | 85 | 2021-08-01 | 123404 | 1709 | TRUE |
1999 | 1999 | Santa Cruz | Santa Cruz | 87 | 2021-08-01 | 16616 | 207 | TRUE |
2000 | 2000 | Shasta | Shasta | 89 | 2021-08-01 | 13043 | 242 | TRUE |
2001 | 2001 | Sierra | Sierra | 91 | 2021-08-01 | 131 | 0 | TRUE |
2002 | 2002 | Siskiyou | Siskiyou | 93 | 2021-08-01 | 2566 | 40 | TRUE |
2003 | 2003 | Solano | Solano | 95 | 2021-08-01 | 36004 | 249 | TRUE |
2004 | 2004 | Sonoma | Sonoma | 97 | 2021-08-01 | 32880 | 330 | |
2005 | 2005 | Stanislaus | Stanislaus | 99 | 2021-08-01 | 59226 | 1095 | TRUE |
2006 | 2006 | Sutter | Sutter | 101 | 2021-08-01 | 10203 | 111 | TRUE |
2007 | 2007 | Tehama | Tehama | 103 | 2021-08-01 | 5892 | 66 | TRUE |
2008 | 2008 | Trinity | Trinity | 105 | 2021-08-01 | 467 | 6 | TRUE |
2009 | 2009 | Tulare | Tulare | 107 | 2021-08-01 | 50278 | 853 | TRUE |
2010 | 2010 | Tuolumne | Tuolumne | 109 | 2021-08-01 | 4535 | 73 | TRUE |
2011 | 2011 | Ventura | Ventura | 111 | 2021-08-01 | 83869 | 1036 | TRUE |
2012 | 2012 | Yolo | Yolo | 113 | 2021-08-01 | 14863 | 213 | TRUE |
2013 | 2013 | Yuba | Yuba | 115 | 2021-08-01 | 7004 | 41 | 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 );