1000 Projects Crowdfunding Data

Detailed Crowdfunding Dataset

@kaggle.syedasimalishah_1000_projects_crowdfunding_data

Table List

1 table(86.83 KB)

Crowdfunding Data 1000 Projects

@kaggle.syedasimalishah_1000_projects_crowdfunding_data.crowdfunding_data_1000_projects

86.83 KB
1000 rows
32 columns

project_id Project ID	school_latitude School Latitude	school_longitude School Longitude	school_city School City	school_state School State	school_zip School Zip	school_metro School Metro	school_district School District	school_county School County	school_charter School Charter	school_magnet School Magnet	school_year_round School Year Round	school_nlns School Nlns	school_kipp School Kipp	school_charter_ready_promise School Charter Ready Promise	teacher_prefix Teacher Prefix	teacher_teach_for_america Teacher Teach For America	teacher_ny_teaching_fellow Teacher Ny Teaching Fellow	primary_focus_subject Primary Focus Subject	primary_focus_area Primary Focus Area	secondary_focus_subject Secondary Focus Subject	secondary_focus_area Secondary Focus Area	resource_type Resource Type	poverty_level Poverty Level	grade_level Grade Level	goal Goal	students_reached Students Reached	total_donations Total Donations	num_donors Num Donors	funding_status Funding Status	date_posted Date Posted	date_expiration Date Expiration
1	45.31014	-93.807736	Monticello	MN	55362	nan	Monticello Ind School Dist 882	Wright	f	f	f	f	f	f	Ms.	f	f	Literacy	Literacy & Language	Special Needs	Special Needs	Technology	moderate poverty	Grades PreK-2	887.15	12	856.83	7	completed	Thu Jan 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri May 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)
2	29.795216	-95.358101	Houston	TX	77009	urban	Houston Ind School District	Harris	f	f	f	f	f	f	Teacher	f	f	Literature & Writing	Literacy & Language	nan	nan	Books	highest poverty	Grades 3-5	761.52	63	125	3	NotCompleted	Thu Jan 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Apr 30 2015 00:00:00 GMT+0000 (Coordinated Universal Time)
3	37.754852	-122.42616	San Francisco	CA	94114	urban	San Francisco Unified Sch Dist	San Francisco	t	f	f	f	f	f	Mrs.	f	f	Gym & Fitness	Health & Sports	Health & Wellness	Health & Sports	Supplies	highest poverty	Grades PreK-2	266.55	88	266.56	6	completed	Thu Jan 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri May 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)
4	36.297083	-119.789619	Lemoore	CA	93245	suburban	Lemoore Union Elem Sd	Kings	f	f	f	f	f	f	Ms.	f	f	Health & Wellness	Health & Sports	Gym & Fitness	Health & Sports	Supplies	high poverty	Grades 3-5	808.15	30	25	1	NotCompleted	Thu Jan 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Apr 30 2015 00:00:00 GMT+0000 (Coordinated Universal Time)
5	33.94601	-118.22336	South Gate	CA	90280	suburban	Los Angeles Unif Sch Dist	Los Angeles	f	f	f	f	f	f	Ms.	f	f	Music	Music & The Arts	Performing Arts	Music & The Arts	Other	high poverty	Grades 9-12	1296.65	92	1296.65	1	NotCompleted	Thu Jan 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri May 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)
6	33.99846442	-83.70176487	Winder	GA	30680	nan	Barrow Co School District	Barrow	t	f	f	f	f	f	Mrs.	f	f	Literacy	Literacy & Language	Special Needs	Special Needs	Technology	highest poverty	Grades 3-5	417.84	15			NotCompleted	Thu Jan 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Apr 30 2015 00:00:00 GMT+0000 (Coordinated Universal Time)
7	40.94207726	-73.87071781	Yonkers	NY	10701	suburban	Yonkers Public School District	Westchester	f	t	f	f	f	f	Mrs.	f	f	Literacy	Literacy & Language	nan	nan	Books	highest poverty	Grades 3-5	399.84	60	399.84	5	completed	Thu Jan 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri May 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)
8	41.803885	-87.590334	Chicago	IL	60615	urban	Chicago Psd-Network 9	Cook	f	t	f	t	f	f	Ms.	f	f	Mathematics	Math & Science	College & Career Prep	Applied Learning	Technology	highest poverty	Grades 6-8	2304.11	24	2304.11	1	completed	Thu Jan 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Apr 30 2015 00:00:00 GMT+0000 (Coordinated Universal Time)
9	40.60720825	-74.09529877	New York City	NY	10304	urban	New York City Dept Of Ed	Richmond (Staten Island)	f	f	f	f	f	f	Mrs.	f	f	Literacy	Literacy & Language	Mathematics	Math & Science	Technology	highest poverty	Grades PreK-2	632.34	30	186	2	NotCompleted	Thu Jan 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Apr 30 2015 00:00:00 GMT+0000 (Coordinated Universal Time)
10	35.39444	-84.684016	Riceville	TN	37370	rural	Mcminn Co School District	Mcminn	f	f	f	f	f	f	Mrs.	f	f	Environmental Science	Math & Science	Health & Life Science	Math & Science	Supplies	high poverty	Grades 3-5	1910.89	80			NotCompleted	Thu Jan 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Apr 30 2015 00:00:00 GMT+0000 (Coordinated Universal Time)


CREATE TABLE crowdfunding_data_1000_projects (
  "project_id" BIGINT,
  "school_latitude" DOUBLE,
  "school_longitude" DOUBLE,
  "school_city" VARCHAR,
  "school_state" VARCHAR,
  "school_zip" BIGINT,
  "school_metro" VARCHAR,
  "school_district" VARCHAR,
  "school_county" VARCHAR,
  "school_charter" VARCHAR,
  "school_magnet" VARCHAR,
  "school_year_round" VARCHAR,
  "school_nlns" VARCHAR,
  "school_kipp" VARCHAR,
  "school_charter_ready_promise" VARCHAR,
  "teacher_prefix" VARCHAR,
  "teacher_teach_for_america" VARCHAR,
  "teacher_ny_teaching_fellow" VARCHAR,
  "primary_focus_subject" VARCHAR,
  "primary_focus_area" VARCHAR,
  "secondary_focus_subject" VARCHAR,
  "secondary_focus_area" VARCHAR,
  "resource_type" VARCHAR,
  "poverty_level" VARCHAR,
  "grade_level" VARCHAR,
  "goal" DOUBLE,
  "students_reached" BIGINT,
  "total_donations" DOUBLE,
  "num_donors" BIGINT,
  "funding_status" VARCHAR,
  "date_posted" TIMESTAMP,
  "date_expiration" TIMESTAMP
);