Find Jobs
Hire Freelancers

Extract data from SEC EDGAR website (from Form 10-K; 82,955 .txt links provided)

$30-250 USD

Cancelled
Posted almost 6 years ago

$30-250 USD

Paid on delivery
I’m interested in collecting information about employee unionization from public company annual reports (Form 10-K). Each 10-K contains several standardized sections. The labor union info I’m interested in is located in “Item 1. Business” and “Item 1A. Risk Factors”. Step 1: Access the links to Form 10-K .txt files (N=82955) in the attached read file and search Item 1 and Item 1A ONLY for the keywords below… KEYWORDS: collective bargaining, collective-bargaining, CBA, labo(u)r union(s), labo(u)r agreement(s), labo(u)r contract(s), labo(u)r organization(s), union agreement(s), union contract(s), union organization(s), or union(s) Step 2: If one of the above keywords matches the text in Item 1 or 1A, add the entire sentence (or paragraph, whichever is easier) with the match to new field/column in the read file. Maybe the output file could have one field for any Item 1 output and a second field for any Item 1A output. Appendix C and Appendix D of the attached research paper (pg36-37) provide some examples of the union-related text that I’m looking for. Step 3: (If possible) Create 3 different union-related variables (binary, percentage, number) from the extracted Item 1 sentences/paragraphs. Create a separate set of 3 union-related variables from the Item 1A text. First, identify whether the union-related statement is positive or negative (i.e. employees are represented/covered by a union V.S. employees are NOT in a union, none of our employees are represented) with a binary variable (=1 for (some) union representation and =0 for no representation). Second, extract the percentage of employees covered if available. Third, extract the number of employees covered if available. I realize this last part is tricky to do mechanically. I’ll have to check this part manually anyways, so any progress here with a reasonable error rate will be appreciated.
Project ID: 17178642

About the project

11 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
11 freelancers are bidding on average $191 USD for this job
User Avatar
Hi there,I am Miljan,Web Scraping expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the agreed deadline. Check out my profile, portfolio, and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Kind regards
$155 USD in 2 days
5.0 (48 reviews)
6.3
6.3
User Avatar
Hello JRESEARCH, I have checked the data in the given links and i can write macro script to get data from these files. I have 5 years experience in Excel VBA programming and can complete task within time with 100% accuracy.I am very responsible towards our clients. I know my client needs and importance. Skills : Excel, Macros,VBA,Web scraping,Web Search, Data entry, Copy typing, Transcription works,Wordpress,Megneto,Woocommerce,Shopify,Prestashop etc With Regards, Bhaskar.
$200 USD in 3 days
4.8 (83 reviews)
6.3
6.3
User Avatar
Hello I am a qualified python developer with 8 years of professional experience. Especially I have rich experiences of web scraping of SEC EDGAR website. I got you what you want and I am able to finish the project in 3 days. I am ready to start the work. Looking forward to hearing from you soon. Best Regards, Yongtao
$250 USD in 3 days
5.0 (14 reviews)
5.5
5.5
User Avatar
let's discuss in chat
$250 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Employer, I have gone through your requirement and i would like to apply for your data mining job. i have previous similar work experience to finish the work on time and within budget. Happy to hear from you! Shyamalaa M.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
State College, United States
0.0
0
Payment method verified
Member since Jun 16, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.