columns

1,690 rows

View and edit SQL

id ▼ table_id name
101 Registered_Business_Locations_-_San_Francisco 30 Business Account Number
102 Registered_Business_Locations_-_San_Francisco 30 Ownership Name
103 Registered_Business_Locations_-_San_Francisco 30 DBA Name
104 Registered_Business_Locations_-_San_Francisco 30 Street Address
105 Registered_Business_Locations_-_San_Francisco 30 City
106 Registered_Business_Locations_-_San_Francisco 30 State
107 Registered_Business_Locations_-_San_Francisco 30 Source Zipcode
108 Registered_Business_Locations_-_San_Francisco 30 Business Start Date
109 Registered_Business_Locations_-_San_Francisco 30 Business End Date
110 Registered_Business_Locations_-_San_Francisco 30 Location Start Date
111 Registered_Business_Locations_-_San_Francisco 30 Location End Date
112 Registered_Business_Locations_-_San_Francisco 30 Mail Address
113 Registered_Business_Locations_-_San_Francisco 30 Mail City
114 Registered_Business_Locations_-_San_Francisco 30 Mail Zipcode
115 Registered_Business_Locations_-_San_Francisco 30 Mail State
116 Registered_Business_Locations_-_San_Francisco 30 NAICS Code
117 Registered_Business_Locations_-_San_Francisco 30 NAICS Code Description
118 Registered_Business_Locations_-_San_Francisco 30 Parking Tax
119 Registered_Business_Locations_-_San_Francisco 30 Transient Occupancy Tax
120 Registered_Business_Locations_-_San_Francisco 30 LIC Code
121 Registered_Business_Locations_-_San_Francisco 30 LIC Code Description
122 Registered_Business_Locations_-_San_Francisco 30 Supervisor District
123 Registered_Business_Locations_-_San_Francisco 30 Neighborhoods - Analysis Boundaries
124 Registered_Business_Locations_-_San_Francisco 30 Business Corridor
125 Registered_Business_Locations_-_San_Francisco 30 Business Location
126 Registered_Business_Locations_-_San_Francisco_fts 31 Ownership Name
127 Registered_Business_Locations_-_San_Francisco_fts 31 DBA Name
128 Registered_Business_Locations_-_San_Francisco_fts 31 Street Address
129 Registered_Business_Locations_-_San_Francisco_fts 31 City
130 Registered_Business_Locations_-_San_Francisco_fts 31 State
131 Registered_Business_Locations_-_San_Francisco_fts 31 NAICS Code Description
132 Registered_Business_Locations_-_San_Francisco_fts 31 Neighborhoods - Analysis Boundaries
133 Registered_Business_Locations_-_San_Francisco_fts 31 Business Corridor
134 Registered_Business_Locations_-_San_Francisco_fts_segments 32 blockid
135 Registered_Business_Locations_-_San_Francisco_fts_segments 32 block
136 Registered_Business_Locations_-_San_Francisco_fts_segdir 33 level
137 Registered_Business_Locations_-_San_Francisco_fts_segdir 33 idx
138 Registered_Business_Locations_-_San_Francisco_fts_segdir 33 start_block
139 Registered_Business_Locations_-_San_Francisco_fts_segdir 33 leaves_end_block
140 Registered_Business_Locations_-_San_Francisco_fts_segdir 33 end_block
141 Registered_Business_Locations_-_San_Francisco_fts_segdir 33 root
142 Registered_Business_Locations_-_San_Francisco_fts_docsize 34 docid
143 Registered_Business_Locations_-_San_Francisco_fts_docsize 34 size
144 Registered_Business_Locations_-_San_Francisco_fts_stat 35 id
145 Registered_Business_Locations_-_San_Francisco_fts_stat 35 value
146 Title 36 id
147 Title 36 value
148 Director 37 id
149 Director 37 value
150 Writer 38 id
151 Writer 38 value
152 Release Year 39 id
153 Release Year 39 value
154 Actors 40 id
155 Actors 40 value
156 Production Company 41 id
157 Production Company 41 value
158 Distributor 42 id
159 Distributor 42 value
160 Film_Locations_in_San_Francisco 43 Title
161 Film_Locations_in_San_Francisco 43 Release Year
162 Film_Locations_in_San_Francisco 43 Locations
163 Film_Locations_in_San_Francisco 43 Fun Facts
164 Film_Locations_in_San_Francisco 43 Production Company
165 Film_Locations_in_San_Francisco 43 Distributor
166 Film_Locations_in_San_Francisco 43 Director
167 Film_Locations_in_San_Francisco 43 Writer
168 Film_Locations_in_San_Francisco 43 Actor 1
169 Film_Locations_in_San_Francisco 43 Actor 2
170 Film_Locations_in_San_Francisco 43 Actor 3
171 Film_Locations_in_San_Francisco_fts 44 Title
172 Film_Locations_in_San_Francisco_fts 44 Production Company
173 Film_Locations_in_San_Francisco_fts 44 Director
174 Film_Locations_in_San_Francisco_fts 44 Writer
175 Film_Locations_in_San_Francisco_fts 44 Actor 1
176 Film_Locations_in_San_Francisco_fts 44 Actor 2
177 Film_Locations_in_San_Francisco_fts 44 Actor 3
178 Film_Locations_in_San_Francisco_fts 44 Locations
179 Film_Locations_in_San_Francisco_fts 44 Fun Facts
180 Film_Locations_in_San_Francisco_fts_segments 45 blockid
181 Film_Locations_in_San_Francisco_fts_segments 45 block
182 Film_Locations_in_San_Francisco_fts_segdir 46 level
183 Film_Locations_in_San_Francisco_fts_segdir 46 idx
184 Film_Locations_in_San_Francisco_fts_segdir 46 start_block
185 Film_Locations_in_San_Francisco_fts_segdir 46 leaves_end_block
186 Film_Locations_in_San_Francisco_fts_segdir 46 end_block
187 Film_Locations_in_San_Francisco_fts_segdir 46 root
188 Film_Locations_in_San_Francisco_fts_docsize 47 docid
189 Film_Locations_in_San_Francisco_fts_docsize 47 size
190 Film_Locations_in_San_Francisco_fts_stat 48 id
191 Film_Locations_in_San_Francisco_fts_stat 48 value
192 PlantType 49 id
193 PlantType 49 value
194 qCaretaker 50 id
195 qCaretaker 50 value
196 qSiteInfo 51 id
197 qSiteInfo 51 value
198 qSpecies 52 id
199 qSpecies 52 value
200 qCareAssistant 53 id

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE columns (
            id integer PRIMARY KEY,
            table_id integer,
            name text,
            FOREIGN KEY (table_id) REFERENCES tables(id)
        );
Powered by Datasette · Query took 6.001ms