latimes_place_totals

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals

2,361 rows where fips = 19 sorted by date descending

View and edit SQL

Suggested facets: note, date (date)

fips

  • 19 · 2,361

county

Link rowid date ▲ county fips place confirmed_cases note x y
74 2020-10-27 Fresno 19 Auberry 35   -119.401944 37.066111
75 2020-10-27 Fresno 19 Biola 68   -120.01717 36.802306
76 2020-10-27 Fresno 19 Cantua Creek 38   -120.316389 36.501389
77 2020-10-27 Fresno 19 Caruthers 281   -119.834562 36.542564
78 2020-10-27 Fresno 19 Clovis 1852   -119.703056 36.825278
79 2020-10-27 Fresno 19 Coalinga 512   -120.360278 36.139722
80 2020-10-27 Fresno 19 Del Rey 125   -119.593694 36.659187
81 2020-10-27 Fresno 19 Dunlap 6   -119.120898 36.737991
82 2020-10-27 Fresno 19 Firebaugh 371   -120.456111 36.858889
83 2020-10-27 Fresno 19 Five Points 15   -120.102441 36.428874
84 2020-10-27 Fresno 19 Fowler 268   -119.683333 36.633333
85 2020-10-27 Fresno 19 Fresno 17408   -119.766667 36.75
86 2020-10-27 Fresno 19 Friant 23   -119.711944 36.987778
87 2020-10-27 Fresno 19 Huron 426   -120.103056 36.202778
88 2020-10-27 Fresno 19 Kerman 925   -120.06 36.723611
89 2020-10-27 Fresno 19 Kingsburg 459   -119.553889 36.513889
90 2020-10-27 Fresno 19 Laton 135   -119.686686 36.433282
91 2020-10-27 Fresno 19 Mendota 998   -120.381667 36.753611
92 2020-10-27 Fresno 19 Orange Cove 691   -119.313611 36.624444
93 2020-10-27 Fresno 19 Other 238      
94 2020-10-27 Fresno 19 Parlier 1131   -119.526944 36.611667
95 2020-10-27 Fresno 19 Pinedale 18   -119.79 36.842778
96 2020-10-27 Fresno 19 Prather 12   -119.513889 37.0375
97 2020-10-27 Fresno 19 Raisin City 34   -119.904167 36.6025
98 2020-10-27 Fresno 19 Reedley 1452   -119.450278 36.596389
99 2020-10-27 Fresno 19 Riverdale 268   -119.859444 36.431111
100 2020-10-27 Fresno 19 San Joaquin 206   -120.189167 36.606667
101 2020-10-27 Fresno 19 Sanger 1441   -119.555833 36.708056
102 2020-10-27 Fresno 19 Selma 1587   -119.611944 36.570833
103 2020-10-27 Fresno 19 Squaw Valley 20   -119.246779 36.740263
104 2020-10-27 Fresno 19 Tollhouse 17   -119.399167 37.018889
105 2020-10-27 Fresno 19 Tranquillity 36   -120.252778 36.648889
3281 2020-10-23 Fresno 19 Auberry 35   -119.401944 37.066111
3282 2020-10-23 Fresno 19 Biola 68   -120.01717 36.802306
3283 2020-10-23 Fresno 19 Cantua Creek 37   -120.316389 36.501389
3284 2020-10-23 Fresno 19 Caruthers 275   -119.834562 36.542564
3285 2020-10-23 Fresno 19 Clovis 1821   -119.703056 36.825278
3286 2020-10-23 Fresno 19 Coalinga 497   -120.360278 36.139722
3287 2020-10-23 Fresno 19 Del Rey 123   -119.593694 36.659187
3288 2020-10-23 Fresno 19 Dunlap 6   -119.120898 36.737991
3289 2020-10-23 Fresno 19 Firebaugh 367   -120.456111 36.858889
3290 2020-10-23 Fresno 19 Five Points 15   -120.102441 36.428874
3291 2020-10-23 Fresno 19 Fowler 249   -119.683333 36.633333
3292 2020-10-23 Fresno 19 Fresno 17052   -119.766667 36.75
3293 2020-10-23 Fresno 19 Friant 22   -119.711944 36.987778
3294 2020-10-23 Fresno 19 Huron 419   -120.103056 36.202778
3295 2020-10-23 Fresno 19 Kerman 919   -120.06 36.723611
3296 2020-10-23 Fresno 19 Kingsburg 454   -119.553889 36.513889
3297 2020-10-23 Fresno 19 Laton 134   -119.686686 36.433282
3298 2020-10-23 Fresno 19 Mendota 997   -120.381667 36.753611
3299 2020-10-23 Fresno 19 Orange Cove 685   -119.313611 36.624444
3300 2020-10-23 Fresno 19 Other 238      
3301 2020-10-23 Fresno 19 Parlier 1120   -119.526944 36.611667
3302 2020-10-23 Fresno 19 Pinedale 19   -119.79 36.842778
3303 2020-10-23 Fresno 19 Prather 11   -119.513889 37.0375
3304 2020-10-23 Fresno 19 Raisin City 34   -119.904167 36.6025
3305 2020-10-23 Fresno 19 Reedley 1443   -119.450278 36.596389
3306 2020-10-23 Fresno 19 Riverdale 264   -119.859444 36.431111
3307 2020-10-23 Fresno 19 San Joaquin 206   -120.189167 36.606667
3308 2020-10-23 Fresno 19 Sanger 1428   -119.555833 36.708056
3309 2020-10-23 Fresno 19 Selma 1566   -119.611944 36.570833
3310 2020-10-23 Fresno 19 Squaw Valley 20   -119.246779 36.740263
3311 2020-10-23 Fresno 19 Tollhouse 17   -119.399167 37.018889
3312 2020-10-23 Fresno 19 Tranquillity 36   -120.252778 36.648889
6283 2020-10-20 Fresno 19 Auberry 35   -119.401944 37.066111
6284 2020-10-20 Fresno 19 Biola 68   -120.01717 36.802306
6285 2020-10-20 Fresno 19 Cantua Creek 37   -120.316389 36.501389
6286 2020-10-20 Fresno 19 Caruthers 274   -119.834562 36.542564
6287 2020-10-20 Fresno 19 Clovis 1783   -119.703056 36.825278
6288 2020-10-20 Fresno 19 Coalinga 494   -120.360278 36.139722
6289 2020-10-20 Fresno 19 Del Rey 120   -119.593694 36.659187
6290 2020-10-20 Fresno 19 Dunlap 6   -119.120898 36.737991
6291 2020-10-20 Fresno 19 Firebaugh 365   -120.456111 36.858889
6292 2020-10-20 Fresno 19 Five Points 15   -120.102441 36.428874
6293 2020-10-20 Fresno 19 Fowler 244   -119.683333 36.633333
6294 2020-10-20 Fresno 19 Fresno 16729   -119.766667 36.75
6295 2020-10-20 Fresno 19 Friant 22   -119.711944 36.987778
6296 2020-10-20 Fresno 19 Huron 415   -120.103056 36.202778
6297 2020-10-20 Fresno 19 Kerman 906   -120.06 36.723611
6298 2020-10-20 Fresno 19 Kingsburg 450   -119.553889 36.513889
6299 2020-10-20 Fresno 19 Laton 134   -119.686686 36.433282
6300 2020-10-20 Fresno 19 Mendota 996   -120.381667 36.753611
6301 2020-10-20 Fresno 19 Orange Cove 679   -119.313611 36.624444
6302 2020-10-20 Fresno 19 Other 238      
6303 2020-10-20 Fresno 19 Parlier 1112   -119.526944 36.611667
6304 2020-10-20 Fresno 19 Pinedale 19   -119.79 36.842778
6305 2020-10-20 Fresno 19 Prather 11   -119.513889 37.0375
6306 2020-10-20 Fresno 19 Raisin City 33   -119.904167 36.6025
6307 2020-10-20 Fresno 19 Reedley 1435   -119.450278 36.596389
6308 2020-10-20 Fresno 19 Riverdale 263   -119.859444 36.431111
6309 2020-10-20 Fresno 19 San Joaquin 205   -120.189167 36.606667
6310 2020-10-20 Fresno 19 Sanger 1411   -119.555833 36.708056
6311 2020-10-20 Fresno 19 Selma 1549   -119.611944 36.570833
6312 2020-10-20 Fresno 19 Squaw Valley 18   -119.246779 36.740263
6313 2020-10-20 Fresno 19 Tollhouse 16   -119.399167 37.018889
6314 2020-10-20 Fresno 19 Tranquillity 36   -120.252778 36.648889
9472 2020-10-16 Fresno 19 Auberry 35   -119.401944 37.066111
9473 2020-10-16 Fresno 19 Biola 64   -120.01717 36.802306
9474 2020-10-16 Fresno 19 Cantua Creek 37   -120.316389 36.501389
9475 2020-10-16 Fresno 19 Caruthers 266   -119.834562 36.542564

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [latimes_place_totals] (
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [place] TEXT,
   [confirmed_cases] INTEGER,
   [note] TEXT,
   [x] TEXT,
   [y] TEXT
);
Powered by Datasette · Query took 932.142ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals