Draft manuscript submitted to Earthquake Spectra July 2009 

It can be valuable to perform seismic risk studies of buildings at the societal level, which requires an inventory of the building stock exposed to damage. HAZUS-MH offers a nationwide default building-stock inventory, but it can be difficult to use outside of HAZUS-MH (as is sometimes desirable): it is encoded in 15 tables in 2 Microsoft Access databases for each of 50 states. A new Microsoft Access database is developed here that links to the HAZUS-MH tables, and includes 54 scripted query language (SQL) queries, a macro to perform them all, and a number of supporting tables, for the purpose of extracting the HAZUS-MH inventory to a single de-normalized table, which is more practical for use by PAGER and some other applications. The table shows by census tract, county or state: square footage of construction, building value, content value, and number of indoor occupants at 2 PM, 2 AM, and 5 PM. The quantities are distributed by HAZUS-MH occupancy classification, structure type, and design level. The database and results for several states are available in the software download section of www.risk-agora.org.