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

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

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