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,120 rows where fips = 95 sorted by date descending

View and edit SQL

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

place

fips

  • 95 · 1,120

county

Link rowid date ▲ county fips place confirmed_cases note x y
946 2020-10-30 Solano 95 Benicia 191   -122.156111 38.063333
947 2020-10-30 Solano 95 Dixon 502   -121.826944 38.449167
948 2020-10-30 Solano 95 Fairfield 2443   -122.054167 38.257778
949 2020-10-30 Solano 95 Other 25      
950 2020-10-30 Solano 95 Rio Vista 59   -121.695833 38.163889
951 2020-10-30 Solano 95 Suisun City 554   -122.016944 38.245
952 2020-10-30 Solano 95 Vacaville 1394   -121.972778 38.353889
953 2020-10-30 Solano 95 Vallejo 2466   -122.235833 38.113056
1964 2020-10-29 Solano 95 Benicia 191   -122.156111 38.063333
1965 2020-10-29 Solano 95 Dixon 493   -121.826944 38.449167
1966 2020-10-29 Solano 95 Fairfield 2426   -122.054167 38.257778
1967 2020-10-29 Solano 95 Other 24      
1968 2020-10-29 Solano 95 Rio Vista 59   -121.695833 38.163889
1969 2020-10-29 Solano 95 Suisun City 550   -122.016944 38.245
1970 2020-10-29 Solano 95 Vacaville 1386   -121.972778 38.353889
1971 2020-10-29 Solano 95 Vallejo 2457   -122.235833 38.113056
2916 2020-10-28 Solano 95 Benicia 191   -122.156111 38.063333
2917 2020-10-28 Solano 95 Dixon 485   -121.826944 38.449167
2918 2020-10-28 Solano 95 Fairfield 2409   -122.054167 38.257778
2919 2020-10-28 Solano 95 Other 23      
2920 2020-10-28 Solano 95 Rio Vista 59   -121.695833 38.163889
2921 2020-10-28 Solano 95 Suisun City 546   -122.016944 38.245
2922 2020-10-28 Solano 95 Vacaville 1339   -121.972778 38.353889
2923 2020-10-28 Solano 95 Vallejo 2428   -122.235833 38.113056
3896 2020-10-27 Solano 95 Benicia 189   -122.156111 38.063333
3897 2020-10-27 Solano 95 Dixon 477   -121.826944 38.449167
3898 2020-10-27 Solano 95 Fairfield 2402   -122.054167 38.257778
3899 2020-10-27 Solano 95 Other 23      
3900 2020-10-27 Solano 95 Rio Vista 59   -121.695833 38.163889
3901 2020-10-27 Solano 95 Suisun City 544   -122.016944 38.245
3902 2020-10-27 Solano 95 Vacaville 1328   -121.972778 38.353889
3903 2020-10-27 Solano 95 Vallejo 2423   -122.235833 38.113056
4856 2020-10-26 Solano 95 Benicia 187   -122.156111 38.063333
4857 2020-10-26 Solano 95 Dixon 475   -121.826944 38.449167
4858 2020-10-26 Solano 95 Fairfield 2385   -122.054167 38.257778
4859 2020-10-26 Solano 95 Other 23      
4860 2020-10-26 Solano 95 Rio Vista 58   -121.695833 38.163889
4861 2020-10-26 Solano 95 Suisun City 541   -122.016944 38.245
4862 2020-10-26 Solano 95 Vacaville 1314   -121.972778 38.353889
4863 2020-10-26 Solano 95 Vallejo 2401   -122.235833 38.113056
7167 2020-10-23 Solano 95 Benicia 186   -122.156111 38.063333
7168 2020-10-23 Solano 95 Dixon 466   -121.826944 38.449167
7169 2020-10-23 Solano 95 Fairfield 2364   -122.054167 38.257778
7170 2020-10-23 Solano 95 Other 23      
7171 2020-10-23 Solano 95 Rio Vista 57   -121.695833 38.163889
7172 2020-10-23 Solano 95 Suisun City 532   -122.016944 38.245
7173 2020-10-23 Solano 95 Vacaville 1284   -121.972778 38.353889
7174 2020-10-23 Solano 95 Vallejo 2374   -122.235833 38.113056
8146 2020-10-22 Solano 95 Benicia 186   -122.156111 38.063333
8147 2020-10-22 Solano 95 Dixon 465   -121.826944 38.449167
8148 2020-10-22 Solano 95 Fairfield 2357   -122.054167 38.257778
8149 2020-10-22 Solano 95 Other 23      
8150 2020-10-22 Solano 95 Rio Vista 57   -121.695833 38.163889
8151 2020-10-22 Solano 95 Suisun City 527   -122.016944 38.245
8152 2020-10-22 Solano 95 Vacaville 1270   -121.972778 38.353889
8153 2020-10-22 Solano 95 Vallejo 2364   -122.235833 38.113056
9110 2020-10-21 Solano 95 Benicia 186   -122.156111 38.063333
9111 2020-10-21 Solano 95 Dixon 463   -121.826944 38.449167
9112 2020-10-21 Solano 95 Fairfield 2343   -122.054167 38.257778
9113 2020-10-21 Solano 95 Other 23      
9114 2020-10-21 Solano 95 Rio Vista 57   -121.695833 38.163889
9115 2020-10-21 Solano 95 Suisun City 525   -122.016944 38.245
9116 2020-10-21 Solano 95 Vacaville 1254   -121.972778 38.353889
9117 2020-10-21 Solano 95 Vallejo 2354   -122.235833 38.113056
10110 2020-10-20 Solano 95 Benicia 185   -122.156111 38.063333
10111 2020-10-20 Solano 95 Dixon 462   -121.826944 38.449167
10112 2020-10-20 Solano 95 Fairfield 2330   -122.054167 38.257778
10113 2020-10-20 Solano 95 Other 23      
10114 2020-10-20 Solano 95 Rio Vista 57   -121.695833 38.163889
10115 2020-10-20 Solano 95 Suisun City 522   -122.016944 38.245
10116 2020-10-20 Solano 95 Vacaville 1244   -121.972778 38.353889
10117 2020-10-20 Solano 95 Vallejo 2348   -122.235833 38.113056
11032 2020-10-19 Solano 95 Benicia 183   -122.156111 38.063333
11033 2020-10-19 Solano 95 Dixon 462   -121.826944 38.449167
11034 2020-10-19 Solano 95 Fairfield 2302   -122.054167 38.257778
11035 2020-10-19 Solano 95 Other 23      
11036 2020-10-19 Solano 95 Rio Vista 56   -121.695833 38.163889
11037 2020-10-19 Solano 95 Suisun City 516   -122.016944 38.245
11038 2020-10-19 Solano 95 Vacaville 1233   -121.972778 38.353889
11039 2020-10-19 Solano 95 Vallejo 2342   -122.235833 38.113056
13293 2020-10-16 Solano 95 Benicia 182   -122.156111 38.063333
13294 2020-10-16 Solano 95 Dixon 450   -121.826944 38.449167
13295 2020-10-16 Solano 95 Fairfield 2271   -122.054167 38.257778
13296 2020-10-16 Solano 95 Other 23      
13297 2020-10-16 Solano 95 Rio Vista 54   -121.695833 38.163889
13298 2020-10-16 Solano 95 Suisun City 509   -122.016944 38.245
13299 2020-10-16 Solano 95 Vacaville 1213   -121.972778 38.353889
13300 2020-10-16 Solano 95 Vallejo 2307   -122.235833 38.113056
14234 2020-10-15 Solano 95 Benicia 182   -122.156111 38.063333
14235 2020-10-15 Solano 95 Dixon 446   -121.826944 38.449167
14236 2020-10-15 Solano 95 Fairfield 2248   -122.054167 38.257778
14237 2020-10-15 Solano 95 Other 23      
14238 2020-10-15 Solano 95 Rio Vista 54   -121.695833 38.163889
14239 2020-10-15 Solano 95 Suisun City 503   -122.016944 38.245
14240 2020-10-15 Solano 95 Vacaville 1199   -121.972778 38.353889
14241 2020-10-15 Solano 95 Vallejo 2296   -122.235833 38.113056
15172 2020-10-14 Solano 95 Benicia 182   -122.156111 38.063333
15173 2020-10-14 Solano 95 Dixon 445   -121.826944 38.449167
15174 2020-10-14 Solano 95 Fairfield 2234   -122.054167 38.257778
15175 2020-10-14 Solano 95 Other 23      

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