Home Data Academic & Education Colleges & Universities US Colleges

US 3,349 Colleges Data: Race Ethnicity Stats, Phone, Website, 9,684 Financial Aid

Name	n3_chennan_college_educationcorner_com
Data	15.69M (+ 0B)
Tables	9 (+ 0)
Columns	60 (+ 0)
Table Rows	58,979 (+ 0)
Media	0B (+ 0B)
Files	0 (+ 0)
Last Commit	2023-06-19 18:36:38 (+ 169 d)

This is a comprehensive colleges directory of 3,349 4-year colleges and universities across over 59 states in the United States. Each college record is comprised of title, description, phone number, address, size, in state tuition, out of state tuition, undergraduates, school type, varsity athletics, acceptance rate, etc. The US colleges database also contains information such as enrollment statistics with 59 records, 9,684 financial aid and 505 student race ethnicity records. The whole United States colleges and universities data set has 9 tables.

Data Samples

Main List (for Desktop / for Mobile) / JSON / XML / Excel / CSV (Download CSV) / View by Table

Data APIs

http://n3.datasn.io/data/api/v1/n3_chennan/list_of_all_colleges_in_the_usa/ (By Table)

Tables + Columns
Media Files
Updates
Download

Tables & Columns

Tables	Rows	Columns	Non-empty
college	3,349	title	100%
		description	99.55%
		phone	94.33%
		address	94.51%
		institution_type	4.24%
		size	94.36%
		award_levels	4.24%
		in_state_tuition	94.18%
		out_of_state_tuition	94.15%
		online_degrees	0.03%
		student_to_faculty_ratio	90.12%
		web_address	0.03%
		webiste	88.35%
		status	90.09%
		faculty	90.12%
		school_type	90.12%
		affiliation	89.31%
		undergraduates	90.12%
		setting	90.12%
		graduate_students	90.12%
		on_campus_housing	90.12%
		acceptance_rate	90.12%
		varsity_athletics	90.12%
college_x_enrollment_statistics	6,184	college_id	100%
college_x_enrollment_statistics	6,184	enrollment_statistics_id	100%
college_x_financial_aid	11,405	college_id	100%
college_x_financial_aid	11,405	financial_aid_id	100%
college_x_student_race_ethnicity	23,984	college_id	100%
college_x_student_race_ethnicity	23,984	student_race_ethnicity_id	100%
enrollment_statistics	379	key	100%
enrollment_statistics	379	value	81%
financial_aid	9,684	title	100%
		percent_receiving_aid	100%
		average_amount_received	100%
state	59	title	100%
state_x_college	3,430	state_id	100%
state_x_college	3,430	college_id	100%
student_race_ethnicity	505	value	100%

Notes:

Meta columns id and ts are not shown here, but included in columns total.
Some statistical or memo columns are not shown here, but included in columns total.
Non-empty percentage indicates the percent of values that are non-empty for that particular column.

Media Sets

No media sets.

Commits / Updates

Time	Data	Tables	Columns	Rows	Media	Files
2023-06-19 (+ 169 d)	15.69M (+ 0B)	9 (+ 0)	60 (+ 0)	58,979 (+ 0)	0B (+ 0B)	0 (+ 0)
2023-01-01 (+ 95 d)	15.69M (+ 0B)	9 (+ 0)	60 (+ 0)	58,979 (+ 0)	0B (+ 0B)	0 (+ 0)
2022-09-27 (+ 271 d)	15.69M (+ 0B)	9 (+ 0)	60 (+ 0)	58,979 (+ 0)	0B (+ 0B)	0 (+ 0)
2021-12-30 (+ 115 d)	15.69M (+ 0B)	9 (+ 0)	60 (+ 0)	58,979 (+ 0)	0B (+ 0B)	0 (+ 0)
2021-09-05 (+ 150 d)	15.69M (+ 0B)	9 (+ 0)	60 (+ 0)	58,979 (+ 0)	0B (+ 0B)	0 (+ 0)
2021-04-08 (+ 68 d)	15.69M (+ 0B)	9 (+ 0)	60 (+ 0)	58,979 (+ 0)	0B (+ 0B)	0 (+ 0)
2021-01-29 (+ 120 d)	15.69M (+ 0B)	9 (+ 0)	60 (+ 0)	58,979 (+ 0)	0B (+ 0B)	0 (+ 0)
2020-10-01 (+ 38 d)	15.69M (+ 0B)	9 (+ 0)	60 (+ 0)	58,979 (+ 0)	0B (+ 0B)	0 (+ 0)
2020-08-23 (+ 141 d)	15.69M (+ 0B)	9 (+ 0)	60 (+ 0)	58,979 (+ 0)	0B (+ 0B)	0 (+ 0)
2020-04-04 (+ 196 d)	15.69M (+ 0B)	9 (+ 0)	60 (+ 0)	58,979 (+ 0)	0B (+ 0B)	0 (+ 0)
2019-09-21 (+ 197 d)	15.69M (+ 0B)	9 (+ 0)	60 (+ 0)	58,979 (+ 0)	0B (+ 0B)	0 (+ 0)
2019-03-07 (+ 43 d)	15.69M (+ 0B)	9 (+ 0)	60 (+ 0)	58,979 (+ 0)	0B (+ 0B)	0 (+ 0)
2019-01-23 (+ 44 d)	15.69M (+ 0B)	9 (+ 0)	60 (+ 0)	58,979 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-12-09 (+ 29 d)	15.69M (+ 0B)	9 (+ 0)	60 (+ 0)	58,979 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-11-09 (+ 27 d)	15.69M (- 2.48M)	9 (+ 0)	60 (+ 0)	58,979 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-10-13 (+ 29 d)	18.17M (+ 0B)	9 (+ 0)	60 (+ 0)	58,979 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-09-13 (+ 34 d)	18.17M (+ 0B)	9 (+ 0)	60 (+ 0)	58,979 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-08-09 (+ 27 d)	18.17M (+ 0B)	9 (+ 0)	60 (+ 0)	58,979 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-07-12 (+ 31 d)	18.17M (+ 0B)	9 (+ 0)	60 (+ 0)	58,979 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-06-10 (+ 31 d)	18.17M (+ 0B)	9 (+ 0)	60 (+ 0)	58,979 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-05-10 (+ 28 d)	18.17M (+ 0B)	9 (+ 0)	60 (+ 0)	58,979 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-04-11	18.17M	9	60	58,979	0B	0

Download Latest Commit

In the same time, you can also access this data set via API.

Access Now!

How to use

View the page for data details.
Sign up for an account and log in.
Open Online Query to build API addresses / calls.
Open the API address / call to access the data.

FAQ

How to access the data?

Select a membership plan and sign up. Return to this page, click Online Query to access the API query maker. Create and open an API call to acquire the data.
Why are data size increments not in line with those of number of rows?

The scanning and profiling of data size increments are done separately from those of the number of rows.