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

3,412 rows where county = "Alameda" sorted by date descending

View and edit SQL

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

fips

  • 1 3,412

county

  • Alameda · 3,412
Link rowid date ▲ county fips place confirmed_cases note x y
1 2020-10-30 Alameda 1 Alameda 472   -122.274444 37.756111
2 2020-10-30 Alameda 1 Albany 63   -122.297778 37.886944
3 2020-10-30 Alameda 1 Berkeley 775   -122.272778 37.871667
4 2020-10-30 Alameda 1 Dublin 329   -121.935833 37.702222
5 2020-10-30 Alameda 1 Emeryville 105   -122.285278 37.831389
6 2020-10-30 Alameda 1 Fremont 1660   -121.988611 37.548333
7 2020-10-30 Alameda 1 Hayward 3511   -122.080796 37.66882
8 2020-10-30 Alameda 1 Homeless 155      
9 2020-10-30 Alameda 1 Livermore 1013   -121.768056 37.681944
10 2020-10-30 Alameda 1 Newark 635   -122.033333 37.533333
11 2020-10-30 Alameda 1 Oakland 9155   -122.270833 37.804444
12 2020-10-30 Alameda 1 Other 38      
13 2020-10-30 Alameda 1 Piedmont 46   -122.233333 37.816667
14 2020-10-30 Alameda 1 Pleasanton 522   -121.874722 37.6625
15 2020-10-30 Alameda 1 San Leandro 1326   -122.156111 37.725
16 2020-10-30 Alameda 1 Sunol 13   -121.888611 37.594444
17 2020-10-30 Alameda 1 Union City 916   -122.048333 37.596389
1032 2020-10-29 Alameda 1 Alameda 468   -122.274444 37.756111
1033 2020-10-29 Alameda 1 Albany 63   -122.297778 37.886944
1034 2020-10-29 Alameda 1 Berkeley 772   -122.272778 37.871667
1035 2020-10-29 Alameda 1 Dublin 328   -121.935833 37.702222
1036 2020-10-29 Alameda 1 Emeryville 105   -122.285278 37.831389
1037 2020-10-29 Alameda 1 Fremont 1643   -121.988611 37.548333
1038 2020-10-29 Alameda 1 Hayward 3493   -122.080796 37.66882
1039 2020-10-29 Alameda 1 Homeless 155      
1040 2020-10-29 Alameda 1 Livermore 1009   -121.768056 37.681944
1041 2020-10-29 Alameda 1 Newark 632   -122.033333 37.533333
1042 2020-10-29 Alameda 1 Oakland 9117   -122.270833 37.804444
1043 2020-10-29 Alameda 1 Other 38      
1044 2020-10-29 Alameda 1 Piedmont 44   -122.233333 37.816667
1045 2020-10-29 Alameda 1 Pleasanton 517   -121.874722 37.6625
1046 2020-10-29 Alameda 1 San Leandro 1310   -122.156111 37.725
1047 2020-10-29 Alameda 1 Sunol 12   -121.888611 37.594444
1048 2020-10-29 Alameda 1 Union City 910   -122.048333 37.596389
2032 2020-10-28 Alameda 1 Alameda 465   -122.274444 37.756111
2033 2020-10-28 Alameda 1 Albany 63   -122.297778 37.886944
2034 2020-10-28 Alameda 1 Berkeley 764   -122.272778 37.871667
2035 2020-10-28 Alameda 1 Dublin 328   -121.935833 37.702222
2036 2020-10-28 Alameda 1 Emeryville 105   -122.285278 37.831389
2037 2020-10-28 Alameda 1 Fremont 1639   -121.988611 37.548333
2038 2020-10-28 Alameda 1 Hayward 3488   -122.080796 37.66882
2039 2020-10-28 Alameda 1 Homeless 152      
2040 2020-10-28 Alameda 1 Livermore 1008   -121.768056 37.681944
2041 2020-10-28 Alameda 1 Newark 632   -122.033333 37.533333
2042 2020-10-28 Alameda 1 Oakland 9096   -122.270833 37.804444
2043 2020-10-28 Alameda 1 Other 38      
2044 2020-10-28 Alameda 1 Piedmont 43   -122.233333 37.816667
2045 2020-10-28 Alameda 1 Pleasanton 515   -121.874722 37.6625
2046 2020-10-28 Alameda 1 San Leandro 1306   -122.156111 37.725
2047 2020-10-28 Alameda 1 Sunol 12   -121.888611 37.594444
2048 2020-10-28 Alameda 1 Union City 906   -122.048333 37.596389
2984 2020-10-27 Alameda 1 Alameda 459   -122.274444 37.756111
2985 2020-10-27 Alameda 1 Albany 63   -122.297778 37.886944
2986 2020-10-27 Alameda 1 Berkeley 757   -122.272778 37.871667
2987 2020-10-27 Alameda 1 Dublin 326   -121.935833 37.702222
2988 2020-10-27 Alameda 1 Emeryville 104   -122.285278 37.831389
2989 2020-10-27 Alameda 1 Fremont 1633   -121.988611 37.548333
2990 2020-10-27 Alameda 1 Hayward 3475   -122.080796 37.66882
2991 2020-10-27 Alameda 1 Homeless 152      
2992 2020-10-27 Alameda 1 Livermore 1004   -121.768056 37.681944
2993 2020-10-27 Alameda 1 Newark 630   -122.033333 37.533333
2994 2020-10-27 Alameda 1 Oakland 9064   -122.270833 37.804444
2995 2020-10-27 Alameda 1 Other 38      
2996 2020-10-27 Alameda 1 Piedmont 43   -122.233333 37.816667
2997 2020-10-27 Alameda 1 Pleasanton 513   -121.874722 37.6625
2998 2020-10-27 Alameda 1 San Leandro 1291   -122.156111 37.725
2999 2020-10-27 Alameda 1 Sunol 12   -121.888611 37.594444
3000 2020-10-27 Alameda 1 Union City 905   -122.048333 37.596389
3960 2020-10-26 Alameda 1 Alameda 458   -122.274444 37.756111
3961 2020-10-26 Alameda 1 Albany 63   -122.297778 37.886944
3962 2020-10-26 Alameda 1 Berkeley 756   -122.272778 37.871667
3963 2020-10-26 Alameda 1 Dublin 324   -121.935833 37.702222
3964 2020-10-26 Alameda 1 Emeryville 104   -122.285278 37.831389
3965 2020-10-26 Alameda 1 Fremont 1619   -121.988611 37.548333
3966 2020-10-26 Alameda 1 Hayward 3465   -122.080796 37.66882
3967 2020-10-26 Alameda 1 Homeless 152      
3968 2020-10-26 Alameda 1 Livermore 1005   -121.768056 37.681944
3969 2020-10-26 Alameda 1 Newark 623   -122.033333 37.533333
3970 2020-10-26 Alameda 1 Oakland 9038   -122.270833 37.804444
3971 2020-10-26 Alameda 1 Other 38      
3972 2020-10-26 Alameda 1 Piedmont 42   -122.233333 37.816667
3973 2020-10-26 Alameda 1 Pleasanton 512   -121.874722 37.6625
3974 2020-10-26 Alameda 1 San Leandro 1286   -122.156111 37.725
3975 2020-10-26 Alameda 1 Sunol 12   -121.888611 37.594444
3976 2020-10-26 Alameda 1 Union City 900   -122.048333 37.596389
4921 2020-10-25 Alameda 1 Alameda 456   -122.274444 37.756111
4922 2020-10-25 Alameda 1 Albany 63   -122.297778 37.886944
4923 2020-10-25 Alameda 1 Berkeley 749   -122.272778 37.871667
4924 2020-10-25 Alameda 1 Dublin 320   -121.935833 37.702222
4925 2020-10-25 Alameda 1 Emeryville 102   -122.285278 37.831389
4926 2020-10-25 Alameda 1 Fremont 1615   -121.988611 37.548333
4927 2020-10-25 Alameda 1 Hayward 3454   -122.080796 37.66882
4928 2020-10-25 Alameda 1 Homeless 152      
4929 2020-10-25 Alameda 1 Livermore 1002   -121.768056 37.681944
4930 2020-10-25 Alameda 1 Newark 618   -122.033333 37.533333
4931 2020-10-25 Alameda 1 Oakland 9021   -122.270833 37.804444
4932 2020-10-25 Alameda 1 Other 38      
4933 2020-10-25 Alameda 1 Piedmont 42   -122.233333 37.816667
4934 2020-10-25 Alameda 1 Pleasanton 506   -121.874722 37.6625
4935 2020-10-25 Alameda 1 San Leandro 1285   -122.156111 37.725

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