Updated 2020-06-17
The Urban Institute has automated the process of reading in and cleaning the Pulse Survey Public Use Microdata files as they are released each week. We have combined all the available Public Use File across all weeks into one standardized CSV (Public Use File All Weeks.csv
) and generated a rolling two week summary file (Two Week Rolling Avg Pulse Metrics.csv
). that powers the Tracking COVID-19’s Effects by Race and Ethnicity feature. These datasets will be updated weekly as new Public Use Files are released. Below is a description of all the files we have made available
-
Public Use Files All Weeks.csv
: A compiled CSV of public use files from all available weeks.. The file structure will be very similar to the Census published files, but will have a few new columns appended. Each row represents a respondent from a given week. Please take careful note of thepweight
column which is the person weight assigned by the Census to each respondent. Any metric you create from the data has to sum across thepweight
column to arrive at the individual level estimates. For additional help understanding what each of the columns in this file represent, please see the Data Dictionary files below. -
PUF Census Data Dictionary.
: The Data Dictionary as provided by the Census for the latest week in the data. This will be exactly the same as the Census published data dictionary files. Note a couple of the Urban appended columns will not be in the Data Dictionary. For definitions of the appended columns, please see the PUF Urban Data Dictionary file -
PUF Urban Data Dictionary
: Urban has appended a few columns to the publicly available Public Use File. This file contains the descriptions of those appended columns. This file in conjunction with the PUF Census Data Dictionary should allow you to understand what each column means in thePublic Use File All Weeks
file.
If you have any questions, please reach out to [email protected]
Data and Resources
Field | Value |
---|---|
Modified | 2022-08-01 |
Release Date | 2020-06-09 |
Identifier | 58f0e1a4-8fec-4918-be37-83741498cb9a |
License | |
Contact Name | Urban Institute |
Contact Email | |
Public Access Level | Public |
Field | Value |
---|---|
Data Dictionary Files | |
Geographic Level | |
Original Data Source | |
Github Repo | |
Citation Requirements | Urban Institute. 2020. Revisions. Accessible from https://datacatalog.urban.org/dataset/census-pulse-public-use-files-ques.... Data originally sourced from Census Household Pulse Survey, developed at the Urban Institute, and made available under the ODC-BY 1.0 Attribution License. |