Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
This data as json, yaml, copyable, CSV (advanced)
Suggested facets: note, date (date)
place
fips
county
| Link | rowid | date ▲ | county | fips | place | confirmed_cases | note | x | y |
|---|---|---|---|---|---|---|---|---|---|
| 74 | 74 | 2020-10-30 | Fresno | 19 | Auberry | 35 | -119.401944 | 37.066111 | |
| 75 | 75 | 2020-10-30 | Fresno | 19 | Biola | 68 | -120.01717 | 36.802306 | |
| 76 | 76 | 2020-10-30 | Fresno | 19 | Cantua Creek | 38 | -120.316389 | 36.501389 | |
| 77 | 77 | 2020-10-30 | Fresno | 19 | Caruthers | 282 | -119.834562 | 36.542564 | |
| 78 | 78 | 2020-10-30 | Fresno | 19 | Clovis | 1882 | -119.703056 | 36.825278 | |
| 79 | 79 | 2020-10-30 | Fresno | 19 | Coalinga | 516 | -120.360278 | 36.139722 | |
| 80 | 80 | 2020-10-30 | Fresno | 19 | Del Rey | 125 | -119.593694 | 36.659187 | |
| 81 | 81 | 2020-10-30 | Fresno | 19 | Dunlap | 6 | -119.120898 | 36.737991 | |
| 82 | 82 | 2020-10-30 | Fresno | 19 | Firebaugh | 372 | -120.456111 | 36.858889 | |
| 83 | 83 | 2020-10-30 | Fresno | 19 | Five Points | 16 | -120.102441 | 36.428874 | |
| 84 | 84 | 2020-10-30 | Fresno | 19 | Fowler | 275 | -119.683333 | 36.633333 | |
| 85 | 85 | 2020-10-30 | Fresno | 19 | Fresno | 17658 | -119.766667 | 36.75 | |
| 86 | 86 | 2020-10-30 | Fresno | 19 | Fresno County | 31594 | |||
| 87 | 87 | 2020-10-30 | Fresno | 19 | Friant | 22 | -119.711944 | 36.987778 | |
| 88 | 88 | 2020-10-30 | Fresno | 19 | Huron | 427 | -120.103056 | 36.202778 | |
| 89 | 89 | 2020-10-30 | Fresno | 19 | Kerman | 929 | -120.06 | 36.723611 | |
| 90 | 90 | 2020-10-30 | Fresno | 19 | Kingsburg | 463 | -119.553889 | 36.513889 | |
| 91 | 91 | 2020-10-30 | Fresno | 19 | Laton | 135 | -119.686686 | 36.433282 | |
| 92 | 92 | 2020-10-30 | Fresno | 19 | Mendota | 999 | -120.381667 | 36.753611 | |
| 93 | 93 | 2020-10-30 | Fresno | 19 | Orange Cove | 695 | -119.313611 | 36.624444 | |
| 94 | 94 | 2020-10-30 | Fresno | 19 | Other | 238 | |||
| 95 | 95 | 2020-10-30 | Fresno | 19 | Parlier | 1138 | -119.526944 | 36.611667 | |
| 96 | 96 | 2020-10-30 | Fresno | 19 | Pinedale | 18 | -119.79 | 36.842778 | |
| 97 | 97 | 2020-10-30 | Fresno | 19 | Prather | 12 | -119.513889 | 37.0375 | |
| 98 | 98 | 2020-10-30 | Fresno | 19 | Raisin City | 34 | -119.904167 | 36.6025 | |
| 99 | 99 | 2020-10-30 | Fresno | 19 | Reedley | 1458 | -119.450278 | 36.596389 | |
| 100 | 100 | 2020-10-30 | Fresno | 19 | Riverdale | 269 | -119.859444 | 36.431111 | |
| 101 | 101 | 2020-10-30 | Fresno | 19 | San Joaquin | 206 | -120.189167 | 36.606667 | |
| 102 | 102 | 2020-10-30 | Fresno | 19 | Sanger | 1449 | -119.555833 | 36.708056 | |
| 103 | 103 | 2020-10-30 | Fresno | 19 | Selma | 1600 | -119.611944 | 36.570833 | |
| 104 | 104 | 2020-10-30 | Fresno | 19 | Squaw Valley | 20 | -119.246779 | 36.740263 | |
| 105 | 105 | 2020-10-30 | Fresno | 19 | Tollhouse | 17 | -119.399167 | 37.018889 | |
| 106 | 106 | 2020-10-30 | Fresno | 19 | Tranquillity | 36 | -120.252778 | 36.648889 | |
| 3057 | 3057 | 2020-10-27 | Fresno | 19 | Auberry | 35 | -119.401944 | 37.066111 | |
| 3058 | 3058 | 2020-10-27 | Fresno | 19 | Biola | 68 | -120.01717 | 36.802306 | |
| 3059 | 3059 | 2020-10-27 | Fresno | 19 | Cantua Creek | 38 | -120.316389 | 36.501389 | |
| 3060 | 3060 | 2020-10-27 | Fresno | 19 | Caruthers | 281 | -119.834562 | 36.542564 | |
| 3061 | 3061 | 2020-10-27 | Fresno | 19 | Clovis | 1852 | -119.703056 | 36.825278 | |
| 3062 | 3062 | 2020-10-27 | Fresno | 19 | Del Rey | 125 | -119.593694 | 36.659187 | |
| 3063 | 3063 | 2020-10-27 | Fresno | 19 | Dunlap | 6 | -119.120898 | 36.737991 | |
| 3064 | 3064 | 2020-10-27 | Fresno | 19 | Firebaugh | 371 | -120.456111 | 36.858889 | |
| 3065 | 3065 | 2020-10-27 | Fresno | 19 | Five Points | 15 | -120.102441 | 36.428874 | |
| 3066 | 3066 | 2020-10-27 | Fresno | 19 | Fowler | 268 | -119.683333 | 36.633333 | |
| 3067 | 3067 | 2020-10-27 | Fresno | 19 | Fresno | 17408 | -119.766667 | 36.75 | |
| 3068 | 3068 | 2020-10-27 | Fresno | 19 | Friant | 23 | -119.711944 | 36.987778 | |
| 3069 | 3069 | 2020-10-27 | Fresno | 19 | Huron | 426 | -120.103056 | 36.202778 | |
| 3070 | 3070 | 2020-10-27 | Fresno | 19 | Kerman | 925 | -120.06 | 36.723611 | |
| 3071 | 3071 | 2020-10-27 | Fresno | 19 | Kingsburg | 459 | -119.553889 | 36.513889 | |
| 3072 | 3072 | 2020-10-27 | Fresno | 19 | Laton | 135 | -119.686686 | 36.433282 | |
| 3073 | 3073 | 2020-10-27 | Fresno | 19 | Mendota | 998 | -120.381667 | 36.753611 | |
| 3074 | 3074 | 2020-10-27 | Fresno | 19 | Orange Cove | 691 | -119.313611 | 36.624444 | |
| 3075 | 3075 | 2020-10-27 | Fresno | 19 | Other | 238 | |||
| 3076 | 3076 | 2020-10-27 | Fresno | 19 | Parlier | 1131 | -119.526944 | 36.611667 | |
| 3077 | 3077 | 2020-10-27 | Fresno | 19 | Pinedale | 18 | -119.79 | 36.842778 | |
| 3078 | 3078 | 2020-10-27 | Fresno | 19 | Prather | 12 | -119.513889 | 37.0375 | |
| 3079 | 3079 | 2020-10-27 | Fresno | 19 | Raisin City | 34 | -119.904167 | 36.6025 | |
| 3080 | 3080 | 2020-10-27 | Fresno | 19 | Reedley | 1452 | -119.450278 | 36.596389 | |
| 3081 | 3081 | 2020-10-27 | Fresno | 19 | Riverdale | 268 | -119.859444 | 36.431111 | |
| 3082 | 3082 | 2020-10-27 | Fresno | 19 | San Joaquin | 206 | -120.189167 | 36.606667 | |
| 3083 | 3083 | 2020-10-27 | Fresno | 19 | Sanger | 1441 | -119.555833 | 36.708056 | |
| 3084 | 3084 | 2020-10-27 | Fresno | 19 | Selma | 1587 | -119.611944 | 36.570833 | |
| 3085 | 3085 | 2020-10-27 | Fresno | 19 | Squaw Valley | 20 | -119.246779 | 36.740263 | |
| 3086 | 3086 | 2020-10-27 | Fresno | 19 | Tollhouse | 17 | -119.399167 | 37.018889 | |
| 3087 | 3087 | 2020-10-27 | Fresno | 19 | Tranquillity | 36 | -120.252778 | 36.648889 | |
| 6263 | 6263 | 2020-10-23 | Fresno | 19 | Auberry | 35 | -119.401944 | 37.066111 | |
| 6264 | 6264 | 2020-10-23 | Fresno | 19 | Biola | 68 | -120.01717 | 36.802306 | |
| 6265 | 6265 | 2020-10-23 | Fresno | 19 | Cantua Creek | 37 | -120.316389 | 36.501389 | |
| 6266 | 6266 | 2020-10-23 | Fresno | 19 | Caruthers | 275 | -119.834562 | 36.542564 | |
| 6267 | 6267 | 2020-10-23 | Fresno | 19 | Clovis | 1821 | -119.703056 | 36.825278 | |
| 6268 | 6268 | 2020-10-23 | Fresno | 19 | Coalinga | 497 | -120.360278 | 36.139722 | |
| 6269 | 6269 | 2020-10-23 | Fresno | 19 | Del Rey | 123 | -119.593694 | 36.659187 | |
| 6270 | 6270 | 2020-10-23 | Fresno | 19 | Dunlap | 6 | -119.120898 | 36.737991 | |
| 6271 | 6271 | 2020-10-23 | Fresno | 19 | Firebaugh | 367 | -120.456111 | 36.858889 | |
| 6272 | 6272 | 2020-10-23 | Fresno | 19 | Five Points | 15 | -120.102441 | 36.428874 | |
| 6273 | 6273 | 2020-10-23 | Fresno | 19 | Fowler | 249 | -119.683333 | 36.633333 | |
| 6274 | 6274 | 2020-10-23 | Fresno | 19 | Fresno | 17052 | -119.766667 | 36.75 | |
| 6275 | 6275 | 2020-10-23 | Fresno | 19 | Friant | 22 | -119.711944 | 36.987778 | |
| 6276 | 6276 | 2020-10-23 | Fresno | 19 | Huron | 419 | -120.103056 | 36.202778 | |
| 6277 | 6277 | 2020-10-23 | Fresno | 19 | Kerman | 919 | -120.06 | 36.723611 | |
| 6278 | 6278 | 2020-10-23 | Fresno | 19 | Kingsburg | 454 | -119.553889 | 36.513889 | |
| 6279 | 6279 | 2020-10-23 | Fresno | 19 | Laton | 134 | -119.686686 | 36.433282 | |
| 6280 | 6280 | 2020-10-23 | Fresno | 19 | Mendota | 997 | -120.381667 | 36.753611 | |
| 6281 | 6281 | 2020-10-23 | Fresno | 19 | Orange Cove | 685 | -119.313611 | 36.624444 | |
| 6282 | 6282 | 2020-10-23 | Fresno | 19 | Other | 238 | |||
| 6283 | 6283 | 2020-10-23 | Fresno | 19 | Parlier | 1120 | -119.526944 | 36.611667 | |
| 6284 | 6284 | 2020-10-23 | Fresno | 19 | Pinedale | 19 | -119.79 | 36.842778 | |
| 6285 | 6285 | 2020-10-23 | Fresno | 19 | Prather | 11 | -119.513889 | 37.0375 | |
| 6286 | 6286 | 2020-10-23 | Fresno | 19 | Raisin City | 34 | -119.904167 | 36.6025 | |
| 6287 | 6287 | 2020-10-23 | Fresno | 19 | Reedley | 1443 | -119.450278 | 36.596389 | |
| 6288 | 6288 | 2020-10-23 | Fresno | 19 | Riverdale | 264 | -119.859444 | 36.431111 | |
| 6289 | 6289 | 2020-10-23 | Fresno | 19 | San Joaquin | 206 | -120.189167 | 36.606667 | |
| 6290 | 6290 | 2020-10-23 | Fresno | 19 | Sanger | 1428 | -119.555833 | 36.708056 | |
| 6291 | 6291 | 2020-10-23 | Fresno | 19 | Selma | 1566 | -119.611944 | 36.570833 | |
| 6292 | 6292 | 2020-10-23 | Fresno | 19 | Squaw Valley | 20 | -119.246779 | 36.740263 | |
| 6293 | 6293 | 2020-10-23 | Fresno | 19 | Tollhouse | 17 | -119.399167 | 37.018889 | |
| 6294 | 6294 | 2020-10-23 | Fresno | 19 | Tranquillity | 36 | -120.252778 | 36.648889 | |
| 9265 | 9265 | 2020-10-20 | Fresno | 19 | Auberry | 35 | -119.401944 | 37.066111 | |
| 9266 | 9266 | 2020-10-20 | Fresno | 19 | Biola | 68 | -120.01717 | 36.802306 | |
| 9267 | 9267 | 2020-10-20 | Fresno | 19 | Cantua Creek | 37 | -120.316389 | 36.501389 | |
| 9268 | 9268 | 2020-10-20 | Fresno | 19 | Caruthers | 274 | -119.834562 | 36.542564 |
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_place_totals] ( [date] TEXT, [county] TEXT, [fips] INTEGER, [place] TEXT, [confirmed_cases] INTEGER, [note] TEXT, [x] TEXT, [y] TEXT );