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-28 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 |
---|---|---|---|---|---|---|---|---|---|
694684 | 694684 | 94102 | 94102 | 2021-06-28 | San Francisco | 75 | 2007 | 31067 | |
694685 | 694685 | 94103 | 94103 | 2021-06-28 | San Francisco | 75 | 1887 | 28735 | |
694686 | 694686 | 94105 | 94105 | 2021-06-28 | San Francisco | 75 | 426 | 9155 | |
694687 | 694687 | 94107 | 94107 | 2021-06-28 | San Francisco | 75 | 1100 | 29689 | |
694688 | 694688 | 94108 | 94108 | 2021-06-28 | San Francisco | 75 | 328 | 14550 | |
694689 | 694689 | 94109 | 94109 | 2021-06-28 | San Francisco | 75 | 2193 | 56677 | |
694690 | 694690 | 94110 | 94110 | 2021-06-28 | San Francisco | 75 | 4430 | 94161 | |
694691 | 694691 | 94111 | 94111 | 2021-06-28 | San Francisco | 75 | 107 | 3620 | |
694692 | 694692 | 94112 | 94112 | 2021-06-28 | San Francisco | 75 | 5141 | 85166 | |
694693 | 694693 | 94114 | 94114 | 2021-06-28 | San Francisco | 75 | 827 | 34754 | |
694694 | 694694 | 94115 | 94115 | 2021-06-28 | San Francisco | 75 | 1345 | 35004 | |
694695 | 694695 | 94116 | 94116 | 2021-06-28 | San Francisco | 75 | 992 | 47823 | |
694696 | 694696 | 94117 | 94117 | 2021-06-28 | San Francisco | 75 | 973 | 44239 | |
694697 | 694697 | 94118 | 94118 | 2021-06-28 | San Francisco | 75 | 951 | 41468 | |
694698 | 694698 | 94121 | 94121 | 2021-06-28 | San Francisco | 75 | 957 | 43795 | |
694699 | 694699 | 94122 | 94122 | 2021-06-28 | San Francisco | 75 | 1122 | 62131 | |
694700 | 694700 | 94123 | 94123 | 2021-06-28 | San Francisco | 75 | 909 | 25941 | |
694701 | 694701 | 94124 | 94124 | 2021-06-28 | San Francisco | 75 | 3840 | 35363 | |
694702 | 694702 | 94127 | 94127 | 2021-06-28 | San Francisco | 75 | 495 | 21423 | |
694703 | 694703 | 94129 | 94129 | 2021-06-28 | San Francisco | 75 | 112 | 3994 | |
694704 | 694704 | 94130 | 94130 | 2021-06-28 | San Francisco | 75 | 142 | 3064 | |
694705 | 694705 | 94131 | 94131 | 2021-06-28 | San Francisco | 75 | 688 | 29902 | |
694706 | 694706 | 94132 | 94132 | 2021-06-28 | San Francisco | 75 | 863 | 31488 | |
694707 | 694707 | 94133 | 94133 | 2021-06-28 | San Francisco | 75 | 720 | 26527 | |
694708 | 694708 | 94134 | 94134 | 2021-06-28 | San Francisco | 75 | 2935 | 42471 | |
694709 | 694709 | 94158 | 94158 | 2021-06-28 | 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 );