Sorting or searching by Universe

Hi everyone, I'm working with ACS 2013 5-year estimates at the census tract level. I am wondering if there is a way to search the FactFinder by Universe and, if so, how that can be done? I would like to create ratios using raw numbers that I'm finding in FactFinder tables, however, these come from different Universes (ie, the numerator I want to use is drawn from the "Civilian noninstitutionalized population" Universe, and the denominator I want to use is drawn from "Families"). Any thoughts, comments, or suggestions are appreciated! Thank you.
Parents
  • Alicia, I have attached a file that should help with your search. I modified the table sequence file so that each Table Title and the associated Universe comprise one record. I then sorted by Universe and Subject Area so you can identify variables that reside within your chosen Universe and use the Table ID to find the table.


    [Updated on 6/19/2015 11:20 AM]

    Just noticed that I did not trim all of the leading spaces from the Universe field so that the sorting went haywire. This has been corrected in the attached file.
Reply
  • Alicia, I have attached a file that should help with your search. I modified the table sequence file so that each Table Title and the associated Universe comprise one record. I then sorted by Universe and Subject Area so you can identify variables that reside within your chosen Universe and use the Table ID to find the table.


    [Updated on 6/19/2015 11:20 AM]

    Just noticed that I did not trim all of the leading spaces from the Universe field so that the sorting went haywire. This has been corrected in the attached file.
Children
No Data