flowsa icon indicating copy to clipboard operation
flowsa copied to clipboard
verified publisher icon USEPA

Add annual wholesale and retail trade margin

Open WesIngwersen opened this issue 7 months ago • 4 comments

Add FBAs for Annual Wholesale Trade Survey using 2022 data to get 2022 and previous years back to 2012. Target is Table 4 to get the gross margin data.

The Annual Retail Trade Survey will provide the analogous data for Retail. See this table https://www2.census.gov/programs-surveys/arts/tables/2022restated/gm.xlsx

WesIngwersen avatar May 09 '25 18:05 WesIngwersen

Table 4: https://www2.census.gov/programs-surveys/awts/tables/2022/2022_awts_purchmarg_nomsbo_table4.xlsx

bl-young avatar May 09 '25 18:05 bl-young

Added in 71cc528

bl-young avatar May 12 '25 15:05 bl-young

The URL wasn't loading for me

requests.exceptions.SSLError: HTTPSConnectionPool(host='www2.census.gov', port=443): Max retries exceeded with url: /programs-surveys/arts/tables/2022restated/gm.xlsx (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1000)')))

WesIngwersen avatar May 14 '25 01:05 WesIngwersen

Hmm, I confirmed I could run it just now

flowsa.generateflowbyactivity.main(source='Census_ARTS', year='2013-2022')

bl-young avatar May 14 '25 01:05 bl-young