latimes-place-totals
Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README
- id
- The unique identifier of the city, neighborhood or other area.
- name
- The name of the city, neighborhood or other area.
- date
- The date when the data were retrieved in ISO 8601 format.
- county
- The name of the county where the city is located.
- fips
- The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
- confirmed_cases
- The cumulative number of confirmed coronavirus case at that time.
- note
- In cases where the confirmed_cases are obscured, this explains the range of possible values.
- population
- The number of residents in the area. Not available for all places.
1,251,796 rows sorted by confirmed_cases descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2022-02-22 1,277
- 2022-02-23 1,277
- 2022-02-24 1,277
- 2022-02-25 1,277
- 2022-02-26 1,277
- 2022-02-27 1,277
- 2022-02-28 1,277
- 2021-01-04 1,276
- 2021-01-05 1,276
- 2021-01-06 1,276
- 2021-01-07 1,276
- 2021-01-08 1,276
- 2021-01-09 1,276
- 2021-01-10 1,276
- 2021-01-11 1,276
- 2021-01-12 1,276
- 2021-01-13 1,276
- 2021-01-14 1,276
- 2021-01-15 1,276
- 2021-01-16 1,276
- 2021-01-17 1,276
- 2021-01-18 1,276
- 2021-01-19 1,276
- 2021-01-20 1,276
- 2021-01-21 1,276
- 2021-01-22 1,276
- 2021-01-23 1,276
- 2021-01-24 1,276
- 2021-01-25 1,276
- 2021-01-26 1,276
- …
Link | rowid | id | name | date | county | fips | confirmed_cases ▲ | note | population |
---|---|---|---|---|---|---|---|---|---|
844871 | 844871 | 93426 | 93426: Bradley | 2021-03-02 | Monterey | 53 | 384615384615384 | 1604 | |
698 | 698 | San Jose | San Jose | 2022-12-30 | Santa Clara | 85 | 279047 | 1026658 | |
1526 | 1526 | San Jose | San Jose | 2022-12-29 | Santa Clara | 85 | 279047 | 1026658 | |
2707 | 2707 | San Jose | San Jose | 2022-12-28 | Santa Clara | 85 | 277669 | 1026658 | |
3888 | 3888 | San Jose | San Jose | 2022-12-27 | Santa Clara | 85 | 277669 | 1026658 | |
5069 | 5069 | San Jose | San Jose | 2022-12-26 | Santa Clara | 85 | 277669 | 1026658 | |
6250 | 6250 | San Jose | San Jose | 2022-12-25 | Santa Clara | 85 | 277669 | 1026658 | |
7431 | 7431 | San Jose | San Jose | 2022-12-24 | Santa Clara | 85 | 277669 | 1026658 | |
8612 | 8612 | San Jose | San Jose | 2022-12-23 | Santa Clara | 85 | 277669 | 1026658 | |
9793 | 9793 | San Jose | San Jose | 2022-12-22 | Santa Clara | 85 | 277669 | 1026658 | |
10974 | 10974 | San Jose | San Jose | 2022-12-21 | Santa Clara | 85 | 276076 | 1026658 | |
12155 | 12155 | San Jose | San Jose | 2022-12-20 | Santa Clara | 85 | 276076 | 1026658 | |
13336 | 13336 | San Jose | San Jose | 2022-12-19 | Santa Clara | 85 | 276076 | 1026658 | |
14517 | 14517 | San Jose | San Jose | 2022-12-18 | Santa Clara | 85 | 276076 | 1026658 | |
15698 | 15698 | San Jose | San Jose | 2022-12-17 | Santa Clara | 85 | 276076 | 1026658 | |
16879 | 16879 | San Jose | San Jose | 2022-12-16 | Santa Clara | 85 | 276076 | 1026658 | |
18060 | 18060 | San Jose | San Jose | 2022-12-15 | Santa Clara | 85 | 276076 | 1026658 | |
19241 | 19241 | San Jose | San Jose | 2022-12-14 | Santa Clara | 85 | 273517 | 1026658 | |
20422 | 20422 | San Jose | San Jose | 2022-12-13 | Santa Clara | 85 | 273517 | 1026658 | |
21603 | 21603 | San Jose | San Jose | 2022-12-12 | Santa Clara | 85 | 273517 | 1026658 | |
22784 | 22784 | San Jose | San Jose | 2022-12-11 | Santa Clara | 85 | 273517 | 1026658 | |
23965 | 23965 | San Jose | San Jose | 2022-12-10 | Santa Clara | 85 | 273517 | 1026658 | |
25146 | 25146 | San Jose | San Jose | 2022-12-09 | Santa Clara | 85 | 273517 | 1026658 | |
26327 | 26327 | San Jose | San Jose | 2022-12-08 | Santa Clara | 85 | 273517 | 1026658 | |
27508 | 27508 | San Jose | San Jose | 2022-12-07 | Santa Clara | 85 | 268160 | 1026658 | |
28689 | 28689 | San Jose | San Jose | 2022-12-06 | Santa Clara | 85 | 268160 | 1026658 | |
29870 | 29870 | San Jose | San Jose | 2022-12-05 | Santa Clara | 85 | 268160 | 1026658 | |
31051 | 31051 | San Jose | San Jose | 2022-12-04 | Santa Clara | 85 | 268160 | 1026658 | |
32232 | 32232 | San Jose | San Jose | 2022-12-03 | Santa Clara | 85 | 268160 | 1026658 | |
33413 | 33413 | San Jose | San Jose | 2022-12-02 | Santa Clara | 85 | 268160 | 1026658 | |
34594 | 34594 | San Jose | San Jose | 2022-12-01 | Santa Clara | 85 | 265137 | 1026658 | |
35775 | 35775 | San Jose | San Jose | 2022-11-30 | Santa Clara | 85 | 265137 | 1026658 | |
37006 | 37006 | San Jose | San Jose | 2022-11-29 | Santa Clara | 85 | 265137 | 1026658 | |
38237 | 38237 | San Jose | San Jose | 2022-11-28 | Santa Clara | 85 | 265137 | 1026658 | |
39468 | 39468 | San Jose | San Jose | 2022-11-27 | Santa Clara | 85 | 265137 | 1026658 | |
40699 | 40699 | San Jose | San Jose | 2022-11-26 | Santa Clara | 85 | 265137 | 1026658 | |
41930 | 41930 | San Jose | San Jose | 2022-11-25 | Santa Clara | 85 | 265137 | 1026658 | |
43161 | 43161 | San Jose | San Jose | 2022-11-24 | Santa Clara | 85 | 265137 | 1026658 | |
44392 | 44392 | San Jose | San Jose | 2022-11-23 | Santa Clara | 85 | 265137 | 1026658 | |
45623 | 45623 | San Jose | San Jose | 2022-11-22 | Santa Clara | 85 | 265137 | 1026658 | |
46854 | 46854 | San Jose | San Jose | 2022-11-21 | Santa Clara | 85 | 265137 | 1026658 | |
48085 | 48085 | San Jose | San Jose | 2022-11-20 | Santa Clara | 85 | 263264 | 1026658 | |
49316 | 49316 | San Jose | San Jose | 2022-11-19 | Santa Clara | 85 | 263264 | 1026658 | |
50547 | 50547 | San Jose | San Jose | 2022-11-18 | Santa Clara | 85 | 263264 | 1026658 | |
51778 | 51778 | San Jose | San Jose | 2022-11-17 | Santa Clara | 85 | 263264 | 1026658 | |
53009 | 53009 | San Jose | San Jose | 2022-11-16 | Santa Clara | 85 | 263264 | 1026658 | |
54240 | 54240 | San Jose | San Jose | 2022-11-15 | Santa Clara | 85 | 263264 | 1026658 | |
55471 | 55471 | San Jose | San Jose | 2022-11-14 | Santa Clara | 85 | 263264 | 1026658 | |
56702 | 56702 | San Jose | San Jose | 2022-11-13 | Santa Clara | 85 | 263264 | 1026658 | |
57933 | 57933 | San Jose | San Jose | 2022-11-12 | Santa Clara | 85 | 263264 | 1026658 | |
59164 | 59164 | San Jose | San Jose | 2022-11-11 | Santa Clara | 85 | 263264 | 1026658 | |
60395 | 60395 | San Jose | San Jose | 2022-11-10 | Santa Clara | 85 | 263264 | 1026658 | |
61626 | 61626 | San Jose | San Jose | 2022-11-09 | Santa Clara | 85 | 263264 | 1026658 | |
62857 | 62857 | San Jose | San Jose | 2022-11-08 | Santa Clara | 85 | 263264 | 1026658 | |
64088 | 64088 | San Jose | San Jose | 2022-11-07 | Santa Clara | 85 | 263264 | 1026658 | |
65319 | 65319 | San Jose | San Jose | 2022-11-06 | Santa Clara | 85 | 263264 | 1026658 | |
66550 | 66550 | San Jose | San Jose | 2022-11-05 | Santa Clara | 85 | 263264 | 1026658 | |
67781 | 67781 | San Jose | San Jose | 2022-11-04 | Santa Clara | 85 | 263264 | 1026658 | |
69012 | 69012 | San Jose | San Jose | 2022-11-03 | Santa Clara | 85 | 263264 | 1026658 | |
70243 | 70243 | San Jose | San Jose | 2022-11-02 | Santa Clara | 85 | 262520 | 1026658 | |
71474 | 71474 | San Jose | San Jose | 2022-11-01 | Santa Clara | 85 | 262520 | 1026658 | |
72737 | 72737 | San Jose | San Jose | 2022-10-31 | Santa Clara | 85 | 262520 | 1026658 | |
74000 | 74000 | San Jose | San Jose | 2022-10-30 | Santa Clara | 85 | 262520 | 1026658 | |
75263 | 75263 | San Jose | San Jose | 2022-10-29 | Santa Clara | 85 | 262520 | 1026658 | |
76526 | 76526 | San Jose | San Jose | 2022-10-28 | Santa Clara | 85 | 262520 | 1026658 | |
77789 | 77789 | San Jose | San Jose | 2022-10-27 | Santa Clara | 85 | 261901 | 1026658 | |
79052 | 79052 | San Jose | San Jose | 2022-10-26 | Santa Clara | 85 | 261901 | 1026658 | |
80315 | 80315 | San Jose | San Jose | 2022-10-25 | Santa Clara | 85 | 261901 | 1026658 | |
81578 | 81578 | San Jose | San Jose | 2022-10-24 | Santa Clara | 85 | 261901 | 1026658 | |
82841 | 82841 | San Jose | San Jose | 2022-10-23 | Santa Clara | 85 | 261901 | 1026658 | |
84104 | 84104 | San Jose | San Jose | 2022-10-22 | Santa Clara | 85 | 261901 | 1026658 | |
85367 | 85367 | San Jose | San Jose | 2022-10-21 | Santa Clara | 85 | 261901 | 1026658 | |
86630 | 86630 | San Jose | San Jose | 2022-10-20 | Santa Clara | 85 | 261901 | 1026658 | |
87893 | 87893 | San Jose | San Jose | 2022-10-19 | Santa Clara | 85 | 261292 | 1026658 | |
89156 | 89156 | San Jose | San Jose | 2022-10-18 | Santa Clara | 85 | 261292 | 1026658 | |
90419 | 90419 | San Jose | San Jose | 2022-10-17 | Santa Clara | 85 | 261292 | 1026658 | |
91682 | 91682 | San Jose | San Jose | 2022-10-16 | Santa Clara | 85 | 261292 | 1026658 | |
92945 | 92945 | San Jose | San Jose | 2022-10-15 | Santa Clara | 85 | 261292 | 1026658 | |
94208 | 94208 | San Jose | San Jose | 2022-10-14 | Santa Clara | 85 | 261292 | 1026658 | |
95471 | 95471 | San Jose | San Jose | 2022-10-13 | Santa Clara | 85 | 261292 | 1026658 | |
96734 | 96734 | San Jose | San Jose | 2022-10-12 | Santa Clara | 85 | 260625 | 1026658 | |
97997 | 97997 | San Jose | San Jose | 2022-10-11 | Santa Clara | 85 | 260625 | 1026658 | |
99260 | 99260 | San Jose | San Jose | 2022-10-10 | Santa Clara | 85 | 260625 | 1026658 | |
100523 | 100523 | San Jose | San Jose | 2022-10-09 | Santa Clara | 85 | 260625 | 1026658 | |
101786 | 101786 | San Jose | San Jose | 2022-10-08 | Santa Clara | 85 | 260625 | 1026658 | |
103049 | 103049 | San Jose | San Jose | 2022-10-07 | Santa Clara | 85 | 260625 | 1026658 | |
104312 | 104312 | San Jose | San Jose | 2022-10-06 | Santa Clara | 85 | 260625 | 1026658 | |
105575 | 105575 | San Jose | San Jose | 2022-10-05 | Santa Clara | 85 | 259900 | 1026658 | |
106838 | 106838 | San Jose | San Jose | 2022-10-04 | Santa Clara | 85 | 259900 | 1026658 | |
108101 | 108101 | San Jose | San Jose | 2022-10-03 | Santa Clara | 85 | 259900 | 1026658 | |
109364 | 109364 | San Jose | San Jose | 2022-10-02 | Santa Clara | 85 | 259900 | 1026658 | |
110627 | 110627 | San Jose | San Jose | 2022-10-01 | Santa Clara | 85 | 259900 | 1026658 | |
111890 | 111890 | San Jose | San Jose | 2022-09-30 | Santa Clara | 85 | 259900 | 1026658 | |
113153 | 113153 | San Jose | San Jose | 2022-09-29 | Santa Clara | 85 | 259900 | 1026658 | |
114416 | 114416 | San Jose | San Jose | 2022-09-28 | Santa Clara | 85 | 259145 | 1026658 | |
115679 | 115679 | San Jose | San Jose | 2022-09-27 | Santa Clara | 85 | 259145 | 1026658 | |
116942 | 116942 | San Jose | San Jose | 2022-09-26 | Santa Clara | 85 | 259145 | 1026658 | |
118205 | 118205 | San Jose | San Jose | 2022-09-25 | Santa Clara | 85 | 259145 | 1026658 | |
119468 | 119468 | San Jose | San Jose | 2022-09-24 | Santa Clara | 85 | 259145 | 1026658 | |
120731 | 120731 | San Jose | San Jose | 2022-09-23 | Santa Clara | 85 | 259145 | 1026658 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "latimes-place-totals" ( [id] TEXT, [name] TEXT, [date] TEXT, [county] TEXT, [fips] INTEGER, [confirmed_cases] INTEGER, [note] TEXT, [population] INTEGER );