Skip to content

Instantly share code, notes, and snippets.

Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Region Exchange Index Currency
United States New York Stock Exchange NYA USD
United States NASDAQ IXIC USD
Hong Kong Hong Kong Stock Exchange HSI HKD
China Shanghai Stock Exchange 000001.SS CNY
Japan Tokyo Stock Exchange N225 JPY
Europe Euronext N100 EUR
China Shenzhen Stock Exchange 399001.SZ CNY
Canada Toronto Stock Exchange GSPTSE CAD
India National Stock Exchange of India NSEI INR
@RobFaj
RobFaj / ICE_5.csv
Last active March 3, 2023 04:22
Assignment for ICE-5
Region Exchange Index Currency
United States New York Stock Exchange NYA USD
United States NASDAQ IXIC USD
Hong Kong Hong Kong Stock Exchange HSI HKD
China Shanghai Stock Exchange 000001.SS CNY
Japan Tokyo Stock Exchange N225 JPY
Europe Euronext N100 EUR
China Shenzhen Stock Exchange 399001.SZ CNY
Canada Toronto Stock Exchange GSPTSE CAD
India National Stock Exchange of India NSEI INR
We can't make this file beautiful and searchable because it's too large.
area_fips,own_code,industry_code,agglvl_code,size_code,year,qtr,disclosure_code,area_title,own_title,industry_title,agglvl_title,size_title,qtrly_estabs_count,month1_emplvl,month2_emplvl,month3_emplvl,total_qtrly_wages,taxable_qtrly_wages,qtrly_contributions,avg_wkly_wage,lq_disclosure_code,lq_qtrly_estabs_count,lq_month1_emplvl,lq_month2_emplvl,lq_month3_emplvl,lq_total_qtrly_wages,lq_taxable_qtrly_wages,lq_qtrly_contributions,lq_avg_wkly_wage,oty_disclosure_code,oty_qtrly_estabs_count_chg,oty_qtrly_estabs_count_pct_chg,oty_month1_emplvl_chg,oty_month1_emplvl_pct_chg,oty_month2_emplvl_chg,oty_month2_emplvl_pct_chg,oty_month3_emplvl_chg,oty_month3_emplvl_pct_chg,oty_total_qtrly_wages_chg,oty_total_qtrly_wages_pct_chg,oty_taxable_qtrly_wages_chg,oty_taxable_qtrly_wages_pct_chg,oty_qtrly_contributions_chg,oty_qtrly_contributions_pct_chg,oty_avg_wkly_wage_chg,oty_avg_wkly_wage_pct_chg
1000,1,541,55,0,2022,1,,Alabama -- Statewide,Federal Government,"NAICS 541 Professional, scientific, and technical services","Sta
qtr qtrly_estabs_count month1_emplvl
1 5739834 37997992
2 5859693 38994554
3 5967223 39449649
qtr employment
q1 37997992
q2 38994554
q3 39449649
qtr employment
1 37997992
2 38994554
3 39449649
Series ID Year Period Label Value 1-Month Net Change 3-Month Net Change 6-Month Net Change 12-Month Net Change 1-Month % Change 3-Month % Change 6-Month % Change 12-Month % Change
SMU36356205000000001 2016 M01 2016 Jan 287.4 -10.6 -7.8 -6.2 1.1 -3.6 -2.6 -2.1 0.4
SMU36356205000000001 2016 M02 2016 Feb 288.5 1.1 -8.5 -3.8 0.7 0.4 -2.9 -1.3 0.2
SMU36356205000000001 2016 M03 2016 Mar 290.1 1.6 -7.9 -1.2 1.6 0.6 -2.7 -0.4 0.6
SMU36356205000000001 2016 M04 2016 Apr 292.1 2 4.7 -3.1 4.6 0.7 1.6 -1.1 1.6
SMU36356205000000001 2016 M05 2016 May 279.2 -12.9 -9.3 -17.8 -9.6 -4.4 -3.2 -6 -3.3
SMU36356205000000001 2016 M06 2016 Jun 294.4 15.2 4.3 -3.6 2.9 5.4 1.5 -1.2 1
SMU36356205000000001 2016 M07 2016 Jul 299.9 5.5 7.8 12.5 6.3 1.9 2.7 4.3 2.1
SMU36356205000000001 2016 M08 2016 Aug 299 -0.9 19.8 10.5 6.7 -0.3 7.1 3.6 2.3
SMU36356205000000001 2016 M09 2016 Sep 297 -2 2.6 6.9 5.7 -0.7 0.9 2.4 2
We can't make this file beautiful and searchable because it's too large.
stfips,areaname,code,name,baseyear,base,projyear,proj,change,percentchange,avgannualopenings
1,Alabama,00-0000,"Total, All Occupations",2022,2210240,2024,2213000,2760,0.1,257220
1,Alabama,11-1011,Chief Executives,2022,1760,2024,1740,-20,-1.1,120
1,Alabama,11-1021,General and Operations Managers,2022,37490,2024,37810,320,0.9,3420
1,Alabama,11-1031,Legislators,2022,1050,2024,1070,20,1.9,90
1,Alabama,Nov-11,Advertising and Promotions Managers,2022,90,2024,90,0,0,10
1,Alabama,Nov-21,Marketing Managers,2022,1640,2024,1660,20,1.2,150
1,Alabama,Nov-22,Sales Managers,2022,3770,2024,3830,60,1.6,340
1,Alabama,Nov-32,Public Relations Managers,2022,390,2024,390,0,0,30
1,Alabama,Nov-33,Fundraising Managers,2022,1550,2024,1540,-10,-0.6,120
We can't make this file beautiful and searchable because it's too large.
industry_code,agglvl_code,size_code,year,qtr,disclosure_code,qtrly_estabs,month1_emplvl,month2_emplvl,month3_emplvl,total_qtrly_wages,taxable_qtrly_wages,qtrly_contributions,avg_wkly_wage,lq_disclosure_code,lq_qtrly_estabs,lq_month1_emplvl,lq_month2_emplvl,lq_month3_emplvl,lq_total_qtrly_wages,lq_taxable_qtrly_wages,lq_qtrly_contributions,lq_avg_wkly_wage,oty_disclosure_code,oty_qtrly_estabs_chg,oty_qtrly_estabs_pct_chg,oty_month1_emplvl_chg,oty_month1_emplvl_pct_chg,oty_month2_emplvl_chg,oty_month2_emplvl_pct_chg,oty_month3_emplvl_chg,oty_month3_emplvl_pct_chg,oty_total_qtrly_wages_chg,oty_total_qtrly_wages_pct_chg,oty_taxable_qtrly_wages_chg,oty_taxable_qtrly_wages_pct_chg,oty_qtrly_contributions_chg,oty_qtrly_contributions_pct_chg,oty_avg_wkly_wage_chg,oty_avg_wkly_wage_pct_chg,area_title,ownership_title
5415,56,0,2019,4,,2,7,7,7,84463,0,0,928,,2.4,3.05,3.02,2.99,2.53,0.0,0.0,0.84,,0,0.0,1,16.7,1,16.7,1,16.7,-7358,-8.0,0,0.0,0,0.0,-249,-21.2,,Federal Government
5415,56,0,2020,1,,2,7,7,7,90957,0,0,1000,,2.4