Top American Colleges 2022

List of top colleges in America in 2022

@kaggle.kabhishm_top_american_colleges_2022

Table List

1 table(304.52 KB)

Top Colleges 2022

@kaggle.kabhishm_top_american_colleges_2022.top_colleges_2022

304.52 KB
498 rows
25 columns

description Description	rank Rank	organizationname OrganizationName	state State	studentpopulation StudentPopulation	campussetting CampusSetting	medianbasesalary MedianBaseSalary	longitude Longitude	latitude Latitude	website Website	phonenumber PhoneNumber	city City	country Country	state_1 State.1	region Region	yearfounded YearFounded	statecode StateCode	collegetype CollegeType	carnegieclassification CarnegieClassification	studentfacultyratio StudentFacultyRatio	totalstudentpop TotalStudentPop	undergradpop UndergradPop	totalgrantaid TotalGrantAid	percentofstudentsfinaid PercentOfStudentsFinAid	percentofstudentsgrant PercentOfStudentsGrant
A leading global research university, MIT attracts some of the most brilliant young minds to its Cambridge, MA, campus every year. MIT is committed to educating students in science, technology, and other areas to best serve the modern world. Last year, researchers at MIT filed 439 patents and 25 com…	1	Massachusetts Institute of Technology	MA	12195	Urban	173700	-71.093539	42.359006	http://web.mit.edu	617-253-1000	Cambridge	United States	Massachusetts	Northeast	1861	MA	Private not-for-profit	Doctoral Universities: Very High Research Activity	3	12195	4582	35299332	75	60
Stanford University sits just outside of Palo Alto, CA. This world class private research university is renowned for its STEM programs, which have produced numerous Nobel Prize, Turing Award and Fields Medal recipients. The institution’s engineering school has housed some of the most accomplished in…	2	Stanford University	CA	20961	Suburban	173500	-122.168924	37.43137	http://www.stanford.edu	650-723-2091	Stanford	United States	California	West	1891	CA	Private not-for-profit	Doctoral Universities: Very High Research Activity	4	20961	8464	51328461	70	55
One of the top public universities in the country, UC Berkeley has a rich tradition of leading technological and social change. Berkeley’s faculty has had a hand in the discovery of Vitamins E and K, the development of the atomic bomb and the creation of the flu vaccine. Since the Free Speech Moveme…	2	University of California, Berkeley	CA	45878	Urban	154500	-122.258393	37.869236	http://www.berkeley.edu	(510) 642-6000	Berkeley	United States	California	West	1868	CA	Public	Doctoral Universities: Very High Research Activity	19	45878	33208	64495611	63	53
Princeton is a leading private research university in Princeton, NJ, and the fourth oldest college in the United States. Students are placed into one of six residential colleges and are guaranteed housing for all four years of school. Students whose families have an annual income below $65,000 are …	4	Princeton University	NJ	8532	Urban	167600	-74.659119	40.349855	http://www.princeton.edu	609-258-3000	Princeton	United States	New Jersey	Northeast	1746	NJ	Private not-for-profit	Doctoral Universities: Very High Research Activity	4	8532	5516	44871096	62	61
Located in upper Manhattan, Columbia University in the City of New York is a private, Ivy league university. The school utilizes its location to provide students with a wealth of resources and learning opportunities. Columbia houses three undergraduate programs: the flagship Columbia College, the co…	5	Columbia University	NY	33882	Urban	148800	-73.961288	40.806515	http://www.columbia.edu	212-854-1754	New York	United States	New York	Northeast	1754	NY	Private not-for-profit	Doctoral Universities: Very High Research Activity	6	33882	8689	44615007	58	54
The University of California, Los Angeles is the most applied-to university in the country, with the goal of welcoming applicants from all backgrounds. The public research university offers more than 125 undergraduate majors. Students learn from award-winning faculty members and two on-campus center…	6	University of California, Los Angeles	CA	46947	Urban	137200	-118.437855	34.073903	http://ucla.edu	310-825-4321	Los Angeles	United States	California	West	1919	CA	Public	Doctoral Universities: Very High Research Activity	18	46947	33641	61100980	73	67
Located in rural Williamstown, MA, Williams College is among the oldest and most prestigious liberal arts schools in the country. Williams does not have any mandatory courses, but it does have rigorous requirements for students in the arts and humanities, social sciences, science and mathematics. Th…	7	Williams College	MA	2307	Rural	152600	-73.208078	42.712389	http://www.williams.edu	413-597-3131	Williamstown	United States	Massachusetts	Northeast	1793	MA	Private not-for-profit	Baccalaureate Colleges: Arts & Sciences Focus	6	2307	2251	15204855	62	52
Yale University is the second oldest Ivy League institution, founded in New Haven, CT. The school is known for its highly-regarded programs in history, economics, psychology and English. Students are assigned to one of fourteen residential colleges on the school’s campus. Students are associated wit…	8	Yale University	CT	14910	Urban	163700	-72.923425	41.314042	http://www.yale.edu	203-432-4771	New Haven	United States	Connecticut	Northeast	1701	CT	Private not-for-profit	Doctoral Universities: Very High Research Activity	4	14910	7199	48430359	61	53
Duke offers 53 undergraduate majors at its Durham, NC, campus, including top programs in computer science, economics and public policy. Its student newspaper, The Chronicle, has been publishing since 1905. Also an athletics powerhouse, Duke’s Blue Devils compete in 27 sports at the Division I level.…	9	Duke University	NC	17855	Urban	155000	-78.940277	36.001389	http://www.duke.edu	919-684-8111	Durham	United States	North Carolina	South	1924	NC	Private not-for-profit	Doctoral Universities: Very High Research Activity	6	17855	7278	41087604	63	47
Founded by Benjamin Franklin, The University of Pennsylvania covers almost 300 acres in west Philadelphia with close proximity to downtown and several neighboring colleges. UPenn offers four undergraduate colleges: the College of Arts & Sciences, the School of Engineering and Applied Sciences, the S…	10	University of Pennsylvania	PA	30688	Urban	164000	-75.162369	39.95227	http://www.upenn.edu	(215) 898-5000	Philadelphia	United States	Pennsylvania	Northeast	1740	PA	Private not-for-profit	Doctoral Universities: Very High Research Activity	6	30688	14202	59744979	57	47


CREATE TABLE top_colleges_2022 (
  "description" VARCHAR,
  "rank" BIGINT,
  "organizationname" VARCHAR,
  "state" VARCHAR,
  "studentpopulation" BIGINT,
  "campussetting" VARCHAR,
  "medianbasesalary" DOUBLE,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "website" VARCHAR,
  "phonenumber" VARCHAR,
  "city" VARCHAR,
  "country" VARCHAR,
  "state_1" VARCHAR,
  "region" VARCHAR,
  "yearfounded" DOUBLE,
  "statecode" VARCHAR,
  "collegetype" VARCHAR,
  "carnegieclassification" VARCHAR,
  "studentfacultyratio" BIGINT,
  "totalstudentpop" BIGINT,
  "undergradpop" BIGINT,
  "totalgrantaid" DOUBLE,
  "percentofstudentsfinaid" DOUBLE,
  "percentofstudentsgrant" DOUBLE
);