Collegiate Sports US

Comprehensive Information on Collegiate Sports Programs in the United States.

@kaggle.willianoliveiragibin_collegiate_sports_us

Table List

1 table(1.33 MB)

Sports College Us New

@kaggle.willianoliveiragibin_collegiate_sports_us.sports_college_us_new

1.33 MB
30000 rows
28 columns

year Year	unitid Unitid	institution_name Institution Name	city_txt City Txt	state_cd State Cd	zip_text Zip Text	classification_code Classification Code	classification_name Classification Name	classification_other Classification Other	ef_male_count Ef Male Count	ef_female_count Ef Female Count	ef_total_count Ef Total Count	sector_cd Sector Cd	sector_name Sector Name	sportscode Sportscode	partic_men Partic Men	partic_women Partic Women	sum_partic_men Sum Partic Men	sum_partic_women Sum Partic Women	rev_men Rev Men	rev_women Rev Women	total_rev_menwomen Total Rev Menwomen	exp_men Exp Men	exp_women Exp Women	total_exp_menwomen Total Exp Menwomen	sports Sports
2015	200192	Lake Region State College	Devils Lake	ND	583011598	12	NJCAA Division I	nan	250	253	503	4	Public, 2-year	1	18		18		69325		69325	69325		69325	Baseball
2015	200192	Lake Region State College	Devils Lake	ND	583011598	12	NJCAA Division I	nan	250	253	503	4	Public, 2-year	2	13	13	13	13	125277	147162	272439	125277	147162	272439	Basketball
2015	200192	Lake Region State College	Devils Lake	ND	583011598	12	NJCAA Division I	nan	250	253	503	4	Public, 2-year	8	5	3	5	3	11907	9932	21839	11907	9932	21839	Golf
2015	200192	Lake Region State College	Devils Lake	ND	583011598	12	NJCAA Division I	nan	250	253	503	4	Public, 2-year	16		16		16		42705	42705		42705	42705	Softball
2015	200192	Lake Region State College	Devils Lake	ND	583011598	12	NJCAA Division I	nan	250	253	503	4	Public, 2-year	26		12		12		65876	65876		65876	65876	Volleyball
2015	214272	Neumann University	Aston	PA	190141298	7	NCAA Division III without football	nan	654	1148	1802	2	Private nonprofit, 4-year or above	1	38		38		83718		83718	83718		83718	Baseball
2015	214272	Neumann University	Aston	PA	190141298	7	NCAA Division III without football	nan	654	1148	1802	2	Private nonprofit, 4-year or above	2	13	14	13	14	76391	73412	149803	76391	73412	149803	Basketball
2015	214272	Neumann University	Aston	PA	190141298	7	NCAA Division III without football	nan	654	1148	1802	2	Private nonprofit, 4-year or above	6		20		20		54965	54965		54965	54965	Field Hockey
2015	214272	Neumann University	Aston	PA	190141298	7	NCAA Division III without football	nan	654	1148	1802	2	Private nonprofit, 4-year or above	8	11	6	11	6	32552	18409	50961	32552	18409	50961	Golf
2015	214272	Neumann University	Aston	PA	190141298	7	NCAA Division III without football	nan	654	1148	1802	2	Private nonprofit, 4-year or above	10	29	20	29	20	234521	144026	378547	234521	144026	378547	Ice Hockey


CREATE TABLE sports_college_us_new (
  "year" BIGINT,
  "unitid" BIGINT,
  "institution_name" VARCHAR,
  "city_txt" VARCHAR,
  "state_cd" VARCHAR,
  "zip_text" BIGINT,
  "classification_code" BIGINT,
  "classification_name" VARCHAR,
  "classification_other" VARCHAR,
  "ef_male_count" BIGINT,
  "ef_female_count" BIGINT,
  "ef_total_count" BIGINT,
  "sector_cd" BIGINT,
  "sector_name" VARCHAR,
  "sportscode" BIGINT,
  "partic_men" DOUBLE,
  "partic_women" DOUBLE,
  "partic_coed_men" DOUBLE,
  "partic_coed_women" DOUBLE,
  "sum_partic_men" BIGINT,
  "sum_partic_women" BIGINT,
  "rev_men" DOUBLE,
  "rev_women" DOUBLE,
  "total_rev_menwomen" BIGINT,
  "exp_men" DOUBLE,
  "exp_women" DOUBLE,
  "total_exp_menwomen" BIGINT,
  "sports" VARCHAR
);