City Research comparing cities in IL

This is the city expansion aspect of my internship. It's more towards the public relations and marketing side of the city. For this particular assignment, Mr. Muhammad had me compare the top 50 cities in IL base on how well they advertise their city via social networks and the internet.

PUBLIC RELATIONS COMPARISON OF THE TOP 50 CITIES IN ILLINOIS

Rank	Name	Population	Website	Facebook? If yes, #?	Twitter If yes, #?	YouTube? If yes, # of videos?	Online Newsletter?	Public Access TV Station?	Photo Gallery? Video Gallery?
1	Chicago †	2,695,598	http://www.cityofchicago.org/city/en.html		Yes, multiple accounts	Yes 0	Yes	Yes WGNTV	Yes Yes
2	Aurora	197,899	www.aurora-il.org	Yes 10,800	Yes 1,500	Yes, Approx. 20	Yes	Yes ACTV	No – Photos Yes - Videos
3	Rockford †	152,871	www.ci.rockford.il.us www.goRockford.com	Yes 1,737	Yes 1532	Yes 76	Yes	Yes WIFR 23	Yes Yes
4	Joliet †	147,433	www.visitjoliet.org/	Yes 1,620	Yes 1235	Yes 30	Yes	Yes WGBO	No No
5	Naperville	141,853	http://www.naperville.il.us/	Yes 3,545	Yes 7,000	Yes 3	Yes	Yes NCTV17	Yes Yes
6	Springfield ††	116,250	http://www.springfield.il.us/	No	Yes 2,264	No	Yes	Yes WICS	Yes Yes
7	Peoria †	115,007	http://www.peoriagov.org/	Yes 150	Yes 397	No	Yes	Yes CINNEWSNOW	Yes Yes
8	Elgin	108,188	http://www.cityofelgin.org/	Yes 4,841	Yes 1,692	No	Yes	Yes ElginChannel17	Yes Yes
9	Waukegan †	89,078	http://www.waukeganweb.net/	Yes 427	Yes 1,095	Yes 13	Yes	Yes	Yes Yes
10	Cicero	83,891	http://www.thetownofcicero.com/	Yes 2,171	Yes 111	No	Yes
11	Champaign	81,055				Yes 30
12	Bloomington †	76,610				Yes 23
13	Decatur †	76,122				No
14	Arlington Heights	75,101				No
15	Evanston	74,486				Yes 30
16	Schaumburg	74,227				No
17	Bolingbrook	73,366				No
18	Palatine	68,557				No
19	Skokie	64,784				Yes 30
20	Des Plaines	58,364				No
21	Orland Park	56,767				No
22	Tinley Park	56,703				No
23	Oak Lawn	56,690				No
24	Berwyn	56,657				Yes 30
25	Mount Prospect	54,167				No