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" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
597730 | 597730 | 94132 | 94132 | 2021-09-12 | San Francisco | 75 | 1157 | 31488 | |
597731 | 597731 | 94133 | 94133 | 2021-09-12 | San Francisco | 75 | 986 | 26527 | |
597732 | 597732 | 94134 | 94134 | 2021-09-12 | San Francisco | 75 | 3389 | 42471 | |
597733 | 597733 | 94158 | 94158 | 2021-09-12 | San Francisco | 75 | 434 | 7291 | |
598984 | 598984 | 94102 | 94102 | 2021-09-11 | San Francisco | 75 | 2504 | 31067 | |
598985 | 598985 | 94103 | 94103 | 2021-09-11 | San Francisco | 75 | 2494 | 28735 | |
598986 | 598986 | 94105 | 94105 | 2021-09-11 | San Francisco | 75 | 604 | 9155 | |
598987 | 598987 | 94107 | 94107 | 2021-09-11 | San Francisco | 75 | 1587 | 29689 | |
598988 | 598988 | 94108 | 94108 | 2021-09-11 | San Francisco | 75 | 422 | 14550 | |
598989 | 598989 | 94109 | 94109 | 2021-09-11 | San Francisco | 75 | 2885 | 56677 | |
598990 | 598990 | 94110 | 94110 | 2021-09-11 | San Francisco | 75 | 5412 | 94161 | |
598991 | 598991 | 94111 | 94111 | 2021-09-11 | San Francisco | 75 | 152 | 3620 | |
598992 | 598992 | 94112 | 94112 | 2021-09-11 | San Francisco | 75 | 5920 | 85166 | |
598993 | 598993 | 94114 | 94114 | 2021-09-11 | San Francisco | 75 | 1368 | 34754 | |
598994 | 598994 | 94115 | 94115 | 2021-09-11 | San Francisco | 75 | 1886 | 35004 | |
598995 | 598995 | 94116 | 94116 | 2021-09-11 | San Francisco | 75 | 1326 | 47823 | |
598996 | 598996 | 94117 | 94117 | 2021-09-11 | San Francisco | 75 | 1507 | 44239 | |
598997 | 598997 | 94118 | 94118 | 2021-09-11 | San Francisco | 75 | 1285 | 41468 | |
598998 | 598998 | 94121 | 94121 | 2021-09-11 | San Francisco | 75 | 1303 | 43795 | |
598999 | 598999 | 94122 | 94122 | 2021-09-11 | San Francisco | 75 | 1568 | 62131 | |
599000 | 599000 | 94123 | 94123 | 2021-09-11 | San Francisco | 75 | 1248 | 25941 | |
599001 | 599001 | 94124 | 94124 | 2021-09-11 | San Francisco | 75 | 4741 | 35363 | |
599002 | 599002 | 94127 | 94127 | 2021-09-11 | San Francisco | 75 | 641 | 21423 | |
599003 | 599003 | 94129 | 94129 | 2021-09-11 | San Francisco | 75 | 136 | 3994 | |
599004 | 599004 | 94130 | 94130 | 2021-09-11 | San Francisco | 75 | 181 | 3064 | |
599005 | 599005 | 94131 | 94131 | 2021-09-11 | San Francisco | 75 | 976 | 29902 | |
599006 | 599006 | 94132 | 94132 | 2021-09-11 | San Francisco | 75 | 1155 | 31488 | |
599007 | 599007 | 94133 | 94133 | 2021-09-11 | San Francisco | 75 | 981 | 26527 | |
599008 | 599008 | 94134 | 94134 | 2021-09-11 | San Francisco | 75 | 3386 | 42471 | |
599009 | 599009 | 94158 | 94158 | 2021-09-11 | San Francisco | 75 | 433 | 7291 | |
600260 | 600260 | 94102 | 94102 | 2021-09-10 | San Francisco | 75 | 2500 | 31067 | |
600261 | 600261 | 94103 | 94103 | 2021-09-10 | San Francisco | 75 | 2492 | 28735 | |
600262 | 600262 | 94105 | 94105 | 2021-09-10 | San Francisco | 75 | 604 | 9155 | |
600263 | 600263 | 94107 | 94107 | 2021-09-10 | San Francisco | 75 | 1581 | 29689 | |
600264 | 600264 | 94108 | 94108 | 2021-09-10 | San Francisco | 75 | 436 | 14550 | |
600265 | 600265 | 94109 | 94109 | 2021-09-10 | San Francisco | 75 | 2879 | 56677 | |
600266 | 600266 | 94110 | 94110 | 2021-09-10 | San Francisco | 75 | 5407 | 94161 | |
600267 | 600267 | 94111 | 94111 | 2021-09-10 | San Francisco | 75 | 152 | 3620 | |
600268 | 600268 | 94112 | 94112 | 2021-09-10 | San Francisco | 75 | 5916 | 85166 | |
600269 | 600269 | 94114 | 94114 | 2021-09-10 | San Francisco | 75 | 1361 | 34754 | |
600270 | 600270 | 94115 | 94115 | 2021-09-10 | San Francisco | 75 | 1882 | 35004 | |
600271 | 600271 | 94116 | 94116 | 2021-09-10 | San Francisco | 75 | 1320 | 47823 | |
600272 | 600272 | 94117 | 94117 | 2021-09-10 | San Francisco | 75 | 1503 | 44239 | |
600273 | 600273 | 94118 | 94118 | 2021-09-10 | San Francisco | 75 | 1281 | 41468 | |
600274 | 600274 | 94121 | 94121 | 2021-09-10 | San Francisco | 75 | 1299 | 43795 | |
600275 | 600275 | 94122 | 94122 | 2021-09-10 | San Francisco | 75 | 1563 | 62131 | |
600276 | 600276 | 94123 | 94123 | 2021-09-10 | San Francisco | 75 | 1306 | 25941 | |
600277 | 600277 | 94124 | 94124 | 2021-09-10 | San Francisco | 75 | 4734 | 35363 | |
600278 | 600278 | 94127 | 94127 | 2021-09-10 | San Francisco | 75 | 641 | 21423 | |
600279 | 600279 | 94129 | 94129 | 2021-09-10 | San Francisco | 75 | 135 | 3994 | |
600280 | 600280 | 94130 | 94130 | 2021-09-10 | San Francisco | 75 | 181 | 3064 | |
600281 | 600281 | 94131 | 94131 | 2021-09-10 | San Francisco | 75 | 974 | 29902 | |
600282 | 600282 | 94132 | 94132 | 2021-09-10 | San Francisco | 75 | 1151 | 31488 | |
600283 | 600283 | 94133 | 94133 | 2021-09-10 | San Francisco | 75 | 977 | 26527 | |
600284 | 600284 | 94134 | 94134 | 2021-09-10 | San Francisco | 75 | 3380 | 42471 | |
600285 | 600285 | 94158 | 94158 | 2021-09-10 | San Francisco | 75 | 433 | 7291 | |
601536 | 601536 | 94102 | 94102 | 2021-09-09 | San Francisco | 75 | 2497 | 31067 | |
601537 | 601537 | 94103 | 94103 | 2021-09-09 | San Francisco | 75 | 2486 | 28735 | |
601538 | 601538 | 94105 | 94105 | 2021-09-09 | San Francisco | 75 | 605 | 9155 | |
601539 | 601539 | 94107 | 94107 | 2021-09-09 | San Francisco | 75 | 1580 | 29689 | |
601540 | 601540 | 94108 | 94108 | 2021-09-09 | San Francisco | 75 | 425 | 14550 | |
601541 | 601541 | 94109 | 94109 | 2021-09-09 | San Francisco | 75 | 2874 | 56677 | |
601542 | 601542 | 94110 | 94110 | 2021-09-09 | San Francisco | 75 | 5409 | 94161 | |
601543 | 601543 | 94111 | 94111 | 2021-09-09 | San Francisco | 75 | 151 | 3620 | |
601544 | 601544 | 94112 | 94112 | 2021-09-09 | San Francisco | 75 | 5911 | 85166 | |
601545 | 601545 | 94114 | 94114 | 2021-09-09 | San Francisco | 75 | 1359 | 34754 | |
601546 | 601546 | 94115 | 94115 | 2021-09-09 | San Francisco | 75 | 1880 | 35004 | |
601547 | 601547 | 94116 | 94116 | 2021-09-09 | San Francisco | 75 | 1317 | 47823 | |
601548 | 601548 | 94117 | 94117 | 2021-09-09 | San Francisco | 75 | 1497 | 44239 | |
601549 | 601549 | 94118 | 94118 | 2021-09-09 | San Francisco | 75 | 1278 | 41468 | |
601550 | 601550 | 94121 | 94121 | 2021-09-09 | San Francisco | 75 | 1298 | 43795 | |
601551 | 601551 | 94122 | 94122 | 2021-09-09 | San Francisco | 75 | 1557 | 62131 | |
601552 | 601552 | 94123 | 94123 | 2021-09-09 | San Francisco | 75 | 1235 | 25941 | |
601553 | 601553 | 94124 | 94124 | 2021-09-09 | San Francisco | 75 | 4729 | 35363 | |
601554 | 601554 | 94127 | 94127 | 2021-09-09 | San Francisco | 75 | 640 | 21423 | |
601555 | 601555 | 94129 | 94129 | 2021-09-09 | San Francisco | 75 | 135 | 3994 | |
601556 | 601556 | 94130 | 94130 | 2021-09-09 | San Francisco | 75 | 181 | 3064 | |
601557 | 601557 | 94131 | 94131 | 2021-09-09 | San Francisco | 75 | 969 | 29902 | |
601558 | 601558 | 94132 | 94132 | 2021-09-09 | San Francisco | 75 | 1151 | 31488 | |
601559 | 601559 | 94133 | 94133 | 2021-09-09 | San Francisco | 75 | 975 | 26527 | |
601560 | 601560 | 94134 | 94134 | 2021-09-09 | San Francisco | 75 | 3380 | 42471 | |
601561 | 601561 | 94158 | 94158 | 2021-09-09 | San Francisco | 75 | 432 | 7291 | |
602812 | 602812 | 94102 | 94102 | 2021-09-08 | San Francisco | 75 | 2490 | 31067 | |
602813 | 602813 | 94103 | 94103 | 2021-09-08 | San Francisco | 75 | 2480 | 28735 | |
602814 | 602814 | 94105 | 94105 | 2021-09-08 | San Francisco | 75 | 602 | 9155 | |
602815 | 602815 | 94107 | 94107 | 2021-09-08 | San Francisco | 75 | 1578 | 29689 | |
602816 | 602816 | 94108 | 94108 | 2021-09-08 | San Francisco | 75 | 422 | 14550 | |
602817 | 602817 | 94109 | 94109 | 2021-09-08 | San Francisco | 75 | 2865 | 56677 | |
602818 | 602818 | 94110 | 94110 | 2021-09-08 | San Francisco | 75 | 5395 | 94161 | |
602819 | 602819 | 94111 | 94111 | 2021-09-08 | San Francisco | 75 | 150 | 3620 | |
602820 | 602820 | 94112 | 94112 | 2021-09-08 | San Francisco | 75 | 5901 | 85166 | |
602821 | 602821 | 94114 | 94114 | 2021-09-08 | San Francisco | 75 | 1355 | 34754 | |
602822 | 602822 | 94115 | 94115 | 2021-09-08 | San Francisco | 75 | 1874 | 35004 | |
602823 | 602823 | 94116 | 94116 | 2021-09-08 | San Francisco | 75 | 1314 | 47823 | |
602824 | 602824 | 94117 | 94117 | 2021-09-08 | San Francisco | 75 | 1493 | 44239 | |
602825 | 602825 | 94118 | 94118 | 2021-09-08 | San Francisco | 75 | 1274 | 41468 | |
602826 | 602826 | 94121 | 94121 | 2021-09-08 | San Francisco | 75 | 1291 | 43795 | |
602827 | 602827 | 94122 | 94122 | 2021-09-08 | San Francisco | 75 | 1552 | 62131 | |
602828 | 602828 | 94123 | 94123 | 2021-09-08 | San Francisco | 75 | 1229 | 25941 | |
602829 | 602829 | 94124 | 94124 | 2021-09-08 | San Francisco | 75 | 4721 | 35363 |
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 );