⚠️ 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

9,050 rows where county = "Fresno" sorted by date descending

View and edit SQL

fips

  • 19 9,050

county

  • Fresno · 9,050
Link rowid id name date ▲ county fips confirmed_cases note population
117 Auberry Auberry 2021-04-10 Fresno 19 113   3994
118 Biola Biola 2021-04-10 Fresno 19 171   949
119 Cantua Creek Cantua Creek 2021-04-10 Fresno 19 120   1125
120 Caruthers Caruthers 2021-04-10 Fresno 19 660   5887
121 Clovis Clovis 2021-04-10 Fresno 19 8086   122949
122 Coalinga Coalinga 2021-04-10 Fresno 19 3842   19345
123 Del Rey Del Rey 2021-04-10 Fresno 19 307   2759
124 Firebaugh Firebaugh 2021-04-10 Fresno 19 1061   9965
125 Fowler Fowler 2021-04-10 Fresno 19 1014   7917
126 Fresno Fresno 2021-04-10 Fresno 19 58343   608579
127 Huron Huron 2021-04-10 Fresno 19 889   7579
128 Kerman Kerman 2021-04-10 Fresno 19 2580   21009
129 Kingsburg Kingsburg 2021-04-10 Fresno 19 1318   17086
130 Laton Laton 2021-04-10 Fresno 19 326   3513
131 Mendota Mendota 2021-04-10 Fresno 19 1796   13576
132 Orange Cove Orange Cove 2021-04-10 Fresno 19 1551   11320
133 Parlier Parlier 2021-04-10 Fresno 19 2521   17097
134 Reedley Reedley 2021-04-10 Fresno 19 3513   31129
135 Riverdale Riverdale 2021-04-10 Fresno 19 701   6459
136 San Joaquin San Joaquin 2021-04-10 Fresno 19 491   4633
137 Sanger Sanger 2021-04-10 Fresno 19 4549   38252
138 Selma Selma 2021-04-10 Fresno 19 4293   31726
139 Squaw Valley Squaw Valley 2021-04-10 Fresno 19 101   3908
140 Tollhouse Tollhouse 2021-04-10 Fresno 19 85   2712
141 Tranquillity Tranquillity 2021-04-10 Fresno 19 98   1132
1484 Auberry Auberry 2021-04-09 Fresno 19 113   3994
1485 Biola Biola 2021-04-09 Fresno 19 171   949
1486 Cantua Creek Cantua Creek 2021-04-09 Fresno 19 120   1125
1487 Caruthers Caruthers 2021-04-09 Fresno 19 660   5887
1488 Clovis Clovis 2021-04-09 Fresno 19 8086   122949
1489 Coalinga Coalinga 2021-04-09 Fresno 19 3842   19345
1490 Del Rey Del Rey 2021-04-09 Fresno 19 307   2759
1491 Firebaugh Firebaugh 2021-04-09 Fresno 19 1061   9965
1492 Fowler Fowler 2021-04-09 Fresno 19 1014   7917
1493 Fresno Fresno 2021-04-09 Fresno 19 58343   608579
1494 Huron Huron 2021-04-09 Fresno 19 889   7579
1495 Kerman Kerman 2021-04-09 Fresno 19 2580   21009
1496 Kingsburg Kingsburg 2021-04-09 Fresno 19 1318   17086
1497 Laton Laton 2021-04-09 Fresno 19 326   3513
1498 Mendota Mendota 2021-04-09 Fresno 19 1796   13576
1499 Orange Cove Orange Cove 2021-04-09 Fresno 19 1551   11320
1500 Parlier Parlier 2021-04-09 Fresno 19 2521   17097
1501 Reedley Reedley 2021-04-09 Fresno 19 3513   31129
1502 Riverdale Riverdale 2021-04-09 Fresno 19 701   6459
1503 San Joaquin San Joaquin 2021-04-09 Fresno 19 491   4633
1504 Sanger Sanger 2021-04-09 Fresno 19 4549   38252
1505 Selma Selma 2021-04-09 Fresno 19 4293   31726
1506 Squaw Valley Squaw Valley 2021-04-09 Fresno 19 101   3908
1507 Tollhouse Tollhouse 2021-04-09 Fresno 19 85   2712
1508 Tranquillity Tranquillity 2021-04-09 Fresno 19 98   1132
2851 Auberry Auberry 2021-04-08 Fresno 19 113   3994
2852 Biola Biola 2021-04-08 Fresno 19 171   949
2853 Cantua Creek Cantua Creek 2021-04-08 Fresno 19 120   1125
2854 Caruthers Caruthers 2021-04-08 Fresno 19 660   5887
2855 Clovis Clovis 2021-04-08 Fresno 19 8086   122949
2856 Coalinga Coalinga 2021-04-08 Fresno 19 3842   19345
2857 Del Rey Del Rey 2021-04-08 Fresno 19 307   2759
2858 Firebaugh Firebaugh 2021-04-08 Fresno 19 1061   9965
2859 Fowler Fowler 2021-04-08 Fresno 19 1014   7917
2860 Fresno Fresno 2021-04-08 Fresno 19 58343   608579
2861 Huron Huron 2021-04-08 Fresno 19 889   7579
2862 Kerman Kerman 2021-04-08 Fresno 19 2580   21009
2863 Kingsburg Kingsburg 2021-04-08 Fresno 19 1318   17086
2864 Laton Laton 2021-04-08 Fresno 19 326   3513
2865 Mendota Mendota 2021-04-08 Fresno 19 1796   13576
2866 Orange Cove Orange Cove 2021-04-08 Fresno 19 1551   11320
2867 Parlier Parlier 2021-04-08 Fresno 19 2521   17097
2868 Reedley Reedley 2021-04-08 Fresno 19 3513   31129
2869 Riverdale Riverdale 2021-04-08 Fresno 19 701   6459
2870 San Joaquin San Joaquin 2021-04-08 Fresno 19 491   4633
2871 Sanger Sanger 2021-04-08 Fresno 19 4549   38252
2872 Selma Selma 2021-04-08 Fresno 19 4293   31726
2873 Squaw Valley Squaw Valley 2021-04-08 Fresno 19 101   3908
2874 Tollhouse Tollhouse 2021-04-08 Fresno 19 85   2712
2875 Tranquillity Tranquillity 2021-04-08 Fresno 19 98   1132
4221 Auberry Auberry 2021-04-07 Fresno 19 113   3994
4222 Biola Biola 2021-04-07 Fresno 19 171   949
4223 Cantua Creek Cantua Creek 2021-04-07 Fresno 19 120   1125
4224 Caruthers Caruthers 2021-04-07 Fresno 19 660   5887
4225 Clovis Clovis 2021-04-07 Fresno 19 8086   122949
4226 Coalinga Coalinga 2021-04-07 Fresno 19 3842   19345
4227 Del Rey Del Rey 2021-04-07 Fresno 19 307   2759
4228 Firebaugh Firebaugh 2021-04-07 Fresno 19 1061   9965
4229 Fowler Fowler 2021-04-07 Fresno 19 1014   7917
4230 Fresno Fresno 2021-04-07 Fresno 19 58343   608579
4231 Huron Huron 2021-04-07 Fresno 19 889   7579
4232 Kerman Kerman 2021-04-07 Fresno 19 2580   21009
4233 Kingsburg Kingsburg 2021-04-07 Fresno 19 1318   17086
4234 Laton Laton 2021-04-07 Fresno 19 326   3513
4235 Mendota Mendota 2021-04-07 Fresno 19 1796   13576
4236 Orange Cove Orange Cove 2021-04-07 Fresno 19 1551   11320
4237 Parlier Parlier 2021-04-07 Fresno 19 2521   17097
4238 Reedley Reedley 2021-04-07 Fresno 19 3513   31129
4239 Riverdale Riverdale 2021-04-07 Fresno 19 701   6459
4240 San Joaquin San Joaquin 2021-04-07 Fresno 19 491   4633
4241 Sanger Sanger 2021-04-07 Fresno 19 4549   38252
4242 Selma Selma 2021-04-07 Fresno 19 4293   31726
4243 Squaw Valley Squaw Valley 2021-04-07 Fresno 19 101   3908
4244 Tollhouse Tollhouse 2021-04-07 Fresno 19 85   2712
4245 Tranquillity Tranquillity 2021-04-07 Fresno 19 98   1132

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [latimes_place_totals] (
   [id] TEXT,
   [name] TEXT,
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [confirmed_cases] INTEGER,
   [note] TEXT,
   [population] TEXT
);