Skip to content

Instantly share code, notes, and snippets.

View RobFaj's full-sized avatar
😄

RobFaj

😄
0 followers · 6 following
View GitHub Profile
@RobFaj
RobFaj / unemployment_rate.csv
Created April 7, 2023 19:11
DATE UNRATE
2009-12-01 9.9
2010-01-01 9.8
2010-02-01 9.8
2010-03-01 9.9
2010-04-01 9.9
2010-05-01 9.6
2010-06-01 9.4
2010-07-01 9.4
2010-08-01 9.5
@RobFaj
RobFaj / tech_layoffs_by_month.csv
Last active April 3, 2023 04:27
year_month Laid_Off_Count
2020-03 9628.0
2020-04 26710.0
2020-05 25804.0
2020-06 7627.0
2020-07 7112.0
2020-08 1969.0
2020-09 609.0
2020-10 450.0
2020-11 237.0
@RobFaj
RobFaj / layoffs_data.csv
Created April 3, 2023 02:55
Layoff Data for Project - Data Viz
We can make this file beautiful and searchable if this error is corrected: It looks like row 6 should actually have 12 columns, instead of 10. in line 5.
Company,Location_HQ,Industry,Laid_Off_Count,Date,Source,Funds_Raised,Stage,Date_Added,Country,Percentage,List_of_Employees_Laid_Off
Veeam,Columbus,Data,200,2023-03-23,https://blocksandfiles.com/2023/03/23/200-people-get-laid-off-by-veeam/,500.0,Acquired,2023-03-24 18:36:13,United States,,Unknown
TakeOff,Kyiv,Retail,50,2023-03-23,https://dou.ua/lenta/news/takeoff-layoff/?,146.0,Unknown,2023-03-26 21:25:22,Ukraine,,Unknown
Slite,Paris,Other,10,2023-03-23,https://www.linkedin.com/posts/christophepasquier_we-always-pride-ourselves-to-grow-healthily-activity-7044698064845971456-s_EB/,15.0,Series A,2023-03-24 18:39:58,France,0.25,Unknown
Indeed,Austin,HR,2200,2023-03-22,https://www.indeed.com/press/releases/a-message-from-our-ceo-chris-hyams,5.0,Acquired,2023-03-22 16:24:35,United States,0.15,Unknown
Logitech,Geneva,Hardware,300,2023-03-22,https://www.bloomberg.com/news/articles/2023-03-22/logitech-cuts-300-jobs-on-post-covid-slump-in-computer-gadgets?srnd=technology-vp#xj4y7vzkg,,Post-IPO,2023-03-23 16:47:11,Switz
@RobFaj
RobFaj / sanfran_comp_emp_2016-2022.csv
Last active April 2, 2023 05:24
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 2.
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,46,0,2019,4,,6410,106596,107040,107251,5066556857,79391536,3283616,3644,,1.11,2.89,2.89,2.92,2.57,3.02,2.54,0.89,,306,5.0,6211,6.2,5709,5.6,5518,5.4,-58597413,-1.1,1973631,2.5,-93815,-2.8,-254,-6.5,"S
@RobFaj
RobFaj / nyc_comp_emp_2016-2022.csv
Created April 2, 2023 05:23
We can make this file beautiful and searchable if this error is corrected: It looks like row 3 should actually have 42 columns, instead of 16. in line 2.
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,76,0,2019,4,N,2,0,0,0,0,0,0,0,N,0.68,0.0,0.0,0.0,0.0,0.0,0.0,0.0,N,0,0.0,0,0.0,0,0.0,0,0.0,0,0.0,0,0.0,0,0.0,0,0.0,"New York County, New York",Local Government
5415,76,0,2020,1,N,2,0,0,0,0,0,0,0,N,0.6
@RobFaj
RobFaj / austin_comp_emp_2016-2022.csv
Last active April 2, 2023 05:24
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 2.
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,46,0,2019,4,,3730,41261,41457,41479,1403402004,35848735,922828,2608,,2.08,2.57,2.57,2.58,2.47,2.36,2.97,0.96,,261,7.5,1221,3.0,1082,2.7,1044,2.6,15912031,1.1,662697,1.9,55003,6.3,-41,-1.5,"Austin-Roun
@RobFaj
RobFaj / sf_nyc_austin_comp_2019_2022.csv
Created April 2, 2023 05:22
We can make this file beautiful and searchable if this error is corrected: It looks like row 3 should actually have 42 columns, instead of 16. in line 2.
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,76,0,2019,4,N,2,0,0,0,0,0,0,0,N,0.68,0.0,0.0,0.0,0.0,0.0,0.0,0.0,N,0,0.0,0,0.0,0,0.0,0,0.0,0,0.0,0,0.0,0,0.0,0,0.0,"New York County, New York",Local Government
5415,76,0,2020,1,N,2,0,0,0,0,0,0,0,N,0.6
@RobFaj
RobFaj / ownership_codes.csv
Created April 2, 2023 01:20
ownership_code ownership_title
0 Total Covered
5 Private
4 International Government
3 Local Government
2 State Government
1 Federal Government
@RobFaj
RobFaj / austin_prof_employment_bls
Created April 1, 2023 18:40
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
SMS48124200000000001,2016,M01,2016 Jan,986.0,2.7,8.9,18.5,41.5,0.3,0.9,1.9,4.4
SMS48124200000000001,2016,M02,2016 Feb,989.4,3.4,9.5,18.1,41.4,0.3,1.0,1.9,4.4
SMS48124200000000001,2016,M03,2016 Mar,991.1,1.7,7.8,16.7,39.5,0.2,0.8,1.7,4.2
SMS48124200000000001,2016,M04,2016 Apr,995.1,4.0,9.1,18.0,40.5,0.4,0.9,1.8,4.2
SMS48124200000000001,2016,M05,2016 May,996.3,1.2,6.9,16.4,36.9,0.1,0.7,1.7,3.8
SMS48124200000000001,2016,M06,2016 Jun,999.0,2.7,7.9,15.7,35.3,0.3,0.8,1.6,3.7
SMS48124200000000001,2016,M07,2016 Jul,1007.3,8.3,12.2,21.3,39.8,0.8,1.2,2.2,4.1
SMS48124200000000001,2016,M08,2016 Aug,1008.8,1.5,12.5,19.4,37.5,0.1,1.3,2.0,3.9
SMS48124200000000001,2016,M09,2016 Sep,1011.6,2.8,12.6,20.5,37.2,0.3,1.3,2.1,3.8
@RobFaj
RobFaj / sanfran_info_employment.csv
Created April 1, 2023 18:38
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
SMU06418605000000001 2016 M01 2016 Jan 95.3 0.4 1.6 2.4 10 0.4 1.7 2.6 11.7
SMU06418605000000001 2016 M02 2016 Feb 96.3 1 2 2.8 10 1 2.1 3 11.6
SMU06418605000000001 2016 M03 2016 Mar 97.3 1 2.4 4.3 10 1 2.5 4.6 11.5
SMU06418605000000001 2016 M04 2016 Apr 97.7 0.4 2.4 4 9.3 0.4 2.5 4.3 10.5
SMU06418605000000001 2016 M05 2016 May 98.2 0.5 1.9 3.9 8.7 0.5 2 4.1 9.7
SMU06418605000000001 2016 M06 2016 Jun 100.3 2.1 3 5.4 8.9 2.1 3.1 5.7 9.7
SMU06418605000000001 2016 M07 2016 Jul 101.4 1.1 3.7 6.1 8.5 1.1 3.8 6.4 9.1
SMU06418605000000001 2016 M08 2016 Aug 101.9 0.5 3.7 5.6 8.4 0.5 3.8 5.8 9
SMU06418605000000001 2016 M09 2016 Sep 101.7 -0.2 1.4 4.4 8.7 -0.2 1.4 4.5 9.4