Readme
Updated 8 days ago
‧ Indexed 1 hour ago
Campaign Spending OE Ledger Dataset
Columns
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| New Georeferenced Column (state) | geocoded_column_state | geocoded_column_state | Text | |
| New Georeferenced Column | geocoded_column | geocoded_column | Point | |
| Zip Code | zip_code | zip_code | Text | |
| Election | year | year | Number | |
| Forgiven | forgiven | forgiven | Text | |
| Disposition Amount | disposition_amount | disposition_amount | Text | |
| Name | name | name | Text | |
| Reg No | reg_no | reg_no | Text | |
| New Georeferenced Column (zip) | geocoded_column_zip | geocoded_column_zip | Text | |
| New Georeferenced Column (city) | geocoded_column_city | geocoded_column_city | Text | |
| New Georeferenced Column (address) | geocoded_column_address | geocoded_column_address | Text | |
| To Whom | to_whom | to_whom | Text | |
| ID | id | id | Text | |
| Repay Amount | repay_amount | repay_amount | Number | |
| InOutState | inoutstate | inoutstate | Text | |
| Reporting Period | reporting_period | reporting_period | Text | |
| Election Period | election_period | election_period | Text | |
| County | county | county | Text | |
| District | district | district | Text | |
| Office | office | office | Text | |
| Counties | :@computed_region_xpdz_s4v8 | :@computed_region_xpdz_s4v8 | Number | |
| Authorized Use | authorized_use | authorized_use | Text | |
| Amount | amount | amount | Number | |
| Date | date | date | Calendar date | |
| State | state | state | Text | |
| City | city | city | Text | |
| Address 1 | address_1 | address_1 | Text | |
| Name ID | name_id | name_id | Text | |
| Candidate Name | candidate_name | candidate_name | Text | |
| Category | category | category | Text | |
| Candidate Disclosure Form URL | candidate_disclosure_form | candidate_disclosure_form | Text | |
| Range | range | range | Text | |
| Non-Monetary? | non_monetary | non_monetary | Text | |
| Aggregated Amount | aggregated_amount | aggregated_amount | Number | |
| Address 2 | address_2 | address_2 | Text | |
| Loan Source | loan_source | loan_source | Text | |
| Party | party | party | Text | |
| Type | type | type | Text | |
| Purpose | purpose | purpose | Text | |
| Schedule | schedule | schedule | Text |
Upstream Metadata