colorado-gov/campaign-reports-for-solicitation-notices-to-fdcw-ei67
Icon for Socrata external plugin
 
Readme
Updated 11 hours ago
Indexed 4 hours ago

Campaign Reports for Solicitation Notices to Charities in Colorado

Non-profit organization (NPO) data of campaign reports for solicitation notices from the Colorado Department of State (CDOS) Division of Charity.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
solicitationnoticeidsolicitationnoticeidsolicitationnoticeidTextSolicitation Notice ID
campaignreportidcampaignreportidcampaignreportidTextSolicitation Notice Campaign Report ID
filingtypefilingtypefilingtypeTextFiling Type: Master, Amendment, Renewal
filingStatusfilingstatusfilingstatusTextThe status of the filing
campaigndatefiledcampaigndatefiledcampaigndatefiledCalendar dateDate campaign report was filed. Changes from source: Dates changed from MM/DD/YY to YYYY-MM-DD.
charitynamecharitynamecharitynameTextCharitable Organization Official first and last name
charitysigneddatecharitysigneddatecharitysigneddateCalendar dateDate Charitable Organization Official signed campaign report. Changes from source: Dates changed from MM/DD/YY to YYYY-MM-DD.
solicitornamesolicitornamesolicitornameTextPaid Solicitor first and last name
solicitorsigneddatesolicitorsigneddatesolicitorsigneddateCalendar dateDate Paid Solicitor signed campaign report. Changes from source: Dates changed from MM/DD/YY to YYYY-MM-DD.
grosscontributionsgrosscontributionsgrosscontributionsNumberGross proceeds; contributions
grossticketsalesgrossticketsalesgrossticketsalesNumberGross proceeds: ticket sales
grossadvertisingsalesgrossadvertisingsalesgrossadvertisingsalesNumberGross proceeds: advertising sales
grossinkindgrossinkindgrossinkindNumberGrossproceeds: in kind
grossTotalgrosstotalgrosstotalNumberTotal of gross proceeds columns
inkinddescriptioninkinddescriptioninkinddescriptionTextDescription of in-kind proceeds
grossothergrossothergrossotherNumberGross proceeds: other revenue
expenseSalaryCommisionexpensesalarycommisionexpensesalarycommisionNumberExpenses: salaries and commissions
expenseprintingexpenseprintingexpenseprintingNumberExpenses: printing of solicitation materials
expensepostageexpensepostageexpensepostageNumberExpenses: postage
expensetelephoneexpensetelephoneexpensetelephoneNumberExpenses: telephone
expenseofficerentalexpenseofficerentalexpenseofficerentalNumberExpenses: office rental
expenseofficeexpensesexpenseofficeexpensesexpenseofficeexpensesNumberExpenses: office expenses
expensetotalexpensetotalexpensetotalNumberTotal of all expense columns
expenseauditoriumrentalexpenseauditoriumrentalexpenseauditoriumrentalNumberDirect event expenses: auditorium rental
expenseeventfeeexpenseeventfeeexpenseeventfeeNumberDirect event expenses: show fee for performers
expenseeventprintingexpenseeventprintingexpenseeventprintingNumberDirect event expenses: printing costs for tickets and program books
expenseeventotherexpenseeventotherexpenseeventotherNumberDirect event expenses: other expenses
proceedsnetproceedsnetproceedsnetNumberNet proceeds to charity (gross proceeds minus expenses + direct event expenses)
proceedspercenttocharityproceedspercenttocharityproceedspercenttocharityNumberPercentage of proceeds to charity (net charity divided by (expenses + direct even expenses X 100))
isfinanciallocalonlyisfinanciallocalonlyisfinanciallocalonlyCheckboxDoes financial information reflect solicitation activity in Colorado only or nationally?
bookkeeperbookkeeperbookkeeperTextPerson who is caretaker of books and records
bookkeeperaddressbookkeeperaddressbookkeeperaddressTextAddress of bookkeeper
bookkeepercitybookkeepercitybookkeepercityTextCity of bookkeeper. Changes from source: ran reconciliation algorithm to modify city name variations (resulting from manual data entry) to full standard (ie Colo Spg to Colorado Springs, etc).
bookkeeperstatebookkeeperstatebookkeeperstateTextState of bookkeeper
bookkeeperzipcodebookkeeperzipcodebookkeeperzipcodeTextZip of bookkeeper
activityflagactivityflagactivityflagCheckboxActivity exclusive to Colorado. Changes from source: �Y�s changed to 1� and �N�s changed to 0�.
commentscommentscommentsTextComments
 
Preview
  • campaign_reports_for_solicitation_notices_to
     
Upstream Metadata