Module ImportFrom alias ImportFrom alias ImportFrom alias ImportFrom alias ClassDef bases NameLoad body Assign NameStore Str FunctionDef arguments args NameParam defaults vararg kwarg body Assign AttributeStore NameLoad attr Call AttributeLoad NameLoad attr Assign NameStore BinOpMod Str Call NameLoad keyword AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr keyword AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr keyword AttributeLoad AttributeLoad AttributeLoad NameLoad attr attr attr Expr Call AttributeLoad AttributeLoad NameLoad attr attr NameLoad Assign NameStore Call NameLoad Call NameLoad Str Str Expr Call AttributeLoad NameLoad attr ListLoad Str Str Str Str Str Str Expr Call AttributeLoad NameLoad attr Call AttributeLoad AttributeLoad NameLoad attr attr decorator_list decorator_list
N/A csvkit CSVKitWriter django.db connection calaccess_campaign_browser models calaccess_campaign_browser.management.commands CalAccessCommand Command N/A CalAccessCommand N/A N/A help Export candidates scraped from the state site handle N/A N/A self N/A args options N/A N/A N/A self cursor N/A N/A connection cursor N/A sql N/A 
        SELECT DISTINCT
            o.name,
            o.seat,
            f.filer_id_raw,
            f.xref_filer_id,
            f.name,
            f.party
        FROM %(candidate)s as c
        INNER JOIN %(office)s as o
        ON c.office_id = o.id
        INNER JOIN %(filer)s as f
        ON c.filer_id = f.id
         N/A dict candidate N/A N/A N/A models Candidate _meta db_table office N/A N/A N/A models Office _meta db_table filer N/A N/A N/A models Filer _meta db_table N/A N/A N/A N/A self cursor execute sql N/A writer N/A CSVKitWriter N/A open ./candidates.csv wb N/A N/A N/A writer writerow N/A office_name office_seat filer_id xref_filer_id name party N/A N/A N/A writer writerows N/A N/A N/A self cursor fetchall N/A N/A