ETL-pipline-automated

Dataset

Content	Refresh Rate	Columns	Link
Population / Crime	Annually	ASSAULT, AUTOTHEFT, BIKETHEFT, BREAKENTER, HOMICIDE, ROBBERY, SHOOTING, THEFTFROMMV, THEFTOVER, Years: 2014-2023	https://open.toronto.ca/dataset/neighbourhood-crime-rates/
Housing Affordability	Quarterly	Quarter, Subsidized Housing Units, Affordable Housing Units	https://open.toronto.ca/dataset/active-affordable-and-social-housing-units/
Places of Interest and Toronto Attractions	As available	ADDRESS_INFO, NAME, CATEGORY, GEOID, ADDRESS_FULL, POSTAL_CODE, MUNICIPALITY, CITY, WARD, WARD_2003, WARD_2018, geometry	https://open.toronto.ca/dataset/places-of-interest-and-toronto-attractions/
Amenities	Monthly	LOCATIONID, ASSET_ID, ASSET_NAME, TYPE, AMENITIES, ADDRESS, geometry	https://open.toronto.ca/dataset/parks-and-recreation-facilities/
Large Industrial & Commercial Properties	Monthly	site_name, district, closest_major_intersection, status, property_type_primary, total_site_area_acres, sq_ft_available, asking_price, planning_status, planning_status_zoning, planning_status_city_ward, geometry	https://open.toronto.ca/dataset/toronto-signature-sites/
Census of Population	Every 5 years	Category, Topic, Characteristic, City of Toronto, Neighborhoods	https://open.toronto.ca/dataset/neighbourhood-profiles/
EarlyON Child and Family Centres	Daily	loc_id, program_name, languages, address, major_intersection, ward, lat, lng, geometry	https://open.toronto.ca/dataset/earlyon-child-and-family-centres/
Air Conditioned and Cool Spaces	Daily	locationId, locationTypeCode, locationTypeDesc, locationName, address, geometry	https://open.toronto.ca/dataset/air-conditioned-and-cool-spaces-heat-relief-network/
Outbreaks in Toronto Healthcare Institutions	Weekly	Institution Name, Institution Address, Outbreak Setting, Type of Outbreak, Date Outbreak Began, Date Declared Over, Active	https://open.toronto.ca/dataset/outbreaks-in-toronto-healthcare-institutions/
Marriage Licence Statistics	Monthly	CIVIC_CENTRE, MARRIAGE_LICENSES, TIME_PERIOD	https://open.toronto.ca/dataset/marriage-licence-statistics/
Tennis Courts Facilities	As available	ID, Name, Type, Lights, Courts, LocationAddress, WinterPlay, geometry	https://open.toronto.ca/dataset/tennis-courts-facilities/