Taxonomy: Transactions

ColumnTypeDescriptionExample
useridstringUnique User ID9F8134BC4A372DDEE0A9E41D20FBC061B6084468
transactionidstringUnique Transaction IDMBOY9BJX55S5EBWPD1QATQ9BJVQKYNHMM7DWE
authorized_datedateDate user authorizes purchase2022-05-07
transaction_datedateDate bank authorizes purchase; can be several days after authorized date; otherwise known as the posted date2022-05-09
clean_merchant_namestringMerchant name field that has been processed for data hygieneWalmart
merchant_namestringMerchant NameWALMART
transaction_namestringTransaction NameWALMART
amountfloatTransaction Total Amount96.21
payment_channelstringonline, in-store, or otherin store
category_level1stringTransaction Category Level 1SHOPS
category_level2stringTransaction Category Level 2SUPERMARKETS AND GROCERIES
category_level3stringTransaction Category Level 3
num_levelsintNumber of Category Levels (how many categories exist for this transaction)2
primary_personal_finance_categorystringPrimary Transaction Category, will soon replace Transaction Category Level 1GENERAL MERCHANDISE
detailed_personal_finance_categorystringDetailed Transaction Category, will soon replace Transaction Category Level 2SUPERSTORES
merchant_addressstringMerchant Street Address5710 MCFARLAND BLVD
merchant_citystringMerchant CityNORTHPORT
merchant_statestringMerchant State AbbreviationAL
merchant_zipstringMerchant Zip Code35476