calling API from US census data on county, year and NAICS level

[Tariq Abdullah]

I'm trying to call BDS ( Business Dynamics Statistics ) data using the following API for multiple years from 2000-2008 on county and NAICS levels. But, unfortunately, the above API is returning data for multiple years only on the county level. It's not returning me the NAICS.

My research goal is to find how many establishments are there in a particular county in a specific year for a specific NAICS. Without knowing the NAICS my research goal remains incomplete.

Would you be kind enough to look at this API to give me feedback on what I'm doing wrong or could edit it to make it work? Here is the link where census is guiding how API can be created :

https://www.census.gov/data/develope...-dynamics.html

I apologize knowing that this is not STATA related but have been struggling with this , and despite reaching out to the concerned authority hasn't been responded by them yet. If anyone has a considerable experience regarding API of US census , would anyone like to help me out ?

https://api.census.gov/data/timeseries/bds?get=NAME,YEAR,FIRM,ESTAB,ESTABS_ENTRY,ESTABS_EXIT,FIRMDEATH_EMP,FIRMDEATH_ESTABS,FIRMDEATH_FIRMS,JOB_CREATION,JOB_CREATION_BIRTHS,JOB_CREATION_RATE,JOB_DESTRUCTION,JOB_DESTRUCTION_DEATHS,NET_JOB_CREATION,REALLOCATION_RATE,NET_JOB_CREATION_RATE,EMP&for=county:*&in=state:*&time=from+2000+to+2008&for=NAICS:*

[Daniel Schaefer]

Hi Tariq,

Unless I'm misunderstanding something, it seems like you might be looking for something like this:

https://api.census.gov/data/timeseries/bds?get=NAME,YEAR,FIRM,ESTAB,ESTABS_ENTRY,ESTABS_EXIT,FIRMDEATH_EMP,FIRMDEATH_ESTABS,FIRMDEATH_FIRMS,JOB_CREATION,JOB_CREATION_BIRTHS,JOB_CREATION_RATE,JOB_DESTRUCTION,JOB_DESTRUCTION_DEATHS,NET_JOB_CREATION,REALLOCATION_RATE,NET_JOB_CREATION_RATE,EMP&for=county:*&in=state:*&time=from+2000+to+2008&NAICS=*

This API request URL gives the NAICS code as the third-from-last column.

[Tariq Abdullah]

Words will fall short for this wonderful coding and thoughtful guidance ! Despite reaching out to several people before posting here, didn't get the direction I needed. This is just the direction I need , and now I can start exploring the data according to the need of my research objective!

Much obliged for your time and kind consideration!