latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
9,036 rows where fips = 9 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
42114 | 42114 | 95221, 95222 | 95221, 95222 | 2022-11-24 | Calaveras | 9 | 140 | 5029 | |
42115 | 42115 | 95223 | 95223 | 2022-11-24 | Calaveras | 9 | 51 | 2666 | |
42116 | 42116 | 95225 | 95225 | 2022-11-24 | Calaveras | 9 | 17 | 378 | |
42117 | 42117 | 95226, 95252 | 95226, 95252 | 2022-11-24 | Calaveras | 9 | 435 | 16262 | |
42118 | 42118 | 95228 | 95228 | 2022-11-24 | Calaveras | 9 | 119 | 4541 | |
42119 | 42119 | 95232, 95245 | 95232, 95245 | 2022-11-24 | Calaveras | 9 | 34 | 161 | |
42120 | 42120 | 95233, 95224, 95247, 95251, 95229 | 95233, 95224, 95247, 95251, 95229 | 2022-11-24 | Calaveras | 9 | 135 | 5364 | |
42121 | 42121 | 95246, 95250 | 95246, 95250 | 2022-11-24 | Calaveras | 9 | 36 | 1159 | |
42122 | 42122 | 95249 | 95249 | 2022-11-24 | Calaveras | 9 | 140 | 5444 | |
42123 | 42123 | 95254 | 95254 | 2022-11-24 | Calaveras | 9 | 26 | 1035 | |
42124 | 42124 | 95255, 95257, 95248 | 95255, 95257, 95248 | 2022-11-24 | Calaveras | 9 | 35 | 1802 | |
42125 | 42125 | Other | Other | 2022-11-24 | Calaveras | 9 | 43 | ||
43345 | 43345 | 95221, 95222 | 95221, 95222 | 2022-11-23 | Calaveras | 9 | 140 | 5029 | |
43346 | 43346 | 95223 | 95223 | 2022-11-23 | Calaveras | 9 | 51 | 2666 | |
43347 | 43347 | 95225 | 95225 | 2022-11-23 | Calaveras | 9 | 17 | 378 | |
43348 | 43348 | 95226, 95252 | 95226, 95252 | 2022-11-23 | Calaveras | 9 | 435 | 16262 | |
43349 | 43349 | 95228 | 95228 | 2022-11-23 | Calaveras | 9 | 119 | 4541 | |
43350 | 43350 | 95232, 95245 | 95232, 95245 | 2022-11-23 | Calaveras | 9 | 34 | 161 | |
43351 | 43351 | 95233, 95224, 95247, 95251, 95229 | 95233, 95224, 95247, 95251, 95229 | 2022-11-23 | Calaveras | 9 | 135 | 5364 | |
43352 | 43352 | 95246, 95250 | 95246, 95250 | 2022-11-23 | Calaveras | 9 | 36 | 1159 | |
43353 | 43353 | 95249 | 95249 | 2022-11-23 | Calaveras | 9 | 140 | 5444 | |
43354 | 43354 | 95254 | 95254 | 2022-11-23 | Calaveras | 9 | 26 | 1035 | |
43355 | 43355 | 95255, 95257, 95248 | 95255, 95257, 95248 | 2022-11-23 | Calaveras | 9 | 35 | 1802 | |
43356 | 43356 | Other | Other | 2022-11-23 | Calaveras | 9 | 43 | ||
44576 | 44576 | 95221, 95222 | 95221, 95222 | 2022-11-22 | Calaveras | 9 | 140 | 5029 | |
44577 | 44577 | 95223 | 95223 | 2022-11-22 | Calaveras | 9 | 51 | 2666 | |
44578 | 44578 | 95225 | 95225 | 2022-11-22 | Calaveras | 9 | 17 | 378 | |
44579 | 44579 | 95226, 95252 | 95226, 95252 | 2022-11-22 | Calaveras | 9 | 435 | 16262 | |
44580 | 44580 | 95228 | 95228 | 2022-11-22 | Calaveras | 9 | 119 | 4541 | |
44581 | 44581 | 95232, 95245 | 95232, 95245 | 2022-11-22 | Calaveras | 9 | 34 | 161 | |
44582 | 44582 | 95233, 95224, 95247, 95251, 95229 | 95233, 95224, 95247, 95251, 95229 | 2022-11-22 | Calaveras | 9 | 135 | 5364 | |
44583 | 44583 | 95246, 95250 | 95246, 95250 | 2022-11-22 | Calaveras | 9 | 36 | 1159 | |
44584 | 44584 | 95249 | 95249 | 2022-11-22 | Calaveras | 9 | 140 | 5444 | |
44585 | 44585 | 95254 | 95254 | 2022-11-22 | Calaveras | 9 | 26 | 1035 | |
44586 | 44586 | 95255, 95257, 95248 | 95255, 95257, 95248 | 2022-11-22 | Calaveras | 9 | 35 | 1802 | |
44587 | 44587 | Other | Other | 2022-11-22 | Calaveras | 9 | 43 | ||
45807 | 45807 | 95221, 95222 | 95221, 95222 | 2022-11-21 | Calaveras | 9 | 140 | 5029 | |
45808 | 45808 | 95223 | 95223 | 2022-11-21 | Calaveras | 9 | 51 | 2666 | |
45809 | 45809 | 95225 | 95225 | 2022-11-21 | Calaveras | 9 | 17 | 378 | |
45810 | 45810 | 95226, 95252 | 95226, 95252 | 2022-11-21 | Calaveras | 9 | 435 | 16262 | |
45811 | 45811 | 95228 | 95228 | 2022-11-21 | Calaveras | 9 | 119 | 4541 | |
45812 | 45812 | 95232, 95245 | 95232, 95245 | 2022-11-21 | Calaveras | 9 | 34 | 161 | |
45813 | 45813 | 95233, 95224, 95247, 95251, 95229 | 95233, 95224, 95247, 95251, 95229 | 2022-11-21 | Calaveras | 9 | 135 | 5364 | |
45814 | 45814 | 95246, 95250 | 95246, 95250 | 2022-11-21 | Calaveras | 9 | 36 | 1159 | |
45815 | 45815 | 95249 | 95249 | 2022-11-21 | Calaveras | 9 | 140 | 5444 | |
45816 | 45816 | 95254 | 95254 | 2022-11-21 | Calaveras | 9 | 26 | 1035 | |
45817 | 45817 | 95255, 95257, 95248 | 95255, 95257, 95248 | 2022-11-21 | Calaveras | 9 | 35 | 1802 | |
45818 | 45818 | Other | Other | 2022-11-21 | Calaveras | 9 | 43 | ||
47038 | 47038 | 95221, 95222 | 95221, 95222 | 2022-11-20 | Calaveras | 9 | 140 | 5029 | |
47039 | 47039 | 95223 | 95223 | 2022-11-20 | Calaveras | 9 | 51 | 2666 | |
47040 | 47040 | 95225 | 95225 | 2022-11-20 | Calaveras | 9 | 17 | 378 | |
47041 | 47041 | 95226, 95252 | 95226, 95252 | 2022-11-20 | Calaveras | 9 | 435 | 16262 | |
47042 | 47042 | 95228 | 95228 | 2022-11-20 | Calaveras | 9 | 119 | 4541 | |
47043 | 47043 | 95232, 95245 | 95232, 95245 | 2022-11-20 | Calaveras | 9 | 34 | 161 | |
47044 | 47044 | 95233, 95224, 95247, 95251, 95229 | 95233, 95224, 95247, 95251, 95229 | 2022-11-20 | Calaveras | 9 | 135 | 5364 | |
47045 | 47045 | 95246, 95250 | 95246, 95250 | 2022-11-20 | Calaveras | 9 | 36 | 1159 | |
47046 | 47046 | 95249 | 95249 | 2022-11-20 | Calaveras | 9 | 140 | 5444 | |
47047 | 47047 | 95254 | 95254 | 2022-11-20 | Calaveras | 9 | 26 | 1035 | |
47048 | 47048 | 95255, 95257, 95248 | 95255, 95257, 95248 | 2022-11-20 | Calaveras | 9 | 35 | 1802 | |
47049 | 47049 | Other | Other | 2022-11-20 | Calaveras | 9 | 43 | ||
48269 | 48269 | 95221, 95222 | 95221, 95222 | 2022-11-19 | Calaveras | 9 | 140 | 5029 | |
48270 | 48270 | 95223 | 95223 | 2022-11-19 | Calaveras | 9 | 51 | 2666 | |
48271 | 48271 | 95225 | 95225 | 2022-11-19 | Calaveras | 9 | 17 | 378 | |
48272 | 48272 | 95226, 95252 | 95226, 95252 | 2022-11-19 | Calaveras | 9 | 435 | 16262 | |
48273 | 48273 | 95228 | 95228 | 2022-11-19 | Calaveras | 9 | 119 | 4541 | |
48274 | 48274 | 95232, 95245 | 95232, 95245 | 2022-11-19 | Calaveras | 9 | 34 | 161 | |
48275 | 48275 | 95233, 95224, 95247, 95251, 95229 | 95233, 95224, 95247, 95251, 95229 | 2022-11-19 | Calaveras | 9 | 135 | 5364 | |
48276 | 48276 | 95246, 95250 | 95246, 95250 | 2022-11-19 | Calaveras | 9 | 36 | 1159 | |
48277 | 48277 | 95249 | 95249 | 2022-11-19 | Calaveras | 9 | 140 | 5444 | |
48278 | 48278 | 95254 | 95254 | 2022-11-19 | Calaveras | 9 | 26 | 1035 | |
48279 | 48279 | 95255, 95257, 95248 | 95255, 95257, 95248 | 2022-11-19 | Calaveras | 9 | 35 | 1802 | |
48280 | 48280 | Other | Other | 2022-11-19 | Calaveras | 9 | 43 | ||
49500 | 49500 | 95221, 95222 | 95221, 95222 | 2022-11-18 | Calaveras | 9 | 140 | 5029 | |
49501 | 49501 | 95223 | 95223 | 2022-11-18 | Calaveras | 9 | 51 | 2666 | |
49502 | 49502 | 95225 | 95225 | 2022-11-18 | Calaveras | 9 | 17 | 378 | |
49503 | 49503 | 95226, 95252 | 95226, 95252 | 2022-11-18 | Calaveras | 9 | 435 | 16262 | |
49504 | 49504 | 95228 | 95228 | 2022-11-18 | Calaveras | 9 | 119 | 4541 | |
49505 | 49505 | 95232, 95245 | 95232, 95245 | 2022-11-18 | Calaveras | 9 | 34 | 161 | |
49506 | 49506 | 95233, 95224, 95247, 95251, 95229 | 95233, 95224, 95247, 95251, 95229 | 2022-11-18 | Calaveras | 9 | 135 | 5364 | |
49507 | 49507 | 95246, 95250 | 95246, 95250 | 2022-11-18 | Calaveras | 9 | 36 | 1159 | |
49508 | 49508 | 95249 | 95249 | 2022-11-18 | Calaveras | 9 | 140 | 5444 | |
49509 | 49509 | 95254 | 95254 | 2022-11-18 | Calaveras | 9 | 26 | 1035 | |
49510 | 49510 | 95255, 95257, 95248 | 95255, 95257, 95248 | 2022-11-18 | Calaveras | 9 | 35 | 1802 | |
49511 | 49511 | Other | Other | 2022-11-18 | Calaveras | 9 | 43 | ||
50731 | 50731 | 95221, 95222 | 95221, 95222 | 2022-11-17 | Calaveras | 9 | 140 | 5029 | |
50732 | 50732 | 95223 | 95223 | 2022-11-17 | Calaveras | 9 | 51 | 2666 | |
50733 | 50733 | 95225 | 95225 | 2022-11-17 | Calaveras | 9 | 17 | 378 | |
50734 | 50734 | 95226, 95252 | 95226, 95252 | 2022-11-17 | Calaveras | 9 | 435 | 16262 | |
50735 | 50735 | 95228 | 95228 | 2022-11-17 | Calaveras | 9 | 119 | 4541 | |
50736 | 50736 | 95232, 95245 | 95232, 95245 | 2022-11-17 | Calaveras | 9 | 34 | 161 | |
50737 | 50737 | 95233, 95224, 95247, 95251, 95229 | 95233, 95224, 95247, 95251, 95229 | 2022-11-17 | Calaveras | 9 | 135 | 5364 | |
50738 | 50738 | 95246, 95250 | 95246, 95250 | 2022-11-17 | Calaveras | 9 | 36 | 1159 | |
50739 | 50739 | 95249 | 95249 | 2022-11-17 | Calaveras | 9 | 140 | 5444 | |
50740 | 50740 | 95254 | 95254 | 2022-11-17 | Calaveras | 9 | 26 | 1035 | |
50741 | 50741 | 95255, 95257, 95248 | 95255, 95257, 95248 | 2022-11-17 | Calaveras | 9 | 35 | 1802 | |
50742 | 50742 | Other | Other | 2022-11-17 | Calaveras | 9 | 43 | ||
51962 | 51962 | 95221, 95222 | 95221, 95222 | 2022-11-16 | Calaveras | 9 | 140 | 5029 | |
51963 | 51963 | 95223 | 95223 | 2022-11-16 | Calaveras | 9 | 51 | 2666 | |
51964 | 51964 | 95225 | 95225 | 2022-11-16 | Calaveras | 9 | 17 | 378 | |
51965 | 51965 | 95226, 95252 | 95226, 95252 | 2022-11-16 | Calaveras | 9 | 435 | 16262 |
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] TEXT );