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

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

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