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)
fips >30
county >30
- Los Angeles 342,048
- Riverside 64,576
- San Bernardino 64,384
- Orange 41,369
- Marin 38,478
- Fresno 31,712
- Placer 31,164
- Contra Costa 29,970
- San Mateo 29,010
- San Luis Obispo 22,374
- Napa 17,730
- Nevada 15,497
- Santa Clara 14,940
- Santa Barbara 11,110
- Merced 10,140
- Kings 8,829
- Sacramento 8,016
- Solano 7,936
- Stanislaus 7,780
- El Dorado 5,144
- Yolo 5,010
- Mendocino 4,890
- Madera 4,475
- Yuba 4,475
- Amador 4,396
- Trinity 3,392
- Butte 3,380
- Siskiyou 3,212
- Mono 3,045
- Sutter 1,818
- …
Link | rowid | id ▼ | name | date | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
198601 | 198601 | 95602 | 95602: Auburn | 2022-07-23 | Nevada | 57 | 747 | 0 | |
198659 | 198659 | 95602 | 95602: Auburn | 2022-07-23 | Placer | 61 | 2265 | 17817 | |
199864 | 199864 | 95602 | 95602: Auburn | 2022-07-22 | Nevada | 57 | 747 | 0 | |
199922 | 199922 | 95602 | 95602: Auburn | 2022-07-22 | Placer | 61 | 2265 | 17817 | |
201127 | 201127 | 95602 | 95602: Auburn | 2022-07-21 | Nevada | 57 | 747 | 0 | |
201185 | 201185 | 95602 | 95602: Auburn | 2022-07-21 | Placer | 61 | 2265 | 17817 | |
202390 | 202390 | 95602 | 95602: Auburn | 2022-07-20 | Nevada | 57 | 747 | 0 | |
202448 | 202448 | 95602 | 95602: Auburn | 2022-07-20 | Placer | 61 | 2265 | 17817 | |
203653 | 203653 | 95602 | 95602: Auburn | 2022-07-19 | Nevada | 57 | 747 | 0 | |
203711 | 203711 | 95602 | 95602: Auburn | 2022-07-19 | Placer | 61 | 2252 | 17817 | |
204916 | 204916 | 95602 | 95602: Auburn | 2022-07-18 | Nevada | 57 | 747 | 0 | |
204974 | 204974 | 95602 | 95602: Auburn | 2022-07-18 | Placer | 61 | 2252 | 17817 | |
206179 | 206179 | 95602 | 95602: Auburn | 2022-07-17 | Nevada | 57 | 747 | 0 | |
206237 | 206237 | 95602 | 95602: Auburn | 2022-07-17 | Placer | 61 | 2252 | 17817 | |
207442 | 207442 | 95602 | 95602: Auburn | 2022-07-16 | Nevada | 57 | 747 | 0 | |
207500 | 207500 | 95602 | 95602: Auburn | 2022-07-16 | Placer | 61 | 2252 | 17817 | |
208705 | 208705 | 95602 | 95602: Auburn | 2022-07-15 | Nevada | 57 | 747 | 0 | |
208763 | 208763 | 95602 | 95602: Auburn | 2022-07-15 | Placer | 61 | 2252 | 17817 | |
209968 | 209968 | 95602 | 95602: Auburn | 2022-07-14 | Nevada | 57 | 747 | 0 | |
210026 | 210026 | 95602 | 95602: Auburn | 2022-07-14 | Placer | 61 | 2252 | 17817 | |
211231 | 211231 | 95602 | 95602: Auburn | 2022-07-13 | Nevada | 57 | 747 | 0 | |
211289 | 211289 | 95602 | 95602: Auburn | 2022-07-13 | Placer | 61 | 2252 | 17817 | |
212494 | 212494 | 95602 | 95602: Auburn | 2022-07-12 | Nevada | 57 | 747 | 0 | |
212552 | 212552 | 95602 | 95602: Auburn | 2022-07-12 | Placer | 61 | 2242 | 17817 | |
213757 | 213757 | 95602 | 95602: Auburn | 2022-07-11 | Nevada | 57 | 747 | 0 | |
213815 | 213815 | 95602 | 95602: Auburn | 2022-07-11 | Placer | 61 | 2242 | 17817 | |
215020 | 215020 | 95602 | 95602: Auburn | 2022-07-10 | Nevada | 57 | 747 | 0 | |
215078 | 215078 | 95602 | 95602: Auburn | 2022-07-10 | Placer | 61 | 2242 | 17817 | |
216283 | 216283 | 95602 | 95602: Auburn | 2022-07-09 | Nevada | 57 | 747 | 0 | |
216341 | 216341 | 95602 | 95602: Auburn | 2022-07-09 | Placer | 61 | 2242 | 17817 | |
217546 | 217546 | 95602 | 95602: Auburn | 2022-07-08 | Nevada | 57 | 747 | 0 | |
217604 | 217604 | 95602 | 95602: Auburn | 2022-07-08 | Placer | 61 | 2242 | 17817 | |
218809 | 218809 | 95602 | 95602: Auburn | 2022-07-07 | Nevada | 57 | 747 | 0 | |
218867 | 218867 | 95602 | 95602: Auburn | 2022-07-07 | Placer | 61 | 2242 | 17817 | |
220072 | 220072 | 95602 | 95602: Auburn | 2022-07-06 | Nevada | 57 | 747 | 0 | |
220130 | 220130 | 95602 | 95602: Auburn | 2022-07-06 | Placer | 61 | 2242 | 17817 | |
221335 | 221335 | 95602 | 95602: Auburn | 2022-07-05 | Nevada | 57 | 747 | 0 | |
221393 | 221393 | 95602 | 95602: Auburn | 2022-07-05 | Placer | 61 | 2221 | 17817 | |
222598 | 222598 | 95602 | 95602: Auburn | 2022-07-04 | Nevada | 57 | 747 | 0 | |
222656 | 222656 | 95602 | 95602: Auburn | 2022-07-04 | Placer | 61 | 2221 | 17817 | |
223861 | 223861 | 95602 | 95602: Auburn | 2022-07-03 | Nevada | 57 | 747 | 0 | |
223919 | 223919 | 95602 | 95602: Auburn | 2022-07-03 | Placer | 61 | 2221 | 17817 | |
225124 | 225124 | 95602 | 95602: Auburn | 2022-07-02 | Nevada | 57 | 747 | 0 | |
225182 | 225182 | 95602 | 95602: Auburn | 2022-07-02 | Placer | 61 | 2221 | 17817 | |
226387 | 226387 | 95602 | 95602: Auburn | 2022-07-01 | Nevada | 57 | 747 | 0 | |
226445 | 226445 | 95602 | 95602: Auburn | 2022-07-01 | Placer | 61 | 2221 | 17817 | |
227650 | 227650 | 95602 | 95602: Auburn | 2022-06-30 | Nevada | 57 | 747 | 0 | |
227708 | 227708 | 95602 | 95602: Auburn | 2022-06-30 | Placer | 61 | 2221 | 17817 | |
228913 | 228913 | 95602 | 95602: Auburn | 2022-06-29 | Nevada | 57 | 747 | 0 | |
228971 | 228971 | 95602 | 95602: Auburn | 2022-06-29 | Placer | 61 | 2221 | 17817 | |
230176 | 230176 | 95602 | 95602: Auburn | 2022-06-28 | Nevada | 57 | 747 | 0 | |
230234 | 230234 | 95602 | 95602: Auburn | 2022-06-28 | Placer | 61 | 2209 | 17817 | |
231439 | 231439 | 95602 | 95602: Auburn | 2022-06-27 | Nevada | 57 | 743 | 0 | |
231497 | 231497 | 95602 | 95602: Auburn | 2022-06-27 | Placer | 61 | 2209 | 17817 | |
232702 | 232702 | 95602 | 95602: Auburn | 2022-06-26 | Nevada | 57 | 743 | 0 | |
232760 | 232760 | 95602 | 95602: Auburn | 2022-06-26 | Placer | 61 | 2209 | 17817 | |
233965 | 233965 | 95602 | 95602: Auburn | 2022-06-25 | Nevada | 57 | 743 | 0 | |
234023 | 234023 | 95602 | 95602: Auburn | 2022-06-25 | Placer | 61 | 2209 | 17817 | |
235228 | 235228 | 95602 | 95602: Auburn | 2022-06-24 | Nevada | 57 | 743 | 0 | |
235286 | 235286 | 95602 | 95602: Auburn | 2022-06-24 | Placer | 61 | 2209 | 17817 | |
236491 | 236491 | 95602 | 95602: Auburn | 2022-06-23 | Nevada | 57 | 741 | 0 | |
236549 | 236549 | 95602 | 95602: Auburn | 2022-06-23 | Placer | 61 | 2209 | 17817 | |
237754 | 237754 | 95602 | 95602: Auburn | 2022-06-22 | Nevada | 57 | 741 | 0 | |
237812 | 237812 | 95602 | 95602: Auburn | 2022-06-22 | Placer | 61 | 2209 | 17817 | |
239017 | 239017 | 95602 | 95602: Auburn | 2022-06-21 | Nevada | 57 | 741 | 0 | |
239075 | 239075 | 95602 | 95602: Auburn | 2022-06-21 | Placer | 61 | 2194 | 17817 | |
240280 | 240280 | 95602 | 95602: Auburn | 2022-06-20 | Nevada | 57 | 736 | 0 | |
240338 | 240338 | 95602 | 95602: Auburn | 2022-06-20 | Placer | 61 | 2194 | 17817 | |
241543 | 241543 | 95602 | 95602: Auburn | 2022-06-19 | Nevada | 57 | 736 | 0 | |
241601 | 241601 | 95602 | 95602: Auburn | 2022-06-19 | Placer | 61 | 2194 | 17817 | |
242806 | 242806 | 95602 | 95602: Auburn | 2022-06-18 | Nevada | 57 | 736 | 0 | |
242864 | 242864 | 95602 | 95602: Auburn | 2022-06-18 | Placer | 61 | 2194 | 17817 | |
244069 | 244069 | 95602 | 95602: Auburn | 2022-06-17 | Nevada | 57 | 736 | 0 | |
244127 | 244127 | 95602 | 95602: Auburn | 2022-06-17 | Placer | 61 | 2194 | 17817 | |
245332 | 245332 | 95602 | 95602: Auburn | 2022-06-16 | Nevada | 57 | 731 | 0 | |
245390 | 245390 | 95602 | 95602: Auburn | 2022-06-16 | Placer | 61 | 2194 | 17817 | |
246595 | 246595 | 95602 | 95602: Auburn | 2022-06-15 | Nevada | 57 | 731 | 0 | |
246653 | 246653 | 95602 | 95602: Auburn | 2022-06-15 | Placer | 61 | 2194 | 17817 | |
247858 | 247858 | 95602 | 95602: Auburn | 2022-06-14 | Nevada | 57 | 731 | 0 | |
247916 | 247916 | 95602 | 95602: Auburn | 2022-06-14 | Placer | 61 | 2174 | 17817 | |
249121 | 249121 | 95602 | 95602: Auburn | 2022-06-13 | Nevada | 57 | 727 | 0 | |
249179 | 249179 | 95602 | 95602: Auburn | 2022-06-13 | Placer | 61 | 2174 | 17817 | |
250384 | 250384 | 95602 | 95602: Auburn | 2022-06-12 | Nevada | 57 | 727 | 0 | |
250442 | 250442 | 95602 | 95602: Auburn | 2022-06-12 | Placer | 61 | 2174 | 17817 | |
251647 | 251647 | 95602 | 95602: Auburn | 2022-06-11 | Nevada | 57 | 727 | 0 | |
251705 | 251705 | 95602 | 95602: Auburn | 2022-06-11 | Placer | 61 | 2174 | 17817 | |
252910 | 252910 | 95602 | 95602: Auburn | 2022-06-10 | Nevada | 57 | 727 | 0 | |
252968 | 252968 | 95602 | 95602: Auburn | 2022-06-10 | Placer | 61 | 2174 | 17817 | |
254173 | 254173 | 95602 | 95602: Auburn | 2022-06-09 | Nevada | 57 | 720 | 0 | |
254231 | 254231 | 95602 | 95602: Auburn | 2022-06-09 | Placer | 61 | 2174 | 17817 | |
255436 | 255436 | 95602 | 95602: Auburn | 2022-06-08 | Nevada | 57 | 720 | 0 | |
255494 | 255494 | 95602 | 95602: Auburn | 2022-06-08 | Placer | 61 | 2174 | 17817 | |
256699 | 256699 | 95602 | 95602: Auburn | 2022-06-07 | Nevada | 57 | 720 | 0 | |
256757 | 256757 | 95602 | 95602: Auburn | 2022-06-07 | Placer | 61 | 2154 | 17817 | |
257962 | 257962 | 95602 | 95602: Auburn | 2022-06-06 | Nevada | 57 | 711 | 0 | |
258020 | 258020 | 95602 | 95602: Auburn | 2022-06-06 | Placer | 61 | 2154 | 17817 | |
259225 | 259225 | 95602 | 95602: Auburn | 2022-06-05 | Nevada | 57 | 711 | 0 | |
259283 | 259283 | 95602 | 95602: Auburn | 2022-06-05 | Placer | 61 | 2154 | 17817 | |
260488 | 260488 | 95602 | 95602: Auburn | 2022-06-04 | Nevada | 57 | 711 | 0 | |
260546 | 260546 | 95602 | 95602: Auburn | 2022-06-04 | Placer | 61 | 2154 | 17817 |
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 );