home / registered-business-locations

Registered_Business_Locations_-_San_Francisco

Data source: data.sfgov.org

226,184 rows sorted by Business Location

View and edit SQL

These facets timed out: Business Corridor

Link rowid Location Id Ownership Name DBA Name Street Address City State Source Zipcode Business Start Date Business End Date Location Start Date Location End Date Mail Address Mail City Mail Zipcode Mail State NAICS Code NAICS Code Description Parking Tax Transient Occupancy Tax LIC Code LIC Code Description Supervisor District Neighborhoods - Analysis Boundaries Business Corridor Business Location ▼
69 0152271-01-999 Decisionone Corp. Decisionone Inc. Po 3004 Frazer Pa Brisbane+q4068 3   0 5 01/29/1985   01/29/1985   426 W Lancaster Ave Devon 13 19333 29 PA 8100-8139 5 Certain Services 5 0 0            
570 0113606-01-001 Camisa Madeline L Scribes Of The City P O Box 29382 San+francisco 8 CA 1 94129 42 07/01/1978   07/01/1978   1270 Chestnut St #6 San Francisco 1 94109 7 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0            
1681 0029094-01-999 Twentieth Century Fox Film Co Twentieth Century Fox Film Co P O Box 900 Beverly Hills Ca Mexico 28   0 5 10/01/1968   10/01/1968   Po Box 900 Beverly Hills 122 90213 183 CA 5100-5199 15 Information 15 0 0            
1818 0001746-01-999 Atlantic Richfield Co Atlantic Richfield Co 99 San Mateo Ca Toronto,+on+m5w+1m5 59 ON 10 0 5 10/01/1968   10/01/1968   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0            
2090 0062168-01-999 Procter & Gamble Distrg Co Th Procter & Gamble Distrg Co The 99 San Mateo Ca Brisbane Q4068 65   0 5 10/01/1968   10/01/1968   1 Po Box 599 Attn Tax Division Ann. Rep Cincinnati 143 45201 210 OH 4200-4299 7 Wholesale Trade 7 0 0            
2607 0406980-01-001 Curiel Luis M Curiel Luis M Po Box 640-871 San+francisco 8 CA 1 94164 110 01/01/2007   01/01/2007   Po Box 640-871 San Francisco 1 94164 132 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
2696 0410169-01-001 Nguyen Tam D Nguyen Tam D Po Box 425866 San+francisco 8 CA 1 94102 16 01/01/2007   01/01/2007   371 Holyoke St San Francisco 1 94134 23 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
3164 0424023-00-000 Baifu Co Inc Baifu Co Inc Po Box 162 Daly+city 40 CA 1 94016 127 01/01/2008 12/31/2012 01/01/2008 12/31/2012             0 0            
3384 0448061-02-999 Faber And Son Inc Faber And Son Inc Po Box 336 Millbrae 87 CA 1 94030 136 08/05/2013   08/05/2013   Po Box 336 Millbrae 17 94030 34 CA     0 0            
4003 0444220-01-999 Bonney Inc Heat Wave Systems Po Box 1747 Sonoma 2 CA 1 95476 2 12/02/2009   12/02/2009   Po Box 1747 Sonoma 100 95476 151 CA 2300-2399 6 Construction 6 0 0            
4361 0005995-01-001 Yeomans Douglas Coast Maintenance Co 24th Illinois St San+francisco 8 CA 1 94107 22 10/01/1968   10/01/1968   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0            
4932 0064007-01-999 B T Mancini Co Inc B T Mancini Co Inc P O Box 361930 Milpitas Ca Milpitas 110 CA 1 95036 185 10/01/1968   10/01/1968   Po Box 361930 Milpitas 264 95036 379 CA 2300-2399 6 Construction 6 0 0            
5025 0465183-01-999 Papadopoulos Teresa E Bodywork@work Po Box 11602 Oakland 16 CA 1 94611 105 04/01/2011   04/01/2011   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0            
5125 0468526-00-000 Rix Julie Rix Julie Po Box #3843 Santa+cruz 120 CA 1 95063 189 04/29/2012 09/05/2012 04/29/2012 09/05/2012             0 0            
5248 0054358-01-999 Nicholson D W Corporation Nicholson D W Corporation P O Box 4197 Hayward Ca Brisbane+q4068 3   0 5 01/01/1969   01/01/1969   Po Box 4197 Hayward 82 94540 401 CA 2300-2399 6 Construction 6 0 0            
6058 0064932-01-999 E Castagnetto Roofing Corp Castagnetto Ed Roofing Co Inc 99 Colma Ca Toronto,+on+m5w+1m5 59 ON 10 0 5 01/01/1970   01/01/1970   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0            
6388 0487386-00-000 Democracy At Work Institute Democracy At Work Institute Po Box 170701 San+francisco 8 CA 1 94117 33 10/01/2013 06/30/2014 10/01/2013 06/30/2014             0 0            
6676 0065495-02-999 General Mills Sales, Inc. General Mills Sales Inc P O Box 1113 Minneapolis Mn Minneapolis 49 MN 7 55440 233 10/01/1968   05/27/1996   Po Box 1113 Minneapolis 19 55440 36 MN 4200-4299 7 Wholesale Trade 7 0 0            
6708 0911345-03-999 Pape' Material Handling Inc Pape' Material Handling Inc Po Box 987 Eugene 146 OR 25 97440 234 01/02/1992   01/01/2005   Po Box 987 Eugene 311 97440 459 OR 4400-4599 3 Retail Trade 3 0 0            
6781 0917154-01-999 Ac3 Accurate Crane Cert Co P O Box 507 Alameda Ca Alameda 73 CA 1 94501 117 11/04/1992   11/04/1992   2394 Po Box 507 Alameda 31 94501 57 CA     0 0            
7392 0066906-01-999 Settlemier B R Bigge Crane & Rigging Co P O Box 1657 San Leandro Ca Brisbane+q4068 3   0 5 12/31/1998   12/31/1998   Po Box 1657 San Leandro 25 94577 49 CA 2300-2399 6 Construction 6 0 0            
7561 1007455-09-141 Johnson Stephanie A Johnson Stephanie A Po Box 3089 Greenwood+village 160 CO 3 80155 255 05/02/2014 02/29/2016 06/01/2014 02/29/2016             0 0            
7958 1014593-12-141 Barkoren Burak Render To Render Po Box 7775 San Francisco 1 CA 1 94120 138 12/01/2014   12/01/2014 01/28/2015 51 Ocean Grove Ave Daly City 11 94015 119 CA 8100-8139 5 Certain Services 5 0 0            
8547 1029055-05-151 Santa Clara Natural Organic Market Santa Clara Natural Organic Market 798 Haight St San Francisco 1 CA 1 94117 33 05/26/2015   05/26/2015   798 Haight St San Francisco 1 94117 80 CA 4400-4599 3 Retail Trade 3 0 0 H31 H73 Multiple        
8783 1032379-07-151 Opmc 805 Bush Llc Opmc 805 Bush Llc Po Box 31376 San Francisco 1 CA 1 94131 14 01/01/2014   01/01/2014   Po Box 31376 San Francisco 1 94131 14 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0            
9152 1078988-06-161 Patrick Mccarty Patrick Mccarty 902 Central Ave. San Francisco 1 CA 1 94115 4 05/15/2015   05/15/2015   Po Box 949 Moss Beach 290 94038 429 CA 4800-4999 12 Transportation and Warehousing 12 0 0     5 7 Lone Mountain/USF 24    
9154 1079172-06-161 Azouaou Sophie B Sophisticate Interiors 2400 El Camino Real 907 Mountain+view 181 CA 1 94040 287 08/15/2014   06/01/2016   2400 W El Camino Real Ste 907 Mountain View 114 94040 422 CA     0 0            
9155 1079468-06-161 The Bike Kitchen The Bike Kitchen 650 Florida St D San Francisco 1 CA 1 94110 18 12/22/2005   12/22/2005   650 Florida St H Ste San Francisco 1 94110 37 CA     0 0            
9157 1080206-07-161 Dowell Charles R/et Al Dowell Charles R/et Al 666 Ellis St #803 San+francisco 8 CA 1 94109 24 10/01/1997   10/01/1997   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0            
9160 1080619-07-161 Mongollimo Mongollimo 271 Vernon St Apt 105 Oakland 16 CA 1 94610 145 10/01/2011 10/11/2011 10/01/2012 10/11/2011             0 0            
9161 1080826-07-161 Allison Hodge Pure Alchemy 1912 Clement St San Francisco 1 CA 1 94121 15 07/05/2016   07/05/2016 11/30/2016 1912 Clement St San Francisco 1 94121 17 CA 4400-4599 4200-4299 57 Multiple 13 0 0     1 6 Outer Richmond 9    
9162 1081058-07-161 5020 Mission St Hoa 5020 Mission St Hoa 407 Orange St #412 Oakland 16 CA 1 94610 145 02/01/2005   02/01/2005   407 Orange St Apt 412 Oakland 27 94610 83 CA     0 0            
9163 1081091-07-161 Rohin Payman Rohin Payman 9784 Ellsmere Way Elk+grove 114 CA 1 95757 288 07/05/2016   07/05/2016   9784 Ellsmere Way Elk Grove 257 95757 560 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
9164 1081560-07-161 Dilawar Khan Dilawar Khan 1911 Court Dr Apt B Tracy 96 CA 1 95376 153 05/15/2015 08/29/2016 05/15/2015 08/29/2016         4800-4999 12 Transportation and Warehousing 12 0 0            
9165 1081607-07-161 Jacy A. Leonardo Leonardo Psychotherapy Services 4237 Geary Blvd San Francisco 1 CA 1 94118 6 07/07/2016   07/07/2016   7415 Geary Blvd 4 Apt San Francisco 1 94121 17 CA 6100-6299 4 Private Education and Health Services 4 0 0            
9166 1081710-07-161 Humanities West Inc Humanities West Inc 57 Post St #814 San+francisco 8 CA 1 94104 1 11/01/1983   11/01/1983   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0            
9167 1081906-07-161 Transpera Inc Transpera Inc 53 23rd St 12 New+york 48 NY 4 10010 289 03/01/2008   03/01/2008   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0            
9169 1082227-07-161 Urban Fabrick Inc Urban Fabrick 195 Plymouth St 410 Brooklyn 182 NY 4 11201 290 01/01/2013   06/01/2016   2 Mint Plaza #206 San Francisco 1 94103 32 CA     0 0            
9171 1082383-07-161 Ruben Orona Ruben Orona 2733 17th St Oakland 16 CA 1 94601 37 07/11/2016   07/11/2016   2733 E 17th St Oakland 27 94601 52 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
9173 1082425-07-161 Soccer United Marketing Llc Soccer United Marketing Llc 420 5th Ave 7th New+york 48 NY 4 10018 77 02/24/2010   02/24/2010   420 5th Ave 7th Fl New York 49 10018 561 NY     0 0            
9174 1082460-07-161 Fresh Express Inc Fresh Express Inc 550 Caldwell St 1010 Charlotte 183 NC 6 28202 291 05/31/2013   05/31/2013   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0            
9175 1082488-07-161 379 Church Street Homeowners A 379 Church Street Homeowners A 900 Bush St 1005 San Francisco 1 CA 1 94109 24 01/01/1993   01/01/1993   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0     3 1 Nob Hill 17    
9178 1082530-07-161 Barkly + Kitty Barkly + Kitty 1874 32nd Ave San Francisco 1 CA 1 94122 19 07/12/2016 04/30/2017 07/12/2016 04/30/2017   San Francisco 1 94122 15   8100-8139 5 Certain Services 5 0 0     4 10 Sunset/Parkside 14    
9180 1082566-07-161 Andrew Li Andrew Li 899 41st Ave. San Francisco 1 CA 1 94121 15 07/12/2016 01/01/2017 07/12/2016 01/01/2017         4800-4999 12 Transportation and Warehousing 12 0 0     1 6 Outer Richmond 9    
9184 1082901-07-161 Words On Dance Words On Dance 3629 Sacramento St San Francisco 1 CA 1 94118 6 01/01/2011   01/01/2011   3629 Sacramento St San Francisco 1 94118 28 CA     0 0     2 Presidio Heights 3    
9186 1083397-07-161 Ali Altaeb Ali Altaeb 2943 Macarthur Blvd Apt 101 Oakland 16 CA 1 94602 209 10/01/2014   10/01/2014   2943 Macarthur Blvd 101 Apt Oakland 27 94602 283 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
9187 1081107-07-161 Blackwell Inc. Blackwell Inc. 3173 24th. St San Francisco 1 CA 1 94110 18 05/02/2016 05/02/2016 05/02/2016 05/02/2016             0 0     9 8 Mission 12    
9188 1081220-07-161 Teams Teams 3540 Grand Ave 2nd Fl Oakland 16 CA 1 94610 145 11/01/2002   11/01/2002   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0            
9190 1081369-07-161 Lasdos Llc Lasdos 840 Wisconsin St San Francisco 1 CA 1 94107 22 06/20/2016   06/20/2016   840 Wisconsin St San Francisco 1 94107 47 CA     0 0            
9192 1083917-07-161 Fong Bongkot Yok Thai Massage 151 Rolph St San Francisco 1 CA 1 94112 28 05/22/2015 05/30/2017 07/19/2016 05/30/2017             0 0     11 Excelsior 23    
9197 1084264-07-161 Other Minds Inc Other Minds 2150 Allston Way #240 Berkeley 35 CA 1 94704 292 03/01/1993   03/01/1993   55 Taylor St San Francisco 1 94102 16 CA     0 0            
9199 1084658-07-161 Zemikael Tesfamakiam Tesfamakiam Zemikael 1601 165th Ave 143 San+leandro 15 CA 1 94578 293 07/22/2016   07/22/2016   1601 165th Ave 143 San Leandro 25 94578 562 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
9201 1084753-07-161 Keith Bodziak Keith Bodziak Photography 50 Capra Way Apt 10 San Francisco 1 CA 1 94123 3 01/01/2016   01/01/2016   548 Brannan St 309 Apt San Francisco 1 94107 47 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     2 Marina 2    
9204 1085188-07-161 Michael Wong Michael Wong 540 Scott St San Francisco 1 CA 1 94117 33 05/25/1999   05/25/1999   423 Broadway # 638 Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     5 7 Hayes Valley 10    
9206 1082617-07-161 Vocate, Inc. Vocate 415 Jackson St Ste B San Francisco 1 CA 1 94111 35 01/01/2016   01/01/2016   655 4th St 1 Fl San Francisco 1 94107 47 CA     0 0     3 1 Chinatown 7    
9208 1085384-07-161 Arizona State University Arizona State University Po Box 875812 Tempe 184 AZ 21 85287 294 01/16/2009   01/16/2009   Po Box 875812 Tempe 369 85287 563 AZ     0 0            
9209 1082838-07-161 Michael Bargo Michael Bargo 382 Head St San Francisco 1 CA 1 94132 32 07/01/2016 05/31/2017 07/01/2016 05/31/2017             0 0     11 Oceanview/Merced/Ingleside 27    
9211 1083003-07-161 Talent Circles Talent Circles 1150 Bayhill Dr San+bruno 6 CA 1 94066 13 07/17/2011   07/17/2011   1150 Bayhill Drive San Bruno 12 94066 27 CA     0 0            
9212 1085796-07-161 Lee Sam Sam Lee 68 Bellevue Ave Daly+city 40 CA 1 94014 97 07/25/2016   07/25/2016   68 Bellevue Ave Daly City 11 94014 26 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
9213 1083432-07-161 Ryan Perez Ryan Perez 78 Vendome Daly+city 40 CA 1 94014 97 05/04/2015   05/04/2015   78 Vendome Daly City 11 94014 26 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
9216 1086376-08-161 Famous 4 Colors Llc Famous 4 Colors 54 Cerritos Ave San Francisco 1 CA 1 94127 31 08/01/2016   08/01/2016   54 Cerritos Ave San Francisco 1 94127 46 CA 4200-4299 7 Wholesale Trade 7 0 0            
9218 1081257-07-161 Excelsior Running Club Excelsior Running Club 968 Palm Ave San+mateo 61 CA 1 94401 178 01/01/2005   01/01/2005   968 Palm Ave San Mateo 32 94401 220 CA     0 0            
9224 1086869-08-161 Pirl Technology, Inc. Not Applicable 3659 Mission San+francisco 8 CA 1 94110 18 08/04/2016   08/04/2016   3659 Mission San Francisco 1 94110 37 CA 3100-3399 10 Manufacturing 10 0 0            
9229 1082068-07-161 The Lotus Method The Lotus Method 3989 24th St San Francisco 1 CA 1 94114 34 04/01/2014   04/11/2016   680 Mission St #34t San Francisco 1 94105 5 CA     0 0            
9231 1082167-07-161 F & H Fire Protection The Universal Church 1119 Westminster Ave Alhambra 185 CA 1 91803 295 07/11/2016   07/11/2016   1119 Westminster Ave Alhambra 94 91803 564 CA 2300-2399 6 Construction 6 0 0            
9236 1085093-07-161 Anthony Mbugua Uber 4231 Loch Ln San+leandro 15 CA 1 94578 293 01/01/2016 01/01/2016 01/01/2016 01/01/2016         4800-4999 12 Transportation and Warehousing 12 0 0            
9237 1082512-07-161 Redf Redf 221 Main St 1550 San Francisco 1 CA 1 94105 7 11/14/2003   11/14/2003   2 Embarcadero Ctr Ste San Francisco 1 94111 11 CA     0 0            
9238 1079937-06-161 Murphy Anthony Murphy Anthony Po Box 70515 Richmond 47 CA 1 94807 296 12/20/2010   12/20/2010   Po Box 70515 Richmond 98 94801 149 CA     0 0            
9241 1085685-07-161 Universal Atlantic Systems, Inc. Uas Inc. 45 Industrial Blvd Paoli 186 PA 9 19301 297 01/01/2014   01/01/2014   45 W Industrial Blvd Paoli 370 19301 565 PA     0 0            
9242 1088699-08-161 Au Lai Yee Lai Yee Au 48 Peabody St San Francisco 1 CA 1 94134 26 08/02/2016   08/02/2016   48 Peabody St San Francisco 1 94134 23 CA     0 0     10 4 Visitacion Valley 37    
9244 1085838-07-161 Yale Residences Llc Yale Residences Llc 633 Larkin St San Francisco 1 CA 1 94109 24 03/15/2016   03/15/2016   2149 Powell St San Francisco 1 94133 9 CA     0 1     6 3 Tenderloin 11    
9245 1089004-08-161 Rommel Sarangelo Uber/lyft 1829 Santa Rita Dr Pittsburg 187 CA 1 94565 166 07/01/2016   07/01/2016   1829 Santa Rita Dr Pittsburg 233 94565 336 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
9247 1083556-07-161 All City Alarm Inc All City Alarm Inc 520 Davey Glen Rd Belmont 161 CA 1 94002 256 01/01/1994   01/01/1994   520 Davey Glen Rd Belmont 30 94002 55 CA     0 0            
9249 1083741-07-161 Logicmonitor, Inc Logicmonitor, Inc 12 Carrillo St Santa+barbara 188 CA 1 93101 298 04/01/2016   04/01/2016   12 E Carrillo St Santa Barbara 279 93101 566 CA     0 0            
9253 1086771-08-161 K W Painting Inc K W Painting Inc 368 Sweeney St San Francisco 1 CA 1 94134 26 08/01/2016   08/01/2016   368 Sweeney St San Francisco 1 94134 23 CA     0 0     9 8 Portola 18    
9258 1090095-08-161 Acq, Chad Feiner Acq 1327 Magnolia Ave. San+carlos 34 CA 1 94070 60 08/14/2016   08/14/2016   1327 Magnolia Ave. San Carlos 164 94070 240 CA     0 0            
9261 1084584-07-161 Guardian Protection Services O O O 189 PA 9 0 5 06/01/2015   06/01/2015   174 Thorn Hill Rd. Warrendale 371 15086 567 PA     0 0            
9264 1090743-08-161 Comfort Pro Comfort Pro 1000 White Oak Ct Vacaville 103 CA 1 95687 162 08/19/2016   08/19/2016   Po Box 1122 Vacaville 229 95696 568 CA     0 0            
9265 1090809-08-161 Devin Reed Driver 1024 Sierra Bonita Ave Apt 9 West+hollywood 190 CA 1 90046 299 02/01/2016 03/01/2017 02/01/2016 03/01/2017         4800-4999 12 Transportation and Warehousing 12 0 0            
9267 1079908-06-161 Brown Mildred Brown Mildred 1625 Eddy St San Francisco 1 CA 1 94115 4 07/01/2007   07/01/2007   1625 Eddy St San Francisco 1 94115 2 CA     0 0     5 7 Western Addition 29    
9271 1085348-07-161 Thompson Erin Thompson Erin Po Box 330220 San+francisco 8 CA 1 94133 11 07/26/2007   07/26/2007   Po Box 330220 San Francisco 1 94133 9 CA     0 0            
9272 1088263-08-161 Wali Ehsan Ehsan Wali 4362 Wilson Ln Concord 20 CA 1 94521 98 04/01/2015 07/01/2016 04/01/2015 07/01/2016         4800-4999 12 Transportation and Warehousing 12 0 0            
9275 1091458-08-161 Maurice Gamble Uber 5933 E.17th St Oakland 16 CA 1 94621 205 08/01/2016   08/01/2016   0000 Undeliverable Mail San Francisco 1 99999 12 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
9280 1091589-08-161 Daiso California Llc Daiso Japan 3251 20th Ave #137 San+francisco 8 CA 1 94132 32 07/12/2009   08/19/2016   26523 Danti Court Hayward 82 94545 123 CA 4400-4599 3 Retail Trade 3 0 0            
9287 1086069-08-161 Northern California Tile And Stone Inc Tesla San Francisco Service Plus T.i 999 Van Ness Ave San Francisco 1 CA 1 94109 24 07/30/2016   07/30/2016   6341 Sky Creek Dr San Francisco 1 95828 569 CA 2300-2399 6 Construction 6 0 0            
9293 1095681-08-161 Robert Sheets Robert Sheets 738 Roosevelt Ave Redwood+city 50 CA 1 94061 80 07/10/2016   07/10/2016   738 Roosevelt Ave Redwood City 21 94061 39 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
9294 1095725-08-161 Jerry Ye Jerry Ye 38488 Botany Green Fremont 64 CA 1 94536 119 08/25/2016 05/13/2017 08/25/2016 05/13/2017             0 0            
9295 1086564-08-161 Madison Sweitzer Vreela 421 Hickory St San Francisco 1 CA 1 94102 16 08/03/2016   08/03/2016   421 Hickory St San Francisco 1 94102 16 CA 4400-4599 3 Retail Trade 3 0 0     5 7 Hayes Valley 10    
9297 1096006-08-161 Uber Uber 820 A St Apt 83 Hayward 38 CA 1 94541 109 10/15/2015   10/15/2015   820 W A St 83 Apt Hayward 82 94541 244 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
9299 1096055-08-161 Jerry Murray Rideshare Driver 609 Third Ave Half+moon+bay 191 CA 1 94019 300 01/01/2016 06/01/2016 01/01/2016 06/01/2016             0 0            
9302 1096218-08-161 Mokbel Almaylaa Mokbel Almaylaa 141 Nyla Ave South+san+francisco 83 CA 1 94080 17 10/10/2015   10/10/2015   141 Nyla Ave South San Francisco 136 94080 13 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
9306 1090235-08-161 Alex.c Alex.c 8501 Banner Ct Ct Antelope 192 CA 1 95843 301 08/14/2016 05/06/2017 08/14/2016 05/06/2017         4800-4999 12 Transportation and Warehousing 12 0 0            
9315 1090894-08-161 Adrian Rosales Uber 12344 Semora Pl Cerritos 193 CA 1 90703 302 11/08/2014 11/08/2014 11/08/2014 11/08/2014         4800-4999 12 Transportation and Warehousing 12 0 0            
9316 1084737-07-161 Tauheed Mitchell Tauheed Mitchell 2000 Linden St Apt 22 Oakland 16 CA 1 94607 106 11/01/2015   11/01/2015   2000 Linden St 22 Apt Oakland 27 94607 223 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
9317 1088044-08-161 Ames Mary Sabellano Ames Uber Rideshare 7169 Po Box 7169 San+francisco 8 CA 1 94122 19 07/01/2016   08/01/2016   Po Box 7169 Santa Cruz 199 95061 410 CA     0 0            
9319 1084960-07-161 Now Voyager Corp Now Voyager Corp 4115 19th St San Francisco 1 CA 1 94114 34 10/08/1984   10/08/1984   4115 19th St San Francisco 1 94114 43 CA     0 0            
9320 1091300-08-161 Full Bright Properties Llc 1554 Market Project 1554 Market St San Francisco 1 CA 1 94102 16 10/28/2015   10/28/2015   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0            
9321 1088234-08-161 Haresh Idnani Haresh Idnani 521 Pimlico Ct Walnut+creek 32 CA 1 94597 139 08/15/2015   08/15/2015   521 Pimlico Ct Walnut Creek 4 94597 140 CA     0 0            
9323 1091417-08-161 Abdullah Rahim Uber Sf 10124 Swann Way Elk+grove 114 CA 1 95757 288 06/27/2016   06/27/2016   10124 Swann Way Elk Grove 257 95757 560 CA 4800-4999 12 Transportation and Warehousing 12 0 0            
9325 1097716-08-161 Baron Lee Baron Lee 1657 Clement St Apt 4 San Francisco 1 CA 1 94121 15 08/26/2016   08/26/2016   1657 Clement St 4 Apt San Francisco 1 94121 17 CA     0 0     1 6 Outer Richmond 9    

Next page

Advanced export

JSON shape: default, array

CSV options:

CREATE TABLE "Registered_Business_Locations_-_San_Francisco" (
"Location Id" TEXT,
  "Business Account Number" INTEGER,
  "Ownership Name" TEXT,
  "DBA Name" TEXT,
  "Street Address" TEXT,
  "City" INTEGER,
  "State" INTEGER,
  "Source Zipcode" INTEGER,
  "Business Start Date" TEXT,
  "Business End Date" REAL,
  "Location Start Date" TEXT,
  "Location End Date" REAL,
  "Mail Address" TEXT,
  "Mail City" INTEGER,
  "Mail Zipcode" INTEGER,
  "Mail State" TEXT,
  "NAICS Code" INTEGER,
  "NAICS Code Description" INTEGER,
  "Parking Tax" INTEGER,
  "Transient Occupancy Tax" INTEGER,
  "LIC Code" REAL,
  "LIC Code Description" REAL,
  "Supervisor District" INTEGER,
  "Neighborhoods - Analysis Boundaries" INTEGER,
  "Business Corridor" INTEGER,
  "Business Location" TEXT
,
FOREIGN KEY ("Neighborhoods - Analysis Boundaries") REFERENCES [Neighborhoods - Analysis Boundaries](id),
    FOREIGN KEY ("NAICS Code Description") REFERENCES [NAICS Code Description](id),
    FOREIGN KEY ("NAICS Code") REFERENCES [NAICS Code](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("Mail Zipcode") REFERENCES [Mail Zipcode](id),
    FOREIGN KEY ("Source Zipcode") REFERENCES [Source Zipcode](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("Supervisor District") REFERENCES [Supervisor District](id),
    FOREIGN KEY ("Business Corridor") REFERENCES [Business Corridor](id),
    FOREIGN KEY ("Mail City") REFERENCES [Mail City](id))
Powered by Datasette · Query took 1439.214ms · Data source: data.sfgov.org