latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
26,520 rows where county = "San Francisco" and fips = 75 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
558152 | 558152 | 94102 | 94102 | 2021-10-13 | San Francisco | 75 | 2635 | 31067 | |
558153 | 558153 | 94103 | 94103 | 2021-10-13 | San Francisco | 75 | 2650 | 28735 | |
558154 | 558154 | 94105 | 94105 | 2021-10-13 | San Francisco | 75 | 633 | 9155 | |
558155 | 558155 | 94107 | 94107 | 2021-10-13 | San Francisco | 75 | 1682 | 29689 | |
558156 | 558156 | 94108 | 94108 | 2021-10-13 | San Francisco | 75 | 468 | 14550 | |
558157 | 558157 | 94109 | 94109 | 2021-10-13 | San Francisco | 75 | 3050 | 56677 | |
558158 | 558158 | 94110 | 94110 | 2021-10-13 | San Francisco | 75 | 5642 | 94161 | |
558159 | 558159 | 94111 | 94111 | 2021-10-13 | San Francisco | 75 | 166 | 3620 | |
558160 | 558160 | 94112 | 94112 | 2021-10-13 | San Francisco | 75 | 6172 | 85166 | |
558161 | 558161 | 94114 | 94114 | 2021-10-13 | San Francisco | 75 | 1477 | 34754 | |
558162 | 558162 | 94115 | 94115 | 2021-10-13 | San Francisco | 75 | 2018 | 35004 | |
558163 | 558163 | 94116 | 94116 | 2021-10-13 | San Francisco | 75 | 1444 | 47823 | |
558164 | 558164 | 94117 | 94117 | 2021-10-13 | San Francisco | 75 | 1653 | 44239 | |
558165 | 558165 | 94118 | 94118 | 2021-10-13 | San Francisco | 75 | 1405 | 41468 | |
558166 | 558166 | 94121 | 94121 | 2021-10-13 | San Francisco | 75 | 1420 | 43795 | |
558167 | 558167 | 94122 | 94122 | 2021-10-13 | San Francisco | 75 | 1725 | 62131 | |
558168 | 558168 | 94123 | 94123 | 2021-10-13 | San Francisco | 75 | 1353 | 25941 | |
558169 | 558169 | 94124 | 94124 | 2021-10-13 | San Francisco | 75 | 4942 | 35363 | |
558170 | 558170 | 94127 | 94127 | 2021-10-13 | San Francisco | 75 | 707 | 21423 | |
558171 | 558171 | 94129 | 94129 | 2021-10-13 | San Francisco | 75 | 146 | 3994 | |
558172 | 558172 | 94130 | 94130 | 2021-10-13 | San Francisco | 75 | 184 | 3064 | |
558173 | 558173 | 94131 | 94131 | 2021-10-13 | San Francisco | 75 | 1034 | 29902 | |
558174 | 558174 | 94132 | 94132 | 2021-10-13 | San Francisco | 75 | 1224 | 31488 | |
558175 | 558175 | 94133 | 94133 | 2021-10-13 | San Francisco | 75 | 1118 | 26527 | |
558176 | 558176 | 94134 | 94134 | 2021-10-13 | San Francisco | 75 | 3485 | 42471 | |
558177 | 558177 | 94158 | 94158 | 2021-10-13 | San Francisco | 75 | 472 | 7291 | |
559428 | 559428 | 94102 | 94102 | 2021-10-12 | San Francisco | 75 | 2633 | 31067 | |
559429 | 559429 | 94103 | 94103 | 2021-10-12 | San Francisco | 75 | 2648 | 28735 | |
559430 | 559430 | 94105 | 94105 | 2021-10-12 | San Francisco | 75 | 632 | 9155 | |
559431 | 559431 | 94107 | 94107 | 2021-10-12 | San Francisco | 75 | 1680 | 29689 | |
559432 | 559432 | 94108 | 94108 | 2021-10-12 | San Francisco | 75 | 467 | 14550 | |
559433 | 559433 | 94109 | 94109 | 2021-10-12 | San Francisco | 75 | 3047 | 56677 | |
559434 | 559434 | 94110 | 94110 | 2021-10-12 | San Francisco | 75 | 5638 | 94161 | |
559435 | 559435 | 94111 | 94111 | 2021-10-12 | San Francisco | 75 | 165 | 3620 | |
559436 | 559436 | 94112 | 94112 | 2021-10-12 | San Francisco | 75 | 6164 | 85166 | |
559437 | 559437 | 94114 | 94114 | 2021-10-12 | San Francisco | 75 | 1477 | 34754 | |
559438 | 559438 | 94115 | 94115 | 2021-10-12 | San Francisco | 75 | 2017 | 35004 | |
559439 | 559439 | 94116 | 94116 | 2021-10-12 | San Francisco | 75 | 1442 | 47823 | |
559440 | 559440 | 94117 | 94117 | 2021-10-12 | San Francisco | 75 | 1649 | 44239 | |
559441 | 559441 | 94118 | 94118 | 2021-10-12 | San Francisco | 75 | 1401 | 41468 | |
559442 | 559442 | 94121 | 94121 | 2021-10-12 | San Francisco | 75 | 1420 | 43795 | |
559443 | 559443 | 94122 | 94122 | 2021-10-12 | San Francisco | 75 | 1721 | 62131 | |
559444 | 559444 | 94123 | 94123 | 2021-10-12 | San Francisco | 75 | 1348 | 25941 | |
559445 | 559445 | 94124 | 94124 | 2021-10-12 | San Francisco | 75 | 4940 | 35363 | |
559446 | 559446 | 94127 | 94127 | 2021-10-12 | San Francisco | 75 | 706 | 21423 | |
559447 | 559447 | 94129 | 94129 | 2021-10-12 | San Francisco | 75 | 145 | 3994 | |
559448 | 559448 | 94130 | 94130 | 2021-10-12 | San Francisco | 75 | 184 | 3064 | |
559449 | 559449 | 94131 | 94131 | 2021-10-12 | San Francisco | 75 | 1033 | 29902 | |
559450 | 559450 | 94132 | 94132 | 2021-10-12 | San Francisco | 75 | 1223 | 31488 | |
559451 | 559451 | 94133 | 94133 | 2021-10-12 | San Francisco | 75 | 1117 | 26527 | |
559452 | 559452 | 94134 | 94134 | 2021-10-12 | San Francisco | 75 | 3484 | 42471 | |
559453 | 559453 | 94158 | 94158 | 2021-10-12 | San Francisco | 75 | 471 | 7291 | |
560704 | 560704 | 94102 | 94102 | 2021-10-11 | San Francisco | 75 | 2626 | 31067 | |
560705 | 560705 | 94103 | 94103 | 2021-10-11 | San Francisco | 75 | 2643 | 28735 | |
560706 | 560706 | 94105 | 94105 | 2021-10-11 | San Francisco | 75 | 630 | 9155 | |
560707 | 560707 | 94107 | 94107 | 2021-10-11 | San Francisco | 75 | 1676 | 29689 | |
560708 | 560708 | 94108 | 94108 | 2021-10-11 | San Francisco | 75 | 465 | 14550 | |
560709 | 560709 | 94109 | 94109 | 2021-10-11 | San Francisco | 75 | 3042 | 56677 | |
560710 | 560710 | 94110 | 94110 | 2021-10-11 | San Francisco | 75 | 5631 | 94161 | |
560711 | 560711 | 94111 | 94111 | 2021-10-11 | San Francisco | 75 | 164 | 3620 | |
560712 | 560712 | 94112 | 94112 | 2021-10-11 | San Francisco | 75 | 6149 | 85166 | |
560713 | 560713 | 94114 | 94114 | 2021-10-11 | San Francisco | 75 | 1466 | 34754 | |
560714 | 560714 | 94115 | 94115 | 2021-10-11 | San Francisco | 75 | 2012 | 35004 | |
560715 | 560715 | 94116 | 94116 | 2021-10-11 | San Francisco | 75 | 1438 | 47823 | |
560716 | 560716 | 94117 | 94117 | 2021-10-11 | San Francisco | 75 | 1642 | 44239 | |
560717 | 560717 | 94118 | 94118 | 2021-10-11 | San Francisco | 75 | 1395 | 41468 | |
560718 | 560718 | 94121 | 94121 | 2021-10-11 | San Francisco | 75 | 1416 | 43795 | |
560719 | 560719 | 94122 | 94122 | 2021-10-11 | San Francisco | 75 | 1710 | 62131 | |
560720 | 560720 | 94123 | 94123 | 2021-10-11 | San Francisco | 75 | 1343 | 25941 | |
560721 | 560721 | 94124 | 94124 | 2021-10-11 | San Francisco | 75 | 4924 | 35363 | |
560722 | 560722 | 94127 | 94127 | 2021-10-11 | San Francisco | 75 | 703 | 21423 | |
560723 | 560723 | 94129 | 94129 | 2021-10-11 | San Francisco | 75 | 145 | 3994 | |
560724 | 560724 | 94130 | 94130 | 2021-10-11 | San Francisco | 75 | 184 | 3064 | |
560725 | 560725 | 94131 | 94131 | 2021-10-11 | San Francisco | 75 | 1032 | 29902 | |
560726 | 560726 | 94132 | 94132 | 2021-10-11 | San Francisco | 75 | 1220 | 31488 | |
560727 | 560727 | 94133 | 94133 | 2021-10-11 | San Francisco | 75 | 1114 | 26527 | |
560728 | 560728 | 94134 | 94134 | 2021-10-11 | San Francisco | 75 | 3476 | 42471 | |
560729 | 560729 | 94158 | 94158 | 2021-10-11 | San Francisco | 75 | 468 | 7291 | |
561980 | 561980 | 94102 | 94102 | 2021-10-10 | San Francisco | 75 | 2624 | 31067 | |
561981 | 561981 | 94103 | 94103 | 2021-10-10 | San Francisco | 75 | 2641 | 28735 | |
561982 | 561982 | 94105 | 94105 | 2021-10-10 | San Francisco | 75 | 630 | 9155 | |
561983 | 561983 | 94107 | 94107 | 2021-10-10 | San Francisco | 75 | 1672 | 29689 | |
561984 | 561984 | 94108 | 94108 | 2021-10-10 | San Francisco | 75 | 465 | 14550 | |
561985 | 561985 | 94109 | 94109 | 2021-10-10 | San Francisco | 75 | 3037 | 56677 | |
561986 | 561986 | 94110 | 94110 | 2021-10-10 | San Francisco | 75 | 5629 | 94161 | |
561987 | 561987 | 94111 | 94111 | 2021-10-10 | San Francisco | 75 | 164 | 3620 | |
561988 | 561988 | 94112 | 94112 | 2021-10-10 | San Francisco | 75 | 6147 | 85166 | |
561989 | 561989 | 94114 | 94114 | 2021-10-10 | San Francisco | 75 | 1464 | 34754 | |
561990 | 561990 | 94115 | 94115 | 2021-10-10 | San Francisco | 75 | 2010 | 35004 | |
561991 | 561991 | 94116 | 94116 | 2021-10-10 | San Francisco | 75 | 1435 | 47823 | |
561992 | 561992 | 94117 | 94117 | 2021-10-10 | San Francisco | 75 | 1638 | 44239 | |
561993 | 561993 | 94118 | 94118 | 2021-10-10 | San Francisco | 75 | 1391 | 41468 | |
561994 | 561994 | 94121 | 94121 | 2021-10-10 | San Francisco | 75 | 1414 | 43795 | |
561995 | 561995 | 94122 | 94122 | 2021-10-10 | San Francisco | 75 | 1707 | 62131 | |
561996 | 561996 | 94123 | 94123 | 2021-10-10 | San Francisco | 75 | 1343 | 25941 | |
561997 | 561997 | 94124 | 94124 | 2021-10-10 | San Francisco | 75 | 4921 | 35363 | |
561998 | 561998 | 94127 | 94127 | 2021-10-10 | San Francisco | 75 | 703 | 21423 | |
561999 | 561999 | 94129 | 94129 | 2021-10-10 | San Francisco | 75 | 145 | 3994 | |
562000 | 562000 | 94130 | 94130 | 2021-10-10 | San Francisco | 75 | 184 | 3064 | |
562001 | 562001 | 94131 | 94131 | 2021-10-10 | San Francisco | 75 | 1029 | 29902 |
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 );