CREATE TABLE "essays"
(
    projectid         TEXT,
    teacher_acctid    TEXT,
    title             TEXT,
    short_description TEXT,
    need_statement    TEXT,
    essay             TEXT
);
essays
CREATE TABLE "projects"
(
    projectid                              TEXT not null
        primary key,
    teacher_acctid                         TEXT,
    schoolid                               TEXT,
    school_ncesid                          TEXT,
    school_latitude                        REAL,
    school_longitude                       REAL,
    school_city                            TEXT,
    school_state                           TEXT,
    school_zip                             INTEGER,
    school_metro                           TEXT,
    school_district                        TEXT,
    school_county                          TEXT,
    school_charter                         TEXT,
    school_magnet                          TEXT,
    school_year_round                      TEXT,
    school_nlns                            TEXT,
    school_kipp                            TEXT,
    school_charter_ready_promise           TEXT,
    teacher_prefix                         TEXT,
    teacher_teach_for_america              TEXT,
    teacher_ny_teaching_fellow             TEXT,
    primary_focus_subject                  TEXT,
    primary_focus_area                     TEXT,
    secondary_focus_subject                TEXT,
    secondary_focus_area                   TEXT,
    resource_type                          TEXT,
    poverty_level                          TEXT,
    grade_level                            TEXT,
    fulfillment_labor_materials            REAL,
    total_price_excluding_optional_support REAL,
    total_price_including_optional_support REAL,
    students_reached                       INTEGER,
    eligible_double_your_impact_match      TEXT,
    eligible_almost_home_match             TEXT,
    date_posted                            DATE
);
projects
CREATE TABLE donations
(
    donationid                               TEXT not null
            primary key,
    projectid                               TEXT,
    donor_acctid                             TEXT,
    donor_city                               TEXT,
    donor_state                              TEXT,
    donor_zip                                TEXT,
    is_teacher_acct                          TEXT,
    donation_timestamp                       DATETIME,
    donation_to_project                      REAL,
    donation_optional_support                REAL,
    donation_total                           REAL,
    dollar_amount                            TEXT,
    donation_included_optional_support       TEXT,
    payment_method                           TEXT,
    payment_included_acct_credit             TEXT,
    payment_included_campaign_gift_card      TEXT,
    payment_included_web_purchased_gift_card TEXT,
    payment_was_promo_matched                TEXT,
    via_giving_page                          TEXT,
    for_honoree                              TEXT,
    donation_message                         TEXT,
    foreign key (projectid) references projects(projectid)
);
donations
CREATE TABLE resources
(
    resourceid            TEXT not null
            primary key,
    projectid             TEXT,
    vendorid              INTEGER,
    vendor_name           TEXT,
    project_resource_type TEXT,
    item_name             TEXT,
    item_number           TEXT,
    item_unit_price       REAL,
    item_quantity         INTEGER,
    foreign key (projectid) references projects(projectid)
);
resources
original_column_name,column_name,column_description,data_format,value_description
projectid,project id,project's unique identifier,text,
teacher_acctid,teacher_acctid,teacher's unique identifier (teacher that created a project),text,
schoolid,schoolid,school's identifier (school where teacher works),text,
school_ncesid,school national center for education statistics id,Public National Center for Ed Statistics id,text,
school_latitude,school latitude,latitude of school ,real,
school_longitude,school longitude,longitude of school ,real,
school_city,school city,city where the school is located,text,
school_state,school state,state where the school is located,text,
school_zip,school zip,zipcode of school,integer,
school_metro,school metro,metro where the school is located,text,
school_district,school district,district where the school is located,text,
school_county,school county,country where the school is located,text,
school_charter,school charter,whether it is a public charter school or not (no private schools in the dataset),text,
school_magnet,school magnet,whether a public magnet school or not,text,
school_year_round,school year round,whether it is a public year round school or not,text,
school_nlns,school Nonleafy Normal Stature,whether it is a public Nonleafy Normal Stature school or not,text,
school_kipp,school Knowledge Is Power Program,whether it is a public Knowledge Power Program school or not,text,
school_charter_ready_promise,school charter ready promise,whether it is a public ready promise school or not,text,
teacher_prefix,teacher prefix,teacher's gender,text,"commonsense evidence:
if the value is equal to ""Dr. "", it means this teacher acquired P.h.D or doctor degree."
teacher_teach_for_america,teachers teach for america,Teach for America or not,text,
teacher_ny_teaching_fellow,teacher_new_york_teaching_fellow,New York teaching fellow or not,text,"• t: true
• f: false
commonsense evidence:
if true: it means that this teacher is a New York teacher"
primary_focus_subject,primary focus subject,main subject for which project materials are intended,text,
primary_focus_area,primary focus area,main subject area for which project materials are intended,text,
secondary_focus_subject,secondary focus subject,secondary subject,text,
secondary_focus_area,secondary focus area,secondary subject area,text,
resource_type,resource type,main type of resources requested by a project,text,
poverty_level,poverty level,school's poverty level,text,"commonsense evidence:
highest: 65%+ free of reduced lunch; high: 40-64%; moderate: 10-39%low: 0-9%"
grade_level,grade level,grade level for which project materials are intended,text,
fulfillment_labor_materials,fulfillment labor materials, cost of fulfillment,real,"commonsense evidence:
higher means higher cost, or need more labors"
total_price_excluding_optional_support,total price excluding optional support,project cost excluding optional tip that donors give to DonorsChoose.org while funding a project,real,
total_price_including_optional_support,total price including optional support,project cost including optional tip that donors give to DonorsChoose.org while funding a project,real,"commonsense evidence:
cost of optional tip = total_price_including_optional_support -total_price_excluding_optional_support"
students_reached,students reached,number of students impacted by a project (if funded),integer,
eligible_double_your_impact_match,eligible double your impact match," project was eligible for a 50% off offer by a corporate partner (logo appears on a project, like Starbucks or Disney)",text,
eligible_almost_home_match,eligible almost home match,project was eligible for a $100 boost offer by a corporate partner,text,
date_posted,date posted,data a project went live on the site,date,
projects
original_column_name,column_name,column_description,data_format,value_description
projectid,project id,unique project identifier,text,
teacher_acctid,teacher acctid,teacher id that created a project,text,
title,title,title of the project,text,
short_description,short description,short description of a project,text,
need_statement,need statement,need statement of a project,text,
essay,essay,complete project essay,text,
essays
original_column_name,column_name,column_description,data_format,value_description
resourceid,resource id,unique resource id,text,
projectid,project id,project id that requested resources for a classroom,text,
vendorid,vendor id,vendor id that supplies resources to a project,integer,
vendor_name,vendor name,vendor name,text,
project_resource_type,project resource type,type of resource,text,
item_name,item name,resource name,text,
item_number,item number,resource item identifier,text,
item_unit_price,item unit price,unit price of the resource,real,
item_quantity,item quantity,number of a specific item requested by a teacher,integer,
resources
original_column_name,column_name,column_description,data_format,value_description
donationid,donation id,unique donation identifier,text,
projectid,project id,project identifier that received the donation,text,
donor_acctid,donor accid,donor that made a donation,text,
donor_city,donor city,donation city,text,
donor_state,donor state,donation state,text,
donor_zip,donor zip,donation zip code,text,
is_teacher_acct,is teacher acct,whether donor is also a teacher,text,"commonsense evidence:
• f: false, it means this donor is not a teacher
• t: true, it means this donor is a teacher"
donation_timestamp,donation timestamp,the time of donation,datetime,
donation_to_project,donation to project,"amount to project, excluding optional support (tip)",real,
donation_optional_support,donation optional support,amount of optional support,real,
donation_total,donation total,donated amount,real,"commonsense evidence:
donated amount = donation_to_project + donation_optional_support"
dollar_amount,dollar amount,donated amount in US dollars,text,
donation_included_optional_support,donation included optional support,whether optional support (tip) was included for DonorsChoose.org,text,"commonsense evidence:
• f: false, optional support (tip) was not included for DonorsChoose.org
• t: true, optional support (tip) was included for DonorsChoose.org"
payment_method,payment method,what card/payment option was used,text,
payment_included_acct_credit,payment included acct credit,whether a portion of a donation used account credits redemption,text,"commonsense evidence:
• f: false, a portion of a donation didn't use account credits redemption
• t: true, a portion of a donation used account credits redemption"
payment_included_campaign_gift_card,payment included campaign gift card,whether a portion of a donation included corporate sponsored gift card,text,"commonsense evidence:
• f: false, a portion of a donation included corporate sponsored gift card
• t: true, a portion of a donation included corporate sponsored gift card"
payment_included_web_purchased_gift_card,payment included web purchased gift card,whether a portion of a donation included citizen purchased gift card (ex: friend buy a gift card for you),text,"• f: false
• t: true"
,,,text,
payment_was_promo_matched,payment was promo matched,whether a donation was matched 1-1 with corporate funds,text,"commonsense evidence:
• f: false, a donation was not matched 1-1 with corporate funds
• t: true, a donation was matched 1-1 with corporate funds"
via_giving_page,via giving page,donation given via a giving / campaign page (example: Mustaches for Kids),text,
for_honoree,for honoree,donation made for an honoree,text,"commonsense evidence:
• f: false, this donation is not made for an honoree
• t: true, this donation is made for an honoree"
donation_message,donation message,donation comment/message. ,text,
donations