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-06-06 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 |
---|---|---|---|---|---|---|---|---|---|
722756 | 722756 | 94102 | 94102 | 2021-06-06 | San Francisco | 75 | 2000 | 31067 | |
722757 | 722757 | 94103 | 94103 | 2021-06-06 | San Francisco | 75 | 1868 | 28735 | |
722758 | 722758 | 94105 | 94105 | 2021-06-06 | San Francisco | 75 | 423 | 9155 | |
722759 | 722759 | 94107 | 94107 | 2021-06-06 | San Francisco | 75 | 1092 | 29689 | |
722760 | 722760 | 94108 | 94108 | 2021-06-06 | San Francisco | 75 | 327 | 14550 | |
722761 | 722761 | 94109 | 94109 | 2021-06-06 | San Francisco | 75 | 2178 | 56677 | |
722762 | 722762 | 94110 | 94110 | 2021-06-06 | San Francisco | 75 | 4407 | 94161 | |
722763 | 722763 | 94111 | 94111 | 2021-06-06 | San Francisco | 75 | 107 | 3620 | |
722764 | 722764 | 94112 | 94112 | 2021-06-06 | San Francisco | 75 | 5114 | 85166 | |
722765 | 722765 | 94114 | 94114 | 2021-06-06 | San Francisco | 75 | 821 | 34754 | |
722766 | 722766 | 94115 | 94115 | 2021-06-06 | San Francisco | 75 | 1338 | 35004 | |
722767 | 722767 | 94116 | 94116 | 2021-06-06 | San Francisco | 75 | 990 | 47823 | |
722768 | 722768 | 94117 | 94117 | 2021-06-06 | San Francisco | 75 | 962 | 44239 | |
722769 | 722769 | 94118 | 94118 | 2021-06-06 | San Francisco | 75 | 942 | 41468 | |
722770 | 722770 | 94121 | 94121 | 2021-06-06 | San Francisco | 75 | 954 | 43795 | |
722771 | 722771 | 94122 | 94122 | 2021-06-06 | San Francisco | 75 | 1111 | 62131 | |
722772 | 722772 | 94123 | 94123 | 2021-06-06 | San Francisco | 75 | 903 | 25941 | |
722773 | 722773 | 94124 | 94124 | 2021-06-06 | San Francisco | 75 | 3804 | 35363 | |
722774 | 722774 | 94127 | 94127 | 2021-06-06 | San Francisco | 75 | 492 | 21423 | |
722775 | 722775 | 94129 | 94129 | 2021-06-06 | San Francisco | 75 | 111 | 3994 | |
722776 | 722776 | 94130 | 94130 | 2021-06-06 | San Francisco | 75 | 142 | 3064 | |
722777 | 722777 | 94131 | 94131 | 2021-06-06 | San Francisco | 75 | 681 | 29902 | |
722778 | 722778 | 94132 | 94132 | 2021-06-06 | San Francisco | 75 | 855 | 31488 | |
722779 | 722779 | 94133 | 94133 | 2021-06-06 | San Francisco | 75 | 717 | 26527 | |
722780 | 722780 | 94134 | 94134 | 2021-06-06 | San Francisco | 75 | 2902 | 42471 | |
722781 | 722781 | 94158 | 94158 | 2021-06-06 | San Francisco | 75 | 340 | 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 );