latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
1,251,796 rows sorted by id descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Los Angeles 359,354
- San Diego 110,660
- Riverside 64,576
- San Bernardino 64,384
- Alameda 54,961
- Kern 46,850
- Orange 41,369
- Marin 38,478
- Sonoma 33,120
- Fresno 31,712
- Placer 31,264
- Contra Costa 29,970
- San Mateo 29,010
- Tulare 28,140
- San Francisco 26,520
- Monterey 25,407
- Ventura 24,575
- San Luis Obispo 22,374
- Napa 17,730
- Imperial 16,660
- Nevada 15,657
- Santa Clara 14,940
- Lake 12,045
- Santa Barbara 11,110
- Merced 10,140
- Calaveras 9,036
- Kings 8,829
- Sacramento 8,016
- Solano 7,936
- Stanislaus 7,780
- …
Link | rowid | id ▲ | name | date | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
1216973 | 1216973 | unincorporated | Other | 2020-04-26 | Stanislaus | 99 | 51 | ||
1218019 | 1218019 | unincorporated | Other | 2020-04-25 | Stanislaus | 99 | 48 | ||
1219048 | 1219048 | unincorporated | Other | 2020-04-24 | Stanislaus | 99 | 48 | ||
1220056 | 1220056 | unincorporated | Other | 2020-04-23 | Stanislaus | 99 | 48 | ||
1221064 | 1221064 | unincorporated | Other | 2020-04-22 | Stanislaus | 99 | 46 | ||
1222072 | 1222072 | unincorporated | Other | 2020-04-21 | Stanislaus | 99 | 40 | ||
1223055 | 1223055 | unincorporated | Other | 2020-04-20 | Stanislaus | 99 | 40 | ||
1224020 | 1224020 | unincorporated | Other | 2020-04-19 | Stanislaus | 99 | 40 | ||
1224985 | 1224985 | unincorporated | Other | 2020-04-18 | Stanislaus | 99 | 40 | ||
1225950 | 1225950 | unincorporated | Other | 2020-04-17 | Stanislaus | 99 | 31 | ||
1226915 | 1226915 | unincorporated | Other | 2020-04-16 | Stanislaus | 99 | 31 | ||
1227880 | 1227880 | unincorporated | Other | 2020-04-15 | Stanislaus | 99 | 29 | ||
487 | 487 | Yucca Valley | Yucca Valley | 2022-12-30 | San Bernardino | 71 | 5034 | 22146 | |
1315 | 1315 | Yucca Valley | Yucca Valley | 2022-12-29 | San Bernardino | 71 | 5034 | 22146 | |
2496 | 2496 | Yucca Valley | Yucca Valley | 2022-12-28 | San Bernardino | 71 | 5034 | 22146 | |
3677 | 3677 | Yucca Valley | Yucca Valley | 2022-12-27 | San Bernardino | 71 | 5034 | 22146 | |
4858 | 4858 | Yucca Valley | Yucca Valley | 2022-12-26 | San Bernardino | 71 | 5034 | 22146 | |
6039 | 6039 | Yucca Valley | Yucca Valley | 2022-12-25 | San Bernardino | 71 | 5034 | 22146 | |
7220 | 7220 | Yucca Valley | Yucca Valley | 2022-12-24 | San Bernardino | 71 | 5034 | 22146 | |
8401 | 8401 | Yucca Valley | Yucca Valley | 2022-12-23 | San Bernardino | 71 | 5034 | 22146 | |
9582 | 9582 | Yucca Valley | Yucca Valley | 2022-12-22 | San Bernardino | 71 | 5034 | 22146 | |
10763 | 10763 | Yucca Valley | Yucca Valley | 2022-12-21 | San Bernardino | 71 | 5004 | 22146 | |
11944 | 11944 | Yucca Valley | Yucca Valley | 2022-12-20 | San Bernardino | 71 | 5004 | 22146 | |
13125 | 13125 | Yucca Valley | Yucca Valley | 2022-12-19 | San Bernardino | 71 | 5004 | 22146 | |
14306 | 14306 | Yucca Valley | Yucca Valley | 2022-12-18 | San Bernardino | 71 | 5004 | 22146 | |
15487 | 15487 | Yucca Valley | Yucca Valley | 2022-12-17 | San Bernardino | 71 | 5004 | 22146 | |
16668 | 16668 | Yucca Valley | Yucca Valley | 2022-12-16 | San Bernardino | 71 | 5004 | 22146 | |
17849 | 17849 | Yucca Valley | Yucca Valley | 2022-12-15 | San Bernardino | 71 | 5004 | 22146 | |
19030 | 19030 | Yucca Valley | Yucca Valley | 2022-12-14 | San Bernardino | 71 | 5004 | 22146 | |
20211 | 20211 | Yucca Valley | Yucca Valley | 2022-12-13 | San Bernardino | 71 | 5004 | 22146 | |
21392 | 21392 | Yucca Valley | Yucca Valley | 2022-12-12 | San Bernardino | 71 | 5004 | 22146 | |
22573 | 22573 | Yucca Valley | Yucca Valley | 2022-12-11 | San Bernardino | 71 | 4894 | 22146 | |
23754 | 23754 | Yucca Valley | Yucca Valley | 2022-12-10 | San Bernardino | 71 | 4894 | 22146 | |
24935 | 24935 | Yucca Valley | Yucca Valley | 2022-12-09 | San Bernardino | 71 | 4894 | 22146 | |
26116 | 26116 | Yucca Valley | Yucca Valley | 2022-12-08 | San Bernardino | 71 | 4894 | 22146 | |
27297 | 27297 | Yucca Valley | Yucca Valley | 2022-12-07 | San Bernardino | 71 | 4894 | 22146 | |
28478 | 28478 | Yucca Valley | Yucca Valley | 2022-12-06 | San Bernardino | 71 | 4894 | 22146 | |
29659 | 29659 | Yucca Valley | Yucca Valley | 2022-12-05 | San Bernardino | 71 | 4894 | 22146 | |
30840 | 30840 | Yucca Valley | Yucca Valley | 2022-12-04 | San Bernardino | 71 | 4894 | 22146 | |
32021 | 32021 | Yucca Valley | Yucca Valley | 2022-12-03 | San Bernardino | 71 | 4894 | 22146 | |
33202 | 33202 | Yucca Valley | Yucca Valley | 2022-12-02 | San Bernardino | 71 | 4894 | 22146 | |
34383 | 34383 | Yucca Valley | Yucca Valley | 2022-12-01 | San Bernardino | 71 | 4894 | 22146 | |
35564 | 35564 | Yucca Valley | Yucca Valley | 2022-11-30 | San Bernardino | 71 | 4894 | 22146 | |
36795 | 36795 | Yucca Valley | Yucca Valley | 2022-11-29 | San Bernardino | 71 | 4894 | 22146 | |
38026 | 38026 | Yucca Valley | Yucca Valley | 2022-11-28 | San Bernardino | 71 | 4894 | 22146 | |
39257 | 39257 | Yucca Valley | Yucca Valley | 2022-11-27 | San Bernardino | 71 | 4894 | 22146 | |
40488 | 40488 | Yucca Valley | Yucca Valley | 2022-11-26 | San Bernardino | 71 | 4894 | 22146 | |
41719 | 41719 | Yucca Valley | Yucca Valley | 2022-11-25 | San Bernardino | 71 | 4894 | 22146 | |
42950 | 42950 | Yucca Valley | Yucca Valley | 2022-11-24 | San Bernardino | 71 | 4894 | 22146 | |
44181 | 44181 | Yucca Valley | Yucca Valley | 2022-11-23 | San Bernardino | 71 | 4894 | 22146 | |
45412 | 45412 | Yucca Valley | Yucca Valley | 2022-11-22 | San Bernardino | 71 | 4894 | 22146 | |
46643 | 46643 | Yucca Valley | Yucca Valley | 2022-11-21 | San Bernardino | 71 | 4894 | 22146 | |
47874 | 47874 | Yucca Valley | Yucca Valley | 2022-11-20 | San Bernardino | 71 | 4894 | 22146 | |
49105 | 49105 | Yucca Valley | Yucca Valley | 2022-11-19 | San Bernardino | 71 | 4894 | 22146 | |
50336 | 50336 | Yucca Valley | Yucca Valley | 2022-11-18 | San Bernardino | 71 | 4894 | 22146 | |
51567 | 51567 | Yucca Valley | Yucca Valley | 2022-11-17 | San Bernardino | 71 | 4894 | 22146 | |
52798 | 52798 | Yucca Valley | Yucca Valley | 2022-11-16 | San Bernardino | 71 | 4894 | 22146 | |
54029 | 54029 | Yucca Valley | Yucca Valley | 2022-11-15 | San Bernardino | 71 | 4894 | 22146 | |
55260 | 55260 | Yucca Valley | Yucca Valley | 2022-11-14 | San Bernardino | 71 | 4894 | 22146 | |
56491 | 56491 | Yucca Valley | Yucca Valley | 2022-11-13 | San Bernardino | 71 | 4894 | 22146 | |
57722 | 57722 | Yucca Valley | Yucca Valley | 2022-11-12 | San Bernardino | 71 | 4894 | 22146 | |
58953 | 58953 | Yucca Valley | Yucca Valley | 2022-11-11 | San Bernardino | 71 | 4894 | 22146 | |
60184 | 60184 | Yucca Valley | Yucca Valley | 2022-11-10 | San Bernardino | 71 | 4894 | 22146 | |
61415 | 61415 | Yucca Valley | Yucca Valley | 2022-11-09 | San Bernardino | 71 | 4894 | 22146 | |
62646 | 62646 | Yucca Valley | Yucca Valley | 2022-11-08 | San Bernardino | 71 | 4894 | 22146 | |
63877 | 63877 | Yucca Valley | Yucca Valley | 2022-11-07 | San Bernardino | 71 | 4894 | 22146 | |
65108 | 65108 | Yucca Valley | Yucca Valley | 2022-11-06 | San Bernardino | 71 | 4879 | 22146 | |
66339 | 66339 | Yucca Valley | Yucca Valley | 2022-11-05 | San Bernardino | 71 | 4879 | 22146 | |
67570 | 67570 | Yucca Valley | Yucca Valley | 2022-11-04 | San Bernardino | 71 | 4879 | 22146 | |
68801 | 68801 | Yucca Valley | Yucca Valley | 2022-11-03 | San Bernardino | 71 | 4879 | 22146 | |
70032 | 70032 | Yucca Valley | Yucca Valley | 2022-11-02 | San Bernardino | 71 | 4879 | 22146 | |
71263 | 71263 | Yucca Valley | Yucca Valley | 2022-11-01 | San Bernardino | 71 | 4879 | 22146 | |
72526 | 72526 | Yucca Valley | Yucca Valley | 2022-10-31 | San Bernardino | 71 | 4879 | 22146 | |
73789 | 73789 | Yucca Valley | Yucca Valley | 2022-10-30 | San Bernardino | 71 | 4879 | 22146 | |
75052 | 75052 | Yucca Valley | Yucca Valley | 2022-10-29 | San Bernardino | 71 | 4879 | 22146 | |
76315 | 76315 | Yucca Valley | Yucca Valley | 2022-10-28 | San Bernardino | 71 | 4879 | 22146 | |
77578 | 77578 | Yucca Valley | Yucca Valley | 2022-10-27 | San Bernardino | 71 | 4863 | 22146 | |
78841 | 78841 | Yucca Valley | Yucca Valley | 2022-10-26 | San Bernardino | 71 | 4863 | 22146 | |
80104 | 80104 | Yucca Valley | Yucca Valley | 2022-10-25 | San Bernardino | 71 | 4863 | 22146 | |
81367 | 81367 | Yucca Valley | Yucca Valley | 2022-10-24 | San Bernardino | 71 | 4863 | 22146 | |
82630 | 82630 | Yucca Valley | Yucca Valley | 2022-10-23 | San Bernardino | 71 | 4863 | 22146 | |
83893 | 83893 | Yucca Valley | Yucca Valley | 2022-10-22 | San Bernardino | 71 | 4863 | 22146 | |
85156 | 85156 | Yucca Valley | Yucca Valley | 2022-10-21 | San Bernardino | 71 | 4863 | 22146 | |
86419 | 86419 | Yucca Valley | Yucca Valley | 2022-10-20 | San Bernardino | 71 | 4863 | 22146 | |
87682 | 87682 | Yucca Valley | Yucca Valley | 2022-10-19 | San Bernardino | 71 | 4849 | 22146 | |
88945 | 88945 | Yucca Valley | Yucca Valley | 2022-10-18 | San Bernardino | 71 | 4849 | 22146 | |
90208 | 90208 | Yucca Valley | Yucca Valley | 2022-10-17 | San Bernardino | 71 | 4849 | 22146 | |
91471 | 91471 | Yucca Valley | Yucca Valley | 2022-10-16 | San Bernardino | 71 | 4849 | 22146 | |
92734 | 92734 | Yucca Valley | Yucca Valley | 2022-10-15 | San Bernardino | 71 | 4849 | 22146 | |
93997 | 93997 | Yucca Valley | Yucca Valley | 2022-10-14 | San Bernardino | 71 | 4849 | 22146 | |
95260 | 95260 | Yucca Valley | Yucca Valley | 2022-10-13 | San Bernardino | 71 | 4849 | 22146 | |
96523 | 96523 | Yucca Valley | Yucca Valley | 2022-10-12 | San Bernardino | 71 | 4837 | 22146 | |
97786 | 97786 | Yucca Valley | Yucca Valley | 2022-10-11 | San Bernardino | 71 | 4837 | 22146 | |
99049 | 99049 | Yucca Valley | Yucca Valley | 2022-10-10 | San Bernardino | 71 | 4837 | 22146 | |
100312 | 100312 | Yucca Valley | Yucca Valley | 2022-10-09 | San Bernardino | 71 | 4837 | 22146 | |
101575 | 101575 | Yucca Valley | Yucca Valley | 2022-10-08 | San Bernardino | 71 | 4837 | 22146 | |
102838 | 102838 | Yucca Valley | Yucca Valley | 2022-10-07 | San Bernardino | 71 | 4837 | 22146 | |
104101 | 104101 | Yucca Valley | Yucca Valley | 2022-10-06 | San Bernardino | 71 | 4833 | 22146 | |
105364 | 105364 | Yucca Valley | Yucca Valley | 2022-10-05 | San Bernardino | 71 | 4833 | 22146 | |
106627 | 106627 | Yucca Valley | Yucca Valley | 2022-10-04 | San Bernardino | 71 | 4833 | 22146 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_place_totals] ( [id] TEXT, [name] TEXT, [date] TEXT, [county] TEXT, [fips] INTEGER, [confirmed_cases] INTEGER, [note] TEXT, [population] TEXT );