Basically name of standard attributes stored in LWCFlexAttDefinition database table. please refer below query which give name of standard attribute and related type.
Example:
Note: I have created query for specific attribute:
SELECT LWCFlexAttDefinition.IDA3A5,LWCFlexAttDefinition.NAME AS"lOCAL ATTRIBUTE",lwctypedefinition.IDA2A2,lwctypedefinition.NAME AS"Type NAME" FROM LWCFlexAttDefinition,lwctypedefinition WHERE LWCFlexAttDefinition.IDA3A5=lwctypedefinition.IDA2A2 AND LWCFlexAttDefinition.NAME LIKE 'Local_Tst'