Hello,
Has IPUMS published any (Postgre)SQL schema/table layouts for using its data in database form?
Hello,
Has IPUMS published any (Postgre)SQL schema/table layouts for using its data in database form?
We don’t have resources for this, nor am I aware of others who do. If you find anything, you are welcome to post it here in case others are interested.
I know it’s been a while now, but I built a program, ipums2db, which can generate database schema (Postges and other RDBMS supported) from an IPUMS extract DDI (e.g., “.xml“) file. You can also generate a full dump, row insertions included, assuming you have fixed-width data.