Skip to content

Instantly share code, notes, and snippets.

View bmurill2019's full-sized avatar

bmurill2019

View GitHub Profile
@bmurill2019
bmurill2019 / businessFormTexas.csv
Created April 8, 2023 03:23
geo naics_sector date qty
Texas Total for All NAICS 7/1/2004 11720
Texas Total for All NAICS 8/1/2004 12061
Texas Total for All NAICS 9/1/2004 12036
Texas Total for All NAICS 10/1/2004 14872
Texas Total for All NAICS 11/1/2004 12622
Texas Total for All NAICS 12/1/2004 13368
Texas Total for All NAICS 1/1/2005 12770
Texas Total for All NAICS 2/1/2005 15352
Texas Total for All NAICS 3/1/2005 19058
@bmurill2019
bmurill2019 / businessFormNewYork.csv
Created April 8, 2023 03:20
geo naics_sector date qty
New York Total for All NAICS 7/1/2004 11830
New York Total for All NAICS 8/1/2004 11925
New York Total for All NAICS 9/1/2004 11457
New York Total for All NAICS 10/1/2004 14310
New York Total for All NAICS 11/1/2004 12815
New York Total for All NAICS 12/1/2004 13413
New York Total for All NAICS 1/1/2005 11634
New York Total for All NAICS 2/1/2005 15157
New York Total for All NAICS 3/1/2005 18567
@bmurill2019
bmurill2019 / businessFormFlorida.csv
Created April 8, 2023 03:13
geo naics_sector date qty
Florida Total for All NAICS 7/1/2004 18374
Florida Total for All NAICS 8/1/2004 19162
Florida Total for All NAICS 9/1/2004 16164
Florida Total for All NAICS 10/1/2004 21849
Florida Total for All NAICS 11/1/2004 20051
Florida Total for All NAICS 12/1/2004 20682
Florida Total for All NAICS 1/1/2005 18673
Florida Total for All NAICS 2/1/2005 25010
Florida Total for All NAICS 3/1/2005 31066
@bmurill2019
bmurill2019 / businessFormCalifornia.csv
Created April 8, 2023 03:08
geo naics_sector date qty
California Total for All NAICS 7/1/2004 18144
California Total for All NAICS 8/1/2004 18352
California Total for All NAICS 9/1/2004 17034
California Total for All NAICS 10/1/2004 22102
California Total for All NAICS 11/1/2004 18820
California Total for All NAICS 12/1/2004 20105
California Total for All NAICS 1/1/2005 20309
California Total for All NAICS 2/1/2005 24430
California Total for All NAICS 3/1/2005 29190
@bmurill2019
bmurill2019 / businessFormUSInformation.csv
Created April 8, 2023 03:02
geo naics_sector date qty
U.S. Total Information 7/1/2004 3148
U.S. Total Information 8/1/2004 3132
U.S. Total Information 9/1/2004 2921
U.S. Total Information 10/1/2004 3860
U.S. Total Information 11/1/2004 3347
U.S. Total Information 12/1/2004 3501
U.S. Total Information 1/1/2005 3299
U.S. Total Information 2/1/2005 4282
U.S. Total Information 3/1/2005 5206
@bmurill2019
bmurill2019 / businessFormUSAllNAICS.csv
Last active April 8, 2023 02:59
geo naics_sector date qty
U.S. Total Total for All NAICS 7/1/2004 166448
U.S. Total Total for All NAICS 8/1/2004 171070
U.S. Total Total for All NAICS 9/1/2004 162742
U.S. Total Total for All NAICS 10/1/2004 207389
U.S. Total Total for All NAICS 11/1/2004 176104
U.S. Total Total for All NAICS 12/1/2004 190986
U.S. Total Total for All NAICS 1/1/2005 177217
U.S. Total Total for All NAICS 2/1/2005 221053
U.S. Total Total for All NAICS 3/1/2005 271787
@bmurill2019
bmurill2019 / layoffsCleaned.csv
Last active April 6, 2023 23:22
Company Location_HQ Industry Laid_Off_Count Date Stage Date_Added Country laid_off_cum
EasyPost Salt Lake City Logistics 75.0 2020-03-11 Series A 2020-03-31 13:21:54 United States 75.0
Tamara Mellon Los Angeles Retail 20.0 2020-03-12 Series C 2020-03-31 16:04:23 United States 95.0
Panda Squad SF Bay Area Consumer 6.0 2020-03-13 Seed 2020-04-17 00:12:49 United States 101.0
HopSkipDrive Los Angeles Transportation 8.0 2020-03-13 Unknown 2020-04-03 04:47:03 United States 109.0
Help.com Austin Support 16.0 2020-03-16 Seed 2020-04-16 06:36:06 United States 125.0
Inspirato Denver Travel 130.0 2020-03-16 Series C 2020-03-31 14:45:56 United States 255.0
Flytedesk Boulder Marketing 4.0 2020-03-18 Seed 2020-04-01 00:56:54 United States 259.0
Lola Boston Travel 34.0 2020-03-19 Series C 2020-03-28 20:52:49 United States 293.0
Remote Year Chicago Travel 50.0 2020-03-19 Series B 2020-03-28 20:52:49 United States 343.0
@bmurill2019
bmurill2019 / businessFormVerbose.csv
Created April 5, 2023 01:20
We can't make this file beautiful and searchable because it's too large.
sa,naics_sector,series,geo,year,jan,feb,mar,apr,may,jun,jul,aug,sep,oct,nov,dec
U,Total for All NAICS,BA_BA,U.S. Total,2023,439183,462896,0,0,0,0,0,0,0,0,0,0
U,Agriculture,BA_BA,U.S. Total,2023,4332,4305,0,0,0,0,0,0,0,0,0,0
U,Mining,BA_BA,U.S. Total,2023,582,503,0,0,0,0,0,0,0,0,0,0
U,Utilities,BA_BA,U.S. Total,2023,532,576,0,0,0,0,0,0,0,0,0,0
U,Construction,BA_BA,U.S. Total,2023,40992,45284,0,0,0,0,0,0,0,0,0,0
U,Manufacturing,BA_BA,U.S. Total,2023,6567,6827,0,0,0,0,0,0,0,0,0,0
U,Wholesale Trade,BA_BA,U.S. Total,2023,9585,10068,0,0,0,0,0,0,0,0,0,0
U,Retail Trade,BA_BA,U.S. Total,2023,72308,74282,0,0,0,0,0,0,0,0,0,0
@bmurill2019
bmurill2019 / bfs_mapper.csv
Created April 4, 2023 22:10
sa A Seasonally Adjusted
sa U Not Seasonally Adjusted
naics_sector TOTAL Total for All NAICS
naics_sector NAICS11 Agriculture
naics_sector NAICS21 Mining
naics_sector NAICS22 Utilities
naics_sector NAICS23 Construction
naics_sector NAICSMNF Manufacturing
naics_sector NAICS42 Wholesale Trade
naics_sector NAICSRET Retail Trade
@bmurill2019
bmurill2019 / layoffs_data.csv
Created April 2, 2023 02:22
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