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 |
---|---|---|---|---|---|---|---|---|---|
120915 | 120915 | 95221, 95222 | 95221, 95222 | 2022-09-22 | Calaveras | 9 | 140 | 5029 | |
120916 | 120916 | 95223 | 95223 | 2022-09-22 | Calaveras | 9 | 51 | 2666 | |
120917 | 120917 | 95225 | 95225 | 2022-09-22 | Calaveras | 9 | 17 | 378 | |
120918 | 120918 | 95226, 95252 | 95226, 95252 | 2022-09-22 | Calaveras | 9 | 435 | 16262 | |
120919 | 120919 | 95228 | 95228 | 2022-09-22 | Calaveras | 9 | 119 | 4541 | |
120920 | 120920 | 95232, 95245 | 95232, 95245 | 2022-09-22 | Calaveras | 9 | 34 | 161 | |
120921 | 120921 | 95233, 95224, 95247, 95251, 95229 | 95233, 95224, 95247, 95251, 95229 | 2022-09-22 | Calaveras | 9 | 135 | 5364 | |
120922 | 120922 | 95246, 95250 | 95246, 95250 | 2022-09-22 | Calaveras | 9 | 36 | 1159 | |
120923 | 120923 | 95249 | 95249 | 2022-09-22 | Calaveras | 9 | 140 | 5444 | |
120924 | 120924 | 95254 | 95254 | 2022-09-22 | Calaveras | 9 | 26 | 1035 | |
120925 | 120925 | 95255, 95257, 95248 | 95255, 95257, 95248 | 2022-09-22 | Calaveras | 9 | 35 | 1802 | |
120926 | 120926 | Other | Other | 2022-09-22 | Calaveras | 9 | 43 | ||
122178 | 122178 | 95221, 95222 | 95221, 95222 | 2022-09-21 | Calaveras | 9 | 140 | 5029 | |
122179 | 122179 | 95223 | 95223 | 2022-09-21 | Calaveras | 9 | 51 | 2666 | |
122180 | 122180 | 95225 | 95225 | 2022-09-21 | Calaveras | 9 | 17 | 378 | |
122181 | 122181 | 95226, 95252 | 95226, 95252 | 2022-09-21 | Calaveras | 9 | 435 | 16262 | |
122182 | 122182 | 95228 | 95228 | 2022-09-21 | Calaveras | 9 | 119 | 4541 | |
122183 | 122183 | 95232, 95245 | 95232, 95245 | 2022-09-21 | Calaveras | 9 | 34 | 161 | |
122184 | 122184 | 95233, 95224, 95247, 95251, 95229 | 95233, 95224, 95247, 95251, 95229 | 2022-09-21 | Calaveras | 9 | 135 | 5364 | |
122185 | 122185 | 95246, 95250 | 95246, 95250 | 2022-09-21 | Calaveras | 9 | 36 | 1159 | |
122186 | 122186 | 95249 | 95249 | 2022-09-21 | Calaveras | 9 | 140 | 5444 | |
122187 | 122187 | 95254 | 95254 | 2022-09-21 | Calaveras | 9 | 26 | 1035 | |
122188 | 122188 | 95255, 95257, 95248 | 95255, 95257, 95248 | 2022-09-21 | Calaveras | 9 | 35 | 1802 | |
122189 | 122189 | Other | Other | 2022-09-21 | Calaveras | 9 | 43 | ||
123441 | 123441 | 95221, 95222 | 95221, 95222 | 2022-09-20 | Calaveras | 9 | 140 | 5029 | |
123442 | 123442 | 95223 | 95223 | 2022-09-20 | Calaveras | 9 | 51 | 2666 | |
123443 | 123443 | 95225 | 95225 | 2022-09-20 | Calaveras | 9 | 17 | 378 | |
123444 | 123444 | 95226, 95252 | 95226, 95252 | 2022-09-20 | Calaveras | 9 | 435 | 16262 | |
123445 | 123445 | 95228 | 95228 | 2022-09-20 | Calaveras | 9 | 119 | 4541 | |
123446 | 123446 | 95232, 95245 | 95232, 95245 | 2022-09-20 | Calaveras | 9 | 34 | 161 | |
123447 | 123447 | 95233, 95224, 95247, 95251, 95229 | 95233, 95224, 95247, 95251, 95229 | 2022-09-20 | Calaveras | 9 | 135 | 5364 | |
123448 | 123448 | 95246, 95250 | 95246, 95250 | 2022-09-20 | Calaveras | 9 | 36 | 1159 | |
123449 | 123449 | 95249 | 95249 | 2022-09-20 | Calaveras | 9 | 140 | 5444 | |
123450 | 123450 | 95254 | 95254 | 2022-09-20 | Calaveras | 9 | 26 | 1035 | |
123451 | 123451 | 95255, 95257, 95248 | 95255, 95257, 95248 | 2022-09-20 | Calaveras | 9 | 35 | 1802 | |
123452 | 123452 | Other | Other | 2022-09-20 | Calaveras | 9 | 43 | ||
124704 | 124704 | 95221, 95222 | 95221, 95222 | 2022-09-19 | Calaveras | 9 | 140 | 5029 | |
124705 | 124705 | 95223 | 95223 | 2022-09-19 | Calaveras | 9 | 51 | 2666 | |
124706 | 124706 | 95225 | 95225 | 2022-09-19 | Calaveras | 9 | 17 | 378 | |
124707 | 124707 | 95226, 95252 | 95226, 95252 | 2022-09-19 | Calaveras | 9 | 435 | 16262 | |
124708 | 124708 | 95228 | 95228 | 2022-09-19 | Calaveras | 9 | 119 | 4541 | |
124709 | 124709 | 95232, 95245 | 95232, 95245 | 2022-09-19 | Calaveras | 9 | 34 | 161 | |
124710 | 124710 | 95233, 95224, 95247, 95251, 95229 | 95233, 95224, 95247, 95251, 95229 | 2022-09-19 | Calaveras | 9 | 135 | 5364 | |
124711 | 124711 | 95246, 95250 | 95246, 95250 | 2022-09-19 | Calaveras | 9 | 36 | 1159 | |
124712 | 124712 | 95249 | 95249 | 2022-09-19 | Calaveras | 9 | 140 | 5444 | |
124713 | 124713 | 95254 | 95254 | 2022-09-19 | Calaveras | 9 | 26 | 1035 | |
124714 | 124714 | 95255, 95257, 95248 | 95255, 95257, 95248 | 2022-09-19 | Calaveras | 9 | 35 | 1802 | |
124715 | 124715 | Other | Other | 2022-09-19 | Calaveras | 9 | 43 | ||
125967 | 125967 | 95221, 95222 | 95221, 95222 | 2022-09-18 | Calaveras | 9 | 1161 | 5029 | |
125968 | 125968 | 95223 | 95223 | 2022-09-18 | Calaveras | 9 | 428 | 2666 | |
125969 | 125969 | 95225 | 95225 | 2022-09-18 | Calaveras | 9 | 123 | 378 | |
125970 | 125970 | 95226, 95252 | 95226, 95252 | 2022-09-18 | Calaveras | 9 | 2848 | 16262 | |
125971 | 125971 | 95228 | 95228 | 2022-09-18 | Calaveras | 9 | 948 | 4541 | |
125972 | 125972 | 95232, 95245 | 95232, 95245 | 2022-09-18 | Calaveras | 9 | 348 | 161 | |
125973 | 125973 | 95233, 95224, 95247, 95251, 95229 | 95233, 95224, 95247, 95251, 95229 | 2022-09-18 | Calaveras | 9 | 987 | 5364 | |
125974 | 125974 | 95246, 95250 | 95246, 95250 | 2022-09-18 | Calaveras | 9 | 196 | 1159 | |
125975 | 125975 | 95249 | 95249 | 2022-09-18 | Calaveras | 9 | 894 | 5444 | |
125976 | 125976 | 95254 | 95254 | 2022-09-18 | Calaveras | 9 | 98 | 1035 | |
125977 | 125977 | 95255, 95257, 95248 | 95255, 95257, 95248 | 2022-09-18 | Calaveras | 9 | 386 | 1802 | |
125978 | 125978 | Other | Other | 2022-09-18 | Calaveras | 9 | 73 | ||
127230 | 127230 | 95221, 95222 | 95221, 95222 | 2022-09-17 | Calaveras | 9 | 1161 | 5029 | |
127231 | 127231 | 95223 | 95223 | 2022-09-17 | Calaveras | 9 | 428 | 2666 | |
127232 | 127232 | 95225 | 95225 | 2022-09-17 | Calaveras | 9 | 123 | 378 | |
127233 | 127233 | 95226, 95252 | 95226, 95252 | 2022-09-17 | Calaveras | 9 | 2848 | 16262 | |
127234 | 127234 | 95228 | 95228 | 2022-09-17 | Calaveras | 9 | 948 | 4541 | |
127235 | 127235 | 95232, 95245 | 95232, 95245 | 2022-09-17 | Calaveras | 9 | 348 | 161 | |
127236 | 127236 | 95233, 95224, 95247, 95251, 95229 | 95233, 95224, 95247, 95251, 95229 | 2022-09-17 | Calaveras | 9 | 987 | 5364 | |
127237 | 127237 | 95246, 95250 | 95246, 95250 | 2022-09-17 | Calaveras | 9 | 196 | 1159 | |
127238 | 127238 | 95249 | 95249 | 2022-09-17 | Calaveras | 9 | 894 | 5444 | |
127239 | 127239 | 95254 | 95254 | 2022-09-17 | Calaveras | 9 | 98 | 1035 | |
127240 | 127240 | 95255, 95257, 95248 | 95255, 95257, 95248 | 2022-09-17 | Calaveras | 9 | 386 | 1802 | |
127241 | 127241 | Other | Other | 2022-09-17 | Calaveras | 9 | 73 | ||
128493 | 128493 | 95221, 95222 | 95221, 95222 | 2022-09-16 | Calaveras | 9 | 1161 | 5029 | |
128494 | 128494 | 95223 | 95223 | 2022-09-16 | Calaveras | 9 | 428 | 2666 | |
128495 | 128495 | 95225 | 95225 | 2022-09-16 | Calaveras | 9 | 123 | 378 | |
128496 | 128496 | 95226, 95252 | 95226, 95252 | 2022-09-16 | Calaveras | 9 | 2848 | 16262 | |
128497 | 128497 | 95228 | 95228 | 2022-09-16 | Calaveras | 9 | 948 | 4541 | |
128498 | 128498 | 95232, 95245 | 95232, 95245 | 2022-09-16 | Calaveras | 9 | 348 | 161 | |
128499 | 128499 | 95233, 95224, 95247, 95251, 95229 | 95233, 95224, 95247, 95251, 95229 | 2022-09-16 | Calaveras | 9 | 987 | 5364 | |
128500 | 128500 | 95246, 95250 | 95246, 95250 | 2022-09-16 | Calaveras | 9 | 196 | 1159 | |
128501 | 128501 | 95249 | 95249 | 2022-09-16 | Calaveras | 9 | 894 | 5444 | |
128502 | 128502 | 95254 | 95254 | 2022-09-16 | Calaveras | 9 | 98 | 1035 | |
128503 | 128503 | 95255, 95257, 95248 | 95255, 95257, 95248 | 2022-09-16 | Calaveras | 9 | 386 | 1802 | |
128504 | 128504 | Other | Other | 2022-09-16 | Calaveras | 9 | 73 | ||
129756 | 129756 | 95221, 95222 | 95221, 95222 | 2022-09-15 | Calaveras | 9 | 1161 | 5029 | |
129757 | 129757 | 95223 | 95223 | 2022-09-15 | Calaveras | 9 | 428 | 2666 | |
129758 | 129758 | 95225 | 95225 | 2022-09-15 | Calaveras | 9 | 123 | 378 | |
129759 | 129759 | 95226, 95252 | 95226, 95252 | 2022-09-15 | Calaveras | 9 | 2848 | 16262 | |
129760 | 129760 | 95228 | 95228 | 2022-09-15 | Calaveras | 9 | 948 | 4541 | |
129761 | 129761 | 95232, 95245 | 95232, 95245 | 2022-09-15 | Calaveras | 9 | 348 | 161 | |
129762 | 129762 | 95233, 95224, 95247, 95251, 95229 | 95233, 95224, 95247, 95251, 95229 | 2022-09-15 | Calaveras | 9 | 987 | 5364 | |
129763 | 129763 | 95246, 95250 | 95246, 95250 | 2022-09-15 | Calaveras | 9 | 196 | 1159 | |
129764 | 129764 | 95249 | 95249 | 2022-09-15 | Calaveras | 9 | 894 | 5444 | |
129765 | 129765 | 95254 | 95254 | 2022-09-15 | Calaveras | 9 | 98 | 1035 | |
129766 | 129766 | 95255, 95257, 95248 | 95255, 95257, 95248 | 2022-09-15 | Calaveras | 9 | 386 | 1802 | |
129767 | 129767 | Other | Other | 2022-09-15 | Calaveras | 9 | 73 | ||
131019 | 131019 | 95221, 95222 | 95221, 95222 | 2022-09-14 | Calaveras | 9 | 1161 | 5029 | |
131020 | 131020 | 95223 | 95223 | 2022-09-14 | Calaveras | 9 | 428 | 2666 | |
131021 | 131021 | 95225 | 95225 | 2022-09-14 | Calaveras | 9 | 123 | 378 | |
131022 | 131022 | 95226, 95252 | 95226, 95252 | 2022-09-14 | Calaveras | 9 | 2848 | 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 );