Climate, Crime, and Reddit Sentiment Data for Canadian Prairie Cities: Edmonton, Saskatoon, Regina, and Winnipeg (2009–2025)

This dataset supports the article "Climate Variability, Urban Crime, and Public Perceptions of Safety: A Social Media Sentiment Analysis of Canadian Prairie Cities" submitted to Computers, Environment and Urban Systems (Special Issue: Open Urban Data Science). The archive contains 17 processed CSV files across three data streams: (1) daily, monthly, and yearly climate observations from Environment and Climate Change Canada for Edmonton, Saskatoon, Regina, and Winnipeg (2010–2025), including temperature, relative humidity, precipitation, and derived thermal indices; (2) police-reported crime statistics from the Statistics Canada Uniform Crime Reporting Survey for all four cities (2010–2024), covering violent crime, property crime, and total Criminal Code violations; and (3) Reddit sentiment data from city-specific subreddits stratified into five analytically distinct eras (2009–2025), including post-level VADER compound sentiment scores, categorical sentiment labels, crime-relevance classification, and geospatial coordinates for mapping. All data are processed, imputed, and analysis-ready. Raw data were sourced from publicly available government and social media archives.本数据集为提交至《Computers, Environment and Urban Systems》（特刊：开放城市数据科学）的论文《气候变异性、城市犯罪与公众安全感知：加拿大草原城市社交媒体情感分析》（原文标题：Climate Variability, Urban Crime, and Public Perceptions of Safety: A Social Media Sentiment Analysis of Canadian Prairie Cities）提供支撑。该数据档案包含三类数据流，共计17个经预处理的CSV文件： 1. 加拿大环境与气候变化部（Environment and Climate Change Canada）针对埃德蒙顿、萨斯卡通、里贾纳及温尼伯2010年至2025年的逐日、逐月及逐年气候观测数据，涵盖气温、相对湿度、降水量及衍生热指数； 2. 加拿大统计局（Statistics Canada）统一犯罪报告调查中上述四市2010年至2024年的警方报案犯罪统计数据，覆盖暴力犯罪、财产犯罪及《加拿大刑法》规定的全部刑事违规行为； 3. 来自各城市专属Reddit子版块的情感数据，按五个分析特征明确的时代区间分层（2009年至2025年），包含帖子级VADER复合情感得分、分类情感标签、犯罪相关性分类结果及用于制图的地理空间坐标。 所有数据均经过处理、缺失值插补，可直接用于分析。原始数据均取自公开可获取的政府及社交媒体档案。