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 |
---|---|---|---|---|---|---|---|---|---|
297919 | 297919 | 95228 | 95228 | 2022-05-05 | Calaveras | 9 | 810 | 4541 | |
297920 | 297920 | 95232, 95245 | 95232, 95245 | 2022-05-05 | Calaveras | 9 | 290 | 161 | |
297921 | 297921 | 95233, 95224, 95247, 95251, 95229 | 95233, 95224, 95247, 95251, 95229 | 2022-05-05 | Calaveras | 9 | 863 | 5364 | |
297922 | 297922 | 95246, 95250 | 95246, 95250 | 2022-05-05 | Calaveras | 9 | 158 | 1159 | |
297923 | 297923 | 95249 | 95249 | 2022-05-05 | Calaveras | 9 | 750 | 5444 | |
297924 | 297924 | 95254 | 95254 | 2022-05-05 | Calaveras | 9 | 85 | 1035 | |
297925 | 297925 | 95255, 95257, 95248 | 95255, 95257, 95248 | 2022-05-05 | Calaveras | 9 | 323 | 1802 | |
297926 | 297926 | Other | Other | 2022-05-05 | Calaveras | 9 | 54 | ||
299188 | 299188 | 95221, 95222 | 95221, 95222 | 2022-05-04 | Calaveras | 9 | 1028 | 5029 | |
299189 | 299189 | 95223 | 95223 | 2022-05-04 | Calaveras | 9 | 384 | 2666 | |
299190 | 299190 | 95225 | 95225 | 2022-05-04 | Calaveras | 9 | 102 | 378 | |
299191 | 299191 | 95226, 95252 | 95226, 95252 | 2022-05-04 | Calaveras | 9 | 2488 | 16262 | |
299192 | 299192 | 95228 | 95228 | 2022-05-04 | Calaveras | 9 | 810 | 4541 | |
299193 | 299193 | 95232, 95245 | 95232, 95245 | 2022-05-04 | Calaveras | 9 | 290 | 161 | |
299194 | 299194 | 95233, 95224, 95247, 95251, 95229 | 95233, 95224, 95247, 95251, 95229 | 2022-05-04 | Calaveras | 9 | 863 | 5364 | |
299195 | 299195 | 95246, 95250 | 95246, 95250 | 2022-05-04 | Calaveras | 9 | 158 | 1159 | |
299196 | 299196 | 95249 | 95249 | 2022-05-04 | Calaveras | 9 | 750 | 5444 | |
299197 | 299197 | 95254 | 95254 | 2022-05-04 | Calaveras | 9 | 85 | 1035 | |
299198 | 299198 | 95255, 95257, 95248 | 95255, 95257, 95248 | 2022-05-04 | Calaveras | 9 | 323 | 1802 | |
299199 | 299199 | Other | Other | 2022-05-04 | Calaveras | 9 | 54 | ||
300461 | 300461 | 95221, 95222 | 95221, 95222 | 2022-05-03 | Calaveras | 9 | 1028 | 5029 | |
300462 | 300462 | 95223 | 95223 | 2022-05-03 | Calaveras | 9 | 384 | 2666 | |
300463 | 300463 | 95225 | 95225 | 2022-05-03 | Calaveras | 9 | 102 | 378 | |
300464 | 300464 | 95226, 95252 | 95226, 95252 | 2022-05-03 | Calaveras | 9 | 2488 | 16262 | |
300465 | 300465 | 95228 | 95228 | 2022-05-03 | Calaveras | 9 | 810 | 4541 | |
300466 | 300466 | 95232, 95245 | 95232, 95245 | 2022-05-03 | Calaveras | 9 | 290 | 161 | |
300467 | 300467 | 95233, 95224, 95247, 95251, 95229 | 95233, 95224, 95247, 95251, 95229 | 2022-05-03 | Calaveras | 9 | 863 | 5364 | |
300468 | 300468 | 95246, 95250 | 95246, 95250 | 2022-05-03 | Calaveras | 9 | 158 | 1159 | |
300469 | 300469 | 95249 | 95249 | 2022-05-03 | Calaveras | 9 | 750 | 5444 | |
300470 | 300470 | 95254 | 95254 | 2022-05-03 | Calaveras | 9 | 85 | 1035 | |
300471 | 300471 | 95255, 95257, 95248 | 95255, 95257, 95248 | 2022-05-03 | Calaveras | 9 | 323 | 1802 | |
300472 | 300472 | Other | Other | 2022-05-03 | Calaveras | 9 | 54 | ||
301730 | 301730 | 95221, 95222 | 95221, 95222 | 2022-05-02 | Calaveras | 9 | 1026 | 5029 | |
301731 | 301731 | 95223 | 95223 | 2022-05-02 | Calaveras | 9 | 384 | 2666 | |
301732 | 301732 | 95225 | 95225 | 2022-05-02 | Calaveras | 9 | 102 | 378 | |
301733 | 301733 | 95226, 95252 | 95226, 95252 | 2022-05-02 | Calaveras | 9 | 2484 | 16262 | |
301734 | 301734 | 95228 | 95228 | 2022-05-02 | Calaveras | 9 | 806 | 4541 | |
301735 | 301735 | 95232, 95245 | 95232, 95245 | 2022-05-02 | Calaveras | 9 | 290 | 161 | |
301736 | 301736 | 95233, 95224, 95247, 95251, 95229 | 95233, 95224, 95247, 95251, 95229 | 2022-05-02 | Calaveras | 9 | 858 | 5364 | |
301737 | 301737 | 95246, 95250 | 95246, 95250 | 2022-05-02 | Calaveras | 9 | 157 | 1159 | |
301738 | 301738 | 95249 | 95249 | 2022-05-02 | Calaveras | 9 | 744 | 5444 | |
301739 | 301739 | 95254 | 95254 | 2022-05-02 | Calaveras | 9 | 84 | 1035 | |
301740 | 301740 | 95255, 95257, 95248 | 95255, 95257, 95248 | 2022-05-02 | Calaveras | 9 | 319 | 1802 | |
301741 | 301741 | Other | Other | 2022-05-02 | Calaveras | 9 | 53 | ||
302999 | 302999 | 95221, 95222 | 95221, 95222 | 2022-05-01 | Calaveras | 9 | 1026 | 5029 | |
303000 | 303000 | 95223 | 95223 | 2022-05-01 | Calaveras | 9 | 384 | 2666 | |
303001 | 303001 | 95225 | 95225 | 2022-05-01 | Calaveras | 9 | 102 | 378 | |
303002 | 303002 | 95226, 95252 | 95226, 95252 | 2022-05-01 | Calaveras | 9 | 2484 | 16262 | |
303003 | 303003 | 95228 | 95228 | 2022-05-01 | Calaveras | 9 | 806 | 4541 | |
303004 | 303004 | 95232, 95245 | 95232, 95245 | 2022-05-01 | Calaveras | 9 | 290 | 161 | |
303005 | 303005 | 95233, 95224, 95247, 95251, 95229 | 95233, 95224, 95247, 95251, 95229 | 2022-05-01 | Calaveras | 9 | 858 | 5364 | |
303006 | 303006 | 95246, 95250 | 95246, 95250 | 2022-05-01 | Calaveras | 9 | 157 | 1159 | |
303007 | 303007 | 95249 | 95249 | 2022-05-01 | Calaveras | 9 | 744 | 5444 | |
303008 | 303008 | 95254 | 95254 | 2022-05-01 | Calaveras | 9 | 84 | 1035 | |
303009 | 303009 | 95255, 95257, 95248 | 95255, 95257, 95248 | 2022-05-01 | Calaveras | 9 | 319 | 1802 | |
303010 | 303010 | Other | Other | 2022-05-01 | Calaveras | 9 | 53 | ||
304268 | 304268 | 95221, 95222 | 95221, 95222 | 2022-04-30 | Calaveras | 9 | 1026 | 5029 | |
304269 | 304269 | 95223 | 95223 | 2022-04-30 | Calaveras | 9 | 384 | 2666 | |
304270 | 304270 | 95225 | 95225 | 2022-04-30 | Calaveras | 9 | 102 | 378 | |
304271 | 304271 | 95226, 95252 | 95226, 95252 | 2022-04-30 | Calaveras | 9 | 2484 | 16262 | |
304272 | 304272 | 95228 | 95228 | 2022-04-30 | Calaveras | 9 | 806 | 4541 | |
304273 | 304273 | 95232, 95245 | 95232, 95245 | 2022-04-30 | Calaveras | 9 | 290 | 161 | |
304274 | 304274 | 95233, 95224, 95247, 95251, 95229 | 95233, 95224, 95247, 95251, 95229 | 2022-04-30 | Calaveras | 9 | 858 | 5364 | |
304275 | 304275 | 95246, 95250 | 95246, 95250 | 2022-04-30 | Calaveras | 9 | 157 | 1159 | |
304276 | 304276 | 95249 | 95249 | 2022-04-30 | Calaveras | 9 | 744 | 5444 | |
304277 | 304277 | 95254 | 95254 | 2022-04-30 | Calaveras | 9 | 84 | 1035 | |
304278 | 304278 | 95255, 95257, 95248 | 95255, 95257, 95248 | 2022-04-30 | Calaveras | 9 | 319 | 1802 | |
304279 | 304279 | Other | Other | 2022-04-30 | Calaveras | 9 | 53 | ||
305537 | 305537 | 95221, 95222 | 95221, 95222 | 2022-04-29 | Calaveras | 9 | 1026 | 5029 | |
305538 | 305538 | 95223 | 95223 | 2022-04-29 | Calaveras | 9 | 384 | 2666 | |
305539 | 305539 | 95225 | 95225 | 2022-04-29 | Calaveras | 9 | 102 | 378 | |
305540 | 305540 | 95226, 95252 | 95226, 95252 | 2022-04-29 | Calaveras | 9 | 2484 | 16262 | |
305541 | 305541 | 95228 | 95228 | 2022-04-29 | Calaveras | 9 | 806 | 4541 | |
305542 | 305542 | 95232, 95245 | 95232, 95245 | 2022-04-29 | Calaveras | 9 | 290 | 161 | |
305543 | 305543 | 95233, 95224, 95247, 95251, 95229 | 95233, 95224, 95247, 95251, 95229 | 2022-04-29 | Calaveras | 9 | 858 | 5364 | |
305544 | 305544 | 95246, 95250 | 95246, 95250 | 2022-04-29 | Calaveras | 9 | 157 | 1159 | |
305545 | 305545 | 95249 | 95249 | 2022-04-29 | Calaveras | 9 | 744 | 5444 | |
305546 | 305546 | 95254 | 95254 | 2022-04-29 | Calaveras | 9 | 84 | 1035 | |
305547 | 305547 | 95255, 95257, 95248 | 95255, 95257, 95248 | 2022-04-29 | Calaveras | 9 | 319 | 1802 | |
305548 | 305548 | Other | Other | 2022-04-29 | Calaveras | 9 | 53 | ||
306806 | 306806 | 95221, 95222 | 95221, 95222 | 2022-04-28 | Calaveras | 9 | 1026 | 5029 | |
306807 | 306807 | 95223 | 95223 | 2022-04-28 | Calaveras | 9 | 384 | 2666 | |
306808 | 306808 | 95225 | 95225 | 2022-04-28 | Calaveras | 9 | 102 | 378 | |
306809 | 306809 | 95226, 95252 | 95226, 95252 | 2022-04-28 | Calaveras | 9 | 2484 | 16262 | |
306810 | 306810 | 95228 | 95228 | 2022-04-28 | Calaveras | 9 | 806 | 4541 | |
306811 | 306811 | 95232, 95245 | 95232, 95245 | 2022-04-28 | Calaveras | 9 | 290 | 161 | |
306812 | 306812 | 95233, 95224, 95247, 95251, 95229 | 95233, 95224, 95247, 95251, 95229 | 2022-04-28 | Calaveras | 9 | 858 | 5364 | |
306813 | 306813 | 95246, 95250 | 95246, 95250 | 2022-04-28 | Calaveras | 9 | 157 | 1159 | |
306814 | 306814 | 95249 | 95249 | 2022-04-28 | Calaveras | 9 | 744 | 5444 | |
306815 | 306815 | 95254 | 95254 | 2022-04-28 | Calaveras | 9 | 84 | 1035 | |
306816 | 306816 | 95255, 95257, 95248 | 95255, 95257, 95248 | 2022-04-28 | Calaveras | 9 | 319 | 1802 | |
306817 | 306817 | Other | Other | 2022-04-28 | Calaveras | 9 | 53 | ||
308075 | 308075 | 95221, 95222 | 95221, 95222 | 2022-04-27 | Calaveras | 9 | 1026 | 5029 | |
308076 | 308076 | 95223 | 95223 | 2022-04-27 | Calaveras | 9 | 384 | 2666 | |
308077 | 308077 | 95225 | 95225 | 2022-04-27 | Calaveras | 9 | 102 | 378 | |
308078 | 308078 | 95226, 95252 | 95226, 95252 | 2022-04-27 | Calaveras | 9 | 2484 | 16262 | |
308079 | 308079 | 95228 | 95228 | 2022-04-27 | Calaveras | 9 | 806 | 4541 | |
308080 | 308080 | 95232, 95245 | 95232, 95245 | 2022-04-27 | Calaveras | 9 | 290 | 161 | |
308081 | 308081 | 95233, 95224, 95247, 95251, 95229 | 95233, 95224, 95247, 95251, 95229 | 2022-04-27 | Calaveras | 9 | 858 | 5364 | |
308082 | 308082 | 95246, 95250 | 95246, 95250 | 2022-04-27 | Calaveras | 9 | 157 | 1159 |
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 );