All classroom projects that have been posted to the site, including lots of school info such as its NCES ID (government-issued), lat/long, and city/state/zip. Each row in the table is a classroom project. Data file: ~40MB zip, ~135MB CSV, ~300K records IDs_projectid: identifies a unique project _teacher_acctid: identifies the teacher who created the project _schoolid: identifies the school that this project is for school_ncesid: the NCES ID of the school as used by http://nces.ed.gov/ School LocationThese fields mostly correspond to the options available on our search page under the School section of "More Criteria." The options that are not available on the search page are latitude/longitude, zip, and metro type. school_latitude school_longitude school_city school_state school_zip: 5 Digit Zip school_metro: Urban, Suburban, or Rural school_district school_county School TypesThese fields correspond to the options available on our search page under the School section of "More Criteria." The are flagged with 1 if the project is associated with the type of school specified, and a 0 if not. For example, a New Leaders New Schools affiliated school would have a 1 in the nlns field. school_charter school_magnet school_year_round school_nlns school_kipp school_charter_ready_promise Teacher Attributesteacher_prefix: Dr., Mr., Mr. & Mrs., Mrs., Ms. teacher_teach_for_america teacher_ Project CategoriesThese correspond the the details available on the bottom of each project page. Each project has a primary focus with a subject and associated area, but may also have a secondary focus. For example, a project requesting books about the environment may have a primary subject of "Environmental Science" under the area "Math & Science", with a secondary subject of "Literacy" under the area "Literacy & Language." primary_focus_subject primary_focus_area secondary_focus_subject secondary_focus_area resource_usage: essential or enrichment resource_type: Books, Technology, Supplies, Trips, Visitors, Other poverty_level: high, low, minimal, unknown grade_level: Grades PreK-2, Grades 3-5, Grades 6-8, Grades 9-12 Project Pricing and ImpactThese fields are available under Project Details on a project page, breaking down the cost of a project into its parts. vendor_shipping_charges sales_tax payment_processing_charges fulfillment_labor_materials total_price_excluding_opt_donation total_price_including_opt_donation students_reached used_by_future_students Project DonationsThese fields provide information about the donations made to a particular project. total_donations: Total donation amount num_donors: Number of unique donors giving to this project eligible_double_your_impact_match: True if the project was ever eligible for a Double Your Impact match offer eligible_almost_home_match: True if the project was ever eligible for an Almost Home match offer Project StatusThese fields provide status information and dates for when a project reached their milestones. Dates will be null if the project did not reach that particular milestone. For example, if a project was posted but not completed, the date_completed would be null while the date_posted would have a date. funding_status refers to the status of this project as of the date the dataset was created. Reallocated projects are projects that received partial funding but the project never completed, so the donations were moved towards another project. Completed projects refer to projects that received full funding. Expired projects are ones that expired before donations were made. Live projects are projects that were still open for donations on the day the dataset was created. funding_status: Completed, Expired, Live, or Reallocated date_posted: Date a project was approved by staff to be listed on the site date_completed: Date a project become fully funded date_thank_you_packet_mailed: Date that the project went through the final stage of sending out a thank you package to donors date_expiration: Date the project was set to expire and be delisted from the site  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 >
Project Data |