⚠️ 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,075 rows where fips = 19 sorted by date descending

View and edit SQL

fips

  • 19 · 9,075

county

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