home / registered-business-locations

Registered_Business_Locations_-_San_Francisco

Data source: data.sfgov.org

226,184 rows sorted by Business Start Date

View and edit SQL

Suggested facets: NAICS Code Description, Supervisor District, 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
36675 0370837-01-001 Columbus Day Celebration Inc Columbus Day Celebration Inc 678 Green St San Francisco 1 CA 1 94133 11 01/01/1941   01/01/1941   678 Green St San Francisco 1 94133 9 CA     0 0     3 1 Chinatown 7   678 GREEN ST San Francisco, CA 94133 (37.79936, -122.41022)
90872 0467968-01-001 Little Sisters Of The Poor Little Sisters Of The Poor 300 Lake St San Francisco 1 CA 1 94118 6 01/01/1941   01/01/1941   300 Lake Street San Francisco 1 94118 28 CA     0 0 H26 Restaurant Greater Than 2,000 Sqft 2 Inner Richmond 21   300 LAKE ST San Francisco, CA 94118 (37.786775, -122.462513)
69433 0438264-01-001 American Jewish Committee Inc American Jewish Committee 121 Steuart St 405 San Francisco 1 CA 1 94105 7 01/01/1945   01/01/1945   165 E 56th St New York 49 10022 434 NY     0 0     6 3 Financial District/South Beach 1   121 STEUART ST San Francisco, CA 94105 (37.792888, -122.392751)
25812 0334899-01-001 The University Corp, Sf State Village At Centennial Square 1600 Holloway Ave C6 San Francisco 1 CA 1 94132 32 01/01/1946   01/01/1946 04/26/2014 1600 Holloway Ave Adm 350 San Francisco 1 94132 56 CA     0 0     7 9 Lakeshore 31   1600 HOLLOWAY AVE San Francisco, CA 94132 (37.720848, -122.477023)
25813 0334899-02-001 The University Corp, Sf State Whirlwind Wheelchair Intl 1600 Holloway Ave Sci 251 San Francisco 1 CA 1 94132 32 01/01/1946   01/01/1953 07/01/2014 1600 Holloway Ave Adm 350 San Francisco 1 94132 56 CA     0 0     7 9 Lakeshore 31   1600 HOLLOWAY AVE San Francisco, CA 94132 (37.720848, -122.477023)
25814 0334899-03-001 The University Corp, Sf State Campus Copy Center 1650 Holloway Ave Plz Lvl San Francisco 1 CA 1 94132 32 01/01/1946   07/01/2012 08/01/2017 1600 Holloway Ave Adm 350 San Francisco 1 94132 56 CA     0 0     7 9 Lakeshore 31   1650 HOLLOWAY AVE PLZ LVL San Francisco, CA 94132
25815 0334899-04-001 The University Corp, Sf State Lobby Shop 1650 Holloway Ave Plz Lvl San Francisco 1 CA 1 94132 32 01/01/1946   07/01/2012   1600 Holloway Ave Adm 350 San Francisco 1 94132 56 CA     0 0 H03 Retail Mkts W/o Prep (Under 5,001) 7 9 Lakeshore 31   1650 HOLLOWAY AVE PLZ LVL San Francisco, CA 94132
25816 0334899-05-001 The University Corp, Sf State Healthy U 1650 Holloway Ave Plz Lvl San Francisco 1 CA 1 94132 32 01/01/1946   07/01/2012   1600 Holloway Ave Adm 350 San Francisco 1 94132 56 CA     0 0 H03 Retail Mkts W/o Prep (Under 5,001) 7 9 Lakeshore 31   1650 HOLLOWAY AVE PLZ LVL San Francisco, CA 94132
63587 0427887-01-001 Anasazi Properties Inc Anasazi Properties Inc 1600 Webster St San Francisco 1 CA 1 94115 4 01/01/1946   01/01/1946   1601 Larkin St 100 San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     5 7 Japantown 22   1600 WEBSTER ST San Francisco, CA 94115 (37.785593, -122.431329)
201992 1156579-08-171 The University Corp, Sf State Ctrl+p Digital Print Shop 1650 Holloway Ave San Francisco 1 CA 1 94132 32 01/01/1946   08/01/2017   1600 Holloway Ave Adm 350 San Francisco 1 94132 56 CA 5600-5699 16 Administrative and Support Services 16 0 0            
20823 0314730-01-001 Variety Club Of No. Ca Variety Club Of No. Ca 582 Market St 101 San Francisco 1 CA 1 94104 1 01/01/1947   01/01/1947   582 Market St San Francisco 1 94104 1 CA 8100-8139 5 Multiple 13 0 0     3 1 Financial District/South Beach 1   582 MARKET ST San Francisco, CA 94104 (37.78926, -122.401407)
41525 0383792-01-001 Potrero Hill Neighborhood Hse Potrero Hill Neighborhood Hse 953 De Haro St San Francisco 1 CA 1 94107 22 01/01/1947   01/01/1947   953 953 De Haro St St San Francisco 1 94107 47 CA 7100-7199 14 Arts, Entertainment, and Recreation 14 0 0 D04 H23 Multiple 10 4 Potrero Hill 28   953 DE HARO ST San Francisco, CA 94107 (37.758212, -122.400976)
43028 0387364-01-001 Mental Health Assoctn Of Sf Mental Health Assocatn Of Sf 870 Market St #928 San+francisco 8 CA 1 94102 16 01/01/1947   01/01/1947   870 Market St #928 San Francisco 1 94102 16 CA 5100-5199 6100-6299 8100-8139 145 Multiple 13 0 0           870 MARKET ST San Francisco, CA 94102 (37.784761, -122.407108)
165210 1080744-07-161 United Nations Assocs Of Sf United Nations Assocs Of Sf 3220 Sacramento St San Francisco 1 CA 1 94115 4 01/01/1947   01/01/1947   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0     2 Presidio Heights 3    
165659 1081331-07-161 S F Psychoanalytic Institute S F Psychoanalytic Institute 2420 Sutter St San Francisco 1 CA 1 94115 4 01/01/1947   01/01/1947   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0     2 Pacific Heights 16    
91050 0468207-01-001 Saint Luke's School Sls School 1755 Clay St San Francisco 1 CA 1 94109 24 01/01/1948   01/01/1948 10/14/2014 1335 Sutter Street San Francisco 1 94109 7 CA 6100-6299 4 Private Education and Health Services 4 0 0     3 1 Nob Hill 17   1755 CLAY ST San Francisco, CA 94109 (37.792249, -122.422128)
143189 1038491-09-151 Saint Luke's School Sls School 1335 Sutter St San Francisco 1 CA 1 94109 24 01/01/1948   10/01/2014   1335 Sutter Street San Francisco 1 94109 7 CA 6100-6299 4 Private Education and Health Services 4 0 0           1335 SUTTER ST SAN FRANCISCO, CA 94109 (37.787474, -122.422392)
144306 1040516-09-151 Associated Students Inc Associated Students Inc 1650 Holloway Ave C-134 San Francisco 1 CA 1 94132 32 01/01/1948   01/01/1948   1650 Holloway Ave C-134 San Francisco 1 94132 56 CA     0 0           1650 HOLLOWAY AVE SAN FRANCISCO, CA 94132 (37.72091, -122.478945)
39269 0377995-01-001 Board Of Trts Of The Glide Fou Board Of Trts Of The Glide Fou 330 Ellis St San Francisco 1 CA 1 94102 16 01/01/1949   01/01/1949   330 Ellis St San Francisco 1 94102 16 CA     0 0     6 3 Tenderloin 11   330 ELLIS ST San Francisco, CA 94102 (37.785017, -122.411661)
146625 1044632-11-151 Board Of Trts Of The Glide Fou Glide 330 Ellis St San Francisco 1 CA 1 94102 16 01/01/1949   01/01/1949   330 Ellis St San Francisco 1 94102 16 CA     0 0           330 ELLIS ST SAN FRANCISCO, CA 94102 (37.785017, -122.411661)
45261 0392796-01-001 Unity Church San Francisco Unity San Francisco Foundation 2224 Bush St C San Francisco 1 CA 1 94115 4 01/01/1950   01/01/1950   2222 Bush St San Francisco 1 94115 2 CA     0 0     5 7 Pacific Heights 16   2224 BUSH ST C San Francisco, CA 94115 (37.786964, -122.433917)
133690 1022604-03-151 West Portal Merchants Association West Portal Merchants Association 236 West Portal Ave 313 San Francisco 1 CA 1 94127 31 01/01/1950   01/01/1950   236 West Portal Ave 313 San Francisco 1 94127 46 CA     0 0     7 9 West of Twin Peaks 26   236 WEST PORTAL AVE SAN FRANCISCO, CA 94127 (37.738551, -122.468448)
186712 1125990-11-161 Harold Parker Properties, Lp 186 Commonwealth 1844 Union Street San Francisco 1 CA 1 94123 3 01/01/1950   01/01/1950   1844 Union Street San Francisco 1 94123 48 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Marina 2    
25533 0334093-01-001 San Francisco Art Institute San Francisco Art Institute 800 Chestnut St San Francisco 1 CA 1 94131 14 01/01/1952   01/01/1952   800 Chestnut St San Francisco 1 94133 9 CA 6100-6299 4 Private Education and Health Services 4 0 0 D04 Places Of Public Assembly & Open-Air Assembly       800 CHESTNUT ST San Francisco, CA 94131 (37.803265, -122.417126)
41603 0384034-01-001 Temple United Meth Chrch Of Sf Temple United Meth Chrch Of Sf 1111 Junipero Serra Blvd San Francisco 1 CA 1 94132 32 01/01/1953   01/01/1953   1111 Junipero Serra Blvd San Francisco 1 94132 56 CA     0 0     11 Oceanview/Merced/Ingleside 27   1111 JUNIPERO SERRA BLVD San Francisco, CA 94132 (37.717454, -122.4725)
120589 0951672-01-001 Order Of Malta Western Assoc Order Of Malta 465 California St 450 San Francisco 1 CA 1 94104 1 01/01/1953   01/01/1953   465 California St 818 San Francisco 1 94104 1 CA 5600-5699 16 Administrative and Support Services 16 0 0     3 1 Financial District/South Beach 1   465 CALIFORNIA ST San Francisco, CA 94104 (37.792937, -122.402185)
79338 0453498-01-001 Sf Zoological Society Sf Zoological Society 1 Zoo Road San Francisco 1 CA 1 94132 32 01/01/1954   01/01/1954   1 Zoo Road San Francisco 1 94132 56 CA 7100-7199 14 Arts, Entertainment, and Recreation 14 0 0 D03 D18 D19 D26 Multiple 7 9 Lakeshore 31   1 ZOO ROAD San Francisco, CA 94132 (37.730346, -122.502199)
164806 1080068-06-161 Sf Culinary/service Empl. Pnsn Sf Culinary/service Empl. Pnsn 642 Harrison St San Francisco 1 CA 1 94107 22 01/01/1956   01/01/1956   1182 Market St #320 San Francisco 1 94102 16 CA     0 0     6 3 Financial District/South Beach 1    
36726 0371004-01-001 Young Audiences Of Ncalifornia Young Audiences Of Ncalifornia 125 Stillman St San Francisco 1 CA 1 94107 22 01/01/1957   01/01/1957   465 California Street 433 San Francisco 1 94104 1 CA 7100-7199 14 Arts, Entertainment, and Recreation 14 0 0     6 3 South of Market 15   125 STILLMAN ST San Francisco, CA 94107 (37.781251, -122.397024)
147316 1045866-12-151 The Nature Conservancy The Nature Conservancy 4245 Fairfax Dr 100 Arlington 574 VA 5 22203 1086 01/01/1957   01/01/1957   201 Mission St 4th San Francisco 1 94105 5 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           4245 FAIRFAX DR ARLINGTON, VA 22203 (38.88223, -77.112288)
147318 1045868-12-151 The Nature Conservancy The Nature Conservancy 201 Mission St 4th Flr San Francisco 1 CA 1 94105 7 01/01/1957   01/01/1957   201 Mission St 4th San Francisco 1 94105 5 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     6 3 Financial District/South Beach 1   201 MISSION ST FLR SAN FRANCISCO, CA 94105 (37.791663, -122.395179)
40530 0381341-01-001 Whitney Young Child Dev Cntrs Whitney Young Child Dev Cntrs 100 Whitney Young Cr San Francisco 1 CA 1 94124 8 01/01/1958   01/01/1958   1101 Masonic Ave San Francisco 1 94117 80 CA 5600-5699 16 Administrative and Support Services 16 0 0     10 4 Bayview Hunters Point 4   100 WHITNEY YOUNG CR San Francisco, CA 94124 (37.733698, -122.384692)
40531 0381341-02-001 Whitney Young Child Dev Cntrs Faces Sf 1101 Masonic Ave San Francisco 1 CA 1 94117 33 01/01/1958   07/01/2011   1101 Masonic Ave San Francisco 1 94117 80 CA 5600-5699 16 Administrative and Support Services 16 0 0     5 7 Haight Ashbury 32   1101 MASONIC AVE San Francisco, CA 94117 (37.770939, -122.445499)
42328 0385885-01-001 California Tennis Club California Tennis Club 1770 Scott St San Francisco 1 CA 1 94115 4 01/01/1958   01/01/1958   1770 Scott St San Francisco 1 94115 2 CA 4400-4599 7100-7199 7220-7229 144 Multiple 13 0 0 H24 Restaurant Less Than 1,000 Sqft 2 Pacific Heights 16   1770 SCOTT ST San Francisco, CA 94115 (37.785881, -122.438297)
30066 0350591-01-002 Spur Spur 654 Mission St San Francisco 1 CA 1 94105 7 01/01/1959   01/01/1959   654 Mission St San Francisco 1 94105 5 CA     0 0 D04 Places Of Public Assembly & Open-Air Assembly 6 3 Financial District/South Beach 1   654 MISSION ST San Francisco, CA 94105 (37.786911, -122.40119)
30067 0350591-02-001 Spur Subart 654 Mission St San Francisco 1 CA 1 94105 7 01/01/1959   10/02/2012   654 Mission St San Francisco 1 94105 5 CA     0 0     6 3 Financial District/South Beach 1   654 MISSION ST San Francisco, CA 94105 (37.786911, -122.40119)
225416 1090540-08-161 Spur Spur Urban Center 654 Mission St San Francisco 1 CA 1 94105 7 01/01/1959   08/18/2016   654 Mission St San Francisco 1 94105 5 CA     0 0            
14733 0190757-01-999 Simco Electronics Simco Electronics 1178 Bordeaux Drive Sunnyvale 135 CA 1 94089 260 01/01/1962   01/01/1962   3131 Jay Street Suite 100 St Santa Clara 188 95054 521 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           1178 BORDEAUX DRIVE Sunnyvale, CA 94089 (37.40638, -122.023183)
60308 0421910-01-001 Sf Women's Rehabilitation Fnd Stepping Stone 255 10th Ave San Francisco 1 CA 1 94118 6 01/01/1962   01/01/1962   255 10th Ave San Francisco 1 94118 28 CA 6100-6299 4 Private Education and Health Services 4 0 0     1 6 Inner Richmond 21   255 10TH AVE San Francisco, CA 94118 (37.783583, -122.468773)
165876 1081631-07-161 Sf African Amer Hist & Cult Sf African Amer Hist & Cult 762 Fulton St 2 San Francisco 1 CA 1 94102 16 01/01/1962   01/01/1962   762 Fulton St 2nd Fl San Francisco 1 94102 16 CA     0 0     5 7 Western Addition 29    
36045 0369039-02-001 San Francisco Education Fund San Francisco Education Fund 727 Golden Gate Ave 2nd Fl San Francisco 1 CA 1 94102 16 01/01/1963   07/01/2009   2730 Bryant St 2nd Fl San Francisco 1 94110 37 CA     0 0     5 7 Western Addition 29   727 GOLDEN GATE AVE San Francisco, CA 94102 (37.780697, -122.423036)
44839 0391752-01-001 Smith-Kettle Well Eye Research Smith-Kettle Well Eye Research 2318 Fillmore St San Francisco 1 CA 1 94115 4 01/01/1963   01/01/1963   2318 Fillmore Street San Francisco 1 94115 2 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     2 Pacific Heights 16   2318 FILLMORE ST San Francisco, CA 94115 (37.791115, -122.434297)
130365 1016645-01-151 Smith-Kettle Well Eye Research Smith-Kettlewell Eye Research Institute 2232 Webster St San Francisco 1 CA 1 94115 4 01/01/1963   03/01/1970 02/08/2017 2318 Fillmore Street San Francisco 1 94115 2 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     2 Pacific Heights 16   2232 WEBSTER ST SAN FRANCISCO, CA 94115 (37.791354, -122.432675)
39834 0379585-02-001 Eoc,inc Economic Opportunity Council 2155 San Jose Ave San Francisco 1 CA 1 94134 26 01/01/1964   01/01/1989   1426 Fillmore Street #301 San Francisco 1 94115 2 CA     0 0     11 Outer Mission 35   2155 SAN JOSE AVE San Francisco, CA 94134 (37.722106, -122.445453)
39835 0379585-03-001 Eoc,inc Chinatown-No. Beach Child Care 715 Chestnut St San Francisco 1 CA 1 94133 11 01/01/1964   09/01/1969   1426 Fillmore Street #301 San Francisco 1 94115 2 CA     0 0     3 1 Russian Hill 5   715 CHESTNUT ST San Francisco, CA 94133 (37.803509, -122.415259)
49882 0399412-01-001 Teen Challenge Teen Challenge 1464 Valencia San+francisco 8 CA 1 94110 18 01/01/1964   01/01/1964   1464 Valencia San Francisco 1 94110 37 CA     0 0           1464 VALENCIA San Francisco, CA 94110 (37.749449, -122.420404)
16898 0206666-01-001 Mccoppin St Inc Mccoppin St Inc 133 Mccoppin St San Francisco 1 CA 1 94103 25 01/01/1965 05/31/2015 01/01/1965 05/31/2015             0 0     8 5 Mission 12 Market/Castro 5 133 MCCOPPIN ST San Francisco, CA 94103 (37.771585, -122.42279)
102182 0480006-01-001 Guardian Life Insur Co Of Amer Guardian Life Insur Co Of Amer 555 Montgomery St 1600 San Francisco 1 CA 1 94111 35 01/01/1965   01/01/1965   7 Hanover Square H 15 D New York 49 10004 1265 NY 5240-5249 20 Insurance 17 0 0     3 1 Chinatown 7   555 MONTGOMERY ST San Francisco, CA 94111 (37.794454, -122.403102)
16480 0191910-01-999 Time Clock Sales Serv Co Inc Time Clock Sales Serv Co Inc 99 So San Francisco Brisbane Q4068 65   0 5 01/01/1966   01/01/1966   2950 Airway Av #D-7 Costa Mesa 546 92626 878 CA     0 0           99 SO 00000
36645 0370778-01-001 American Conservatory Theater American Conservatory Theater 30 Grant Ave San Francisco 1 CA 1 94108 9 01/01/1966   01/01/1966   30 Grant Ave San Francisco 1 94108 22 CA 7100-7199 14 Arts, Entertainment, and Recreation 14 0 0     3 1 Financial District/South Beach 1   30 GRANT AVE San Francisco, CA 94108 (37.787443, -122.404988)
36646 0370778-01-002 American Conservatory Theater American Conservatory Theater 415 Geary Street San Francisco 1 CA 1 94102 16 01/01/1966   01/01/1966   30 Grant Ave San Francisco 1 94108 22 CA 7100-7199 14 Arts, Entertainment, and Recreation 14 0 0 D15 H86 Multiple 3 1 Tenderloin 11   415 GEARY STREET San Francisco, CA 94102 (37.787107, -122.410226)
43035 0387382-01-001 Bethany Center Senior Housing Bethany Center Senior Housing 580 Capp Street San Francisco 1 CA 1 94110 18 01/01/1966   01/01/1966   580 Capp Street San Francisco 1 94110 37 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     9 8 Mission 12   580 CAPP STREET San Francisco, CA 94110 (37.757455, -122.417841)
45628 0393762-01-001 United Way Of The Bay Area United Way Of The Bay Area 550 Kearny St 1000 San Francisco 1 CA 1 94108 9 01/01/1966   01/01/1966   550 Kearny Street Suite 1000 San Francisco 1 94108 22 CA     0 0     3 1 Financial District/South Beach 1   550 KEARNY ST San Francisco, CA 94108 (37.79297, -122.404505)
71312 0440849-01-001 The San Francisco School The San Francisco School 300 Gaven St San Francisco 1 CA 1 94134 26 01/01/1966   01/01/1966   300 Gaven St San Francisco 1 94134 23 CA 6100-6299 4 Private Education and Health Services 4 0 0 H91 School Cafeterias (Private W/food Prep) 9 8 Portola 18   300 GAVEN ST San Francisco, CA 94134 (37.732528, -122.411645)
84832 0460828-01-001 Sup Welfare Plan Inc Sup Welfare Plan 730 Harrisons St 415 San+francisco 8 CA 1 94107 22 01/01/1966   01/01/1966   730 Harrison St #415 San Francisco 1 94107 47 CA     0 0           730 HARRISONS ST San Francisco, CA 94107 (37.781897, -122.398229)
130384 1016675-01-151 American Conservatory Theater American Conservatory Theater 1127 Market St San Francisco 1 CA 1 94102 16 01/01/1966   02/20/2015   30 Grant Ave San Francisco 1 94108 22 CA 7100-7199 14 Arts, Entertainment, and Recreation 14 0 0 D04 H87 P23 Multiple       1127 MARKET ST SAN FRANCISCO, CA 94102 (37.77997, -122.413162)
130385 1016676-01-151 American Conservatory Theater American Conservatory Theater 1117 Market St San Francisco 1 CA 1 94102 16 01/01/1966   12/01/2013   30 Grant Ave San Francisco 1 94108 22 CA 7100-7199 14 Arts, Entertainment, and Recreation 14 0 0     6 3 South of Market 15   1117 MARKET ST SAN FRANCISCO, CA 94102 (37.780195, -122.412886)
146999 1045329-11-151 Uso Of No California Uso Of No California Terminal 1 Mezzanine Sf Iap San+francisco 8 CA 1 94128 59 01/01/1966 12/31/2011 01/01/1966 12/31/2011             0 0           1 MEZZANINE SF IAP SAN FRANCISCO, CA 94128
165058 1080490-07-161 Performing Arts Workshop Inc Performing Arts Workshop Inc 265 Fort Mason C San+francisco 8 CA 1 94123 3 01/01/1966   01/01/1966   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0            
168205 1085518-07-161 United Way Of The Bay Area United Way Bay Area 550 Kearny St 1000 San Francisco 1 CA 1 94108 9 01/01/1966   07/01/2016   550 Kearny Street Suite 1000 San Francisco 1 94108 22 CA     0 0            
217206 0370778-01-003 American Conservatory Theater American Conservatory Theater 681 Florida St San Francisco 1 CA 1 94110 18 01/01/1966   01/01/1988   30 Grant Ave San Francisco 1 94108 22 CA 7100-7199 14 Arts, Entertainment, and Recreation 14 0 0     9 8 Mission 12   681 FLORIDA ST San Francisco, CA 94110 (37.760761, -122.411019)
36610 0370687-01-001 Magic Theatre Inc The Magic Theatre Inc The Fort Mason Ctr Bldg D San+francisco 8 CA 1 94123 3 01/01/1967   01/01/1967   0 Fort Mason Ctr Bldg G San Francisco 1 94123 48 CA 7100-7199 14 Arts, Entertainment, and Recreation 14 0 0           FORT MASON CTR BLDG D San Francisco, CA 94123 (37.800677, -122.436863)
59828 0421023-01-001 Audium Inc Audium Inc 1616 Bush St San Francisco 1 CA 1 94109 24 01/01/1967   01/01/1967   112 Midcrest Way San Francisco 1 94131 14 CA 7100-7199 14 Arts, Entertainment, and Recreation 14 0 0     2 Western Addition 29   1616 BUSH ST San Francisco, CA 94109 (37.788238, -122.42387)
165443 1081042-07-161 Lycee Francais La Perouse Lycee Francais La Perouse 1201 Ortega St San Francisco 1 CA 1 94122 19 01/01/1967   01/01/1967   1201 Ortega Street San Francisco 1 94122 15 CA 6100-6299 4 Private Education and Health Services 4 0 0     4 10 Sunset/Parkside 14    
165461 1081066-07-161 Joint Action In Community Svce Joint Action In Community Svce 5225 Wisconsin Ave #404 Washington+dc 1319   20015 2922 01/01/1967   01/01/1967   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0            
165710 1081393-07-161 Mission Area Health Asscs Inc Mission Area Health Asscs Inc 240 Shotwell St San Francisco 1 CA 1 94110 18 01/01/1967   01/01/1967   240 Shotwell St San Francisco 1 94110 37 CA 6100-6299 4 Private Education and Health Services 4 0 0            
745 0040711-02-001 Cuneo Joseph D Etal 2598 Filbert Apts 2598 Filbert St San Francisco 1 CA 1 94123 3 01/01/1968 12/31/2013 01/01/1969 12/31/2013             0 0     2 Marina 2   2598 FILBERT ST San Francisco, CA 94123 (37.797215, -122.442101)
749 0040711-06-001 Cuneo Joseph D Etal 1230 Stockton St Bldg 1230 Stockton St San Francisco 1 CA 1 94133 11 01/01/1968 12/31/2013 12/01/1992 12/31/2013             0 0     3 1 Chinatown 7   1230 STOCKTON ST San Francisco, CA 94133 (37.79721, -122.408545)
750 0040711-07-001 Cuneo Joseph D Etal 56 Belden Pl Bldg 56 Belden Pl San+francisco 8 CA 1 94104 1 01/01/1968 12/31/2013 12/10/1993 12/31/2013             0 0           56 BELDEN PL San Francisco, CA 94104 (37.791444, -122.403812)
755 0040711-08-001 Cuneo Joseph D Etal 485 Pine St Bldg 485 Pine St San Francisco 1 CA 1 94104 1 01/01/1968 12/31/2013 11/09/1998 12/31/2013             0 0     3 1 Financial District/South Beach 1   485 PINE ST San Francisco, CA 94104 (37.791759, -122.403782)
757 0040711-09-001 Cuneo Joseph D Etal 471 Pine St Bldg 471 Pine St San Francisco 1 CA 1 94104 1 01/01/1968 12/31/2013 12/10/1993 12/31/2013             0 0     3 1 Financial District/South Beach 1   471 PINE ST San Francisco, CA 94104 (37.791772, -122.403676)
1062 0001155-03-002 Campana A E 745 14th St Parking Lot 745 14th St San Francisco 1 CA 1 94114 34 01/01/1968   01/01/1977   2120 Market St #100 San Francisco 1 94114 43 CA     0 0     8 5 Castro/Upper Market 30   745 14TH ST San Francisco, CA 94114 (37.767664, -122.430039)
1069 0001155-05-001 Campana A E 2120-2122 Market Bldg 2120 Market St San Francisco 1 CA 1 94114 34 01/01/1968   10/01/1968   2120 Market St #100 San Francisco 1 94114 43 CA     0 0     8 5 Castro/Upper Market 30   2120 MARKET ST San Francisco, CA 94114 (37.76718, -122.429469)
1078 0001155-07-001 Campana A E 3643-3647 17th St Building 3643 17th St San Francisco 1 CA 1 94114 34 01/01/1968   02/16/1990   2120 Market St #100 San Francisco 1 94114 43 CA     0 0     8 5 Castro/Upper Market 30   3643 17TH ST San Francisco, CA 94114 (37.762976, -122.427321)
4680 0024927-42-001 Sangiacomo Family Trust 575-579 27th St Apts 575-579 27th St San Francisco 1 CA 1 94131 14 01/01/1968   01/01/2003   1145 Market Street 12th Floor San Francisco 1 94103 32 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     8 5 Noe Valley 33   575 579 27TH ST San Francisco, CA 94131 (37.746504, -122.432853)
5245 0054345-01-001 Motorola Solutions Inc Motorola Inc 1555 Burke Ave San Francisco 1 CA 1 94124 8 01/01/1968   01/01/1968   1301 E Algonquin Rd - Swa2 Schaumburg 276 60196 399 IL 4200-4299 7 Wholesale Trade 7 0 0     10 4 Bayview Hunters Point 4   1555 BURKE AVE San Francisco, CA 94124 (37.744252, -122.385672)
5257 0032543-02-001 Chiao Johnson L & Diane W 1215 Bay Apts 1215 Bay St San Francisco 1 CA 1 94123 3 01/01/1968   01/01/1968   Po Box 641756 San Francisco 1 94164 132 CA 7210-7219 9 Accommodations 9 0 0     2 Marina 2   1215 BAY ST San Francisco, CA 94123 (37.803903, -122.427068)
5264 0032543-03-001 Chiao Johnson L & Diane W 1991 California Apts 1991 California St San Francisco 1 CA 1 94109 24 01/01/1968   05/01/1974   Po Box 641756 San Francisco 1 94164 132 CA 7210-7219 9 Accommodations 9 0 0     2 Pacific Heights 16   1991 CALIFORNIA ST San Francisco, CA 94109 (37.789777, -122.427021)
5336 0037014-01-001 Pacheu Jean 1261 8th Av Apartments 1261 8th Ave San Francisco 1 CA 1 94122 19 01/01/1968   01/01/1968   1534 Irving St #201 San Francisco 1 94122 15 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     5 7 Inner Sunset 13   1261 8TH AVE San Francisco, CA 94122 (37.764771, -122.465293)
5345 0037014-02-001 Pacheu Jean 1250 19th Av Apartments 1250 19th Ave San Francisco 1 CA 1 94122 19 01/01/1968   01/01/1984 12/31/2013 1534 Irving St #201 San Francisco 1 94122 15 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     4 10 Inner Sunset 13   1250 19TH AVE San Francisco, CA 94122 (37.764501, -122.477194)
5408 0037014-03-001 Pacheu Jean 3638 19th St Apts 3638 19th St San Francisco 1 CA 1 94110 18 01/01/1968   01/01/1968 12/31/2013 1534 Irving St #201 San Francisco 1 94122 15 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     8 5 Mission 12   3638 19TH ST San Francisco, CA 94110 (37.75991, -122.424589)
6195 0055914-02-001 Balma Eugene R 1021-29 Geneva Av Apts 1021 Geneva Ave San Francisco 1 CA 1 94134 26 01/01/1968 01/01/2014 10/01/1968 01/01/2014             0 0     11 Excelsior 23   1021 GENEVA AVE San Francisco, CA 94134 (37.715491, -122.43896)
6208 0055914-03-001 Balma Eugene R 99 Onondaga St Building 99 Onondaga Ave San Francisco 1 CA 1 94112 28 01/01/1968 01/01/2014 01/01/1973 01/01/2014             0 0     11 Outer Mission 35   99 ONONDAGA AVE San Francisco, CA 94112 (37.72202, -122.439674)
6484 0024927-45-001 Sangiacomo Family Trust 40 Edgehill Way 40 Edgehill San+francisco 8 CA 1 94127 31 01/01/1968   01/01/2003   1145 Market Street 12th Floor San Francisco 1 94103 32 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           40 EDGEHILL San Francisco, CA 94127 (37.743009, -122.460945)
8365 0047479-01-001 Lai Enterprises Inc 775 Sacramento Rentals 775 Sacramento St San Francisco 1 CA 1 94108 9 01/01/1968   01/01/1968   1168 Pacific Ave San Francisco 1 94133 9 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Chinatown 7   775 SACRAMENTO ST San Francisco, CA 94108 (37.793434, -122.405762)
8380 0024669-02-001 Safeway Inc Safeway Inc #4601 145 Jackson St San Francisco 1 CA 1 94111 35 01/01/1968   10/01/1968   Po Box 52131 Ms 5015 Phoenix 288 85027 523 AZ 4400-4599 3 Retail Trade 3 0 0 H31 H73 H81 Multiple       145 JACKSON ST San Francisco, CA 94111 (37.797051, -122.398626)
8402 0024669-04-001 Safeway Inc Safeway Inc #759 625 Monterey Blvd San Francisco 1 CA 1 94127 31 01/01/1968   10/01/1968   Po Box 52131 Ms 5015 Phoenix 288 85027 523 AZ 4400-4599 3 Retail Trade 3 0 0 H26 H31 H73 Multiple 7 9 West of Twin Peaks 26   625 MONTEREY BLVD San Francisco, CA 94127 (37.731511, -122.449537)
8410 0024669-05-001 Safeway Inc Safeway Inc #1507 2020 Market St San Francisco 1 CA 1 94114 34 01/01/1968   10/01/1968   Po Box 52131 Ms 5015 Phoenix 288 85027 523 AZ 4400-4599 3 Retail Trade 3 0 0 H73 H81 Multiple       2020 MARKET ST San Francisco, CA 94114 (37.768701, -122.427535)
8419 0024669-07-001 Safeway Inc Safeway Inc #985 2350 Noriega St San Francisco 1 CA 1 94122 19 01/01/1968   10/01/1968   Po Box 52131 Ms 5015 Phoenix 288 85027 523 AZ 4400-4599 3 Retail Trade 3 0 0 D19 H73 H81 Multiple 4 10 Sunset/Parkside 14   2350 NORIEGA ST San Francisco, CA 94122 (37.753724, -122.488472)
8437 0024669-12-001 Safeway Inc Safeway Inc #739 3350 Mission St San Francisco 1 CA 1 94110 18 01/01/1968   10/01/1968   Po Box 52131 Ms 5015 Phoenix 288 85027 523 AZ 4400-4599 3 Retail Trade 3 0 0 H31 H73 H81 Multiple 9 8 Bernal Heights 19   3350 MISSION ST San Francisco, CA 94110 (37.743283, -122.421372)
8451 0024669-13-001 Safeway Inc Safeway Inc #1490 2300 16th St San Francisco 1 CA 1 94103 25 01/01/1968   10/01/1968   Po Box 52131 Ms 5015 Phoenix 288 85027 523 AZ 4400-4599 3 Retail Trade 3 0 0 H73 H81 Multiple 10 4 Mission 12   2300 16TH ST San Francisco, CA 94103 (37.765632, -122.410113)
8467 0039246-01-001 Martorana Anthony J & Clara 301 Clipper Apts 301 Clipper St San Francisco 1 CA 1 94114 34 01/01/1968   01/01/1971   420 Hill Street San Francisco 1 94114 43 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     8 5 Noe Valley 33   301 CLIPPER ST San Francisco, CA 94114 (37.74902, -122.431912)
8479 0024669-14-001 Safeway Inc Safeway Inc #785 850 Laplaya St San+francisco 8 CA 1 94121 15 01/01/1968   10/27/1971   Po Box 52131 Ms 5015 Phoenix 288 85027 523 AZ 4400-4599 3 Retail Trade 3 0 0 D19 H73 H81 Multiple       850 LAPLAYA ST San Francisco, CA 94121 (37.772309, -122.509972)
8487 0039246-02-001 Martorana Anthony J & Clara 3440 25th St Apartments 3440 25th St San Francisco 1 CA 1 94110 18 01/01/1968   10/01/1968   420 Hill Street San Francisco 1 94114 43 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     9 8 Mission 12   3440 25TH ST San Francisco, CA 94110 (37.750594, -122.419097)
8494 0024669-15-001 Safeway Inc Safeway Inc #909 730 Taraval St San Francisco 1 CA 1 94116 23 01/01/1968   06/02/1974   Po Box 52131 Ms 5015 Phoenix 288 85027 523 AZ 4400-4599 3 Retail Trade 3 0 0 H73 H81 Multiple 7 9 West of Twin Peaks 26   730 TARAVAL ST San Francisco, CA 94116 (37.743138, -122.473882)
8498 0024669-16-001 Safeway Inc Safeway Inc #964 4950 Mission St San Francisco 1 CA 1 94112 28 01/01/1968   11/09/1980   Po Box 52131 Ms 5015 Phoenix 288 85027 523 AZ 4400-4599 3 Retail Trade 3 0 0 H26 H73 Multiple 11 Outer Mission 35   4950 MISSION ST San Francisco, CA 94112 (37.720004, -122.438349)
8534 0039246-05-001 Martorana Anthony J & Clara 385-387 Bartlett St Apts 385 Bartlett St San Francisco 1 CA 1 94110 18 01/01/1968   10/20/1989   420 Hill Street San Francisco 1 94114 43 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     9 8 Mission 12   385 BARTLETT ST San Francisco, CA 94110 (37.750857, -122.419427)
8541 0024669-19-001 Safeway Inc Safeway Inc #995 1335 Webster St San Francisco 1 CA 1 94115 4 01/01/1968   10/01/2010   Po Box 52131 Ms 5015 Phoenix 288 85027 523 AZ 4400-4599 3 Retail Trade 3 0 0 D19 H26 H73 H81 Multiple 5 7 Western Addition 29   1335 WEBSTER ST San Francisco, CA 94115 (37.782557, -122.430887)
8548 0024669-20-001 Safeway Inc Safeway Inc #1206 350 Bay St San Francisco 1 CA 1 94133 11 01/01/1968   01/01/1991   Po Box 52131 Ms 5015 Phoenix 288 85027 523 AZ 4400-4599 3 Retail Trade 3 0 0 H31 H73 H81 Multiple 3 1 North Beach 6   350 BAY ST San Francisco, CA 94133 (37.805738, -122.412646)
8558 0024669-21-001 Safeway Inc Safeway #2606 298 King St San Francisco 1 CA 1 94107 22 01/01/1968   09/10/2004   Po Box 52131 Ms 5015 Phoenix 288 85027 523 AZ 4400-4599 3 Retail Trade 3 0 0 H73 H81 Multiple       298 KING ST SAN FRANCISCO, CA 94107 (37.776541, -122.393549)

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 961.296ms · Data source: data.sfgov.org