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

31,712 rows where county = "Fresno" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips 1

  • 19 31,712

county 1

  • Fresno · 31,712 ✖
Link rowid id name date ▲ county fips confirmed_cases note population
96 96 Auberry Auberry 2022-12-30 Fresno 19 407   3994
97 97 Biola Biola 2022-12-30 Fresno 19 469   949
98 98 Cantua Creek Cantua Creek 2022-12-30 Fresno 19 306   1125
99 99 Caruthers Caruthers 2022-12-30 Fresno 19 1583   5887
100 100 Clovis Clovis 2022-12-30 Fresno 19 28757   122949
101 101 Coalinga Coalinga 2022-12-30 Fresno 19 7754   19345
102 102 Del Rey Del Rey 2022-12-30 Fresno 19 768   2759
103 103 Dinuba Dinuba 2022-12-30 Fresno 19 131   0
104 104 Dos Palos Dos Palos 2022-12-30 Fresno 19 107    
105 105 Dunlap Dunlap 2022-12-30 Fresno 19 89    
106 106 Firebaugh Firebaugh 2022-12-30 Fresno 19 2627   9965
107 107 Five Points Five Points 2022-12-30 Fresno 19 157   0
108 108 Fowler Fowler 2022-12-30 Fresno 19 2712   7917
109 109 Fresno Fresno 2022-12-30 Fresno 19 173123   608579
110 110 Friant Friant 2022-12-30 Fresno 19 317   1930
111 111 Huron Huron 2022-12-30 Fresno 19 1856   7579
112 112 Kerman Kerman 2022-12-30 Fresno 19 6093   21009
113 113 Kingsburg Kingsburg 2022-12-30 Fresno 19 3614   17086
114 114 Laton Laton 2022-12-30 Fresno 19 892   3513
115 115 Mendota Mendota 2022-12-30 Fresno 19 3625   13576
116 116 Orange Cove Orange Cove 2022-12-30 Fresno 19 3571   11320
117 117 Parlier Parlier 2022-12-30 Fresno 19 5854   17097
118 118 Prather Prather 2022-12-30 Fresno 19 205   0
119 119 Raisin Raisin 2022-12-30 Fresno 19 151   380
120 120 Reedley Reedley 2022-12-30 Fresno 19 8958   31129
121 121 Riverdale Riverdale 2022-12-30 Fresno 19 1900   6459
122 122 San Joaquin San Joaquin 2022-12-30 Fresno 19 1212   4633
123 123 Sanger Sanger 2022-12-30 Fresno 19 12129   38252
124 124 Selma Selma 2022-12-30 Fresno 19 10706   31726
125 125 Squaw Valley Squaw Valley 2022-12-30 Fresno 19 423   3908
126 126 Tollhouse Tollhouse 2022-12-30 Fresno 19 302   2712
127 127 Tranquillity Tranquillity 2022-12-30 Fresno 19 275   1132
924 924 Auberry Auberry 2022-12-29 Fresno 19 407   3994
925 925 Biola Biola 2022-12-29 Fresno 19 469   949
926 926 Cantua Creek Cantua Creek 2022-12-29 Fresno 19 306   1125
927 927 Caruthers Caruthers 2022-12-29 Fresno 19 1583   5887
928 928 Clovis Clovis 2022-12-29 Fresno 19 28757   122949
929 929 Coalinga Coalinga 2022-12-29 Fresno 19 7754   19345
930 930 Del Rey Del Rey 2022-12-29 Fresno 19 768   2759
931 931 Dinuba Dinuba 2022-12-29 Fresno 19 131   0
932 932 Dos Palos Dos Palos 2022-12-29 Fresno 19 107    
933 933 Dunlap Dunlap 2022-12-29 Fresno 19 89    
934 934 Firebaugh Firebaugh 2022-12-29 Fresno 19 2627   9965
935 935 Five Points Five Points 2022-12-29 Fresno 19 157   0
936 936 Fowler Fowler 2022-12-29 Fresno 19 2712   7917
937 937 Fresno Fresno 2022-12-29 Fresno 19 173123   608579
938 938 Friant Friant 2022-12-29 Fresno 19 317   1930
939 939 Huron Huron 2022-12-29 Fresno 19 1856   7579
940 940 Kerman Kerman 2022-12-29 Fresno 19 6093   21009
941 941 Kingsburg Kingsburg 2022-12-29 Fresno 19 3614   17086
942 942 Laton Laton 2022-12-29 Fresno 19 892   3513
943 943 Mendota Mendota 2022-12-29 Fresno 19 3625   13576
944 944 Orange Cove Orange Cove 2022-12-29 Fresno 19 3571   11320
945 945 Parlier Parlier 2022-12-29 Fresno 19 5854   17097
946 946 Prather Prather 2022-12-29 Fresno 19 205   0
947 947 Raisin Raisin 2022-12-29 Fresno 19 151   380
948 948 Reedley Reedley 2022-12-29 Fresno 19 8958   31129
949 949 Riverdale Riverdale 2022-12-29 Fresno 19 1900   6459
950 950 San Joaquin San Joaquin 2022-12-29 Fresno 19 1212   4633
951 951 Sanger Sanger 2022-12-29 Fresno 19 12129   38252
952 952 Selma Selma 2022-12-29 Fresno 19 10706   31726
953 953 Squaw Valley Squaw Valley 2022-12-29 Fresno 19 423   3908
954 954 Tollhouse Tollhouse 2022-12-29 Fresno 19 302   2712
955 955 Tranquillity Tranquillity 2022-12-29 Fresno 19 275   1132
1752 1752 Auberry Auberry 2022-12-28 Fresno 19 407   3994
1753 1753 Biola Biola 2022-12-28 Fresno 19 469   949
1754 1754 Cantua Creek Cantua Creek 2022-12-28 Fresno 19 306   1125
1755 1755 Caruthers Caruthers 2022-12-28 Fresno 19 1583   5887
1756 1756 Clovis Clovis 2022-12-28 Fresno 19 28757   122949
1757 1757 Coalinga Coalinga 2022-12-28 Fresno 19 7754   19345
1758 1758 Del Rey Del Rey 2022-12-28 Fresno 19 768   2759
1759 1759 Dinuba Dinuba 2022-12-28 Fresno 19 131   0
1760 1760 Dos Palos Dos Palos 2022-12-28 Fresno 19 107    
1761 1761 Dunlap Dunlap 2022-12-28 Fresno 19 89    
1762 1762 Firebaugh Firebaugh 2022-12-28 Fresno 19 2627   9965
1763 1763 Five Points Five Points 2022-12-28 Fresno 19 157   0
1764 1764 Fowler Fowler 2022-12-28 Fresno 19 2712   7917
1765 1765 Fresno Fresno 2022-12-28 Fresno 19 173123   608579
1766 1766 Friant Friant 2022-12-28 Fresno 19 317   1930
1767 1767 Huron Huron 2022-12-28 Fresno 19 1856   7579
1768 1768 Kerman Kerman 2022-12-28 Fresno 19 6093   21009
1769 1769 Kingsburg Kingsburg 2022-12-28 Fresno 19 3614   17086
1770 1770 Laton Laton 2022-12-28 Fresno 19 892   3513
1771 1771 Mendota Mendota 2022-12-28 Fresno 19 3625   13576
1772 1772 Orange Cove Orange Cove 2022-12-28 Fresno 19 3571   11320
1773 1773 Parlier Parlier 2022-12-28 Fresno 19 5854   17097
1774 1774 Prather Prather 2022-12-28 Fresno 19 205   0
1775 1775 Raisin Raisin 2022-12-28 Fresno 19 151   380
1776 1776 Reedley Reedley 2022-12-28 Fresno 19 8958   31129
1777 1777 Riverdale Riverdale 2022-12-28 Fresno 19 1900   6459
1778 1778 San Joaquin San Joaquin 2022-12-28 Fresno 19 1212   4633
1779 1779 Sanger Sanger 2022-12-28 Fresno 19 12129   38252
1780 1780 Selma Selma 2022-12-28 Fresno 19 10706   31726
1781 1781 Squaw Valley Squaw Valley 2022-12-28 Fresno 19 423   3908
1782 1782 Tollhouse Tollhouse 2022-12-28 Fresno 19 302   2712
1783 1783 Tranquillity Tranquillity 2022-12-28 Fresno 19 275   1132
2933 2933 Auberry Auberry 2022-12-27 Fresno 19 407   3994
2934 2934 Biola Biola 2022-12-27 Fresno 19 469   949
2935 2935 Cantua Creek Cantua Creek 2022-12-27 Fresno 19 306   1125
2936 2936 Caruthers Caruthers 2022-12-27 Fresno 19 1583   5887

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
);