All donations, including donor city, state, and partial-zip (when available). Each donation corresponds to a single classroom project so, for example, a donor can put 3 project donations in a check-out cart and pay for them with a single transaction. Data file: ~85MB zip, ~260MB CSV, ~1.1M records IDs_donationid _projectid _donor_acctid _cartid: Can contain donations to multiple projects as well as gift card purchases. Donor InfoA few years back, donor addresses became optional, even when the donor is eligible to receive a mailed thank-you packet from the classroom. So there are a lot of null address fields for donors who elected not to provide their address. donor_city donor_state donor_zip: The last two digits are hidden for privacy reasons. is_teacher_acct: Donation was made by a teacher. We don't publish exact donation amounts publicly as we believe many donors do not wish to share this information. Instead we've indicated the dollar amount range of the donation: <=$10, $10 to <=$100, >=$100.Payment TypesThe fields below that are prefixed with payment_... indicate the source of funds used as payment for the donation. The payment_method gives the primary source of revenues for new donations. If payment_method given as 'no_cash_received', the donation consisted entirely of applying donation dollars that came into our system via a previous transaction. The remaining three boolean payment_included_... fields indicate the nature of those previous transactions. When a gift card is used to make a donation, it's one of two scenarios. payment_included_campaign_gift_card is true when the gift card was issued as part of corporate or foundation giving campaign, or some other special promotional campaign. payment_included_web_purchased_gift_card is true when the gift was purchased by an individual donor through our public website. These web purchases are detailed in the Gift Cards data table. Account credits may be created when a donor partially redeems a gift card, when they receive funds to spend because their donations were made to a project that expired without being fully funded, or because they're participating in our automatic monthly donations program. When these account credits are later used to make a donation, payment_included_acct_credit is true. It is possible for a donation to include
multiple payment types. For example, if a donor redeemed a gift card
and added $10 dollars to make the donation, payment_included_ campaign_gift_card would be true and payment_method would be creditcard.payment_method: creditcard, paypal, amazon, check, double_your_impact_match, almost_home_match or no_cash_received. The 2 '..._match' methods indicate if the donation was made by a Double Your Impact or an Almost Home account. payment_included_acct_credit payment_included_campaign_gift_card payment_included_web_purchased_gift_card The above 3 payment types are not mutually exclusive and forms of applying donation dollars that came into our system via a previous transaction. They can also be in addition to, or instead of, the primary payment_method type listed above. We have done many large campaign- and promotion-based gift card distributions, you should expect to see many donations with payment_included_campaign_gift_card=True and payment_method=no_cash_received. Donation TypesSome additional donation attributes. via_giving_page: True if the donation was made through a Giving Page. for_honoree: Donation included an honoree. thank_you_packet_mailed: All donors receive certain teacher thank-you's and photos of the project taking place. Donors who give >$100 or provide the project's completing donation, and supply us with their mailing address, receive a mailed thank-you packet. This field indicates whether the donor was sent a thank-you packet for their donation.  This work by DonorsChoose.org is licensed under a Creative Commons Attribution-NonCommercial 3.0 Unported License (CC BY-NC 3.0). If you'd like to use this data for commercial purposes, drop a note to apiquestions (at) donorschoose {dot} org and tell us a bit about your plans. Our strong preference is to greenlight your commercial application with no licensing fees, and we have never charged for access to our API or data. We just need to make sure that the application won't run contrary to our org's mission or abuse the rich content that our teachers have created. |
|
Open Datasets >
Donation Data |