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,096 rows where county = "Solano" sorted by date descending

View and edit SQL

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

place

fips

  • 95 1,096

county

  • Solano · 1,096
Link rowid date ▲ county fips place confirmed_cases note x y
914 2020-10-27 Solano 95 Benicia 189   -122.156111 38.063333
915 2020-10-27 Solano 95 Dixon 477   -121.826944 38.449167
916 2020-10-27 Solano 95 Fairfield 2402   -122.054167 38.257778
917 2020-10-27 Solano 95 Other 23      
918 2020-10-27 Solano 95 Rio Vista 59   -121.695833 38.163889
919 2020-10-27 Solano 95 Suisun City 544   -122.016944 38.245
920 2020-10-27 Solano 95 Vacaville 1328   -121.972778 38.353889
921 2020-10-27 Solano 95 Vallejo 2423   -122.235833 38.113056
1874 2020-10-26 Solano 95 Benicia 187   -122.156111 38.063333
1875 2020-10-26 Solano 95 Dixon 475   -121.826944 38.449167
1876 2020-10-26 Solano 95 Fairfield 2385   -122.054167 38.257778
1877 2020-10-26 Solano 95 Other 23      
1878 2020-10-26 Solano 95 Rio Vista 58   -121.695833 38.163889
1879 2020-10-26 Solano 95 Suisun City 541   -122.016944 38.245
1880 2020-10-26 Solano 95 Vacaville 1314   -121.972778 38.353889
1881 2020-10-26 Solano 95 Vallejo 2401   -122.235833 38.113056
4185 2020-10-23 Solano 95 Benicia 186   -122.156111 38.063333
4186 2020-10-23 Solano 95 Dixon 466   -121.826944 38.449167
4187 2020-10-23 Solano 95 Fairfield 2364   -122.054167 38.257778
4188 2020-10-23 Solano 95 Other 23      
4189 2020-10-23 Solano 95 Rio Vista 57   -121.695833 38.163889
4190 2020-10-23 Solano 95 Suisun City 532   -122.016944 38.245
4191 2020-10-23 Solano 95 Vacaville 1284   -121.972778 38.353889
4192 2020-10-23 Solano 95 Vallejo 2374   -122.235833 38.113056
5164 2020-10-22 Solano 95 Benicia 186   -122.156111 38.063333
5165 2020-10-22 Solano 95 Dixon 465   -121.826944 38.449167
5166 2020-10-22 Solano 95 Fairfield 2357   -122.054167 38.257778
5167 2020-10-22 Solano 95 Other 23      
5168 2020-10-22 Solano 95 Rio Vista 57   -121.695833 38.163889
5169 2020-10-22 Solano 95 Suisun City 527   -122.016944 38.245
5170 2020-10-22 Solano 95 Vacaville 1270   -121.972778 38.353889
5171 2020-10-22 Solano 95 Vallejo 2364   -122.235833 38.113056
6128 2020-10-21 Solano 95 Benicia 186   -122.156111 38.063333
6129 2020-10-21 Solano 95 Dixon 463   -121.826944 38.449167
6130 2020-10-21 Solano 95 Fairfield 2343   -122.054167 38.257778
6131 2020-10-21 Solano 95 Other 23      
6132 2020-10-21 Solano 95 Rio Vista 57   -121.695833 38.163889
6133 2020-10-21 Solano 95 Suisun City 525   -122.016944 38.245
6134 2020-10-21 Solano 95 Vacaville 1254   -121.972778 38.353889
6135 2020-10-21 Solano 95 Vallejo 2354   -122.235833 38.113056
7128 2020-10-20 Solano 95 Benicia 185   -122.156111 38.063333
7129 2020-10-20 Solano 95 Dixon 462   -121.826944 38.449167
7130 2020-10-20 Solano 95 Fairfield 2330   -122.054167 38.257778
7131 2020-10-20 Solano 95 Other 23      
7132 2020-10-20 Solano 95 Rio Vista 57   -121.695833 38.163889
7133 2020-10-20 Solano 95 Suisun City 522   -122.016944 38.245
7134 2020-10-20 Solano 95 Vacaville 1244   -121.972778 38.353889
7135 2020-10-20 Solano 95 Vallejo 2348   -122.235833 38.113056
8050 2020-10-19 Solano 95 Benicia 183   -122.156111 38.063333
8051 2020-10-19 Solano 95 Dixon 462   -121.826944 38.449167
8052 2020-10-19 Solano 95 Fairfield 2302   -122.054167 38.257778
8053 2020-10-19 Solano 95 Other 23      
8054 2020-10-19 Solano 95 Rio Vista 56   -121.695833 38.163889
8055 2020-10-19 Solano 95 Suisun City 516   -122.016944 38.245
8056 2020-10-19 Solano 95 Vacaville 1233   -121.972778 38.353889
8057 2020-10-19 Solano 95 Vallejo 2342   -122.235833 38.113056
10311 2020-10-16 Solano 95 Benicia 182   -122.156111 38.063333
10312 2020-10-16 Solano 95 Dixon 450   -121.826944 38.449167
10313 2020-10-16 Solano 95 Fairfield 2271   -122.054167 38.257778
10314 2020-10-16 Solano 95 Other 23      
10315 2020-10-16 Solano 95 Rio Vista 54   -121.695833 38.163889
10316 2020-10-16 Solano 95 Suisun City 509   -122.016944 38.245
10317 2020-10-16 Solano 95 Vacaville 1213   -121.972778 38.353889
10318 2020-10-16 Solano 95 Vallejo 2307   -122.235833 38.113056
11252 2020-10-15 Solano 95 Benicia 182   -122.156111 38.063333
11253 2020-10-15 Solano 95 Dixon 446   -121.826944 38.449167
11254 2020-10-15 Solano 95 Fairfield 2248   -122.054167 38.257778
11255 2020-10-15 Solano 95 Other 23      
11256 2020-10-15 Solano 95 Rio Vista 54   -121.695833 38.163889
11257 2020-10-15 Solano 95 Suisun City 503   -122.016944 38.245
11258 2020-10-15 Solano 95 Vacaville 1199   -121.972778 38.353889
11259 2020-10-15 Solano 95 Vallejo 2296   -122.235833 38.113056
12190 2020-10-14 Solano 95 Benicia 182   -122.156111 38.063333
12191 2020-10-14 Solano 95 Dixon 445   -121.826944 38.449167
12192 2020-10-14 Solano 95 Fairfield 2234   -122.054167 38.257778
12193 2020-10-14 Solano 95 Other 23      
12194 2020-10-14 Solano 95 Rio Vista 54   -121.695833 38.163889
12195 2020-10-14 Solano 95 Suisun City 501   -122.016944 38.245
12196 2020-10-14 Solano 95 Vacaville 1182   -121.972778 38.353889
12197 2020-10-14 Solano 95 Vallejo 2287   -122.235833 38.113056
13075 2020-10-13 Solano 95 Benicia 182   -122.156111 38.063333
13076 2020-10-13 Solano 95 Dixon 443   -121.826944 38.449167
13077 2020-10-13 Solano 95 Fairfield 2221   -122.054167 38.257778
13078 2020-10-13 Solano 95 Other 23      
13079 2020-10-13 Solano 95 Rio Vista 54   -121.695833 38.163889
13080 2020-10-13 Solano 95 Suisun City 498   -122.016944 38.245
13081 2020-10-13 Solano 95 Vacaville 1171   -121.972778 38.353889
13082 2020-10-13 Solano 95 Vallejo 2284   -122.235833 38.113056
16365 2020-10-09 Solano 95 Benicia 180   -122.156111 38.063333
16366 2020-10-09 Solano 95 Dixon 436   -121.826944 38.449167
16367 2020-10-09 Solano 95 Fairfield 2179   -122.054167 38.257778
16368 2020-10-09 Solano 95 Other 22      
16369 2020-10-09 Solano 95 Rio Vista 54   -121.695833 38.163889
16370 2020-10-09 Solano 95 Suisun City 493   -122.016944 38.245
16371 2020-10-09 Solano 95 Vacaville 1146   -121.972778 38.353889
16372 2020-10-09 Solano 95 Vallejo 2240   -122.235833 38.113056
17325 2020-10-08 Solano 95 Benicia 179   -122.156111 38.063333
17326 2020-10-08 Solano 95 Dixon 433   -121.826944 38.449167
17327 2020-10-08 Solano 95 Fairfield 2164   -122.054167 38.257778
17328 2020-10-08 Solano 95 Other 22      

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