NOTE: this cleansing file takes approximately 20 min to execute. You will be prompted at the end to enter in your PGAdmin password in order to execute the creation of the SQL tables.
#import dependencies
import pandas as pd #for data analysis
import re #for specifying sets of string matches
import numpy as np #for arrays and matrices
import string
from string import punctuation
#File to Load 1996 t0 2019 to be used as dummy data
sunshine_data_to_load = "Raw Data CSV files/SunShine.csv"
# Create a DataFrame for the Sunshine data.
sunshine_kaggle_df = pd.read_csv(sunshine_data_to_load)
#display the data table for preview
sunshine_kaggle_df.head()
| Sector | Last Name | First Name | Salary Paid | Taxable Benefits | Employer | Job Title | Calendar Year | |
|---|---|---|---|---|---|---|---|---|
| 0 | COLLEGES | Gillett | Robert | 127332.0 | 3633.0 | Algonquin College of Applied Arts and Technology | President | 1996 |
| 1 | COLLEGES | Hanson | Raymonde | 102999.0 | 5557.0 | Algonquin College of Applied Arts and Technology | V.P., Academic | 1996 |
| 2 | COLLEGES | Killeen | Philip | 183482.0 | 878.0 | Algonquin College of Applied Arts and Technology | Past President | 1996 |
| 3 | COLLEGES | Mitchelson | Robert | 106608.0 | 5586.0 | Algonquin College of Applied Arts and Technology | V.P., Finance & Administration | 1996 |
| 4 | COLLEGES | Crombie | Glenn | 111655.0 | 3177.0 | Cambrian College of Applied Arts & Technology | President | 1996 |
# Review datatypes and shape
print(sunshine_kaggle_df.shape)
sunshine_kaggle_df.dtypes
(1470706, 8)
Sector object Last Name object First Name object Salary Paid float64 Taxable Benefits float64 Employer object Job Title object Calendar Year int64 dtype: object
#Change Salarey columsn from FLOAT to INTEGER
sunshine_kaggle_df['Salary Paid'] = sunshine_kaggle_df['Salary Paid'].astype(int)
sunshine_kaggle_df['Taxable Benefits'] = sunshine_kaggle_df['Taxable Benefits'].astype(int)
# Review datatypes and shape
print(sunshine_kaggle_df.shape)
sunshine_kaggle_df.dtypes
(1470706, 8)
Sector object Last Name object First Name object Salary Paid int32 Taxable Benefits int32 Employer object Job Title object Calendar Year int64 dtype: object
# Add sunshine 2020 csv to sunshine_data_df
#File to Load 2020
sunshine_2020_to_load = "Raw Data CSV files/Sunshine-2020-en-utf-8-2022-01-10.csv"
# Create a DataFrame for the Sunshine 2020 data.
sunshine_2020_df = pd.read_csv(sunshine_2020_to_load)
#display the data table for preview
sunshine_2020_df.tail()
| Sector | Last name | First name | Salary | Benefits | Employer | Job title | Year | |
|---|---|---|---|---|---|---|---|---|
| 205850 | Universities | Zylberberg | Joel | $141,478.88 | $727.20 | York University | Assistant Professor / Canada Research Chair | 2020 |
| 205851 | Universities | Zylla | Phil | $127,898.47 | $231.93 | McMaster Divinity College | Vice President Academic | 2020 |
| 205852 | Universities | Zytaruk | Nicole | $113,582.77 | $231.93 | McMaster University | Research Associate | 2020 |
| 205853 | Universities | Zytner | Richard | $193,168.37 | $1,906.08 | University Of Guelph | Professor | 2020 |
| 205854 | Universities | Zywno | Malgorzata | $204,615.20 | $1,130.48 | Ryerson University | Professor | 2020 |
# Remove $ from string columns Salary and Benefits
sunshine_2020_df['Salary'] = sunshine_2020_df['Salary'].str.replace('$',"")
sunshine_2020_df['Salary'] = sunshine_2020_df['Salary'].str.replace(',',"")
sunshine_2020_df['Benefits'] = sunshine_2020_df['Benefits'].str.replace('$',"")
sunshine_2020_df['Benefits'] = sunshine_2020_df['Benefits'].str.replace(',',"")
C:\Users\Danielle Spring\anaconda3\envs\PythonData\lib\site-packages\ipykernel_launcher.py:2: FutureWarning: The default value of regex will change from True to False in a future version. In addition, single character regular expressions will*not* be treated as literal strings when regex=True. C:\Users\Danielle Spring\anaconda3\envs\PythonData\lib\site-packages\ipykernel_launcher.py:4: FutureWarning: The default value of regex will change from True to False in a future version. In addition, single character regular expressions will*not* be treated as literal strings when regex=True. after removing the cwd from sys.path.
# Review datatypes and shape
print(sunshine_2020_df.shape)
sunshine_2020_df.dtypes
(205855, 8)
Sector object Last name object First name object Salary object Benefits object Employer object Job title object Year int64 dtype: object
# #Change Salary & Taxable benefits to float
sunshine_2020_df['Salary'] = pd.to_numeric(sunshine_2020_df['Salary'],errors='coerce')
sunshine_2020_df['Benefits'] = pd.to_numeric(sunshine_2020_df['Benefits'],errors='coerce')
sunshine_2020_df.dtypes
Sector object Last name object First name object Salary float64 Benefits float64 Employer object Job title object Year int64 dtype: object
#Change Salarey columsn from FLOAT to INTEGER
sunshine_2020_df['Salary'] = sunshine_2020_df['Salary'].astype(int)
sunshine_2020_df['Benefits'] = sunshine_2020_df['Benefits'].astype(int)
# Confirm data types
sunshine_2020_df.dtypes
Sector object Last name object First name object Salary int32 Benefits int32 Employer object Job title object Year int64 dtype: object
# Rename 2020 column headers to match Sunshine list
sunshine_2020_df.rename({'Sector':'Sector',
'Last name':'Last Name',
'First name':'First Name',
'Salary':'Salary Paid',
'Benefits':'Taxable Benefits',
'Employer':'Employer',
'Job title':'Job Title',
'Year':'Calendar Year'
}, axis='columns', inplace=True)
#Create consolidated sunshine list DataFrame - combine the consolidated kaggle file with the 2020 sunshine data
sunshine_data_df= sunshine_kaggle_df.append(sunshine_2020_df, ignore_index = True)
print(sunshine_data_df.shape)
sunshine_data_df.tail()
(1676561, 8)
| Sector | Last Name | First Name | Salary Paid | Taxable Benefits | Employer | Job Title | Calendar Year | |
|---|---|---|---|---|---|---|---|---|
| 1676556 | Universities | Zylberberg | Joel | 141478 | 727 | York University | Assistant Professor / Canada Research Chair | 2020 |
| 1676557 | Universities | Zylla | Phil | 127898 | 231 | McMaster Divinity College | Vice President Academic | 2020 |
| 1676558 | Universities | Zytaruk | Nicole | 113582 | 231 | McMaster University | Research Associate | 2020 |
| 1676559 | Universities | Zytner | Richard | 193168 | 1906 | University Of Guelph | Professor | 2020 |
| 1676560 | Universities | Zywno | Malgorzata | 204615 | 1130 | Ryerson University | Professor | 2020 |
#find null values
for column in sunshine_data_df.columns:
print(f"Column {column} has {sunshine_data_df[column].isnull().sum()}null values")
Column Sector has 0null values Column Last Name has 0null values Column First Name has 3null values Column Salary Paid has 0null values Column Taxable Benefits has 0null values Column Employer has 0null values Column Job Title has 0null values Column Calendar Year has 0null values
# Drop First Name rows with missing information
sunshine_data_df = sunshine_data_df.dropna(how='any')
sunshine_data_df.head()
| Sector | Last Name | First Name | Salary Paid | Taxable Benefits | Employer | Job Title | Calendar Year | |
|---|---|---|---|---|---|---|---|---|
| 0 | COLLEGES | Gillett | Robert | 127332 | 3633 | Algonquin College of Applied Arts and Technology | President | 1996 |
| 1 | COLLEGES | Hanson | Raymonde | 102999 | 5557 | Algonquin College of Applied Arts and Technology | V.P., Academic | 1996 |
| 2 | COLLEGES | Killeen | Philip | 183482 | 878 | Algonquin College of Applied Arts and Technology | Past President | 1996 |
| 3 | COLLEGES | Mitchelson | Robert | 106608 | 5586 | Algonquin College of Applied Arts and Technology | V.P., Finance & Administration | 1996 |
| 4 | COLLEGES | Crombie | Glenn | 111655 | 3177 | Cambrian College of Applied Arts & Technology | President | 1996 |
#Create Total compensation columns
sunshine_data_df["total_compensation"] = sunshine_data_df['Salary Paid']+sunshine_data_df['Taxable Benefits']
#Create cleansed_employer column
sunshine_data_df["clean_employer"] = sunshine_data_df['Employer']
#Create cleansed job title column
sunshine_data_df["clean_job_title"] = sunshine_data_df['Job Title']
#Create cleansed first name column
sunshine_data_df["clean_first_name"] = sunshine_data_df['First Name']
sunshine_data_df["final_first_name"] = 'TBD'
#Create Gender column
sunshine_data_df["gender"] = None
#TO DO - pending decision if we want to attempt predicting age based on first name
# #Create Age column
# sunshine_data_df['age']=None
# # Age may be on hold---leave code in case it is left in
# # #change age from object to numeric
# sunshine_data_df["age"] = sunshine_data_df["age"].apply(pd.to_numeric,errors='ignore')
# #Create City column
sunshine_data_df["city"] = sunshine_data_df['Employer']
#Create character count on First Name column
sunshine_data_df["first_char_count"] = sunshine_data_df['First Name'].str.len()
# Review First Name based on word count
sunshine_data_df['word_count'] = sunshine_data_df['clean_first_name'].str.split().str.len()
# #Create a Salary binning column
sunshine_data_df["salary_bin"] = sunshine_data_df['Salary Paid']
sunshine_data_df.head()
| Sector | Last Name | First Name | Salary Paid | Taxable Benefits | Employer | Job Title | Calendar Year | total_compensation | clean_employer | clean_job_title | clean_first_name | final_first_name | gender | city | first_char_count | word_count | salary_bin | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | COLLEGES | Gillett | Robert | 127332 | 3633 | Algonquin College of Applied Arts and Technology | President | 1996 | 130965 | Algonquin College of Applied Arts and Technology | President | Robert | TBD | None | Algonquin College of Applied Arts and Technology | 6 | 1 | 127332 |
| 1 | COLLEGES | Hanson | Raymonde | 102999 | 5557 | Algonquin College of Applied Arts and Technology | V.P., Academic | 1996 | 108556 | Algonquin College of Applied Arts and Technology | V.P., Academic | Raymonde | TBD | None | Algonquin College of Applied Arts and Technology | 8 | 1 | 102999 |
| 2 | COLLEGES | Killeen | Philip | 183482 | 878 | Algonquin College of Applied Arts and Technology | Past President | 1996 | 184360 | Algonquin College of Applied Arts and Technology | Past President | Philip | TBD | None | Algonquin College of Applied Arts and Technology | 6 | 1 | 183482 |
| 3 | COLLEGES | Mitchelson | Robert | 106608 | 5586 | Algonquin College of Applied Arts and Technology | V.P., Finance & Administration | 1996 | 112194 | Algonquin College of Applied Arts and Technology | V.P., Finance & Administration | Robert | TBD | None | Algonquin College of Applied Arts and Technology | 6 | 1 | 106608 |
| 4 | COLLEGES | Crombie | Glenn | 111655 | 3177 | Cambrian College of Applied Arts & Technology | President | 1996 | 114832 | Cambrian College of Applied Arts & Technology | President | Glenn | TBD | None | Cambrian College of Applied Arts & Technology | 5 | 1 | 111655 |
The sector column will be cleansed to standardize and consolidate the sector names for visualization purposes. In addition, it will correct for inconsistent naming conventions from year to year for certain sectors.
#Review the various categories in Sector column
sunshine_data_df['Sector'].value_counts()
Municipalities and Services 272130
Universities 261393
School Boards 232193
Municipalities & Services 135202
Hospitals and Boards of Public Health 118189
...
Seconded (Attorney General) 1
Seconded (Ministry of Labour)* 1
Seconded (Transportation)* 1
Seconded (Economic Development & Trade)* 1
Seconded (Research and Innovation)* 1
Name: Sector, Length: 81, dtype: int64
#Cleanse and Rename sector names
sunshine_data_df.loc[sunshine_data_df['Sector'].str.contains('Seconded', case=False), 'Sector'] = 'Public Sector'
sunshine_data_df.loc[sunshine_data_df['Sector'].str.contains('Other Public', case=False), 'Sector'] = 'Public Sector'
sunshine_data_df.loc[sunshine_data_df['Sector'].str.contains('Public Service', case=False), 'Sector'] = 'Public Sector'
sunshine_data_df.loc[sunshine_data_df['Sector'].str.contains('Government of Ontario', case=False), 'Sector'] = 'Government of Ontario'
sunshine_data_df.loc[sunshine_data_df['Sector'].str.contains('Universiti', case=False), 'Sector'] = 'Post Secondary'
sunshine_data_df.loc[sunshine_data_df['Sector'].str.contains('College', case=False), 'Sector'] = 'Post Secondary'
sunshine_data_df.loc[sunshine_data_df['Sector'].str.contains('Hospital', case=False), 'Sector'] = 'Hospitals'
sunshine_data_df.loc[sunshine_data_df['Sector'].str.contains('School', case=False), 'Sector'] = 'Schools'
sunshine_data_df.loc[sunshine_data_df['Sector'].str.contains('Municipal', case=False), 'Sector'] = 'Municipalitites'
# Clean up Sector category. Replace 'Self Employed' and 'Self' with 'Self-Employed'
sunshine_data_df['Sector'] = sunshine_data_df['Sector'].replace({'Hydro One & Ontario Power Generation':'Hydro/OPG',
'Hydro One and Ontario Power Generation':'Hydro/OPG',
'Ontario Power Generation':'Hydro/OPG',
'CROWN AGENCIES':'Crown Agencies'
})
# Convert all sunshine_data_df['First Name'] to str.lower()
sunshine_data_df['Last Name']=sunshine_data_df['Last Name'].str.lower()
#Capitalize first letter of Last Name
last_name=sunshine_data_df['Last Name']
sunshine_data_df['Last Name']=last_name.str.capitalize()
The Employer is a cleansed column of the Sunshine Employer column for the purpose of standardizing and consolidation of employers for visualization purposes. In addition, it will correct for inconsistent naming conventions from year to year for certain employers.
#Review the various categories in Sector column
sunshine_data_df['clean_employer'].value_counts()
Ontario Power Generation 137335
University of Toronto 47240
City of Toronto 46561
City of Toronto - Police Service 36985
Hydro One 32331
...
Waterloo Accelerator Centre 1
Child Witness Centre Of Waterloo Region 1
Recycling Congress of Ontario 1
Peterborough Community Access 1
Superior North Catholic Dist. School 1
Name: clean_employer, Length: 8666, dtype: int64
#Standardize and Rename all cleansed employer column
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains("City of Barrie", case=False), 'clean_employer'] = "City"
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains("City of Brampton", case=False), 'clean_employer'] = "City"
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains("City of London", case=False), 'clean_employer'] = "City"
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains("City of Ottawa", case=False), 'clean_employer'] = "City"
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains("City of Toronto", case=False), 'clean_employer'] = "City"
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains(" Spanish", case=False), 'clean_employer'] = "Centre for Spanish Speaking Peoples"
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains("Algonquin Forest", case=False), 'clean_employer'] = "Algonquin Forest Authority"
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains("Amity Goodwill", case=False), 'clean_employer'] = "Amity Goodwill Industries"
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains("Assessment Review", case=False), 'clean_employer'] = "Assessment Review Board"
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains("Association Franco-Ont", case=False), 'clean_employer'] = "Association Franco-Ontarienne Des Conseils Scolaire Catholiques"
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains("Barbara Black", case=False), 'clean_employer'] = "Barbara Black Centre for Youth Res."
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains("Bellwoods Centres", case=False), 'clean_employer'] = "Bellwoods Centres for Community Living Incorporated"
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains("Big Brothers", case=False), 'clean_employer'] = "Big Brothers Big Sisters of Canada"
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains("BioDiscovery", case=False), 'clean_employer'] = "BioDiscovery Toronto Incorporated"
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains("Bloorview MacMillan", case=False), 'clean_employer'] = "Bloorview MacMillan Children's Centre"
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains("Board of Health", case=False), 'clean_employer'] = "Board of Health"
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains("Cambrian", case=False), 'clean_employer'] = "Cambrian College of Applied Arts & Technology"
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains("Canadore ", case=False), 'clean_employer'] = "Canadore College of Applied Arts and Technology"
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains("Carlington Community ", case=False), 'clean_employer'] = "Carlington Community Health Centre"
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains("Catholic C.A.S", case=False), 'clean_employer'] = "CCAC"
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains("Catholic Children's Aid", case=False), 'clean_employer'] = "CCAC"
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains("Centennial", case=False), 'clean_employer'] = "Centennial College Of Applied Arts and Technology"
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains("Central Toronto Comm", case=False), 'clean_employer'] = "Central Toronto Community Health Centres"
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains("Centretown Community", case=False), 'clean_employer'] = "Centretown Community Health Centre Inc."
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains("Children's Aid Soc", case=False), 'clean_employer'] = "Children's Aid Society"
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains("Citizenship", case=False), 'clean_employer'] = "Citizenship & Immigration"
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains("Gaming Commission", case=False), 'clean_employer'] = "Alcohol & Gaming Commission of Ontario"
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains("Hearing Society", case=False), 'clean_employer'] = "Canadian Hearing Society"
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains("John Howard Society ", case=False), 'clean_employer'] = "The John Howard Society"
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains("Paraplegic ", case=False), 'clean_employer'] = "Canadian Paraplegic Association Ont."
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains("Southlake Regional", case=False), 'clean_employer'] = "Southlake Regional Health Centre"
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains("Sport Alliance", case=False), 'clean_employer'] = "Sport Alliance of Ontario"
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains("St. Alban", case=False), 'clean_employer'] = "St. Alban's Boys' & Girls' Club"
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains("St. Demetrius", case=False), 'clean_employer'] = "St. Demetrius (Ukrainian Catholic) Development Corp."
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains("St. Peter", case=False), 'clean_employer'] = "St. Peter's Hospital"
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains("Stevenson Memorial Hospital", case=False), 'clean_employer'] = "Stevenson Memorial Hospital"
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains("Sunnybrook", case=False), 'clean_employer'] = "Sunnybrook Hospital"
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains("Victorian Order ", case=False), 'clean_employer'] = "Victorian Order of Nurses"
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains("YMCA ", case=False), 'clean_employer'] = "YMCA"
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains('Aboriginal Affairs', case=False), 'clean_employer'] = 'Aboriginal Affairs'
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains('Accessible Community Counselling', case=False), 'clean_employer'] = 'Accessible Community Counselling & Employment Services'
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains('Agriculture', case=False), 'clean_employer'] = 'Agriculture, Food & Rural Affairs'
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains('Algonquin Opportunity', case=False), 'clean_employer'] = 'Algonquin Opportunity (No 2) Corporation'
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains('Algonquin Opportunity', case=False), 'clean_employer'] = 'Algonquin Opportunity (No 2) Corporation'
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains('Alzheimer Society', case=False), 'clean_employer'] = 'Alzheimer Society'
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains('Canadian Mental Health', case=False), 'clean_employer'] = 'Canadian Mental Health Association'
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains('Canadian Red Cross', case=False), 'clean_employer'] = 'Canadian Red Cross'
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains('CAS', case=False), 'clean_employer'] = 'CAS'
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains('Catholic Children', case=False), 'clean_employer'] = "Catholic Children's Aid Society"
sunshine_data_df.loc[sunshine_data_df['clean_employer'].str.contains('CCAC', case=False), 'clean_employer'] = "CCAC"
The city column has been created using the employer column and job title where city has been specifically noted. Many employers such as hospitals, school boards and agencies have been looked up for city headquarter information.
#Review Employer Names to identify city
sunshine_data_df['city'].value_counts()
Ontario Power Generation 137335
University of Toronto 47240
City of Toronto 46561
City of Toronto - Police Service 36985
Hydro One 32331
...
Waterloo Accelerator Centre 1
Child Witness Centre Of Waterloo Region 1
Recycling Congress of Ontario 1
Peterborough Community Access 1
Superior North Catholic Dist. School 1
Name: city, Length: 8666, dtype: int64
#Review Employer Names to identify city
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Algoma", case=False), 'city'] = "Algoma"
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Anishinabek", case=False), 'city'] = "Anishinabeck"
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Antikokan", case=False), 'city'] = "Antikokan"
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Arnprior", case=False), 'city'] = "Arnprior"
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Belleville", case=False), 'city'] = "Belleville"
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Bramalea", case=False), 'city'] = "Bramalea"
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Brockville", case=False), 'city'] = "Brockville"
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Lanark", case=False), 'city'] = "Lanark"
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Port Colborne", case=False), 'city'] = "Port Colborne"
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Timiskaming", case=False), 'city'] = "Timiskaming"
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Ancaster', case=False), 'city'] = 'Ancaster'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Aurora', case=False), 'city'] = 'Aurora'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Barrie', case=False), 'city'] = 'Barrie'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Georgian College', case=False), 'city'] = 'Barrie'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Georgian", case=False), 'city'] = 'Barrie'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Bowmanville', case=False), 'city'] = 'Bowmanville'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Brampton', case=False), 'city'] = 'Brampton'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Brant", case=False), 'city'] = 'Brant'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Brant County", case=False), 'city'] = 'Brant County'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Brantford', case=False), 'city'] = 'Brantford'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Burlington", case=False), 'city'] = 'Burlington'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Cambridge", case=False), 'city'] = 'Cambridge'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Chatham', case=False), 'city'] = 'Chatham'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Clarington", case=False), 'city'] = 'Clarington'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Cobourg', case=False), 'city'] = 'Cobourg'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Cochrane', case=False), 'city'] = 'Cochrane'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Cornwall', case=False), 'city'] = 'Cornwall'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Dryden", case=False), 'city'] = 'Dryden'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Durham", case=False), 'city'] = 'Durham'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("East York", case=False), 'city'] = 'East York'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Etobicoke", case=False), 'city'] = 'Etobicoke'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Guelph", case=False), 'city'] = 'Guelph'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Haliburton", case=False), 'city'] = 'Haliburton'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Halton', case=False), 'city'] = 'Halton'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Hamilton', case=False), 'city'] = 'Hamilton'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('McMaster', case=False), 'city'] = 'Hamilton'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Mohawk College', case=False), 'city'] = 'Hamilton'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Hawkesbury', case=False), 'city'] = 'Hawkesbury'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Huntsville", case=False), 'city'] = 'Huntsville'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Kanata", case=False), 'city'] = 'Kanata'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Kapuskasing", case=False), 'city'] = 'Kapuskasing'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Kawartha', case=False), 'city'] = 'Kawartha Lakes'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Kenora", case=False), 'city'] = 'Kenora'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Kingston', case=False), 'city'] = 'Kingston'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Queen's University", case=False), 'city'] = 'Kingston'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Queen's", case=False), 'city'] = 'Kingston'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Temiskaming', case=False), 'city'] = 'Kirkland Lake'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Kirkland Lake", case=False), 'city'] = 'Kirkland Lake'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Kitchener', case=False), 'city'] = 'Kitchener'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('London', case=False), 'city'] = 'London'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('University of Western', case=False), 'city'] = 'London'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Western Ont.", case=False), 'city'] = 'London'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Mattawa', case=False), 'city'] = 'Mattawa'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Manitoulin', case=False), 'city'] = 'Manitoulin'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Markham', case=False), 'city'] = 'Markham'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Mississauga', case=False), 'city'] = 'Mississauga'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Muskoka', case=False), 'city'] = 'Muskoka'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Napean", case=False), 'city'] = 'Napean'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Niagara', case=False), 'city'] = 'Niagara Falls'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Norfolk", case=False), 'city'] = 'Norfolk'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('North Bay', case=False), 'city'] = 'North Bay'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('North York', case=False), 'city'] = 'North York'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Oakville', case=False), 'city'] = 'Oakville'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Orillia', case=False), 'city'] = 'Orillia'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Oshawa', case=False), 'city'] = 'Oshawa'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Ottawa', case=False), 'city'] = 'Ottawa'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Carleton University', case=False), 'city'] = 'Ottawa'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Carleton Board", case=False), 'city'] = 'Ottawa'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Ottawa BE ", case=False), 'city'] = 'Ottawa'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Bruce-Grey", case=False), 'city'] = 'Owen Sound'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Bruce County", case=False), 'city'] = 'Owen Sound'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Parry Sound", case=False), 'city'] = 'Parry Sound'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Pembroke", case=False), 'city'] = 'Pembroke'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Peterborough', case=False), 'city'] = 'Peterborough'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Trent U", case=False), 'city'] = 'Peterborough'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Sir Sandford Fleming", case=False), 'city'] = 'Peterborough'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Peterboro", case=False), 'city'] = 'Peterborough'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Petrolia", case=False), 'city'] = 'Petrolia'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Pickering', case=False), 'city'] = 'Pickering'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Port Hope', case=False), 'city'] = 'Port Hope'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Prescott', case=False), 'city'] = 'Prescott'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Renfrew', case=False), 'city'] = 'Renfrew'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Richmond Hill', case=False), 'city'] = 'Richmond Hill'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Sarnia', case=False), 'city'] = 'Sarnia'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Sault Ste. Marie', case=False), 'city'] = 'Sault Ste. Marie'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Sault Ste. Marie', case=False), 'city'] = 'Sault Ste. Marie'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Scarborough', case=False), 'city'] = 'Scarborough'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Peel', case=False), 'city'] = 'Shelburne'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Dufferin", case=False), 'city'] = 'Shelburne'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('St. Catharines', case=False), 'city'] = 'St. Catherines'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('St. Thomas', case=False), 'city'] = 'St. Thomas'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Stoney Creek", case=False), 'city'] = 'Stoney Creek'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Stratford', case=False), 'city'] = 'Stratford'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Strathroy', case=False), 'city'] = 'Strathroy'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Sudbury', case=False), 'city'] = 'Sudbury'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Thunder Bay', case=False), 'city'] = 'Thunder Bay'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Tillsonburg', case=False), 'city'] = 'Tillsonburg'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Timmins", case=False), 'city'] = 'Timmins'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Toronto', case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Ryerson University', case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Seneca College', case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Sunnybrook', case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Metrolinx', case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('York University', case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('The Hospital for Sick Children', case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('St . Michael', case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Mount Sinai Hospital', case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Michael Garron Hospital', case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('George Brown College', case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Women's College Hospital", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Ryerson", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("George Brown", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Seneca", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Princess Margaret", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Ont. College of Art ", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Trenton', case=False), 'city'] = 'Trenton'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Tweed", case=False), 'city'] = 'Tweed'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Vaughan', case=False), 'city'] = 'Vaughan'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Wasaga Beach', case=False), 'city'] = 'Wasaga Beach'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Waterloo', case=False), 'city'] = 'Waterloo'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Wilfrid Laurier", case=False), 'city'] = 'Waterloo'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Welland', case=False), 'city'] = 'Welland'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Whitby", case=False), 'city'] = 'Whitby'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Windsor', case=False), 'city'] = 'Windsor'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains('Woodstock', case=False), 'city'] = 'Woodstock'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Woolwich", case=False), 'city'] = 'Woolwich'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Burlington", case=False), 'city'] = 'Burlington'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Brockville", case=False), 'city'] = 'Brockville'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Brockton", case=False), 'city'] = 'Brockton'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Brighton", case=False), 'city'] = 'Brighton'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Brampton", case=False), 'city'] = 'Brampton'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Bancroft", case=False), 'city'] = 'Bancroft'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Banyan", case=False), 'city'] = 'Banyan'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Bellville", case=False), 'city'] = 'Belleville'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Bowmanville", case=False), 'city'] = 'Bowmanville'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Blue Mountain", case=False), 'city'] = 'Collingwood'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Bloorview", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Carleton", case=False), 'city'] = 'Ottawa'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Carlington", case=False), 'city'] = 'Clarington'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Owen", case=False), 'city'] = 'Owen Sound'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Elgin", case=False), 'city'] = 'Elgin'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Hasting", case=False), 'city'] = 'Belleville'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Alexandra Marine And General Hospital", case=False), 'city'] = 'Goderich'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Algonquin & Lakeshore", case=False), 'city'] = 'Kingston'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Algonquin College of Applied Arts and Technology", case=False), 'city'] = 'Nepean'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Algonquin Forestry", case=False), 'city'] = 'Huntsville'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Almonte General Hospital", case=False), 'city'] = 'St. Almonte'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Art Gallery of Ontario", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Assessment Review Board", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Avon Maitland District School Board", case=False), 'city'] = 'Seaforth'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Baycrest Centre for Geriatric Care", case=False), 'city'] = 'North York'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Bethesda", case=False), 'city'] = 'Thorold'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Bluewater District School Board", case=False), 'city'] = 'Chesley'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Bluewater Health", case=False), 'city'] = 'Sarnia'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Brescia University College", case=False), 'city'] = 'London'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Bridgepoint Hospital", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Brock University", case=False), 'city'] = 'St. Catherines'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Bruyère Continuing Care", case=False), 'city'] = 'Ottawa'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Cabinet Office", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Campbellford", case=False), 'city'] = 'Campbellford'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Canadore College", case=False), 'city'] = 'Nipissing'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Cancer Care Ontario", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Catholic District School Board of Eastern Ontario", case=False), 'city'] = 'Kemptville'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Centennial College", case=False), 'city'] = 'Scarborough'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Centre for Addiction & Mental He", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Centre for Addiction and Mental He", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Children's Hospital of Eastern Ont", case=False), 'city'] = 'Ottawa'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Children's Hosp. of East", case=False), 'city'] = 'Ottawa'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("St Catherines", case=False), 'city'] = 'St. Catherines'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("College Boreal", case=False), 'city'] = 'Ottawa'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Conestoga", case=False), 'city'] = 'Kitchener'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Confederation College", case=False), 'city'] = 'Thunder Bay'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Conseil De La Cooperation De L'Ontario", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Conseil des écoles catholiques du Centre-Est", case=False), 'city'] = 'Gloucester'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Conseil Des Écoles Publiques De L’est De L’ontario", case=False), 'city'] = 'Ottawa'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Conseil Scolaire Catholique Centre-Sud", case=False), 'city'] = 'North York'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Conseil scolaire catholique de district des Grandes Rivières", case=False), 'city'] = 'Timmins'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Conseil scolaire catholique de l'Est ontarien", case=False), 'city'] = "L'Orignal"
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Conseil Scolaire Catholique Des Aurores Boréales", case=False), 'city'] = 'Thunder Bay'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Conseil Scolaire Catholique Des Grandes Rivières", case=False), 'city'] = 'Timmins'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Conseil scolaire catholique du Nouvel-Ontario", case=False), 'city'] = 'Sudbury'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Conseil Scolaire Catholique Franco-Nord", case=False), 'city'] = 'North Bay'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Conseil scolaire de district catholique Centre-Sud", case=False), 'city'] = 'North York'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Conseil scolaire de district catholique de l'Est ontarien", case=False), 'city'] = "L'Orignal"
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Conseil Scolaire De District Catholique Du Nouvel-Ontario", case=False), 'city'] = 'Sudbury'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Conseil Scolaire Viamonde", case=False), 'city'] = 'North York'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("District School Board Ontario North East", case=False), 'city'] = 'Schumacher'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Dunnville Haldimand War Memorial", case=False), 'city'] = 'Dunnville'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Fanshawe College", case=False), 'city'] = 'London'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Grand Erie District School Board", case=False), 'city'] = 'Brantford'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Grand River Hospital", case=False), 'city'] = 'Kitchener'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Greater Essex County District School Board", case=False), 'city'] = 'Windsor'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Grey Bruce", case=False), 'city'] = 'Owen Sound'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Health Sciences North", case=False), 'city'] = 'Sudbury'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Hôpital Montfort", case=False), 'city'] = 'Ottawa'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Hotel-Dieu Grace", case=False), 'city'] = 'Windsor'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Hotel–Dieu Grace", case=False), 'city'] = 'Windsor'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Hospital for Sick Children", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Hotel Dieu Hospital / l'Hôpital Hôtel-", case=False), 'city'] = 'Kingston'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Humber River", case=False), 'city'] = 'North York'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Huron Perth", case=False), 'city'] = 'Stratford'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("John McGivney", case=False), 'city'] = 'Windsor'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("La Cité", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Lake of the woods", case=False), 'city'] = 'Kenora'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Lakehead", case=False), 'city'] = 'Thunder Bay'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Lakeridge Health", case=False), 'city'] = 'Oshawa'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Lambton", case=False), 'city'] = 'Sarnia'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Limestone District School Board", case=False), 'city'] = 'Kingston'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Liquor Control Board of Ontario", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Listowel", case=False), 'city'] = 'Listowel'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Loyalist College", case=False), 'city'] = 'Bancroft'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Mackenzie Health", case=False), 'city'] = 'Richmond Hill'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Municipal Property Assessment Corporation", case=False), 'city'] = 'Pickering'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Natural Resources And Forestry", case=False), 'city'] = 'Peterborough'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Near North District School Board", case=False), 'city'] = 'Parry Sound'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Nipissing", case=False), 'city'] = 'North Bay'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Nishnawbe", case=False), 'city'] = 'Nishnawbe-Aski '
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Northeastern Catholic District School Board", case=False), 'city'] = 'Cochrane'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Northeastern CDSB", case=False), 'city'] = 'Cochrane'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Northeastern RCDSB", case=False), 'city'] = 'Cochrane'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Northern College of Applied Arts & Technology", case=False), 'city'] = 'Scarborough'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Northern College of Applied Arts and Technology", case=False), 'city'] = 'Scarborough'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("OMERS", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Ontario College of Art ", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Ontario Energy Board", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Ontario Hospital Association", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Ontario Infrastructure and Lands Corporation", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Ontario Infrastructure & Lands Corporation", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Ontario Institute for", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Ontario Lottery", case=False), 'city'] = 'Sault Ste. Marie'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Ontario Securities Commission", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Ontario Shores Centre For Mental Health Sciences", case=False), 'city'] = 'Whitby'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Ornge", case=False), 'city'] = 'Mississauga'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Providence Care ", case=False), 'city'] = 'Kingston'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Providence Cont ", case=False), 'city'] = 'Kingston'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Queen’s University", case=False), 'city'] = 'Kingston'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Rainbow District School Board", case=False), 'city'] = 'Sudbury'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Municipality Of York", case=False), 'city'] = 'Pickering'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Rouge Valley", case=False), 'city'] = 'Scarborough'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Royal Ontario Museum", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Royal Victoria Regional Health Centre", case=False), 'city'] = 'Barrie'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Royal Victoria Hospital", case=False), 'city'] = 'Barrie'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Sault", case=False), 'city'] = 'Sault Ste. Marie'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Sheridan College", case=False), 'city'] = 'Oakville'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Simcoe County", case=False), 'city'] = 'Barrie'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Sinai", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Southlake", case=False), 'city'] = 'New Market'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("St Lawrence College", case=False), 'city'] = 'Kingston'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("St. Clair Catholic District School Board", case=False), 'city'] = 'Wallaceburg'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("St. Clair Catholic DSB", case=False), 'city'] = 'Wallaceburg'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("St. Clair ", case=False), 'city'] = 'Wallaceburg'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("St. Michael's Hospital", case=False), 'city'] = 'Wallaceburg'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Superior-Greenstone", case=False), 'city'] = 'Marathon'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Superior--Greenstone", case=False), 'city'] = 'Marathon'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Superior North", case=False), 'city'] = 'Terrace Bay'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Thames Valley", case=False), 'city'] = 'London'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Credit Valley", case=False), 'city'] = 'Mississauga'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Ajax", case=False), 'city'] = 'Ajax'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Innisfil", case=False), 'city'] = 'Innisfil'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Midland", case=False), 'city'] = 'Midland'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Milton", case=False), 'city'] = 'Milton'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("New Market", case=False), 'city'] = 'New Market'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Orangeville", case=False), 'city'] = 'Orangeville'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Trillium Health", case=False), 'city'] = 'Mississauga'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Trillium Lakelands", case=False), 'city'] = 'Kawartha Lakes'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("University Health Network", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Ontario Institute of Technology", case=False), 'city'] = 'Oshawa'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Upper Canada", case=False), 'city'] = 'Brockville'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Weeneebayko", case=False), 'city'] = 'Weeneebayko'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Wellington", case=False), 'city'] = 'Wellington'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("West Park", case=False), 'city'] = 'York'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("William Osler", case=False), 'city'] = 'Brampton'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("York", case=False), 'city'] = 'York'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("South Simcoe", case=False), 'city'] = 'Barrie'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Canadian Institute For Health Info", case=False), 'city'] = 'Ottawa'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Ross Memorial Hospital", case=False), 'city'] = 'Lindsay'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Huron-Superior Catholic District School Board", case=False), 'city'] = "Sault Ste. Marie"
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Treasury Board Secretariat", case=False), 'city'] = 'Ottawa'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Workplace Safety And Insurance Board", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Upper Grand District School Board", case=False), 'city'] = 'Guelph'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Algonquin College", case=False), 'city'] = 'Nepean'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Humber", case=False), 'city'] = 'Etobicoke'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("eHealth Ontario", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Legislative Assembly", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Children, Community and Social Services", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Conseil Des Écoles Catholiques Du Centre Est", case=False), 'city'] = 'Gloucester'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Laurentian University", case=False), 'city'] = 'Sudbury'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Treasury Board Secretariat / Secrétariat du Conseil du Trésor", case=False), 'city'] = 'Ottawa'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Transportation / Transports", case=False), 'city'] = 'North York'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("King's University College", case=False), 'city'] = 'London'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Public Safety and Security", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Keewatin-Patricia District School Board", case=False), 'city'] = 'Dryden'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Quinte", case=False), 'city'] = 'Bellville'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("St. Mary's General Hospital", case=False), 'city'] = 'Kitchener'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Cambrian", case=False), 'city'] = 'Sudbury'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("County of Simcoe", case=False), 'city'] = 'Barrie'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Newmarket", case=False), 'city'] = 'Newmarket'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("St. Lawrence College", case=False), 'city'] = 'Kingston'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Ontario Northland Transportation Commission", case=False), 'city'] = 'Coldwater'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Conseil des écoles publiques de l'Est de l'Ontario", case=False), 'city'] = 'Ottawa'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Canadian Institute for Health Information", case=False), 'city'] = 'North York'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("St. Joseph's Care Group", case=False), 'city'] = 'Thunder Bay'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Municipal Affairs & Housing", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Canadian Institute For Health Info", case=False), 'city'] = 'Ottawa'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Collège Boréal", case=False), 'city'] = 'Barrie'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("SCO Health Service", case=False), 'city'] = 'Ottawa'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Ontario Place", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Trinity College", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("NTMC", case=False), 'city'] = 'Durham'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Town of Collingwood", case=False), 'city'] = 'Collingwood'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Grand Bend Area", case=False), 'city'] = 'Lambton'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Headwaters HealthCare Centre", case=False), 'city'] = 'Orangeville'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("LAMP CHC", case=False), 'city'] = 'Etobicoke'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Ontario Pension Board", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Ross Memorial Hospital", case=False), 'city'] = 'Lindsay'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Elliot Lake", case=False), 'city'] = 'Elliot Lake'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Mars Discovery District", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Northern College", case=False), 'city'] = 'Scarborough'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("ARB/BON/OMB", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Grimsby", case=False), 'city'] = 'Grimsby'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Rainbow DSB", case=False), 'city'] = 'Sudbury'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Today's Family", case=False), 'city'] = 'Hamilton'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("CSDC du Centre-Est", case=False), 'city'] = 'Gloucester'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Grand Erie District School Board", case=False), 'city'] = 'Brantford'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Essex", case=False), 'city'] = 'Essex'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("St. Lawrence Lodge", case=False), 'city'] = 'Brockville'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Upsala", case=False), 'city'] = 'Upsala'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Township of South Dundas", case=False), 'city'] = 'Williamsburg'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("James Bay General Hospital", case=False), 'city'] = 'Attawapiskat'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Amherstburg", case=False), 'city'] = 'Amherstburg'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("LaSalle", case=False), 'city'] = 'LaSalle'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Huron University College", case=False), 'city'] = 'London'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Fort Erie", case=False), 'city'] = 'Fort Erie'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("County of Bruce", case=False), 'city'] = 'Kincardine'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Moosonee ", case=False), 'city'] = 'Moosonee'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("West Haldimand General Hospital", case=False), 'city'] = 'Hagersville'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Riverside Hospital", case=False), 'city'] = 'Ottawa'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Queensway General Hospital", case=False), 'city'] = 'Mississauga'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Aylmer", case=False), 'city'] = 'Aylmer'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Atikokan", case=False), 'city'] = 'Atikokan'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Deep River", case=False), 'city'] = 'Deep River'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Eastern Ontario Health Unit", case=False), 'city'] = 'Cornwall'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Caledon", case=False), 'city'] = 'Caledon'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Georgina", case=False), 'city'] = 'Georgina'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Wingham", case=False), 'city'] = 'Wingham'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Runnymede Healthcare Centre", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("City of St Catharines", case=False), 'city'] = 'St. Catherines'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Women’s College Hospital", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Victoria University", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Fanshaw", case=False), 'city'] = 'London'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Le Collge des Grands Lacs", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("La Cite collegiale", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("ORTECH Corporation", case=False), 'city'] = 'Mississauga'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Ontario Trillium Foundation", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("TV Ontario", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Centenary Health Centre", case=False), 'city'] = 'Scarborough'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Clarke Institute of Psychiatry", case=False), 'city'] = 'Scarborough'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Collingwood General & Marine Hospital", case=False), 'city'] = 'Collingwood'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Hillcrest Hospital", case=False), 'city'] = 'Trenton'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Township of Uxbridge", case=False), 'city'] = 'Uxbridge'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Town of Newmarket", case=False), 'city'] = 'Newmarket'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Corp. of the City of Nepean", case=False), 'city'] = 'Napean'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Arprior", case=False), 'city'] = 'Arnpior'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Black Creek", case=False), 'city'] = 'North York'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Brescia College", case=False), 'city'] = 'London'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Hincks", case=False), 'city'] = 'Toronto'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Huron - Perth", case=False), 'city'] = 'Stratford'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains(" Huron-Perth", case=False), 'city'] = 'Stratford'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Oxford", case=False), 'city'] = 'Woodstock'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Kingsn/Frontenac /Lennox/Addingn", case=False), 'city'] = 'Kingston'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("KFL & A", case=False), 'city'] = 'Kingston'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Perth County", case=False), 'city'] = 'Stratford'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("City of Nepean", case=False), 'city'] = 'Napean'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("City of St Thomas", case=False), 'city'] = 'St Thomas'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("City of Thorold", case=False), 'city'] = 'Thorold'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains(" Collingwood", case=False), 'city'] = 'Collingwood'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Country Roads", case=False), 'city'] = 'Portland'
sunshine_data_df.loc[sunshine_data_df['city'].str.contains("Prince Edward", case=False), 'city'] = 'Belleville'
#Update city based on job title
# sunshine_data_df['city'] = sunshine_data_df['job_title'].apply(lambda x: x['Pickering'] if x['city'].str.contains("Pickering") else x['A'], axis=1)
sunshine_data_df.loc[sunshine_data_df['Job Title'].str.contains("Pickering", case=False), 'city'] = 'Pickering'
sunshine_data_df.loc[sunshine_data_df['Job Title'].str.contains("Bruce", case=False), 'city'] = 'Kincardine'
sunshine_data_df.loc[sunshine_data_df['Job Title'].str.contains("Nuclear", case=False), 'city'] = 'Pickering'
sunshine_data_df.loc[sunshine_data_df['Job Title'].str.contains("Lambton", case=False), 'city'] = 'Lambton'
sunshine_data_df.loc[sunshine_data_df['Job Title'].str.contains("Renison University College", case=False), 'city'] = 'Waterloo'
sunshine_data_df.loc[sunshine_data_df['Job Title'].str.contains("(Pickering/Darlington)", case=False), 'city'] = 'Pickering'
C:\Users\Danielle Spring\anaconda3\envs\PythonData\lib\site-packages\pandas\core\strings\accessor.py:101: UserWarning: This pattern has match groups. To actually get the groups, use str.extract. return func(self, *args, **kwargs)
#Create
city=sunshine_data_df['city'].unique()
unique_city_list=city.tolist()
print(unique_city_list)
['Nepean', 'Sudbury', 'Scarborough', 'Ottawa', 'Kitchener', 'Durham', 'London', 'Toronto', 'Barrie', 'Etobicoke', 'Sarnia', 'Bancroft', 'Milton', 'Niagara Falls', 'Sault Ste. Marie', 'Oakville', 'Peterborough', 'Wallaceburg', 'Kingston', 'Thunder Bay', 'LCBO', 'McMichael Canadian Art Collection', 'OCETA', 'Mississauga', 'Ontario Arts Council', 'Ontario Casino Corporation', 'Ontario Clean Water Agency', 'Ontario Energy Corporation', 'Ontario Film Development Corporation', 'Ontario Financing Authority', 'Ontario Hydro', 'Pickering', 'Kincardine', 'Lambton', 'Ontario Northland', 'Ontario Realty Corporation', 'The Institute for Space and Terrestrial Science', "Workers' Compensation Board", 'Workplace Health & Safety Agency', 'Belleville', 'Brockville', 'Cambridge', 'Campbellford', 'Collingwood', 'Cornwall', 'Guelph', 'Hawkesbury', 'Trenton', 'Windsor', 'St. Catherines', 'York', 'Huntsville', 'Brant', 'Laurentian Hospital', 'Bowmanville', 'Montfort Hospital', 'Norfolk', 'Orillia', 'Orthopaedic & Arthritic Hospital', 'Oshawa', 'Shelburne', 'Pembroke', 'Perth and Smiths Falls District Hospital', 'Providence Centre', 'Lindsay', 'Runnymede Chronic Care Hospital', 'Muskoka', "St. Joseph's Hospital & Health Centre", 'St. Thomas', 'Stratford', 'Strathroy', 'Kirkland Lake', 'The Doctors Hospital', 'The Donwood Institute', 'The Ontario Cancer Treatment & Research Foundation', "The Perley & Rideau Veterans' Health Centre", 'The Queen Elizabeth Hospital', 'The Riverdale Hospital', 'The Wellesley Central Hospital', 'Tillsonburg', 'Timmins', 'Welland', 'Parry Sound', "Women's Christian Association-Parkwood Hosp.", 'Woodstock', 'Brampton', 'Kanata', 'North Bay', 'Waterloo', 'Gloucester', 'Clarington', 'Stoney Creek', 'Vaughan', 'Burlington', 'Napean', 'Markham', 'Whitby', 'Halton', 'Richmond Hill', 'Agriculture,Food and Rural Affairs', 'Attorney General', 'Citizenship, Culture & Rec.', 'Community and Social Services', 'Consumer and Commercial Relat.', 'Economic Dev., Trade and Tourism', 'Education and Training', 'Environment and Energy', 'Finance', 'Health', 'Labour', 'Management Board Secretariat', 'Municipal Affairs and Housing', 'Native Affairs Secretariat', 'Natural Resources', 'North. Dev. & Mines', 'Office of the Chief Election Officer', 'Office of the Premier', 'Office of the Provincial Auditor', 'Ombudsman Ontario', "Ontario Women's Directorate", 'Solicitor Gen. & Correctional Serv.', 'Transportation', 'Workers Comp. Appeals Tribunal', 'Addiction Research Foundation', 'Almaguin Health Centre', 'North York', 'Owen Sound', 'Centre Medical Ste-Anne Inc.', "Centre de sante communautaire de l'Estrie", 'Centretown Community Health Centre Inc.', 'Community Occupational Therapists & Associates', 'Community Services To Jewish Elderly', 'County Roads Community Health Centre', 'Erinoak Serving Young People with Physical Disabilities', 'Essex', 'Exhibiton Place', "Grandview Children's Centre", 'Haliburton', 'Health Services Restructurint Commission', 'ITRC: Information Technology Research Centre', 'Jewish Family & Child Services', 'Kenora', 'Kent-Chatam Health Unit', 'Kinark Child and Family Services', 'Lakeshore Area Multi-Service Project (LOMP)', 'Lanark', 'Manufacturing Research Corporation of Ontario', 'Northwest Health Unit', 'Ongwanada', 'Ontario March of Dimes', 'Parkdale Community Health Centre', 'Perth District Health Unit', 'Providence Continuing Care Centre', 'Regent Park Community Health Centre', 'Renfrew', 'Sandy Hill Community Health Centre', 'South Riverdale Community Health Centre', 'Surrey Place Centre', 'TRIO', 'The Canadian Hearing Society', 'The Canadian Institute for Advance Research', "The Dellcrest Children's Centre", 'The Ontario Legal Aid Plan', 'Transportation Association of Canada', 'Tweed', 'Elgin', "Women's Health in Women's Hands", 'Woolwich', 'CEFCUT', 'Algoma', 'Cochrane', 'Prescott', 'Dryden', 'Fort Frances-Rainy River Board of Education', 'Frontenac County Board of Education', 'Frontenac-Lennox & Addington County RCSS', 'Grey County Board of Education', 'Haldimand Board of Education', 'Huron County Board of Education', 'Kapuskasing', 'Kent County Board of Education', 'Kent County R.C.S.S.B.', 'Timiskaming', 'Leeds and Grenville County Board of Education', 'Lennox and Addington County Board of Education', 'Lincoln County Board of Education', 'Lincoln County Roman Catholic Separate School Board', 'Metropolitan Seperate School Board', 'Middlesex County Board of Education', 'North Shore Board of Education', 'North Shore District Roman Catholic Separate School Board', 'Stormont, Dundas & Glengarry Public School Board', 'Stormont, Dundas & Glengarry R.C.S.S.B.', 'Victoria County Board of Education', 'Wellington', 'Wentworth County Board of Education', "University of St. Jerome's College", 'Algonquin', 'Confederation', 'Loyalist', 'Northern', 'Sheridan', 'St. Clair', 'St. Lawrence', 'AGRICORP', 'Cdn. Inst. For Advanced Research', 'Education Relations Commission', 'Fields Inst.-Research In Math.Sci.', 'GO Transit', 'Health Serv. Restructuring Comm.', 'Institute for Space/Terrestrial Sci.', 'Materials & Manuf. Ontario', 'McMichael Cdn. Art Collection', 'Ont. Council Of Regents', 'Ont. Dairy Herd Improv. Corp', 'Ont. Lottery Corp.', 'Ont. Municipal Board', 'Ont. Municipal Emp. Retire. Brd.', 'Ont. Northland Transport. Comm.', 'Ont. Swine Improvement Inc.', 'Ontario Development Corp.', 'Ontario Heritage Foundation', 'Royal Botanical Gardens', 'St. Lawrence Parks Commission', 'Telecomm. Research Inst. Of Ont.', 'Waterfront Regeneration Trust', 'Workplace Safety & Insurance Brd.', 'Collingwood General & Marine Hosp.', 'Doctors Hospital', 'Georgetown & District Memorial Hosp.', 'Kincardine & District Gen. Hosp.', 'Kirkland and District Hospital', 'MICS Group of Hospitals - Matheson', 'Ongwanada Hospital', "Perley & Rideau Veterans' Health Ctr.", 'Perth and Smiths Falls District Hosp.', 'Chatham', 'Ross Memorial Hosp. -Lindsay', 'Wellesley Central Hospital', 'Aurora', 'Township of Pittsburgh', 'Energy, Science & Tech.', 'Environment', 'Intergovernmental Affairs', 'Solicitor Gen. & Correct Serv.', 'Barbara Black Centre', 'Canadian Red Cross - Ont. Zone', 'Cdn. Hearing Society', 'Community Occupational Therapists & Assoc.', 'Portland', 'Erinoak Serving Young People w/Phy. Disabilities', 'I.O.O.F Senior Citizen Homes Inc.', 'Lakeshore Area Multi-Service Project (LAMP)', 'Langs Farm Village Assoc.', 'Longlac Comm. Health Centre', 'Michener Inst. For Applied Health Sci.', 'Muki Baum Assoc.', 'Northwestern Health Unit', 'Perley /Rideau Veterans Health Centre', 'Porcupine Health Unit', 'Rehabilitation Foundation for Disabled', 'South Bruce Grey Health Centre', 'Southheastern Ont. Health Sciences Centre', "St. Joseph's Health Centre", 'West Hill Community Services', 'Workplace Safety & Ins. Appeals Tribunal', 'Youthdale Treatment Centres', 'Cdn. Nat. Inst. For The Blind', 'Ctr. de Santé Comm. du Témiskaming', 'Davenport-Perth Neighbourhood Ctr.', 'Lawrence Hgts. Comm. Health Ctr.', "Ont. Assoc. of Children's Aid Societies", 'Ont. Hospital Association', 'Ont. Legal Aid Plan', 'Ont. Mental Health Fdn.', 'Blue Water DSB # 7', 'Blue Water DSB #7', 'DSB # 15', 'Dist. Catholic School Board #55', 'Fort Frances-Rainy River BE', 'Frontenac County BE', 'Haldimand BE.', 'Huron County BE', 'Leeds and Grenville County BE', 'Lennox and Addington County BE', 'Lincoln County BE', 'Lincoln County RCSSB', 'North Shore District RCSSB', 'North of Superior RCSSB', 'Stormont, Dund. & Glen RCSSB', 'Stormont, Dundas & Glengarry BE', 'Wentworth County BE', 'Brock', 'Laurentian', 'Trent', 'Alcohol and Gaming Commission', 'College Rel. Comm., Ed. Rel. Comm.', 'Commercial Reg. Appeal Tribunal', 'Deposit Insurance Corp. of Ontario', 'Farm Products Marketing Comm.', 'Financial Services Commission', 'McMichael Cdn Art Collection', 'Ontario Civilian Comm. on Police Svcs', 'Ontario Development Corporation', 'Ontario International Trade Corp.', 'Ontario Mun. Empl. Retirement Bd.', 'Ontario Municipal Board', 'Ontario Northland Transport. Comm.', 'Ontario Racing Commission', 'Ontario Science Centre', 'Photonics Research Ontario', 'Science North', 'TVOntario', 'Workplace Safety & Ins. Appeals Trib', 'Workplace Safety and Ins. Board', 'Hop Gen de Hawksbry & Dst Gen Hsp', 'Hotel Dieu Hospital', 'Leamington District Memorial Hosp.', 'Mattawa', 'Perth & Smiths Falls District Hospital', 'Port Colborne', 'Ross Memorial', 'Shaver Hospital', "St. John's Rehabilitation Hospital", "St. Peter's Hospital", 'Winchester District Memorial Hosp.', 'Wingham', 'Town of Lindsay', 'Agriculture, Food & Rural Affairs', 'Citizenship, Culture and Recreation', 'Consumer and Commercial Relations', 'Economic Dev., Trade & Tourism', 'Energy, Science and Technology', 'Francophone Affairs', 'Northern Development and Mines', 'Solicitor General & Correctional Svcs', 'Barbara Black Centre for Youth Res.', 'CRESTech', 'Canadian Hearing Society', 'Canadian Nat. Institute for the Blind', 'Canadian Red Cross', 'Cdn. Coord. Office for Health Tech', 'Centre de santé comm. HWN Inc.', "Centre de santé comm. de l'estrie", 'Centre médico-social comm.', 'Comm. & Information Technology Ont', 'Comp. Rehab. & Mental Health Svcs.', 'Davenport Perth Neighbourhood Cent', 'Don Mills Foundation', 'Erinoak', 'Hal. Kaw. Pine Rdg. District Hlth Unit', 'Inst. for Clinical Evaluative Sciences', 'Jewish Family & Child Service', 'KFL&A Health Unit', 'Lakeshore Area Multi-Service Project', 'Lawrence Heights Comm. Hlth Cent.', 'MICs Group of Health Services', 'Materials & Manufacturing Ontario', 'Merrickville District CHC', 'Michener Institute for Applied Health', 'Muki Baum Assoc. for Rehabilitation', 'Ongwanada Resource Centre', 'Ontario Agri-Food Technologies', "Ontario Assn. Of Children's Aid Soc.", 'Ontario Dairy Herd Improvement Corp', 'Ontario Legal Aid Plan', 'Ontario Mental Health Foundation', "Perley & Rideau Veteran's Hlth Cent.", 'Regent Park CHC', 'Rehabilitation Found. for Disabled', 'Rexdale Community Health Centre', 'Sandwich Comm. Health Centre Inc.', 'South Riverdale Comm. Health Cent.', 'Southeastern Ont. Health Sci. Centre', 'Sport Alliance of Ontario', 'Wine Council of Ontario', "Women's Hlth in Wmn's Hands CHC", 'Avon Maitland DSB', 'Bluewater DSB', 'CSBD du Nouvel-Ontario', 'CSD Centre Sud-Ouest', 'CSD langue française Est Ont.', 'CSDB du Sud-Ouest', "CSDC Centre-Est de l'Ontario", 'CSDC Centre-Sud', 'CSDC Est Ontarien', 'CSDC Franco-Nord', "CSDC Grand Nord de l'Ontario", 'CSDC Grandes Rivieres', 'CSDC Grandes Rivières', 'Catholic DSB of Eastern Ontario', 'DSB Ontario North East', 'English Language RCDSB', 'Grand Erie DSB', 'Huron Superior RCDSB', 'Huron-Perth RCDSB', 'Kawartha Lakes', 'Keewatin-Patricia District Sch Bd', 'Limestone DSB', 'Near North DSB', 'Northwest RCDSB', 'Peter/Vict/North/Claring. RCDSB', 'Rainy River DSB', 'Terrace Bay', 'Marathon', 'Upper Grand DSB', 'College des Grands Lacs', 'Commercial Reg. Appeals Tribunal', 'Environment Assmt & Appeal Brd.', 'Independent Electricity Market Op.', 'Ont. Trsm Mrktng Prtnrshp Corp.', 'Ontario Elec. Pension Srvcs Corp.', 'Ontario Exports Inc.', 'Ontario Human Rights Comm.', 'Ontario Rental Housing Tribunal', 'Ontario Review Board', 'Workplace Safety & Ins. App. Trib.', 'Workplace Safety & Insurance Brd', 'Centre for Addiction & Mental Hlth', 'Children s Hosp. of East. Ontario', 'Collingwood Hospital', 'Hotel Dieu Hospital , St. Catherines', 'Kirkland District Hospital', 'Manitoulin', 'Perth & Smith Falls District Hospital', 'Bellville', 'Rel Hsp St. Joseph s Hth Ctr Cornwa', 'Riverdale Hospital', 'Southeastern Ont. Hlth Sciences Ctr', 'St. John s Rehab Hospital', 'St. Joseph s Care Group', 'St. Joseph s Hospital & Home', 'St. Marys Memorial Hospital', 'St. Peters Hospital', 'Hydro One', 'Ontario Power Generation', 'City of Gloucester', 'Citizenship, Culture & Recreation', 'Community & Social Services', 'Consumer & Commercial Relations', 'Correctional Services', 'Economic Development & Trade', 'Education', 'Energy, Science & Technology', 'Health & Long-Term Care', 'Northern Development & Mines', 'Ontario Women\x19s Directorate', 'Solicitor General', 'Tourism', 'Training, Colleges & Universities', 'Access Alliance Multicultural CHC', 'Barbara Black Hlth Ctr for Yth Rsrcs', 'Board of Govenors of Exhibition Place', 'COSTI-IIAS', 'Canadian Inst. for Advanced Researc', "Catholic Children's Aid, Ham-Went.", 'Centre de santé comm. HWN', "Centre de santé comm. de l'Estrie", 'Centre médics social comm.', 'Centretown Community Health Ctr.', 'Circle of Home Care Services - T.O.', 'Communication & Info. Tech. Ont.', 'Davenport Perth Neighbourhood Ctr.', 'Don Mills Foundation for Sr. Citizens', 'Family Day Care Services', 'Gateway Community Health Centre', 'Grandview Treatment Centre', 'Griffin Centre', 'KFLA Health Unit', 'Lakeshore Area MultiService Proj.', 'Langs Farm CHC', 'Lawrence Heights Comm. Hlth Ctr.', 'Legal Aid Ontario', 'Lutherwood CODA', 'Mamaweschen N.Shore Tribal Cncl', 'Mary Berglund Community Hth Ctr.', 'Michener Institute for Applied Hlth', 'NORCAT', 'Ontario Dairy Herd Improve. Corp', 'PDHU', 'Parkdale CHC', "Perley & Rideau Veterans' Hlth Ctr", 'Pinecrest-Queensway HCS', 'Police Services Brd.', 'Porcupine & District C.A.S.', 'Regent Park Comm. Hlth Ctr.', 'Rehab. Foundation for the Disabled', 'Sandwich CHC', 'Sandy Hill CHC', 'St. Lawrence Centre for the Arts', 'TEDCO', 'Youth Srvcs Bureau of Ott-Car.', "CSD Grand Nord de l'Ontario", 'CSD langue française Est Ontario', 'CSDC des Aurores-Boréales', 'Keewatin-Patricia DSB', 'Huntington University', "King's College", 'AGCO', 'Council of Regents', 'Edu. Quality & Accountability Off.', 'Environmental Assmt & Appeal Brd.', 'Hlth Prof Appl & Review Board', 'LAT/CRAT', 'OHTB', 'OMB', 'Ont Civilian Comm. on Police Services', 'Ont.Farm Products Marketing Comm.', 'Ontario Board of Parole', 'Ontario Electricity Pension Srvcs', 'Ontario Human Rights Commission', 'Ontario Labour Relations Board', 'PEHT/BOI', 'Pay Equity Commission', 'Social Benefits Tribunal/SARB', 'SuperBuild Corporation', 'Almonte General', 'Centre for Addiction & Mental Hlth.', 'Chapleau Health Services', 'Collingwood G & M Hospital', 'Haldimand War Memorial Hospital', 'Huronia District Hospital', 'Leamington District Memorial', 'Montfort', 'Providence Continuing Care Ctr.', 'Riverdale Hospital, The', 'Riverside Health Care Fac. Inc.', 'Sensenbrenner Hospital', 'Smooth Rock Falls Hospital', 'New Market', "St. John's Rehab Hospital", "St. Joseph's", "St. Joseph's Hospital & Home", 'County of Grey', 'Cumberland', 'Ajax', 'Ancaster', 'Town of Dundas', 'Fort Erie', 'Health & Long Term Care', 'Barbara Black Ctr for Yth Rsrcs', 'Board of Govenors, Exhibition Place', 'CITO', 'CNIB', 'Centre médico social communautaire', 'Centretown CHC', 'Community Mental Health Clinic', 'Costi - IIAS', 'Four Villages Community Hlth Ctr', 'Go Transit', 'Hinks-Dellcrest Ctr.', 'Inst. for Clinical & Evaluative Studies', 'Langs Farm Village Association', 'Lawrence Heights CHC', 'M.I.G. Group of Health Services', 'Mary Berglund Community Hlth Ctr', 'Merrickville DCHC', 'Michener Instit. for App.Hlth Science', 'Misiway Milopemahtesewin CHC', 'Ontario Dairy Herd Improve. Corp.', 'Ontario Edu.Comm. Authority', 'Regient Park Community Hlth Ctr', 'SSM&D Group Health Association', 'Services de santé de Chap.Hlth Srvcs', 'Shepherd Village Inc.', 'South Riverdale CHC', 'Sport Alliance', "St. Joseph's Villa", 'Stonegate CHC', "CEP de l'Est de l'Ont.", "CSDC de l'Est Ontarien", 'CSDC du Nouvel-Ontario', 'CSDC du Sud-Ouest', 'Ont.Coll.of Arts & Design', 'Alcohol & Gaming Commission', 'Board of Inquiry', 'Consent & Capacity Board', 'Environmental Review Tribunal', 'Licence Appeal Tribunal', 'OCWA', 'OEPSC', 'Office of the Employer Advisor', 'Office of the Worker Advisor', 'Ontario Civilian Commission on Police Services', 'Ontario Council of Regents', 'Ontario Highway Transport Board', 'Ontario Parole Board', 'Pay Equity Hearings Tribunal', 'Tourism Mark Partner Corp.', 'Tourism Mark g Partner p Corp.', 'Algonquin Health Services', 'CKHA', 'Casey House Hospice', 'Children\x19s Hosp. of East. Ontario', 'Collingwood General and Marine', 'Dunnville', 'Geraldton District Hospital', 'Grandview Children\x19s Hospital', 'Northeast Mental Health Centre', 'Perley & Rideau Veterans Hlth Ctr.', 'Perth and Smith Falls District Hosp.', 'St. John´s Rehabilitation', 'Stevenson Memorial Hospital', 'West Nippissing General Hospital', 'St Thomas', 'County of Haldimand', 'Georgina', 'Innisfil', 'LaSalle', 'Newmarket', 'Town of Whitchurch-Stouffville', 'Township of Springwater', 'Citizenship', 'Consumer & Business Services', 'Tourism, Culture & Recreation', 'Alzheimer Societies of Ontario', 'Anishinbek Police Services', 'Arthritis Society, The', 'Barbara Black Ctr for Yth Rsrcs, The', 'Board of Governors, Exhibition Place', 'C.S.C.E.', 'CCAC for the Eastern Counties', 'CCAC of KFLA', 'Can. Inst. for Adv. Research, The', 'Canadian Hearing Society, The', 'Catholic Wrld Yth Days-2002 Co.', 'Central East Hlth Info. Partnership', 'Davenport Perth Neighbourhood Ctr', 'East End Community Health Centre', 'FortFrances&Dst.Assc.for Com.Liv.', 'Four Villages Community Hlth Ctr.', 'Frontenac Comm. Mental Hlth Ctr.', 'Gateway CHC', 'Joint Planning & Policy Committee', 'LOFT Community Services', "Madame Vanier Children's Services", 'Mamaweswen, Nrth Shore Tribal Co.', 'Mary Bergland CHC', 'Materials and Manufacturing Ontario', 'Mohawk Council of Akwesasne', 'Nishnawbe-Aski ', 'Ont. Educational Comm. Authority', 'Prov. Bld. & Const. Trds Coun. of Ont.', 'Regent Park Community Hlth Ctr.', 'Slt.Ste.Marie & Dist.Grp.Hlth Assoc.', 'St. Lawrence Centre', 'Villa Colombo Homes for the Aged', 'Weeneebayko', 'Women´s Christian Association', 'YMCA -YWCA', 'CSCD des Grandes Riviéres', 'CSCD. des Grandes Riviéres', 'CSD Nord-Est', 'P.V.N.C. Catholic District School Brd.', 'Centennial', 'Sheridan Institute', 'Grand River Conservation Authority', 'Human Rights Tribunal of Ontario', 'OECA/OTEO', 'Ont. Parole & Earned Release Board', 'Ont.Civillian Comm. on Police Srvcs', 'Ontario SuperBuild Corp.', 'Public Service Appeals Board', 'WSIB', 'St. Almonte', 'Arnpior', 'Atikokan', 'Centretown Community Health Ctrs.', 'Collingwood General & Marine', 'Haldimand War Memorial, Dunnville', 'Hanover District', 'Headwaters Health Care Centre', 'Hopital Montfort', 'Hotel Dieu', 'Attawapiskat', 'Lennox & Addington County', 'NEMHC', 'NorWest CHCs', 'Penetanguishene General Hospital', "Perly & Rideau Veterans' Hlth Ctr.", 'Red Lake Margaret Cochenour Mem.', 'Riverside Health Care Facilities, Inc.', "SMOL - St. Mary's", 'SiouxLookout Meno-Ya-Win Hth Ctr.', 'Smooth Rock Falls', "Soldiers' Memorial", 'South Bruce Grey Hospital', 'St. Joseph Care Group', 'Elliot Lake', 'TB Regional Hospital', 'Westpark Healthcare Centre', 'C.U.P.R.', 'City of Clarence-Rockland', 'Corporation of Haldimand County', 'County of Huron', 'County of Middlesex', 'Caledon', 'Town of Pelham', 'Town of Tecumseh', 'Wasaga Beach', 'Township of King', 'Uxbridge', 'United Counties of Leeds & Grenville', 'Agriculture and Food', "Community, Family & Children's Services", 'Culture', 'Energy', 'Enterprise, Opportunity & Innovation', 'Office of Francophone Affairs', 'Provincial Auditor', 'Tourism and Recreation', 'Training, Colleges and Universities', 'Barbara Black Ctr for Youth Res.', 'Bellwoods Centres for Comm. Living', 'Board of Gov. Exhibition Place', 'CAS - Frontenac', 'CASey House', 'CHATS', 'COSTA - IIAS Immigrant Services', 'COTA', 'Community Care', 'Ctr. Mdico Social Communautaire', 'George Hull Centre', 'Innovation Institute of Ontario', 'Institute for Clinical Evaluation', 'J.D. Griffin Centre', 'Kennedy House Youth Services Inc.', "Kerry's Place Autism Services", 'Lennox & Addington Cnty Library Brd.', 'Mamaweswen Nrth Shore Tribal Co.', 'Michener Instit. for App. Hlth Science.', 'Muki Baum Association', 'Municipal Prop. Assessment Corp.', 'Northern Diabetes Health Network', 'Northern Youth Services Inc.', "Ont. Assoc. of Children's Aid Soc.", 'Ontario Cancer Research Network', 'Optical Reg. Advanced Network of Ont.', 'Pinecrest-Queensway Hlth & Com. Srv.', 'Prov. Build. & Con. Trad. Co. of Ont.', 'Safehaven Project for Comm. Living', 'Serv. aux enfants et adultes de P-R', 'Southern Ontario Library Service', 'The Arthritis Society, Ont. Division', 'The Four Villages', "Tor. Aged Men's & Women's Homes", 'Turning Point Youth Services', "Women's Christian Association", 'Yee Hong Centre for Geriatric Care', 'Algonquin and Lakeshore CDSB', 'C.S.D.C. Centre-Sud', 'C.S.D.C.S.O.', 'CECLFCE', 'CSCD des Granddes Rivières', 'CSD du Grand Nord de l\x92Ontario', 'CSD du Grand Nord de l\x92Ontario>', 'CSDC Franco-nord', 'CSDC des Aurores boréales', 'CSDCEO', 'CSDESCO', 'Conseil scolaire de district', 'Brantford', 'Huron-Perth CDSB', 'Huron-Superior CDSB', 'James Bay Lowlands SSB', 'Northwest CDSB', 'Upper Grand D.S.B', 'Contact North/Contact Nord', 'Ontario College for Art & Design', 'Algonquin Forest Authority', 'College Comp.& Appointments Council', 'Deposit Insurance Corporation', 'Education, Quality & Account Office', 'Independent Electricity Market Operator', 'OECA', 'OMEIFA', 'Ont. Civilian Commission on Police Services', 'Ont. Farm Products Marketing Commission', 'Ont. Tourism Marketing Partnership', 'Ontario Exports Inc', 'Ontario Media Development Corp.', 'Ontario Northland Transportation Comm', 'Smart Systems for Health Agency', 'Social Benefits Tribunal', 'Workers Compensation Appeals Tribunal', 'Workplace Safety & Insurance Board', 'Ontario Court of Justice', 'Chief Election Officer', 'Environmental Comm', 'Information & Privacy', 'Integrity Commission', 'Agriculture & Food', 'Children & Youth Services', 'Citizenship & Immigration', 'Community Safety and Correctional Services', 'Public Infrastructure Renewal', 'Tourism & Recreation', 'Arnprior', 'Deep River', 'Haldimand War Memorial', 'Hanover & District Hospital', 'Orangeville', 'Hôpital Glengarry Memorial Hospital', 'Kemptville District Hospital', 'Lake Woods District Hospital', 'Leamington District Memorial Hospital', 'Listowel', 'MICsGroup of Health Services', 'Manitouwadge General Hospital', 'Nipigon District Memorial Hospital', 'Norwest Community Health Centres', "Providence Continuing Care Centre(St.Mary's)", "Providence Continuing Care Centre.(St.Mary's)", 'Providence Healthcare', 'Red Lake Margaret Cochenour Memorial', 'Riverside Health Care Facility Inc.', 'Sioux Lookout Meno-Ya-Win HC', "St. John's Rehabilitation", 'TB Regional Health Sciences Centre', 'City of Clarence-Rockwood', 'County of Haldimand County', 'County of Lennox & Addington', 'Municipality of Greenstone', 'Municipality of Leamington - Police', 'Municipality of Northern Bruce Peninsula', 'Municipality of Sioux Lookout', 'Town of Bradford West Gwillimbury', 'Grimsby', 'Town of Hearst', 'Midland', 'Town of New Tecumseth', 'United Counties of Stormont, Dundas and Glengarry', 'Aisling Discoveries Child & Family Centre', 'Bellwoods Centres for Community Living Inc.', 'CAS - Stormont, Dundas & Glengarry', 'CCAC - Eastern Counties', 'CCAC - Near North', 'COSTI - IIAS Immigrant Services', 'Canadian Mental Health Association - Ontario', 'Canadian National Institute for the Blind', 'Central East Health Partnership', "Centre de santé Community de l'Estrie", 'Centre for Research, Earth & Space Tech.', 'Centre-in-the-Square Corporation', 'Clarendon Foundation (Cheshire Homes)', 'College of Medical Radiation Technologists', 'Communications & Info. Tech. Ontario', 'Community Home Assistance to Seniors', 'Contact North/ Contact Nord', 'Davenport Perth Neighbourhood Centre', 'Don Mills Foundation for Senior Citizens Inc', 'Earlscourt Child & Family Centre', 'East Metro Youth Services', 'Exhibition Place', 'Frontenac Community Mental Health Srvcs', 'Grand River C.A.', 'Grandview Childrens Centre', 'Group Health Centre', 'Hospice Association of Ontario', 'I.O.O.F. Senior Citizen Homes Inc.', 'Kinark Child & Family Services', 'Mamaweswen North Shore Tribal Council', 'Merrickville District Community Health Centre', 'Northern Shores Dist. Health Council', 'Northern Youth Services', 'Notre Dame of St. Agatha', "Ont. Association of Children's Aid Soc.", 'Ont. Dairy Herd Improvement', 'Ont. Problem Gambling Research Centre', 'Optical Reg. Advanced Network, Ont.', 'Pinecrest- Queensway Health & Community Services', 'Project Hostel', 'Provincial Buliding & Constraction Trades Council, Ont.', 'Radiation Safety Institute of Canada', 'Reconnect Mental Health Srvcs', 'Responsible Gambling Council', 'Rexdale CHC', 'Roberts / Smart Centre', 'Safehaven Project for Community Living', 'Sandwich Community Health Centre', 'Simcoe Community Services', 'St. Demetrius Dev. Corporation', "St. Paul's L'Amoreaux Centre", "St. Peter's Health System", 'The Arthritis Society', 'The Cdn Institute for Advanced Research', 'The Four Villages CHC', 'The Michener Inst. for Applied Health Services', 'The Ontario HIV Treatment Network', 'The Wexford Residence', 'Trillium Gift of Life Network', 'Youth Employment Service', 'CSCD des Grandes Rivieres', 'CSD Catholic du Centre-Sud', "CSD de l'est de l'Ontario", 'CSD du Grand Nord de lOntario', 'CSDC - Franco-Nord', 'CSDC Centre Est', "CSDC de L'est Ontarien", 'CSDC des Aurores boreales', 'CSDC du Sud Ouest', 'James Bay Lowlands DSA', 'College Comp. & Appointments Council', 'Education Quality & Account. Office', 'Financial Srvcs Commission', 'Hlth. Professions Appeal & Review Board', 'Independent Electricity System Op.', 'OSIFA', 'Ont. Civilian Comm. on Police Srvcs.', 'Ont. Farm Products Marketing Comm.', 'Ontario Food Terminal Board', 'Ontario Northland Transportation Comm.', 'Postsecondary Ed. Review Secretariat', 'SARS Commission', 'Workplace Safety & Ins. Appeals Trib.', 'Auditor General', 'Lieutenant Governor', 'Comm. Safety & Corr. Services', 'Democratic Renewal Secretariat', 'Alexandra Marine & General Hospital', 'Baycrest Ctr. for Geriatric Care', 'Glengarry Memorial Hospital', 'Headwaters Health Care Ctr.', 'Kirkland & District', 'Lennox & Addington Cty. Gen. Hosp.', 'MICS Group of Health Srvcs', 'Manitouwadge General Hosp.', 'Nipigon District Memorial Hosp.', 'Northeast Mental Health Ctr.', 'Notre-Dame Hospital', 'Penetanguishene General Hosp.', "Perley & Rideau Veterans' Hlth. Ctr.", 'Riverside Hlth. Care Facility Inc.', 'South Bruce Grey Hlth. Ctr.', "St. John's Rehab.", "St. Joseph's Continuing Care Ctr.", "St. Mary's General Hosp.", 'Wilson Memorial General Hosp.', 'Thorold', 'Municipality of Leamington', 'Amherstburg', 'Cobourg', 'Town of East Gwillimbury', 'Town of Lakeshore', 'Town of Lincoln', 'Township of Brock', 'Township of Mapleton', 'Township of St. Clair', 'Township of Wainfleet', 'Treaty Three Police Service', "Unt'd Cties-Stormont, Dundas, Glengarry", 'Aisling Discoveries Child & Family Ctr.', 'Alexandra Marine & General Hosp.', 'Algonquin Child & Family Services', 'Bellwoods Ctr. for Comm. Living Inc.', "CCAC - Kings'n/Frontenac/Lennox/Adding'n", 'COSTI-IIAS Immigrant Services', 'COTA Hlth.', 'Canadian Inst. for Advanced Research', 'Canadian MotherCraft Society', 'Canadian Paraplegic Assoc. ON', 'Casey House Hospice Inc.', "Centre de santé comm, de l'Estrie", 'Centre franco-ontarien de ress. péd.', "Children's Mental Health Services", "Clarendon Found'n (Cheshire Homes) Inc.", 'Community Head Injury Resource Srvcs.', 'Don Mills Foundation for Seniors', 'East End CHC', 'East Metro Youth Srvcs.', 'Eastholme', 'Flemingdon Hlth. Centre', 'Frontenac Community Mental Hlth. Srvcs.', 'Geneva Centre for Autism', 'Group Health Association', 'IOOF Senior Citizen Homes Inc.', 'LOFT Community Srvcs.', 'Langs Farm Village Association CHC', 'Lawrence Heights CHS', 'MICS Group of Hlth. Srvcs.', 'Macaulay Child Development Centre', 'Marianhill', 'Municipal Property Assess. Corp.', 'NorWest CHC', 'North Shore Tribal Council', 'Northern Diabetes Hlth. Network', 'Northern Ontario Library Service', 'Northern Shores DHC', "Ont Assoc'n of Children's Aid Societies", "Ont. Fed'n. of Indian Friendship Ctrs.", 'Ont. Problem Gambling Research Ctr.', 'Ontario Centres of Excellence Inc.', 'Ontario Genomics Inst.', 'Ontario HIV Treatment Network', 'Ontario Mental Hlth. Foundation', "Ontario Physical & Hlth. Ed. Assoc'n.", 'Ontario Sailing Association', 'Pinecrest-Queensway Hlth. & Comm. Srvcs', 'Prov Bldg & Constr Trades Council, Ont', 'Reconnect Mental Hlth. Srvcs.', 'Sherbourne Health Centre', 'Smart Systems for Hlth. Agency', 'Social Housing Services Corp.', 'St. Demetrius Development Corporation', "St. Peter's Hlth. System", 'The Michener Inst. for Applied Hlth Sci', 'The Reena Foundation', 'The Royal Agricultural Winter Fair', 'The Safehaven Proj. for Comm. Living', 'The Wexford Residence Inc.', 'Villa Colombo Homes for the Aged Inc.', "Women's Hlth in Women's Hands Comm. Ctr", 'CSC du Nouvel-Ontario', 'CSCD des Grandes Rivières', 'CSD catholiques du Sud-Ouest', "CSD de l'Est de l'Ontario", 'CSD du Centre Sud-Ouest', "CSD du Grand Nord de l'Ontario", "CSD du Nord-Est de l'Ontario", 'Huron Superior CDSB', 'Rainy River District School Board', 'University of Ontario Inst. of Tech.', 'Université de Hearst', 'AgriCorp', 'Criminal Injuries Compensation Board', 'Ed. Quality & Accountability Office', 'Independent Electricity System Operator', 'OECA (TVOntario)', 'Ont. Civilian Comm. on Police Services', 'Ontario Farm Products Marketing Comm.', 'Ontario Heritage Trust', 'Ontario Media Development Corporation', 'Ontario Tourism Marketing Partnership', 'Pay Equity Office', 'Smart Systems for Health', 'Environmental Commissioner', 'Office of the Auditor General', 'Comm. Safety& Corr. Services', 'Government Services', 'Health Promotion', 'Ont. Secretariat for Aboriginal Affairs', 'Research & Innovation', 'Blind River District Health Centre', 'Espanola General Hospital', 'Hornepayne Community Hospital', 'Hotel Dieu Shaver Hlth. & Rehab. Ctr.', 'KidsAbility Centre for Child Dev.', 'Kirkland & District Hospital', 'LHIN 4 Hospitals', 'Lady Dunn Health Centre', 'PHB', 'Sioux Lookout Meno-Ya-Win Health Centre', "St. Joseph's General Hospital", "The Perley & Rideau Veterans' Hlth. Ctr", 'Hagersville', 'West Lincoln Memorial Hospital', 'Wilson Memorial General Hospital', 'Winchester District Memorial Hospital', 'County of Frontenac', 'John Noble Home', 'Port Hope', 'Southern Ontario Library Services', 'Town of Bracebridge', 'Town of Fort Frances', 'Town of Marathon', 'Town of Saugeen Shores', 'Town of West Lincoln', 'Town of Whitchurch Stouffville', 'Township of East Ferris', 'Township of Seguin', 'Township of Tay', 'Township of The Archipelago', 'Township of Tiny', 'Anishinabeck', 'Bellwoods Centres for Community Living', 'Bethany Lodge', "CCAC - Kings'n/Frontenac /Lennox/Adding'n", 'CCAC - W/E', 'COSTI Immigrant Services', 'COTA Health', 'CSC Estrie', 'Canadian MH Association, Ont.', 'Canadian Paraplegic Association Ont.', 'Canadian Stroke Network', 'Centre de santé comm.. du Témiskaming', 'Centre des serv comm Vanier/Vanier CSC', 'Child & Family Centre', 'Christian Horizons', 'County Roads CHC', 'Dominion Institute', 'Fife House Foundation Inc.', 'Flemingdon Health Centre', 'George R. Gardiner Museum of Ceramic Art', 'Glengarda Child & Family Services', 'Goodwill, The Amity Group', 'Grand Bend CHC', 'Grand River Conservation Authorities', 'HUCCHC', 'Idlewyld Manor', 'J. D. Griffin Adolescent Centre Inc.', 'Lake Simcoe Region Conservation Auth.', 'Lampton Community Health Centre', 'Lutherwood', 'MaRS', 'Marianhill Inc.', 'Michener Inst. for Applied Hlth. Sci.', 'Notre Dame of St. Agatha Inc.', "Ont. Assoc'n of Children's Aid Societies", 'Ont. Assoc. of Comm. Care Access Ctrs.', "Ont. Fed'n. of Indian Friendship Ctr.", 'Ont. Flue-Cured Tobacco Growers Board', 'Ont. HIV Treatment Network', 'Ont. Physical & Hlth. Ed. Association', 'Ontario College of Family Physicians', 'Ontario Genomics Institute', 'Ontario Library Association', 'Ontario Neurotrauma Foundation', 'Ontario Power Authority', 'Ontario Problem Gambling Research Ctr.', 'Oolagen Community Services', 'Optical Regional Advanced Network Ont.', 'PACE Independent Living', 'Pediatric Onc. Group of Ont.', 'Pinecrest-Queensway CHC', 'Prov Bldg & Constr. Trades Council, Ont', 'Rainy River Dist Social Srvcs Admin Bd', 'Rainycrest-District Home for the Aged', 'Reconnect Men. Health Ser.', 'Responsible Gambling Council (Ontario)', 'Roberts/Smart Centre', 'Royal Conservatory of Music', 'Sandwich CHS', 'Smoking & Health Action Foundation', "St. Joseph's Villa, Dundas", "St. Paul's l'Amoreaux Centre", "St. Stephen's Community House", 'Stonegate Community Health Centre', 'The Barbara Black Ctr. for Youth Res.', 'The Centre for Governance Innovation', 'The George Hull Centre', 'The Safehaven Proj for Community Living', 'Villa Colombo Homes', "Women's Christian Assoc.", 'CDSB of Eastern Ontario', 'CESC de Dubreuilville', 'CSC Franco-Nord', 'CSC des Grandes Rivières', 'CSD de Centre Sud-Ouest', "CSD de l'Est ontarien", "DSB du Nord-Est de l'Ontario", 'James Bay Lowlands Secondary SB', 'Northern Ontario School of Medicine', "St. Michael's College", 'Wycliffe College', 'Agricorp', 'Central East Local Health Integration Network', 'Central Health Integration Network', 'Central West Health Integration Network', 'Deposit Insurance Corporation of Ontario', 'Education Quality Accountability Office', 'Health Integration Network of Champlain', 'Health Integration Network of Erie St. Clair', 'Health Professions Appeal & Review Board', 'Local Health Integration Network (North West Ontario)', 'North East Health Integration Network', 'Ontario Educational Communications Authority (TVOntario)', 'Ontario Farm Products Marketing Commission', 'Ontario Infrastructrue Projects Corporation', "Ontario Municipal Employees' Retirement System", 'Coldwater', 'Ontario Parole and Earned Release Board', 'Ontario Strategic Infrastructure Financing Authority', 'Ontario Tourism Marketing Partnership Corporation', 'South East Health Integration Network', 'South West Local Health Integration Network', 'Walkerton Clean Water Centre', 'Workplace Safety and Insurance Appeals Tribunal', 'Information & Privacy Commissioner', 'Integrity Commissioner', 'Aboriginal Affairs Secretariat', 'Children and Youth Services', 'Citizenship and Immigration', 'Community Safety & Corr. Services', 'Health and Long-Term Care', 'Research and Innovation', 'Englehart and District Hospital', 'Four Counties Health Services', 'Groves Memorial Community Hospital', 'Hanover and District Hospital', 'Hopital Glengarry Memorial Hospital', 'Hospital Administrative Services', 'Hotel Dieu Shaver Health & Rehabilitation Centre', 'Hôpital Notre-Dame Hospital, Hearst', 'Red Lake Margaret Cochenour Memorial Hosp', 'Riverside Health Care Facilities, Inc', 'Services de sante de Chapleau Health Services', 'Sioux Lookout Meno Ya Win Health Centre', 'The Lennox & Addington County General Hospital', 'The McCausland Hospital', "The Perley and Rideau Veterans' Health Centre", 'City Clarence-Rockland', 'City of Kendra', 'Corp. of Haldimand County', 'Corporation of the County of Grey', 'Corporation of the Municipality of Greenstone', 'Corporation of the Town of Bracebridge', 'Corporation of the Town of Hanover', 'Corporation of the Town of Hearst', 'Corporation of the Town of Kingsville', 'Corporation of the Town of Smiths Falls', 'Corporation of the Township of Seguin', 'Corporation of the Township of Springwater', 'Corporation of the Township of The Archipelago', 'Municipality of Leamington, Police Services Board', 'Municipality of Whitestone', 'Rainy River District Social Services Admin. Board', 'The Corporation of The Town of New Tecumseth', 'The Corporation of the Municipality of Sioux Lookout', 'Aylmer', 'The Corporation of the Township of Oro-Medonte', 'The Corporation of the Township of West Lincoln', 'The Corporation of the Township of Wilmot', 'The Township of Brock', 'The Untd. Counties of Stormont, Dundas & Glengarry', 'Town of Goderich', 'Town of Gravenhurst', 'Town of Mississippi Mills', 'Town of Perth', 'Town of Smiths Falls, Smiths Falls Police Services', 'Township of Loyalist', 'Township of Michipicoten', 'Township of Rideau Lakes', 'Township of Scugog', 'Township of Severn', 'Accessible Community Counselling and Employment Services', 'Acclaim Health and Community Care Services', 'Albright Gardens Homes Inc', 'Amity Goodwill', 'Arbour Creek Long Term Care Centre', 'Building and Construction Trades Council of Ontario', 'CAS - United Counties of Stormont, Dundas & Glengarry', 'CHATS Community Home Assistance to Seniors', 'COTA Comprehensive Rehabilitation & Mental Hlth. Srvcs', 'Cama Woodlands Nursing Home', 'Canadian Blood Services', 'Canadian Film Centre', 'Canadian Mental Health Association, Ontario Division', 'Canadian Mothercraft Society', 'Canadian National Institute for the Blind (CNIB)', 'Canadian Opera House Corporation', 'Canadian Paraplegic Association Ontario', 'Canadian Youth Business Foundation', 'Carefirst Seniors & Community Services Association', 'Carefor Health & Community Services', 'Centre Franco-ontarien de ressources pédagogiques', 'Centre de santé communautaire du Témiskaming', "Centre de santé communautaire le l'Estrie", 'Centre des services Communitaires de Vanier/ Vanier CSC', 'Centretown Community Health Centre Inc', "Child Care Resources / Ressources sur la garde d'enfants", 'Child Development Institute', "Children's Mental Health-Oolagen Community Services", 'Clarendon Foundation (Cheshire Homes) Inc', 'Coleman Care Centre', 'Community Living St.Catharines', 'Conservation Ontario', 'Corporation of Council of Ministers of Education', 'Eastholme Home for the Aged', 'Erinoak Serving Young People With Physical Disabilities', "Family & Children's Services of the District of Rainy River", 'Fife House Foundation Inc', 'Frontenac Community Mental Health Services', 'Frontier College', 'Frontier College Foundation', 'Glengarda Child and Family Services', 'Grand Bend Community Health Centre', 'Grape Growers of Ontario', 'Hospital Administrative Services/Plexxus', 'IOOF Seniors Homes Inc', 'Institute for Clinical Evaluative Sciences', 'J. D. Griffin Adolescent Centre Inc', 'Jewish Family and Child Service', 'Jewish Vocational Services', 'Joint Policy and Planning Committee', 'Kennedy House Youth Services Inc', 'Keystone Child, Youth and Family Service', 'Kids Help Phone', 'KidsAbility Centre for Child Development', 'Lake Ridge Community Support Services', 'Lake Simcoe Region Conservation Authority', 'Laurencrest Youth Services Inc', 'Lawrence Heights Community Health Centre', "Lennox & Addington Family & Children's Services", 'Maryvale Adolescent and Family Services', 'Meta Centre', 'Mon Sheong Foundation', 'Near North Community Care Access Centre', 'NorWest Community Health Centres', 'Notre Dame of St. Agatha Inc', 'One Kids Place', 'Ongwanada Hospital (Community Centre)', "Ontario Association of Children's Aid Societies", 'Ontario Association of Community Care Access Centres', 'Ontario Cancer Biomarker Network', 'Ontario Centres of Excellence Incorporated', 'Ontario Federation of Indian Friendship Centres', 'Ontario Health Quality Council', 'Ontario Multifaith Council', 'Ontario Physical & Health Education Association', 'Operation Springboard', 'Pathways for Children and Youth', 'Pathways to Independence', 'Pediatric Oncology Group of Ontario', 'Pinecrest-Queensway Health & Community Services', 'Plainfield Community Homes', 'Rainy River First Nations', 'Reconnect Mental Health Services Inc', 'Schizophrenia Society of Ontario', 'Services familiaux Jeanne Sauvé Family Services', 'Shepherd Village Incorporated', 'Soy 20/20 Project', 'St. Demetrius (Ukrainian Catholic) Development Corp', 'Summit Housing & Outreach Programs', 'The Barbara Black Centre for Youth Resources', 'The Bernard Betel Centre for Creative Living', 'The Canadian Institute for Advanced Research', 'The Centre for International Governance Innovation', 'The Delisle House Association', 'The George R. Gardiner Museum of Ceramic Art', 'The Kensington Health Centre', 'The Macaulay Child Development Centre', 'The Maytree Foundation', 'The Michener Insitute for Applied Health Sciences', 'The Royal Conservatory of Music', 'The Royal Life Saving Society Canada, Ontario Branch', 'The Salvation Army', 'The Wexford Residence Inc', 'Hamilton', 'WoodGreen Community Services', 'Seaforth', 'Chesley', 'CSD catholique Centre-Sud', 'CSD catholique des Grandes Rivières', "CSD public du Nord-Est de l'Ontario", 'Kemptville', "L'Orignal", 'Conseil scolaire de district catholique des Aurores boréales', 'Schumacher', 'Huron Superior Catholic District School Board', 'James Bay Lowlands Secondary School Board', 'Northwest Catholic District School Board', 'Upsala', 'University of Ontario Institute of Tech.', "University of St. Michael's College", 'Advertising Review Board', 'Alcohol & Gaming Commission of Ontario', 'Child & Family Srvcs. Review Bd./Custody Review Bd', 'Education Quality & Accountability Office', 'HealthForceOntario Marketing & Recruitment Agency', 'Higher Education Quality Council of Ontario', 'Landlord & Tenant Board', 'Local Health Integration Network - Central', 'Local Health Integration Network - Central East', 'Local Health Integration Network - Central West', 'Local Health Integration Network - Champlain', 'Local Health Integration Network - Erie St. Clair', 'Local Health Integration Network - North East', 'Local Health Integration Network - North West Ontario', 'Local Health Integration Network - South East', 'Local Health Integration Network - South West', 'Ontario Educational Communications Authority (TVO)', 'Ontario Film Review Board', 'Ontario Infrastructure Projects Corporation', 'Ontario Parole & Earned Release Board', 'Workplace Safety & Insurance Appeals Tribunal', 'Ontario Court of Justice[1]', 'Superior Court of Justice', 'Aboriginal Affairs', 'Community Safety & Correctional Services', 'Government & Consumer Services', 'Revenue', 'Small Business & Entrepreneurship', 'Englehart & District Hospital', 'ErinoakKids Centre for Treatment & Development', 'Geriatric Psychiatry Community Services', 'Hopital Notre-Dame Hospital Hearst', 'Hôpital du district de Geraldton', 'Providence Care', 'Red Lake Margaret Cochenour Memorial Hospital', 'Riverside Health Care Facilities', 'Runnymede Health Care Centre', 'Sandy Hill CHC, Inc./CSC Côte-de-Sable, Inc', 'South Huron Hospital Association', 'County of Perth', 'Haldimand County', 'Loyalist Township', 'Municipality of Kincardine', 'Municipality of Wawa', 'Town of Espanola', 'Town of Hanover', 'Town of Ingersoll', 'Town of Kingsville', 'Town of Shelburne', 'Town of Smiths Falls', 'Township of Cavan Monaghan', 'Township of Clearview', 'Township of East Garafraxa', 'Township of Oro-Medonte', 'Township of Perth East', 'Township of Ramara', 'Township of Stirling-Rawdon', 'Township of West Lincoln', 'Township of Wilmot', 'Treaty Three Police Services Inc', 'United Counties of Stormont, Dundas & Glengarry', 'Accessible Community Counselling & Employment Services', 'Bellwoods Centres for Community Living Inc', 'Belvedere Heights', 'Central Community Care Access Centre', 'Central East Community Care Access Centre', 'Central West Community Care Access Centre', "Centre de santé communautaire de l'Estrie", 'Centre des services communautaires de Vanier', 'Centre franco\x96ontarien de ressources pédagogiques', 'Champlain Community Care Access Centre', 'Child & Youth Wellness Centre of Leeds & Grenville', "Child Care Resources/Ressources sur la garde d'enfants", "Children's Aid Society of Simcoe", "Children's Aid Society of Stormont, Dundas & Glengarry", 'Christian Horizons, Canada', 'Community Occupational Therapist Association Health', 'Council of Ministers of Education, Canada', "Crossroads Children's Centre", 'Davenport-Perth Neighbourhood Centre', 'E3 (Educate, Enable, Empower) Community Services', 'Earlscourt-Creche Child Development Institute', 'Fairhaven', 'Hellenic Home for the Aged Inc', 'Homes First Society', 'Imagine Canada', 'Integra Foundation', 'Jeanne Sauvé Family Services', 'Joint Policy & Planning Committee', 'Keystone Child, Youth & Family Services', 'Kunuwanimano Child & Family Services', 'Lakeshore Area Multiservice Project CHC', 'Mainstay Housing', 'Mamaweswen, The North Shore Tribal Council', 'Maryvale Adolescent & Family Services', "Merrymount Children's Centre", 'North East Community Care Access Centre', 'North Park Nursing Home Limited', 'Northern Youth Services Inc', 'Northwest Community Care Access Centre', 'Nucleus Independent Living', "Ontario Cattlemen's Association", 'Ontario Centres of Excellence, Incorporated', 'Ontario Education Collaborative Marketplace', 'Ontario Telemedicine Network', 'PARTEQ Research & Development Innovations', 'Pathways To Independence', 'Pathways for Children & Youth', 'Payukotayno, James & Hudson Bay Family Services', 'Plexxus', 'Rainy River District Social Services Administration Board', 'Reach Out Centre for Kids', 'Reena', 'Ritz Lutheran Villa', 'Royal Crest Lifecare Group Inc', "Saint Luke's Place", 'Sandwich Community Health Centre Inc', 'Shepherd Village Inc', 'Social Enterprise for Canada', 'South East Community Care Access Centre', 'South West Community Care Access Centre', 'St. Demetrius (Ukrainian Catholic) Development Corporation', 'Sunbeam Residential Development Centre', 'The Anne Johnston Health Station', 'The Dorothy Ley Hospice', 'The Elliott Community', 'The Four Villages Community Health Centre', 'The George Hull Centre for Children & Families', 'The Governing Council of the Salvation Army', 'The Michener Institute for Applied Health Sciences', 'Transitions for Youth', 'Trellis Mental Health & Developmental Services', 'Tri-County Mennonite Homes', 'Union of Ontario Indians', 'United Way of Canada - Centraide Canada', 'Upper Thames River Conservation Authority', 'Villa Colombo Homes for the Aged Inc', "Women's Christian Association (McCormick Home)", "Women's Health in Women's Hands CHC", 'World Education Services', 'Youth Employment Services YES', 'Youthlink', 'CDEC, langue française du Centre-Est', 'CSC de district des Grandes Rivières', 'CSD catholique des Aurores boréales', 'CSD des écoles catholiques du Sud-Ouest', 'Connell & Ponsford District School Area Board', 'Conseil scolaire de district du Centre-Sud-Ouest', "Conseil scolaire de district du Nord-Est de l'Ontario", "Conseil scolaire public du Grand Nord de l'Ontario", 'Dubreuilville Roman Catholic Separate School Board', 'KidsAbility School Authority', 'Moosonee', 'College Compensation & Appointments Council', 'Grievance Settlement Board', 'Independent Police Review Office', 'Office of the Chair (Ontario Parole & Earned Release Board)', 'Office of the Fairness Commissioner', 'Office of the French Language Services Commissioner', "Office, télécomm. éduc. de langue française de l'Ontario", 'Ontario Agency for Health Protection & Promotion', 'Ontario Civilian Commission on Policing', 'Chief Electoral Officer', 'Economic Development', 'Energy & Infrastructure', 'International Trade & Investment', 'Small Business & Consumer Services', 'Alexandra Hospital', 'Red Lake Margaret Cochenour Hospital', 'Riverside Health Care Facilities Inc', 'Services de santé de Chapleau', 'Chippewas of Rama First Nation', 'City of Clarence Rockland', 'Covent Garden Market Corporation', 'Middlesex County Library', 'Municipality of Bluewater', 'Municipality of McDougall', 'Municipality of Middlesex Centre', 'Municipality of North Grenville', 'Municipality of North Perth', 'Municipality of Temagami', 'Municipality of Thames Centre', 'Municipality of Trent Hills', 'The Nation Municipality', 'Town of Gananoque', 'Town of Greater Napanee', 'Town of Penetanguishene', 'Town of Perry Sound', 'Town of Saugeen Shores - Police Services', 'Town of South Bruce Peninsula', 'Township of Adelaide Metcalfe', 'Township of Beckwith', 'Township of Lake of Bays', 'Township of Malahide', 'Township of Russell', 'Williamsburg', 'Township of Wellesley', 'Township of the Archipelago', 'Access Alliance Multicultural Health', 'Access. Comm. Coun./Employment Srvcs. For New Cdns.', 'Acclaim Health & Community Care Services', 'Alliance of Manufacturers & Exporters Canada', 'Association of Colleges of Applied Arts & Technology of Ontario', 'Association of Local Public Health Agencies', 'Association of Ontario Health Centres', 'Bellwoods Centres For Community Living Inc', 'Better Living Health & Community Services', 'Big Brothers Big Sisters of Canada', 'Blue Hills Academy', 'Blue Sky Family Health Team', 'CAMA Woodlands Nursing Home', 'CANES Community Care', 'CON*NECT Strategic Alliances', 'Canadian Education Association', 'Canadian Mental Health Association', 'Carefirst Family Health Team', 'Central Jewish Institute, Hillcrest Progressive School', 'Centre des services communautaires Vanier', 'Centre for Family Medicine Family Health Team', 'Centre franco-ontarien de ressources pédagogiques', 'Child Care Resources', "Children's Aid Society of Bruce", 'Clinton Family Health Team', 'Community Living Huronia', 'Community Living Wallaceburg', 'Community MicroSkills Development Centre', 'Coordination des Services Coordination', 'Ctr., Evaluation of Hlth. Professionals Educated Abroad', 'Delhi Imperial Place Community Health Centre Inc', 'Delisle Youth Services', 'Dixon Hall', 'Dorothy Ley Hospice', 'Dorval Medical Associates Family Health Team', 'E3 (Educate, Enable, Empower) Community Services Inc', 'Eastern Ontario Youth Justice Agency', "Family & Children's Services Lennox & Addington", 'Fenelon Family Health Team', 'Findhelp Information Services', 'Harrow Health Centre Inc', 'Heritage Green Nursing Home', 'Houselink Community Homes', 'JobStart', 'LAMP Community Health Centre', 'Lake Simcoe Conservation Authority', 'Lynnwood Hall Child & Family Centre', 'Maple Family Health Team Inc', 'Marianhill Inc', 'Marycrest Home For the Aged', 'Merrickville District Community Health & Services Centre', 'Montage Support Services', 'MukiBaum Association', 'Nature Conservancy of Canada', 'New Heights Community Health Centres', 'New Leaf, Living & Learning Together Inc', 'North Park Nursing Home Ltd', 'Northern Lights', 'Ontario Centres of Excellence, Inc', 'Ontario Lung Association', 'Ontario Problem Gambling Research Centre', 'Ontario Public Health Association', 'Ontario Society for the Prevention of Cruelty to Animals', 'Osteoporosis Canada', 'Parks & Recreation Ontario', 'Pinecrest-Queensway Community Health Centre', 'Project Hostel, Yellow Brick House', 'Rehabilitation Foundation for the Disabled', 'St. Christopher House', 'St. Demetrius (Ukrainian Catholic) Dev. Corp.', 'Sunset Country Family Health Team', 'The ACT Foundation', 'The Change Foundation', 'The Glebe Centre Incorporated', 'The Governing Council of The Salvation Army', 'Trinity Village Care Centre', 'United Way Canada - Centraide Canada', 'Vineland Research & Innovation Centre', 'Western Area Youth Services, Inc', 'William W. Creighton Youth Services', "Women's Christian Association - McCormick Home", 'Yellow Brick House', 'Yes I Can Nursery School', 'Youth Employment Services (YES)', 'Youth Science Canada', 'Conseil scolaire public du Grand Nord', 'Conseil scolaire public du Nord-Est', 'Gogama District School Area Board', 'Nakina District School Area Board', 'Red Lake Area Combined Roman Catholic Sep Sch Bd', 'Cardiac Care Network of Ontario', 'Child & Family Srvcs. Review Bd./Custody Review Bd.', 'Health Boards Secretariat', 'Human Rights Legal Support Centre', "Office des télécomm. éducatives, langue française de l'Ont.", 'Office of the Independent Police Review Director', 'Ontario Educational Communications Authority', 'Provincial Advocate', 'Consumer Services', 'Northern Development, Mines & Forestry', 'Englehart & District Hospital Inc.', 'Hôpital Notre-Dame Hospital (Hearst)', 'Lennox & Addington County General Hospital', 'Mental Health Centre Penetanguishene', 'Riverside Health Care Facilities Inc.', 'Services de santé de Chapleau Health Services', 'Smooth Rock Falls Hospital Corporation', 'Collingwood Public Utilities Service Board', 'County of Middlesex - Library', 'Brighton', 'Brockton', 'Municipality of Meaford', 'Municipality of Red Lake', 'Municipality of South Huron', 'Town of Erin', 'Town of Smiths Falls - Fire', 'Town of Smiths Falls - Police Service', 'Town of St. Marys', 'Township of Algonquin Highlands', 'Township of Champlain', 'Township of Douro-Dummer', 'Township of Edwardsburgh/Cardinal', 'Township of Essa', 'Township of Minden Hills', 'Township of Puslinch', 'Township of Zorra', 'Access Alliance Multicultural Health & Community Services', 'Across Boundaries', 'Albright Gardens Homes Inc.', 'Amity Goodwill Industries', 'Assn. of Colleges of Applied Arts & Technology of Ontario', "Assn., Conservation Auth's of Ont. (Conservation Ontario)", 'Association of Local Public Health Agencies (alPHa)', 'Association of Ontario Midwives', 'Big Brothers & Sisters of Canada', 'Boost Child Abuse Prevention & Intervention', 'Bramalea', 'Bridges Community Health Centre Corporation', 'Broadview Foundation operating as Chester Village', 'Canadian Energy Efficiency Alliance', 'Canadian Sport Centre', 'Central Ontario Healthcare Procurement Alliance', 'Centre Psychosocial', "Children's Community Network", 'Clarendon Foundation (Cheshire Homes) Inc.', 'Communitech Technology Association Inc.', 'Community Microskills Development Centre', 'Contact North - Contact Nord', 'Dale Brain Injury Services Inc.', 'E3 (Educate, Enable, Empower) Community Services Inc.', "Echo: Improving Women's Health in Ontario", 'F. J. Davey Home', "Five Counties Children's Centre", 'Flowers Canada (Ontario) Inc.', 'Fred Victor Centre', 'Friuli Long Term Care operating as Villa Leonardo Gambin', 'Griffin Centre Mental Health Services', 'Hearthouse Hospice Inc.', 'Hellenic Home for the Aged Inc.', 'Huron Community Family Health Team', 'IOOF Seniors Homes Inc.', 'Innovative Community Support Services', 'Laurencrest Youth Services Inc.', 'Maison Fraternité', 'Maryvale', 'Metis Nation of Ontario', 'Mohawk Shared Services Inc.', 'Mount Nemo Christian Nursing Home', 'New Leaf: Living & Learning Together Inc.', 'New Path Youth & Family Services', 'Nisbet Lodge', 'North Huron Family Health Team', 'North Park Nursing Home Ltd.', 'Norwest Community Health Centre', "One Kids Place Children's Med. Treat. Ctr., Northeast Ont.", 'Ontario Brain Injury Association', 'Ontario Centres of Excellence, Inc.', 'Ontario Library Service-North', 'Patricia Centre for Children & Youth', 'Payukotayno: James & Hudson Bay Family Services', 'Phoenix Wholistic Health Centre', 'Pine River Institute', 'Reach Out Centre For Kids', 'Reconnect Mental Health Services Inc.', 'Rideau Valley Conservation Authority', 'Sandy Hill CHC, Inc./CSC cote de sable, inc.', 'Shalom Manor Long Term Care Home', 'Shared Support Services Southeastern Ontario', 'Sherwood Park Manor', 'Skills For Change', 'Smart Risk Foundation', 'Social Enterprise For Canada', 'Social Housing Services Corporation', 'South Nation River Conservation Authority', 'Southwest Centre for Community Programme Development', 'Spruce Lodge Home for the Aged', "St. Alban's Boys' & Girls' Club", 'St. Demetrius (Ukrainian Catholic) Development Corp.', "St. Hilda's Towers Inc.", "St. Joseph's Home Care", "St. Joseph's Villa Dundas", 'TAIBU Community Health Centre', 'Tamir Foundation', "Thames River Children's Centre", 'The Arthritis Society - Ontario Division', 'The Gairdner Foundation', 'The In Community', 'The Massey Centre for Women', 'The Safehaven Project for Community Living', 'Thorncliffe Neighbourhood Office', 'Tikinagan Child & Family Services', 'Tobias House Attendant Care Inc.', 'Total Communication Environment', 'Treaty Three Police Service Inc.', 'VHA Health & Home Support', 'Valleyview Residence', 'Variety Village', 'Victorian Order of Nurses', 'Vineland Research & Innovation Centre Inc.', 'Vista Centre', "Women's Community House", 'CSD de scolaire du Centre-Sud-Ouest', "Campbell Children's School Authority", "Conseil scolaire du district du Grand Nord de l'Ontario", 'Protestant Separate Sch Bd, Town of Penetanguishene', 'CDS de scolaire du Centre-Sud-Ouest', 'CSC de District des Grandes Rivières', 'CSD\xa0des écoles catholiques du Sud-Ouest', 'English Language District SSB', 'Health Board Secretariat', 'Office of the Employer Adviser', 'Office of the Worker Adviser', 'Ontario Civilian Police Commission', 'Health Promotion & Sport', 'Infrastructure', 'Tourism & Culture', 'Alexandra Hospital, Ingersoll', 'Huron County Health Unit', "St. Joseph's Continuing Care Centre", 'Covent Garden', 'Municipality of Central Huron', 'Municipality of East Ferris', 'Municipality of Magnetawan', 'Municipality of West Grey', 'Town of Moosonee', 'Township of McKellar', 'Township of Norwich', 'Township of Sables-Spanish Rivers', 'Township of Smith-Ennismore-Lakefield', 'Township of South Frontenac', 'Township of South Glengarry', 'Township of Whitewater Region', 'Village of Point Edward', 'Aberdeen Health & Community Services', 'AbleLiving Services Inc.', 'Advent Health Care Corporation/Valleyview Residence', 'Alliance of Ontario Food Processors', 'Alpine Ontario Alpin', "Ambercroft Labourers' 506 Training Centre", 'Association of Conservation Authorities of Ontario', 'Autism Society Ontario', 'Big Brothers Big Sisters Canada', 'Bluewater Area Family Health Team', 'Boundless Adventures', 'Bridges Community Health Centre', 'Brock Community Health Centre', 'CHATS - Community & Home Assistance to Seniors', 'Canadian Independent Music Association', 'Canadian Institute for Advanced Research', 'Canadian Sport Centre Ontario', 'Catholic Immigration Centre', "Centre Moi j'apprends Inc.", 'Centre for International Governance Innovation', 'Centre for Research & Innovation in the Bio-Economy', 'Collège des Grands Lacs', 'Consolidated Health Information Services', 'Council of Ministers of Education, Canada (CCMEC)', 'Ctr des services de dév. Stormont/Dundas/Glengarry', 'Dale Brain Injury Service Inc.', 'De dwa de dehs nye>s Aboriginal Health Centre', 'DeafBlind Ontario Services', 'Delhi Family Health Team Inc.', 'Dietitians of Canada', 'Dixie Bloor Neighbourhood Centre', 'Don Mills Foundation For Seniors', 'Dorval Medical Family Health Team', 'Eastern Lake Ontario Innovation Network', "Family & Children's Services of the Rainy River District", 'Federation of Ontario Naturalists', 'Fort Frances Community Clinic Inc.', 'Friends of the Greenbelt Foundation', 'Friuli Long Term Care o/a Villa Leonardo Gambin', 'Golden Horseshoe Biosciences Network', 'Grand River Community Health Centre', 'GreenCentre Canada', 'HIV & AIDS Legal Clinic (Ontario)', 'Haldimand Family Health Teams Inc.', 'Harrow Health Centre Inc.', 'Holland Christian Homes Inc.', 'House of Sophrosyne', 'Ina Grafton Gage Home', 'Ivan Franko Home', 'Job Skills - Employment & Business Programs Support', 'Job Start', 'K-W Habilitation Services', 'K3C Community Counselling Centres', 'Lakeland Long-Term Care Services', 'Learning Enrichment Foundation', 'Links2Care', 'Lynwood Hall Child & Family Centre', 'Maple Family Health Team Inc.', 'Mary Berglund Community Health Centre', 'Maxville Manor', 'Merrickville District Community Health & Health Srvcs. Ctr.', 'Momiji Health Care Society', 'Montfort Renaissance', 'Mushkegowuk Council', 'Métis Nation of Ontario', 'New Leaf Living & Learning Together Inc.', 'North of Superior Counselling Services', 'Northern Centre for Advanced Technology Inc.', 'Northern Ontario Library Service Board', 'Oasis Addiction Recovery Society', 'One Change Foundation', 'Ontario 211 Services Corp.', 'Ontario Aboriginal Housing Support Services Corporation', "Ontario Association of Children's Rehabilitation Services", 'Ontario Colleges Library Service', 'Ontario Independent Meat Processors Association', "Ontario Native Women's Association", 'Ontario Sailing', 'Ontario Society of Professional Engineers', 'Orléans-Cumberland Community Resource Centre', 'PROcure Healthcare', 'Pathways Health Centre for Children', 'Pathways to Education Canada', 'Payukotayno: James & Hudson Bay Family Service', 'Peninsula Family Health Team', 'Pollution Probe Foundation', 'Punjabi Community Health Services', 'Quality Continuous Improvement Centre', 'Quality Improvement & Innovation Partnership', 'Recycling Congress of Ontario', 'Roots of Empathy', 'Sandy Hill CHC, Inc./CSC Côte-de-Sable, Inc.', 'Saugeen Valley Conservation Authority', 'Seaway Valley Community Health Centre', 'Seven Generations Education Institute', 'Shad Valley International', "Sheet Metal Workers' Int'l Assoc Loc 285 Training Trust Fnd", 'Sioux Lookout First Nations Health Authority', 'Skills Canada-Ontario', 'Southwest Centre for Community Program Development', "St. Alban's Boys & Girls' Club", "St. Joseph's at Fleming", "St. Mary's Home", "St. Peter's Care Centres", 'Summerville Family Health Team', 'The Glebe Centre Inc.', 'The Kensington Eye Institute', 'The Mennonite Home Association', 'Thorncliffe Neighbourhood Office, Social/Multicultural Dev.', 'TransCare Community Support Services', 'Unionville Home Society', 'Unison Health & Community Services', 'Upper Grand Family Health Team', 'Victorian Order of Nurses for Canada, Ontario Branch', 'Villa Marconi Long Term Care Centre', 'Vineland Research & Innovations Centre Inc.', 'West GTA Healthcare Shared Services Corporation', 'Western Area Youth Services Inc.', 'Westover Treatment Centre', "Woodview Children's Centre", 'World Green Building Council', 'YouthLink', 'htx.ca - The Health Technology Exchange', "Conseil scolaire public du Nord-Est de l'Ontario", 'Huron-Perth Catholic District School Board', 'CSC\xa0de District des Grandes Rivières', "CSD\xa0catholique de l'Est ontarien", 'Advertising Review Board / Commission de révision de la publicité', "Alcohol & Gaming Commission of Ontario / Commission des alcools et des jeux de l'Ontario", "Child & Family Services Review Board/Custody Review Board / Commission de révision des services à l'enfance et à la famille / Commission de révision des placements sous garde", 'Death Investigation Oversight Council / Conseil de surveillance des enquêtes sur les décès', 'Deposit Insurance Corporation of Ontario / Société ontarienne d´assurance-dépôts', 'Education Quality & Accountability Office / Office de la qualité et de la responsabilité en éducation', "Environmental Review Tribunal / Tribunal de l'environnement", "Financial Services Commission / Commission des services financiers de l'Ontario", 'Grievance Settlement Board / Commission de règlement des griefs', 'Health Board Secretariat / Secrétariat des conseils de santé', 'HealthForceOntario Marketing & Recruitment Agency / Agence de promotion et de recrutement de ProfessionsSantéOntario', "Higher Education Quality Council of Ontario / Conseil ontarien de la qualité de l'enseignement supérieur", "Human Rights Legal Support Centre / Centre d'assistance juridique en matière de droits de la personne", "Human Rights Tribunal of Ontario / Tribunal des droits de la personne de l'Ontario", 'Landlord & Tenant Board / Commission de la location immobilière', 'Legal Aid Ontario / Aide Juridique Ontario', "Licence Appeal Tribunal / Tribunal d'appel en matière de permis", "Local Health Integration Network - Central / Réseau local d'intégration des services de santé - Centre", "Local Health Integration Network - Central East / Réseau local d'intégration des services de santé - Centre-Est", "Local Health Integration Network - Central West / Réseau local d'intégration des services de santé - Centre-Ouest", "Local Health Integration Network - Champlain / Réseau local d'intégration des services de santé - Champlain", "Local Health Integration Network - North East / Réseau local d'intégration des services de santé - Nord-Est", "Local Health Integration Network - North West Ontario / Réseau local d'intégration des services de santé - Nord-Ouest", "Local Health Integration Network - South East / Réseau local d'intégration des services de santé - Sud-Est", "Local Health Integration Network - South West / Réseau local d'intégration des services de santé - Sud-Ouest", "McMichael Canadian Art Collection / Collection McMichael d'art canadien", "Northern Ontario Heritage Fund Corporation / Société de gestion du Fonds du patrimoine du Nord de l'Ontario", "Office des télécommunications éducatives de langue française de l'Ontario / The Ontario French Language Educational Communications Authority (TFO)", 'Office of the Employer Adviser / Bureau des conseillers des employeurs', "Office of the Fairness Commissioner / Bureau du commissaire à l'équité", 'Office of the French Language Services Commissioner / Commissariat aux services en français', "Office of the Independent Police Review Director / Bureau du directeur indépendant de l'examen de la police", 'Office of the Worker Adviser / Bureau des conseillers des travailleurs', 'Ontario Agency for Health Protection & Promotion / Agence ontarienne de protection et de promotion de la santé', "Ontario Arts Council / Conseil des arts de l'Ontario", "Ontario Civilian Police Commission / Commission civile de l'Ontario sur la police", 'Ontario Clean Water Agency / Agence ontarienne des eaux', "Ontario Educational Communications Authority / Office de la télécommunication éducative de l'Ontario", "Ontario Film Review Board / Commission de contrôle cinématographique de l'Ontario", 'Ontario Financing Authority / Office ontarien de financement', "Ontario Food Terminal Board / Commission du marché des produits alimentaires de l'Ontario", 'Ontario Health Quality Council / Qualité des services de santé Ontario', 'Ontario Heritage Trust / Fiducie du patrimoine ontarien', "Ontario Highway Transport Board / Commission des transports routiers de l'Ontario", 'Ontario Human Rights Commission / Commission ontarienne des droits de la personne', "Ontario Labour Relations Board / Commission des relations de travail de l'Ontario", "Ontario Media Development Corporation / Société de développement de l'industrie des médias de l'Ontario", 'Ontario Mental Health Foundation / Fondation ontarienne de la santé mentale', "Ontario Municipal Board / Commission des affaires municipales de l'Ontario", 'Ontario Parole Board / Commission ontarienne des libérations conditionnelles', "Ontario Racing Commission / Commission des courses de l'Ontario", "Ontario Review Board / Commission ontarienne d'examen", "Ontario Science Centre / Centre des sciences de l'Ontario", 'Ontario Tourism Marketing Partnership Corporation / Société du Partenariat ontarien de marketing touristique', "Pay Equity Commission / Commission de l'équité salariale", "Pay Equity Hearings Tribunal / Tribunal de l'équité salariale", 'Science North / Science Nord', "Social Benefits Tribunal / Tribunal de l'aide sociale", 'St. Lawrence Parks Commission / Commission des parcs du Saint-Laurent', 'Trillium Gift of Life Network / Réseau Trillium pour le don de vie', "Walkerton Clean Water Centre / Centre de Walkerton pour l'assainissement de l'eau", "Workplace Safety & Insurance Appeals Tribunal / Tribunal d'appel de la sécurité professionnelle et de l'assurance contre les accidents du travail", "Workplace Safety & Insurance Board / Commission de la sécurité professionnelle et de l'assurance contre les accidents du travail", "Ontario Court of Justice / Cour de justice de l'Ontario", 'Superior Court of Justice / Cour supérieure de justice', 'Chief Electoral Officer / Directeur général des élections', "Environmental Commissioner / Commissaire à l'environnement", "Information & Privacy Commissioner / Commissaire à l'information et à la protection de la vie privée", "Integrity Commissioner / Commissaire à l'intégrité", 'Lieutenant Governor / Lieutenant-gouverneur', 'Office of the Auditor General / Bureau du vérificateur général', 'Ombudsman Ontario / Ombudsman Ontario', "Provincial Advocate / Bureau de l'intervenant provincial", 'Aboriginal Affairs / Affaires autochtones', 'Agriculture, Food & Rural Affairs / Agriculture, Alimentation et Affaires rurales', 'Attorney General / Procureur général', 'Attorney\xa0General\xa0/\xa0Procureur général', "Children & Youth Services / Services à l'enfance et à la jeunesse", 'Citizenship & Immigration / Affaires civiques et Immigration', 'Comm. Safety & Corr. Services / Sécurité com. et Services corr.', 'Community & Social Services / Services sociaux et communautaires', 'Consumer Services / Services aux consommateurs', 'Economic Development & Innovation / Développement économique et Innovation', 'Education / Éducation', 'Energy / Énergie', 'Environment / Environnement', 'Finance / Finances', 'Government Services / Services gouvernementaux', 'Health & Long-Term Care / Santé et Soins de longue durée', 'Health Promotion & Sport / Promotion de la santé et Sport', 'Infrastructure / Infrastructure', 'Labour / Travail', 'Natural Resources / Richesses naturelles', 'Northern Development & Mines / Développement du Nord et des Mines', 'Office of Francophone Affairs / Office des affaires francophones', 'Office of the Premier / Cabinet du premier ministre', 'Tourism, Culture & Sport / Tourisme, Culture et Sport', 'Training, Colleges & Universities / Formation, Collèges et Universités', 'Blind River District Health Centre / Pavillon Sante du District de Blind River', "Board of Health for the Northwestern Health Unit / Le conseil de Santé pour l'Unité de Santé du nord-ouest", 'Casey House Hospice / Casey House, Foyer de Soins Palliatifs', "Englehart & District Hospital Inc. / Hôpital d'Englehart et du district", 'Hornepayne Community Hospital / Hôpital Communautaire de Hornepayne', 'Hôpital de Smooth Rock Falls Hospital Corporation', 'Kirkland & District Hospital / Hopital de Kirkland et du district', 'Lady Dunn Health Centre / Centre de santé Lady Dunn', "Leamington District Memorial Hospital / l'Hôpital quartier mémorial de Leamington", 'Manitouwadge General Hospital / Hôpital général de Manitouwadge', 'Sensenbrenner Hospital / Hôpital Sensenbrenner', 'St. Francis Memorial Hospital', 'Stevenson Memorial Hospital / Hôpital Stevenson Mémorial', "The Perley & Rideau Veterans' Health Centre / le Centre de santé Perley et Rideau pour anciens combattants", 'Waypoint Centre', "Canton d'Alfred et Plantagenet", 'Covent Garden Market', 'Municipality of Grey Highlands', 'Stirling-Rawdon Police Services', 'Town of Blind River', 'Town of Kapauskasing', 'Town of Minto', 'Town of Mono', 'Town of Petawawa', 'Township of Adjala-Tosorontio', 'Township of Ashfield-Colborne-Wawanosh', 'Township of Asphodel-Norwood', 'Township of Ear Falls', 'Township of Havelock-Belmont-Methuen', 'Township of Melancthon', 'Village of Casselman', 'Able Living Services Inc.', 'Albright Gardens Homes Incorporated', 'Algonquin Family Health Team', 'Associated Medical Services, Inc.', 'Association franco-ontarienne des conseils scolaires catholiques', 'Association of Ontario Health Centres / Les centres de santé communautaire en Ontario', 'Bellwoods Centres for Community Living Incorporated', 'Blue Hills Child & Family Centre', 'Breakaway Addiction Services', 'Broadview Foundation o/a Chester Village', 'CARE Centre for Internationally Educated Nurses', 'Canadian Deafblind Association Ontario Chapter', 'Canadian Elevator Industry Educational Program', 'Canadian National Institute for the Blind / Institut National Canadien pour les Aveugles', 'Canadian Reformed Society For A Home For The Aged Inc.', 'Canadian Reformed Society for a Home for the Aged Incorporated', 'Canadian Sport Centre - Ontario', 'Catholic Centre for Immigrants', "Central Community Care Access Centre / Centre d'accès aux soins communautaires du Centre", 'Central Community Health Centre', "Central West Community Care Access Centre / Centre d'acces aux soins communautaires du Centre-Ouest", 'Central West Specialized Developmental Services', 'Centre de santé communautaire CHIGAMIK Community Health Centre', 'Centre for Spanish Speaking Peoples', 'Centre for the Evaluation of Health Professionals Educated Abroad', 'Centretown Community Health Centre Inc. / Centre de santé communautaire du Centre-ville', "Champlain Community Care Access Centre / Centre d'acces aux soins communautaires de Champlain", "Child Care Resources / Ressources sur la Garde d'Enfants", "Children's Mental Health Ontario", 'Choices Association Inc.', 'Christian Horizons / Christian Horizons', 'Communitech Corporation', 'Community & Health Assistance to Seniors', 'Community & Primary Health Care, Community Family Health Team', 'Community Counselling & Addictions Services', 'Community Living Haldimand', 'Community Living Ontario', 'Community Living Walkerton & District', 'Community Living Wallaceburg / Intégration Communautaire Wallaceburg', 'Community Services Coordination Network (Ontario)', 'Contact North / Contact Nord', 'Coral Communications Enabled Applications Keystone', 'Corbrook Sheltered Workshop', 'Council for Business & the Arts in Canada', 'Council of Academic Hospitals of Ontario', 'Dave Smith Youth Treatment Centre', 'Davenport-Perth Neighbourhood & Community Health Centre', 'Delhi Family Health Team', 'Dixie Bloor Neighbourhood Drop-In Centre', 'Downsview Services for Seniors', 'Drs. Paul & John Rekai Centre', 'E3 Community Services', 'Evergreen', 'Fort Frances Community Clinic', 'Four Counties Addiction Services Team Inc.', 'Frontenac Community Mental Health & Addiction Services', 'Global Risk Institute in Financial Services', 'Hands TheFamilyHelpNetwork.ca / LeReseaudaideauxfamilles.ca', 'Homes First Society ', 'HopeGreyBruce Mental Health & Addictions Services', 'Hospital Diagnostic Imaging Repository Services', 'Huronia Transition Homes', 'Innovation Factory', 'Institute for Safe Medication Practices Canada', 'International Union of Operating Engineers Local 793 Training Fund', 'Job Skills - Employment & Business Programs & Supports', 'Kensington Eye Institute', 'Kensington Health Centre', "Kerry's Place Autism Services / Place Kerry Services d'Autisme", "Kids Help Phone / Jeunesse J'Ecoute", 'LAMP Community Health Care Centre', 'Lakeland Long Term Care', 'Learning Disabilities Association of Ontario', 'Leeds & Grenville Rehabilitation & Counselling Services', "Let's Talk Science", 'Liuna Local 183 Training & Rehabilitation Centre', 'Lynwood Charlton Centre', 'Mitacs Inc.', 'Miziwe Biik Development Corporation', 'Montfort Renaissance Inc.', 'Network for Innovation & Entrepreneurship', "New Canadians' Centre of Excellence Inc.", 'NorWest Community Health Centres / Centres de santé communautaire NorWest', "North East Community Care Access Centre / Centre d'accès aux soins communautaires du Nord-Est", 'North West Community Care Access Centre ', 'North of Superior Community Mental Health Programs Corp. / Programmes de counselling Nord du Supérieur', 'North of Superior Counselling Programs', 'Northeast Superior Forest Community Corporation', 'Northern Youth Services / Services à la jeunesse du nord', 'Notre-Dame of St. Agatha, Inc.', 'OnTrace Agri-food Traceability', "One Kids Place Children's Medical Treatment Centre of Northeast Ontario", 'Ontario 211 Services Corporation', 'Ontario Aboriginal Housing', 'Ontario BioAuto Council', 'Ontario Brain Institute', 'Ontario College of Trades', "Ontario Education Collaborative Marketplace / Marche Éducationnel Collaboratif de l'Ontario", 'Ontario Independent Meat Processors', 'Ontario Literacy Coalition / La coalition de l\x92alphabétisation de l\x92Ontario', 'Ontario Soil & Crop Improvement Association', 'Ontario Stroke Network', 'Ontario Telemedicine Network / Réseau Télémédecine Ontario', 'Ontario Volleyball Association', "Ontario Éducation Collaborative Marketplace / Marche Éducationnel Collaboratif de l'Ontario", 'OntarioMD Inc.', 'Pathstone Mental Health', 'Pinecrest-Queensway Community Health Centre / Centre de santé communautaire Pinecrest-Queensway', 'Portage Program for Drug Dependencies Inc. (Portage Ontario)', 'Progress Career Planning Institute', 'Project Hostel o/a Yellow Brick House', 'Quality Continuous Improvement Centre for Community Education & Training', 'Quest Community Health Centre', 'Registered Nurses Association of Ontario', 'Rehabilitation Foundation for the Disabled / Fondation pour la réadaptation pour les personnes handicapées', 'Retirement Homes Regulatory Authority / Office de réglementation des maisons de retraite', 'Rideau Community Health Services', 'Rideau Valley Conservation Authority / Office de Protection de la Nature de la Vallée Rideau', 'Right To Play International', 'Rural Ontario Institute', 'Sandy Hill Community Health Centre / Centre de santé communautaire Côte-de-Sable', 'Science Media Centre of Canada', 'Seven Generations Educational Institute', 'Shalom Village Nursing Home', "Sheet Metal Workers' International Association Local 285 Training Centre", 'Skills for Change', 'Skills/Competences Canada - Ontario', 'Softech Alliance Network', "South East Community Care Access Centre / Centre d'accès aux soins communautaires du sud-est", 'South East Community Health Centre', 'Southwest Ontario Aboriginal Health Access Centre', 'Speech & Stuttering Institute', 'Sport Alliance Ontario', "St. Joseph's Villa Dundas owned & operated by St. Joseph's Health System", "St. Leonard's Community Services", 'St. Paul\x92s L\x92Amoreaux Centre', 'Sunset County Family Health Team', 'The Fields Institute for Research in Mathematical Sciences', "The Governing Council of The Salvation Army / Conseil de direction de l'Armée du Salut", 'Tides Canada Initiatives Society', 'Tourism Industry Association of Ontario', 'Tourism Partnership of Ontario', 'Treaty Three Policy Services Inc.', 'Trees Ontario', 'Trellis Mental Health & Developmental Services / Santé de trellis mentale et des Services de développement', 'Tungasuvvingat Inuit', 'United Church of Canada in Ontario', 'Villa Marconi Long Term Care Center', 'Vista Centre Brain Injury Services', 'Wabano Centre for Aboriginal Health, Inc. / Centre de santé aborigène Wabano, inc.', "Women's Health in Women's Hands Community Health Centre", 'Conseil scolaire de district des écoles catholiques du Sud-Ouest', 'Moose Factory Island District School Area Board', 'Protestant Separate School Board of the Town of Penetanguishene', 'Collège de Hearst (Université de Hearst)', 'Child & Family Services Review Board', 'Death Investigation Oversight Council', "Fire Marshal's Public Fire Safety Council", 'Local Health Integration Network – Central', 'Local Health Integration Network – Central East', 'Local Health Integration Network – Central West', 'Local Health Integration Network – Champlain', 'Local Health Integration Network – Erie St. Clair', 'Local Health Integration Network – North East', 'Local Health Integration Network – North West Ontario', 'Local Health Integration Network – South East', 'Local Health Integration Network – South West', 'Northern Ontario Heritage Fund Corporation', "Office des télécommunications éducatives de langue française de l'Ontario", 'Office of the Conflict of Interest Commissioner', 'Ontario Court of Justice ', 'Superior Court of Justice ', 'Chief Electoral Officer ', 'Environmental Commissioner ', 'Information & Privacy Commissioner ', 'Integrity Commissioner ', 'Lieutenant Governor ', 'Office of the Auditor General ', 'Ombudsman Ontario ', 'Provincial Advocate ', 'Economic Development & Innovation', 'Health & Long–Term Care', 'Tourism, Culture & Sport', "Hotel Dieu Hospital / l'Hôpital Hôtel–Dieu", 'Leamington District Memorial Hospital / Hôpital Mémorial du district de Leamington', 'Leamington District Memorial Hospital / Hôpital mémorial du district de Leamington', 'Canton d’Alfred et Plantagenet / Township of Alfred-Plantagenet', 'County of Middlesex ', 'Municipality of Callander', 'Municipality of Huron East', 'Municipality of Morris-Turnberry', 'Municipality of North Middlesex', 'Municipality of Oliver Paipoonge', 'Municipality of Southwest Middlesex', 'The Nation Municipality / Municipalité de La Nation', 'Township of Augusta', 'Township of Cramahe', 'Township of East Zorra-Tavistock ', 'Township of Ignace', 'Township of Mulmur', 'Township of North Huron', 'Township of Seguin ', 'United Townships of Dysart , Dudley, Harcourt, Guilford, Harburn, Bruton, Havelock, Eyre & Clyde', 'Access Counselling & Family Services', 'Action ontarienne contre la violence faite aux femmes', 'Advent Health Care Corporation', 'Adventure Place', 'Board of Funeral Services', 'Boundless Adventures Association', 'Bruce Grey Child & Family Services', 'CHATS – Community & Home Assistance to Seniors', "Canada's Walk of Fame", 'Canadian Centre for Diversity', 'Canadian Council on Rehabilitation & Work', 'Canadian Mental Health Association, Grand River Branch', 'Canadian Reformed Society for a Home for the Aged Inc.', 'Canadian Sport Institute Ontario', 'Cassellhome', 'Catarqui Region Conservation Authority / Office de protection de la nature de la région de Cataraqui', 'Centre franco–ontarien de ressources pédagogiques', 'Centretown Community Health Centre Inc. / Centre de santé communautaire du Centre–ville', 'Charles H. Best Diabetes Centre', "Child & Community Resources / Ressources pour l'enfance et la communauté", "Children's Aid Society of Huron–Perth", "Children's Aid Society of Stormont, Dundas & Glengarry / Société de l'aide à l'enfance de Stormont, Dundas et Glengarry", "Children's Mental Health of Leeds & Grenville", 'City View Centre for Child & Family Services / Centre City View Services pour enfant et familles', 'Coalition for Persons with Disabilities', 'College of Kinesiologists of Ontario', 'Community Living Wallaceburg / Integration Communautaire Wallaceburg', 'Copernicus Lodge', 'Coral Communication Enabled Applications Keystone', 'Craigwood Youth Services', 'Davenport–Perth Neighbourhood & Community Health Centre', 'Dixie Bloor Neighbourhood Drop–In Centre', 'Downsview Service for Seniors', 'E3 Community Services Inc.', 'Earlscourt–Creche Child Development Institute', 'Essential Skills Ontario', 'FIREFLY – Physical, Emotional, Developmental & Community Services / FIREFLY – Services physique, émotifs, communautaires et pour le développement', "Family & Children's Services of Frontenac, Lennox & Addington", 'Fast Track – Community Centre for Skills, Development & Training', 'Fernie House', 'Friuli Long Term care', 'HIV & AIDS Legal Clinic Ontario', 'Health Nexus / Nexus Santé', 'Heart & Stroke Foundation of Ontario', 'Heart House Hospice Inc.', "Highland Shores Children's Aid Society", 'Hope Place Centre', 'Independent Order of Odd Fellows Seniors Homes Inc.', 'Information & Communications Technology Council', 'Infrastructure Health & Safety Association', 'Job Skills – Employment & Business Programs & Supports', 'K–W Habilitation Services', "Lansdowne Children's Centre", 'Learning Partnership Canada', 'Leeds & Grenville Mental Health', 'Life Sciences Ontario', 'MaRS Investment Accelerator Fund', 'Maison Fraternite', 'Markhaven Inc.', 'Mills Community Support Corporation', 'Montfort Renaissance inc.', 'Muki Baum Association for the Rehabilitation of Multi Handicapped Inc.', 'Neighbourhood Link Support Services', "North East Community Care Access Centre / Centre d'accès aux soins communautaires du Nord–Est", "North Eastern Ontario Family & Children's Services / Services à la famille et à l'enfance du Nord–Est de l'Ontario", 'Northern Youth Services / Services à la Jeunesse du Nord', 'Occupational Health Clinics for Ontario Workers Inc.', 'One Care Home & Community Support Services', 'Ontario Association of Distress Centres', 'Ontario Finnish Resthome Association', 'Ontario Institute of Cancer Research', 'Ontario Municipal Social Services Association (OMSSA)', 'Ontario Sheet Metal Workers Training Centre', 'Ontario University Athletics', 'On–Trace Agri–Food Traceability Incorporated', 'Orleans–Cumberland Community Resource Centre / Centre de ressources communautaires Orléans–Cumberland', 'Parkview Services for Seniors', 'Pathways For Children & Youth', 'Payukotayno: James & Hudsons Bay Family Services', 'Pinecrest–Queensway Community Health Centre / Centre de santé communautaire Pinecrest–Queensway', 'Progress Place Rehabilitation Centre', 'Public Services Health & Safety Association', 'Raisin Region Conservation Authority', 'Rosalie Hall', 'Safe Workplace Promotion Services Ontario', "Safehaven Project for Community Living / Le Projet Safehaven pour L'intégration Communautaire", 'Sandy Hill Community Health Centre, Inc. / Centre de santé communautaire Côte–de–Sable, Inc.', 'Seaway Valley Community Health Centre Inc.', 'Service Coordination For Persons With Special Needs / Coordination des services pour personnes ayant des besoins spéciaux', 'Shkagamik–Kwe Health Centre', 'Six Nations Polytechnic', 'Skills / Competences Canada – Ontario', "South East Community Care Access Centre / Centre d'accès aux soins communautaires du Sud–Est", 'South West Centre for Community Program Development', 'South–East Grey Community Health Centre', 'Spinal Cord Injury Ontario', "St. Alban's Boys & Girls Club", "St. Joseph's Home Care a member of St. Joseph's Health System", 'The Canadian Red Cross Society / La société Croix–Rouge canadienne', "The Governing Council of the Salvation Army / Conseil de direction de l'Armée du Salut", 'The Teresa Group Child & Family Aid', 'Three Trilliums Community Place Inc.', 'Transcare Community Support Services', 'Transitional Council of the College of Homeopaths of Ontario', 'Transitional Council of the College of Naturopaths of Ontario', 'Transitional Council of the College of Registered Psychotherapists & Registered Mental Health Therapists of Ontario', 'Traverse Independence', 'Trellis Mental Health & Developmental Services / Santé de treillis mentale et des Services de développement', 'Tri–County Mennonite Homes', 'Two Rivers Family Health Team Inc.', 'Ukrainian Home for the Aged – Ivan Franko Homes', 'Wabano Centre for Aboriginal Health Inc.', 'Wikwemikong Nursing Home Limited', 'Wikwemikong Tribal Police Service', 'Wood Manufacturing Council / Conseil des fabricants de bois', 'Woodgreen Red Door Family Shelter', 'Workers Health & Safety Centre', 'Workplace Safety North', 'Yor–Sup–Net Support Services Network', 'htx.ca – The Health Technology Exchange', 'Bruce–Grey Catholic District School Board', 'Conseil des écoles catholiques du Centre–Est', 'Conseil scolaire catholique Franco–Nord', 'Conseil scolaire catholique du Nouvel–Ontario', 'Conseil scolaire de district catholique Centre–Sud', 'Conseil scolaire de district des écoles catholiques du Sud–Ouest', "Conseil scolaire public du Nord–Est de l'Ontario", 'Huron–Perth Catholic District School Board', 'Huron–Superior Catholic District School Board', 'Keewatin–Patricia District School Board', 'Superior–Greenstone District School Board', 'Collège de Hearst', 'Advertising Review Board ', 'Alcohol & Gaming Commission of Ontario ', 'Child & Family Services Review Board/Custody Review Board', 'Consent & Capacity Board ', 'Criminal Injuries Compensation Board ', 'Death Investigation Oversight Council ', 'Deposit Insurance Corporation of Ontario ', 'Education Quality & Accountability Office ', 'Environmental Review Tribunal ', 'Financial Services Commission ', "Fire Marshal's Public Fire Safety Council ", 'Grievance Settlement Board ', 'Health Board Secretariat ', 'HealthForceOntario Marketing & Recruitment Agency ', 'Higher Education Quality Council of Ontario ', 'Human Rights Legal Support Centre ', 'Human Rights Tribunal of Ontario ', 'Landlord & Tenant Board ', 'Legal Aid Ontario ', 'Licence Appeal Tribunal ', 'Local Health Integration Network - Central ', 'Local Health Integration Network - Central East ', 'Local Health Integration Network - Central West ', 'Local Health Integration Network - Champlain ', 'Local Health Integration Network - North East ', 'Local Health Integration Network - North West Ontario ', 'Local Health Integration Network - South East ', 'Local Health Integration Network - South West ', 'McMichael Canadian Art Collection ', 'Northern Ontario Heritage Fund Corporation ', "Office des télécommunications éducatives de langue française de l'Ontario ", 'Office of the Conflict of Interest Commissioner ', 'Office of the Employer Adviser ', 'Office of the Fairness Commissioner ', 'Office of the French Language Services Commissioner ', 'Office of the Independent Police Review Director ', 'Office of the Worker Adviser ', 'Ontario Agency for Health Protection & Promotion ', 'Ontario Arts Council ', 'Ontario Civilian Police Commission ', 'Ontario Clean Water Agency ', 'Ontario Educational Communications Authority ', 'Ontario Farm Products Marketing Commission ', 'Ontario Financing Authority ', 'Ontario Food Terminal Board ', 'Ontario Health Quality Council ', 'Ontario Heritage Trust ', 'Ontario Highway Transport Board ', 'Ontario Human Rights Commission ', 'Ontario Labour Relations Board ', 'Ontario Media Development Corporation ', 'Ontario Mental Health Foundation ', 'Ontario Municipal Board ', 'Ontario Parole Board ', 'Ontario Racing Commission ', 'Ontario Science Centre ', 'Ontario Tourism Marketing Partnership Corporation ', 'Pay Equity Commission ', 'Pay Equity Hearings Tribunal ', 'Science North ', 'Social Benefits Tribunal ', 'St. Lawrence Parks Commission ', 'Trillium Gift of Life Network ', 'Walkerton Clean Water Centre ', 'Workplace Safety & Insurance Appeals Tribunal ', 'Workplace Safety & Insurance Board ', 'Office of the Chief Electoral Officer ', 'Aboriginal Affairs ', 'Agriculture & Food/Rural Affairs', 'Attorney General ', 'Children & Youth Services ', 'Citizenship & Immigration ', 'Community & Social Services ', 'Consumer Services ', 'Economic Dev., Trade & Employment/Research & Innovation', 'Education ', 'Energy ', 'Environment ', 'Finance ', 'Government Services ', 'Health & Long-Term Care ', 'Infrastructure ', 'Labour ', 'Natural Resources ', 'Northern Development & Mines ', 'Office of Francophone Affairs ', 'Office of the Premier ', 'Tourism, Culture & Sport ', 'Training, Colleges & Universities ', 'Transportation ', 'Blind River District Health Centre / Pavillon Santé du District de Blind River', "Englehart & District Hospital Inc. / Hôpital d'Englehart et du District", 'Geraldton District Hospital / Hôpital de district de Geraldton', 'Hotel Dieu Hospital / l’Hôpital Hôtel-Dieu', 'Hôpital de Smooth Rock Falls Hospital', 'Kirkland & District Hospital / Hôpital de Kirkland et du district', 'Leamington District Memorial Hospital / Hôpital memorial du district de Leamington', 'Stevenson Memorial Hospital / Hôpital Stevenson Memorial', "Canton d'Alfred-Plantagenet / Township of Alfred-Plantagenet", 'Killarney Health Centre Board', 'Municipality of Dysart et al', 'Municipality of South Bruce', 'Municipality of South Dundas', 'Municipality of Trent Lakes', 'Town of Saugeen Shores Police Services', 'Town of Smooth Rock Falls', 'Township of Blandford-Blenheim', 'Township of Greater Madawaska', 'Township of Huron-Kinloss', 'Township of Laurentian Valley', 'Township of Manitouwadge', 'Township of North Dundas', 'Township of North Frontenac', 'Township of North Glengarry', 'Township of Selwyn', 'Township of Southwold', '(ACCES) Accessible Community Counselling & Employment Services', 'Agricultural Adaptation Council', 'Anishinaabe Abinoojii Family Services', "Association canadienne d'éducation de langue française", "Association des juristes d'expression française de l'Ontario", 'Association for Workplace Tragedy Family Support (Threads of Life)', 'Bennett Health Care Centre', 'Better Living at Thompson House', 'Bimose Tribal Council Inc.', 'CARE Centre For Internationally Educated Nurses', 'Canadian Red Cross Society / Croix-Rouge canadienne', 'Canadian Reformed Society for a Home for the Aged Inc. o/a Mount Nemo Christian Nursing Home', 'Canadian Safe School Network', 'Carizon Family & Community Services', 'Cassellholme', 'Cataraqui Region Conservation Authority / Office de protection de la nature de la région de Cataraqui', 'Centre des services communautaires de Vanier / Vanier Community Service Centre', 'Centre for Commercialization of Regenerative Medicine', 'Centre for Spanish Speaking Peoples ', 'Centretown Community Health Centre Inc. / Centre de santé communautaire du Centre-Ville', "Child & Community Resources / Resources pour l'enfance et la communauté", "Children's Community Network / Réseau Communautaire Pour Enfants", 'Clinical Trials Ontario', 'College of Traditional Chinese Medicine Practitioners & Acupuncturists of Ontario', 'Colleges Ontario', 'Community & Home Assistance to Seniors', 'Community Legal Education Ontario', 'Coral Communication Enabled Applications Keystone Limited', 'De Dwa Da Dehs Nyes Aboriginal Health Centre', 'Dementia Alliance', 'Downsview Long Term Care Centre', "Eastern Ontario Regional Lab Association / Association des laboratoires régionaux de l'est de l'Ontario ", 'Estonian Relief Committee "Ehatare"', 'FIREFLY - Physical, Emotional, Developmental & Community Services / FIREFLY - Services physique, émotifs, communautaires et pour le développement', "Family & Children's Services of Frontenac, Lennox & Addington / Services à la famille et à l'enfance de Frontenac, Lennox et Addington", 'Fast Track - Community Centre for Skills Development & Training', 'Finlandia Nursing Home Limited', 'Frontenac Community Mental Health & Addiction Services / Services communautaires de santé et de dependances de Frontenac', 'Frontenac Youth Services', 'Good Companions', 'Grand River Agricultural Society', 'HalTech Regional Innovation Centre', 'Hands TheFamilyHelpNetwork.ca / LeReseaudaideauxfamilies.ca', 'Health Nexus Santé', 'Hellenic Home For The Aged Inc.', 'Holland Marsh Drainage System Joint Municipal Services Board', 'Hong Fook Mental Health Association', 'Hope Place Centres', 'Hospice Association Of Ontario', 'Huronia Nurse Practitioner-Led Clinic', 'Institute for Work & Health', 'Interior Finishing Systems Training Centre', "Kerry's Place Autism Services / Services en autisme", 'Keystone Child, Youth & Family Services ', 'Kina Gbezhgomi Child & Family Services', 'Launch lab (Eastern Ontario) ', 'Laurencrest Youth Services Inc. ', 'Lennox & Addington Addiction & Community Health Services Inc.', 'Malton Neighbourhood Services', 'Mamaweswen, The North Shore Tribal Council Secretariat', 'March of Dimes Canada', 'Mathematics of Information Technology & Complex Systems Inc.', 'Middlesex Community Living', 'Moose Cree First Nation', 'Multilingual Community Interpreter Services', 'New Unionville Home Society', 'Noojmowin Teg Health Centre', "North Eastern Ontario Family & Children's Services / Services à la famille et à l'enfance du Nord-Est de l'Ontario", "North West Community Care Access Centre / Centre d'accès aux soins communautaires du Nord-Ouest", 'OCASI - Ontario Council of Agencies Serving Immigrants', 'Ontario Brain Institute / Institut ontarien du cerveau', "Ontario Catholic School Trustees' Association ", 'Ontario Community Support Association', 'Ontario Craft Brewers', 'Ontario Federation of Food Co-operatives & Clubs, Inc.', 'Ontario Federation of School Athletic Associations', 'Ontario Industrial & Finishing Skills Centre', 'Ontario Physical Health & Education Association', 'Ontario Physician Services Inc.', 'Ontario Sailing ', 'Perimeter Institute for Theoretical Physics', 'Project Hostel operating as Yellow Brick House', 'Regional Tourism Organization 7', 'Rideauwood Addiction & Family Services', "Safehaven Project for Community Living / Le Projet Safehaven Pour L'Intégration Communautaire", 'Sandy Hill Community Health Centre, Inc. / Centre de santé communautaire Côte-De-Sable, Inc.', 'Schlegel-UW Research Institute for Aging Foundation', 'Service Coordination for Persons with Special Needs / Coordination des services pour personnes ayant des besoins spéciaux', 'Sheet Metal Workers’ International Association Local Union 285 Training Centre', 'Shepherds of Good Hope', 'Shkagamik-Kwe Health Centre', 'Six Nations of the Grand River', 'Skills / Competences Canada - Ontario', "South East Community Care Access Centre / Centre d'accès aux soins communautaires du Sud-Est", 'South-East Grey Community Health Centre', 'Southwest Ontario Tourism Corporation', 'Student Transportation of Eastern Ontario', 'Surex Community Services', "The Canadian Hearing Society / la Société canadienne de l'ouïe", 'The Corporation of Massey Hall & Roy Thomson Hall', 'TransForm Shared Service Organization', 'Traverse Independence Not-For-Profit', 'Treaty Three Police Services Inc. ', 'Trees Ontario Foundation', 'Ukrainian Canadian Care Centre', 'Ukrainian Home for the Aged', 'Villa Marconi Long Term Care', 'WIL Counselling & Training for Employment', 'Water Technology Acceleration Project', 'Woodbine Entertainment Group', 'Workers Health & Safety Centre Federation of Ontario', 'YOR-SUP-NET Support Services Network', "St. Peter's Seminary", 'Thorneloe University', 'Université Saint-Paul / Saint Paul University', 'Alcohol and Gaming Commission of Ontario', 'Child and Family Services Review Board / Custody Review Board', 'Consent and Capacity Board', 'Education Quality and Accountability Office', "Fire Marshal's Public Safety Council", 'Health Professions Appeal and Review Board', 'HealthForceOntario Marketing and Recruitment Agency', 'Landlord and Tenant Board', 'Nawiinginikiima Forest Management Corporation', 'Public Health Ontario', 'French Language Services Commissioner', 'Information and Privacy Commissioner', 'Office of the Chief Electoral Officer', 'Agriculture, Food and Rural Affairs', 'Citizenship, Immigration and International Trade', 'Comm. Safety and Corr. Services', 'Economic Development, Employment and Infrastructure / Research and Innovation', 'Environment and Climate Change', 'Government and Consumer Services', 'Tourism, Culture and Sport', 'Goderich', 'Board of Health for the Northwestern Health Unit', 'Board of Health for the Porcupine Health Unit', 'Collingwood General and Marine Hospital', 'Englehart and District Hospital Inc.', 'ErinoakKids Centre for Treatment and Development', 'Hotel Dieu Shaver Health and Rehabilitation Centre', 'Hôtel-Dieu Grace Healthcare', 'Lennox and Addington County General Hospital', 'Waypoint Centre for Mental Health Care', 'Winchester District Memorial Hospital and Dundas Manor Long-Term Care Home', 'County of Lennox and Addington', 'Municipality of Marmora and Lake', 'Municipality of Powassan ', 'Municipality of West Perth', 'Town of East Gwillimbury Public Library', 'Town of Grand Valley', 'Town of Hearst ', 'Town of Iroquois Falls', 'Petrolia', 'Town of Plympton-Wyoming', 'Town of Smiths Falls ', 'Township of Chatsworth', 'Township of East Zorra-Tavistock', 'Township of Edwardsburgh / Cardinal', 'Township of Howick ', 'Township of Huron Kinloss', 'Township of Leeds and the Thousand Islands', 'Township of Lucan Biddulph', 'Township of McNab / Braeside', 'Township of North Dumfries', 'Township of Perth South ', 'Township of Scugog ', 'Township of South Stormont', 'Township of Stirling-Rawdon Police Service', 'United Counties of Leeds and Grenville', 'Village de / of Casselman', '(ACCES) Accessible Community Counselling and Employment Services', 'Access Alliance Multicultural Health and Community Services', 'Access Counselling and Family Services', 'Agri-food Management Institute', 'Aisling Discoveries Child and Family Centre', 'Alzheimer Society of Ontario', 'Anago (Non) Residential Resources Inc.', 'Aptus Treatment Centre', 'Association of Family Health Teams of Ontario', 'Benevolent Society Heidehof for the Care of the Aged', 'Better Living Health and Community Services', 'Blue Hills Child and Family Centre', 'Boost Child Abuse Prevention and Intervention', 'Brain Injury Services of Northern Ontario', 'Broadview Foundation o / a Chester Village', 'Bruce Grey Child and Family Services', 'CHOICES Association Inc.', 'Canadian Mental Health Association, Champlain Eas', 'Canadian Mental Health Association, Middlesex', 'Canes Family Health Team', 'Capability Support Services Inc.', 'Carefirst Seniors and Community Services Association', 'Carefor Health and Community Services', 'Carizon Family and Community Services', 'Castle Arms Non-Profit Apartment Corporation', 'Centre De Sante Communautaire CHIGAMIK Community Health Centre', "Centre De Santé Communautaire De L'Estrie", 'Centre de santé Communautaire du Témiskaming', 'Centre des services de développement pour Stormont, Dundas et Glengarry / Stormont, Dundas and Glengarry Developmental Services Centre', 'Centre for Canadian Language Benchmarks', 'Centre for Spanish-Speaking Peoples', 'Centretown Community Health Centre Inc. du Centre-ville', 'Child and Community Resources', "Child and Family Centre, Centre de l'enfant et de la famille, Ngodweaangizwin aaskaagewin", "Children's Aid Society of Stormont, Dundas and Glengarry", "Children's Mental Health of Leeds and Grenville", 'City View Centre for Child and Family Services', 'College of Carpenters and Allied Trades Inc.', 'College of Dietitians of Ontario', 'College of Midwives of Ontario', 'College of Registered Psychotherapists and Registered Mental Health Therapists of Ontario', 'College of Traditional Chinese Medicine and Acupuncturists of Ontario', 'Community Living Haldimand ', 'Community and Home Assistance to Seniors', 'Community and Primary Health Care - Community Family Health Team', 'Corporation of The Council of Ministers of Education, Canada', 'Couchiching Family Health Team', 'Curriculum Services Canada', 'Davenport-Perth Neighbourhood and Community Health Centre', 'De Dwa Da Dehs Nye>s Aboriginal Health Centre', 'Dilico Anishinebek Family Care', 'Doctors Without Borders Canada', 'Dorval Medical Family Health Team ', 'Drs. Paul and John Rekai Centre', 'Earscourt-Creche Child Development Institute', 'Eastern Ontario Regional Lab Association', 'Electricity Human Resources Canada', 'FIREFLY - Physical, Emotional, Developmental and Community Services', 'Fairview Mennonite Home', "Family and Children's Services of Frontenac, Lennox and Addington", 'Farm and Food Care Ontario', 'Fast Track-Community Centre for Skills Development and Training', 'Fernie Youth Service', "Five Counties Children's Centre ", 'Food and Beverage Ontario', 'Fort William First Nation', 'Frontenac Community Mental Health and Addiction Services ', 'Grove Park Home for Senior Citizens', 'Hands TheFamilyHelpNetwork.ca', 'Health Nexus santé', 'Heart and Stroke Foundation of Ontario', 'Hiatus House', 'HopeGreyBruce Mental Health and Addictions Services', 'Hospice Palliative Care Ontario', 'Hospital Diagnostic Imaging Repository', 'Infrastructure Health and Safety Association', 'Institute for Competitiveness and Prosperity', 'Institute for Work and Health', 'Invasive Species Centre', 'Job Skills - Employment and Business Programs and Supports', 'Joint Training and Apprenticeship Committee', 'K3C Counselling Centres / Centres de counseling K3C', 'Keystone Child, Youth and Family Services', 'Kunuwanimano Child and Family Services', 'LIUNA Local 1059 Training Trust Fund', 'Lakeshore Area Multi Purpose Inc.', 'Launch lab (Eastern Ontario) Inc.', 'Learning Partnership', 'Leeds and Greenville Mental Health', "Let's Talk Science / Parlons sciences", 'Local 285 Training Centre', 'Lower Trent Region Conservation Authority', 'Mamaweswen, the North Shore Tribal Council Secretariat', 'Matawa First Nations Management', 'Mathematics of Information Technology and Complex Systems Inc.', 'Misiway Milopemahtesewin Community Health Centre', 'Mount Nemo Christian Nursing Home ', 'Métis Voyageur Development Fund Inc.', 'New Leaf Living and Learning Together Inc.', 'Nickel District Conservation Authority', 'North Centennial Manor Inc.', "North Eastern Ontario Family and Children's Services", 'North West Community Care Access Centre', 'ONE CARE Home and Community Support Services', 'On-Track Career and Employment Services', 'Ontario Aboriginal Housing Support Services', 'Ontario Agri-Food Education Inc.', 'Ontario Bioscience Industry Organization', 'Ontario College Library Service', 'Ontario Construction Secretariat', 'Ontario Council on Articulation and Transfer', 'Ontario Cultural Attractions Fund', 'Ontario Educational Leadership Centre', 'Ontario Federation of Indigenous Friendship Centres', 'Ontario Greenhouse Vegetable Growers', 'Ontario Industrial and Finishing Skills Centre', 'Ontario Physical and Health Education Association', "Ontario Pork Producer's Marketing Board", "Ontario Public School Boards' Association ", 'Ontario Soil and Crop Improvement Association', "PARO Centre for Women's Enterprise / PARO Centre pour l'enterprise des Femmes", 'Payukotayno: James and Hudson Bay Family Services', 'Petawawa Centennial Family Health Centre', 'Philip Aziz Centre for Hospice Care', 'Pinecrest-Queensway Community Health Centre Pinecrest-Queensway', 'Points North Family Health Team', 'Project Hostel o / a Yellow Brick House', 'Provision The Food Industry Sustainability Coalition ', 'Public Services Health and Safety Association ', 'Quality Continuous Improvement Centre for Community Education and Training', 'Radius Child and Youth Services', 'Rapids Family Health Team ', 'Ray of Hope Inc.', 'Regional Tourism Organization 4 Inc ', 'Rise Asset Development', 'Rygiel Supports for Community Living', 'SIM-one Ontario Simulation Network', 'SPRINT Senior Care', 'Sandy Hill Community Health Centre, Inc. Côte-de-sable, Inc.', 'Service Coordination for Persons with Special Needs', 'Six Nations Polytechnic Inc.', 'Skate Canada', 'Smoking and Health Action Foundation', 'South East Grey Community Health Centre', 'South Riverdale community Health Centre', 'Speech and Stuttering Institute', "St. Alban's Boys' and Girls Club", "St. Joseph's Infirmary", "St. Joseph's Villa Dundas owned and operated by St. Joseph's Health System", "St. Leonard's Community Services Inc.", "St. Michael's Homes", "St. Peter's Care Centre", 'Summit Housing and Outreach Programs', 'Swim Ontario', 'The AIDS Network', 'The Bloom Centre for Sustainability', 'The Corporation of Massey Hall and Roy Thomson Hall', 'The George Hull Centre for Children and Families', 'The Haldimand Family Health Team', 'The Neighbourhood Group Community Services', 'Tikinagan Child and Family Services', 'Touchstone Institute', 'Trans Canada Trail ', 'Transitional Council for the College of Homeopaths', 'Treaty Three Polices Services Inc.', 'TriCounty Addictions Program', 'Two Rivers Family Health Team ', 'Unsion Health and Community Services', 'VHA Health and Home Support', 'Valley Manor Inc.', "Variety Village / Variety - The Children's Charity (Ontario)", 'Victoria Village Inc.', 'Victorian Order of Nurses Canada', 'Villa Colombo Homes For the Aged', 'Vineland Research and Innovation Centre Inc.', "Waasegiizhig Nanaandawe'iyewigamig", 'Wabano Centre for Aboriginal Health', 'WellFort Community Health Services', 'White Ribbon Foundation', 'Woodgreen Community Services', 'Workers Health and Safety Centre Federation of Ontario', 'Workplace Safety and Prevention Services', 'YMCA-YWCA of the National Capital Region', 'Zone 6 Regional Tourism Organization', 'Algonquin and Lakeshore Catholic District School Board', 'Conseil scolaire catholique Providence', 'Saint Paul University / Université Saint-Paul', 'Fire Marshal’s Public Fire Safety Council', 'Ring of Fire Infrastructure Development Corporation', 'The Ontario French Language Educational Communications Authority', 'Financial Accountability Officer', 'Citizenship, Immigration & International Trade', 'Economic Development, Employment & Infrastructure/Research & Innovation', 'Environment & Climate Change', 'Natural Resources & Forestry', 'Leamington District Memorial Hospital / Hôpital Memorial du District de Leamington', 'Municipality Of Kincardine', 'Municipality of Bayham', 'Municipality of Marmora & Lake', 'Municipality of Mississippi Mills', 'Municipality of Powassan', 'The Nation Municipality/Municipalité de La Nation', 'Town of Tecumesh', 'Township of Alfred & Plantagenet', 'Township of Alnwick/Haldimand', 'Township of Black River-Matheson', 'Township of Horton', 'Township of Howick', 'Township of Leeds & the Thousand Islands', 'Village de/of Casselman', 'Village of Westport', '360Kids Support Services', 'Access for Parents and Children in Ontario', 'Addiction and Mental Health Service-KFLA/Services de lutte contre les dependances et de sante mentale-KFLA', 'Akausivik Inuit Family Health Team', 'Algonquin Opportunity (No.2) Corporation', "Association des conseils scolaires des écoles publiques de l'Ontario", 'Ausable Bayfield Conservation Authority', 'Banyan', 'Beamsville Medical Centre Family Health Team', 'Benevolent Society Heidehof', 'Bernadette McCann House for Women Inc.', 'Boost Child & Youth Advocacy Centre', 'Bridgepoint Family Health Team', 'Broadview Foundation O/A Chester Village', 'Brotherhood Foundation', 'COU Holding Association Inc.', 'Canadian Mental Health Association - Champlain Eas', 'Catulpa Community Support Services Inc.', "Centre D'Accueil Roger Seguin", 'Centre De Santé Communautaire Chigamik Community Health Centre', 'Centre des services communautaires Vanier / Vanier Community Service Centre', 'Centre des services de développement S.D. & G. Developmental Services Centre', 'Centre franco-ontarien des ressources pédagogiques', 'Champlain Health Supply Services', 'Child & Community Resources', "Children's Aid Society Of Stormont, Dundas & Glengarry", "Children's Community Network / Réseau communautaire pour enfants", 'Chimo Youth and Family Services Inc.', 'City View Centre for Child & Family Services', 'College of Carpenters & Allied Trades Inc.', 'Community & Primary Health Care - Community Family Health Team', 'Community Living Glengarry Inc. - Intégration communautaire Glengarry Inc.', 'Community Living Lennox & Addington', 'Corporation of the Council of Ministers of Education, Canada', 'Crest Support Services (Meadowcrest) Inc.', 'De dwa da dehs nye>s Aboriginal Health Centre', 'Dnaagdawenmag Binoojiiyag Child & Family Services', "Dr. Roz's Healing Place", 'Dunara Homes for Recovery Inc.', 'E3 Community Services Inc', 'Eastern Ontario Regional Laboratory Association', 'Estonian Relief Committee in Canada', 'Fernie Youth Services', 'Firefly - Physical, Emotional, Developmental and Community Services / Firefly - Services physiques, émotifs, communautaires et pour le développement', 'Forests Ontario', 'Gambling Research Exchange Ontario', "George Jeffrey Children's Centre", 'Gizhewaadiziwin Health Access Centre', 'Hands TheFamilyHelpNetwork.ca/LeReseaudaideauxfamilies.ca', 'Harrow Health Centre', 'Health Nexus', 'HeartHouse Hospice Inc', 'Huron Lodge Community Service Board Inc.', "Huron-Perth Children's Aid Society", 'Huronia Nurse Practitioner–Led Clinic', 'IISD Experimental Lakes Area Inc.', 'Indspire', 'Institute For Safe Medication Practices Canada', 'Institute for Competitiveness & Prosperity', 'Interim Place', 'International Association Of Heat & Frost Insulators And Allied Workers Local 95', 'International Union Of Operating Engineers Local 793 Training Fund', 'Interval House', 'Joint Training & Apprenticeship Committee Refrigeration Workers Local 787 Orac Training Fund', 'KW Habilitation Services', 'Keewaytinook Okimakanak Northern Chiefs Council', 'Keewaytinook Okimakanak/Northern Chiefs Council', 'Killarney Health Centre', 'Kina Gbezhgomi Child and Family Services', 'Kristus Darzs Latvian Home', "L'Association franco-ontarienne des conseils scolaire catholiques", 'Lac Seul Police Service', 'Lac des Mille Lacs First Nation', 'Laidlaw Foundation', 'Lakeland Long Term Care Services Corporation', 'Lakeshore Area Multi Purpose Inc. (LAMP Inc.)', "Le Centre de Santé Communautaire de l'Estrie Ontario", 'Lower Outaouis Family Health Team / Equipe de Sante Familiale du Bas Outaouis', 'Maamwesying North Shore Community Health Services', 'Madawaska Valley Association for Community Living', 'Maison Vale Hospice', 'Mariann Home', 'Mary Berglund Community Health Centre Hub', 'Mill Creek Care Centre', 'Mills Community Support Corporation Inc.', 'Monarch Recovery Services/services de retablissement', 'Multilingual Community Interpreter Services / Services d’interprétation communautaire multilingues', 'Murray McKinnon Foundation', 'Métis Voyageur Development Fund Incorporated', 'Noojmowin-Teg Health Centre', 'North of Superior Counseling Programs', 'Northern Ontario Regional Tourism Organization (13)', 'Northern Youth Services Inc./Services à la Jeunesse du Nord Inc.', "OCSTA Ontario Catholic School Trustees' Association", 'Ontario Agri-Food Education Inc', 'Ontario Association Of Adult And Continuing Education Schoolboard Administrators', "Ontario Association of Children's Aid Societies/ Association des sociétés d'aide à l'enfance de l'Ontario", 'Ontario Brain Institute/Institut Ontarien Du Cerveau', "Ontario Catholic Supervisory Officers' Association", 'Ontario Council of Agencies Serving Immigrants', "Ontario Cultural Attractions Fund / le fonds pour les manifestations culturelles de l'ontario", 'Ontario Federation of Snowmobile Clubs', 'Ontario Physician Services Inc', "Ontario Public School Boards' Association", 'Ontario Society For the Prevention of Cruelty to Animals', 'Ontario Tennis Association', 'Ontario Éducation Collaborative Marketplace', 'Ontrack Career and Employment Services Inc.', 'Orléans - Cumberland Community Resource Centre', "PARO Centre for Women's Enterprise / PARO Centre pour L'enterprise des Femmes", "Pathway's For Children & Youth", 'Perimeter Institute', 'Prosper Canada', 'Provision The Food Industry Sustainability Coalition', 'Public Services Health and Safety Association', 'Rapids Family Health Team', 'Reconnect Community Health Services', 'Regional Tourism Office Four', 'Roots Of Empathy', 'SMWIA Local Union 285 Training Trust Fund', 'Sandy Hill Community Health Centre, Inc.', 'Sauble Family Health Team', 'Service Coordination for Persons with Special Needs / Coordination des Services pour personnes ayant des desoins spéciaux', 'Shad Valley international', 'Shalom Village', 'Shepherd Village', 'Six Nations Of The Grand River', "St. Joseph's At Fleming", 'The Centre for Skills Development & Training', "The Governing Council of the Salvation Army / Conseil de direction de l'Armee du Salut", 'The Massey Centre for Woman', 'The Otonabee Region Conservation Authority', 'The Phoenix Centre For Children and Families', 'The Rekai Centres', 'Transitional Council of The College of Registered Psychotherapists & Registered Mental Health Therapists of Ontario', 'Treaty Three Police Services Inc.', 'Trent Hills Family Health Team', 'Tropicana Community Services', 'Unison Health and Community Services', 'United Association 67 Technical Trades Academy Inc', 'United Mennonite Home for the Aged', "Variety Village / Variety The Children's Charity", 'Victoria Village Inc', 'Victorian Order Of Nurses (Canada)', 'Villa Marconi Long-Term Care', 'Vineland Research and Innovation Centre', "Vision '74 Inc.", 'WAYS Mental Health Support / WAYS soutien en santé mentale', "Waasegiizhig Nanaandawe'Iyewigamig", 'Wee chi-it-the-win Family Services Inc.', 'Wine Marketing Association of Ontario', 'YOR-SUP-NET Support Service Network', "Youturn Youth Support Services / Services d'appui a la jeunesse", 'The Protestant Separate School Board', 'Saint Paul University', "St. Jerome's University", 'AgriCorp / Agricorp', 'Animal Care Review Board', 'Automobile Accident Benefits Service', "Fire Marshal's Public Safety Council", 'Fire Safety Commission', 'Motherisk Commission', 'Nawiinginokiima Forest Management Corporation', 'Office for Victims of Crime', 'Ontario Agency for Health Protection and Promotion', 'Safety, Licensing Appeals and Standards Tribunals Ontario / Animal Care Review Board / Fire Safety Commission / Licence Appeal Tribunal / Ontario Civilian Police Commission / Ontario Parole Board', 'Social Benefits Tribuna', 'Advanced Education and Skills Development', 'Community and Social Services / Services sociaux et communautaires', 'Economic Development and Growth / Research, Innovation and Science', 'Housing / Logement', 'Indigenous Relations and Reconciliation', 'International Trade', 'Municipal Affairs', 'Headwater Health Care Centre', 'North Shore Health Network', 'North of Superior Healthcare Group', 'The Alexandra Hospital, Ingersoll', 'lennox and Addington County General Hospital', 'Municipality of French River', 'Municipality of Highlands East', 'Municipality of Shuniah', 'Tay Valley Township', 'Town of Espanola - Police Service Board', 'Township of Alfred and Plantagenet', 'Township of Armour', 'Township of Black River-Matheson / Canton de Black River-Matheson', 'Township of Carling', 'Township of Elizabethtown-Kitley', 'Township of McNab/Braeside', 'Township of North Stormont', 'Township of Perth South', 'Township of Southgate', 'Accommodation Information and Support Inc.', 'Addiction and Mental Health Service-KFLA', 'Addictions and Mental Health Ontario', 'Affiliated Services for Children and Youth', 'Algonquin Opportunity (No. 2) Corporation', 'Alternative Land Use Services Canada Inc.', 'Andrew Fleck Child Care Services', 'Asbestos Workers Local 95 Training Centre', 'Association Franco-Ontarienne Des Conseils Scolaire Catholiques', 'Barbra Schlifer Comemorative Clinic (BSCC)', "Barry's Bay and Area Senior Citizens Home Support Services", 'Beausoleil First Nation', 'Boost Child and Youth Advocacy Centre', 'BridgeWay Family Centre', 'Broadview Foundation', 'Canadian Centre for Victims of Torture', 'Canadian Council for Aboriginal Business', 'Canadian Elevator Industry Educational Program (Ceiep)', 'Canadian Film In The Schools (Reel Canada)', "Canadian Hearing Society / Société canadienne de l'ouïe", 'Canadian International Military Games Corporation', 'Canadian Mental Health Association - Champlain East', 'Capacity Canada', 'Capreol Nurse Practitioner Led Clinic', 'Cedar Centre', 'Centre Franco-Ontarien Des Ressources Pédagogiques', 'Centre des services de développement S. D and G. Developmental Services Centre', 'Centre for Effective Practice', 'Child and Family Centre, Ngodweaangizwin aaskaagewin', 'Chimo Youth and Family Services', 'City View Centre For Child and Family Services', 'City of Lakes Family Health Team', 'Communitech', 'Community Living Glengarry Inc', 'Community Living Lennox and Addington', 'Corporation Of The Council Of Ministers Of Education, Canada', 'Creighton Youth Services', 'Dale Brain Injury Services Incorporated', 'Davenport-Perth Neighbourhood And Community Health Center', "De Dwa Da Dehs Nye's Aboriginal Health Centre", 'Dnaagdawenmag Binnoojiiyag Child and Family Services', 'Egale Canada Human Rights Trust', "Ernestine's Women's Shelter", 'FIREFLY – Physical, Emotional, Developmental and Community Services', 'Fairhaven Home For Senior Citizens', 'Fairview Mennonite Homes', 'First Nations Technical Institute', 'First Robotics Canada', 'Five Counties Children’s Centre', 'Forest Ontario', 'Fort William Family Health Team Inc.', 'Four Counties Addiction Services Team Incorporated', 'Glengarry Nurse Practitioner Led Clinic', 'Good Companions Seniors Centre', 'Haltech Regional Innovation Centre', 'Harmony Centre for Community Living', 'Hearst Kap S-R-F Counselling Services', 'Hearthouse Hospice Incorporated', 'Hellenic Home For The Aged Incorporated', 'Hong Fook Connecting Health Nurse Practitioner-Led Clinic', 'Hopegreybruce Mental Health And Addictions Services', "Hopewell Children's Homes Inc.", 'Immigrant Access Fund Of Canada Inc.', 'Indus Community Services', 'Ingersoll Nurse Practitioner-Led Clinic', 'Inner City Family Health Team', 'Institute For Clinical Evaluative Sciences', 'International Association of Bridge, Structural, Ornamental and Reinforcing Irownworkers Local 700', 'Ioof Seniors Homes Incorporated', 'Joint Training and Apprenticeship Committee Refrigeration Workers Local 787 Orac Training Fund', 'LIUNA Local 506 Training Centre', "Labourers' Local 183 Members Training and Rehabilitation Fund", "Labourers' Local 625 Training Trust", 'Lac Des Milles Lacs First Nation', 'Launch Lab', "Le Reseau De Developpement Economique Et D'Employabilite De L'Ontario (Rdee-Ontario)", 'Leamington Area Family Health Team', 'Leeds and Grenville Community Family Health Team', 'Loft Community Services', 'Lumacare Services', 'MaRS Innovation', 'Maamweysing North Shore Community Health Services Incorporated', 'Madison Community Services', 'Maple Family Health Team Incorporated', 'March Of Dimes Canada', 'Marianhill Incorporated', 'Mariann Nursing Home and Residence', 'Metis Voyageur Development Fund Inc.', 'Mining Innovation Rehab and Applied Research Corp', 'Minto-Mapleton Family Health Team', 'Mohawk Council Of Akwesasne', 'Monarch Recovery Services', 'Multilingual Community Interpreter Services (MCIS)', "Municipal Finance Officers' Association of Ontario", 'New Vision Family Health Team', 'North Simcoe Family Health Team', 'North of Superior Community Mental Health\xa0Program Corporation', 'Northern Ontario Regional Tourism Organization (RTO) 13', 'Northern Youth Services Inc. / Services à la Jeunesse du Nord Inc.', 'OCASI-Ontario Council of Agencies Serving Immigrants', 'OPTIONS Northwest Personal Support Services', 'Ojibways of Onigaming', 'On-Track Career and Employment Services Inc.', 'One Care Home and Community Support Services', 'Ontario Agri Food Technologies', 'Ontario Association Of Community Care Access Centres', 'Ontario Association of Continuing Education School Board Administrators (CESBA)', 'Ontario Association of Social Workers', 'Ontario Basketball Association', "Ontario Catholic School Trustees' Association (OCSTA)", 'Ontario Council On Articulation and Transfer', 'Ontario Municipal Social Services Association', 'Ontario Online Learning Consortium', 'Ontario Sheep Marketing Agency', 'Osstf/Feeso Provincial Health Benefit Plan Corporation', 'Pace Independent Living', 'Parkwood Mennonite Homes Incorporated', "Pathway's For Children and Youth", 'Pediatric Oncology of Ontario', 'Philip Aziz Centre For Hospice Care', 'Physicians Services’ Incorporated Foundation', 'Progress Place', 'Provision the Food Industry Sustainability Coalition', 'Quality Continuous Improvement Centre For Community Education and Training', 'Region 9 Regional Tourism Organization', 'Regional Tourism Organization Four Inc.', 'Rosaleen Rubino Physiotherapy Professional Corporation', 'Service Coordination for Persons with Special Needs / Coordination des Services pour personnes ayant des desoins speciaux', 'Shalom Village Home For the Aged', 'Skylark Children, Youth and Families', 'Smwia Local Union 285 Training Trust Fund', 'Social Research and Demonstration Corporation (SRDC)', 'South West Centre For Community Program Development', 'Spark Commercialization and Innovation Centre', "St. Alban's Boys' and Girls' Club", "St. Joseph's Lifecare Centre", 'Sunbeam Centre', 'Thamesview Family Health Team', 'The Canadian National Institute for the Blind', 'The Canadian Red Cross', 'The Cedarbrook Society', 'The Centre for Family Medicine Family Health Team', 'The Centre for Spanish-Speaking Peoples', 'The Learning Enrichment Foundation', 'The Learning Partnership', 'The Ontario Finnish Resthome Association', 'The St. Christopher House', 'The Yonge Street Mission', 'Thorncliffe Neighbourhood office', 'Thresholds Homes and Supports Inc.', 'Township Of Osgoode Care Centre', 'Trillium Network for Advanced Manufacturing', 'Twin Bridges Nurse Practitioner-Led Clinic', 'UA Local 67/MCA Zone 8/9/9A Apprenticeship Committee.', 'Upper Thames Conservation Authority', 'VHA Health and Home Support/soins et soutien a domicile', 'Vanier Community Services Centre', 'Victorian Order of Nurses Canada (VON)', 'Villa Marconi', 'Ways Mental Health Support', 'Weechi-it-te-win Family Services Inc.', 'Wesley Urban Ministries', 'Wesway Incorporated', 'White Ribbon', "Women's Health In Women's Hands Community Health Centre", 'Woodview Mental Health and Autism Services', 'Workers Health and Safety Centre Federation Of Ontario', 'YOR-SUP-NET Supportive Service Network', 'Youth Employment Services Yes', 'Youth Opportunities Unlimited', 'Youturn Youth Support Services', 'ventureLAB Innovation Centre', 'Conseil Scolaire Catholique Providence', 'Conseil des écoles catholiques du Centre Sud-Ouest', 'Conseil scolaire catholique de l’Est ontarien', 'Superior Greenstone Disctrict School Board', 'Agricorp / Agricorp', 'Alcohol And Gaming Commission of Ontario / Commission Des Alcools Et Des Jeux De L’Ontario', "Automobile Accident Benefits Service / Service d'aide relative aux indemnités d'accident automobile", "Child and Family Services Review Board/Custody Review Board / Commission de révision des services à l'enfance et à la famille/Commission de révision des placements sous garde", 'Consent and Capacity Board / Commission du Consentement et de la Capacité', 'Conservation Review Board / Commission des biens culturels', "Criminal Injuries Compensation Board / Commission d'indemnisation des victimes d'actes criminels", "Deposit Insurance Corporation of Ontario / La Société Ontarienne D'Assurance-Dépôts", 'Education Quality and Accountability Office / Office de la qualité et de la responsabilité en éducation', 'Health Boards Secretariat / Secrétariat des conseils de santé', 'Health Shared Services Ontario (Hssontario) / Services Communs Pour La Santé Ontario', 'Healthforceontario Marketing And Recruitment Agency / Agence De Promotion Et De Recrutement De Professionssantéontario', "Higher Education Quality Council of Ontario / Conseil Ontarien de la Qualité De L'Enseignement Supérieur?", "Human Rights Legal Support Centre / Centre D'Assistance Juridique En Matière De Droits de la Personne", 'Judicial Appointments Advisory Committee/Comité consultatif sur les nominations à la magistrature', 'Justices of the Peace Appointments Advisory Committee / Comité consultatif sur la nomination des juges de paix', 'Landlord and Tenant Board / Commission de la location immobilière', "Local Health Integration Network - Central / Réseau Local D'Intégration Des Services De Santé - Centre", "Local Health Integration Network - Central East / Réseau Local D'Intégration Des Services De Santé - Centre-Est", "Local Health Integration Network - Central West / Réseau Local D'Intégration Des Services De Santé - Centre-Ouest", "Local Health Integration Network - Champlain / Réseau Local D'Intégration Des Services De Santé De Champlain", "Local Health Integration Network - North East / Réseau Local D'Intégration Des Services De Santé - Nord-Est", "Local Health Integration Network - North West Ontario / Réseau Local D'Intégration Des Services De Santé Du Nord-Ouest", "Local Health Integration Network - South East / Réseau Local D'Intégration Des Services De Santé - Sud-Est", "Local Health Integration Network - South West / Réseau Local D'Intégration Des Services De Santé - Sud-Ouest", 'Mcmichael Canadian Art Collection / Collection Mcmichael D’Art Canadien', 'Motherisk Commission / Commission Motherisk', 'Nawiinginokiima Forest Management Corporation / Société De Gestion Forestière Nawiinginokiima', "Northern Ontario Heritage Fund Corporation / Société de gestion du Fonds du patrimoine du Nord de l'Ontario ", "Office of the Conflict of Interest Commissioner / Bureau du commissaire aux conflits d'intérêts", 'Office of the Fairness Commissioner / Bureau du commissaire à l’équité', 'Ontario Agency For Health Protection And Promotion / Agence Ontarienne De Protection Et De Promotion de la Santé', 'Ontario Arts Council / Conseil Des Arts De L’Ontario', 'Ontario Farm Products Marketing Commission / Commission ontarienne de commercialisation des produits agricoles', "Ontario Food Terminal Board / Commission Du Marché Des Produits Alimentaires De L'Ontario\xa0", 'Ontario Health Quality Council (Health Quality Ontario) / Qualité Des Services De Santé Ontario', 'Ontario Human Rights Commission / Commission ontarienne des droits de la personne ', 'Ontario Review Board / Commission ontarienne d’examen', "Ring of Fire Infrastructure Development Corporation / Société de développement de l'infrastructure du Cercle de feu", 'Safety, Licensing Appeals and Standards Tribunals Ontario / Animal Care Review Board /Fire Safety Commission / Licence Appeal Tribunal/Ontario Civilian Police Commission / Ontario Parole Board/Tribunaux de la sécurité, des appels en matière de permis et des normes Ontario / Commission d’étude des soins aux animaux / Commission de la sécurité-incendie / Tribunal d’appel en matière de permis / Commission civile de l’Ontario sur la police / Commission ntarienne des libérations conditionnelles', "The Ontario French Language Educational Communications Authority / Office Des Télécommunications Éducatives De Langue Française De L'Ontario", 'Trillium Gift of Life Network / Réseau Trillium Pour Le Don De Vie', "Walkerton Clean Water Centre / Centre De Walkerton Pour L\x92'Assainissement De L\x92'Eau", "Workplace Safety And Insurance Appeals Tribunal / Tribunal D'Appel de la Sécurité Professionnelle Et De L'Assurance Contre Les Accidents Du Travail\xa0", 'Financial Accountability Officer / Directeur de la responsabilité financière', 'French Language Services Commissioner / Commissaire aux services en français', "Information and Privacy Commissioner / Commissaire à l'information et à la protection de la vie privée", "Integrity Commissioner / Commissaire à l'intégrité ", "Office of the Auditor General/Bureau de la vérificatrice générale de l'Ontario", 'Office of the Chief Electoral Officer / Bureau du directeur général des élections', "Provincial Advocate / Bureau de l'intervenant provincial ", "Accessibility Directorate of Ontario / Direction générale de l'accessibilité pour l'Ontario", 'Advanced Education and Skills Development / Enseignement supérieur et de la Formation professionnelle', 'Agriculture, Food and Rural Affairs / Agriculture, Alimentation\xa0et\xa0Affaires rurales', 'Children and Youth Services / Services à l’enfance et à la jeunesse', 'Citizenship and Immigration / Affaires civiques et Immigration', 'Community Safety And Correctional Services', 'Community Safety and Correctional Services / Sécurité communautaire et Services correctionnels', 'Environment and Climate Change / Environnement et Action en matière de changement', 'Francophone Affairs / Affaires francophones', 'Health and Long-Term Care / Santé et Soins de longue durée', 'Indigenous Relations and Reconciliation / Relations avec les Autochtones et de la Réconciliation', 'International Trade / Commerce international', 'International Trade / Commerce international ', 'Ministry Of Infrastructure', 'Ministry Of Municipal Affairs', "Ministry of Economic Development and Growth/Ministry of Research, Innovation and Science / Ministère du Développement économique et de la Croissance / Ministère de la Recherche, de l'Innovation et des Sciences", 'Ministry of Government and Consumer Services / Ministère des Services gouvernementaux et des Services aux consommateurs', 'Ministry of Housing / Ministère du Logement', "Ministry of Infrastructure / ministère de l'Infrastructure", 'Ministry of Labour / Ministère du Travail', 'Ministry of Municipal Affairs / Ministère des Affaires municipales ', 'Northern Development and Mines / Développement du Nord et des Mines', 'Office of the Premier / Cabinet de la Première ministre', 'Ontario Court Of Justice', 'Seniors Affairs / Affaires des personnes âgées ', 'Status of Women / Condition féminine', 'Tourism, Culture and Sport / Tourisme, Culture et Sport', 'Board of Health For The Northwestern Health Unit', 'Board of Health For The Porcupine Health Unit', 'Casey House', 'Englehart And District Hospital', 'Erie Shores Healthcare', 'Erinoakkids Centre For Treatment And Development', 'Kirkland And District Hospital', 'Lennox And Addington County General Hospital', 'North Shore Health Network Reseau Sante Rive Nord', 'Religious Hospitallers of St Joseph of The Hotel Dieu of St Catharines', 'Services De Santé De Chapleau Health Services', 'Smooth Rock Falls Hospital / Hôpital De Smooth Rock Falls Hospital', 'Waypoint Centre For Mental Health Care', 'County of Lennox And Addington', 'Municipality of Dysart Et Al', 'Municipality of Mcdougall', 'Town of Kearney', 'Town of Plympton–Wyoming', 'Township of Alfred And Plantagenet', 'Township of Amaranth', 'Township of Asphodel–Norwood', 'Township of Black River-Matheson / Canton De Black River-Matheson', 'Township of Bonnechere Valley', 'Township of Killaloe, Hagarty And Richards', 'Township of Leeds And The Thousand Islands', 'Township of Mckellar', 'Township of Mcnab/Braeside', 'Township of North Algona Wilberforce', 'Township of Otonabee–South Monaghan', 'United Counties of Leeds And Grenville', 'United Counties of Stormont, Dundas And Glengarry', 'Village of Merrickville–Wolford', 'Abilities Centre', 'Ableliving Services Inc', 'Access Alliance Multicultural Health And Community Services', 'Access Community Services Incorporated', 'Access Independent Living Services', 'Accessible Community Counselling And Employment Services (Acces)', 'Acclaim Health And Community Care Services', 'Accommodation Info & Support Inc', 'Addiction And Mental Health Services - Kfla', 'Addictions And Mental Health Ontario', 'Affiliated Services For Children and Youth Inc', 'Agricultural Adaptation Council (Aac)', 'Algonquin Opportunity (No 2) Corporation', 'Anago (Non) Residential Resources Inc', 'Animakee Wa Zhing 37', "Association Des Conseils Scolaires Des Ecoles Publiques De L'Ontario", 'Association of Family Health Teams of Ontario (Afhto)', 'Association of Native Child and Family Services Agencies of Ontario', 'Association of Workplace Tragedy/Threads of Life', 'Athens District Famly Health Team', 'Autism Ontario', 'Bernard Betel Centre For Creative Living', 'Better Living Health And Community Services', 'Bimose Tribal Council Inc', 'Bloom Centre For Sustainability', 'Blue Water Rest Home', 'Bridgeway Family Centre', 'Bruce Grey Child And Family Services', 'Canadian Aids Treatment Information Exchange', 'Canadian Blood Agency', "Canadian Hearing Society-La Societe Canadienne De L'Ouie", 'Canadian Institute For Advanced Research', 'Canadian Mental Health Association Middlesex', 'Canadian National Institute For The Blind (Cnib)', 'Canadian Red Cross Society/La Societe Canadienne de la Croix-Rouge', 'Canadian Wheelchair Basketball Association', 'Canes Community Care', 'Capability Support Services Inc', 'Capreol Nurse Pracititioner Led Clinic', 'Carefirst Seniors And Community Services Association', 'Carefor Health And Community Services', 'Carizon Family And Community Services', "Catholic Children's Aid Society", 'Catulpa Community Support Services Inc', 'Causeway Work Centre', 'Centennial Infant and Child Centre (For Children With Special Needs)', 'Central Canadian District Chirstian and Missionary Alliance - Cama Woodlands', 'Centre De Sante Communautaire Chigamik Chc Inc', "Centre De Sante Communautaire De L'Estrie Ontario", 'Centre Des Services Communautaires De Vanier/Vanier Community Service Centre', 'Centre Des Services De Developpement Pour Stormont Dundas Et Glengarry (S D and G Developmental Services Centre)', 'Centre For Canadian Language Benchmarks', 'Centre For Effective Practice', 'Centre For International Governance Innovation', 'Centre For Spanish Speaking Peoples', 'Centre For Surgical Invention And Innovation', 'Centre Franco-Ontarien De Ressources Pedagogiques', 'Centretown Community Health Centre', 'Cheshire Homes', "Child And Family Centre, Centre De L'Enfant Et La Famille Ngodweaangizwin Aaskaagewin", "Children's Aid Society of The United Counties of Stormont Dundas and Glengarry", "Children's Community Network/Reseau Communautaire Pour Enfants", "Children's Mental Health of Leeds And Grenville", 'Chimo Youth and Family Services Inc', 'Chippewas Of Rama First Nation', 'Choices', 'Clarence- Rockland Family Health Team Inc/Equipe De Sante Familiale Clarence-Rockland Inc', 'College of Carpenters And Allied Trades Inc', 'Community Home Assistance To Seniors', 'Community Living St Catharines', 'Community Living Trent Highlands', 'Community Support Connections-Meals On Wheels and More', "Connexion Family Health Team- L'Equipe De Sante Familiale Connexion", 'Contact North', 'Copernicus Lodge Inc', 'Corhealth Ontario', 'Corporation of Massey Hall and Roy Thompson Hall', 'Costi Immigrant Services', 'Cota Health', 'Cottage Country Family Health Team', 'Couchichng Family Health Team', 'Craigwiel Gardens Inc', 'Crest Support Services (Meadowcrest) Inc', 'Culinary Tourism Alliance', 'Dale Brain Injury Services Inc', 'Davenport-Perth Neighbourhood And Community Health Centre', 'David Smith Youth Treatment Centre', 'Deafblind Ontario Services', 'Design Exchange', 'Developmental Services of Leeds And Grenville', 'Dnaagdawenmag Binnoojiiyag Child And Family Services', 'Dorothy Ley Hospice Inc', "Dr Roz's Healing Place", 'Ducks Unlimited Canada', 'Dunara Homes For Recovery Inc', 'E3 (Educate Enable Empower) Community Services Inc', 'Earlscourt - Creche Child Development Institute', 'East Gta Family Health Team', 'Eastern Ontario Regional Laboratory Association (Eorla)', 'Emery-Keelesdale Nplc Inc', 'Englehart And District Family Health Team', 'Environmental Defence Canada Inc', 'Estonian Relief Committee In Canada', 'F J Davey Home', "Family And Children's Services of Frontenac Lennox And Addington", 'Family Service Ontario', 'Fast Track Community Centre For Skills Development and Training', 'Fields Institute For Research In Math Sciences', 'Fife House Foundation', 'Firefly (Physical Emotional Developmental And Community Services)', 'Flowers Canada (Ontario) Inc', 'Fort Frances Community Clinic Inc', 'Fort William Family Health Team Inc', 'Four Counties Addiction Services Team Inc', 'French River Nurse Pracititioner Led Clinic', 'Geneva Centre For Autism', 'George Hull Centre For Children and Families', 'Glebe Centre Inc', 'Glen Hill Terrace Christian Homes Inc', 'Glengarry Nurse Pracititioner Led Clinic', 'Governing Council of The Salvation Army In Canada', 'Great Northern Family Health Team', 'Greenbelt Family Health Team', 'Greencentre Canada', 'Greenstone Family Health Team', 'Grove Park Home For Senior Citizens Inc', 'Hands Thefamilyhelpnetwork.Ca', 'Hanover Family Health Team', 'Harbourview Family Health Team', 'Health Zone Nurse Practitioner-Led Clinic', 'Hearst Kap S-R-F Counselling Services/Services De Counselling De Hearst Kap S-R-F', 'Hearthouse Hospice Inc', 'Heidehof Home For The Aged', 'Hellenic Home For The Aged Inc', 'Hf Connecting Health Nurse Practitioner-Led Clinic', 'Hiv & Aids Legal Clinic (Ontario)', 'Holland Christian Homes Inc', 'Huronia Nurse Pracititioner Led Clinic', 'Ices (Institute For Clinical Evaluative Sciences)', 'Iisd Experimental Lakes Area Inc', 'Immigrant Access Fund of Canada', "Independent Electricity System Operator / Opérateur Indépendant De Réseau D'Électricité", 'Indwell Community Homes', 'Infrastructure Health And Safety Association', 'Institute For Competitiveness And Prosperity', 'Institute For Work and Health', 'International Association of Bridge Structural And Ornamental Iron Workers', 'International Union of Operating Engineers', 'Invasive Species Centre (Isc)', 'Ioof Seniors Homes Inc', 'Iroquois Falls Family Health Team', 'Job Skills - Employment And Business Programs And Supports', 'Jobstart', 'Kenjgewin Teg Educational Institute', 'Keystone Child Youth and Family Services', 'Kidsability Centre For Child Development', 'Kina Gbezhgomi Child And Family Services', 'Kincardine Family Health Team', "King's Daughters Dinner Wagon", 'Kirkland District Family Health Team', "La Corporation Du Conseil Des Ministres De L'Education Canada (Cmec)", 'Labourers International Union of North America Local 1059 Training Fund Management Inc (Liuna)', 'Labourers Local 625 Training Trust', 'Lac Seul Police Services Board Corp.', 'Lake Ridge Community Support Srvc', 'Lakelands Family Health Team', 'Lakeshore Area Multi-Services Project Inc (Lamp)', 'Launch Lab (Eastern Ontario) Inc', 'Leamington And Area Family Health Team', 'Leeds & Grenville Community Family Health Team', "Les Centres D'Accueil Heritage", 'Lower Outaouis Family Health Team/Equipe De Sante Familiale Du Bas Outaouis', 'Loyalist Family Health Team', "Maison D'Amitie", 'Maltby Centre', 'Manitowaning Medical Clinc Board', 'Markhaven Incorporated', 'Mars Innovation', 'Mars Investment Accelerator Fund Inc', 'Massey Centre For Women', 'Mathematics of Information Technology And Complex Systems (Mitacs) Inc', 'Mccormick Home', 'Medecins Sans Frontieres/Doctors Without Borders(Msf Canada)', 'Mental Health Program Services', 'Metis Nation of Ontario Secretariat', 'Metis Voyageur Development Fund Inc', 'Montfort Renaissance Inc', 'Mount Forest Family Health Team Inc', 'Multilingual Community Interpreter Services (Mcis)', 'Municipal Finance Officers Association', 'Murray Mckinnon Foundation', 'Neighbourhood Group Community Services', 'New Leaf Living and Learning Together Inc', 'Next Canada', 'Nog-Da-Win-Da-Min Family And Community Services', 'North Centennial Manor Inc', 'North Channel Nurse Pracititioner Led Clinic', "North Eastern Ontario Family And Children's Services/Services A La Famille Et A L'Enfance Du Nord-Est De L'Ontario", 'North Perth Family Health Team', 'North Shore Family Health Team', 'North of Superior Programs', 'Northern Ontario Regional Tourism Organization (Rto) 13', 'Oasw (Ontario Association of Social Workers)', 'Ocasi-Ontario Council of Agencies Serving Immigrants', 'Occupational Health Clinics For Ontario Workers Inc', 'Oecm (Ontario Education Collaborative Marketplace)', 'Ojibways of Onigaming First Nation', 'On Track Career And Employment Services Inc', 'One Care Home And Community Support Services', "One Kids Place Children's Medical Treatment Centre of North East Ontario", "Ontario Association of Children's Aid Societies (Oacas)", 'Ontario Association of Residences Treating Youth', "Ontario Catholic School Trustees' Association", 'Ontario Centres of Excellence Inc', 'Ontario Chamber Of Commerce', 'Ontario Colleges / Collèges Library Service (Ocls)', 'Ontario Council On Articulation And Transfer (Oncat)', 'Ontario Cycling Association Inc', 'Ontario Federation of Anglers and Hunters (Ofah)', 'Ontario Federation of Indigenous Friendship Centres (Ofifc)', 'Ontario First Nations Technical Services Corporation', 'Ontario Hiv Treatment Network', "Ontario Online Learning Consortium / Consortium Ontarien Pour L'Apprentissage En Linge", 'Ontario Public School Boards / Conseils Scolaires Association', 'Ontario Society For The Prevention of Cruelty To Animals (Spca)', 'Ophea', 'Options Northwest Personal Support Services', 'Orleans-Cumberland Community Resource Centre Centre De Ressources Communautaires Orleans-Cumberland', 'Osgoode Care Centre', 'Otonabee Region Conservation Authority', 'Parkdale Queen West Community Health Centre', 'Parkwood Mennonite Home Inc', "Paro Centre For Women's Enterprise", 'Pathways Health Centre For Children', 'Pathways To Education Canada', 'Payukotayno James & Hudson Bay Family Services', 'Perimeter Institute For Theoretical Physics', "Perley and Rideau Veterans' Health Centre", 'Pleasant Manor Retirement Village', 'Powassan and Area Family Health Team', 'Prime Care Family Health Team', 'Provincial Sheet Metal Workers Training Corporation', 'Quality Continuous Improvement Centre For Community Education And Training (Qciccet)', 'Queen Square Family Health Team', 'Radius Child And Youth Services', 'Rainy River District Social Services Admin Board', 'Ray of Hope Inc', 'Reaching Out Family Homes Inc', 'Red Lake Family Health Team', 'Reel Canada', 'Refrigeration Workers Local 787-Orac Training Fund', 'Regional Tourism Organization Four Inc', 'Rotman Camh Social Enterprise Development (O/A Rise Asset Development)', 'Rygiel Supports For Community Living', 'Safehaven Project For Community Living', 'Schlegel-Uw Research Institute For Aging Foundation', 'Seaway Valley Community Health Centre Inc', 'Service Coordination For Persons With Special Needs', 'Services And Housing In The Province (Ship)', "Sheet Metal Workers' Int'L Assoc", 'Sickkids Centre For Community Mental Health', 'Six Nations Elected Council - Justice Program', 'Skills Canada Ontario', 'Skylark Children Youth And Families', 'Smiths Falls Nurse Pracititioner Led Clinic', 'Sound Times Support Services', 'South Algonquin Family Health Team', 'South West Centre For Community Programme Development', 'Southwest Ontario Aboriginal Health Access Centre (Soahac)', 'Spark Commercialization And Innovation Centre', 'Speech And Stuttering Institute', 'Spruce Lodge Home For The Aged', "St Alban's Boys' And Girls' Club", 'St Clair Child and Youth Services', 'St Clair Region Conservation Authority', "St Hilda's Towers Inc", "St John's Retirement Homes", "St Joseph's Infirmary", "St Joseph's Lifecare Centre", "St Joseph's at Fleming", "St Michael's Homes", "St Stephen's Community House", 'St. Marys Public Library Board', 'St. Peter’S Care Centres', 'Stonegate Community Association', 'Stonehenge Therapeutic Community', 'Superior Family Health Team', 'Swim Drink Fish Canada', 'Taddle Creek Family Health Team', 'Taibu Community Health Centre', 'Teachers of English Second Language of Ontario (Tesl)', 'Temagami Medical Centre And Family Health Team', 'The Aids Network', 'The Michener Institute of Education At Uhn', 'The Ontario Community Centre For The Deaf Inc', 'The Ontario Mission of The Deaf Incorporated', 'The St Christopher House', 'Thresholds Homes And Supports Inc', 'Tilbury District Family Health Team (Tdfht)', 'Tno - The Neighbourhood Organization', 'Tourism Industry Association of Ontario (Tiao)', 'Traverse Independence Not For Profit', 'Treaty Three Police Services Board Inc', 'Trillium Network For Advanced Manufacturing', 'Twin Bridges Nurse Pracititioner Led Clinic', 'Two Rivers Community Development Centre', 'Two Rivers Family Health Team', 'U A Local 67M C A Zone 9/9A Apprenticeship Committee', 'Ukrainian Home For The Aged', 'Valley Manor Inc', 'Vector Institute', 'Venturelab Innovation Centre', 'Vha Health and Home Support', 'Victorian Order of Nurses For Canada - Ontario Branch', 'Villa Colombo Homes For The Aged', 'Village Family Health Team', 'Vineland Research And Innovations Centre Inc', 'Vintners Quality Alliance of Ontario', 'Vision 74 Inc', "Waasegiizhig Nanaandawe'Iyewigamig Health Access Centre", 'Wabano Centre For Aboriginal Health Inc', 'Water Technology Acceleration Project (O/A Watertap)', 'Waterlution - A Water Learning Experience', 'We Charity', 'Weechi-It-Te-Win Family Services Inc', 'Wellfort Community Health Services', 'Wesley Urban Ministries Inc', 'West Champlain Family Health Team Inc', 'West Gta Healthcare Shared Services Corporation', 'Wesway Inc', 'William W Creighton Youth Services', 'Windigo First Nations Council', "Women's Health In Womens Hands", "Women's Place St Catharines and District Inc", 'Woodbine Family Health Team', 'Woodbridge Medical Centre Family Health Team', 'Woodview Mental Health And Autism Services', 'Workers Health and Safety Centre', 'World Council On City Data', 'YMCA of Northeastern Ontario', 'Yee Hong Centre For Geriatric Care', 'Yor-Sup-Net Support Service Network', 'Youth Employment Services (Yes)', "Youturn Youth Support Services Services D'Appui A La Jeunesse", 'Algonquin And Lakeshore Catholic District School Board', "Conseil Scolaire Public Du Grand Nord De L'Ontario", "Conseil Scolaire Public Du Nord-Est De L'Ontario", 'Penetanguishene Protestant Separate School Board', 'Université De Hearst', 'Child and Family Services Review Board/Custody Review Board', 'Financial Services Regulatory Authority', 'Health Shared Services Ontario (HSSOntario)', 'Mcmichael Canadian Art Collection', 'Office of The Conflict of Interest Commissioner', 'Office of The Employer Adviser', 'Office of The Fairness Commissioner', 'Office of The Independent Police Review Director', 'Office of The Worker Adviser', 'Ontario Climate Change Solutions Deployment Corporation (GreenON)', 'Ontario Health Quality Council (Health Quality Ontario)', 'Safety, Licensing Appeals and Standards Tribunals Ontario / Animal Care Review Board /Fire Safety Commission / Licence Appeal Tribunal/Ontario Civilian Police Commission / Ontario Parole Board', 'Office of The Auditor General', 'Office of The Chief Electoral Officer', 'Accessibility Directorate of Ontario', 'Advanced Education And Skills Development', 'Ministry Of Labour', 'Ministry of Economic Development and Growth/Ministry of Research, Innovation and Science', 'Ministry of Government and Consumer Services', 'Ministry of Housing', 'Ministry of Infrastructure', 'Ministry of Labour', 'Ministry of Municipal Affairs', 'Office Of The Premier', 'Office of The Premier', 'Ontario Provincial Police', 'Seniors Affairs', 'Status of Women', 'Board of Health for The Northwestern Health Unit', 'Board of Health for The Porcupine Health Unit', 'Erinoakkids Centre for Treatment and Development', 'Municipality Of Killarney', 'Municipality of Dutton–Dunwich', 'Township of Chapleau', 'Township of Drummond–North Elmsley', 'Township of Emo', 'Township of Enniskillen', 'Township of Hornepayne', 'Township of Killaloe, Hagarty and Richards', 'Township of Leeds and The Thousand Islands', 'Township of Perry', 'Township of Stone Mills', 'Township of Terrace Bay', 'Township of White River', '2021 Canada Games Host Society Inc', 'APTUS Treatment Centre', 'Abrigo Centre', 'Accessible Community Counselling and Employment Services (ACCES)', 'Accommodation Info and Support Inc', 'Addiction and Mental Health Services - KFLA', 'Affiliated Services for Children and Youth Inc', 'Agri-Food Management Institute', 'Agricultural Adaptation Council (AAC)', 'Alliance for Healthier Communities', 'Alliston Family Health Team', 'Anishnabeg Outreach Employment and Training Inc', 'Anne Johnston Health Station - Tobias House Attendant Care', 'Association of Family Health Teams of Ontario (AFHTO)', 'Association of Municipalities of Ontario', 'Barbra Schlifer Commemorative Clinic (Bscc)', 'Bernard Betel Centre for Creative Living', 'Bethell Hospice', 'Bloom Centre for Sustainability', 'Branch 133 Legion Village Inc', 'CIVIX', 'Canadian Canoe Museum', "Canadian Men's Health Foundation", 'Canadian National Institute for The Blind (CNIB)', 'Canadian Red Cross Society', 'Canadian Urban Institute', 'Canadian Working Group On HIV and Rehabilitation (CWGHR)', 'Centre Des Services Communautaires De Vanier', 'Centre for Social Innovation', 'Centre for Surgical Invention and Innovation', 'Charles H Best Diabetes Centre', 'Child and Family Centre Ngodweaangizwin Aaskaagewin', 'Clarence- Rockland Family Health Team Inc', 'Coaches Association of Ontario', 'Coachworx Ltd', 'College of Carpenters and Allied Trades Inc', 'Community Legal Education Ontario (Cleo)', 'Community Living Fort Frances and District', 'Community Services for Independence North West', 'Connexion Family Health Team', 'Cou Holding Association Inc (OPAS)', 'Developmental Services of Leeds and Grenville', 'Dunara Homes for Recovery Inc', 'East GTA Family Health Team', 'Eastern Ontario Regional Laboratory Association (EORLA)', 'Enaahtig Healing Lodge and Learning Centre', 'Espanola and Area Family Health Team', 'Fairhaven Home for Senior Citizens', 'Family First Family Health Team', "Family and Children's Services of Frontenac Lennox and Addington", 'Fast Track Community Centre for Skills Development and Training', 'Fields Institute for Research In Math Sciences', 'Firefly (Physical Emotional Developmental and Community Services)', 'Friends of The Greenbelt Foundation', 'Gairdner Foundation', 'George Hull Centre for Children and Families', 'Grey Sauble Conservation Authority', 'Grove Park Home for Senior Citizens Inc', 'Haldimand Family Health Teams Inc', 'Happy Valley Family Health Team', 'Health for All Family Health Team', 'Heidehof Home for The Aged', 'Hellenic Home for The Aged Inc', 'Hiv and Aids Legal Clinic (Ontario)', 'Ices (Institute for Clinical Evaluative Sciences)', 'International Association of Bridge Structural and Ornamental Iron Workers', 'Invasive Species Centre (ISC)', 'Ivan Franko Homes', 'Jane-Finch Family Health Team', 'Kennedy House Youth Service Inc', 'Kidsability Centre for Child Development', "La Corporation Du Conseil Des Ministres De L'Education Canada (CMEC)", 'Labdara Lithuanian Nursing Home', "Labourers' International Union of North America Local 506", 'Lakeshore Area Multi-Services Project Inc (LAMP)', "Le Reseau De Developpement Economique Et D'Employabilite De L'Ontario (RDEE-Ontario)", 'Leamington and Area Family Health Team', 'Les Femmes Michif Otipemisiwak', 'Links2care', 'Local Planning Appeal Support Centre', 'Lower Outaouis Family Health Team', 'Maison Fraternite - Fraternity House', 'Mariann Nursing Home And Residence', 'Massey Centre for Women', 'Mathematics of Information Technology and Complex Systems (MITACS) Inc', 'McCormick Home', 'Mills Community Support Corporation Inc', 'Next Generation Manufacturing Canada', 'Nog-Da-Win-Da-Min Family and Community Services', 'Occupational Health Clinics for Ontario Workers Inc', 'Ontario Association of Adult and Continuing Education School Board Administrators (CESBA)', "Ontario Association of Children's Aid Societies (OACAS)", 'Ontario Association of Childrens Rehabilitation Services (OACRS)', 'Ontario Bioscience Innovation Organization', 'Ontario Chamber of Commerce', 'Ontario Colleges Library Service (OCLS)', 'Ontario Council On Articulation and Transfer (ONCAT)', 'Ontario Disability Employment Network', 'Ontario Federation of Indigenous Friendship Centres (OFIFC)', 'Ontario Home Care Association', 'Ontario Public School Boards Association', 'Ontario Public Service Quarter Century Club', 'Ontario Society for The Prevention of Cruelty To Animals (SPCA)', 'Organization of Canadian Nuclear Industries (OCI)', 'Orion', 'Oshki-Pimache-O-Win Education and Training Institute', 'Osteoporosis Society of Canada', "Paro Centre for Women's Enterprise", 'Patricia Region Senior Services Inc', 'Payukotayno James and Hudson Bay Family Services', 'Phara - Physically Handicapped Adults Rehabilitation Assoc', 'Plug N Drive Coalition of Ontario (O/A Plug N Drive)', 'Portage Medical Family Health Team', 'Prima Care Community Family Health Team', 'Quality Continuous Improvement Centre for Community Education and Training (QCICCET)', 'Regional HIV/AIDS Connection', 'Rideau Family Health Team', 'Rideauwood Addiction and Family Services', 'Royal Life Saving Society Canada Ontario Branch', 'Schlegel-Uw Research Institute for Aging Foundation', 'Senior Persons Living Connected', 'Serenity House Inc', 'Service Coordination for Persons With Special Needs', 'Services and Housing In The Province (SHIP)', 'Sheeo Canada Fund', "Sheet Metal Workers' Int'l Assoc", 'Sickkids Centre for Community Mental Health', 'Six Nations Polytechnic Inc', 'Skylark Children Youth and Families', 'Softech Alliance Network (O/P Wetch Alliance)', 'South West Centre for Community Programme Development', 'Southwest Ontario Aboriginal Health Access Centre (SOAHAC)', 'Southwestern Integrated Fibre Technology Inc', 'Spencer House Inc', "St Alban's Boys' and Girls' Club", "St Clair O'Connor Community Inc", "St Joseph's At Fleming", "St Joseph's Health Care Dundas", 'Stefanie Vander Slagt Physiotherapy Professional Corporation', 'Surrey Place', 'TNO - The Neighbourhood Organization', 'Teachers of English Second Language of Ontario (TESL)', 'Temagami Medical Centre and Family Health Team', 'The Michener Institute of Education At UHN', 'The Ontario Mission of the Deaf Incorporated', 'Thresholds Homes and Supports Inc', "Thrive Child Development Centre Centre De Developpement De L'Enfant", 'Tilbury District Family Health Team (TDFHT)', 'Transform Shared Service Organization', 'Traverse Independence Not for Profit', 'Tropicana Community Services Organization', 'United Mennonite Home for The Aged', 'Urban Rez Solutions', 'Victorian Order of Nurses for Canada - Ontario Branch', 'Villa Colombo Homes for The Aged', 'Vineland Research and Innovations Centre Inc', 'Waabnoong Bemjiwang Association of First Nations', 'Wabano Centre for Aboriginal Health Inc', 'Warden Woods Community Centre', 'Water Technology Acceleration Project (O/A WaterTAP)', 'Wellesley Institute', 'Wise Elephant Family Health Team', "Conseil Scolaire Public du Grand Nord de l'Ontario", "Conseil Scolaire Public du Nord-Est de l'Ontario", 'St Clair College Of Applied Arts and Technology', 'Alcohol And Gaming Commission Of Ontario', 'Health ForceOntario Marketing and Recruitment Agency', 'Health Program Initiatives (O/A Ontario Health)', 'Higher Education Quality Council Of Ontario', 'Ontario Agency For Health Protection And Promotion', 'Ontario Cannabis Retail Corporation', 'Ontario Climate Change Solutions Deployment Corporation (GREENON)', 'Safety, Licensing Appeals And Standards Tribunals Ontario / Animal Care Review Board /Fire Safety Commission / Licence Appeal Tribunal/ Ontario Civilian Police Commission / Ontario Parole Board', 'Trillium Gift Of Life Network', 'Workplace Safety And Insurance Appeals Tribunal', 'Superior Court Of Justice', 'Information And Privacy Commissioner', 'Office Of The Auditor General', 'Office Of The Chief Electoral Officer', 'Agriculture, Food And Rural Affairs', 'Economic Development, Job Creation and Trade', 'Energy, Northern Development and Mines', 'Environment, Conservation and Parks', 'Health And Long-Term Care', 'Indigenous Affairs', 'Seniors and Accessibility', 'Tourism, Culture And Sport', 'Board Of Health For The Northwestern Health Unit', 'Board Of Health For The Porcupine Health Unit', 'Collingwood General And Marine Hospital', 'Hanover And District Hospital', 'Hôpital Notre-dame Hospital (Hearst)', 'North Of Superior Healthcare Group', 'Perth And Smiths Falls District Hospital', 'Religious Hospitallers Of St Joseph Of The Hotel Dieu Of St Catharines', 'Santé Manitouwadge Health', 'City Of Clarence-Rockland', 'County Of Frontenac', 'County Of Grey', 'County Of Huron', 'County Of Lennox And Addington', 'County Of Middlesex', 'County Of Perth', 'Municipality Of Bayham', 'Municipality Of Bluewater', 'Municipality Of Callander', 'Municipality Of Central Huron', 'Municipality Of Dutton–Dunwich', 'Municipality Of Dysart Et Al', 'Municipality Of East Ferris', 'Municipality Of French River', 'Municipality Of Greenstone', 'Municipality Of Grey Highlands', 'Municipality Of Highlands East', 'Municipality Of Huron East', 'Municipality Of Leamington', 'Municipality Of McDougall', 'Municipality Of Meaford', 'Municipality Of Middlesex Centre', 'Municipality Of Mississippi Mills', 'Municipality Of Morris-Turnberry', 'Municipality Of North Grenville', 'Municipality Of North Middlesex', 'Municipality Of North Perth', 'Municipality Of Northern Bruce Peninsula', 'Municipality Of Oliver Paipoonge', 'Municipality Of Powassan', 'Municipality Of Red Lake', 'Municipality Of Shuniah', 'Municipality Of Sioux Lookout', 'Municipality Of South Bruce', 'Municipality Of South Dundas', 'Municipality Of South Huron', 'Municipality Of Southwest Middlesex', 'Municipality Of Temagami', 'Municipality Of Thames Centre', 'Municipality Of Trent Hills', 'Municipality Of Trent Lakes', 'Municipality Of Wawa', 'Municipality Of West Grey', 'Municipality Of West Perth', 'Municipality Of Whitestone', 'Municipality of Casselman', 'Town Of Blind River', 'Town Of Bracebridge', 'Town Of Bradford West Gwillimbury', 'Town Of Deseronto', 'Town Of East Gwillimbury', 'Town Of Erin', 'Town Of Espanola', 'Town Of Espanola - Police Service Board', 'Town Of Fort Frances', 'Town Of Gananoque', 'Town Of Goderich', 'Town Of Grand Valley', 'Town Of Gravenhurst', 'Town Of Greater Napanee', 'Town Of Hanover', 'Town Of Hearst', 'Town Of Ingersoll', 'Town Of Iroquois Falls', 'Town Of Kearney', 'Town Of Kingsville', 'Town Of Lakeshore', 'Town Of Lincoln', 'Town Of Marathon', 'Town Of Minto', 'Town Of Mono', 'Town Of Moosonee', 'Town Of New Tecumseth', 'Town Of Pelham', 'Town Of Penetanguishene', 'Town Of Perth', 'Town Of Petawawa', 'Town Of Plympton–Wyoming', 'Town Of Saugeen Shores', 'Town Of Shelburne', 'Town Of Smiths Falls', 'Town Of Smooth Rock Falls', 'Town Of South Bruce Peninsula', 'Town Of St. Marys', 'Town Of Tecumseh', 'Town Of Whitchurch-Stouffville', 'Township Of Addington Highlands', 'Township Of Adjala-Tosorontio', 'Township Of Alfred And Plantagenet', 'Township Of Algonquin Highlands', 'Township Of Alnwick/Haldimand', 'Township Of Amaranth', 'Township Of Armour', 'Township Of Ashfield-Colborne-Wawanosh', 'Township Of Asphodel–Norwood', 'Township Of Augusta', 'Township Of Black River-Matheson', 'Township Of Blandford-Blenheim', 'Township Of Brock', 'Township Of Carling', 'Township Of Cavan Monaghan', 'Township Of Central Frontenac', 'Township Of Champlain', 'Township Of Chatsworth', 'Township Of Clearview', 'Township Of Cramahe', 'Township Of Douro-Dummer', 'Township Of Drummond–North Elmsley', 'Township Of Ear Falls', 'Township Of East Garafraxa', 'Township Of East Zorra-Tavistock', 'Township Of Edwardsburgh/Cardinal', 'Township Of Elizabethtown-Kitley', 'Township Of Emo', 'Township Of Essa', 'Township Of Frontenac Islands', 'Township Of Greater Madawaska', 'Township Of Havelock-Belmont-Methuen', 'Township Of Hornepayne', 'Township Of Huron-Kinloss', 'Township Of Ignace', 'Township Of Killaloe, Hagarty And Richards', 'Township Of King', 'Township Of Lake Of Bays', 'Township Of Laurentian Valley', 'Township Of Leeds And The Thousand Islands', 'Township Of Lucan Biddulph', 'Township Of Machar', 'Township Of Madawaska Valley', 'Township Of Malahide', 'Township Of Manitouwadge', 'Township Of Mapleton', 'Township Of McKellar', 'Township Of McNab/Braeside', 'Township Of Melancthon', 'Township Of Minden Hills', 'Township Of Mulmur', 'Township Of North Algona Wilberforce', 'Township Of North Dumfries', 'Township Of North Dundas', 'Township Of North Frontenac', 'Township Of North Glengarry', 'Township Of North Huron', 'Township Of North Stormont', 'Township Of Norwich', 'Township Of Oro-Medonte', 'Township Of Otonabee–South Monaghan', 'Township Of Perry', 'Township Of Perth East', 'Township Of Perth South', 'Township Of Puslinch', 'Township Of Ramara', 'Township Of Rideau Lakes', 'Township Of Russell', 'Township Of Scugog', 'Township Of Seguin', 'Township Of Selwyn', 'Township Of Severn', 'Township Of South Frontenac', 'Township Of South Glengarry', 'Township Of South Stormont', 'Township Of Southgate', 'Township Of Southwold', 'Township Of Springwater', 'Township Of St. Clair', 'Township Of Stirling-Rawdon', 'Township Of Stone Mills', 'Township Of Tay', 'Township Of Terrace Bay', 'Township Of The Archipelago', 'Township Of Tiny', 'Township Of Wainfleet', 'Township Of Warwick', 'Township Of Wellesley', 'Township Of West Lincoln', 'Township Of Whitewater Region', 'Township Of Wilmot', 'Township Of Zorra', 'United Counties Of Leeds And Grenville', 'United Counties Of Stormont, Dundas And Glengarry', 'Village Of Merrickville–Wolford', 'Village Of Point Edward', 'Village Of Westport', '2021633 Ontario Inc (O/A Finishing Trades Institute of Ontario)', 'AbleLiving Services Inc', 'Access For Parents and Children In Ontario', 'Accessible Community Counselling And Employment Services (ACCES)', "Afghans Women's Counselling and Integration Community Support Organization", 'Algonquin Opportunity (no 2)', 'Anago (non)', 'Anishnabeg Outreach Employment And Training Inc', 'Association Franco-Ontarienne Des Conseils Scolaires Catholiques (o/a AFOCSC)', 'Association Of Family Health Teams Of Ontario (AFHTO)', 'Association Of Native Child and Family Services Agencies Of Ontario', 'Association Of Ontario Midwives', 'Athletics Ontario', 'Barbra Schlifer Commemorative Clinic (BSCC)', 'Better Living At Thompson House', 'Big Brothers Big Sisters Of Canada', 'Brain Injury Services Of Northern Ontario', 'CLH Developmental Support Services', 'Canadian AIDS Treatment Information Exchange', 'Canadian Elevator Industry Educational Program (CEIEP)', "Canadian Hearing Society-la Societe Canadienne De L'ouie", 'Canadian Helen Keller Centre (CHKC)', 'Canadian Mental Health Association - Ontario Division', 'Canadian National Institute For The Blind (CNIB)', 'Centennial Infant And Child Centre (for Children With Special Needs)', 'Centre Canadien De Leadership En Evaluation Inc', "Centre D'accueil Roger Seguin", 'Centre De Sante Communautaire Chigamik CHC Inc', "Centre De Sante Communautaire De L'estrie Ontario", 'Centre For Family Medicine Family Health Team', 'Centre Ontarien De Prevention Des Agressions (COPA)', 'Centre de santé UNIVI Health Centre', 'Chapleau And District Family Health Team', 'Chiefs Of Ontario', "Children's Aid Society Of The United Counties Of Stormont Dundas and Glengarry", "Children's Mental Health Of Leeds And Grenville", 'City Of Lakes Family Health Team', 'Coalition For Persons With Disabilities', 'College Of Carpenters And Allied Trades Inc', 'Community Family Services of Ontario', 'Community Legal Education Ontario (CLEO)', 'Community Living Fort Frances And District', 'Community Living-Central Huron', 'Compass Community Health', 'Compass, Boussole, Akii-Izhinoogan Mental Health, Development And Community Services For Children, Youth And Families', 'Corbrook Awakening Abilities', 'Corporation Of Massey Hall and Roy Thompson Hall', 'Crest Support Services (Meadowcrest)', 'Deafblind Community Services', 'Deer Lake First Nation School', 'Developmental Services Of Leeds And Grenville', 'Dixie Bloor Neighbourhood Drop-in Centre', 'Don Mills Family Health Team', 'Dr Bob Kemp Hospice Foundation Inc', 'E3 (Educate Enable Empower)', 'Eagle Lake First Nation', 'Edgewater Gardens Long Term Care Centre', 'Elmira District Community Living', 'Emery-Keelesdale NPLC Inc', 'Employment Planning And Counselling', 'Equipe De Sante Familiale Academique Montfort', "Family And Children's Services Of Frontenac Lennox And Addington", 'Family Transition Place', 'Fort Frances Tribal Area Health Services Inc', 'Friends Of The Greenbelt Foundation', 'Garden River First Nation', 'Good Shepherd Non-Profit Homes Inc', 'Governing Council Of The Salvation Army In Canada', 'Grandview Medical Centre Family Health Team Inc', 'HF Connecting Health Nurse Practitioner-Led Clinic', 'Hands Thefamilyhelpnetwork.ca', 'Harmony Centre For Community Living', 'Head Injury Rehabilitation Ontario', 'Health For All Family Health Team', 'Heart & Stroke Foundation Of Ontario', "Hopewell Children's Homes Inc", 'House Of Sophrosyne', 'Huron Lodge Community Service Board Inc', 'Huron-Perth Centre For Children And Youth', 'ICES (Institute For Clinical Evaluative Sciences)', 'IISD Experimental Lakes Area Inc', 'Ican Independence Centre And Network', 'Indigenous Advanced Education And Skills Council', 'International Association Of Bridge Structural And Ornamental Iron Workers', 'International Union Of Operating Engineers', 'Ironworkers Local 765 Training Centre Fund', 'Jakes House For Autistic Children', 'Ka-Na-Chi-Hih Specialized Solvent Abuse Treatment Centre', 'Kinark Child And Family Services', 'Kunuwanimano Child And Family Services', "La Corporation Du Conseil Des Ministres De L'education Canada (CMEC)", "Labourers' International Union Of North America Local 506", "Labourers' International Union of North America Local 1059 GE", 'Lakeshore Area Multi-services Project Inc (LAMP)', 'Lakeview Family Health Team', "Land O'Lakes Community Services", "Le Centre Moi J'apprends Inc", 'Learning Disabilities Association Of Ontario', "Les Centres D'accueil Heritage", 'Liveworkplay', 'Madawaska Valley Association For Community Living', 'Maitland Valley Family Health Team', 'Mathematics Of Information Technology And Complex Systems (MITACS)', 'Mennonite Brethern Senior Citizen Home', 'Metis Nation Of Ontario Secretariat', 'Nan Corporate Services', 'Nog-da-win-da-min Family And Community Services', "North Eastern Ontario Family And Children's Services", 'North Of Superior Programs', 'Northern Neighbours Nurse Practitioner-Led Clinic', 'Northern Ontario Regional Tourism Organization (RTO)', 'OCASI-Ontario Council Of Agencies Serving Immigrants', 'Oakmed Family Health Team', 'Ojibways Of Onigaming First Nation', "One Kids Place Children's Medical Treatment Centre Of North East Ontario", 'Ontario Aboriginal HIV/AIDS Strategy', 'Ontario Agri-food Education Inc', "Ontario Association Of Children's Aid Societies (OACAS)", 'Ontario Association Of Childrens Rehabilitation Services (OACRS)', 'Ontario Association Of Veterinary Technicians (OAVT)', 'Ontario Caregiver Organization', 'Ontario Centres Of Excellence Inc', 'Ontario College Of Family Physicians', 'Ontario Council On Articulation And Transfer (ONCAT)', 'Ontario Federation Of Indigenous Friendship Centres (OFIFC)', 'Ontario Federation Of School Athletic Associations', 'Ontario Long Term Care Association', 'Ontario Society For The Prevention Of Cruelty To Animals (SPCA)', 'Ontario Tourism Education Corp', 'Opportunity For Advancement', "PARO Centre For Women's Enterprise", 'PHARA - Physically Handicapped Adults Rehabilitation Assoc', 'PTP-Adult Learning And Employment Programs', 'Pediatric Oncology Group Of Ontario', 'Personal Attendant Care Inc', 'Point In Time Centre For Children Youth And Parents', 'Prevention Link', 'Prospectors And Developers Association Of Canada Mining Matters', 'Quality Continuous Improvement Centre For Community Education And Training (QCICCET)', 'Quantum Valley Ideas Laboratories', 'Refrigeration Workers Local 787-ORAC Training Fund', 'Regeneration House Inc', 'Regina Gardens', 'Registered Nurses Association Of Ontario', 'Richview Community Care Services Corporation', 'Rotman CAMH Social Enterprise Development (o/a Rise Asset Development)', 'Row Ontario', 'Saint Elizabeth Fountation', 'Schizophrenia Society Of Ontario', 'Schlegel-UW Research Institute For Aging Foundation', "Sedna Women's Shelter and Support Services Inc", 'Services And Housing In The Province (SHIP)', 'Sharbot Lake Family Health Team', 'Shepherds Of Good Hope', 'SickKids Centre For Community Mental Health', 'Slovenian Linden Foundation', 'Softech Alliance Network (o/p Wetch Alliance)', 'St. Peter’s Care Centres', 'Star Family Health Team', 'Stormont Dundas and Glengarry Developmental Services Centre', 'Street Haven At The Crossroads', 'TESL Association of Ontario', 'The Benevolent Society Heidehof for the Care of the Aged', 'The Michener Institute Of Education At Uhn', 'Tikinagan Child And Family Services', 'Tri-County Community Support Services', 'United Mennonite Home For The Aged', 'Vanier Community Service Centre', 'Victorian Order Of Nurses For Canada - Ontario Branch', 'Vintners Quality Alliance Of Ontario', 'Vision Loss Rehabilitation Canada', "Waasegiizhig Nanaandawe'iyewigamig Health Access Centre", 'Wasauksing First Nation', 'Windmill Microlending', 'Wine Marketing Association Of Ontario', "Y's Owl MacLure Cooperative Centre Inc", 'YMCA Of Northeastern Ontario', 'Conseil Scolaire Catholique MonAvenir', "Conseil Scolaire Public Du Grand Nord De L'ontario", "Conseil Scolaire Public Du Nord-est De L'ontario", 'Kidsability School Authority', "Maison D'amitie", 'Northern Ontario School Of Medicine', "University Of St. Michael's College", 'Ontario Health', 'Financial Services Regulatory Authority of Ontario', 'Labour, Training and Skills Development', 'Colleges and Universities', 'Long-Term Care', 'Heritage, Sport, Tourism and Culture Industries', 'St. Joseph’s Care Group', 'St. Mary’s General Hospital', 'St. Joseph’s General Hospital', 'Town Of Cobalt', 'Municipality Of Marmora And Lake', 'Township Of Dawn-Euphemia', 'Township Of Chapleau', 'Township Of Horton', 'Town Of Espanola – Police Service Board', 'Township Of Strong', 'Township Of Alberton', 'Municipality Of Arran-Elderslie', 'Township Of Sables-Spanish Rivers', 'Township Of Bonnechere Valley', 'Municipality Of Magnetawan', 'Atura', 'Catholic Children’s Aid Society', 'Inuuqatigiit Centre for Inuit Children, Youth and Families', 'Centre De Sante Communautaire De L’estrie Ontario', 'The Redwood Shelter', 'The Career Foundation', 'Institute for Advancements in Mental Health', 'Skate Ontario', 'Ontario Association Of Children’s Aid Societies (OACAS)', 'Canadian Mental Health Association – Ontario Division', 'Automotive Parts Manufacturers Association Of Canada (APMA)', 'Women’s Health In Womens Hands', 'Shingwauk Teaching Lodge', 'St Joseph’s Home Care', 'Highland Shores Children’s Aid Society', 'EveryMind Mental Health Services', 'Travel Industry Council Of Ontario', 'Children’s Aid Society Of The United Counties Of Stormont Dundas and Glengarry', 'Anne Johnston Health Station – Tobias House Attendant Care', 'Earlscourt – Creche Child Development Institute', 'Victorian Order Of Nurses For Canada – Ontario Branch', 'Stella’S Place Assessment And Treatment Center', 'Waasegiizhig Nanaandawe’iyewigamig', 'La Corporation Du Conseil Des Ministres De L’education Canada (CMEC)', 'Canadian Hearing Services/Services canadiens de L’ouïe', 'North Eastern Ontario Family And Children’s Services', 'Mathematics Of Information Technology And Complex Systems (MITACS) Inc', 'Children’s Mental Health Ontario', 'Ontario Centre of Innovation', 'Onkwehon:We Midwives Collective', 'George Jeffrey Children’s Centre', 'Lumenus Community Services', 'Carea Community Health Centre', 'Npower Canada', 'Lakeshore Community Nurse Practitioner-Led Clinic', 'De Dwa Da Dehs Nye’s Aboriginal Health Centre', 'Perley and Rideau Veterans’ Health Centre', 'Slate Falls First Nation', 'Huron-Perth Children’s Aid Society', 'Saint Luke’s Place', 'Gardiner Museum Of Ceramic Art', 'Sheet Metal Workers’ International Association Local 285 Training Centre', 'St Joseph’s Infirmary', 'St Joseph’s Lifecare Centre', 'Kerry’s Place Autism Services', 'Family And Children’s Services Of Frontenac Lennox And Addington', 'Les Centres D’accueil Heritage', 'Central Canadian District Chirstian and Missionary Alliance – Cama Woodlands', 'Wellkin-Child and Youth Mental Wellness', 'The Ontario Mission Of The Deaf Incorporated', 'Alphaplus Centre', 'Marathon Family Health Team', 'St Joseph’s At Fleming', 'St Thomas Economic Development Corporation', 'Ontario Lacrosse Association', 'St Joseph’s Health Care Dundas', 'Empower Simcoe Services', 'Compute Ontario', 'Children’s Mental Health Of Leeds And Grenville', 'Ontario Retirement Communities Association', 'St John’s Retirement Homes', 'Farm & Food Care Ontario', 'Grandview Children’s Centre', 'Maison Fraternite – Fraternity House', 'Children’s Aid Foundation Of Canada', 'Horticultural Trades Association Inc (o/a Landscape Ontario)', 'Bereavement Authority Of Ontario', 'Anago (non) Residential Resources Inc', 'Royal Canadian Legion District “D” Care Centres', 'Oshki-pimache-o-win: The Wenjack Education Institute', 'Madawaska Valley Family Health Team', 'Eastern Ontario Regional Network Inc', 'One Kids Place Children’s Medical Treatment Centre Of North East Ontario', 'Resolve Counselling Services Canada', 'Ismp Canada (Institute For Safe Medication Practices Canada)', 'Smithville Family Health Team', 'St Michael’s Homes', 'Lansdowne Children’s Centre', 'Street Health Community Nursing Foundation', 'Indian Agricultural Program Of Ontario', 'Choices For Change Alcohol Drug And Gambling Counselling Centre', 'Centre D’accueil Roger Seguin', 'Sunbeam Community & Developmental Services', 'Food For Life Canada Charitable Corporation', 'Achēv', 'Niijaansinaanik Child And Family Services', 'St Clair O’Connor Community Inc', 'Crossroads Children’s Centre', 'Merrymount Children’s Centre', 'Children’s Community Network', 'TNO – The Neighbourhood Organization', 'Job Skills – Employment And Business Programs And Supports', 'Nipigon District Family Health Team', 'Cornerstone Family Violence Prevention Centre', 'Clarence – Rockland Family Health Team Inc', 'Wabaseemoong Independent Nations', 'Haileybury Family Health Team', 'Boxing Ontario Inc', 'ABLE2: Support for People with Disabilities', 'Wikwemikong Nursing Home', 'Centre De Ressources Familiales De Sturgeon Falls Sturgeon Falls Family Resource Centre', 'Le Centre Moi J’apprends Inc', 'Harold And Grace Baker Centre', 'St Hilda’s Towers Inc', 'Canadian Mental Health Association – Champlain East', 'PARO Centre For Women’s Enterprise', 'Land O’Lakes Community Services', 'Webequie First Nation', '8024499 Canada Association (O/A Helmets To Hardhats Canada)', 'Bingwi Neyaashi Anishinaabek First Nation', 'Ontario Native Women’s Association', 'Ontario Tender Fruit Growers', 'Ontario Business Improvement Area Association', 'Ontario Equestrian Federation', 'Sedna Women’s Shelter and Support Services Inc', '2 Spirited People Of The First Nations', 'Kwayaciiwin Education Resource Centre', 'Livestock Research Innovation Corporation (LRIC)', 'Community Living North Grenville', 'Wrestling Canada Lutte', 'Inspire Community Support Services', 'Four County Labour Market Planning Board', 'The Canadian Academy Of Recording Arts And Sciences (Caras)', 'Community Services For Independence North West', 'St Stephen’s Community House', 'Wahgoshig First Nation', 'Maison D’hebergement Pour Femmes Francophones', 'House Of Friendship', 'St. Leonard’s Community Support, Prevention and Residential Services', 'Bennett Village', 'HIV and AIDS Legal Clinic (Ontario)', 'Addiction And Mental Health Services – KFLA', 'Rural Healthcare Innovations', 'Plantagenet Family Health Team Inc', 'Wawa Family Health Team', 'St Lawrence River Institute Of Environmental Sciences', 'Foyer Des Pionniers', 'Hopewell Children’s Homes Inc', 'Villa Leonardo Gambin', 'Labourers’ International Union of North America Local 1059 GE', 'Bulimia Anorexia Nervosa Association (o/a BANA)', 'Ontario AIDS Network', 'Nainstay Non-profit Buildings Inc', 'Ontario Gymnastic Federation', 'Madame Vanier Children’s Services', 'Nellie’s Women’s Hostel Inc', 'Arrabon Inc', 'Ontario Rugger Union (o/a Rugby Ontario)', 'St. Leonard’s Community Services Inc.', 'Algonquin Opportunity (no 2) Corporation', 'Ontario Association Of Food Banks', 'The Ontario Association Of Social Workers', 'Bernadette McCann House For Women Inc', 'Peer Support South East Ontario', 'Mattagami First Nation', 'Ernestine’s Women’s Shelter', 'PHARA – Physically Handicapped Adults Rehabilitation Assoc', 'Ray Of Hope Inc', 'Good Shepherd Refuge Social Ministries', 'Sunshine Child Care Centre', 'Knollcrest Lodge', 'Crisis Homes Inc (o/a Faye Peterson Transition House)', 'Conseil Scolaire Public Du Grand Nord De L’ontario', 'Conseil Scolaire De District Catholique De L’est Ontarien', 'Conseil Scolaire Public Du Nord-est De L’ontario', 'Women’s Place St Catharines and District Inc', 'Weechi-it-te-win Family Services Inc', 'St. Jerome’s University', 'King’s University College', 'University Of St. Michael’s College', 'Universite De L’Ontario Francais', 'St. Peter’s Seminary']
#File city file to be used below
city_data_to_load = "Resources/city.csv"
# Create a DataFrame for the city data.
city_df = pd.read_csv(city_data_to_load)
#display the data table for preview
city_df.head()
| city | |
|---|---|
| 0 | Ajax |
| 1 | Algoma |
| 2 | Aylmer |
| 3 | Atikokan |
| 4 | Ancaster |
#use the city file to clean city column
sunshine_data_df.loc[~sunshine_data_df['city'].isin(city_df['city']), 'city'] = 'Not Identified'
#Review the various categories in Sector column
sunshine_data_df['clean_job_title'].value_counts()
Professor 71790
Associate Professor 46408
Registered Nurse 41450
Constable 31880
Police Constable 26476
...
Charge Mammography 1
Municipal Building Official II 1
Chef des Affaires 1
Supervisor of Family Support and Early Intervention 1
Director, Facilities & Ancillary 1
Name: clean_job_title, Length: 179380, dtype: int64
#Standardize and Rename all cleansed_job_title column
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Vice President Academic', case=False),'clean_job_title'] ='VP'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Chair', case=False), 'clean_job_title'] = 'Chair/Chief/DeptHead'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Dean', case=False), 'clean_job_title'] = 'Dean/Provost'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Director', case=False), 'clean_job_title'] = 'Director'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Account Exe', case=False), 'clean_job_title'] = 'Manager'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Account Manager', case=False), 'clean_job_title'] = 'Manager'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Account R', case=False), 'clean_job_title'] = 'Manager'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Accountant', case=False), 'clean_job_title'] = 'Accountant'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('CEO', case=False), 'clean_job_title'] = 'CEO'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('CFO', case=False), 'clean_job_title'] = 'CFO'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Chief E', case=False), 'clean_job_title'] = 'CEO'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Chief F', case=False), 'clean_job_title'] = 'CFO'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Commissioner', case=False), 'clean_job_title'] = 'Commissioner/Minister/Councillor'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('President', case=False), 'clean_job_title'] = 'President'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Vice President', case=False), 'clean_job_title'] = 'VP'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('VP', case=False), 'clean_job_title'] = 'VP'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('V.P', case=False), 'clean_job_title'] = 'VP'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Vice P', case=False), 'clean_job_title'] = 'VP'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Superintendent', case=False), 'clean_job_title'] = 'Superintendent'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Nurse P', case=False), 'clean_job_title'] = 'Nurse'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Registered Nurse', case=False), 'clean_job_title'] = 'Nurse'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Administrator', case=False), 'clean_job_title'] = 'Admin'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Teacher', case=False), 'clean_job_title'] = 'Teacher/Trainer'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Paramedic', case=False), 'clean_job_title'] = 'Paramedic'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Physio', case=False), 'clean_job_title'] = 'Physiotherapist'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Physio', case=False), 'clean_job_title'] = 'Physiotherapist'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Supervisor', case=False), 'clean_job_title'] = 'TeamLead/Supervisor'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Technologist', case=False), 'clean_job_title'] = 'Technologist/Technician'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Practice Nurse', case=False), 'clean_job_title'] = 'Nurse'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Practice Resource Nurse', case=False), 'clean_job_title'] = 'Nurse'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Advisor', case=False), 'clean_job_title'] = 'Consultant'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Engineer', case=False), 'clean_job_title'] = 'Engineer'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Analyst', case=False), 'clean_job_title'] = 'Analyst'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Assistant Deputy Minister', case=False),'clean_job_title'] ='Commissioner/Minister/Councillor'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Professor', case=False),'clean_job_title'] ='Professor'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Principal', case=False),'clean_job_title'] ='Principal'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Physician', case=False),'clean_job_title'] ='Physician'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Assoc Prof', case=False),'clean_job_title'] ='Professor'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Manager', case=False),'clean_job_title'] ='Manager'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('mgr', case=False),'clean_job_title'] ='Manager'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('adm', case=False),'clean_job_title'] ='Admin'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('police', case=False),'clean_job_title'] ='Police'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('fire', case=False),'clean_job_title'] ='Fire Fighter'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('clerk', case=False),'clean_job_title'] ='Admin'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Soliciter', case=False),'clean_job_title'] ='Lawyer'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('General Counsel', case=False),'clean_job_title'] ='Lawyer'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Nurs', case=False), 'clean_job_title'] = 'Nurse'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Secetary', case=False), 'clean_job_title'] = 'Admin'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Pharma', case=False), 'clean_job_title'] = 'Pharmacist'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Pathologist', case=False), 'clean_job_title'] = "Physician"
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('social worker', case=False), 'clean_job_title'] = "Social Worker"
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Dir', case=False), 'clean_job_title'] = "Director"
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Law Enforcement Officer', case=False), 'clean_job_title'] = "Police"
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Judge', case=False), 'clean_job_title'] = "Judge"
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Justice of the Peace', case=False), 'clean_job_title'] = "Judge"
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Scientist', case=False), 'clean_job_title'] = "Scientist"
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Soliciter', case=False), 'clean_job_title'] = "Lawyer"
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Counsel', case=False), 'clean_job_title'] = "Lawyer"
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Chief Information Officer', case=False), 'clean_job_title'] = "CIO"
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Crown Attorney', case=False), 'clean_job_title'] = "Lawyer"
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Librarian', case=False), 'clean_job_title'] = "Librarian"
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Medical Officer of Health', case=False), 'clean_job_title'] = "Physician"
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Oncologist', case=False), 'clean_job_title'] = "Physician"
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Prof.', case=False),'clean_job_title'] ='Professor'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Bus Driver', case=False),'clean_job_title'] ='Bus Driver'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Lawyer', case=False),'clean_job_title'] ='Lawyer'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Pilot', case=False),'clean_job_title'] ='Pilot'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Médecin', case=False),'clean_job_title'] ='Physician'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Mechanic', case=False),'clean_job_title'] ='Mechanic'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Electrician', case=False),'clean_job_title'] ='Electrician'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Electrical', case=False),'clean_job_title'] ='Electrician'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Detective Sergeant', case=False),'clean_job_title'] ='Police'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('First Class Constable', case=False),'clean_job_title'] ='Police'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Constable', case=False),'clean_job_title'] ='Police'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Detective ', case=False),'clean_job_title'] ='Police'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Constable ', case=False),'clean_job_title'] ='Police'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Sergeant ', case=False),'clean_job_title'] ='Police'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Commissioner', case=False),'clean_job_title'] ='Commissioner/Minister/Councillor'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Minister', case=False),'clean_job_title'] ='Commissioner/Minister/Councillor'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Curriculum', case=False),'clean_job_title'] ='Teacher/Trainer'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Enseignante', case=False),'clean_job_title'] ='Teacher/Trainer'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Education', case=False),'clean_job_title'] ='Teacher/Trainer'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Professeur(e)', case=False),'clean_job_title'] ='Professor'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Chief Information Officer', case=False),'clean_job_title'] ='CIO'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Vice–Président', case=False),'clean_job_title'] ='VP'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Operator', case=False),'clean_job_title'] ='Operator'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Consultant', case=False),'clean_job_title'] ='Consultant'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Forensics', case=False),'clean_job_title'] ='Police'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('City Solicitor', case=False),'clean_job_title'] ='Lawyer'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Technician', case=False),'clean_job_title'] ='Technologist/Technician'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Solicitor 2', case=False),'clean_job_title'] ='Lawyer'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Senior Solicitor', case=False),'clean_job_title'] ='Lawyer'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Enseignement secondaire', case=False),'clean_job_title'] ='Teacher/Trainer'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Sergeant', case=False),'clean_job_title'] ='Police'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Falculty', case=False),'clean_job_title'] ='Faculty Member/Team Member'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Captain', case=False),'clean_job_title'] ='Police'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Staff Sergeant', case=False),'clean_job_title'] ='Police'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('General Duty Officer', case=False),'clean_job_title'] ='Police'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Platoon Chief', case=False),'clean_job_title'] ='Fire Fighter'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Solicitor 1', case=False),'clean_job_title'] ='Lawyer'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Enseignant', case=False),'clean_job_title'] ='Teacher/Trainer'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('General Duty Officer / Agent des services généraux', case=False),'clean_job_title'] ='Police'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Solicitor', case=False),'clean_job_title'] ='Lawyer'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Senior Lecturer', case=False),'clean_job_title'] ='Faculty Member/Team Member'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Chief Operating Officer', case=False),'clean_job_title'] ='COO'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('General Duty Officer', case=False),'clean_job_title'] ='Police'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Secondary Department Head', case=False),'clean_job_title'] ='Teacher/Trainer'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Enseignant-e', case=False),'clean_job_title'] ='Teacher/Trainer'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Councillor', case=False),'clean_job_title'] ='Commissioner/Minister/Councillor'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Executive Assistant', case=False),'clean_job_title'] ='Admin'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('City Solicitor', case=False),'clean_job_title'] ='Lawyer'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Associate Lecturer', case=False),'clean_job_title'] ='Faculty Member/Team Member'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Detachment Sergeant', case=False),'clean_job_title'] ='Police'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Contract Lecturer', case=False),'clean_job_title'] ='Faculty Member/Team Member'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Psychologist PhD', case=False),'clean_job_title'] ='Physician'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Solicitor 2', case=False),'clean_job_title'] ='Lawyer'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Plumber/Pipefitter Foreman - Construction', case=False),'clean_job_title'] ='Plumber'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Senior Solicitor', case=False),'clean_job_title'] ='Lawyer'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Executive Chef', case=False),'clean_job_title'] ='CEO'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Senior Vice President Secretary Treasurer', case=False),'clean_job_title'] ='VP'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Co-ordinator', case=False),'clean_job_title'] ='Coordinator/Planner/Specialist'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Chief', case=False), 'clean_job_title'] = 'Chair/Chief/DeptHead'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Neuropathologist', case=False), 'clean_job_title'] = 'Physician'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Head', case=False), 'clean_job_title'] = 'Chair/Chief/DeptHead'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Researcher', case=False), 'clean_job_title'] = 'Researcher'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('NEONATOLOGIST', case=False), 'clean_job_title'] = 'Physician'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Pathologist', case=False), 'clean_job_title'] = 'Physician'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Geneticist', case=False), 'clean_job_title'] = 'Physician'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Bacteriologist', case=False), 'clean_job_title'] = 'Physician'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Radiologist', case=False), 'clean_job_title'] = 'Physician'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Medical Biochemist', case=False), 'clean_job_title'] = 'Scientist'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Legal Officer', case=False), 'clean_job_title'] = 'Lawyer'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Lecturer', case=False), 'clean_job_title'] = 'Faculty Member/Team Member'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Coordinator', case=False), 'clean_job_title'] = 'Coordinator/Planner/Specialist'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Prosecutors ', case=False), 'clean_job_title'] = 'Lawyer'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Senior Planner Community Planning', case=False), 'clean_job_title'] = 'Coordinator/Planner'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Economist', case=False), 'clean_job_title'] = 'Economist'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Lead', case=False), 'clean_job_title'] = 'TeamLead/Supervisor'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Foreperson', case=False), 'clean_job_title'] = 'Foreperson'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Program Coordinator', case=False), 'clean_job_title'] = 'Coordinator/Planner'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Coordinator / Coordonnateur', case=False), 'clean_job_title'] = 'Coordinator/Planner'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Foreman', case=False), 'clean_job_title'] = 'Foreperson'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Doctor', case=False), 'clean_job_title'] = 'Physician'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Staff Psychologist/ Psychologue', case=False), 'clean_job_title'] = 'Physician'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Physicist / Physicien', case=False), 'clean_job_title'] = 'Scientist'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Shift Leade', case=False), 'clean_job_title'] = 'TeamLead/Supervisor'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Planner', case=False), 'clean_job_title'] = 'Coordinator/Planner/Specialist'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Microbiologist', case=False), 'clean_job_title'] = 'Scientist'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Physicist/Physicien', case=False), 'clean_job_title'] = 'Scientist'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Sessional Lecturer', case=False), 'clean_job_title'] = 'Faculty Member/Team Member'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Maintainer', case=False),'clean_job_title'] ='Operator'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Rail Vehicle Analyzer', case=False),'clean_job_title'] ='Analyst'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Operations Specialist I', case=False),'clean_job_title'] ='Operator'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Prosecutor', case=False),'clean_job_title'] ='Lawyer'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Detective', case=False),'clean_job_title'] ='Police'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Instructor', case=False),'clean_job_title'] ='Teacher/Trainer'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Training Officer', case=False),'clean_job_title'] ='Teacher/Trainer'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains("Team Member / Membre de l'équipe", case=False), 'clean_job_title'] = 'Faculty Member/Team Member'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains("Physicist", case=False), 'clean_job_title'] = 'Scientist'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains("Health Physicist", case=False), 'clean_job_title'] = 'Scientist'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains("Research Associate", case=False), 'clean_job_title'] = 'Researcher'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains("Infection Control Practitioner", case=False), 'clean_job_title'] = 'Physician'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains("Psychiatrist / Psychiatre", case=False), 'clean_job_title'] = 'Physician'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains("Contract Psychiatrist", case=False), 'clean_job_title'] = 'Physician'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains("General Practitioner, Oncology", case=False), 'clean_job_title'] = 'Physician'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Planning', case=False), 'clean_job_title'] = 'Coordinator/Planner/Specialist'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains("Lab MD", case=False), 'clean_job_title'] = 'Physician'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains("Investigator", case=False), 'clean_job_title'] = 'Investigator/Audit/Controller'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains("Audit", case=False), 'clean_job_title'] = 'Investigator/Audit/Controller'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains("Control", case=False), 'clean_job_title'] = 'Investigator/Audit/Controller'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains("Inspector", case=False), 'clean_job_title'] = 'Investigator/Audit/Controller'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains("Auditor", case=False), 'clean_job_title'] = 'Investigator/Audit/Controller'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains("Member", case=False), 'clean_job_title'] = 'Faculty Member/Team Member'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Educator', case=False),'clean_job_title'] ='Teacher/Trainer'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains("Limited Term Faculty", case=False), 'clean_job_title'] = 'Faculty Member/Team Member'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains("General Practitioner, Oncology", case=False), 'clean_job_title'] = 'Physician'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains("Psychologist/Psychologue", case=False), 'clean_job_title'] = 'Physician'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains("Faculty", case=False), 'clean_job_title'] = 'Faculty Member/Team Member'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains("Inspector", case=False), 'clean_job_title'] = 'Investigator/Audit/Controller'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains("Psychologist", case=False), 'clean_job_title'] = 'Physician'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains("Psychiatrist", case=False), 'clean_job_title'] = 'Physician'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains("Investigator / Enquêteur", case=False), 'clean_job_title'] = 'Investigator/Audit/Controller'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains("University Secretary", case=False), 'clean_job_title'] = 'Admin'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains("Biochemist", case=False), 'clean_job_title'] = 'Scientist'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains("Sr. Technical Eng./ Officer", case=False), 'clean_job_title'] = 'Engineer'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains("Epidemiologist", case=False), 'clean_job_title'] = 'Physician'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains("Surintendant de l'éducation", case=False), 'clean_job_title'] = 'Superintendent'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains("Surintendant", case=False), 'clean_job_title'] = 'Superintendent'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains("Supt. of Schools", case=False), 'clean_job_title'] = 'Superintendent'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains("Surintendant(e)", case=False), 'clean_job_title'] = 'Superintendent'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains("Paramédics", case=False), 'clean_job_title'] = 'Paramedic'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains("Registrar", case=False), 'clean_job_title'] = 'Admin'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Specialist', case=False), 'clean_job_title'] = 'Coordinator/Planner/Specialist'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Enseignement titulaire', case=False), 'clean_job_title'] = 'Teacher/Trainer'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Officer', case=False), 'clean_job_title'] = 'Officer'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Journeyperson', case=False), 'clean_job_title'] = 'Journeyperson'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Journeyman', case=False), 'clean_job_title'] = 'Journeyperson'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Training Service Representative', case=False), 'clean_job_title'] = 'Teacher/Trainer'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Conseillère', case=False), 'clean_job_title'] = 'Consultant'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Infirmière autorisée', case=False), 'clean_job_title'] = 'Nurse'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Hygienist', case=False), 'clean_job_title'] = 'Hygienist'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Provost', case=False), 'clean_job_title'] = 'Dean/Provost'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Vice_Pres', case=False), 'clean_job_title'] = 'VP'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Midwife', case=False), 'clean_job_title'] = 'Nurse'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Paediatrician', case=False), 'clean_job_title'] = 'Physician'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Psychological Associate', case=False), 'clean_job_title'] = 'Physician'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Psychologue', case=False), 'clean_job_title'] = 'Physician'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Psychometric', case=False), 'clean_job_title'] = 'Physician'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Trustee', case=False), 'clean_job_title'] = 'Trustee'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Coroner', case=False), 'clean_job_title'] = 'Coroner'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Fellow', case=False), 'clean_job_title'] = 'Physician'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Resident', case=False), 'clean_job_title'] = 'Physician'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Therapists', case=False), 'clean_job_title'] = 'Respiratory/Occupational/SocialWork'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Occupational', case=False), 'clean_job_title'] = 'Respiratory/Occupational/SocialWork'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Respirologist', case=False), 'clean_job_title'] = 'Respiratory/Occupational/SocialWork'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Secretary', case=False), 'clean_job_title'] = 'Admin'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Application', case=False), 'clean_job_title'] = 'IT'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Security Architect', case=False), 'clean_job_title'] = 'IT'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Programmer', case=False), 'clean_job_title'] = 'IT'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Programmer', case=False), 'clean_job_title'] = 'IT'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Solutions Architect', case=False), 'clean_job_title'] = 'IT'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Solution Developer', case=False), 'clean_job_title'] = 'IT'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Solution Designer', case=False), 'clean_job_title'] = 'IT'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Systems', case=False), 'clean_job_title'] = 'IT'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Web', case=False), 'clean_job_title'] = 'IT'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Technical', case=False), 'clean_job_title'] = 'IT'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Technology', case=False), 'clean_job_title'] = 'IT'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Telecommunications', case=False), 'clean_job_title'] = 'IT'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Tutor', case=False), 'clean_job_title'] = 'Teacher/Trainer'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Server', case=False), 'clean_job_title'] = 'IT'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Skilled', case=False), 'clean_job_title'] = 'Skilled Worker'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Trades', case=False), 'clean_job_title'] = 'Skilled Worker'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Tradesperson', case=False), 'clean_job_title'] = 'Skilled Worker'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Social Work', case=False), 'clean_job_title'] = 'Respiratory/Occupational/SocialWork'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Social Worker', case=False), 'clean_job_title'] = 'Respiratory/Occupational/SocialWork'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Software', case=False), 'clean_job_title'] = 'IT'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Assistant', case=False), 'clean_job_title'] = 'Admin'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Coord', case=False), 'clean_job_title'] = 'Coordinator/Planner/Specialist'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Co-ord', case=False), 'clean_job_title'] = 'Coordinator/Planner/Specialist'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Eng/', case=False), 'clean_job_title'] = 'Engineer'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Engr', case=False), 'clean_job_title'] = 'Engineer'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Mgmt.', case=False), 'clean_job_title'] = 'Manager'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Account,Exec.', case=False), 'clean_job_title'] = 'Manager'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('AcctExec', case=False), 'clean_job_title'] = 'Manager'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Consult.,', case=False), 'clean_job_title'] = 'Consultant'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('coor.,', case=False), 'clean_job_title'] = 'Coordinator/Planner/Specialist'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Coord.', case=False), 'clean_job_title'] = 'Coordinator/Planner/Specialist'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Welder', case=False), 'clean_job_title'] = 'Skilled Worker'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Webmaster', case=False), 'clean_job_title'] = 'IT'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Truck Driver', case=False), 'clean_job_title'] = 'Skilled Worker'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Worker', case=False), 'clean_job_title'] = 'Skilled Worker'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Handyworker', case=False), 'clean_job_title'] = 'Skilled Worker'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Vice-Provost', case=False), 'clean_job_title'] = 'Dean/Provost'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Vice presidente', case=False), 'clean_job_title'] = 'VP'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Vice-Pres.', case=False), 'clean_job_title'] = 'VP'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Vice-Pres.,Inst.', case=False), 'clean_job_title'] = 'VP'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Vice-President', case=False), 'clean_job_title'] = 'VP'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Heating', case=False), 'clean_job_title'] = 'Skilled Worker'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Custodian', case=False), 'clean_job_title'] = 'Skilled Worker'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('V.-P.,', case=False), 'clean_job_title'] = 'VP'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('utility', case=False), 'clean_job_title'] = 'Skilled Worker'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('UNIX', case=False), 'clean_job_title'] = 'IT'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Veterinarian', case=False), 'clean_job_title'] = 'Veteriniarian'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Veterinarian,', case=False), 'clean_job_title'] = 'Veteriniarian'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Veterinary', case=False), 'clean_job_title'] = 'Veteriniarian'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Veterinaire', case=False), 'clean_job_title'] = 'Veteriniarian'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Transport', case=False), 'clean_job_title'] = 'Skilled Worker'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Transit', case=False), 'clean_job_title'] = 'Bus Driver'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Tool', case=False), 'clean_job_title'] = 'Skilled Worker'
sunshine_data_df.loc[sunshine_data_df['clean_job_title'].str.contains('Support', case=False), 'clean_job_title'] = 'IT'
C:\Users\Danielle Spring\anaconda3\envs\PythonData\lib\site-packages\pandas\core\strings\accessor.py:101: UserWarning: This pattern has match groups. To actually get the groups, use str.extract. return func(self, *args, **kwargs)
# check dataframe data
sunshine_data_df.head()
# Review unique first names and count distinct names
sunshine_data_df['First Name'].value_counts()
# # Filter on david, ignore case sensitive strings and perform a count
# david=sunshine_data_df[sunshine_data_df['First Name'].str.contains('david', flags=re.IGNORECASE)]
# print(david["First Name"].value_counts().sum())
# david["First Name"].value_counts()
# # Filter on michael, ignore case sensitive strings and perform a count
# michael=sunshine_data_df[sunshine_data_df['First Name'].str.contains('michael', flags=re.IGNORECASE)]
# print(michael["First Name"].value_counts().sum())
# michael["First Name"].value_counts()
# Convert all sunshine_data_df['First Name'] to str.lower()
# df['Fruits'] = df['Fruits'].str.lower()
sunshine_data_df['clean_first_name']=sunshine_data_df['clean_first_name'].str.lower()
# sunshine_data_df.head(5)
#First step should be to trim white space to the left and right of string ---- strip() not working with this dataset????
# ...wrong location for code??????
# remove tab/new row etc
# sunshine_data_df["clean_first_name"] = sunshine_data_df["clean_first_name"].str.replace(' ',"")
# # Review cleaned_first_name for Dr combinations and
# dr=sunshine_data_df[sunshine_data_df["clean_first_name"].str.startswith('dr.')]
# mr=sunshine_data_df[sunshine_data_df["clean_first_name"].str.contains('mr ', 'mr. ')]
# miss=sunshine_data_df[sunshine_data_df["clean_first_name"].str.startswith('miss')]
# mrs=sunshine_data_df[sunshine_data_df["clean_first_name"].str.startswith('mrs')]
# ms=sunshine_data_df[sunshine_data_df["clean_first_name"].str.startswith('ms')]
# phd=sunshine_data_df[sunshine_data_df["clean_first_name"].str.contains('phd')]
# comma=sunshine_data_df[sunshine_data_df["clean_first_name"].str.contains(',')]
# period=sunshine_data_df[(sunshine_data_df["clean_first_name"].str.contains('. '))]
# white_space=sunshine_data_df[sunshine_data_df["clean_first_name"].str.contains(' ')]
# # Review cleaned_first_name for white space
# white_space=sunshine_data_df[sunshine_data_df["clean_first_name"].str.contains(' ')]
# white_space['clean_first_name'].value_counts()
reviewing first name character counts
# #Refresh character count on First Name column
# sunshine_data_df["first_char_count"] = sunshine_data_df['First Name'].str.len()
# Review cleaned_first_name based on character count
# char_one=sunshine_data_df[sunshine_data_df["first_char_count"]<=1]
# print(char_one['clean_first_name'].value_counts().sum())
# char_one['clean_first_name'].value_counts()
# Review cleaned_first_name based on character count
# char_two=sunshine_data_df[sunshine_data_df["first_char_count"]==2]
# print(char_two['clean_first_name'].value_counts().sum())
# char_two['clean_first_name'].value_counts()
# # Review cleaned_first_name based on character count
# char_three=sunshine_data_df[sunshine_data_df["first_char_count"]==3]
# print(char_three['clean_first_name'].value_counts().sum())
# char_three['clean_first_name'].value_counts()
# # Review cleaned_first_name based on character count
# char_three=sunshine_data_df[sunshine_data_df["first_char_count"]==4]
# print(char_three['clean_first_name'].value_counts().sum())
# char_three['clean_first_name'].value_counts()
Reviewing single initial First Names - can they be matched with a full name using historical data? --on hold due to time constrainst; rows to be deleted where only inital used as first name
# # Review records where clean first name has the initial "j"
# initial_j=char_one[char_one['clean_first_name']=='j']
# initial_j
# agostino=sunshine_data_df[(sunshine_data_df['Last Name']=='Agostino') & (sunshine_data_df['clean_first_name'].str.startswith('j'))]
# agostino
sunshine_data_df["clean_first_name"] = sunshine_data_df["clean_first_name"].str.split("dr.", expand=True)[0]
# # Iterate through the words in the "dr" list and replace them with an empty space, "".
md=['md-','md -', 'MD-', 'MD -', 'md']
for word in md:
sunshine_data_df["clean_first_name"] = sunshine_data_df["First Name"].str.replace(word," ")
# Cleaning First Name for punctuation with no space
# comma = [",", ", "," ,"]
punctuation=[ ",", "(" , ")"]
# Iterate through the words in list and replace them with an empty space, "".
for word in punctuation:
sunshine_data_df["clean_first_name"] = sunshine_data_df["clean_first_name"].str.replace(word,"")
# Cleaning First Name with titles and Replacing Substrings in a Python String to get the dr. still in dataset
period=["."]
for word in period:
sunshine_data_df["clean_first_name"] = sunshine_data_df["clean_first_name"].str.replace(word," ")
# Remove all text after a space
# example:'Bi Yi Jane' you get= Bi
sunshine_data_df["clean_first_name"] = sunshine_data_df["clean_first_name"].str.split(" ", expand=True)[0]
#change to extract text (right most)
# #Extract only text after first space
# sunshine_data_df['clean_alt_clean_first_name']=sunshine_data_df['First Name'].str.extract('(^[^\s]+)')
sunshine_data_df['clean_alt_first_name']=sunshine_data_df['First Name'].str.split(" ", expand=True)[1]
# Convert all alt_first name to str.lower()
# df['Fruits'] = df['Fruits'].str.lower()
sunshine_data_df['clean_alt_first_name']=sunshine_data_df['clean_alt_first_name'].str.lower()
#Create character count on First Name column
sunshine_data_df["clean_char_count"] = sunshine_data_df['clean_first_name'].str.len()
# Determine Final First Name
sunshine_data_df.loc[sunshine_data_df["clean_char_count"]>=3, 'final_first_name'] = sunshine_data_df["clean_first_name"]
sunshine_data_df.loc[sunshine_data_df["clean_char_count"]<3, 'final_first_name'] = sunshine_data_df["clean_alt_first_name"]
sunshine_data_df.loc[sunshine_data_df["final_first_name"]=='DR', 'final_first_name'] = sunshine_data_df["clean_alt_first_name"]
#Create character count on Final First Name column
sunshine_data_df["final_char_count"] = sunshine_data_df['final_first_name'].str.len()
# Convert all alt_first name to str.lower()
# df['Fruits'] = df['Fruits'].str.lower()
sunshine_data_df['final_first_name']=sunshine_data_df['final_first_name'].str.lower()
# Drop First Name rows with less than 2 characters
sunshine_data_df = sunshine_data_df.drop(sunshine_data_df[sunshine_data_df["final_char_count"] <2].index)
print(sunshine_data_df.shape)
#find null values----drops all records...wrong location of code
sunshine_data_df = sunshine_data_df.drop(sunshine_data_df[sunshine_data_df["final_char_count"].isnull()].index)
print(sunshine_data_df.shape)
indexes = sunshine_data_df[ (sunshine_data_df['final_char_count'] == 2) & (sunshine_data_df['clean_char_count']<=2) ].index
sunshine_data_df.drop(indexes,inplace=True)
print(sunshine_data_df.shape)
bracket=[ "(" , ")" , "''", " ' ", " ' ", "-" ]
# Iterate through the words in the "dr" list and replace them with an empty space, ""., ' " " '
for word in bracket:
sunshine_data_df["final_first_name"] = sunshine_data_df["final_first_name"].str.replace(word,"")
dr=[ "dr." ]
# Iterate through the words in the "dr" list and replace them with an empty space, "".
for word in dr:
sunshine_data_df["final_first_name"] = sunshine_data_df["final_first_name"].str.replace(word,"")
period=[ "." ]
# Iterate through the words in the "dr" list and replace them with an empty space, "".
for word in period:
sunshine_data_df["final_first_name"] = sunshine_data_df["final_first_name"].str.replace(word,"")
#replace ’ with space
sunshine_data_df["final_first_name"] = sunshine_data_df["final_first_name"].str.replace("’"," ")
#Refresh final First Name count
sunshine_data_df["final_char_count2"] = sunshine_data_df['final_first_name'].str.len()
# Drop First Name rows with less than 2 characters
sunshine_data_df = sunshine_data_df.drop(sunshine_data_df[sunshine_data_df["final_char_count2"] <=2].index)
print(sunshine_data_df.shape)
# # Filter on michael, ignore case sensitive strings and perform a count
skip=sunshine_data_df[sunshine_data_df['First Name'].str.contains('skip', flags=re.IGNORECASE)]
skip.head()
# print(michael["First Name"].value_counts().sum())
# michael["First Name"].value_counts()
# Drop First Name skip row
# sunshine_data_df = sunshine_data_df.drop(sunshine_data_df[sunshine_data_df["final_first_name"].str.contains(' "skip"')].index)
sunshine_data_df.drop(index=21592)
# print(sunshine_data_df.shape)
sunshine_data_df.tail()
#Create unique employee 'Last, First Name' column
#concatenate Last and First Name
sunshine_data_df["last_first_name"]=(sunshine_data_df["Last Name"]+"_"+sunshine_data_df["final_first_name"]).str.title()
sunshine_data_df.head()
#Make final first names first inital captial
sunshine_data_df["final_first_name"]=sunshine_data_df["final_first_name"].str.title()
# Create a distinct list of clean first names
first_names=sunshine_data_df['final_first_name'].unique()
# Create a Sunshine First Name Dataframe
sunshine_names_df=pd.DataFrame(first_names,columns=['first_name'])
unique_sunshine_name_sorted=sunshine_names_df.sort_values('first_name', ascending=True)
print(unique_sunshine_name_sorted['first_name'].value_counts().sum())
unique_sunshine_name_sorted
#Create gender and age columns
unique_sunshine_name_sorted['gender']=None
# unique_sunshine_name_sorted['age']=None
#Delete Skip
unique_sunshine_name_sorted=unique_sunshine_name_sorted.drop(index=1764)
unique_sunshine_name_sorted
#Delete funny Brian
unique_sunshine_name_sorted=unique_sunshine_name_sorted.drop(index=25358)
unique_sunshine_name_sorted
unique_sunshine_name_sorted.shape
# Reorder the columns in the sunshine_data DataFrame.
sunshine_data_df = sunshine_data_df.reindex(columns=['Calendar Year',
'Sector',
'city',
'clean_employer',
'Job Title',
'clean_job_title',
'last_first_name',
'Last Name',
'final_first_name',
'gender',
'Salary Paid',
'salary_bin',
'Taxable Benefits',
'total_compensation']
)
# # Rename the columns in the sunshine_data DataFrame.### changed to match 2020 data
sunshine_data_df.rename({'Calendar Year':'year',
'Sector':'sector',
'city':'city',
'clean_employer':'employer',
'Job Title':'sunshine_job_title',
'clean_job_title':'job_title',
'last_first_name':'last_first_name',
'Last Name':'last_name',
'final_first_name':'first_name',
'gender':'gender',
'Salary Paid':'salary_paid',
'salary_bin':'salary_bin',
'Taxable Benefits':'taxable_benefits',
'total_compensation':'total_compensation'
}, axis='columns', inplace=True)
from sqlalchemy import create_engine
from getpass import getpass
# from config import db_password
# db_password = 'db_password'
db_password = getpass ('Enter in Password')
#connect to local server
db_string = f"postgresql://postgres:{db_password}@127.0.0.1:5432/Final_Project_SunshineList"
#Create database engine
engine = create_engine(db_string)
# #Import Sunshine First Name table into SQL table to be pulled by ML
unique_sunshine_name_sorted.to_sql(name='ml_first_names', con=engine, index=False)
#Import Sunshine table into SQL table
sunshine_data_df.to_sql(name='sunshine_table', con=engine)