Junior Colleges & Technical Institutes Database v.1.0.4

10,939 Junior Colleges

This download database contains records and listings for a range of Junior Colleges as well as a website database of Technical Schools and Institutions. A junior college is like a community college in that the highest degree it awards is the associate's degree, but it is private. A Technical school is a term used for two-year colleges which provide mostly job-preparation skills for trained labor, such as welding, culinary arts and office management.

License Database Purchase Options

	USAGE RIGHTS $50.00	PUBLICATION RIGHTS $150.00	MASTER RIGHTS $300.00
Data Tracking Seeds
Data Modification
Importing
Exporting
Merge
Web Usage
Multiple PC's or Websites
Mobile Development
Updates Available
All Data File Formats
Custom File Formats
Distribution
Copyright Endorsement
	BUY NOW	BUY NOW	BUY NOW

Table Schema Database Field Statistics

Field	Records	Percent	Type	Comment
id	10,939	100%	int(11)	Unique Identifier
biz_name	10,939	100%	varchar(150)	Business Name
biz_info	0	0%	text	Business Information and Description
cat_primary	10,939	100%	varchar(75)	Business Primary Category
cat_sub	10,892	100%	varchar(75)	Business Secondary/Sub Category
e_address	10,855	99%	varchar(100)	Physical Address
e_city	10,939	100%	varchar(50)	Physical Address City
e_state	10,939	100%	varchar(20)	Physical Address State / Province
e_postal	10,939	100%	varchar(7)	Physical Address Postal Code
e_zip_full	0	0%	varchar(10)	Zip +4 for US Physical Addresses
e_country	10,939	100%	varchar(20)	Physical Address Country
loc_county	10,929	100%	varchar(40)	Physical Address County
loc_area_code	10,929	100%	varchar(3)	Physical Address Area Code
loc_FIPS	10,931	100%	varchar(5)	Federal Information Processing Standard - http://www.epa.gov/enviro/html/codes/state.html
loc_MSA	4,791	44%	varchar(5)	Metropolitan Statistical Area - http://www.census.gov/population/www/metroareas/metrodef.html
loc_PMSA	3,924	36%	varchar(5)	Primary Metropolitan Statistical Area - http://www.census.gov/epcd/www/g97geo2.htm
loc_TZ	10,931	100%	varchar(6)	Location Time Zone
loc_DST	10,939	100%	enum('Y','N','U')	Daylight Savings Time (Yes, No, Unknown)
loc_LAT_centroid	10,929	100%	varchar(15)	Latitude (Centroid Based)
loc_LAT_poly	10,835	99%	varchar(15)	Latitude (Precision Polygon Based)
loc_LONG_centroid	10,929	100%	varchar(15)	Longitude (Centroid Based)
loc_LONG_poly	10,835	99%	varchar(15)	Longitude (Precision Polygon Based)
biz_phone	10,934	100%	varchar(20)	Business Phone Number
biz_phone_ext	0	0%	varchar(8)	Business Phone Number Extension
biz_fax	264	2%	varchar(20)	Business Fax Number
biz_email	232	2%	varchar(75)	Business Contact Email Address
web_url	5,781	53%	varchar(175)	Website URL
web_meta_title	1,145	10%	varchar(255)	Website Meta Title
web_meta_desc	1,107	10%	varchar(255)	Website Meta Description
web_meta_keys	1,106	10%	varchar(255)	Website Meta Keywords

Junior Colleges Records Information

United States Junior Colleges

55 Alaska Junior Colleges
230 Alabama Junior Colleges
108 Arkansas Junior Colleges
285 Arizona Junior Colleges
444 California Junior Colleges
290 Colorado Junior Colleges
181 Connecticut Junior Colleges
64 District Of Columbia Junior Colleges
52 Delaware Junior Colleges
431 Florida Junior Colleges
352 Georgia Junior Colleges
70 Hawaii Junior Colleges
144 Iowa Junior Colleges
62 Idaho Junior Colleges
587 Illinois Junior Colleges
306 Indiana Junior Colleges
125 Kansas Junior Colleges
252 Kentucky Junior Colleges
284 Louisiana Junior Colleges
365 Massachusetts Junior Colleges
199 Maryland Junior Colleges
83 Maine Junior Colleges
383 Michigan Junior Colleges
294 Minnesota Junior Colleges
275 Missouri Junior Colleges
167 Mississippi Junior Colleges
46 Montana Junior Colleges
224 North Carolina Junior Colleges
33 North Dakota Junior Colleges
81 Nebraska Junior Colleges
63 New Hampshire Junior Colleges
293 New Jersey Junior Colleges
119 New Mexico Junior Colleges
112 Nevada Junior Colleges
775 New York Junior Colleges
345 Ohio Junior Colleges
184 Oklahoma Junior Colleges
213 Oregon Junior Colleges
465 Pennsylvania Junior Colleges
43 Rhode Island Junior Colleges
185 South Carolina Junior Colleges
39 South Dakota Junior Colleges
264 Tennessee Junior Colleges
431 Texas Junior Colleges
104 Utah Junior Colleges
237 Virginia Junior Colleges
45 Vermont Junior Colleges
295 Washington Junior Colleges
110 Wisconsin Junior Colleges
108 West Virginia Junior Colleges
37 Wyoming Junior Colleges