Row 1667

Row ID: 1667 | Dataset Entry | Axioma AXP Content Repository

Content Data

This page contains data entry 1667 from the Axioma AXP content repository. The structured data below represents the complete record for this entry.

Dear economists,

I am a Ph.D. student and want to extract some county-level data from the US census (such as average income, education, etc.). However, I have a hard time interpreting the US Census data. I have tried US Census data, ACS, and IPUMS and have been confused by all. For example, take into account IPUMS data: why some countyfips are zero?! or why some hhincomes are 9,999,999?!

Do you know any paper with published codes where I can find how economists extract county-level data from related data sources? Or do you know any good references explaining the confusion of such sources?

[IPUMS snapshot](https://preview.redd.it/7s4pllqrf3fa1.jpg?width=1522&format=pjpg&auto=webp&s=79effefc2386784c2e6cda28816de4fe0abbdfc3)

​

Or take into account ACS data:

FieldValue
text Dear economists, I am a Ph.D. student and want to extract some county-level data from the US census (such as average income, education, etc.). However, I have a hard time interpreting the US Census data. I have tried US Census data, ACS, and IPUMS and have been confused by all. For example, take into account IPUMS data: why some countyfips are zero?! or why some hhincomes are 9,999,999?! Do you know any paper with published codes where I can find how economists extract county-level data from r…
label r/econpapers
dataType post
communityName r/EconPapers
datetime 2023-01-30
username_encoded Z0FBQUFBQm5LakwwWm96MUN3YlZUNGIxVHRvUTY2eHNZcXZPOUNDUGJMVTZtbDBNRWRVWnhBVnU2WlhYdllsVXlkakxCY0tVMUFhanhsWExBcW1GSTVPd3pXNGV1TkNVb2c9PQ==
url_encoded Z0FBQUFBQm5Lak9EX2hTbHlZUHRTYkJkcUdfTDVSbE9aVkZwWVp5bVo2T0F2OGExSmxsY0ZNU1VxMlktY0tjeW9WNk1PWGIxaF8yYUdjaTNCR080UURjN3NoNG1ULXJjLWluV3FidGJubk8yWFhXdDd0LWhMUzlDNzRFVDc5UkhOMXAwNUZIT0ViU2Z0ZVY3ZXJxRWQ2Tmw3RGlWWUF0X250WHNaOVRjbzRrOHVhdnBubUNiNWkzNnAwTC1XWVZ1LUxlYWdOQ2Vjb2FxODFjS0hUNmRCdURGZ250amEtMnprQT09

Raw Record

{
  "text": "Dear economists,\n\nI am a Ph.D. student and want to extract some county-level data from the US census (such as average income, education, etc.). However, I have a hard time interpreting the US Census data. I have tried US Census data, ACS, and IPUMS and have been confused by all. For example, take into account IPUMS data: why some countyfips are zero?! or why some hhincomes are 9,999,999?!\n\nDo you know any paper with published codes where I can find how economists extract county-level data from related data sources? Or do you know any good references explaining the confusion of such sources?\n\n[IPUMS snapshot](https://preview.redd.it/7s4pllqrf3fa1.jpg?width=1522&format=pjpg&auto=webp&s=79effefc2386784c2e6cda28816de4fe0abbdfc3)\n\n​\n\nOr take into account ACS data:",
  "label": "r/econpapers",
  "dataType": "post",
  "communityName": "r/EconPapers",
  "datetime": "2023-01-30",
  "username_encoded": "Z0FBQUFBQm5LakwwWm96MUN3YlZUNGIxVHRvUTY2eHNZcXZPOUNDUGJMVTZtbDBNRWRVWnhBVnU2WlhYdllsVXlkakxCY0tVMUFhanhsWExBcW1GSTVPd3pXNGV1TkNVb2c9PQ==",
  "url_encoded": "Z0FBQUFBQm5Lak9EX2hTbHlZUHRTYkJkcUdfTDVSbE9aVkZwWVp5bVo2T0F2OGExSmxsY0ZNU1VxMlktY0tjeW9WNk1PWGIxaF8yYUdjaTNCR080UURjN3NoNG1ULXJjLWluV3FidGJubk8yWFhXdDd0LWhMUzlDNzRFVDc5UkhOMXAwNUZIT0ViU2Z0ZVY3ZXJxRWQ2Tmw3RGlWWUF0X250WHNaOVRjbzRrOHVhdnBubUNiNWkzNnAwTC1XWVZ1LUxlYWdOQ2Vjb2FxODFjS0hUNmRCdURGZ250amEtMnprQT09"
}
Explore Dataset Explore Row

Entry Information