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

1,169 rows where county = "Kings" sorted by date descending

View and edit SQL

Suggested facets: note, x, y, date (date)

fips

  • 31 1,169

county

  • Kings · 1,169
Link rowid date ▲ county fips place confirmed_cases note x y
122 2020-10-23 Kings 31 Armona 175   -119.708728 36.315187
123 2020-10-23 Kings 31 Avenal 433   -120.128876 36.004087
124 2020-10-23 Kings 31 Corcoran 674   -119.560654 36.097923
125 2020-10-23 Kings 31 Hanford 2131   -119.64573 36.327428
126 2020-10-23 Kings 31 Kettleman City 66   -119.960005 36.008623
127 2020-10-23 Kings 31 Lemoore 955   -119.782993 36.300838
128 2020-10-23 Kings 31 Other 67      
129 2020-10-23 Kings 31 Prisons 3634      
130 2020-10-23 Kings 31 Stratford 61   -119.822485 36.189369
1124 2020-10-22 Kings 31 Armona 175   -119.708728 36.315187
1125 2020-10-22 Kings 31 Avenal 432   -120.128876 36.004087
1126 2020-10-22 Kings 31 Corcoran 672   -119.560654 36.097923
1127 2020-10-22 Kings 31 Hanford 2120   -119.64573 36.327428
1128 2020-10-22 Kings 31 Kettleman City 66   -119.960005 36.008623
1129 2020-10-22 Kings 31 Lemoore 953   -119.782993 36.300838
1130 2020-10-22 Kings 31 Other 67      
1131 2020-10-22 Kings 31 Prisons 3634      
1132 2020-10-22 Kings 31 Stratford 61   -119.822485 36.189369
2077 2020-10-21 Kings 31 Armona 173   -119.708728 36.315187
2078 2020-10-21 Kings 31 Avenal 430   -120.128876 36.004087
2079 2020-10-21 Kings 31 Corcoran 671   -119.560654 36.097923
2080 2020-10-21 Kings 31 Hanford 2110   -119.64573 36.327428
2081 2020-10-21 Kings 31 Kettleman City 66   -119.960005 36.008623
2082 2020-10-21 Kings 31 Lemoore 951   -119.782993 36.300838
2083 2020-10-21 Kings 31 Other 68      
2084 2020-10-21 Kings 31 Prisons 3634      
2085 2020-10-21 Kings 31 Stratford 61   -119.822485 36.189369
3096 2020-10-20 Kings 31 Armona 173   -119.708728 36.315187
3097 2020-10-20 Kings 31 Avenal 429   -120.128876 36.004087
3098 2020-10-20 Kings 31 Corcoran 671   -119.560654 36.097923
3099 2020-10-20 Kings 31 Hanford 2105   -119.64573 36.327428
3100 2020-10-20 Kings 31 Kettleman City 66   -119.960005 36.008623
3101 2020-10-20 Kings 31 Lemoore 949   -119.782993 36.300838
3102 2020-10-20 Kings 31 Other 67      
3103 2020-10-20 Kings 31 Prisons 3634      
3104 2020-10-20 Kings 31 Stratford 61   -119.822485 36.189369
4074 2020-10-19 Kings 31 Armona 173   -119.708728 36.315187
4075 2020-10-19 Kings 31 Avenal 430   -120.128876 36.004087
4076 2020-10-19 Kings 31 Corcoran 670   -119.560654 36.097923
4077 2020-10-19 Kings 31 Hanford 2103   -119.64573 36.327428
4078 2020-10-19 Kings 31 Kettleman City 66   -119.960005 36.008623
4079 2020-10-19 Kings 31 Lemoore 949   -119.782993 36.300838
4080 2020-10-19 Kings 31 Other 67      
4081 2020-10-19 Kings 31 Prisons 3634      
4082 2020-10-19 Kings 31 Stratford 61   -119.822485 36.189369
4894 2020-10-18 Kings 31 Armona 173   -119.708728 36.315187
4895 2020-10-18 Kings 31 Avenal 430   -120.128876 36.004087
4896 2020-10-18 Kings 31 Corcoran 666   -119.560654 36.097923
4897 2020-10-18 Kings 31 Hanford 2095   -119.64573 36.327428
4898 2020-10-18 Kings 31 Kettleman City 66   -119.960005 36.008623
4899 2020-10-18 Kings 31 Lemoore 947   -119.782993 36.300838
4900 2020-10-18 Kings 31 Other 67      
4901 2020-10-18 Kings 31 Prisons 3634      
4902 2020-10-18 Kings 31 Stratford 61   -119.822485 36.189369
5526 2020-10-17 Kings 31 Armona 171   -119.708728 36.315187
5527 2020-10-17 Kings 31 Avenal 431   -120.128876 36.004087
5528 2020-10-17 Kings 31 Corcoran 665   -119.560654 36.097923
5529 2020-10-17 Kings 31 Hanford 2095   -119.64573 36.327428
5530 2020-10-17 Kings 31 Kettleman City 66   -119.960005 36.008623
5531 2020-10-17 Kings 31 Lemoore 946   -119.782993 36.300838
5532 2020-10-17 Kings 31 Other 66      
5533 2020-10-17 Kings 31 Prisons 3634      
5534 2020-10-17 Kings 31 Stratford 61   -119.822485 36.189369
6288 2020-10-16 Kings 31 Armona 171   -119.708728 36.315187
6289 2020-10-16 Kings 31 Avenal 430   -120.128876 36.004087
6290 2020-10-16 Kings 31 Corcoran 664   -119.560654 36.097923
6291 2020-10-16 Kings 31 Hanford 2093   -119.64573 36.327428
6292 2020-10-16 Kings 31 Kettleman City 66   -119.960005 36.008623
6293 2020-10-16 Kings 31 Lemoore 941   -119.782993 36.300838
6294 2020-10-16 Kings 31 Other 66      
6295 2020-10-16 Kings 31 Prisons 4492      
6296 2020-10-16 Kings 31 Stratford 61   -119.822485 36.189369
7232 2020-10-15 Kings 31 Armona 172   -119.708728 36.315187
7233 2020-10-15 Kings 31 Avenal 430   -120.128876 36.004087
7234 2020-10-15 Kings 31 Corcoran 663   -119.560654 36.097923
7235 2020-10-15 Kings 31 Hanford 2084   -119.64573 36.327428
7236 2020-10-15 Kings 31 Kettleman City 66   -119.960005 36.008623
7237 2020-10-15 Kings 31 Lemoore 939   -119.782993 36.300838
7238 2020-10-15 Kings 31 Other 66      
7239 2020-10-15 Kings 31 Prisons 3670      
7240 2020-10-15 Kings 31 Stratford 61   -119.822485 36.189369
8197 2020-10-14 Kings 31 Armona 173   -119.708728 36.315187
8198 2020-10-14 Kings 31 Avenal 430   -120.128876 36.004087
8199 2020-10-14 Kings 31 Corcoran 661   -119.560654 36.097923
8200 2020-10-14 Kings 31 Hanford 2073   -119.64573 36.327428
8201 2020-10-14 Kings 31 Kettleman City 66   -119.960005 36.008623
8202 2020-10-14 Kings 31 Lemoore 939   -119.782993 36.300838
8203 2020-10-14 Kings 31 Other 66      
8204 2020-10-14 Kings 31 Prisons 2668      
8205 2020-10-14 Kings 31 Stratford 61   -119.822485 36.189369
9108 2020-10-13 Kings 31 Armona 172   -119.708728 36.315187
9109 2020-10-13 Kings 31 Avenal 429   -120.128876 36.004087
9110 2020-10-13 Kings 31 Corcoran 658   -119.560654 36.097923
9111 2020-10-13 Kings 31 Hanford 2073   -119.64573 36.327428
9112 2020-10-13 Kings 31 Kettleman City 66   -119.960005 36.008623
9113 2020-10-13 Kings 31 Lemoore 939   -119.782993 36.300838
9114 2020-10-13 Kings 31 Other 66      
9115 2020-10-13 Kings 31 Prisons 3632      
9116 2020-10-13 Kings 31 Stratford 61   -119.822485 36.189369
10010 2020-10-12 Kings 31 Armona 171   -119.708728 36.315187

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 876.399ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals