latimes-place-totals
Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README
- id
- The unique identifier of the city, neighborhood or other area.
- name
- The name of the city, neighborhood or other area.
- date
- The date when the data were retrieved in ISO 8601 format.
- county
- The name of the county where the city is located.
- fips
- The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
- confirmed_cases
- The cumulative number of confirmed coronavirus case at that time.
- note
- In cases where the confirmed_cases are obscured, this explains the range of possible values.
- population
- The number of residents in the area. Not available for all places.
1,251,796 rows sorted by confirmed_cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2022-02-22 1,277
- 2022-02-23 1,277
- 2022-02-24 1,277
- 2022-02-25 1,277
- 2022-02-26 1,277
- 2022-02-27 1,277
- 2022-02-28 1,277
- 2021-01-04 1,276
- 2021-01-05 1,276
- 2021-01-06 1,276
- 2021-01-07 1,276
- 2021-01-08 1,276
- 2021-01-09 1,276
- 2021-01-10 1,276
- 2021-01-11 1,276
- 2021-01-12 1,276
- 2021-01-13 1,276
- 2021-01-14 1,276
- 2021-01-15 1,276
- 2021-01-16 1,276
- 2021-01-17 1,276
- 2021-01-18 1,276
- 2021-01-19 1,276
- 2021-01-20 1,276
- 2021-01-21 1,276
- 2021-01-22 1,276
- 2021-01-23 1,276
- 2021-01-24 1,276
- 2021-01-25 1,276
- 2021-01-26 1,276
- …
Link | rowid | id | name | date | county | fips | confirmed_cases ▼ | note | population |
---|---|---|---|---|---|---|---|---|---|
346195 | 346195 | Dos Palos | Dos Palos | 2022-03-28 | Fresno | 19 | 0 | ||
346969 | 346969 | Havasu Lake | Havasu Lake | 2022-03-28 | San Bernardino | 71 | 0 | 0 | |
347464 | 347464 | Dos Palos | Dos Palos | 2022-03-27 | Fresno | 19 | 0 | ||
348238 | 348238 | Havasu Lake | Havasu Lake | 2022-03-27 | San Bernardino | 71 | 0 | 0 | |
348733 | 348733 | Dos Palos | Dos Palos | 2022-03-26 | Fresno | 19 | 0 | ||
349507 | 349507 | Havasu Lake | Havasu Lake | 2022-03-26 | San Bernardino | 71 | 0 | 0 | |
350002 | 350002 | Dos Palos | Dos Palos | 2022-03-25 | Fresno | 19 | 0 | ||
350776 | 350776 | Havasu Lake | Havasu Lake | 2022-03-25 | San Bernardino | 71 | 0 | 0 | |
351271 | 351271 | Dos Palos | Dos Palos | 2022-03-24 | Fresno | 19 | 0 | ||
352045 | 352045 | Havasu Lake | Havasu Lake | 2022-03-24 | San Bernardino | 71 | 0 | 0 | |
352540 | 352540 | Dos Palos | Dos Palos | 2022-03-23 | Fresno | 19 | 0 | ||
353314 | 353314 | Havasu Lake | Havasu Lake | 2022-03-23 | San Bernardino | 71 | 0 | 0 | |
353809 | 353809 | Dos Palos | Dos Palos | 2022-03-22 | Fresno | 19 | 0 | ||
354583 | 354583 | Havasu Lake | Havasu Lake | 2022-03-22 | San Bernardino | 71 | 0 | 0 | |
355078 | 355078 | Dos Palos | Dos Palos | 2022-03-21 | Fresno | 19 | 0 | ||
355852 | 355852 | Havasu Lake | Havasu Lake | 2022-03-21 | San Bernardino | 71 | 0 | 0 | |
356347 | 356347 | Dos Palos | Dos Palos | 2022-03-20 | Fresno | 19 | 0 | ||
357121 | 357121 | Havasu Lake | Havasu Lake | 2022-03-20 | San Bernardino | 71 | 0 | 0 | |
357616 | 357616 | Dos Palos | Dos Palos | 2022-03-19 | Fresno | 19 | 0 | ||
358390 | 358390 | Havasu Lake | Havasu Lake | 2022-03-19 | San Bernardino | 71 | 0 | 0 | |
358885 | 358885 | Dos Palos | Dos Palos | 2022-03-18 | Fresno | 19 | 0 | ||
359659 | 359659 | Havasu Lake | Havasu Lake | 2022-03-18 | San Bernardino | 71 | 0 | 0 | |
360154 | 360154 | Dos Palos | Dos Palos | 2022-03-17 | Fresno | 19 | 0 | ||
360928 | 360928 | Havasu Lake | Havasu Lake | 2022-03-17 | San Bernardino | 71 | 0 | 0 | |
361423 | 361423 | Dos Palos | Dos Palos | 2022-03-16 | Fresno | 19 | 0 | ||
362197 | 362197 | Havasu Lake | Havasu Lake | 2022-03-16 | San Bernardino | 71 | 0 | 0 | |
362695 | 362695 | Dos Palos | Dos Palos | 2022-03-15 | Fresno | 19 | 0 | ||
363469 | 363469 | Havasu Lake | Havasu Lake | 2022-03-15 | San Bernardino | 71 | 0 | 0 | |
363967 | 363967 | Dos Palos | Dos Palos | 2022-03-14 | Fresno | 19 | 0 | ||
364741 | 364741 | Havasu Lake | Havasu Lake | 2022-03-14 | San Bernardino | 71 | 0 | 0 | |
365239 | 365239 | Dos Palos | Dos Palos | 2022-03-13 | Fresno | 19 | 0 | ||
366013 | 366013 | Havasu Lake | Havasu Lake | 2022-03-13 | San Bernardino | 71 | 0 | 0 | |
366511 | 366511 | Dos Palos | Dos Palos | 2022-03-12 | Fresno | 19 | 0 | ||
367285 | 367285 | Havasu Lake | Havasu Lake | 2022-03-12 | San Bernardino | 71 | 0 | 0 | |
367783 | 367783 | Dos Palos | Dos Palos | 2022-03-11 | Fresno | 19 | 0 | ||
368557 | 368557 | Havasu Lake | Havasu Lake | 2022-03-11 | San Bernardino | 71 | 0 | 0 | |
369055 | 369055 | Dos Palos | Dos Palos | 2022-03-10 | Fresno | 19 | 0 | ||
369829 | 369829 | Havasu Lake | Havasu Lake | 2022-03-10 | San Bernardino | 71 | 0 | 0 | |
370327 | 370327 | Dos Palos | Dos Palos | 2022-03-09 | Fresno | 19 | 0 | ||
371101 | 371101 | Havasu Lake | Havasu Lake | 2022-03-09 | San Bernardino | 71 | 0 | 0 | |
371599 | 371599 | Dos Palos | Dos Palos | 2022-03-08 | Fresno | 19 | 0 | ||
372373 | 372373 | Havasu Lake | Havasu Lake | 2022-03-08 | San Bernardino | 71 | 0 | 0 | |
372871 | 372871 | Dos Palos | Dos Palos | 2022-03-07 | Fresno | 19 | 0 | ||
373645 | 373645 | Havasu Lake | Havasu Lake | 2022-03-07 | San Bernardino | 71 | 0 | 0 | |
374143 | 374143 | Dos Palos | Dos Palos | 2022-03-06 | Fresno | 19 | 0 | ||
374917 | 374917 | Havasu Lake | Havasu Lake | 2022-03-06 | San Bernardino | 71 | 0 | 0 | |
375415 | 375415 | Dos Palos | Dos Palos | 2022-03-05 | Fresno | 19 | 0 | ||
376189 | 376189 | Havasu Lake | Havasu Lake | 2022-03-05 | San Bernardino | 71 | 0 | 0 | |
376687 | 376687 | Dos Palos | Dos Palos | 2022-03-04 | Fresno | 19 | 0 | ||
377461 | 377461 | Havasu Lake | Havasu Lake | 2022-03-04 | San Bernardino | 71 | 0 | 0 | |
377959 | 377959 | Dos Palos | Dos Palos | 2022-03-03 | Fresno | 19 | 0 | ||
378733 | 378733 | Havasu Lake | Havasu Lake | 2022-03-03 | San Bernardino | 71 | 0 | 0 | |
379231 | 379231 | Dos Palos | Dos Palos | 2022-03-02 | Fresno | 19 | 0 | ||
380005 | 380005 | Havasu Lake | Havasu Lake | 2022-03-02 | San Bernardino | 71 | 0 | 0 | |
380503 | 380503 | Dos Palos | Dos Palos | 2022-03-01 | Fresno | 19 | 0 | ||
381277 | 381277 | Havasu Lake | Havasu Lake | 2022-03-01 | San Bernardino | 71 | 0 | 0 | |
381780 | 381780 | Dos Palos | Dos Palos | 2022-02-28 | Fresno | 19 | 0 | ||
382554 | 382554 | Havasu Lake | Havasu Lake | 2022-02-28 | San Bernardino | 71 | 0 | 0 | |
383057 | 383057 | Dos Palos | Dos Palos | 2022-02-27 | Fresno | 19 | 0 | ||
383831 | 383831 | Havasu Lake | Havasu Lake | 2022-02-27 | San Bernardino | 71 | 0 | 0 | |
384334 | 384334 | Dos Palos | Dos Palos | 2022-02-26 | Fresno | 19 | 0 | ||
385108 | 385108 | Havasu Lake | Havasu Lake | 2022-02-26 | San Bernardino | 71 | 0 | 0 | |
385611 | 385611 | Dos Palos | Dos Palos | 2022-02-25 | Fresno | 19 | 0 | ||
386385 | 386385 | Havasu Lake | Havasu Lake | 2022-02-25 | San Bernardino | 71 | 0 | 0 | |
386888 | 386888 | Dos Palos | Dos Palos | 2022-02-24 | Fresno | 19 | 0 | ||
387662 | 387662 | Havasu Lake | Havasu Lake | 2022-02-24 | San Bernardino | 71 | 0 | 0 | |
388165 | 388165 | Dos Palos | Dos Palos | 2022-02-23 | Fresno | 19 | 0 | ||
388939 | 388939 | Havasu Lake | Havasu Lake | 2022-02-23 | San Bernardino | 71 | 0 | 0 | |
389442 | 389442 | Dos Palos | Dos Palos | 2022-02-22 | Fresno | 19 | 0 | ||
390216 | 390216 | Havasu Lake | Havasu Lake | 2022-02-22 | San Bernardino | 71 | 0 | 0 | |
390719 | 390719 | Dos Palos | Dos Palos | 2022-02-21 | Fresno | 19 | 0 | ||
391493 | 391493 | Havasu Lake | Havasu Lake | 2022-02-21 | San Bernardino | 71 | 0 | 0 | |
391980 | 391980 | Dos Palos | Dos Palos | 2022-02-20 | Fresno | 19 | 0 | ||
392754 | 392754 | Havasu Lake | Havasu Lake | 2022-02-20 | San Bernardino | 71 | 0 | 0 | |
393241 | 393241 | Dos Palos | Dos Palos | 2022-02-19 | Fresno | 19 | 0 | ||
394015 | 394015 | Havasu Lake | Havasu Lake | 2022-02-19 | San Bernardino | 71 | 0 | 0 | |
394502 | 394502 | Dos Palos | Dos Palos | 2022-02-18 | Fresno | 19 | 0 | ||
395276 | 395276 | Havasu Lake | Havasu Lake | 2022-02-18 | San Bernardino | 71 | 0 | 0 | |
395763 | 395763 | Dos Palos | Dos Palos | 2022-02-17 | Fresno | 19 | 0 | ||
396537 | 396537 | Havasu Lake | Havasu Lake | 2022-02-17 | San Bernardino | 71 | 0 | 0 | |
397024 | 397024 | Dos Palos | Dos Palos | 2022-02-16 | Fresno | 19 | 0 | ||
397798 | 397798 | Havasu Lake | Havasu Lake | 2022-02-16 | San Bernardino | 71 | 0 | 0 | |
398285 | 398285 | Dos Palos | Dos Palos | 2022-02-15 | Fresno | 19 | 0 | ||
399059 | 399059 | Havasu Lake | Havasu Lake | 2022-02-15 | San Bernardino | 71 | 0 | 0 | |
399545 | 399545 | Dinuba | Dinuba | 2022-02-14 | Fresno | 19 | 0 | 0 | |
399546 | 399546 | Dos Palos | Dos Palos | 2022-02-14 | Fresno | 19 | 0 | ||
400320 | 400320 | Havasu Lake | Havasu Lake | 2022-02-14 | San Bernardino | 71 | 0 | 0 | |
400806 | 400806 | Dinuba | Dinuba | 2022-02-13 | Fresno | 19 | 0 | 0 | |
400807 | 400807 | Dos Palos | Dos Palos | 2022-02-13 | Fresno | 19 | 0 | ||
401581 | 401581 | Havasu Lake | Havasu Lake | 2022-02-13 | San Bernardino | 71 | 0 | 0 | |
402067 | 402067 | Dinuba | Dinuba | 2022-02-12 | Fresno | 19 | 0 | 0 | |
402068 | 402068 | Dos Palos | Dos Palos | 2022-02-12 | Fresno | 19 | 0 | ||
402842 | 402842 | Havasu Lake | Havasu Lake | 2022-02-12 | San Bernardino | 71 | 0 | 0 | |
403328 | 403328 | Dinuba | Dinuba | 2022-02-11 | Fresno | 19 | 0 | 0 | |
403329 | 403329 | Dos Palos | Dos Palos | 2022-02-11 | Fresno | 19 | 0 | ||
404103 | 404103 | Havasu Lake | Havasu Lake | 2022-02-11 | San Bernardino | 71 | 0 | 0 | |
404589 | 404589 | Dinuba | Dinuba | 2022-02-10 | Fresno | 19 | 0 | 0 | |
404590 | 404590 | Dos Palos | Dos Palos | 2022-02-10 | Fresno | 19 | 0 | ||
405364 | 405364 | Havasu Lake | Havasu Lake | 2022-02-10 | San Bernardino | 71 | 0 | 0 | |
405850 | 405850 | Dinuba | Dinuba | 2022-02-09 | Fresno | 19 | 0 | 0 |
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] INTEGER );