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-15 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
2990 | 2990 | Alameda | Alameda | 1 | 2021-07-15 | 88013 | 1220 | |
2991 | 2991 | Berkeley | Alameda | 1 | 2021-07-15 | 3730 | 50 | |
2992 | 2992 | Alpine | Alpine | 3 | 2021-07-15 | 89 | 0 | TRUE |
2993 | 2993 | Amador | Amador | 5 | 2021-07-15 | 3751 | 48 | TRUE |
2994 | 2994 | Butte | Butte | 7 | 2021-07-15 | 12824 | 198 | TRUE |
2995 | 2995 | Calaveras | Calaveras | 9 | 2021-07-15 | 2253 | 58 | |
2996 | 2996 | Colusa | Colusa | 11 | 2021-07-15 | 2322 | 18 | TRUE |
2997 | 2997 | Contra Costa | Contra Costa | 13 | 2021-07-15 | 72602 | 822 | |
2998 | 2998 | Del Norte | Del Norte | 15 | 2021-07-15 | 1521 | 8 | |
2999 | 2999 | El Dorado | El Dorado | 17 | 2021-07-15 | 10657 | 118 | |
3000 | 3000 | Fresno | Fresno | 19 | 2021-07-15 | 102966 | 1730 | |
3001 | 3001 | Glenn | Glenn | 21 | 2021-07-15 | 2385 | 27 | |
3002 | 3002 | Humboldt | Humboldt | 23 | 2021-07-15 | 4711 | 53 | |
3003 | 3003 | Imperial | Imperial | 25 | 2021-07-15 | 28568 | 745 | |
3004 | 3004 | Inyo | Inyo | 27 | 2021-07-15 | 1446 | 38 | TRUE |
3005 | 3005 | Kern | Kern | 29 | 2021-07-15 | 111571 | 1413 | TRUE |
3006 | 3006 | Kings | Kings | 31 | 2021-07-15 | 23224 | 248 | |
3007 | 3007 | Lake | Lake | 33 | 2021-07-15 | 3755 | 63 | |
3008 | 3008 | Lassen | Lassen | 35 | 2021-07-15 | 5857 | 26 | |
3009 | 3009 | Long Beach | Los Angeles | 37 | 2021-07-15 | 54294 | 948 | |
3010 | 3010 | Los Angeles | Los Angeles | 37 | 2021-07-15 | 1196893 | 23268 | |
3011 | 3011 | Pasadena | Los Angeles | 37 | 2021-07-15 | 11484 | 351 | |
3012 | 3012 | Madera | Madera | 39 | 2021-07-15 | 16686 | 248 | |
3013 | 3013 | Marin | Marin | 41 | 2021-07-15 | 14422 | 213 | |
3014 | 3014 | Mariposa | Mariposa | 43 | 2021-07-15 | 471 | 7 | |
3015 | 3015 | Mendocino | Mendocino | 45 | 2021-07-15 | 4490 | 50 | |
3016 | 3016 | Merced | Merced | 47 | 2021-07-15 | 32582 | 483 | |
3017 | 3017 | Modoc | Modoc | 49 | 2021-07-15 | 573 | 7 | TRUE |
3018 | 3018 | Mono | Mono | 51 | 2021-07-15 | 1304 | 5 | TRUE |
3019 | 3019 | Monterey | Monterey | 53 | 2021-07-15 | 44113 | 518 | |
3020 | 3020 | Napa | Napa | 55 | 2021-07-15 | 10150 | 80 | |
3021 | 3021 | Nevada | Nevada | 57 | 2021-07-15 | 5067 | 75 | |
3022 | 3022 | Orange | Orange | 59 | 2021-07-15 | 257826 | 5133 | |
3023 | 3023 | Placer | Placer | 61 | 2021-07-15 | 24176 | 304 | TRUE |
3024 | 3024 | Plumas | Plumas | 63 | 2021-07-15 | 742 | 6 | TRUE |
3025 | 3025 | Riverside | Riverside | 65 | 2021-07-15 | 302069 | 4647 | |
3026 | 3026 | Sacramento | Sacramento | 67 | 2021-07-15 | 110781 | 1758 | |
3027 | 3027 | San Benito | San Benito | 69 | 2021-07-15 | 6200 | 63 | |
3028 | 3028 | San Bernardino | San Bernardino | 71 | 2021-07-15 | 302029 | 4855 | |
3029 | 3029 | San Diego | San Diego | 73 | 2021-07-15 | 285697 | 3786 | |
3030 | 3030 | San Francisco | San Francisco | 75 | 2021-07-15 | 37726 | 557 | |
3031 | 3031 | San Joaquin | San Joaquin | 77 | 2021-07-15 | 75500 | 1446 | TRUE |
3032 | 3032 | San Luis Obispo | San Luis Obispo | 79 | 2021-07-15 | 21588 | 264 | TRUE |
3033 | 3033 | San Mateo | San Mateo | 81 | 2021-07-15 | 43018 | 583 | |
3034 | 3034 | Santa Barbara | Santa Barbara | 83 | 2021-07-15 | 34896 | 458 | |
3035 | 3035 | Santa Clara | Santa Clara | 85 | 2021-07-15 | 120447 | 1702 | |
3036 | 3036 | Santa Cruz | Santa Cruz | 87 | 2021-07-15 | 16375 | 207 | |
3037 | 3037 | Shasta | Shasta | 89 | 2021-07-15 | 12614 | 238 | TRUE |
3038 | 3038 | Sierra | Sierra | 91 | 2021-07-15 | 124 | 0 | |
3039 | 3039 | Siskiyou | Siskiyou | 93 | 2021-07-15 | 2472 | 40 | |
3040 | 3040 | Solano | Solano | 95 | 2021-07-15 | 34461 | 245 | |
3041 | 3041 | Sonoma | Sonoma | 97 | 2021-07-15 | 31641 | 323 | |
3042 | 3042 | Stanislaus | Stanislaus | 99 | 2021-07-15 | 57804 | 1080 | |
3043 | 3043 | Sutter | Sutter | 101 | 2021-07-15 | 9855 | 108 | |
3044 | 3044 | Tehama | Tehama | 103 | 2021-07-15 | 5792 | 61 | |
3045 | 3045 | Trinity | Trinity | 105 | 2021-07-15 | 435 | 6 | |
3046 | 3046 | Tulare | Tulare | 107 | 2021-07-15 | 49964 | 852 | |
3047 | 3047 | Tuolumne | Tuolumne | 109 | 2021-07-15 | 4284 | 72 | |
3048 | 3048 | Ventura | Ventura | 111 | 2021-07-15 | 82160 | 1032 | TRUE |
3049 | 3049 | Yolo | Yolo | 113 | 2021-07-15 | 14315 | 211 | |
3050 | 3050 | Yuba | Yuba | 115 | 2021-07-15 | 6670 | 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 );