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

View and edit SQL

Suggested facets: x, y, date (date)

place

fips

  • 67 · 1,399

county

Link rowid date ▲ county fips place confirmed_cases note x y
661 2020-10-23 Sacramento 67 Citrus Heights 1021   -121.283333 38.7
662 2020-10-23 Sacramento 67 Elk Grove 2506   -121.381944 38.438333
663 2020-10-23 Sacramento 67 Folsom 451   -121.157778 38.672222
664 2020-10-23 Sacramento 67 Galt 646   -121.303056 38.260833
665 2020-10-23 Sacramento 67 Isleton 33   -121.609167 38.161944
666 2020-10-23 Sacramento 67 Other 4861      
667 2020-10-23 Sacramento 67 Rancho Cordova 1016   -121.302778 38.589167
668 2020-10-23 Sacramento 67 Sacramento 14476   -121.494444 38.581667
1662 2020-10-22 Sacramento 67 Citrus Heights 1011   -121.283333 38.7
1663 2020-10-22 Sacramento 67 Elk Grove 2491   -121.381944 38.438333
1664 2020-10-22 Sacramento 67 Folsom 448   -121.157778 38.672222
1665 2020-10-22 Sacramento 67 Galt 645   -121.303056 38.260833
1666 2020-10-22 Sacramento 67 Isleton 33   -121.609167 38.161944
1667 2020-10-22 Sacramento 67 Other 4844      
1668 2020-10-22 Sacramento 67 Rancho Cordova 1012   -121.302778 38.589167
1669 2020-10-22 Sacramento 67 Sacramento 14360   -121.494444 38.581667
2636 2020-10-21 Sacramento 67 Citrus Heights 999   -121.283333 38.7
2637 2020-10-21 Sacramento 67 Elk Grove 2482   -121.381944 38.438333
2638 2020-10-21 Sacramento 67 Folsom 448   -121.157778 38.672222
2639 2020-10-21 Sacramento 67 Galt 641   -121.303056 38.260833
2640 2020-10-21 Sacramento 67 Isleton 33   -121.609167 38.161944
2641 2020-10-21 Sacramento 67 Other 4819      
2642 2020-10-21 Sacramento 67 Rancho Cordova 1006   -121.302778 38.589167
2643 2020-10-21 Sacramento 67 Sacramento 14281   -121.494444 38.581667
3648 2020-10-20 Sacramento 67 Citrus Heights 989   -121.283333 38.7
3649 2020-10-20 Sacramento 67 Elk Grove 2470   -121.381944 38.438333
3650 2020-10-20 Sacramento 67 Folsom 445   -121.157778 38.672222
3651 2020-10-20 Sacramento 67 Galt 640   -121.303056 38.260833
3652 2020-10-20 Sacramento 67 Isleton 33   -121.609167 38.161944
3653 2020-10-20 Sacramento 67 Other 4800      
3654 2020-10-20 Sacramento 67 Rancho Cordova 1002   -121.302778 38.589167
3655 2020-10-20 Sacramento 67 Sacramento 14190   -121.494444 38.581667
4598 2020-10-19 Sacramento 67 Citrus Heights 983   -121.283333 38.7
4599 2020-10-19 Sacramento 67 Elk Grove 2443   -121.381944 38.438333
4600 2020-10-19 Sacramento 67 Folsom 441   -121.157778 38.672222
4601 2020-10-19 Sacramento 67 Galt 639   -121.303056 38.260833
4602 2020-10-19 Sacramento 67 Isleton 32   -121.609167 38.161944
4603 2020-10-19 Sacramento 67 Other 4772      
4604 2020-10-19 Sacramento 67 Rancho Cordova 995   -121.302778 38.589167
4605 2020-10-19 Sacramento 67 Sacramento 14031   -121.494444 38.581667
6847 2020-10-16 Sacramento 67 Citrus Heights 977   -121.283333 38.7
6848 2020-10-16 Sacramento 67 Elk Grove 2415   -121.381944 38.438333
6849 2020-10-16 Sacramento 67 Folsom 433   -121.157778 38.672222
6850 2020-10-16 Sacramento 67 Galt 635   -121.303056 38.260833
6851 2020-10-16 Sacramento 67 Isleton 32   -121.609167 38.161944
6852 2020-10-16 Sacramento 67 Other 4700      
6853 2020-10-16 Sacramento 67 Rancho Cordova 969   -121.302778 38.589167
6854 2020-10-16 Sacramento 67 Sacramento 13787   -121.494444 38.581667
7766 2020-10-15 Sacramento 67 Citrus Heights 975   -121.283333 38.7
7767 2020-10-15 Sacramento 67 Elk Grove 2410   -121.381944 38.438333
7768 2020-10-15 Sacramento 67 Folsom 432   -121.157778 38.672222
7769 2020-10-15 Sacramento 67 Galt 629   -121.303056 38.260833
7770 2020-10-15 Sacramento 67 Isleton 32   -121.609167 38.161944
7771 2020-10-15 Sacramento 67 Other 4670      
7772 2020-10-15 Sacramento 67 Rancho Cordova 967   -121.302778 38.589167
7773 2020-10-15 Sacramento 67 Sacramento 13745   -121.494444 38.581667
8698 2020-10-14 Sacramento 67 Citrus Heights 974   -121.283333 38.7
8699 2020-10-14 Sacramento 67 Elk Grove 2408   -121.381944 38.438333
8700 2020-10-14 Sacramento 67 Folsom 431   -121.157778 38.672222
8701 2020-10-14 Sacramento 67 Galt 629   -121.303056 38.260833
8702 2020-10-14 Sacramento 67 Isleton 32   -121.609167 38.161944
8703 2020-10-14 Sacramento 67 Other 4661      
8704 2020-10-14 Sacramento 67 Rancho Cordova 962   -121.302778 38.589167
8705 2020-10-14 Sacramento 67 Sacramento 13725   -121.494444 38.581667
9584 2020-10-13 Sacramento 67 Citrus Heights 971   -121.283333 38.7
9585 2020-10-13 Sacramento 67 Elk Grove 2398   -121.381944 38.438333
9586 2020-10-13 Sacramento 67 Folsom 429   -121.157778 38.672222
9587 2020-10-13 Sacramento 67 Galt 627   -121.303056 38.260833
9588 2020-10-13 Sacramento 67 Isleton 32   -121.609167 38.161944
9589 2020-10-13 Sacramento 67 Other 4644      
9590 2020-10-13 Sacramento 67 Rancho Cordova 957   -121.302778 38.589167
9591 2020-10-13 Sacramento 67 Sacramento 13673   -121.494444 38.581667
10534 2020-10-12 Sacramento 67 Citrus Heights 968   -121.283333 38.7
10535 2020-10-12 Sacramento 67 Elk Grove 2377   -121.381944 38.438333
10536 2020-10-12 Sacramento 67 Folsom 427   -121.157778 38.672222
10537 2020-10-12 Sacramento 67 Galt 622   -121.303056 38.260833
10538 2020-10-12 Sacramento 67 Isleton 32   -121.609167 38.161944
10539 2020-10-12 Sacramento 67 Other 4617      
10540 2020-10-12 Sacramento 67 Rancho Cordova 954   -121.302778 38.589167
10541 2020-10-12 Sacramento 67 Sacramento 13622   -121.494444 38.581667
12852 2020-10-09 Sacramento 67 Citrus Heights 952   -121.283333 38.7
12853 2020-10-09 Sacramento 67 Elk Grove 2358   -121.381944 38.438333
12854 2020-10-09 Sacramento 67 Folsom 420   -121.157778 38.672222
12855 2020-10-09 Sacramento 67 Galt 619   -121.303056 38.260833
12856 2020-10-09 Sacramento 67 Isleton 32   -121.609167 38.161944
12857 2020-10-09 Sacramento 67 Other 4580      
12858 2020-10-09 Sacramento 67 Rancho Cordova 942   -121.302778 38.589167
12859 2020-10-09 Sacramento 67 Sacramento 13520   -121.494444 38.581667
13837 2020-10-08 Sacramento 67 Citrus Heights 945   -121.283333 38.7
13838 2020-10-08 Sacramento 67 Elk Grove 2345   -121.381944 38.438333
13839 2020-10-08 Sacramento 67 Folsom 417   -121.157778 38.672222
13840 2020-10-08 Sacramento 67 Galt 618   -121.303056 38.260833
13841 2020-10-08 Sacramento 67 Isleton 32   -121.609167 38.161944
13842 2020-10-08 Sacramento 67 Other 4559      
13843 2020-10-08 Sacramento 67 Rancho Cordova 936   -121.302778 38.589167
13844 2020-10-08 Sacramento 67 Sacramento 13445   -121.494444 38.581667
14822 2020-10-07 Sacramento 67 Citrus Heights 942   -121.283333 38.7
14823 2020-10-07 Sacramento 67 Elk Grove 2334   -121.381944 38.438333
14824 2020-10-07 Sacramento 67 Folsom 412   -121.157778 38.672222
14825 2020-10-07 Sacramento 67 Galt 618   -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 797.898ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals