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 2022-09-01 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 |
---|---|---|---|---|---|---|---|---|---|
148417 | 148417 | 94102 | 94102 | 2022-09-01 | San Francisco | 75 | 7449 | 31067 | |
148418 | 148418 | 94103 | 94103 | 2022-09-01 | San Francisco | 75 | 7595 | 28735 | |
148419 | 148419 | 94105 | 94105 | 2022-09-01 | San Francisco | 75 | 2522 | 9155 | |
148420 | 148420 | 94107 | 94107 | 2022-09-01 | San Francisco | 75 | 6229 | 29689 | |
148421 | 148421 | 94108 | 94108 | 2022-09-01 | San Francisco | 75 | 1887 | 14550 | |
148422 | 148422 | 94109 | 94109 | 2022-09-01 | San Francisco | 75 | 9424 | 56677 | |
148423 | 148423 | 94110 | 94110 | 2022-09-01 | San Francisco | 75 | 15289 | 94161 | |
148424 | 148424 | 94111 | 94111 | 2022-09-01 | San Francisco | 75 | 695 | 3620 | |
148425 | 148425 | 94112 | 94112 | 2022-09-01 | San Francisco | 75 | 19407 | 85166 | |
148426 | 148426 | 94114 | 94114 | 2022-09-01 | San Francisco | 75 | 5124 | 34754 | |
148427 | 148427 | 94115 | 94115 | 2022-09-01 | San Francisco | 75 | 6435 | 35004 | |
148428 | 148428 | 94116 | 94116 | 2022-09-01 | San Francisco | 75 | 6775 | 47823 | |
148429 | 148429 | 94117 | 94117 | 2022-09-01 | San Francisco | 75 | 6589 | 44239 | |
148430 | 148430 | 94118 | 94118 | 2022-09-01 | San Francisco | 75 | 5938 | 41468 | |
148431 | 148431 | 94121 | 94121 | 2022-09-01 | San Francisco | 75 | 6681 | 43795 | |
148432 | 148432 | 94122 | 94122 | 2022-09-01 | San Francisco | 75 | 8518 | 62131 | |
148433 | 148433 | 94123 | 94123 | 2022-09-01 | San Francisco | 75 | 3988 | 25941 | |
148434 | 148434 | 94124 | 94124 | 2022-09-01 | San Francisco | 75 | 12649 | 35363 | |
148435 | 148435 | 94127 | 94127 | 2022-09-01 | San Francisco | 75 | 3135 | 21423 | |
148436 | 148436 | 94129 | 94129 | 2022-09-01 | San Francisco | 75 | 528 | 3994 | |
148437 | 148437 | 94130 | 94130 | 2022-09-01 | San Francisco | 75 | 514 | 3064 | |
148438 | 148438 | 94131 | 94131 | 2022-09-01 | San Francisco | 75 | 4604 | 29902 | |
148439 | 148439 | 94132 | 94132 | 2022-09-01 | San Francisco | 75 | 4685 | 31488 | |
148440 | 148440 | 94133 | 94133 | 2022-09-01 | San Francisco | 75 | 3932 | 26527 | |
148441 | 148441 | 94134 | 94134 | 2022-09-01 | San Francisco | 75 | 10441 | 42471 | |
148442 | 148442 | 94158 | 94158 | 2022-09-01 | San Francisco | 75 | 2034 | 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 );