Add industry lookup (seed file?) #22
Description
In order to answer questions around how specific industries donate to parties or candidates, we need a mechanism to determine alignment of PAC/committee to industry.
Based on the available data, it looks like committee_master_2024.parquet has a field called connect_org_nm that could be used to map an organization’s entity name with its industry.
CMTE_ID │ CMTE_NM │ TRES_NM │ CMTE_ST1 │ CMTE_ST2 │ CMTE_CITY │ CMTE_ST │ … │ CMTE_DSGN │ CMTE_TP │ CMTE_PTY_AFFILIATION │ CMTE_FILING_FREQ │ ORG_TP │ CONNECTED_ORG_NM │ CAND_ID
varchar │ varchar │ varchar │ varchar │ varchar │ varchar │ varchar │ │ varchar │ varchar │ varchar │ varchar │ varchar │ varchar │ varchar
───────────┼──────────────────────┼──────────────────────┼──────────────────────┼─────────────────┼───────────────┼─────────┼───┼───────────┼─────────┼──────────────────────┼──────────────────┼─────────┼──────────────────────┼────────
C00000059 │ HALLMARK CARDS, IN… │ KLEIN, CASSIE MS. │ 2501 MCGEE, MD853 │ │ KANSAS CITY │ MO │ … │ B │ Q │ UNK │ M │ C │ HALLMARK CARDS, INC. │
C00000422 │ AMERICAN MEDICAL A… │ JORDAN, JOHN ROBER… │ 25 MASSACHUSETTS A… │ SUITE 600 │ WASHINGTON │ DC │ … │ B │ Q │ │ M │ │ AMERICAN MEDICAL A… │
C00000489 │ D R I V E POLITICA… │ JERRY SIMS JR │ 3528 W RENO │ │ OKLAHOMA CITY │ OK │ … │ U │ N │ │ Q │ L │ │
C00000729 │ AMERICAN DENTAL AS… │ TIPPETT-WHYTE, JUD… │ 400 C STREET, NE │ │ WASHINGTON │ DC │ … │ B │ Q │ UNK │ M │ M │ INDIANA DENTAL PAC │
C00000885 │ INTERNATIONAL UNIO… │ SMITH, GREGG │ 7234 PARKWAY DRIVE │ │ HANOVER │ MD │ … │ B │ Q │ UNK │ M │ L │ INTERNATIONAL UNIO… │
C00000901 │ BUILD POLITICAL AC… │ RAMAGE, EILEEN │ 1201 15TH STREET, NW │ │ WASHINGTON │ DC │ … │ B │ Q │ UNK │ M │ T │ NATIONAL ASSOCIATI… │
C00000935 │ DCCC │ MERZ, JULIE │ 430 SOUTH CAPITOL … │ 2ND FLOOR │ WASHINGTON │ DC │ … │ U │ Y │ DEM │ M │ │ │