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

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

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