U.S. Census Demographics + Geospatial Boundaries — Free Dataset
收藏Snowflake2025-09-30 更新2025-10-01 收录
下载链接：
https://app.snowflake.com/marketplace/listing/GZ1M6ZYDCF2
下载链接
链接失效反馈官方服务：
资源简介：
Get a free sample of **Census Galaxy**, No Fret Data’s Data-as-a-Service platform that makes U.S. Census demographics and geospatial boundaries easy to use. This demo includes curated fields across income, education, housing, and population, along with ready-to-use polygons and centroids for mapping.
It’s designed to be **plug-and-play** for AI/ML models, analytics, and geospatial projects—no cleanup required. Install it instantly and explore how Census Galaxy can power segmentation, targeting, and market insights at scale.
Use Cases Include:
- Quick testing in AI/ML workflows
- Audience segmentation and marketing demos
- Geospatial joins and mapping
- Site selection & market research trials
- Academic and classroom use
提供机构：
No Fret Data
创建时间：
2025-09-25
原始信息汇总
U.S. Census Demographics + Geospatial Boundaries — Free Dataset
数据集概述
- 数据集名称：U.S. Census Demographics + Geospatial Boundaries — Free Dataset
- 提供商：No Fret Data
- 访问权限：免费
- 访问模式：Unlimited Access
- 数据刷新频率：Annually
- 地理覆盖范围：USA (All States), American Samoa, Guam, 52 More
- 覆盖粒度：By postal code
数据内容
- 数据表名称：AM_DEMO_2023_ZIP
- 数据特征：AI/ML-ready Census demographics & spatial insights at ZIP level
- 包含字段：收入、教育、住房、人口等精选字段
- 空间数据：包含可直接使用的多边形和质心点用于地图绘制
- 数据特点：无需清洗即可使用的即插即用数据
主要应用场景
受众细分
- 利用邮政编码级别的变量进行精准分组和目标受众定位
- 适用场景：营销人员构建人口统计集群和客户相似模型
位置规划
- 支持选址、区域优化和地理扩展
- 适用场景：房地产、零售和市政规划
机器学习
- 使用丰富的标准化人口统计输入训练机器学习模型
- 特征：百分位数和分层桶有助于减少偏见并提高预测性能
使用示例
按家庭收入中位数查询华盛顿特区前5个邮政编码
sql SELECT "ZipCode", "CityStateAbbrev", "TOTAL_POPULATION", "MEDIAN_HOUSEHOLD_INCOME", "ZipCodePolygon" FROM "2023".AM_DEMO_2023_ZIP WHERE "StateAbbrev" = DC AND "MEDIAN_HOUSEHOLD_INCOME" IS NOT NULL AND "ZipCodePolygon" IS NOT NULL ORDER BY "MEDIAN_HOUSEHOLD_INCOME" DESC LIMIT 5;
按教育程度与贫困水平比较邮政编码排名
sql SELECT "ZipCode", "CityStateAbbrev", "TOTAL_POPULATION", "POPULATION_DENSITY", "DEGREE_HOLDERS", "DEGREE_HOLDERS_PRCNTGE", "POP_BELOW_POVERTY_LEVEL_PRCNTGE" FROM "2023".AM_DEMO_2023_ZIP WHERE "DEGREE_HOLDERS_PRCNTGE" IS NOT NULL AND "TOTAL_POPULATION" > 5 ORDER BY "DEGREE_HOLDERS_PRCNTGE" DESC;
技术规格
- 云区域可用性：AWS Africa (Cape Town), Asia Pacific (Jakarta), Asia Pacific (Mumbai), Asia Pacific (Osaka) 等46个区域
- 法律条款：Standard
分类标签
- AI & ML
- Audience Segmentation
- Demographics
- Geospatial
- Location Planning
- Machine Learning
