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-06-20 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 |
---|---|---|---|---|---|---|---|---|---|
240616 | 240616 | 94102 | 94102 | 2022-06-20 | San Francisco | 75 | 6584 | 31067 | |
240617 | 240617 | 94103 | 94103 | 2022-06-20 | San Francisco | 75 | 6729 | 28735 | |
240618 | 240618 | 94105 | 94105 | 2022-06-20 | San Francisco | 75 | 2171 | 9155 | |
240619 | 240619 | 94107 | 94107 | 2022-06-20 | San Francisco | 75 | 5395 | 29689 | |
240620 | 240620 | 94108 | 94108 | 2022-06-20 | San Francisco | 75 | 1630 | 14550 | |
240621 | 240621 | 94109 | 94109 | 2022-06-20 | San Francisco | 75 | 8406 | 56677 | |
240622 | 240622 | 94110 | 94110 | 2022-06-20 | San Francisco | 75 | 13475 | 94161 | |
240623 | 240623 | 94111 | 94111 | 2022-06-20 | San Francisco | 75 | 610 | 3620 | |
240624 | 240624 | 94112 | 94112 | 2022-06-20 | San Francisco | 75 | 16642 | 85166 | |
240625 | 240625 | 94114 | 94114 | 2022-06-20 | San Francisco | 75 | 4441 | 34754 | |
240626 | 240626 | 94115 | 94115 | 2022-06-20 | San Francisco | 75 | 5608 | 35004 | |
240627 | 240627 | 94116 | 94116 | 2022-06-20 | San Francisco | 75 | 5524 | 47823 | |
240628 | 240628 | 94117 | 94117 | 2022-06-20 | San Francisco | 75 | 5710 | 44239 | |
240629 | 240629 | 94118 | 94118 | 2022-06-20 | San Francisco | 75 | 5091 | 41468 | |
240630 | 240630 | 94121 | 94121 | 2022-06-20 | San Francisco | 75 | 5377 | 43795 | |
240631 | 240631 | 94122 | 94122 | 2022-06-20 | San Francisco | 75 | 7038 | 62131 | |
240632 | 240632 | 94123 | 94123 | 2022-06-20 | San Francisco | 75 | 3621 | 25941 | |
240633 | 240633 | 94124 | 94124 | 2022-06-20 | San Francisco | 75 | 11091 | 35363 | |
240634 | 240634 | 94127 | 94127 | 2022-06-20 | San Francisco | 75 | 2631 | 21423 | |
240635 | 240635 | 94129 | 94129 | 2022-06-20 | San Francisco | 75 | 472 | 3994 | |
240636 | 240636 | 94130 | 94130 | 2022-06-20 | San Francisco | 75 | 458 | 3064 | |
240637 | 240637 | 94131 | 94131 | 2022-06-20 | San Francisco | 75 | 3814 | 29902 | |
240638 | 240638 | 94132 | 94132 | 2022-06-20 | San Francisco | 75 | 3910 | 31488 | |
240639 | 240639 | 94133 | 94133 | 2022-06-20 | San Francisco | 75 | 3457 | 26527 | |
240640 | 240640 | 94134 | 94134 | 2022-06-20 | San Francisco | 75 | 8994 | 42471 | |
240641 | 240641 | 94158 | 94158 | 2022-06-20 | San Francisco | 75 | 1725 | 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 );