home / covid

Menu
  • GraphQL API

latimes_place_totals

Table actions
  • GraphQL API for 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

28,928 rows where county = "Placer" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips 1

  • 61 28,928

county 1

  • Placer · 28,928 ✖
Link rowid id name date ▲ county fips confirmed_cases note population
730 730 95602 95602: Auburn 2022-08-19 Placer 61 2324   17817
731 731 95603 95603: Auburn 2022-08-19 Placer 61 4807   27256
732 732 95626 95626: Elverta 2022-08-19 Placer 61 92   6371
733 733 95631 95631: Foresthill 2022-08-19 Placer 61 745   6387
734 734 95648 95648: Lincoln 2022-08-19 Placer 61 9310   51257
735 735 95650 95650: Loomis 2022-08-19 Placer 61 2174   12986
736 736 95658 95658: Newcastle 2022-08-19 Placer 61 951   6751
737 737 95661 95661: Roseville 2022-08-19 Placer 61 6856   30470
738 738 95663 95663: Penryn 2022-08-19 Placer 61 464   2102
739 739 95677 95677: Rocklin 2022-08-19 Placer 61 5253   23121
740 740 95678 95678: Roseville 2022-08-19 Placer 61 9037   41221
741 741 95681 95681: Sheridan 2022-08-19 Placer 61 241   1241
742 742 95701 95701: Alta 2022-08-19 Placer 61 121   842
743 743 95703 95703: Applegate 2022-08-19 Placer 61 269   3023
744 744 95713 95713: Colfax 2022-08-19 Placer 61 1095   8927
745 745 95714 95714: Dutch Flat 2022-08-19 Placer 61 47   701
746 746 95715 95715: Emigrant Gap 2022-08-19 Placer 61 18   0
747 747 95717 95717: Gold Run 2022-08-19 Placer 61 25   0
748 748 95722 95722: Meadow Vista 2022-08-19 Placer 61 661   4933
749 749 95724 95724: Norden 2022-08-19 Placer 61 6   0
750 750 95746 95746: Granite Bay 2022-08-19 Placer 61 3374   21786
751 751 95747 95747: Roseville 2022-08-19 Placer 61 14529   59715
752 752 95765 95765: Rocklin 2022-08-19 Placer 61 7704   37002
753 753 96140 96140: Carnelian Bay 2022-08-19 Placer 61 204   1659
754 754 96141 96141: Homewood 2022-08-19 Placer 61 74   933
755 755 96142 96142: Tahoma 2022-08-19 Placer 61 7   0
756 756 96143 96143: Kings Beach 2022-08-19 Placer 61 972   3988
757 757 96145 96145: Tahoe City 2022-08-19 Placer 61 654   3033
758 758 96146 96146: Olympic Valley 2022-08-19 Placer 61 270   1326
759 759 96148 96148: Tahoe Vista 2022-08-19 Placer 61 213   1450
760 760 96161 96161: Truckee 2022-08-19 Placer 61 340   18599
761 761 96162 96162: Truckee 2022-08-19 Placer 61 5 5 or fewer 0
1953 1953 95602 95602: Auburn 2022-08-18 Placer 61 2324   17817
1954 1954 95603 95603: Auburn 2022-08-18 Placer 61 4807   27256
1955 1955 95626 95626: Elverta 2022-08-18 Placer 61 92   6371
1956 1956 95631 95631: Foresthill 2022-08-18 Placer 61 745   6387
1957 1957 95648 95648: Lincoln 2022-08-18 Placer 61 9310   51257
1958 1958 95650 95650: Loomis 2022-08-18 Placer 61 2174   12986
1959 1959 95658 95658: Newcastle 2022-08-18 Placer 61 951   6751
1960 1960 95661 95661: Roseville 2022-08-18 Placer 61 6856   30470
1961 1961 95663 95663: Penryn 2022-08-18 Placer 61 464   2102
1962 1962 95677 95677: Rocklin 2022-08-18 Placer 61 5253   23121
1963 1963 95678 95678: Roseville 2022-08-18 Placer 61 9037   41221
1964 1964 95681 95681: Sheridan 2022-08-18 Placer 61 241   1241
1965 1965 95701 95701: Alta 2022-08-18 Placer 61 121   842
1966 1966 95703 95703: Applegate 2022-08-18 Placer 61 269   3023
1967 1967 95713 95713: Colfax 2022-08-18 Placer 61 1095   8927
1968 1968 95714 95714: Dutch Flat 2022-08-18 Placer 61 47   701
1969 1969 95715 95715: Emigrant Gap 2022-08-18 Placer 61 18   0
1970 1970 95717 95717: Gold Run 2022-08-18 Placer 61 25   0
1971 1971 95722 95722: Meadow Vista 2022-08-18 Placer 61 661   4933
1972 1972 95724 95724: Norden 2022-08-18 Placer 61 6   0
1973 1973 95746 95746: Granite Bay 2022-08-18 Placer 61 3374   21786
1974 1974 95747 95747: Roseville 2022-08-18 Placer 61 14529   59715
1975 1975 95765 95765: Rocklin 2022-08-18 Placer 61 7704   37002
1976 1976 96140 96140: Carnelian Bay 2022-08-18 Placer 61 204   1659
1977 1977 96141 96141: Homewood 2022-08-18 Placer 61 74   933
1978 1978 96142 96142: Tahoma 2022-08-18 Placer 61 7   0
1979 1979 96143 96143: Kings Beach 2022-08-18 Placer 61 972   3988
1980 1980 96145 96145: Tahoe City 2022-08-18 Placer 61 654   3033
1981 1981 96146 96146: Olympic Valley 2022-08-18 Placer 61 270   1326
1982 1982 96148 96148: Tahoe Vista 2022-08-18 Placer 61 213   1450
1983 1983 96161 96161: Truckee 2022-08-18 Placer 61 340   18599
1984 1984 96162 96162: Truckee 2022-08-18 Placer 61 5 5 or fewer 0
3191 3191 95602 95602: Auburn 2022-08-17 Placer 61 2324   17817
3192 3192 95603 95603: Auburn 2022-08-17 Placer 61 4807   27256
3193 3193 95626 95626: Elverta 2022-08-17 Placer 61 92   6371
3194 3194 95631 95631: Foresthill 2022-08-17 Placer 61 745   6387
3195 3195 95648 95648: Lincoln 2022-08-17 Placer 61 9310   51257
3196 3196 95650 95650: Loomis 2022-08-17 Placer 61 2174   12986
3197 3197 95658 95658: Newcastle 2022-08-17 Placer 61 951   6751
3198 3198 95661 95661: Roseville 2022-08-17 Placer 61 6856   30470
3199 3199 95663 95663: Penryn 2022-08-17 Placer 61 464   2102
3200 3200 95677 95677: Rocklin 2022-08-17 Placer 61 5253   23121
3201 3201 95678 95678: Roseville 2022-08-17 Placer 61 9037   41221
3202 3202 95681 95681: Sheridan 2022-08-17 Placer 61 241   1241
3203 3203 95701 95701: Alta 2022-08-17 Placer 61 121   842
3204 3204 95703 95703: Applegate 2022-08-17 Placer 61 269   3023
3205 3205 95713 95713: Colfax 2022-08-17 Placer 61 1095   8927
3206 3206 95714 95714: Dutch Flat 2022-08-17 Placer 61 47   701
3207 3207 95715 95715: Emigrant Gap 2022-08-17 Placer 61 18   0
3208 3208 95717 95717: Gold Run 2022-08-17 Placer 61 25   0
3209 3209 95722 95722: Meadow Vista 2022-08-17 Placer 61 661   4933
3210 3210 95724 95724: Norden 2022-08-17 Placer 61 6   0
3211 3211 95746 95746: Granite Bay 2022-08-17 Placer 61 3374   21786
3212 3212 95747 95747: Roseville 2022-08-17 Placer 61 14529   59715
3213 3213 95765 95765: Rocklin 2022-08-17 Placer 61 7704   37002
3214 3214 96140 96140: Carnelian Bay 2022-08-17 Placer 61 204   1659
3215 3215 96141 96141: Homewood 2022-08-17 Placer 61 74   933
3216 3216 96142 96142: Tahoma 2022-08-17 Placer 61 7   0
3217 3217 96143 96143: Kings Beach 2022-08-17 Placer 61 972   3988
3218 3218 96145 96145: Tahoe City 2022-08-17 Placer 61 654   3033
3219 3219 96146 96146: Olympic Valley 2022-08-17 Placer 61 270   1326
3220 3220 96148 96148: Tahoe Vista 2022-08-17 Placer 61 213   1450
3221 3221 96161 96161: Truckee 2022-08-17 Placer 61 340   18599
3222 3222 96162 96162: Truckee 2022-08-17 Placer 61 5 5 or fewer 0
4429 4429 95602 95602: Auburn 2022-08-16 Placer 61 2310   17817
4430 4430 95603 95603: Auburn 2022-08-16 Placer 61 4794   27256
4431 4431 95626 95626: Elverta 2022-08-16 Placer 61 91   6371
4432 4432 95631 95631: Foresthill 2022-08-16 Placer 61 741   6387

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [latimes_place_totals] (
   [id] TEXT,
   [name] TEXT,
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [confirmed_cases] INTEGER,
   [note] TEXT,
   [population] TEXT
);
Powered by Datasette · Queries took 1166.628ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals