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-06-17 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update, date (date)
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
4698 | 4698 | Alameda | Alameda | 1 | 2021-06-17 | 85920 | 1217 | |
4699 | 4699 | Berkeley | Alameda | 1 | 2021-06-17 | 3642 | 46 | |
4700 | 4700 | Alpine | Alpine | 3 | 2021-06-17 | 89 | 0 | TRUE |
4701 | 4701 | Amador | Amador | 5 | 2021-06-17 | 3685 | 47 | TRUE |
4702 | 4702 | Butte | Butte | 7 | 2021-06-17 | 12644 | 192 | TRUE |
4703 | 4703 | Calaveras | Calaveras | 9 | 2021-06-17 | 2201 | 56 | |
4704 | 4704 | Colusa | Colusa | 11 | 2021-06-17 | 2284 | 18 | TRUE |
4705 | 4705 | Contra Costa | Contra Costa | 13 | 2021-06-17 | 70478 | 808 | |
4706 | 4706 | Del Norte | Del Norte | 15 | 2021-06-17 | 1454 | 7 | TRUE |
4707 | 4707 | El Dorado | El Dorado | 17 | 2021-06-17 | 10363 | 116 | |
4708 | 4708 | Fresno | Fresno | 19 | 2021-06-17 | 102265 | 1722 | |
4709 | 4709 | Glenn | Glenn | 21 | 2021-06-17 | 2360 | 27 | |
4710 | 4710 | Humboldt | Humboldt | 23 | 2021-06-17 | 4462 | 48 | |
4711 | 4711 | Imperial | Imperial | 25 | 2021-06-17 | 28295 | 741 | |
4712 | 4712 | Inyo | Inyo | 27 | 2021-06-17 | 1434 | 38 | TRUE |
4713 | 4713 | Kern | Kern | 29 | 2021-06-17 | 110710 | 1401 | |
4714 | 4714 | Kings | Kings | 31 | 2021-06-17 | 23093 | 247 | |
4715 | 4715 | Lake | Lake | 33 | 2021-06-17 | 3553 | 45 | |
4716 | 4716 | Lassen | Lassen | 35 | 2021-06-17 | 5799 | 24 | TRUE |
4717 | 4717 | Long Beach | Los Angeles | 37 | 2021-06-17 | 53515 | 945 | TRUE |
4718 | 4718 | Los Angeles | Los Angeles | 37 | 2021-06-17 | 1182201 | 23134 | |
4719 | 4719 | Pasadena | Los Angeles | 37 | 2021-06-17 | 11317 | 349 | |
4720 | 4720 | Madera | Madera | 39 | 2021-06-17 | 16493 | 245 | TRUE |
4721 | 4721 | Marin | Marin | 41 | 2021-06-17 | 14185 | 212 | TRUE |
4722 | 4722 | Mariposa | Mariposa | 43 | 2021-06-17 | 465 | 7 | |
4723 | 4723 | Mendocino | Mendocino | 45 | 2021-06-17 | 4306 | 50 | |
4724 | 4724 | Merced | Merced | 47 | 2021-06-17 | 32284 | 477 | |
4725 | 4725 | Modoc | Modoc | 49 | 2021-06-17 | 556 | 5 | |
4726 | 4726 | Mono | Mono | 51 | 2021-06-17 | 1295 | 4 | |
4727 | 4727 | Monterey | Monterey | 53 | 2021-06-17 | 43819 | 421 | |
4728 | 4728 | Napa | Napa | 55 | 2021-06-17 | 10003 | 79 | |
4729 | 4729 | Nevada | Nevada | 57 | 2021-06-17 | 4903 | 75 | |
4730 | 4730 | Orange | Orange | 59 | 2021-06-17 | 255771 | 5102 | |
4731 | 4731 | Placer | Placer | 61 | 2021-06-17 | 23477 | 299 | |
4732 | 4732 | Plumas | Plumas | 63 | 2021-06-17 | 736 | 6 | |
4733 | 4733 | Riverside | Riverside | 65 | 2021-06-17 | 301543 | 4625 | |
4734 | 4734 | Sacramento | Sacramento | 67 | 2021-06-17 | 107560 | 1730 | |
4735 | 4735 | San Benito | San Benito | 69 | 2021-06-17 | 6109 | 63 | |
4736 | 4736 | San Bernardino | San Bernardino | 71 | 2021-06-17 | 299151 | 4836 | |
4737 | 4737 | San Diego | San Diego | 73 | 2021-06-17 | 281530 | 3770 | |
4738 | 4738 | San Francisco | San Francisco | 75 | 2021-06-17 | 36892 | 550 | |
4739 | 4739 | San Joaquin | San Joaquin | 77 | 2021-06-17 | 74629 | 1438 | |
4740 | 4740 | San Luis Obispo | San Luis Obispo | 79 | 2021-06-17 | 21421 | 261 | TRUE |
4741 | 4741 | San Mateo | San Mateo | 81 | 2021-06-17 | 42284 | 581 | |
4742 | 4742 | Santa Barbara | Santa Barbara | 83 | 2021-06-17 | 34593 | 455 | |
4743 | 4743 | Santa Clara | Santa Clara | 85 | 2021-06-17 | 118880 | 1696 | |
4744 | 4744 | Santa Cruz | Santa Cruz | 87 | 2021-06-17 | 16232 | 207 | |
4745 | 4745 | Shasta | Shasta | 89 | 2021-06-17 | 12605 | 233 | TRUE |
4746 | 4746 | Sierra | Sierra | 91 | 2021-06-17 | 113 | 0 | TRUE |
4747 | 4747 | Siskiyou | Siskiyou | 93 | 2021-06-17 | 2393 | 37 | |
4748 | 4748 | Solano | Solano | 95 | 2021-06-17 | 33673 | 244 | |
4749 | 4749 | Sonoma | Sonoma | 97 | 2021-06-17 | 30825 | 316 | |
4750 | 4750 | Stanislaus | Stanislaus | 99 | 2021-06-17 | 56701 | 1069 | |
4751 | 4751 | Sutter | Sutter | 101 | 2021-06-17 | 9650 | 106 | |
4752 | 4752 | Tehama | Tehama | 103 | 2021-06-17 | 5727 | 59 | |
4753 | 4753 | Trinity | Trinity | 105 | 2021-06-17 | 422 | 5 | TRUE |
4754 | 4754 | Tulare | Tulare | 107 | 2021-06-17 | 49776 | 849 | |
4755 | 4755 | Tuolumne | Tuolumne | 109 | 2021-06-17 | 4207 | 71 | |
4756 | 4756 | Ventura | Ventura | 111 | 2021-06-17 | 81609 | 1025 | TRUE |
4757 | 4757 | Yolo | Yolo | 113 | 2021-06-17 | 14079 | 209 | |
4758 | 4758 | Yuba | Yuba | 115 | 2021-06-17 | 6464 | 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 );