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,393 rows where county = "Fresno" sorted by date descending

View and edit SQL

Suggested facets: note, date (date)

fips

  • 19 2,393

county

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