latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
31,264 rows where county = "Placer" sorted by id
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id ▼ | name | date | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
198659 | 198659 | 95602 | 95602: Auburn | 2022-07-23 | Placer | 61 | 2265 | 17817 | |
199922 | 199922 | 95602 | 95602: Auburn | 2022-07-22 | Placer | 61 | 2265 | 17817 | |
201185 | 201185 | 95602 | 95602: Auburn | 2022-07-21 | Placer | 61 | 2265 | 17817 | |
202448 | 202448 | 95602 | 95602: Auburn | 2022-07-20 | Placer | 61 | 2265 | 17817 | |
203711 | 203711 | 95602 | 95602: Auburn | 2022-07-19 | Placer | 61 | 2252 | 17817 | |
204974 | 204974 | 95602 | 95602: Auburn | 2022-07-18 | Placer | 61 | 2252 | 17817 | |
206237 | 206237 | 95602 | 95602: Auburn | 2022-07-17 | Placer | 61 | 2252 | 17817 | |
207500 | 207500 | 95602 | 95602: Auburn | 2022-07-16 | Placer | 61 | 2252 | 17817 | |
208763 | 208763 | 95602 | 95602: Auburn | 2022-07-15 | Placer | 61 | 2252 | 17817 | |
210026 | 210026 | 95602 | 95602: Auburn | 2022-07-14 | Placer | 61 | 2252 | 17817 | |
211289 | 211289 | 95602 | 95602: Auburn | 2022-07-13 | Placer | 61 | 2252 | 17817 | |
212552 | 212552 | 95602 | 95602: Auburn | 2022-07-12 | Placer | 61 | 2242 | 17817 | |
213815 | 213815 | 95602 | 95602: Auburn | 2022-07-11 | Placer | 61 | 2242 | 17817 | |
215078 | 215078 | 95602 | 95602: Auburn | 2022-07-10 | Placer | 61 | 2242 | 17817 | |
216341 | 216341 | 95602 | 95602: Auburn | 2022-07-09 | Placer | 61 | 2242 | 17817 | |
217604 | 217604 | 95602 | 95602: Auburn | 2022-07-08 | Placer | 61 | 2242 | 17817 | |
218867 | 218867 | 95602 | 95602: Auburn | 2022-07-07 | Placer | 61 | 2242 | 17817 | |
220130 | 220130 | 95602 | 95602: Auburn | 2022-07-06 | Placer | 61 | 2242 | 17817 | |
221393 | 221393 | 95602 | 95602: Auburn | 2022-07-05 | Placer | 61 | 2221 | 17817 | |
222656 | 222656 | 95602 | 95602: Auburn | 2022-07-04 | Placer | 61 | 2221 | 17817 | |
223919 | 223919 | 95602 | 95602: Auburn | 2022-07-03 | Placer | 61 | 2221 | 17817 | |
225182 | 225182 | 95602 | 95602: Auburn | 2022-07-02 | Placer | 61 | 2221 | 17817 | |
226445 | 226445 | 95602 | 95602: Auburn | 2022-07-01 | Placer | 61 | 2221 | 17817 | |
227708 | 227708 | 95602 | 95602: Auburn | 2022-06-30 | Placer | 61 | 2221 | 17817 | |
228971 | 228971 | 95602 | 95602: Auburn | 2022-06-29 | Placer | 61 | 2221 | 17817 | |
230234 | 230234 | 95602 | 95602: Auburn | 2022-06-28 | Placer | 61 | 2209 | 17817 | |
231497 | 231497 | 95602 | 95602: Auburn | 2022-06-27 | Placer | 61 | 2209 | 17817 | |
232760 | 232760 | 95602 | 95602: Auburn | 2022-06-26 | Placer | 61 | 2209 | 17817 | |
234023 | 234023 | 95602 | 95602: Auburn | 2022-06-25 | Placer | 61 | 2209 | 17817 | |
235286 | 235286 | 95602 | 95602: Auburn | 2022-06-24 | Placer | 61 | 2209 | 17817 | |
236549 | 236549 | 95602 | 95602: Auburn | 2022-06-23 | Placer | 61 | 2209 | 17817 | |
237812 | 237812 | 95602 | 95602: Auburn | 2022-06-22 | Placer | 61 | 2209 | 17817 | |
239075 | 239075 | 95602 | 95602: Auburn | 2022-06-21 | Placer | 61 | 2194 | 17817 | |
240338 | 240338 | 95602 | 95602: Auburn | 2022-06-20 | Placer | 61 | 2194 | 17817 | |
241601 | 241601 | 95602 | 95602: Auburn | 2022-06-19 | Placer | 61 | 2194 | 17817 | |
242864 | 242864 | 95602 | 95602: Auburn | 2022-06-18 | Placer | 61 | 2194 | 17817 | |
244127 | 244127 | 95602 | 95602: Auburn | 2022-06-17 | Placer | 61 | 2194 | 17817 | |
245390 | 245390 | 95602 | 95602: Auburn | 2022-06-16 | Placer | 61 | 2194 | 17817 | |
246653 | 246653 | 95602 | 95602: Auburn | 2022-06-15 | Placer | 61 | 2194 | 17817 | |
247916 | 247916 | 95602 | 95602: Auburn | 2022-06-14 | Placer | 61 | 2174 | 17817 | |
249179 | 249179 | 95602 | 95602: Auburn | 2022-06-13 | Placer | 61 | 2174 | 17817 | |
250442 | 250442 | 95602 | 95602: Auburn | 2022-06-12 | Placer | 61 | 2174 | 17817 | |
251705 | 251705 | 95602 | 95602: Auburn | 2022-06-11 | Placer | 61 | 2174 | 17817 | |
252968 | 252968 | 95602 | 95602: Auburn | 2022-06-10 | Placer | 61 | 2174 | 17817 | |
254231 | 254231 | 95602 | 95602: Auburn | 2022-06-09 | Placer | 61 | 2174 | 17817 | |
255494 | 255494 | 95602 | 95602: Auburn | 2022-06-08 | Placer | 61 | 2174 | 17817 | |
256757 | 256757 | 95602 | 95602: Auburn | 2022-06-07 | Placer | 61 | 2154 | 17817 | |
258020 | 258020 | 95602 | 95602: Auburn | 2022-06-06 | Placer | 61 | 2154 | 17817 | |
259283 | 259283 | 95602 | 95602: Auburn | 2022-06-05 | Placer | 61 | 2154 | 17817 | |
260546 | 260546 | 95602 | 95602: Auburn | 2022-06-04 | Placer | 61 | 2154 | 17817 | |
261809 | 261809 | 95602 | 95602: Auburn | 2022-06-03 | Placer | 61 | 2154 | 17817 | |
263072 | 263072 | 95602 | 95602: Auburn | 2022-06-02 | Placer | 61 | 2154 | 17817 | |
264335 | 264335 | 95602 | 95602: Auburn | 2022-06-01 | Placer | 61 | 2154 | 17817 | |
265598 | 265598 | 95602 | 95602: Auburn | 2022-05-31 | Placer | 61 | 2130 | 17817 | |
266861 | 266861 | 95602 | 95602: Auburn | 2022-05-30 | Placer | 61 | 2130 | 17817 | |
268124 | 268124 | 95602 | 95602: Auburn | 2022-05-29 | Placer | 61 | 2130 | 17817 | |
269387 | 269387 | 95602 | 95602: Auburn | 2022-05-28 | Placer | 61 | 2130 | 17817 | |
270650 | 270650 | 95602 | 95602: Auburn | 2022-05-27 | Placer | 61 | 2130 | 17817 | |
271913 | 271913 | 95602 | 95602: Auburn | 2022-05-26 | Placer | 61 | 2130 | 17817 | |
273176 | 273176 | 95602 | 95602: Auburn | 2022-05-25 | Placer | 61 | 2130 | 17817 | |
274439 | 274439 | 95602 | 95602: Auburn | 2022-05-24 | Placer | 61 | 2107 | 17817 | |
275702 | 275702 | 95602 | 95602: Auburn | 2022-05-23 | Placer | 61 | 2107 | 17817 | |
276975 | 276975 | 95602 | 95602: Auburn | 2022-05-22 | Placer | 61 | 2107 | 17817 | |
278248 | 278248 | 95602 | 95602: Auburn | 2022-05-21 | Placer | 61 | 2107 | 17817 | |
279521 | 279521 | 95602 | 95602: Auburn | 2022-05-20 | Placer | 61 | 2107 | 17817 | |
280794 | 280794 | 95602 | 95602: Auburn | 2022-05-19 | Placer | 61 | 2107 | 17817 | |
282067 | 282067 | 95602 | 95602: Auburn | 2022-05-18 | Placer | 61 | 2108 | 17817 | |
283340 | 283340 | 95602 | 95602: Auburn | 2022-05-17 | Placer | 61 | 2063 | 17817 | |
284613 | 284613 | 95602 | 95602: Auburn | 2022-05-16 | Placer | 61 | 2063 | 17817 | |
285886 | 285886 | 95602 | 95602: Auburn | 2022-05-15 | Placer | 61 | 2063 | 17817 | |
287159 | 287159 | 95602 | 95602: Auburn | 2022-05-14 | Placer | 61 | 2063 | 17817 | |
288432 | 288432 | 95602 | 95602: Auburn | 2022-05-13 | Placer | 61 | 2063 | 17817 | |
289705 | 289705 | 95602 | 95602: Auburn | 2022-05-12 | Placer | 61 | 2063 | 17817 | |
290978 | 290978 | 95602 | 95602: Auburn | 2022-05-11 | Placer | 61 | 2063 | 17817 | |
292251 | 292251 | 95602 | 95602: Auburn | 2022-05-10 | Placer | 61 | 2043 | 17817 | |
293524 | 293524 | 95602 | 95602: Auburn | 2022-05-09 | Placer | 61 | 2043 | 17817 | |
294797 | 294797 | 95602 | 95602: Auburn | 2022-05-08 | Placer | 61 | 2043 | 17817 | |
296070 | 296070 | 95602 | 95602: Auburn | 2022-05-07 | Placer | 61 | 2043 | 17817 | |
297343 | 297343 | 95602 | 95602: Auburn | 2022-05-06 | Placer | 61 | 2043 | 17817 | |
298616 | 298616 | 95602 | 95602: Auburn | 2022-05-05 | Placer | 61 | 2043 | 17817 | |
299889 | 299889 | 95602 | 95602: Auburn | 2022-05-04 | Placer | 61 | 2043 | 17817 | |
301158 | 301158 | 95602 | 95602: Auburn | 2022-05-03 | Placer | 61 | 2036 | 17817 | |
302427 | 302427 | 95602 | 95602: Auburn | 2022-05-02 | Placer | 61 | 2036 | 17817 | |
303696 | 303696 | 95602 | 95602: Auburn | 2022-05-01 | Placer | 61 | 2036 | 17817 | |
304965 | 304965 | 95602 | 95602: Auburn | 2022-04-30 | Placer | 61 | 2036 | 17817 | |
306234 | 306234 | 95602 | 95602: Auburn | 2022-04-29 | Placer | 61 | 2036 | 17817 | |
307503 | 307503 | 95602 | 95602: Auburn | 2022-04-28 | Placer | 61 | 2036 | 17817 | |
308772 | 308772 | 95602 | 95602: Auburn | 2022-04-27 | Placer | 61 | 2010 | 17817 | |
310041 | 310041 | 95602 | 95602: Auburn | 2022-04-26 | Placer | 61 | 2016 | 17817 | |
311310 | 311310 | 95602 | 95602: Auburn | 2022-04-25 | Placer | 61 | 2016 | 17817 | |
312579 | 312579 | 95602 | 95602: Auburn | 2022-04-24 | Placer | 61 | 2016 | 17817 | |
313848 | 313848 | 95602 | 95602: Auburn | 2022-04-23 | Placer | 61 | 2016 | 17817 | |
315117 | 315117 | 95602 | 95602: Auburn | 2022-04-22 | Placer | 61 | 2016 | 17817 | |
316386 | 316386 | 95602 | 95602: Auburn | 2022-04-21 | Placer | 61 | 2016 | 17817 | |
317655 | 317655 | 95602 | 95602: Auburn | 2022-04-20 | Placer | 61 | 2010 | 17817 | |
318924 | 318924 | 95602 | 95602: Auburn | 2022-04-19 | Placer | 61 | 2005 | 17817 | |
320193 | 320193 | 95602 | 95602: Auburn | 2022-04-18 | Placer | 61 | 2005 | 17817 | |
321462 | 321462 | 95602 | 95602: Auburn | 2022-04-17 | Placer | 61 | 2005 | 17817 | |
322731 | 322731 | 95602 | 95602: Auburn | 2022-04-16 | Placer | 61 | 2005 | 17817 | |
324000 | 324000 | 95602 | 95602: Auburn | 2022-04-15 | Placer | 61 | 2005 | 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 );