Exploring Census Data Webinar Series- Expanding Your Markets Using International Trade Data

welcome and thank you for standing by at this time all participants will be in a listen-only mode into the question and answer session of today’s call at that time you may press star 1 to ask a question from the phone lines I know like we’re trying to call over to your host miss Linda Lee thank you you may begin good afternoon everyone my name is Linda Lee and thank you for attending today’s webinar I want to welcome everyone to our new series on exploring census data first in the series today is our international trade data today’s webinar will be presented by mr. Andy hey Andy is a senior economist here at the Census Bureau with over 30 plus years of experience in a moment Andy will be presenting practical ways to use our international trade data to expand your business and you will also be showing you how to obtain the data using the available data tool before we begin let me give you a quick look into our series the exploring census data webinar series consists of six webinars presented monthly on popular topics on the right side of the screen we have included the upcoming topics and session dates other items consistent throughout the series is the use of real-life case scenarios to illustrate practical ways to use the data each of the webinars in the series is presented by subject matter experts with the opportunity for Q&A at the end of each session and if you missed the webinar want to refer a colleague to a session you found to be helpful or simply would like to view it again each of the session will be recorded and posted at the link provided here archive for you as well is our 2018 series where you will be able to obtain the slide transcripts and recordings so let’s begin with general information about the Census Bureau the Census Bureau is the federal government’s largest sophistical agency we conduct over 130 surveys each year with some of our highly visible programs such as the decennial the American communities our and the economic census listed here out of these 130 plus surveys over 50 of them collect business data now when it comes to our data a pyramid is a good illustration of the relationship between details and timeliness in general the more timely the data the less detail but that being said the economic census is a periodic survey that takes place every 5 years it is illustrated at the bottom of the pyramid because it is the most comprehensive program when you are looking for business data the international trade data you will see today is timely and is categorized at the very top of the pyramid on the next slide I’m going to show you a general overview of the decennial census the primary purpose of the 2020 decennial census is to collect data on population and housing but there are many other important purposes the data from the 2020 health withdrawing congressional and state legislative district school districts and voting precincts distributing billions of dollars annually in funding to state and local communities these outcomes affect every person in the United States which is why it’s important that we have a complete and accurate census since the 2020 census will touch our lives in the near future here’s a timeline on our activities so you can know what’s coming down the road in March of next year households will be receiving an invitation to participate and respond as you can see from the timeline reminders will be delivered to those who may have missed the initial mailing every household will have the option of responding online by phone or by mail what you can do to get involved to help make the 2020 census a complete and accurate accurate count of the nation’s people you can actively support and spread the word about completing your 2020 census in your community you can learn more about approximately 500,000 temporary census jobs that may become available in the spring of 2020 you can also remind others that it’s important easy and safe lastly you could join your local complete count committee and lend your expertise to ensure that all areas of your community are accurately counted in 2020 and at this point I would like to turn the presentation over to Andy Haight who will discuss today’s webinar on international trade great thank you so much Linda so again my name is Andy Haight I’m an economist here at the Census Bureau today we’re going to be focusing on the information

that the Census Bureau has on international trade we’re gonna take sort of two ways of looking at these data first we’re gonna relate how US manufacturers could utilize our exports data to identify markets for their products or services let’s pretend we’re gonna pretend today that we are an automotive manufacturer or our most part manufacturer who currently has customers in the United States for their products but is looking to expand that market to other areas and could actually use the exports data to potentially identify countries that they might be exporting their data to their products do second we’ll look at the wholesale trade sector and we’ll relate how US wholesalers could actually utilize the imports data that are available from our international trade program to identify potential suppliers for their business these wholesale businesses often purchase goods from the United States from businesses where there are manufacturing the US but very often knowing something about the imports of the types of products that they that they resell would be in foot would be informative they might discover markets to buy their products from that they then sell the US case we’re going to follow today is the automotive parts industry but it is important to note that the international trade and we publish at census covers nearly every manufacturing industry down to the four digit NACE code level it also covers the mining sector and the agriculture sector so while we’re going to be focusing today as our example on our automotive parts industry the same type of be available for many many other industries so let’s get started by thinking about manufacturing in the United States one of the key surveys that we publish at the Census Bureau that covers the manufacturing sector is the annual survey of manufacturers this annual program provides data on the manufacturing sector for manufacturing businesses that have at least one paid employee therefore it wouldn’t cover the non employer businesses data from the annual survey of manufacturers are shown at both the national and state level national level data is shown at the full two through six digit names code levels while the state state data are only shown down to the two through selected four digit codes on the right-hand side of the slide I’ve pulled some key statistics for this particular industry from the annual survey of manufacturers where you can see that over five hundred and thirty-nine thousand people are employed by this industry in the United States they reported over twenty nine point four billion dollars in annual payroll and reported more than 260 billion dollars in value of shipments so this is obviously a quite important industry here in the United States the bats that you’re seeing here on the slide now reflect some information from one of our data tools on this industry called census business builder in the upper left hand corner we have a screen shot looking at information on the number of employees total employment in the motor vehicle and parts manufacturing for our scenario today we’re going to pretend that we are in auto parts manufacturer in the state of Michigan clicking on that particular state you can see it’s highlighted on the map allows us to see that there’s over a hundred and nineteen thousand employees that work in the automobile motor vehicle parts manufacturing industry in Michigan in the bottom right hand corner we have a screen shot of the map looking at the data for the motor vehicle manufacturers so these very often are the customers of motor vehicle parts manufacturers so if I was manufacturing parts in Michigan I would might maybe want to find out where are all the motor vehicle manufacturers in the US and as you can see the states that are big that are highlighted in blue from the from the motor vehicle parts manufacturing perspective align fairly well with where the motor vehicle manufacturers are actually located you see the states in the Michigan Ohio Indiana Illinois area you see this big dominance of motor vehicle manufacturing in California and you see the other kind of alignments thinking about our automotive parts manufacturer in Michigan I’ve also included some statistics from the annual survey of manufacturers that compare the state of Michigan to all of these other to the other states the other top states and as you can clearly see Michigan substantially dominates the motor vehicle parts manufacturing industry in this in the United States so our US automobile motor vehicle parts manufacturer is probably shipping their products to these types of businesses motor vehicle manufacturers for example but perhaps they’re interested in

finding out other markets where else could I be selling the parts that I make so we’re gonna drill down a little bit and we’re gonna look at specifically a certain type of motor vehicle part the chart you see here on the slide identifies the detailed product data that we publish in the annual survey of manufacturers on the individual products manufactured by motor vehicle parts manufacturers these include things like gasoline engines Earring and cysts and suspension of components transmissions of metal stamping for the purposes of our demo today we’re gonna focus on the seating and interior trim product we’re gonna look at how much of these parts are made the United States and then we’re gonna look at what are the exports of these types of products and where are those exports going so thinking about where this automobile manufacturer a parts manufacturer could be exporting their products so the key data program the Census Bureau that provides information our imports and exports is the US international trade in goods and services report this report provides data on a monthly and an on an annual basis on US exports data are shown at the two through four digit Naik’s codes or NICs based codes and at the national level we do have some data down to the sixth digit data are also shown by commodity and this is a key dimension of the trade data sometimes it’s interesting to look at not just the shipments of industries but also specific cup commodities and finally the third major dimension that this program provides data for is by the country that these exports are going to data are published in the spin from the survey at the national state district and even port levels and we’ll actually drill down and look a little bit at the port level data that our manufacturer might want to use to determine if I decide to export byproducts to one of these countries what might be a good port for me to export them to so we’ll go on the right-hand slide I pulled some key data from our international trade report on the exports value of products manufacturer for businesses classified in makes three three six three again our motor vehicle parts manufacturing industry we can see that over fifty-seven point 1 billion dollars worth of products are exported with about ten point four billion of those exported by vessels and about four point four billion of them exported by air we can see that over a billion kilograms of of these particular industries are are exported by vessels and a hundred and twenty seven point two million kilograms of these products are exported by air so where can we go to actually get this detailed exports data so the key tools that that are are data released in is a tool called USA trade online in the upper left hand corner I have a screen shot of the USA trade online sign in page but I’ve also included the you are at the bottom of the slide where you can go in to actually sign into this tool and to get help USA trade online is a free service you do not need to pay for it you do however do need to sign up and I would really encourage all of you to check out this tool it’s an amazing resource go in sign up for the service and then you can log in once you log in to USA trade online you come to a menu that you see in the bottom left-hand corner of the slide and this is our datasource selection menu where you get to choose what types of information are you interested in in this particular case we are interested in state export data by Naik’s so you can see the third row down in the table is the state export data origin of movement data are published both by HS code which is the harmonized system code as well as on the namespaces North American industry classification system again for the purposes of our demo today we were interested in looking at exports for mixed code three three six three so I went ahead and I clicked on that Naik’s link and on the right hand side is a screenshot of what the table looks like once you’ve gone through and actually selected the industry or in this case the commodity selected the time period that were interested in i selected data for 2017 2018 and 2019 through January at the time when I pulled this that’s what was available this site is constantly being updated and always includes the latest vintage of data available I also went in and I selected data for exports from all

states but I was also curious to see how does Nick Michigan do in terms of exports of these particular products so I selected all states and Michigan and finally the last selection I made was to look at not only the world total what are the total exports from all states and from Michigan but also I provided I pulled out the data for all the countries so you can see Afghanistan Albania Algeria etc the screenshot obviously only includes just a small fraction of the state of the countries that we export products do there’s over two hundred and forty countries published in this particular tool so it’s a great resource that our manufacturer could use to identify where are the countries that products in his industry where are they being exported another key tool that is available to look at the exports industry and exports data is a tool called global market finder this is a tool that was just recently released I love it it’s very intuitive to use has a very very nice interface and in this particular tool we can go in and look at specific commodities that are being exported so it’s sticking with our example here I type in the word seats into the search system and I get a list of all of the different commodities that are related to that word seats and as we can see the third line down that I’ve circled is seats of a kind used for motor vehicles so again thinking about our manufacturer that makes automotive seating and trimmings maybe this would be something that he or she would be interested in over on the right-hand side I have provided a link to where you can go to get to the global market finder there is the tool itself and we also wrote a really nice American count story recently that was released that talks about this really intuitive tool and I’ve provided that link here as well so in this case I chose seats and the application automatically then opens to display a map of the world with dots on all of the countries that that we export seats to so again right at the top of the screen you can see total exports of seats of a kind used for Motor Vehicles the menu that says all that is all countries 2017 is the year and we’re displaying the data in a graph the five countries that are highlighted with a red dot are those are those that are our top five trading partners but let’s just pretend our us manufacturer in Michigan is interested in identifying a country that maybe isn’t one of the top five let’s say he’s always sort of considered may be exporting his seeds to Brazil so by placing my cursor over the dot on the country Brazil and clicking on that I can clearly see that in 2017 the exports values of seats was about two point one built billion dollars okay we also have information in this tool for many of these industries on quantities how many numbers of seats were shipped and use it as you can see about 3,300 seats were shipped to Brazil in calendar year 2017 now in addition to this map based display the tool also supply up supports a table based display over on the right hand side is the exact same data that we’re looking at on the map but in this case displayed in a tabular presentation these data can all of course be downloaded using this tool and it’s just a great a great great resource now across the top of this tool you’ll see four tabs the first one again is a map tab the second tab is the methods of transportation feature this is looking at exports of dates of a kind use for Motor Vehicles to Brazil in 2017 and we’re looking at the type of method that is used to export these products so we can see air vessel containerized vessel not containerized and other and you can clearly see in this graphic that in 2013 the vast majority of the products of these particular products seats that were exported to Brazil were exported via containerized vessel you can see this decline of these exports from 2013 down to 2016 and then you can see the recovery of these exports to 2017 so maybe our manufacturer who is may be thinking about exporting to Brazil they might first be put off by the exports to Brazil are declining but then they might say oh okay it’s actually beginning to rebound in 2017 maybe this is a good time to get in

there so again helping them understand their potential markets and they could go through this tool and look at each of the countries that are there the third tab across the top is our time series tab that again shows that same type of data but this time just over a simple time line and again you see that same basic pattern a decline in the exports to Brazil of these products from 2013 down to 2016 and then the recovery back to 2017 and finally the fourth tab in the global market finder is a unit price tab this allows me to go in and compare the price per unit of each of these seats that are being exported to each of the countries you can clearly see dots on here that are for each of the countries that we export to in this case I put my cursor over that dot in the upper right hand corner and we can clearly see that that country which is Mexico has the highest value and the highest unit price each of these seats that were exported to Mexico in 2017 on average had a unit price of 327 dollars and 13 cents so pretty nice seats so that’s the global market finder again a fabulous resource that US manufacturers and others could use to identify potential markets for products that they are making in the United States now let’s turn to that second scenario that we were interested in and that is looking at the imports data from a wholesalers perspective one of our key surveys of the Census Bureau that publishes data on this sector is the annual wholesale trade survey this survey again is an annual program that provides data on wholesale trade businesses that have one or more employees just like the manufacturing survey data are shown at the national level only at the two through four digit code level but there are some data available excel for selected five digit mix codes state-level data are not available in the annual wholesale trade survey but those state-level data are available from other Census Bureau sources including the County business patterns or CBP survey and the non employer statistics survey or NES for the purposes of this section of the webinar we’re going to focus on the motor vehicle and motor vehicle parts and supplies merchants wholesalers industry which is Naik’s 4-2-3-1 and over on the right hand side we can see some key statistics from the annual wholesale trade survey to talk about what the total sales of businesses classified in this industry are about eight hundred and thirty six point five billion dollars in sales and 2017 a pretty substantial portion of those sales are ecommerce sales our sales of these wholesale businesses to other businesses via e-commerce methods so four hundred and twenty eight point nine billion dollars worth of those sales are available we’re done via e-commerce so as again you can see this is a pretty strong industry like our data from the annual surveys manufacturers I did a similar comparison between the employment data for motor vehicle and motor vehicle parts and supplies merchants wholesalers and the types of businesses that often buy from these wholesale businesses so the map and the etapa in the upper left hand corner shows the distribution of employment of these types of businesses by state and in the bottom right hand corner we have data for the number of automotive repair businesses so when you think about who is buying products from a wholesaler automotive parts supply wholesalers are selling their products to repair facilities to car dealerships and to other businesses that consume maybe auto parts sales retail businesses so as again you can see a similar relationship like we saw before where these wholesalers tend to be located in the same areas where the where the customers are actually located in the upper right hand corner I’ve also included just a couple of statistics from the annual wholesale trade survey to again show how this industry has been doing over the last five years and you can see this clear increase from 2013 up through 2015 and then a gradual leveling off of the total sales of these businesses up through 2017 again we turn to the u.s international trade and goods and services report which provides detailed information not only on exports but on imports too like the export side data are published by industry commodity and by country in this case by country of origination as opposed to destination and again similar to the exports data data are published at the national state

district and even port levels once again I’ve included some key statistics on imports of these particular products as you can see the customs value of imports in this industry was over a hundred and twenty-two billion dollars with about forty five point six billion of it coming into this country via vessel and about five point when one billion of it coming in via air similar to the exports data we also publish information not only on dollar values or custom values but also by weight you can see about six point 1 billion kilograms of these particular products were imported into the United States now unlike the exports data where you have both the USA trade online tool and the global market finder tool where you can access detailed information on exports the USA trade online tool is the key tool to look at the imports data so I went into USA trade online and downloaded some information to find out where are the products that are being imported in this industry where are they coming from and you can clearly see that Mexico substantially dominates this particular case so about forty nine point eight billion dollars worth of motor vehicle parts came into the United States imports via Mexico next in line in terms of ranking was China with fifteen point four million dollars and Canada immediately find that at fourteen point two billion dollars again this is from the USA trade online tool that has both imports and exports data I then changed up this thing a little bit and look specifically again at imports of seats so instead of just looking at that entire industry I looked at the data for how much seats are being import United States and once again I see this clear dominance of Mexico about ninety 1.4 million dollars worth of sales versus of imports of seats with China behind that at fifty six point eight a million dollars then I went ahead and said okay let’s look at where are these seats being imported into what is the state that they these these parts are ending up in and once again we see this dominance of Michigan forty five point eight million dollars worth of those imports are going to Michigan and finally I went in and looked at the imports data looking at the port that they’re actually coming into and you can see clearly that Laredo Texas the port of Louie no Texas is where the lion share of substantial majority of those impedes are being imported into so this again is a great resource for this wholesaler to say I want to wholesale products my job is to sell products to businesses that need to consume them one of these products that I might be wholesaling might be automotive seats I could be looking to a u.s. manufacturer to buy those seats from or it could be looking to a foreign supplier where I would be importing those seats so with that all now says let’s just change gears for a quick moment and talk about where did all this great data come from now obviously all these statistics that are so valuable came because people because businesses filled out their forms they received a survey form from us they reported on their customs documentation filled out their their information so what we really want to do is promote usage of this data to also promote response so if you found what was displayed today what we talked about today to be interesting we really would love to hear you promote with your customers and with your other businesses that you work with the usage of our monthly quarterly and annual business data census as Linda come mentioned before conducts over a hundred and thirty surveys with more than fifty of those being business surveys and we very much rely on businesses who are who are responding to us so to summarize the presentation I just want to quickly again say how US manufacturers can utilize these data to dental identify potential markets for their products or services these businesses often look at either existing customers are and then look at the data to determine are there additional markets international markets that they maybe they haven’t considered before on the opposite side us wholesalers can utilize the imports data to identify potential suppliers they can look at who are the existing suppliers of the product that they wholesale where are their existing domestic customers physically located and finally are their suppliers that they could be buying from internationally that they could tap into

to better serve those local customers now finally not only can businesses use these data but also economic development and other organizations can also use these data to help businesses in their communities be successful so again we really are looking to you all to help us promote response to these programs so the last thing I wanted to mention before I turn this back over to my colleague Linda is that help on all of these tools these trade tools we talked about today global market finder the USA trade online application all that type of help is available from our staff here at the Census Bureau on the right hand side is a flyer for our NGO webinar our go global webinar series that webinar series is going to be in May of this year just in the coming days and I would encourage each of you to check this out for more information I provided the URL for this particular program so with that let me turn this back over to Linda and she will close out our presentation Thank You Mandy for presenting our audience with different programs and ways to use Census Bureau’s International trade data to help expand business markets before we begin the Q&A here’s a look into what’s coming next month second in the series is a webinar on employment scheduled for May 21st at 2:00 p.m. for anyone who may have tuned in to our 2018 series on employment a session on May 21st were served as a second part where we will be featuring additional information not covered in last year’s session in this webinar our speakers will dive into employment data from our demographic and public sector programs the webinar is a standalone session where you don’t need to have seen part one in order to track along if you’re interested in viewing part one please visit the link provided here where you’ll be able to obtain an archived copy of the recording slides and transcripts thank you everyone for taking the time out of your busy day to attend this webinar at this time we would like to open our phone lines to take any questions you may have about the international trade data if you have questions regarding the 2020 decennial please contact a telephone number provided on this slide operator do we have any questions at this time as a brief reminder please press star 1 to ask a question i’m your phone and record your name again it’s star 1 to ask a question so while we’re waiting for the questions to queue andy in your presentation you have mentioned the global market finder tool for acquiring export data is this tool also available on the import side actually I know it isn’t Linda so the global market finder tool currently provides data just for exports but that is an interesting question would there be any way of us actually doing that sometime in the future or so we’ll see great question okay we did have a few questions come in our first question comes from Darrell McClellan your line is open hello Andy I’ve tried to use USA trade online before and it’s I find it very difficult is there any videos or anything other than the online online tutorial that we could use for training so on our international trade website on census.gov we do have materials on the USA trade online tool there are Flyers and fact sheets and some other training materials so yes I would definitely recommend you checking out those materials on the website we also provide information where you can actually call our staff and actually have them walk through the application with you the phone number that you’d want to contact is 301 seven six three two three one one we read that back again 301 seven six three two three one one and the staff that work in this office would be happy to walk through the tool with you as with a lot of powerful tools they sometimes are not always quite as intuitive but I think when you kind of figure out how to work through it you’ll find that it’s a great resource well just know what you know I I have tried that number and the person that answered my call directed me to a YouTube video so it wasn’t as helpful as I would have liked okay well you have my contact information here too I would be happy to talk to chat with you about this if you’d like to or again maybe try to reach somebody else on that site again

we’re more than happy to help any way we can thank you and our next question comes from mark van sweet your line is open Andy thanks very clear president I’m trying to help a certain region here in northern Indiana I’m trying to help them do more exporting for their midsize manufacturers and I wondered if if there’s data that’s broken down by region or County or either exports or imports that can help me make the case for my region right so I mentioned in the presentation that the trade data are available at the national state region district and port levels the definition of a district import obviously vary widely across the US so I would really recommend you kind of digging into the tool a little bit to see what levels of geography are supported in that in your area of the country again I would also recommend if you want to call that number that I just gave out and they can kind of walk through that with you as well but yes you should be able to get to data and a more localized geography than just simply the state they’re not necessarily County I guess is that it it could be a region as depends on how they define it as you said yeah correct correct yeah we don’t we don’t publish date it on the trade data from the international trade and goods and services report we don’t publish that data at the county level for a number for a number of reasons but yeah at the district and port we’d be the smallest level of geography you’d be able to get to thank you and our next question comes from Ryan Pratt your line is open hi I just wanted to check to see if this presentation will be available for the attendees afterwards it will be when we post the recording you will also get access to the transcript for the reporting and the PowerPoint file itself and you are more than welcome to utilize that PowerPoint file as you as you see we of course would love it if you would sign us as a source of this information but yes the information will be posted probably a couple of days you you’re welcome thank you and our next question comes from Fredo Diaz your line is open gentlemen just before me answer that same question I’m very interested in the transcripts in the video thank you you’re welcome thank you our next question comes from bill bender your line is open good afternoon and I’ve utilized your services over many times over the last thirty years and something I found to be extremely important helping us develop business overseas for some of the trade seminars or were held at international trade zones are there any coming up that we would be able to subscribe to yeah that’s a great question I’m glad you brought that up and I’m happy that you that you found them useful if you go to our trade web site they actually have a list of all of the upcoming events and and seminars that are being done a lot of the seminars are I’ll say technical in focus thinking about things like trade regulations and things like that but there’s also a number of other trade webinars that day in presentations they do with a more sort of general audience one of the things that Linda and I have been trying to do is to incorporate the trade data that we published it has such a great user base with a lot of our other data programs that we have to again help expand the use of all of all of our data so that’s why we decided today to kind of merge together the manufacturers in the wholesale data we have with the trade data because together and tell such a compelling story but yes there’s there’s lots of training materials available they traveled more than I do which is a little scary so yeah there’s a there’s in-person workshops frequently thank you you’re welcome Thank You Anne our next question comes from Raymond fight your line is open so I’m listening I’ve heard a lot of answers to the questions that I had so but I still have one or two that’s outstanding one is the cost to consultants for use of the data is there any I booked charge that would be made for accessing any of the data and then secondly what are the links that we should advise to the small businesses that we might be interfacing with as to how to go about reporting on this census more directly if they’re really

concerned about how to get information to you about what they do when it’s their baby right okay so let’s let’s tackle them in to to the two questions so the first question is no there is no charge for any of the data we talked about today in fact at the Census Bureau I can only think of two programs of all the 130 plus surveys we conduct that we actually charge data for so there is no charge for any of the data there’s no charge to subscribe subscribe to the USA trade online service and there’s no download charge to access all of that all that information even the you contacting us and getting guidance we provide that free of service I’d like to say nothing from the federal government is free you already paid for it so if you’ve already paid for it use it so definitely everything’s free the second question that you were asking about sort of consulting was working with small businesses and and encouraging their response the sample surveys that we conducted the Census Bureau the sample size the sample frame itself is drawn from the economic census complete universe we actually just completed collection of the 2017 economic census so employer businesses in your area should have received from us as long as they had a sort of a minimum number of employees should have received from us a form they would have received a follow-up from us if they did not complete so I’m gonna keep my fingers crossed here that you’re that your colleagues you’re talking about that they did sell out their form but we do have a respondent portal system available on our Census Bureau’s website where businesses can go in and check into the status of their forms if they were called if they were sent one if you are also interested my phone number here is on the slide seven six three six seven four seven please give me a call and I can forward your information on to one of my colleagues who works on our respondent side and we can determine whether or not the businesses that you’re talking about were selected or they can again kind of handle that so yeah great great question thank you and our next question comes from Patty best where your line is open hey there thank you Andrew for the presentation I just had a question because originally I was using USA trade online by moved towards the using the API I was wondering is there also any sooner like newer information like either it be the licensing information or anything like that even if it’s a lower HTS code so I’m gonna I’m gonna restate what I think you said and tell me if I say this right the data that is available in USA trade online is identical to the data that’s available in the API I do not believe that there are any additional data variables that are available in one platform versus another if you’re interested in specifics I might recommend you giving our folks a call to see if there’s anything but I don’t think there’s any extra data I’m getting a colleague of my here in the room is giving me that there’s one thing that is available if I’m sorry I just let me to break in is if I understood your question correctly if there’s just you were saying even if it’s at a higher level is there data that’s available sooner is that correct yes so the only thing that would be available that earlier than the full release so so just as Andy was saying when it comes to us a treat online the API all that detail is available at the same time but if you want a bit broader numbers we do have a public dance economic indicators report and in there we do have broad numbers for just the goods portion of the international trade it also includes retail and wholesale indicators but that could be a resource it’s a very simple report it’s based on one digit level nd codes but that that is potentially could be what you’re looking for that sounds great thank you thank you and our next question comes from Logan Hahn your line is open hey thank you all good presentation um first time user here I was just wondering maybe this goes towards the first lady’s question would you be able to share screen and walk us through a very basic example an export out of a certain port Baltimore all commodities to a certain country so what

I can do if you’d like is on the slide you’ll see my email address and my phone number if you would like to send me an email we can set up maybe a time to do a screen share where I can literally walk through sort of the demo that I did today but just do it live how I went and do as I trade online selected the commodity someone selected the country the period etc yeah I’d be I’d be more than happy to do that I also can send you to the folks in a way more about this than I do and the experts and they they could certainly do the same but yes we can we can definitely help you with that much appreciated thank you you’re welcome thank you on our next question comes from Angelica Coronado llaman is open Andy I just had a kind of out-of-the-box question about this example that we did I just wanted to know I know that you know they get sent to the countries but I wanted to know if there was any data on the variable of which ones or like a total loss for the country or have to either get sent back to the manufacturer for let’s say like the wrong stitching or a light gauge something that needs to be repaired is that data available or is that kind of just like a lost kind of thing and something that the courts deal with that you don’t usually see data on yeah I’m some in a sort of restate so you’re asking when we publish data on exports of a particular commodity let’s say to a particular country do we have any statistics on those exported products that were returned if you will back to the sender for some particular reason I think the short answer is no like step in for a second if I understand you correctly it sounds almost like you’re asking about re-exports anything that sent back out of the country for very theism yeah so we do have we do have we exports but the problem that I would see with your question is I don’t know that we can always break down by the reason so but that is that is a good starting point for what I think you’re asking and that is available it’s available and throughout our data products but on USA trade online there’s such an indicator so it’s domestic versus foreign for exports so again it would be a foreign considered a foreign export because it’s not you know it’s not from the US okay thank you so much seven said definitely answered your question great thank you all thank you and our next question comes from Ray Roman your line is open hi Andy thank you for the presentation you mentioned during the talk that much of the expo data is acquired from I guess from the trade from business I think you said business owners that are completing questionnaires or forms with regard to their export my question is is any data pulled into their from to the automated export system and as companies are reporting their export shipments yeah yeah absolutely the the trade data so unlike our our other economic programs that we conducted a census bureau where we are responsible the Census Bureau is responsible for sending out the forms to those particular businesses whether that be a paper form or whether that be a lot of online instrument on the trade side they collect the data via two main methods AES or made an export system that you were talking about is obviously the key method of collecting the data on the export side so that system is a system that exporters have to use we use the data that’s reported in there and that’s what becomes a source of the information for our for our tabulated published data that’s on the export side on the import side those are from customs documents documents said importers have to complete we pull those reports and that’s the source of information for the import side data so yes it’s a very it’s an interesting program because how they get their source data is sort of in a very different way from the way other business surveys we have it the Census Bureau collects that source data yeah great question thank you and our next question comes from dr. Toby Malachi your line is open Thank You Linda Andy great presentation dr. Toby Malachi findings founding executive chairman of Malachi group worldwide headquarters here in Indianapolis Indiana and I’m also vice chairman of the Indiana District Export

Council which is affiliated with US Department of Commerce Andy you raised it a great point and I don’t think the questions been asked yet the Tuffle more about this great instrument we use it we’ve completed working over 70 countries the global market finder we’ve found that to be very useful for SMEs quantum sized enterprises who are new to export or thinking about expanding their exports could you talk just a little bit more about that great tool yeah I I will tell you it sort of came as a surprise to me I do a lot of outreach and marketing with other data products and other data tools we do at Census and when I learned that my colleagues on the trade side had developed this really intuitive really easy to use very elegant interface this this interactive graphic if you will I was really excited by it but if I think in a lot of ways it is democratizing if you will a lot of the data that you could get in USA trade online but this tool does such a nice job of displaying a map base format you’ve got these great charting tools that are in there I love it I am a relatively new convert convert to this but I’m really sold although and this as being of just a great tool for us to make accessibility to that type of really dub which could be complex data one of the one of the other callers mentioned about how USA trade online has a lot of features and it’s a little bit challenging to use that is certainly not the case with local market finder I love it I’m really happy that you’re happy with it as with a lot of our other data tools we always are open to feedback so if you are or interested in providing some feedback on additional things you like to see in the tool or maybe make the functionality work a particular way even in preparing this particular webinar today I found some things about the tool that I didn’t know about and my colleagues had to say no Andy you want to do it you want to use it this other way so yeah it was it was a great thing so yes we definitely very interested in taking the feedback and suggestions you have on the tool you have my email address and phone number we’ve also provided information on the phone for our trade our direct trade office that 231 one number that I already already gave you all it’s here on the slide and so we’d love to hear those kind of comments that’s that’s the thing that we kind of live for here because in the end the tool was booked for you not for us well thank you so much we will and I always end by saying have a successful day and think globally Wow yes thank you and our next question comes from Todd romanovski your line is open thank you very much I had a follow-up question about cost and it’s related to access we’re a us-based company but we’re owned by privately held foreign national and the most available market research resource I have for me may be at corporate in the UK so would would such an individual have access or do you need to be us-based when you use either of the tools discussed all of our data at the Census Bureau is freely is freely accessible and free to anybody I the Census Bureau participates in a program called select USA Investment Summit it’s a it’s a program that the US Department of Commerce conducts every summer it’s usually the middle of June and that summit pulls together US companies US businesses US markets state representatives economic development organizations from States with foreign investors where they can come to the US and sort of like a matchmaking service essentially and I’ve participated in USA select USA for the last four years it’s a great audience and I got that question more often than I would believe that I’m a foreign national can I still access your data for free do I have to pay for it and the answer of course is no you don’t we want for users we want domestic users to be accessing these data so no it does not matter that your headquarters is is in Buffalo or wherever it’s located you have free access to the data thank you very much you’re welcome thank you and as a brief reminder again it star one to ask a question please record your name to introduce your question and our last question comes from Elizabeth your line is open thank you I appreciate you I appreciate your enthusiasm I’ve got a couple questions the first one is related to

the calculation of price the fact that you were able to give a price per unit was very interesting but pooling data a lot of people write units and you know they’re they’re shipping documents in different units you have tonnage you have you know piece you have cubic meters you have square feet how do you reconcile different units to create a an average price or is that average price sometimes just what’s recorded and then an average of ton and piece for example yeah it’s actually a very it’s a more common challenge with even other economic programs we conduct we actually have systems that convert the units of measure that they’ve measured the data in into a into that common kilograms measure and this is and again so we only offer unit of quantity and unit price at the telogen HS level and at that level it’s in fact when you’re even looking on the global market finder on unix or on USA trade online you’ll notice something in parentheses that’s the unit quantity that’s being used so when what an exporter importer is filing they’re good they’re required to report their unit of quantity and what for whatever’s required for that Conrad system code so for example I’m the first code on here horses you are required to report horses and the number of courses you have so it’s based off of that right right but again that that conversion that you’re talking about that is something that we have to deal with with other academic programs so it’s nice that they on the trade side they actually require the business to actually report in a consistent user of measure so it depends on the commodity some of the products are less consistent because they’re moldable weights to calculate but I appreciate the challenge the second question I have is related to the trade data that’s coming from US Customs there are certainly publicly available company you know their companies that provide services to manipulate that data for you Pangea met manifest journals that kind of organization one of the challenges in using those is they run against the manifest confidentiality I’m wondering if we’re looking at stuff through the US trade link that you provide on the census is that giving us data that hits that doesn’t have certain imports blocked body by the importer yes so that’s that’s always a challenge when you cut when you look at those particular sites if you’re you’re not going to get your most complete information and you won’t get it edited so we’re getting everything where with those sites they’re just focusing on manifest data they don’t have access to all that we do so so you’re not looking at a complete picture of course when you’re when you’re looking at the private sites because we do offer counsel confidentiality that is part of the reason that we’re able to collect all of the data for input and the data on the cut on the custom site is not specific to importer correct it’s just aggregate data right yes okay yeah we nearly all of the business data we have at the Census Bureau is subject to privacy protections so we all we publish basically is summary level data we you will never see individual business individual export data because that would violate the privacy protection thank you and our next question comes from Christine Stine your line is open hi my name is Kristen Stein I’m with trade data monitor and I work with many different countries important export trade statistics and often times I have clients that are asking me the differences between the US exports to Canada and Canada imports from the US and I was hoping that you could explain to how the data exchange occurs between Statistics Canada and the US Census Bureau so we could have a whole webinar on that one so and a fact we do we do have some resources available on it but there there are a number of different factors that play into where there if you were essentially asking why there’s a discrepancy is that correct did I hear that right yes yeah and I guess how revisions are handled between the two different agencies how we reconcile each other’s data essentially Hey okay so to try to tackle at least the first part at a very high level and like you said it is it is kind of one of those complicated things that we do dedicate ho-hold webinars or presentations to this and of course I also be but happy to talk to you after or if you contact daddy engine he’ll get me in contact with you just we can go

over it a little more but um there are there’s sorry I’m like trying to think it off the top of my head exactly all the differences some of it relates back to our great charges valuation right our valuation as well as this one yeah sure I mean this is just to start off with the Canadian Canada US Canada beta exchange is pretty much an exchange of import data in which the base the respective export statistics so there will definitely be changed differences that will be noticed when you are comparing the two those can be due to free charges and our ways of doing revisions as well they can also be based on how we collect or how we treat re exports and things of that nature so we work with one another to try to come to an equal level of revising but again there are going to be differences and we try to reconcile as much as possible but it is still a task in hand at this time right and I think and whatever he was getting at especially when it comes to the V export piece is part of it is if we’re both following the UN guidelines which we are in regards to how to handle our collection and publication of data it it does just lend itself to there being this imbalance between our two types of data what I love is actually is that Canada had actually put out something that explains this in a little more detail and really breaks down where that I don’t want to say disconnect but just where that that imbalances and then as far as getting back to how we what we do to reconcile it we do every few years we do do a trade reconciliation with Canada as well as with other countries that we will publish on our site but just with the way that things are being held knowledge it does lend itself to their being on a melon okay thank you so much thank you and our next question comes from – janata your line is open yes sir your line is open thank you since the quality of that data so that it is it is usable to join sites right so I’ll like like my colleague Mazda said we could do a whole webinar just on data quality and how we analyze data so I’ll just give sort of some basic guidelines on what we do sort of sense it’s wide so certainly when you think about review of data looking for discrepancies we do things like time series comparisons looking at what that business reported in the past what are they reporting now does that does that data make sense is there are they reporting a change that doesn’t seem to make sense so we do that sort of Time series comparison we also look for inconsistencies between the statistics that they’ve reported to make sure that they there isn’t some problem there so thinking about one of our business surveys we might say okay you reported that you had ten employees but you reported ten million dollars in annual payroll when every Butler business and your industry pays their employees twenty five thousand dollars a year you’re really paying your employees 100 a million dollars a year maybe something’s wrong there so we look for those sort of inconsistencies in data on the trade side that could be something like looking at weird comparisons between the quantities and the dollars where they’re you know if everybody else is shipping a commodity those horses are worth X number of your unit prices X number of dollars and you’re reporting a number that’s ten times that we are probably going to look at that number and then determine is that number accurate and if not we’ll then contact the business we’ll figure out what’s happening as we are we’re pretty nerdy here at the Census Bureau in terms of how we look at that raw data and analyze it because in the end especially for benchmark surveys like the economic census if we don’t get it right then that error could then cascade through every other annual program that we do after that particular program that’s benchmarked back to it so we look for those kinds of inconsistencies in some of our programs we actually compare our statistics to other agencies Dana so we have a sharing agreement between the Census Bureau and the Bureau of Labor Statistics and the International and the IRS that allow us to pull data from those organizations and compare or what a business reports the IRS to what they reported on on our econ programs when

they find discrepancies in a classification change you know issues where you said to the IRS that you were a bar but to us you said you were a restaurant you know what’s what’s going on so we we do a lot of that kind of work in fact when when you think about the timeliness of our data and the lag that often exists between when the period that the data cover is four and when the data are actually released the lion’s share portion of that gap between when the period ends and when the data released a substantial piece of that is in analysis is spent on our side looking at the numbers making sure that they’re accurate and contacting the businesses if we think that they’re not that they’re questionable so yeah it’s a it speaks to me to the quality of what we insist upon here that we want to take the time to do it right and provide that that accurate data so yeah great great question thank you so much welcome thank you and our last question comes from Ken Roberts your line is open thank you I’ve been using your data for probably close to 20 years it’s great and I’ve enjoyed the presentation so a couple of questions related to sort of border crossing trade one is is there any way to align tonnage data to border crossing trade because I believe the tonnage doesn’t show up on things that are crossing a border and the second piece of that is there any way to separate rail versus truck crossing I think I’m gonna start with the second part first because it might answer your first question but as far as separating out rail or truck crossings we don’t have enough of that data to single it out so if you have if you have been looking at for example USA trade online and you’ll see there’s a break out there works Absalon air we don’t offer that for those for the rest of the modes of transportation so that it includes like pipeline hand-carry etc we food those because they they represent such a small piece that really at that point we we would be risking giving up the identity of certain companies so I mean as Andy had mentioned before our while we do want to give as much data as possible our first priority is also making sure that we’re protecting the companies that are reporting to us to ensure that they will always continue to give us accurate data so so yeah there really isn’t a way for us to to break that out without holding to title 13 right so and that even if you’ve kept it truck and rail together as total tonnage okay it’s a bit it’s not small it’s big we’re talking Mexico and Canada right right yeah but then if you break it down by the particular commodities it starts getting a bit more specific you know I do think that’s something that we occasionally look at to see if that is a possibility and and the one thing that you can always do is if there’s a specific idea you had in mind of what you’d like to see you can always email our group and we can have our methodology area investigate it and see if that’s something that can be broken out so it’s not to say that just everything that you see on our website is all that’s available we do take the Russell request it’s just the only thing when it comes to a request like that is you’re not guaranteed to get the data you could end up we they could end up researching it and say ultimately there’s too much disclosure we cannot release this data to you but it’s you know we can still have that discussion okay yes probably look because look at Ray lotion and and I guess I mean I’m sorry you look at ocean air and then sort of other category they’re remarkably similar in total value so they probably wouldn’t be as revealing as it might seem but then the last question sort of an oddball question I got asked this question and I didn’t know the answer to and by the way you can see what we do with the state at US trade numbers comment that we have we sort of extrapolate all the state and do stuff with value in tonnage and time and very stuff but the last question is are all military exports in this data or some of them withheld or they all withheld it looks like some are there but I’m not sure so we do include military data within our within our exports I’m trying to think of an instance that it would be withheld but I think they should pretty much all be there or let’s all be there okay okay at this time if anyone has additional questions please feel free to use the contact information listed on this slide I want to thank everyone again for attending today’s webinar and concludes our session for today thank you this concludes our session you may disconnect at this time