latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
26 rows where county = "San Francisco", "date" is on date 2021-09-18 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 |
---|---|---|---|---|---|---|---|---|---|
590052 | 590052 | 94102 | 94102 | 2021-09-18 | San Francisco | 75 | 2536 | 31067 | |
590053 | 590053 | 94103 | 94103 | 2021-09-18 | San Francisco | 75 | 2530 | 28735 | |
590054 | 590054 | 94105 | 94105 | 2021-09-18 | San Francisco | 75 | 608 | 9155 | |
590055 | 590055 | 94107 | 94107 | 2021-09-18 | San Francisco | 75 | 1620 | 29689 | |
590056 | 590056 | 94108 | 94108 | 2021-09-18 | San Francisco | 75 | 434 | 14550 | |
590057 | 590057 | 94109 | 94109 | 2021-09-18 | San Francisco | 75 | 2931 | 56677 | |
590058 | 590058 | 94110 | 94110 | 2021-09-18 | San Francisco | 75 | 5490 | 94161 | |
590059 | 590059 | 94111 | 94111 | 2021-09-18 | San Francisco | 75 | 154 | 3620 | |
590060 | 590060 | 94112 | 94112 | 2021-09-18 | San Francisco | 75 | 5996 | 85166 | |
590061 | 590061 | 94114 | 94114 | 2021-09-18 | San Francisco | 75 | 1389 | 34754 | |
590062 | 590062 | 94115 | 94115 | 2021-09-18 | San Francisco | 75 | 1932 | 35004 | |
590063 | 590063 | 94116 | 94116 | 2021-09-18 | San Francisco | 75 | 1362 | 47823 | |
590064 | 590064 | 94117 | 94117 | 2021-09-18 | San Francisco | 75 | 1543 | 44239 | |
590065 | 590065 | 94118 | 94118 | 2021-09-18 | San Francisco | 75 | 1317 | 41468 | |
590066 | 590066 | 94121 | 94121 | 2021-09-18 | San Francisco | 75 | 1336 | 43795 | |
590067 | 590067 | 94122 | 94122 | 2021-09-18 | San Francisco | 75 | 1609 | 62131 | |
590068 | 590068 | 94123 | 94123 | 2021-09-18 | San Francisco | 75 | 1275 | 25941 | |
590069 | 590069 | 94124 | 94124 | 2021-09-18 | San Francisco | 75 | 4798 | 35363 | |
590070 | 590070 | 94127 | 94127 | 2021-09-18 | San Francisco | 75 | 655 | 21423 | |
590071 | 590071 | 94129 | 94129 | 2021-09-18 | San Francisco | 75 | 138 | 3994 | |
590072 | 590072 | 94130 | 94130 | 2021-09-18 | San Francisco | 75 | 181 | 3064 | |
590073 | 590073 | 94131 | 94131 | 2021-09-18 | San Francisco | 75 | 999 | 29902 | |
590074 | 590074 | 94132 | 94132 | 2021-09-18 | San Francisco | 75 | 1173 | 31488 | |
590075 | 590075 | 94133 | 94133 | 2021-09-18 | San Francisco | 75 | 1026 | 26527 | |
590076 | 590076 | 94134 | 94134 | 2021-09-18 | San Francisco | 75 | 3418 | 42471 | |
590077 | 590077 | 94158 | 94158 | 2021-09-18 | San Francisco | 75 | 444 | 7291 |
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 );