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

View and edit SQL

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

fips

  • 1 · 3,293

county

Link rowid date ▲ county fips place confirmed_cases note x y
1 2020-10-23 Alameda 1 Alameda 453   -122.274444 37.756111
2 2020-10-23 Alameda 1 Albany 62   -122.297778 37.886944
3 2020-10-23 Alameda 1 Berkeley 745   -122.272778 37.871667
4 2020-10-23 Alameda 1 Dublin 318   -121.935833 37.702222
5 2020-10-23 Alameda 1 Emeryville 100   -122.285278 37.831389
6 2020-10-23 Alameda 1 Fremont 1597   -121.988611 37.548333
7 2020-10-23 Alameda 1 Hayward 3423   -122.080796 37.66882
8 2020-10-23 Alameda 1 Homeless 152      
9 2020-10-23 Alameda 1 Livermore 992   -121.768056 37.681944
10 2020-10-23 Alameda 1 Newark 615   -122.033333 37.533333
11 2020-10-23 Alameda 1 Oakland 8967   -122.270833 37.804444
12 2020-10-23 Alameda 1 Other 38      
13 2020-10-23 Alameda 1 Piedmont 41   -122.233333 37.816667
14 2020-10-23 Alameda 1 Pleasanton 502   -121.874722 37.6625
15 2020-10-23 Alameda 1 San Leandro 1275   -122.156111 37.725
16 2020-10-23 Alameda 1 Sunol 12   -121.888611 37.594444
17 2020-10-23 Alameda 1 Union City 885   -122.048333 37.596389
988 2020-10-22 Alameda 1 Alameda 451   -122.274444 37.756111
989 2020-10-22 Alameda 1 Albany 61   -122.297778 37.886944
990 2020-10-22 Alameda 1 Berkeley 741   -122.272778 37.871667
991 2020-10-22 Alameda 1 Dublin 317   -121.935833 37.702222
992 2020-10-22 Alameda 1 Emeryville 100   -122.285278 37.831389
993 2020-10-22 Alameda 1 Fremont 1579   -121.988611 37.548333
994 2020-10-22 Alameda 1 Hayward 3398   -122.080796 37.66882
995 2020-10-22 Alameda 1 Homeless 152      
996 2020-10-22 Alameda 1 Livermore 989   -121.768056 37.681944
997 2020-10-22 Alameda 1 Newark 613   -122.033333 37.533333
998 2020-10-22 Alameda 1 Oakland 8929   -122.270833 37.804444
999 2020-10-22 Alameda 1 Other 38      
1000 2020-10-22 Alameda 1 Piedmont 41   -122.233333 37.816667
1001 2020-10-22 Alameda 1 Pleasanton 497   -121.874722 37.6625
1002 2020-10-22 Alameda 1 San Leandro 1271   -122.156111 37.725
1003 2020-10-22 Alameda 1 Sunol 12   -121.888611 37.594444
1004 2020-10-22 Alameda 1 Union City 872   -122.048333 37.596389
1952 2020-10-21 Alameda 1 Alameda 451   -122.274444 37.756111
1953 2020-10-21 Alameda 1 Albany 61   -122.297778 37.886944
1954 2020-10-21 Alameda 1 Berkeley 741   -122.272778 37.871667
1955 2020-10-21 Alameda 1 Dublin 316   -121.935833 37.702222
1956 2020-10-21 Alameda 1 Emeryville 98   -122.285278 37.831389
1957 2020-10-21 Alameda 1 Fremont 1571   -121.988611 37.548333
1958 2020-10-21 Alameda 1 Hayward 3382   -122.080796 37.66882
1959 2020-10-21 Alameda 1 Homeless 152      
1960 2020-10-21 Alameda 1 Livermore 988   -121.768056 37.681944
1961 2020-10-21 Alameda 1 Newark 610   -122.033333 37.533333
1962 2020-10-21 Alameda 1 Oakland 8913   -122.270833 37.804444
1963 2020-10-21 Alameda 1 Other 37      
1964 2020-10-21 Alameda 1 Piedmont 41   -122.233333 37.816667
1965 2020-10-21 Alameda 1 Pleasanton 489   -121.874722 37.6625
1966 2020-10-21 Alameda 1 San Leandro 1268   -122.156111 37.725
1967 2020-10-21 Alameda 1 Sunol 12   -121.888611 37.594444
1968 2020-10-21 Alameda 1 Union City 871   -122.048333 37.596389
2931 2020-10-20 Alameda 1 Alameda 450   -122.274444 37.756111
2932 2020-10-20 Alameda 1 Albany 61   -122.297778 37.886944
2933 2020-10-20 Alameda 1 Berkeley 738   -122.272778 37.871667
2934 2020-10-20 Alameda 1 Dublin 316   -121.935833 37.702222
2935 2020-10-20 Alameda 1 Emeryville 95   -122.285278 37.831389
2936 2020-10-20 Alameda 1 Fremont 1562   -121.988611 37.548333
2937 2020-10-20 Alameda 1 Hayward 3364   -122.080796 37.66882
2938 2020-10-20 Alameda 1 Homeless 152      
2939 2020-10-20 Alameda 1 Livermore 983   -121.768056 37.681944
2940 2020-10-20 Alameda 1 Newark 606   -122.033333 37.533333
2941 2020-10-20 Alameda 1 Oakland 8888   -122.270833 37.804444
2942 2020-10-20 Alameda 1 Other 37      
2943 2020-10-20 Alameda 1 Piedmont 41   -122.233333 37.816667
2944 2020-10-20 Alameda 1 Pleasanton 489   -121.874722 37.6625
2945 2020-10-20 Alameda 1 San Leandro 1242   -122.156111 37.725
2946 2020-10-20 Alameda 1 Sunol 12   -121.888611 37.594444
2947 2020-10-20 Alameda 1 Union City 856   -122.048333 37.596389
3935 2020-10-19 Alameda 1 Alameda 448   -122.274444 37.756111
3936 2020-10-19 Alameda 1 Albany 61   -122.297778 37.886944
3937 2020-10-19 Alameda 1 Berkeley 739   -122.272778 37.871667
3938 2020-10-19 Alameda 1 Dublin 316   -121.935833 37.702222
3939 2020-10-19 Alameda 1 Emeryville 95   -122.285278 37.831389
3940 2020-10-19 Alameda 1 Fremont 1550   -121.988611 37.548333
3941 2020-10-19 Alameda 1 Hayward 3350   -122.080796 37.66882
3942 2020-10-19 Alameda 1 Homeless 152      
3943 2020-10-19 Alameda 1 Livermore 982   -121.768056 37.681944
3944 2020-10-19 Alameda 1 Newark 604   -122.033333 37.533333
3945 2020-10-19 Alameda 1 Oakland 8849   -122.270833 37.804444
3946 2020-10-19 Alameda 1 Other 37      
3947 2020-10-19 Alameda 1 Piedmont 41   -122.233333 37.816667
3948 2020-10-19 Alameda 1 Pleasanton 486   -121.874722 37.6625
3949 2020-10-19 Alameda 1 San Leandro 1231   -122.156111 37.725
3950 2020-10-19 Alameda 1 Sunol 12   -121.888611 37.594444
3951 2020-10-19 Alameda 1 Union City 847   -122.048333 37.596389
4803 2020-10-18 Alameda 1 Alameda 448   -122.274444 37.756111
4804 2020-10-18 Alameda 1 Albany 61   -122.297778 37.886944
4805 2020-10-18 Alameda 1 Berkeley 731   -122.272778 37.871667
4806 2020-10-18 Alameda 1 Dublin 313   -121.935833 37.702222
4807 2020-10-18 Alameda 1 Emeryville 95   -122.285278 37.831389
4808 2020-10-18 Alameda 1 Fremont 1540   -121.988611 37.548333
4809 2020-10-18 Alameda 1 Hayward 3325   -122.080796 37.66882
4810 2020-10-18 Alameda 1 Homeless 152      
4811 2020-10-18 Alameda 1 Livermore 977   -121.768056 37.681944
4812 2020-10-18 Alameda 1 Newark 604   -122.033333 37.533333
4813 2020-10-18 Alameda 1 Oakland 8825   -122.270833 37.804444
4814 2020-10-18 Alameda 1 Other 37      
4815 2020-10-18 Alameda 1 Piedmont 41   -122.233333 37.816667
4816 2020-10-18 Alameda 1 Pleasanton 485   -121.874722 37.6625
4817 2020-10-18 Alameda 1 San Leandro 1229   -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 827.532ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals