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,635 rows where county = "Contra Costa" sorted by date descending

View and edit SQL

Suggested facets: x, y, date (date)

fips

  • 13 5,635

county

  • Contra Costa · 5,635
Link rowid date ▲ county fips place confirmed_cases note x y
37 2020-10-27 Contra Costa 13 Alamo 124   -122.032222 37.850278
38 2020-10-27 Contra Costa 13 Antioch 2479   -121.805833 38.005
39 2020-10-27 Contra Costa 13 Bay Point 978   -121.961667 38.029167
40 2020-10-27 Contra Costa 13 Bethel Island 14   -121.640556 38.015
41 2020-10-27 Contra Costa 13 Brentwood 732   -121.695833 37.931944
42 2020-10-27 Contra Costa 13 Byron 24   -121.638056 37.867222
43 2020-10-27 Contra Costa 13 Clayton 65   -121.935833 37.941111
44 2020-10-27 Contra Costa 13 Concord 2506   -122.031111 37.978056
45 2020-10-27 Contra Costa 13 Crockett 19   -122.213056 38.0525
46 2020-10-27 Contra Costa 13 Danville 384   -122.0 37.821667
47 2020-10-27 Contra Costa 13 Discovery Bay 125   -121.600278 37.908611
48 2020-10-27 Contra Costa 13 El Cerrito 122   -122.311667 37.915833
49 2020-10-27 Contra Costa 13 El Sobrante 313   -122.295278 37.977222
50 2020-10-27 Contra Costa 13 Hercules 279   -122.288611 38.017222
51 2020-10-27 Contra Costa 13 Lafayette 158   -122.118056 37.885833
52 2020-10-27 Contra Costa 13 Martinez 418   -122.134167 38.019444
53 2020-10-27 Contra Costa 13 Moraga 79   -122.129722 37.835
54 2020-10-27 Contra Costa 13 Oakley 583   -121.7125 37.9975
55 2020-10-27 Contra Costa 13 Orinda 130   -122.179722 37.882778
56 2020-10-27 Contra Costa 13 Other 191      
57 2020-10-27 Contra Costa 13 Pacheco 73   -122.075278 37.983611
58 2020-10-27 Contra Costa 13 Pinole 249   -122.291111 38.004444
59 2020-10-27 Contra Costa 13 Pittsburg 2105   -121.884722 38.028056
60 2020-10-27 Contra Costa 13 Pleasant Hill 310   -122.0525 37.948056
61 2020-10-27 Contra Costa 13 Richmond 3551   -122.347778 37.935833
62 2020-10-27 Contra Costa 13 Rodeo 118   -122.266944 38.033056
63 2020-10-27 Contra Costa 13 San Pablo 1609   -122.345556 37.962222
64 2020-10-27 Contra Costa 13 San Ramon 414   -121.978056 37.78
65 2020-10-27 Contra Costa 13 Walnut Creek 665   -122.065 37.906389
1009 2020-10-26 Contra Costa 13 Alamo 124   -122.032222 37.850278
1010 2020-10-26 Contra Costa 13 Antioch 2475   -121.805833 38.005
1011 2020-10-26 Contra Costa 13 Bay Point 972   -121.961667 38.029167
1012 2020-10-26 Contra Costa 13 Bethel Island 14   -121.640556 38.015
1013 2020-10-26 Contra Costa 13 Brentwood 725   -121.695833 37.931944
1014 2020-10-26 Contra Costa 13 Byron 24   -121.638056 37.867222
1015 2020-10-26 Contra Costa 13 Clayton 63   -121.935833 37.941111
1016 2020-10-26 Contra Costa 13 Concord 2501   -122.031111 37.978056
1017 2020-10-26 Contra Costa 13 Crockett 19   -122.213056 38.0525
1018 2020-10-26 Contra Costa 13 Danville 384   -122.0 37.821667
1019 2020-10-26 Contra Costa 13 Discovery Bay 124   -121.600278 37.908611
1020 2020-10-26 Contra Costa 13 El Cerrito 122   -122.311667 37.915833
1021 2020-10-26 Contra Costa 13 El Sobrante 312   -122.295278 37.977222
1022 2020-10-26 Contra Costa 13 Hercules 279   -122.288611 38.017222
1023 2020-10-26 Contra Costa 13 Lafayette 157   -122.118056 37.885833
1024 2020-10-26 Contra Costa 13 Martinez 417   -122.134167 38.019444
1025 2020-10-26 Contra Costa 13 Moraga 78   -122.129722 37.835
1026 2020-10-26 Contra Costa 13 Oakley 578   -121.7125 37.9975
1027 2020-10-26 Contra Costa 13 Orinda 129   -122.179722 37.882778
1028 2020-10-26 Contra Costa 13 Other 191      
1029 2020-10-26 Contra Costa 13 Pacheco 73   -122.075278 37.983611
1030 2020-10-26 Contra Costa 13 Pinole 246   -122.291111 38.004444
1031 2020-10-26 Contra Costa 13 Pittsburg 2098   -121.884722 38.028056
1032 2020-10-26 Contra Costa 13 Pleasant Hill 309   -122.0525 37.948056
1033 2020-10-26 Contra Costa 13 Richmond 3548   -122.347778 37.935833
1034 2020-10-26 Contra Costa 13 Rodeo 118   -122.266944 38.033056
1035 2020-10-26 Contra Costa 13 San Pablo 1606   -122.345556 37.962222
1036 2020-10-26 Contra Costa 13 San Ramon 415   -121.978056 37.78
1037 2020-10-26 Contra Costa 13 Walnut Creek 662   -122.065 37.906389
1956 2020-10-25 Contra Costa 13 Alamo 124   -122.032222 37.850278
1957 2020-10-25 Contra Costa 13 Antioch 2467   -121.805833 38.005
1958 2020-10-25 Contra Costa 13 Bay Point 967   -121.961667 38.029167
1959 2020-10-25 Contra Costa 13 Bethel Island 14   -121.640556 38.015
1960 2020-10-25 Contra Costa 13 Brentwood 724   -121.695833 37.931944
1961 2020-10-25 Contra Costa 13 Byron 24   -121.638056 37.867222
1962 2020-10-25 Contra Costa 13 Clayton 63   -121.935833 37.941111
1963 2020-10-25 Contra Costa 13 Concord 2494   -122.031111 37.978056
1964 2020-10-25 Contra Costa 13 Crockett 19   -122.213056 38.0525
1965 2020-10-25 Contra Costa 13 Danville 383   -122.0 37.821667
1966 2020-10-25 Contra Costa 13 Discovery Bay 124   -121.600278 37.908611
1967 2020-10-25 Contra Costa 13 El Cerrito 122   -122.311667 37.915833
1968 2020-10-25 Contra Costa 13 El Sobrante 310   -122.295278 37.977222
1969 2020-10-25 Contra Costa 13 Hercules 277   -122.288611 38.017222
1970 2020-10-25 Contra Costa 13 Lafayette 155   -122.118056 37.885833
1971 2020-10-25 Contra Costa 13 Martinez 411   -122.134167 38.019444
1972 2020-10-25 Contra Costa 13 Moraga 78   -122.129722 37.835
1973 2020-10-25 Contra Costa 13 Oakley 575   -121.7125 37.9975
1974 2020-10-25 Contra Costa 13 Orinda 129   -122.179722 37.882778
1975 2020-10-25 Contra Costa 13 Other 191      
1976 2020-10-25 Contra Costa 13 Pacheco 73   -122.075278 37.983611
1977 2020-10-25 Contra Costa 13 Pinole 246   -122.291111 38.004444
1978 2020-10-25 Contra Costa 13 Pittsburg 2087   -121.884722 38.028056
1979 2020-10-25 Contra Costa 13 Pleasant Hill 309   -122.0525 37.948056
1980 2020-10-25 Contra Costa 13 Richmond 3539   -122.347778 37.935833
1981 2020-10-25 Contra Costa 13 Rodeo 118   -122.266944 38.033056
1982 2020-10-25 Contra Costa 13 San Pablo 1600   -122.345556 37.962222
1983 2020-10-25 Contra Costa 13 San Ramon 411   -121.978056 37.78
1984 2020-10-25 Contra Costa 13 Walnut Creek 660   -122.065 37.906389
2639 2020-10-24 Contra Costa 13 Alamo 124   -122.032222 37.850278
2640 2020-10-24 Contra Costa 13 Antioch 2449   -121.805833 38.005
2641 2020-10-24 Contra Costa 13 Bay Point 962   -121.961667 38.029167
2642 2020-10-24 Contra Costa 13 Bethel Island 14   -121.640556 38.015
2643 2020-10-24 Contra Costa 13 Brentwood 721   -121.695833 37.931944
2644 2020-10-24 Contra Costa 13 Byron 24   -121.638056 37.867222
2645 2020-10-24 Contra Costa 13 Clayton 63   -121.935833 37.941111
2646 2020-10-24 Contra Costa 13 Concord 2484   -122.031111 37.978056
2647 2020-10-24 Contra Costa 13 Crockett 19   -122.213056 38.0525
2648 2020-10-24 Contra Costa 13 Danville 385   -122.0 37.821667
2649 2020-10-24 Contra Costa 13 Discovery Bay 125   -121.600278 37.908611
2650 2020-10-24 Contra Costa 13 El Cerrito 120   -122.311667 37.915833
2651 2020-10-24 Contra Costa 13 El Sobrante 310   -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 949.307ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals