latimes_place_totals

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

This data as json, yaml, Notebook, copyable, CSV (advanced)

fips

  • 19 9,050

county

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