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,415 rows where county = "Sacramento" sorted by date descending

View and edit SQL

Suggested facets: x, y, date (date)

place

fips

  • 67 1,415

county

  • Sacramento · 1,415
Link rowid date ▲ county fips place confirmed_cases note x y
701 2020-10-27 Sacramento 67 Citrus Heights 1034   -121.283333 38.7
702 2020-10-27 Sacramento 67 Elk Grove 2549   -121.381944 38.438333
703 2020-10-27 Sacramento 67 Folsom 465   -121.157778 38.672222
704 2020-10-27 Sacramento 67 Galt 659   -121.303056 38.260833
705 2020-10-27 Sacramento 67 Isleton 34   -121.609167 38.161944
706 2020-10-27 Sacramento 67 Other 4966      
707 2020-10-27 Sacramento 67 Rancho Cordova 1029   -121.302778 38.589167
708 2020-10-27 Sacramento 67 Sacramento 14755   -121.494444 38.581667
1659 2020-10-26 Sacramento 67 Citrus Heights 1030   -121.283333 38.7
1660 2020-10-26 Sacramento 67 Elk Grove 2536   -121.381944 38.438333
1661 2020-10-26 Sacramento 67 Folsom 463   -121.157778 38.672222
1662 2020-10-26 Sacramento 67 Galt 656   -121.303056 38.260833
1663 2020-10-26 Sacramento 67 Isleton 33   -121.609167 38.161944
1664 2020-10-26 Sacramento 67 Other 4930      
1665 2020-10-26 Sacramento 67 Rancho Cordova 1025   -121.302778 38.589167
1666 2020-10-26 Sacramento 67 Sacramento 14673   -121.494444 38.581667
3945 2020-10-23 Sacramento 67 Citrus Heights 1021   -121.283333 38.7
3946 2020-10-23 Sacramento 67 Elk Grove 2506   -121.381944 38.438333
3947 2020-10-23 Sacramento 67 Folsom 451   -121.157778 38.672222
3948 2020-10-23 Sacramento 67 Galt 646   -121.303056 38.260833
3949 2020-10-23 Sacramento 67 Isleton 33   -121.609167 38.161944
3950 2020-10-23 Sacramento 67 Other 4861      
3951 2020-10-23 Sacramento 67 Rancho Cordova 1016   -121.302778 38.589167
3952 2020-10-23 Sacramento 67 Sacramento 14476   -121.494444 38.581667
4946 2020-10-22 Sacramento 67 Citrus Heights 1011   -121.283333 38.7
4947 2020-10-22 Sacramento 67 Elk Grove 2491   -121.381944 38.438333
4948 2020-10-22 Sacramento 67 Folsom 448   -121.157778 38.672222
4949 2020-10-22 Sacramento 67 Galt 645   -121.303056 38.260833
4950 2020-10-22 Sacramento 67 Isleton 33   -121.609167 38.161944
4951 2020-10-22 Sacramento 67 Other 4844      
4952 2020-10-22 Sacramento 67 Rancho Cordova 1012   -121.302778 38.589167
4953 2020-10-22 Sacramento 67 Sacramento 14360   -121.494444 38.581667
5920 2020-10-21 Sacramento 67 Citrus Heights 999   -121.283333 38.7
5921 2020-10-21 Sacramento 67 Elk Grove 2482   -121.381944 38.438333
5922 2020-10-21 Sacramento 67 Folsom 448   -121.157778 38.672222
5923 2020-10-21 Sacramento 67 Galt 641   -121.303056 38.260833
5924 2020-10-21 Sacramento 67 Isleton 33   -121.609167 38.161944
5925 2020-10-21 Sacramento 67 Other 4819      
5926 2020-10-21 Sacramento 67 Rancho Cordova 1006   -121.302778 38.589167
5927 2020-10-21 Sacramento 67 Sacramento 14281   -121.494444 38.581667
6932 2020-10-20 Sacramento 67 Citrus Heights 989   -121.283333 38.7
6933 2020-10-20 Sacramento 67 Elk Grove 2470   -121.381944 38.438333
6934 2020-10-20 Sacramento 67 Folsom 445   -121.157778 38.672222
6935 2020-10-20 Sacramento 67 Galt 640   -121.303056 38.260833
6936 2020-10-20 Sacramento 67 Isleton 33   -121.609167 38.161944
6937 2020-10-20 Sacramento 67 Other 4800      
6938 2020-10-20 Sacramento 67 Rancho Cordova 1002   -121.302778 38.589167
6939 2020-10-20 Sacramento 67 Sacramento 14190   -121.494444 38.581667
7882 2020-10-19 Sacramento 67 Citrus Heights 983   -121.283333 38.7
7883 2020-10-19 Sacramento 67 Elk Grove 2443   -121.381944 38.438333
7884 2020-10-19 Sacramento 67 Folsom 441   -121.157778 38.672222
7885 2020-10-19 Sacramento 67 Galt 639   -121.303056 38.260833
7886 2020-10-19 Sacramento 67 Isleton 32   -121.609167 38.161944
7887 2020-10-19 Sacramento 67 Other 4772      
7888 2020-10-19 Sacramento 67 Rancho Cordova 995   -121.302778 38.589167
7889 2020-10-19 Sacramento 67 Sacramento 14031   -121.494444 38.581667
10131 2020-10-16 Sacramento 67 Citrus Heights 977   -121.283333 38.7
10132 2020-10-16 Sacramento 67 Elk Grove 2415   -121.381944 38.438333
10133 2020-10-16 Sacramento 67 Folsom 433   -121.157778 38.672222
10134 2020-10-16 Sacramento 67 Galt 635   -121.303056 38.260833
10135 2020-10-16 Sacramento 67 Isleton 32   -121.609167 38.161944
10136 2020-10-16 Sacramento 67 Other 4700      
10137 2020-10-16 Sacramento 67 Rancho Cordova 969   -121.302778 38.589167
10138 2020-10-16 Sacramento 67 Sacramento 13787   -121.494444 38.581667
11050 2020-10-15 Sacramento 67 Citrus Heights 975   -121.283333 38.7
11051 2020-10-15 Sacramento 67 Elk Grove 2410   -121.381944 38.438333
11052 2020-10-15 Sacramento 67 Folsom 432   -121.157778 38.672222
11053 2020-10-15 Sacramento 67 Galt 629   -121.303056 38.260833
11054 2020-10-15 Sacramento 67 Isleton 32   -121.609167 38.161944
11055 2020-10-15 Sacramento 67 Other 4670      
11056 2020-10-15 Sacramento 67 Rancho Cordova 967   -121.302778 38.589167
11057 2020-10-15 Sacramento 67 Sacramento 13745   -121.494444 38.581667
11982 2020-10-14 Sacramento 67 Citrus Heights 974   -121.283333 38.7
11983 2020-10-14 Sacramento 67 Elk Grove 2408   -121.381944 38.438333
11984 2020-10-14 Sacramento 67 Folsom 431   -121.157778 38.672222
11985 2020-10-14 Sacramento 67 Galt 629   -121.303056 38.260833
11986 2020-10-14 Sacramento 67 Isleton 32   -121.609167 38.161944
11987 2020-10-14 Sacramento 67 Other 4661      
11988 2020-10-14 Sacramento 67 Rancho Cordova 962   -121.302778 38.589167
11989 2020-10-14 Sacramento 67 Sacramento 13725   -121.494444 38.581667
12868 2020-10-13 Sacramento 67 Citrus Heights 971   -121.283333 38.7
12869 2020-10-13 Sacramento 67 Elk Grove 2398   -121.381944 38.438333
12870 2020-10-13 Sacramento 67 Folsom 429   -121.157778 38.672222
12871 2020-10-13 Sacramento 67 Galt 627   -121.303056 38.260833
12872 2020-10-13 Sacramento 67 Isleton 32   -121.609167 38.161944
12873 2020-10-13 Sacramento 67 Other 4644      
12874 2020-10-13 Sacramento 67 Rancho Cordova 957   -121.302778 38.589167
12875 2020-10-13 Sacramento 67 Sacramento 13673   -121.494444 38.581667
13818 2020-10-12 Sacramento 67 Citrus Heights 968   -121.283333 38.7
13819 2020-10-12 Sacramento 67 Elk Grove 2377   -121.381944 38.438333
13820 2020-10-12 Sacramento 67 Folsom 427   -121.157778 38.672222
13821 2020-10-12 Sacramento 67 Galt 622   -121.303056 38.260833
13822 2020-10-12 Sacramento 67 Isleton 32   -121.609167 38.161944
13823 2020-10-12 Sacramento 67 Other 4617      
13824 2020-10-12 Sacramento 67 Rancho Cordova 954   -121.302778 38.589167
13825 2020-10-12 Sacramento 67 Sacramento 13622   -121.494444 38.581667
16136 2020-10-09 Sacramento 67 Citrus Heights 952   -121.283333 38.7
16137 2020-10-09 Sacramento 67 Elk Grove 2358   -121.381944 38.438333
16138 2020-10-09 Sacramento 67 Folsom 420   -121.157778 38.672222
16139 2020-10-09 Sacramento 67 Galt 619   -121.303056 38.260833

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