ACS Data Users Group

I am a vocational expert and need this information (full time employment percentages for jobs in the national economy). In a training seminar tables were distributed that were allegedly produced by the Bureau of the Census. I received directions to access the Bureau's site, and was not able to find such tables. I called the bureau and the Representative suggested I join the ACS Data Users Group. I joined, I have not yet found these tables and I was recommended to express my need to find such tables, that identify the percentages for full time employment for jobs in the national economy. I was recommended to express my search here in the discussion forum.

There's nothing to discuss, I need to find the table that lists full time employment numbers. Help!

Can you give more details ? What do you mean by "jobs?" Do you want the data broken out by Industry (eg NAICS code) and Occupation code ? What geography do you want ? The entire US ? A state ? etc. What do you mean by full time ? 35 hours or more per week?

Here is one table at data.census.gov

https://data.census.gov/table/ACSST1Y2023.S2402?q=Employment

Dave Dorer

Dave, When I research job numbers, one of the components I need so that I am reporting as accurately as possible, is a percentage of workers who work full time. The two key details in the ACS table I look for are the SOC Standard Occupational Classifications guide Job Title Code number (SOC Code), and the percentage of full time workers for that job. For example, the ACS Chart I am looking at has a SOC Code aggregate number of 41-2010. The job of Cashier is in this group. The ACS Table says workers in this aggregate 41-2010 have a full time worker percentage of 22.3%. I received the chart from a training seminar. I was given the ACS Site and told it would be easy to obtain updates. First thing I did was go to the site but could not find the chart. Then I contacted the Bureau of the Census and they could not help, oblivious to what I need, and they suggested I join the ACS Data Users Group. So here I am. This data exists, but I can't find it and no one else appears to be able. I tried to be general so that at least someone would respond, and one person did. I hope others in this forum can read our conversation here. Thank you!

Dave,

I may have another problem. When I went to the tables you recommended, I was on a compound page with multiple information and I could not find or open an intelligible table. I may just need assistance opening any table correctly. I don't know where to click to see the chart.

Dear Adolph,

You might look at the PUMS (public use microdata) codebook to see what "raw" variables are available for the ACS. The tables on data.census.gov come from the PUMS data, except the PUMS data is a sample from the "raw" ACS responses. There are multiple industry occupation variables/codes.

www2.census.gov/.../2019_2023ACS_PUMS_User_Guide.pdf

As far as data.census.gov goes, close the left panel with the << click on the << and it will close the "window" and show the entire table. There are scroll bars at the bottom and side of the right panel/window so you can scroll down and across the table. Sometimes it is hard to see/find the scroll bars. Move the cursor around.

You can also get the data from the appropriate PUMS data file and make your own table but you need to use a statistical package.

If you work for a non-profit or government agency/entity email info@dorerfoundation.org and we can continue via email.

Dave

If you plan on using Census data regularly, it might also be helpful to use some of the rich Census user information resources, such as this, this, and this.

Ask the seminar leaders for the specific data product (ACS, CBP, etc) and the table ID numbers that they used for the training materials. That will make finding those tables much easier.

Table ID numbers? I will ask the colleague who attended the training to back track and see if he can get the Table Number.

Yes, every table that the Census Bureau publishes has an ID number or code. For example, in the ACS, Sex by Age by Nativity and Citizenship Status is table B05003. Another example in David's comment above, S2402 Occupation by Sex for the Full-Time, Year-Round Civilian Employed Population 16 Years and Over. S2402 is the table ID.

Is there a directory where all the codes are listed?

Sure, for ACS tables you can check the Table List or Table Shells files

https://www.census.gov/programs-surveys/acs/technical-documentation/table-shells.html

But for your question, you still need to know which tables they got the data from