A draft manuscript entitled Cracking an Open Safe: Extracting HAZUS’s Building Inventory to a Single Table, available here, explains how one can "denormalize" the HAZUS building inventory, i.e., merge 15 linked tables from 2 mdb files on the HAZUS data DVDs into a single table that lists, for each combination of census tract, occupancy class, earthquake structure type, and seismic design level: the total estimated square footage (1000s of sf), building value ($1000s in 2003), content value ($1000s in 2003), number of occupants at 2 PM, number of occupants at 2 AM, and number of occupants at 5 PM. Only combinations with nonzero values are tabulated.

The process is automated in a beta-version Microsoft Access database, also available here, containing a number of supporting tables, links to the 15 HAZUS-MH tables (the user needs to supply the proper HAZUS-MH DVD and update the links in a process detailed in the manuscript), plus 59 scripted query language (SQL) queries and a macro to perform them all in sequence. It helps to turn off all confirmations before running the macro.