US CORE LMI DIM_UNITID

Column Name	Snowflake	Big Query	Databricks	Parquet	Comment
ACTIVE	VARCHAR	STRING	STRING	STRING	Indicates whether the educational institution is still operational.
ADDRESS	VARCHAR	STRING	STRING	STRING	Address of the educational institution.
CITY	VARCHAR	STRING	STRING	STRING	City of the educational institution.
CONTROL	FLOAT	FLOAT	DOUBLE	FLOAT	Whether a school is public (1), private-not-for-profit (2), or private-for-profit (3).
COUNTY	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	County of the educational institution.
HBCU	VARCHAR	STRING	STRING	STRING	Historically black colleges and universities.
HSI	VARCHAR	STRING	STRING	STRING	Hispanic serving institutions.
LATITUDE	FLOAT	FLOAT	DOUBLE	FLOAT	Latitude of the educational institution.
LONGITUDE	FLOAT	FLOAT	DOUBLE	FLOAT	Longitude of the educational institution.
NAME	VARCHAR	STRING	STRING	STRING	Educational institution by name.
PHONE	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Contact phone number for the educational institution.
SECTOR	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Sector code of the education institution (e.g., Private-for-profit 2-year, Public 4-year, etc.).
SECTOR_DESCRIPTION	VARCHAR	STRING	STRING	STRING	Sector name of the education institution (e.g., Private-for-profit 2-year, Public 4-year, etc.).
STATEABBREVIATION	VARCHAR	STRING	STRING	STRING	State abbreviation.
STATEFIPS	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	State FIPS code.
UNITID	VARCHAR	STRING	STRING	STRING	Educational institution by ID.
WEBSITE	VARCHAR	STRING	STRING	STRING	Website of the educational institution.
ZIP	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	ZIP code of the educational institution.
ZIP9	VARCHAR	STRING	STRING	STRING	9-digit ZIP code of the educational institution.