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

5,531 rows where fips = 13 sorted by date descending

View and edit SQL

Suggested facets: x, y, date (date)

fips

  • 13 · 5,531

county

Link rowid date ▲ county fips place confirmed_cases note x y
37 2020-10-23 Contra Costa 13 Alamo 121   -122.032222 37.850278
38 2020-10-23 Contra Costa 13 Antioch 2441   -121.805833 38.005
39 2020-10-23 Contra Costa 13 Bay Point 960   -121.961667 38.029167
40 2020-10-23 Contra Costa 13 Bethel Island 14   -121.640556 38.015
41 2020-10-23 Contra Costa 13 Brentwood 715   -121.695833 37.931944
42 2020-10-23 Contra Costa 13 Byron 24   -121.638056 37.867222
43 2020-10-23 Contra Costa 13 Clayton 61   -121.935833 37.941111
44 2020-10-23 Contra Costa 13 Concord 2473   -122.031111 37.978056
45 2020-10-23 Contra Costa 13 Crockett 18   -122.213056 38.0525
46 2020-10-23 Contra Costa 13 Danville 385   -122.0 37.821667
47 2020-10-23 Contra Costa 13 Discovery Bay 122   -121.600278 37.908611
48 2020-10-23 Contra Costa 13 El Cerrito 119   -122.311667 37.915833
49 2020-10-23 Contra Costa 13 El Sobrante 307   -122.295278 37.977222
50 2020-10-23 Contra Costa 13 Hercules 271   -122.288611 38.017222
51 2020-10-23 Contra Costa 13 Lafayette 154   -122.118056 37.885833
52 2020-10-23 Contra Costa 13 Martinez 401   -122.134167 38.019444
53 2020-10-23 Contra Costa 13 Moraga 78   -122.129722 37.835
54 2020-10-23 Contra Costa 13 Oakley 565   -121.7125 37.9975
55 2020-10-23 Contra Costa 13 Orinda 124   -122.179722 37.882778
56 2020-10-23 Contra Costa 13 Other 191      
57 2020-10-23 Contra Costa 13 Pacheco 73   -122.075278 37.983611
58 2020-10-23 Contra Costa 13 Pinole 241   -122.291111 38.004444
59 2020-10-23 Contra Costa 13 Pittsburg 2075   -121.884722 38.028056
60 2020-10-23 Contra Costa 13 Pleasant Hill 307   -122.0525 37.948056
61 2020-10-23 Contra Costa 13 Richmond 3521   -122.347778 37.935833
62 2020-10-23 Contra Costa 13 Rodeo 118   -122.266944 38.033056
63 2020-10-23 Contra Costa 13 San Pablo 1585   -122.345556 37.962222
64 2020-10-23 Contra Costa 13 San Ramon 406   -121.978056 37.78
65 2020-10-23 Contra Costa 13 Walnut Creek 653   -122.065 37.906389
1019 2020-10-22 Contra Costa 13 Alamo 121   -122.032222 37.850278
1020 2020-10-22 Contra Costa 13 Antioch 2429   -121.805833 38.005
1021 2020-10-22 Contra Costa 13 Bay Point 958   -121.961667 38.029167
1022 2020-10-22 Contra Costa 13 Bethel Island 13   -121.640556 38.015
1023 2020-10-22 Contra Costa 13 Brentwood 709   -121.695833 37.931944
1024 2020-10-22 Contra Costa 13 Byron 24   -121.638056 37.867222
1025 2020-10-22 Contra Costa 13 Clayton 61   -121.935833 37.941111
1026 2020-10-22 Contra Costa 13 Concord 2462   -122.031111 37.978056
1027 2020-10-22 Contra Costa 13 Crockett 18   -122.213056 38.0525
1028 2020-10-22 Contra Costa 13 Danville 378   -122.0 37.821667
1029 2020-10-22 Contra Costa 13 Discovery Bay 122   -121.600278 37.908611
1030 2020-10-22 Contra Costa 13 El Cerrito 119   -122.311667 37.915833
1031 2020-10-22 Contra Costa 13 El Sobrante 306   -122.295278 37.977222
1032 2020-10-22 Contra Costa 13 Hercules 271   -122.288611 38.017222
1033 2020-10-22 Contra Costa 13 Lafayette 153   -122.118056 37.885833
1034 2020-10-22 Contra Costa 13 Martinez 393   -122.134167 38.019444
1035 2020-10-22 Contra Costa 13 Moraga 75   -122.129722 37.835
1036 2020-10-22 Contra Costa 13 Oakley 563   -121.7125 37.9975
1037 2020-10-22 Contra Costa 13 Orinda 120   -122.179722 37.882778
1038 2020-10-22 Contra Costa 13 Other 190      
1039 2020-10-22 Contra Costa 13 Pacheco 73   -122.075278 37.983611
1040 2020-10-22 Contra Costa 13 Pinole 240   -122.291111 38.004444
1041 2020-10-22 Contra Costa 13 Pittsburg 2067   -121.884722 38.028056
1042 2020-10-22 Contra Costa 13 Pleasant Hill 304   -122.0525 37.948056
1043 2020-10-22 Contra Costa 13 Richmond 3504   -122.347778 37.935833
1044 2020-10-22 Contra Costa 13 Rodeo 117   -122.266944 38.033056
1045 2020-10-22 Contra Costa 13 San Pablo 1573   -122.345556 37.962222
1046 2020-10-22 Contra Costa 13 San Ramon 400   -121.978056 37.78
1047 2020-10-22 Contra Costa 13 Walnut Creek 650   -122.065 37.906389
1975 2020-10-21 Contra Costa 13 Alamo 121   -122.032222 37.850278
1976 2020-10-21 Contra Costa 13 Antioch 2419   -121.805833 38.005
1977 2020-10-21 Contra Costa 13 Bay Point 952   -121.961667 38.029167
1978 2020-10-21 Contra Costa 13 Bethel Island 13   -121.640556 38.015
1979 2020-10-21 Contra Costa 13 Brentwood 710   -121.695833 37.931944
1980 2020-10-21 Contra Costa 13 Byron 24   -121.638056 37.867222
1981 2020-10-21 Contra Costa 13 Clayton 61   -121.935833 37.941111
1982 2020-10-21 Contra Costa 13 Concord 2448   -122.031111 37.978056
1983 2020-10-21 Contra Costa 13 Crockett 18   -122.213056 38.0525
1984 2020-10-21 Contra Costa 13 Danville 376   -122.0 37.821667
1985 2020-10-21 Contra Costa 13 Discovery Bay 120   -121.600278 37.908611
1986 2020-10-21 Contra Costa 13 El Cerrito 118   -122.311667 37.915833
1987 2020-10-21 Contra Costa 13 El Sobrante 306   -122.295278 37.977222
1988 2020-10-21 Contra Costa 13 Hercules 271   -122.288611 38.017222
1989 2020-10-21 Contra Costa 13 Lafayette 152   -122.118056 37.885833
1990 2020-10-21 Contra Costa 13 Martinez 389   -122.134167 38.019444
1991 2020-10-21 Contra Costa 13 Moraga 75   -122.129722 37.835
1992 2020-10-21 Contra Costa 13 Oakley 561   -121.7125 37.9975
1993 2020-10-21 Contra Costa 13 Orinda 121   -122.179722 37.882778
1994 2020-10-21 Contra Costa 13 Other 191      
1995 2020-10-21 Contra Costa 13 Pacheco 73   -122.075278 37.983611
1996 2020-10-21 Contra Costa 13 Pinole 239   -122.291111 38.004444
1997 2020-10-21 Contra Costa 13 Pittsburg 2057   -121.884722 38.028056
1998 2020-10-21 Contra Costa 13 Pleasant Hill 302   -122.0525 37.948056
1999 2020-10-21 Contra Costa 13 Richmond 3497   -122.347778 37.935833
2000 2020-10-21 Contra Costa 13 Rodeo 117   -122.266944 38.033056
2001 2020-10-21 Contra Costa 13 San Pablo 1564   -122.345556 37.962222
2002 2020-10-21 Contra Costa 13 San Ramon 398   -121.978056 37.78
2003 2020-10-21 Contra Costa 13 Walnut Creek 649   -122.065 37.906389
2959 2020-10-20 Contra Costa 13 Alamo 121   -122.032222 37.850278
2960 2020-10-20 Contra Costa 13 Antioch 2417   -121.805833 38.005
2961 2020-10-20 Contra Costa 13 Bay Point 949   -121.961667 38.029167
2962 2020-10-20 Contra Costa 13 Bethel Island 13   -121.640556 38.015
2963 2020-10-20 Contra Costa 13 Brentwood 706   -121.695833 37.931944
2964 2020-10-20 Contra Costa 13 Byron 24   -121.638056 37.867222
2965 2020-10-20 Contra Costa 13 Clayton 60   -121.935833 37.941111
2966 2020-10-20 Contra Costa 13 Concord 2437   -122.031111 37.978056
2967 2020-10-20 Contra Costa 13 Crockett 18   -122.213056 38.0525
2968 2020-10-20 Contra Costa 13 Danville 371   -122.0 37.821667
2969 2020-10-20 Contra Costa 13 Discovery Bay 117   -121.600278 37.908611
2970 2020-10-20 Contra Costa 13 El Cerrito 118   -122.311667 37.915833
2971 2020-10-20 Contra Costa 13 El Sobrante 306   -122.295278 37.977222

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