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 |
---|---|---|---|---|---|---|---|---|---|
287731 | 287731 | 95221, 95222 | 95221, 95222 | 2022-05-13 | Calaveras | 9 | 1031 | 5029 | |
287732 | 287732 | 95223 | 95223 | 2022-05-13 | Calaveras | 9 | 387 | 2666 | |
287733 | 287733 | 95225 | 95225 | 2022-05-13 | Calaveras | 9 | 102 | 378 | |
287734 | 287734 | 95226, 95252 | 95226, 95252 | 2022-05-13 | Calaveras | 9 | 2495 | 16262 | |
287735 | 287735 | 95228 | 95228 | 2022-05-13 | Calaveras | 9 | 812 | 4541 | |
287736 | 287736 | 95232, 95245 | 95232, 95245 | 2022-05-13 | Calaveras | 9 | 290 | 161 | |
287737 | 287737 | 95233, 95224, 95247, 95251, 95229 | 95233, 95224, 95247, 95251, 95229 | 2022-05-13 | Calaveras | 9 | 868 | 5364 | |
287738 | 287738 | 95246, 95250 | 95246, 95250 | 2022-05-13 | Calaveras | 9 | 158 | 1159 | |
287739 | 287739 | 95249 | 95249 | 2022-05-13 | Calaveras | 9 | 753 | 5444 | |
287740 | 287740 | 95254 | 95254 | 2022-05-13 | Calaveras | 9 | 87 | 1035 | |
287741 | 287741 | 95255, 95257, 95248 | 95255, 95257, 95248 | 2022-05-13 | Calaveras | 9 | 324 | 1802 | |
287742 | 287742 | Other | Other | 2022-05-13 | Calaveras | 9 | 54 | ||
289004 | 289004 | 95221, 95222 | 95221, 95222 | 2022-05-12 | Calaveras | 9 | 1031 | 5029 | |
289005 | 289005 | 95223 | 95223 | 2022-05-12 | Calaveras | 9 | 387 | 2666 | |
289006 | 289006 | 95225 | 95225 | 2022-05-12 | Calaveras | 9 | 102 | 378 | |
289007 | 289007 | 95226, 95252 | 95226, 95252 | 2022-05-12 | Calaveras | 9 | 2495 | 16262 | |
289008 | 289008 | 95228 | 95228 | 2022-05-12 | Calaveras | 9 | 812 | 4541 | |
289009 | 289009 | 95232, 95245 | 95232, 95245 | 2022-05-12 | Calaveras | 9 | 290 | 161 | |
289010 | 289010 | 95233, 95224, 95247, 95251, 95229 | 95233, 95224, 95247, 95251, 95229 | 2022-05-12 | Calaveras | 9 | 868 | 5364 | |
289011 | 289011 | 95246, 95250 | 95246, 95250 | 2022-05-12 | Calaveras | 9 | 158 | 1159 | |
289012 | 289012 | 95249 | 95249 | 2022-05-12 | Calaveras | 9 | 753 | 5444 | |
289013 | 289013 | 95254 | 95254 | 2022-05-12 | Calaveras | 9 | 87 | 1035 | |
289014 | 289014 | 95255, 95257, 95248 | 95255, 95257, 95248 | 2022-05-12 | Calaveras | 9 | 324 | 1802 | |
289015 | 289015 | Other | Other | 2022-05-12 | Calaveras | 9 | 54 | ||
290277 | 290277 | 95221, 95222 | 95221, 95222 | 2022-05-11 | Calaveras | 9 | 1031 | 5029 | |
290278 | 290278 | 95223 | 95223 | 2022-05-11 | Calaveras | 9 | 387 | 2666 | |
290279 | 290279 | 95225 | 95225 | 2022-05-11 | Calaveras | 9 | 102 | 378 | |
290280 | 290280 | 95226, 95252 | 95226, 95252 | 2022-05-11 | Calaveras | 9 | 2495 | 16262 | |
290281 | 290281 | 95228 | 95228 | 2022-05-11 | Calaveras | 9 | 812 | 4541 | |
290282 | 290282 | 95232, 95245 | 95232, 95245 | 2022-05-11 | Calaveras | 9 | 290 | 161 | |
290283 | 290283 | 95233, 95224, 95247, 95251, 95229 | 95233, 95224, 95247, 95251, 95229 | 2022-05-11 | Calaveras | 9 | 868 | 5364 | |
290284 | 290284 | 95246, 95250 | 95246, 95250 | 2022-05-11 | Calaveras | 9 | 158 | 1159 | |
290285 | 290285 | 95249 | 95249 | 2022-05-11 | Calaveras | 9 | 753 | 5444 | |
290286 | 290286 | 95254 | 95254 | 2022-05-11 | Calaveras | 9 | 87 | 1035 | |
290287 | 290287 | 95255, 95257, 95248 | 95255, 95257, 95248 | 2022-05-11 | Calaveras | 9 | 324 | 1802 | |
290288 | 290288 | Other | Other | 2022-05-11 | Calaveras | 9 | 54 | ||
291550 | 291550 | 95221, 95222 | 95221, 95222 | 2022-05-10 | Calaveras | 9 | 1031 | 5029 | |
291551 | 291551 | 95223 | 95223 | 2022-05-10 | Calaveras | 9 | 387 | 2666 | |
291552 | 291552 | 95225 | 95225 | 2022-05-10 | Calaveras | 9 | 102 | 378 | |
291553 | 291553 | 95226, 95252 | 95226, 95252 | 2022-05-10 | Calaveras | 9 | 2495 | 16262 | |
291554 | 291554 | 95228 | 95228 | 2022-05-10 | Calaveras | 9 | 812 | 4541 | |
291555 | 291555 | 95232, 95245 | 95232, 95245 | 2022-05-10 | Calaveras | 9 | 290 | 161 | |
291556 | 291556 | 95233, 95224, 95247, 95251, 95229 | 95233, 95224, 95247, 95251, 95229 | 2022-05-10 | Calaveras | 9 | 868 | 5364 | |
291557 | 291557 | 95246, 95250 | 95246, 95250 | 2022-05-10 | Calaveras | 9 | 158 | 1159 | |
291558 | 291558 | 95249 | 95249 | 2022-05-10 | Calaveras | 9 | 753 | 5444 | |
291559 | 291559 | 95254 | 95254 | 2022-05-10 | Calaveras | 9 | 87 | 1035 | |
291560 | 291560 | 95255, 95257, 95248 | 95255, 95257, 95248 | 2022-05-10 | Calaveras | 9 | 324 | 1802 | |
291561 | 291561 | Other | Other | 2022-05-10 | Calaveras | 9 | 54 | ||
292823 | 292823 | 95221, 95222 | 95221, 95222 | 2022-05-09 | Calaveras | 9 | 1028 | 5029 | |
292824 | 292824 | 95223 | 95223 | 2022-05-09 | Calaveras | 9 | 384 | 2666 | |
292825 | 292825 | 95225 | 95225 | 2022-05-09 | Calaveras | 9 | 102 | 378 | |
292826 | 292826 | 95226, 95252 | 95226, 95252 | 2022-05-09 | Calaveras | 9 | 2488 | 16262 | |
292827 | 292827 | 95228 | 95228 | 2022-05-09 | Calaveras | 9 | 810 | 4541 | |
292828 | 292828 | 95232, 95245 | 95232, 95245 | 2022-05-09 | Calaveras | 9 | 290 | 161 | |
292829 | 292829 | 95233, 95224, 95247, 95251, 95229 | 95233, 95224, 95247, 95251, 95229 | 2022-05-09 | Calaveras | 9 | 863 | 5364 | |
292830 | 292830 | 95246, 95250 | 95246, 95250 | 2022-05-09 | Calaveras | 9 | 158 | 1159 | |
292831 | 292831 | 95249 | 95249 | 2022-05-09 | Calaveras | 9 | 750 | 5444 | |
292832 | 292832 | 95254 | 95254 | 2022-05-09 | Calaveras | 9 | 85 | 1035 | |
292833 | 292833 | 95255, 95257, 95248 | 95255, 95257, 95248 | 2022-05-09 | Calaveras | 9 | 323 | 1802 | |
292834 | 292834 | Other | Other | 2022-05-09 | Calaveras | 9 | 54 | ||
294096 | 294096 | 95221, 95222 | 95221, 95222 | 2022-05-08 | Calaveras | 9 | 1028 | 5029 | |
294097 | 294097 | 95223 | 95223 | 2022-05-08 | Calaveras | 9 | 384 | 2666 | |
294098 | 294098 | 95225 | 95225 | 2022-05-08 | Calaveras | 9 | 102 | 378 | |
294099 | 294099 | 95226, 95252 | 95226, 95252 | 2022-05-08 | Calaveras | 9 | 2488 | 16262 | |
294100 | 294100 | 95228 | 95228 | 2022-05-08 | Calaveras | 9 | 810 | 4541 | |
294101 | 294101 | 95232, 95245 | 95232, 95245 | 2022-05-08 | Calaveras | 9 | 290 | 161 | |
294102 | 294102 | 95233, 95224, 95247, 95251, 95229 | 95233, 95224, 95247, 95251, 95229 | 2022-05-08 | Calaveras | 9 | 863 | 5364 | |
294103 | 294103 | 95246, 95250 | 95246, 95250 | 2022-05-08 | Calaveras | 9 | 158 | 1159 | |
294104 | 294104 | 95249 | 95249 | 2022-05-08 | Calaveras | 9 | 750 | 5444 | |
294105 | 294105 | 95254 | 95254 | 2022-05-08 | Calaveras | 9 | 85 | 1035 | |
294106 | 294106 | 95255, 95257, 95248 | 95255, 95257, 95248 | 2022-05-08 | Calaveras | 9 | 323 | 1802 | |
294107 | 294107 | Other | Other | 2022-05-08 | Calaveras | 9 | 54 | ||
295369 | 295369 | 95221, 95222 | 95221, 95222 | 2022-05-07 | Calaveras | 9 | 1028 | 5029 | |
295370 | 295370 | 95223 | 95223 | 2022-05-07 | Calaveras | 9 | 384 | 2666 | |
295371 | 295371 | 95225 | 95225 | 2022-05-07 | Calaveras | 9 | 102 | 378 | |
295372 | 295372 | 95226, 95252 | 95226, 95252 | 2022-05-07 | Calaveras | 9 | 2488 | 16262 | |
295373 | 295373 | 95228 | 95228 | 2022-05-07 | Calaveras | 9 | 810 | 4541 | |
295374 | 295374 | 95232, 95245 | 95232, 95245 | 2022-05-07 | Calaveras | 9 | 290 | 161 | |
295375 | 295375 | 95233, 95224, 95247, 95251, 95229 | 95233, 95224, 95247, 95251, 95229 | 2022-05-07 | Calaveras | 9 | 863 | 5364 | |
295376 | 295376 | 95246, 95250 | 95246, 95250 | 2022-05-07 | Calaveras | 9 | 158 | 1159 | |
295377 | 295377 | 95249 | 95249 | 2022-05-07 | Calaveras | 9 | 750 | 5444 | |
295378 | 295378 | 95254 | 95254 | 2022-05-07 | Calaveras | 9 | 85 | 1035 | |
295379 | 295379 | 95255, 95257, 95248 | 95255, 95257, 95248 | 2022-05-07 | Calaveras | 9 | 323 | 1802 | |
295380 | 295380 | Other | Other | 2022-05-07 | Calaveras | 9 | 54 | ||
296642 | 296642 | 95221, 95222 | 95221, 95222 | 2022-05-06 | Calaveras | 9 | 1028 | 5029 | |
296643 | 296643 | 95223 | 95223 | 2022-05-06 | Calaveras | 9 | 384 | 2666 | |
296644 | 296644 | 95225 | 95225 | 2022-05-06 | Calaveras | 9 | 102 | 378 | |
296645 | 296645 | 95226, 95252 | 95226, 95252 | 2022-05-06 | Calaveras | 9 | 2488 | 16262 | |
296646 | 296646 | 95228 | 95228 | 2022-05-06 | Calaveras | 9 | 810 | 4541 | |
296647 | 296647 | 95232, 95245 | 95232, 95245 | 2022-05-06 | Calaveras | 9 | 290 | 161 | |
296648 | 296648 | 95233, 95224, 95247, 95251, 95229 | 95233, 95224, 95247, 95251, 95229 | 2022-05-06 | Calaveras | 9 | 863 | 5364 | |
296649 | 296649 | 95246, 95250 | 95246, 95250 | 2022-05-06 | Calaveras | 9 | 158 | 1159 | |
296650 | 296650 | 95249 | 95249 | 2022-05-06 | Calaveras | 9 | 750 | 5444 | |
296651 | 296651 | 95254 | 95254 | 2022-05-06 | Calaveras | 9 | 85 | 1035 | |
296652 | 296652 | 95255, 95257, 95248 | 95255, 95257, 95248 | 2022-05-06 | Calaveras | 9 | 323 | 1802 | |
296653 | 296653 | Other | Other | 2022-05-06 | Calaveras | 9 | 54 | ||
297915 | 297915 | 95221, 95222 | 95221, 95222 | 2022-05-05 | Calaveras | 9 | 1028 | 5029 | |
297916 | 297916 | 95223 | 95223 | 2022-05-05 | Calaveras | 9 | 384 | 2666 | |
297917 | 297917 | 95225 | 95225 | 2022-05-05 | Calaveras | 9 | 102 | 378 | |
297918 | 297918 | 95226, 95252 | 95226, 95252 | 2022-05-05 | Calaveras | 9 | 2488 | 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 );