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
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: date
fips >30
county >30
- Los Angeles 359,254
- 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 |
---|---|---|---|---|---|---|---|---|---|
124873 | 124873 | 90802 | 90802: Long Beach | 2022-09-19 | Los Angeles | 37 | 11447 | 39453 | |
126136 | 126136 | 90802 | 90802: Long Beach | 2022-09-18 | Los Angeles | 37 | 11435 | 39453 | |
127399 | 127399 | 90802 | 90802: Long Beach | 2022-09-17 | Los Angeles | 37 | 11435 | 39453 | |
128662 | 128662 | 90802 | 90802: Long Beach | 2022-09-16 | Los Angeles | 37 | 11435 | 39453 | |
129925 | 129925 | 90802 | 90802: Long Beach | 2022-09-15 | Los Angeles | 37 | 11423 | 39453 | |
131188 | 131188 | 90802 | 90802: Long Beach | 2022-09-14 | Los Angeles | 37 | 11415 | 39453 | |
132451 | 132451 | 90802 | 90802: Long Beach | 2022-09-13 | Los Angeles | 37 | 11410 | 39453 | |
133714 | 133714 | 90802 | 90802: Long Beach | 2022-09-12 | Los Angeles | 37 | 11414 | 39453 | |
134977 | 134977 | 90802 | 90802: Long Beach | 2022-09-11 | Los Angeles | 37 | 11400 | 39453 | |
136240 | 136240 | 90802 | 90802: Long Beach | 2022-09-10 | Los Angeles | 37 | 11400 | 39453 | |
137503 | 137503 | 90802 | 90802: Long Beach | 2022-09-09 | Los Angeles | 37 | 11400 | 39453 | |
138766 | 138766 | 90802 | 90802: Long Beach | 2022-09-08 | Los Angeles | 37 | 11389 | 39453 | |
140029 | 140029 | 90802 | 90802: Long Beach | 2022-09-07 | Los Angeles | 37 | 11389 | 39453 | |
141292 | 141292 | 90802 | 90802: Long Beach | 2022-09-06 | Los Angeles | 37 | 11386 | 39453 | |
142555 | 142555 | 90802 | 90802: Long Beach | 2022-09-05 | Los Angeles | 37 | 11365 | 39453 | |
143818 | 143818 | 90802 | 90802: Long Beach | 2022-09-04 | Los Angeles | 37 | 11365 | 39453 | |
145081 | 145081 | 90802 | 90802: Long Beach | 2022-09-03 | Los Angeles | 37 | 11365 | 39453 | |
146344 | 146344 | 90802 | 90802: Long Beach | 2022-09-02 | Los Angeles | 37 | 11365 | 39453 | |
147607 | 147607 | 90802 | 90802: Long Beach | 2022-09-01 | Los Angeles | 37 | 11351 | 39453 | |
148870 | 148870 | 90802 | 90802: Long Beach | 2022-08-31 | Los Angeles | 37 | 11337 | 39453 | |
150133 | 150133 | 90802 | 90802: Long Beach | 2022-08-30 | Los Angeles | 37 | 11340 | 39453 | |
151396 | 151396 | 90802 | 90802: Long Beach | 2022-08-29 | Los Angeles | 37 | 11305 | 39453 | |
152659 | 152659 | 90802 | 90802: Long Beach | 2022-08-28 | Los Angeles | 37 | 11287 | 39453 | |
153922 | 153922 | 90802 | 90802: Long Beach | 2022-08-27 | Los Angeles | 37 | 11287 | 39453 | |
155185 | 155185 | 90802 | 90802: Long Beach | 2022-08-26 | Los Angeles | 37 | 11287 | 39453 | |
156448 | 156448 | 90802 | 90802: Long Beach | 2022-08-25 | Los Angeles | 37 | 11271 | 39453 | |
157711 | 157711 | 90802 | 90802: Long Beach | 2022-08-24 | Los Angeles | 37 | 11256 | 39453 | |
158974 | 158974 | 90802 | 90802: Long Beach | 2022-08-23 | Los Angeles | 37 | 11257 | 39453 | |
160237 | 160237 | 90802 | 90802: Long Beach | 2022-08-22 | Los Angeles | 37 | 11229 | 39453 | |
161500 | 161500 | 90802 | 90802: Long Beach | 2022-08-21 | Los Angeles | 37 | 11199 | 39453 | |
162763 | 162763 | 90802 | 90802: Long Beach | 2022-08-20 | Los Angeles | 37 | 11199 | 39453 | |
164026 | 164026 | 90802 | 90802: Long Beach | 2022-08-19 | Los Angeles | 37 | 11199 | 39453 | |
165289 | 165289 | 90802 | 90802: Long Beach | 2022-08-18 | Los Angeles | 37 | 11191 | 39453 | |
166552 | 166552 | 90802 | 90802: Long Beach | 2022-08-17 | Los Angeles | 37 | 11175 | 39453 | |
167815 | 167815 | 90802 | 90802: Long Beach | 2022-08-16 | Los Angeles | 37 | 11168 | 39453 | |
169078 | 169078 | 90802 | 90802: Long Beach | 2022-08-15 | Los Angeles | 37 | 11141 | 39453 | |
170341 | 170341 | 90802 | 90802: Long Beach | 2022-08-14 | Los Angeles | 37 | 11111 | 39453 | |
171604 | 171604 | 90802 | 90802: Long Beach | 2022-08-13 | Los Angeles | 37 | 11111 | 39453 | |
172867 | 172867 | 90802 | 90802: Long Beach | 2022-08-12 | Los Angeles | 37 | 11111 | 39453 | |
174130 | 174130 | 90802 | 90802: Long Beach | 2022-08-11 | Los Angeles | 37 | 11085 | 39453 | |
175393 | 175393 | 90802 | 90802: Long Beach | 2022-08-10 | Los Angeles | 37 | 11065 | 39453 | |
176656 | 176656 | 90802 | 90802: Long Beach | 2022-08-09 | Los Angeles | 37 | 11059 | 39453 | |
177919 | 177919 | 90802 | 90802: Long Beach | 2022-08-08 | Los Angeles | 37 | 11042 | 39453 | |
179182 | 179182 | 90802 | 90802: Long Beach | 2022-08-07 | Los Angeles | 37 | 11018 | 39453 | |
180445 | 180445 | 90802 | 90802: Long Beach | 2022-08-06 | Los Angeles | 37 | 11018 | 39453 | |
181708 | 181708 | 90802 | 90802: Long Beach | 2022-08-05 | Los Angeles | 37 | 11018 | 39453 | |
182971 | 182971 | 90802 | 90802: Long Beach | 2022-08-04 | Los Angeles | 37 | 11001 | 39453 | |
184234 | 184234 | 90802 | 90802: Long Beach | 2022-08-03 | Los Angeles | 37 | 10997 | 39453 | |
185497 | 185497 | 90802 | 90802: Long Beach | 2022-08-02 | Los Angeles | 37 | 10952 | 39453 | |
186760 | 186760 | 90802 | 90802: Long Beach | 2022-08-01 | Los Angeles | 37 | 10952 | 39453 | |
188023 | 188023 | 90802 | 90802: Long Beach | 2022-07-31 | Los Angeles | 37 | 10916 | 39453 | |
189286 | 189286 | 90802 | 90802: Long Beach | 2022-07-30 | Los Angeles | 37 | 10916 | 39453 | |
190549 | 190549 | 90802 | 90802: Long Beach | 2022-07-29 | Los Angeles | 37 | 10916 | 39453 | |
191812 | 191812 | 90802 | 90802: Long Beach | 2022-07-28 | Los Angeles | 37 | 10886 | 39453 | |
193075 | 193075 | 90802 | 90802: Long Beach | 2022-07-27 | Los Angeles | 37 | 10861 | 39453 | |
194338 | 194338 | 90802 | 90802: Long Beach | 2022-07-26 | Los Angeles | 37 | 10852 | 39453 | |
195601 | 195601 | 90802 | 90802: Long Beach | 2022-07-25 | Los Angeles | 37 | 10817 | 39453 | |
196864 | 196864 | 90802 | 90802: Long Beach | 2022-07-24 | Los Angeles | 37 | 10753 | 39453 | |
198127 | 198127 | 90802 | 90802: Long Beach | 2022-07-23 | Los Angeles | 37 | 10753 | 39453 | |
199390 | 199390 | 90802 | 90802: Long Beach | 2022-07-22 | Los Angeles | 37 | 10753 | 39453 | |
200653 | 200653 | 90802 | 90802: Long Beach | 2022-07-21 | Los Angeles | 37 | 10728 | 39453 | |
201916 | 201916 | 90802 | 90802: Long Beach | 2022-07-20 | Los Angeles | 37 | 10700 | 39453 | |
203179 | 203179 | 90802 | 90802: Long Beach | 2022-07-19 | Los Angeles | 37 | 10673 | 39453 | |
204442 | 204442 | 90802 | 90802: Long Beach | 2022-07-18 | Los Angeles | 37 | 10622 | 39453 | |
205705 | 205705 | 90802 | 90802: Long Beach | 2022-07-17 | Los Angeles | 37 | 10532 | 39453 | |
206968 | 206968 | 90802 | 90802: Long Beach | 2022-07-16 | Los Angeles | 37 | 10532 | 39453 | |
208231 | 208231 | 90802 | 90802: Long Beach | 2022-07-15 | Los Angeles | 37 | 10532 | 39453 | |
209494 | 209494 | 90802 | 90802: Long Beach | 2022-07-14 | Los Angeles | 37 | 10509 | 39453 | |
210757 | 210757 | 90802 | 90802: Long Beach | 2022-07-13 | Los Angeles | 37 | 10490 | 39453 | |
212020 | 212020 | 90802 | 90802: Long Beach | 2022-07-12 | Los Angeles | 37 | 10482 | 39453 | |
213283 | 213283 | 90802 | 90802: Long Beach | 2022-07-11 | Los Angeles | 37 | 10445 | 39453 | |
214546 | 214546 | 90802 | 90802: Long Beach | 2022-07-10 | Los Angeles | 37 | 10387 | 39453 | |
215809 | 215809 | 90802 | 90802: Long Beach | 2022-07-09 | Los Angeles | 37 | 10387 | 39453 | |
217072 | 217072 | 90802 | 90802: Long Beach | 2022-07-08 | Los Angeles | 37 | 10387 | 39453 | |
218335 | 218335 | 90802 | 90802: Long Beach | 2022-07-07 | Los Angeles | 37 | 10343 | 39453 | |
219598 | 219598 | 90802 | 90802: Long Beach | 2022-07-06 | Los Angeles | 37 | 10335 | 39453 | |
220861 | 220861 | 90802 | 90802: Long Beach | 2022-07-05 | Los Angeles | 37 | 10321 | 39453 | |
222124 | 222124 | 90802 | 90802: Long Beach | 2022-07-04 | Los Angeles | 37 | 10230 | 39453 | |
223387 | 223387 | 90802 | 90802: Long Beach | 2022-07-03 | Los Angeles | 37 | 10230 | 39453 | |
224650 | 224650 | 90802 | 90802: Long Beach | 2022-07-02 | Los Angeles | 37 | 10230 | 39453 | |
225913 | 225913 | 90802 | 90802: Long Beach | 2022-07-01 | Los Angeles | 37 | 10230 | 39453 | |
227176 | 227176 | 90802 | 90802: Long Beach | 2022-06-30 | Los Angeles | 37 | 10202 | 39453 | |
228439 | 228439 | 90802 | 90802: Long Beach | 2022-06-29 | Los Angeles | 37 | 10186 | 39453 | |
229702 | 229702 | 90802 | 90802: Long Beach | 2022-06-28 | Los Angeles | 37 | 10161 | 39453 | |
230965 | 230965 | 90802 | 90802: Long Beach | 2022-06-27 | Los Angeles | 37 | 10128 | 39453 | |
232228 | 232228 | 90802 | 90802: Long Beach | 2022-06-26 | Los Angeles | 37 | 10081 | 39453 | |
233491 | 233491 | 90802 | 90802: Long Beach | 2022-06-25 | Los Angeles | 37 | 10081 | 39453 | |
234754 | 234754 | 90802 | 90802: Long Beach | 2022-06-24 | Los Angeles | 37 | 10081 | 39453 | |
236017 | 236017 | 90802 | 90802: Long Beach | 2022-06-23 | Los Angeles | 37 | 10048 | 39453 | |
237280 | 237280 | 90802 | 90802: Long Beach | 2022-06-22 | Los Angeles | 37 | 10019 | 39453 | |
238543 | 238543 | 90802 | 90802: Long Beach | 2022-06-21 | Los Angeles | 37 | 10005 | 39453 | |
239806 | 239806 | 90802 | 90802: Long Beach | 2022-06-20 | Los Angeles | 37 | 9922 | 39453 | |
241069 | 241069 | 90802 | 90802: Long Beach | 2022-06-19 | Los Angeles | 37 | 9922 | 39453 | |
242332 | 242332 | 90802 | 90802: Long Beach | 2022-06-18 | Los Angeles | 37 | 9922 | 39453 | |
243595 | 243595 | 90802 | 90802: Long Beach | 2022-06-17 | Los Angeles | 37 | 9922 | 39453 | |
244858 | 244858 | 90802 | 90802: Long Beach | 2022-06-16 | Los Angeles | 37 | 9903 | 39453 | |
246121 | 246121 | 90802 | 90802: Long Beach | 2022-06-15 | Los Angeles | 37 | 9883 | 39453 | |
247384 | 247384 | 90802 | 90802: Long Beach | 2022-06-14 | Los Angeles | 37 | 9872 | 39453 | |
248647 | 248647 | 90802 | 90802: Long Beach | 2022-06-13 | Los Angeles | 37 | 9847 | 39453 | |
249910 | 249910 | 90802 | 90802: Long Beach | 2022-06-12 | Los Angeles | 37 | 9799 | 39453 |
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 );