finances/migration/merchant_clusters.md

Merchant cluster proposal

• 363 clusters from 372 accounts + 706 statement txns
• 150 auto-proposable (>=0.80, clean canonical)
• 213 NEED DANE (ambiguous / junky canonical / new merchant)

NEEDS DANE (top 40 by volume)

For each: what is the real merchant? You can type a name; it becomes a permanent rule.

• ? (conf 0.55, weight 68, 28 accts, 40 stmt) guess=Amazon
  • desc: AMAZON.COM*N428X9Q71 440 TERRY AVE N SEATTLE 98109 WA USA
  • desc: AMAZON MARK* B008Z3VV0410 TERRY AVENUE NORTH SEATTLE 98109 WA USA
  • desc: AMAZON MARK* B00SF6VV0410 TERRY AVENUE NORTH SEATTLE 98109 WA USA (RET
  • desc: AMAZON MARK* B00SF6VV0410 TERRY AVENUE NORTH SEATTLE 98109 WA USA
  • desc: AMAZON MARK* B03Y156K1410 TERRY AVENUE NORTH SEATTLE 98109 WA USA
  • desc: AMAZON MARK* B204T9M31410 TERRY AVENUE NORTH SEATTLE 98109 WA USA
  • accts: Amazon, Amazon Mark* B008z3vv0, Amazon Mark* B00sf6vv0, Amazon Mark* B00sf6vv0410 Terry Avenue North Seattle 98109 Wa Usa (return), Amazon Mark* B03y156k1, Amazon Mark* B204t9m31
• ? (conf 0.4, weight 42, 0 accts, 42 stmt) guess=Sq *La Gourmandine Oak116 Meyran Ave Pittsburgh15213 Pa Usa|Pitt Parking Pay Stati127 North
  • desc: PITT PARKING PAY STATI127 NORTH BELLEFIELD AVE PITTSBURGH 15260 PA USA
  • desc: PITT PARKING PAY STATI127 NORTH BELLEFIELD AVE PITTSBURGH15260 PA USA
• ? (conf 0.78, weight 31, 7 accts, 24 stmt) guess=McDonald's
  • desc: MCDONALD'S F1862 3708 FORBES AVE PITTSBURGH 15213 PA USA
  • desc: MCDONALDS 1862 3708 FORBES AVE PITTSBURGH 15213 PA USA
  • desc: MCDONALDS 1102 225 MOUNT LEBANON BLVD CASTLE SHANNO15234 PA USA
  • desc: MCDONALDS 5834 2518 W LIBERTY RD PITTSBURGH 15226 PA USA
  • desc: MCDONALD'S F1102 225 MT LEBANON BLVD PITTSBURGH 15234 PA USA
  • desc: MCDONALD'S F27387 1412 B MAIN STREET BURGETTSTOWN 15021 PA USA
  • accts: McDonald's, Mcdonald's F1102, Mcdonald's F1862, Mcdonald's F27387, Mcdonalds 1862, Mcdonalds 33234
• ? (conf 1.0, weight 26, 0 accts, 26 stmt) guess=Castle Shannon Shop
  • desc: CASTLE SHANNON SHOP' 799 CASTLE SHANNON BLV PITTSBURGH 15234 PA USA
  • desc: CASTLE SHANNON SHOP' 799 CASTLE SHANNON BLV PITTSBURGH15234 PA USA
• ? (conf 0.71, weight 22, 2 accts, 20 stmt) guess=Market District
  • desc: MARKET DISTRICT #0014 7000 OXFORD DR BETHEL PARK 15102 PA USA
  • desc: MARKET DISTRICT #0014 7000 OXFORD DR BETHEL PAR15102 PA USA
  • desc: MARKET DISTRICT #0047 100 SETTLERS RIDGE CENTER DR PITTSBURGH 15205 PA
  • accts: Market District, Market District Supermarket
• ? (conf 1.0, weight 17, 0 accts, 17 stmt) guess=Kuhns Banksville
  • desc: KUHNS BANKSVILLE 3125 BANKSVILLE ROAD PITTSBURGH 15216 PA USA
  • desc: KUHNS BANKSVILLE 3125 BANKSVILLE ROAD PITTSBURGH15216 PA USA
• ? (conf 0.4, weight 15, 0 accts, 15 stmt) guess=Apple Com Bill One Apple
  • desc: APPLE.COM/BILL ONE APPLE PARK WAY CUPERTINO 95014 CA USA
  • desc: APPLE.COM/US ONE APPLE PARK WAY CUPERTINO 95014 CA USA
  • desc: APPLE.COM/BILL ONE APPLE PARK CUPERTINO 95014 CA USA
• ? (conf 0.75, weight 11, 4 accts, 7 stmt) guess=Starbucks
  • desc: STARBUCKS STORE 27117 4022 FIFTH AVE PITTSBURGH 15213 PA USA
  • desc: STARBUCKS 27117 4022 5TH AVE PITTSBURGH 15213 PA USA
  • desc: STARBUCKS STORE 27117 4022 FIFTH AVE PITTSBURGH15213 PA USA
  • accts: Starbucks, Starbucks 27117, Starbucks 8007827282, Starbucks Store 27117
• ? (conf 0.4, weight 10, 0 accts, 10 stmt) guess=Claude Ai Subscription548 Market Street
  • desc: CLAUDE.AI SUBSCRIPTION548 MARKET STREET PMB 90375 SAN FRANCISCO94104 C
  • desc: CLAUDE.AI SUBSCRIPTION548 MARKET STREET PMB 90375 SAN FRANCI94104 CA U
• ? (conf 0.4, weight 10, 0 accts, 10 stmt) guess=Sq *La Gourmandine Oak116 Meyran Ave Pittsburgh15213 Pa Usa|Sq *La Gourmandine Oak116 Meyran Ave Pittsburgh 15213 Pa Usa
  • desc: SQ *LA GOURMANDINE OAK116 MEYRAN AVE PITTSBURGH 15213 PA USA
• ? (conf 1.0, weight 8, 1 accts, 7 stmt) guess=Comcast / Xfinity
  • desc: COMCAST / XFINITY 15 SUMMIT PARK DR PITTSBURGH 15275 PA USA
  • desc: COMCAST / XFINITY 15 SUMMIT PARK DR PITTSBURGH15275 PA USA
  • desc: COMCAST / XFINITY 15 SUMMIT PARK DR 800-266-2278 15275 PA USA
  • accts: Comcast / Xfinity
• ? (conf 0.45, weight 8, 8 accts, 0 stmt) guess=Compeer
  • accts: COMPEER-COMP-CP WEB PMTS ACH WEB 3Y6QDL, COMPEER-COMP-CP WEB PMTS ACH WEB 7Y648K, COMPEER-COMP-CP WEB PMTS ACH WEB D9FZ0L, COMPEER-COMP-CP WEB PMTS ACH WEB F394TK, COMPEER-COMP-CP WEB PMTS ACH WEB JS0NNK, COMPEER-COMP-CP WEB PMTS ACH WEB K7TDFK
• ? (conf 0.4, weight 8, 1 accts, 7 stmt) guess=T2
  • desc: T2* MT LEBANON PA 8900 KEYSTONE XING, SUITE 700 INDIANAPOLIS 46240 IN
  • desc: T2* MT LEBANON PA 8900 KEYSTONE XING, SUITE 700 INDIANAPOL46240 IN USA
  • accts: T2* Mt Lebanon Pa
• ? (conf 0.4, weight 8, 0 accts, 8 stmt) guess=Upmc Student Insurance600 Grant
  • desc: UPMC STUDENT INSURANCE600 GRANT ST 41ST FL PITTSBURGH 15219 PA USA
  • desc: UPMC STUDENT INSURANCE600 GRANT ST 41ST FL PITTSBURGH15219 PA USA
  • desc: UPMC STUDENT INSURANCE600 GRANT ST 41ST FL 888-499-6885 15219 PA USA
• ? (conf 0.4, weight 7, 0 accts, 7 stmt) guess=Ach Deposit Internet Transfer From
  • desc: ACH DEPOSIT INTERNET TRANSFER FROM ACCOUNT ENDING IN 7552
• ? (conf 1.0, weight 7, 0 accts, 7 stmt) guess=Ebay O
  • desc: EBAY O*07-14287-66191 2535 NORTH FIRST STREET SAN JOSE 95125 CA USA
  • desc: EBAY O*07-14287-66190 2535 NORTH FIRST STREET SAN JOSE 95125 CA USA
  • desc: EBAY O*07-14287-66189 2535 NORTH FIRST STREET SAN JOSE 95125 CA USA
  • desc: EBAY O*07-14287-66188 2535 NORTH FIRST STREET SAN JOSE 95125 CA USA
  • desc: EBAY O*07-14287-66187 2535 NORTH FIRST STREET SAN JOSE 95125 CA USA
  • desc: EBAY O*07-14287-66186 2535 NORTH FIRST STREET SAN JOSE 95125 CA USA
• ? (conf 0.9, weight 7, 1 accts, 6 stmt) guess=Needle & Bean
  • desc: SQ *NEEDLE & BEAN 320 CASTLE SHANNON BLVD PITTSBURGH15234 PA USA
  • desc: SQ *NEEDLE & BEAN 320 CASTLE SHANNON BLVD PITTSBURGH 15234 PA USA
  • accts: Needle & Bean
• ? (conf 0.4, weight 7, 0 accts, 7 stmt) guess=Sq *La Gourmandine Oak116 Meyran Ave Pittsburgh15213 Pa Usa|Sq *La Gourmandine Oak116 Meyran Ave Pittsburgh15213 Pa Usa
  • desc: SQ *LA GOURMANDINE OAK116 MEYRAN AVE PITTSBURGH15213 PA USA
• ? (conf 1.0, weight 7, 0 accts, 7 stmt) guess=Youtube Tv
  • desc: GOOGLE *YOUTUBE TV 1600 AMPHITHEATRE PKWY MOUNTAIN VIEW94043 CA USA
  • desc: GOOGLE *YOUTUBE TV 1600 AMPHITHEATRE PKWY MOUNTAIN V94043 CA USA
• ? (conf 1.0, weight 6, 0 accts, 6 stmt) guess=Daily Cash Adjustment
  • desc: DAILY CASH ADJUSTMENT
• ? (conf 0.4, weight 6, 0 accts, 6 stmt) guess=Spo P&Amp Gspamelasdiner3703 Forbes
  • desc: SPO*P&G'SPAMELA'SDINER3703 FORBES AVE PITTSBURGH 15213 PA USA
• ? (conf 0.4, weight 5, 0 accts, 5 stmt) guess=Bp 9604786Ukani Broqps2900 Banksville
  • desc: BP#9604786UKANI BROQPS2900 BANKSVILLE RD PITTSBURGH 15216 PA USA
  • desc: BP#9604786UKANI BROQPS2900 BANKSVILLE RD PITTSBURGH15216 PA USA
• ? (conf 0.69, weight 5, 1 accts, 4 stmt) guess=Peacock
  • desc: PEACOCK 75AE1 PREMIUM 30 ROCKEFELLER PLAZA NEW YORK 10112 NY USA
  • desc: PEACOCK 81D06 PREMIUM 30 ROCKEFELLER PLAZA NEW YORK 10112 NY USA
  • desc: PEACOCK EF701 PREMIUM 30 ROCKEFELLER PLAZA NEW YORK 10112 NY USA
  • desc: PEACOCK X6258 PREMIUM 30 ROCKEFELLER PLAZA NEW YORK 10112 NY USA
  • accts: Peacock
• ? (conf 0.4, weight 4, 0 accts, 4 stmt) guess=Enricos Tazza Do125 Lytton
  • desc: SQ *ENRICO'S TAZZA D'O125 LYTTON AVE PITTSBURGH 15213 PA USA
• ? (conf 0.57, weight 4, 2 accts, 2 stmt) guess=Liberty Mutual
  • desc: LIBERTY MUTUAL ATTN: COURTNEY MURPHY 225 BORT PORTSMOUTH 03801 NH USA
  • desc: LIBERTY MUTUAL ATTN: COURTNEY MURPHY 225 BORT PORTSMOUTH 03801 NH USA
  • accts: Liberty Mutual
• ? (conf 0.48, weight 4, 2 accts, 2 stmt) guess=Openai
  • desc: OPENAI 1455 3RD STREET SAN FRANCISCO94158 CA USA
  • desc: OPENAI *CHATGPT SUBSCR548 MARKET STREET PMB 97273 SAN FRANCISCO94104-5
  • accts: Openai, Openai *chatgpt Subscr
• ? (conf 0.4, weight 4, 0 accts, 4 stmt) guess=Sq *La Gourmandine Oak116 Meyran Ave Pittsburgh15213 Pa Usa|Hemingway S Cafe
  • desc: HEMINGWAY S CAFE 3911 FORBES AVE PITTSBURGH 15213 PA USA
• ? (conf 1.0, weight 4, 1 accts, 3 stmt) guess=Subaru Of South Hills
  • desc: SUBARU OF SOUTH HILLS 3260 WASHINGTON RD MCMURRAY 15317 PA USA
  • accts: Subaru Of South Hills
• ? (conf 1.0, weight 4, 2 accts, 2 stmt) guess=Svdp Castle Shannon
  • desc: SVDP CASTLE SHANNON 3423 LIBRARY ROAD PITTSBURGH15234 PA USA
  • desc: SVDP CASTLE SHANNON 3423 LIBRARY ROAD PITTSBURGH 15234 PA USA
  • accts: SVDP Castle Shannon, Svdp Castle Shannon
• ? (conf 0.4, weight 3, 1 accts, 2 stmt) guess=24 7 Travel St 2710 Commerce Rd Goodland 67735 Ks Usa
  • desc: 24 7 TRAVEL ST 1415 S FOSSIL ST RUSSELL 67665 KS USA
  • desc: 24 7 TRAVEL ST 2710 COMMERCE RD GOODLAND 67735 KS USA
  • accts: 24 7 Travel St
• ? (conf 0.58, weight 3, 1 accts, 2 stmt) guess=Allegheny Arms
  • desc: ALLEGHENY ARMS AND GUN4603 LIBRARY RD BETHEL PARK 15102 PA USA
  • accts: Allegheny Arms
• ? (conf 0.4, weight 3, 0 accts, 3 stmt) guess=Dave And Andy S Ho207
  • desc: SQ *DAVE AND ANDY S HO207 ATWOOD ST PITTSBURGH 15213 PA USA
  • desc: SQ *DAVE AND ANDY S HO207 ATWOOD ST PITTSBURGH15213 PA USA
• ? (conf 1.0, weight 3, 1 accts, 2 stmt) guess=Gloss* Jayme @ Xcepti.
  • desc: GLOSS* JAYME @ XCEPTI.1901 MARMADUKE STREET XCEPTIONAL STYLE LLC PITTS
  • desc: GLOSS* JAYME @ XCEPTI.1901 MARMADUKE STREET XCEPTIONAL STYLE LLC PITTS
  • accts: Gloss* Jayme @ Xcepti.
• ? (conf 1.0, weight 3, 0 accts, 3 stmt) guess=Jegs Com
  • desc: JEGS.COM 101 JEGS BOULEVARD DELAWARE 43015 OH USA
• ? (conf 0.46, weight 3, 1 accts, 2 stmt) guess=Primanti Bros
  • desc: PRIMANTI BROS 3803 FORBES AVE. PITTSBURGH 15213 PA USA
  • desc: PRIMANTI BROS ROBINSON4501 STEUBENVILLE PIKE PITTSBURGH 15205 PA USA
  • accts: Primanti Bros
• ? (conf 0.4, weight 3, 0 accts, 3 stmt) guess=Spiegel Freedman Psych105 Braunlich Drive
  • desc: SPIEGEL FREEDMAN PSYCH105 BRAUNLICH DRIVE, STE 210 PITTSBURGH 15237 PA
• ? (conf 1.0, weight 3, 0 accts, 3 stmt) guess=Spo Mineospizzahouse
  • desc: SPO*MINEO'SPIZZAHOUSE-713 WASHINGTON RD MT LEBANON15228 PA USA
  • desc: SPO*MINEO'SPIZZAHOUSE-2128 MURRAY AVE PITTSBURGH 15217 PA USA
  • desc: SPO*MINEO'SPIZZAHOUSE-713 WASHINGTON RD MT LEBANON 15228 PA USA
• ? (conf 0.4, weight 3, 0 accts, 3 stmt) guess=Sq *La Gourmandine Oak116 Meyran Ave Pittsburgh15213 Pa Usa|Pam Pittsburgh Parking325 Daniel Zenker
  • desc: PAM PITTSBURGH PARKING325 DANIEL ZENKER DR STE 4 HORSEHEADS 14845 NY U
  • desc: PAM PITTSBURGH PARKING325 DANIEL ZENKER DR STE 4 HORSEHEADS14845 NY US
• ? (conf 0.4, weight 3, 0 accts, 3 stmt) guess=Sq *La Gourmandine Oak116 Meyran Ave Pittsburgh15213 Pa Usa|Rnk Pittsburgh P3610 Forbes
  • desc: TST*RNK PITTSBURGH - P3610 FORBES AVE PITTSBURGH 15213 PA USA
  • desc: TST*RNK PITTSBURGH - P3610 FORBES AVE PITTSBURGH15213 PA USA
• ? (conf 0.4, weight 3, 1 accts, 2 stmt) guess=Willi S Ski And Snowb3738
  • desc: WILLI S SKI AND SNOWB3738 LIBRARY ROAD PITTSBURGH 15234 PA USA
  • accts: Willi S Ski And Snowb

AUTO-PROPOSABLE (top 40 by volume)

• GomobilePGH (conf 1.0, weight 47, merges 4 accts) ids=[865, 642, 559, 781]
• Sheetz (conf 1.0, weight 31, merges 7 accts) ids=[566, 744, 739, 567, 774, 794, 738]
• Sunoco (conf 1.0, weight 19, merges 6 accts) ids=[599, 638, 827, 767, 820, 715]
• Autozone (conf 1.0, weight 17, merges 6 accts) ids=[593, 812, 724, 714, 591, 806]
• Harbor Freight Tools (conf 0.95, weight 14, merges 3 accts) ids=[878, 569, 737]
• Chick-fil-A (conf 1.0, weight 12, merges 5 accts) ids=[630, 810, 832, 712, 702]
• Petco (conf 1.0, weight 12, merges 4 accts) ids=[546, 729, 797, 633]
• D J*wsj (conf 1.0, weight 8, merges 1 accts) ids=[553]
• Raising Cane's (conf 1.0, weight 8, merges 3 accts) ids=[868, 561, 828]
• Chikn Oakland (conf 1.0, weight 7, merges 1 accts) ids=[558]
• Rockauto (conf 0.94, weight 7, merges 1 accts) ids=[557]
• University Club (conf 0.86, weight 7, merges 2 accts) ids=[867, 637]
• Barnes & Noble (conf 0.9, weight 6, merges 3 accts) ids=[603, 817, 658]
• PMUSA (conf 1.0, weight 6, merges 2 accts) ids=[885, 614]
• REI (conf 1.0, weight 6, merges 2 accts) ids=[684, 682]
• Target (conf 1.0, weight 6, merges 2 accts) ids=[605, 731]
• Best Buy (conf 1.0, weight 5, merges 2 accts) ids=[751, 740]
• Expedia (conf 1.0, weight 5, merges 2 accts) ids=[717, 711]
• Home Depot (conf 0.83, weight 5, merges 1 accts) ids=[722]
• Michaels Stores (conf 1.0, weight 5, merges 2 accts) ids=[587, 664]
• Rita's (conf 1.0, weight 5, merges 1 accts) ids=[882]
• Sportsmans Warehouse (conf 1.0, weight 4, merges 1 accts) ids=[568]
• Taco Bell (conf 1.0, weight 4, merges 2 accts) ids=[686, 691]
• TNT Pizza (conf 1.0, weight 4, merges 1 accts) ids=[624]
• Act Cntyalleghenyprk (conf 1.0, weight 3, merges 1 accts) ids=[776]
• Butterjoint (conf 1.0, weight 3, merges 1 accts) ids=[608]
• Ctlp*csc Serviceworks (conf 1.0, weight 3, merges 1 accts) ids=[650]
• CVS Pharmacy (conf 1.0, weight 3, merges 2 accts) ids=[783, 816]
• Dunkin (conf 1.0, weight 3, merges 2 accts) ids=[655, 846]
• Fiori's Pizzaria (conf 0.91, weight 3, merges 1 accts) ids=[551]
• Five Guys (conf 1.0, weight 3, merges 1 accts) ids=[723]
• Giant Eagle (conf 1.0, weight 3, merges 1 accts) ids=[592]
• Hemingway's Cafe (conf 1.0, weight 3, merges 1 accts) ids=[560]
• Hinge (conf 1.0, weight 3, merges 1 accts) ids=[623]
• J.Crew Factory (conf 1.0, weight 3, merges 1 accts) ids=[617]
• Lowe's (conf 1.0, weight 3, merges 1 accts) ids=[673]
• ParkWhiz (conf 1.0, weight 3, merges 1 accts) ids=[670]
• Redhawk Coffee (conf 1.0, weight 3, merges 1 accts) ids=[721]
• Rei Com (conf 1.0, weight 3, merges 1 accts) ids=[687]
• T-Gateway Center (conf 0.9, weight 3, merges 1 accts) ids=[772]