Grab Specific Data -- 2
Budget: $30 – $250 USD
WARNING: Bid your final and complete PRICE, bid and switch will be reported to freelancer and disqualify you
I need a program to operate on a MAC OR a website that will do the following:
Go to the link below.
https://web.sba.gov/dsbs/search/dsp_quicksearch.cfm
Search By Metropolitan Statistical Area (The results should be Less than 5000 records per category)
The following link will provide the Metropolitan Statistical Area
https://www.naics.com/business-lists/counts-by-msa/
There are 338 MSA’s
Search results by Category:
HUBZone,
8(a),
Small Disadvantaged Business (SDB),
Woman-owned,
Veteran owned and Service Disabled Veteran-owned
(Some MSA’s might not have all categories)
Please gather the counts designated by MSA for Each Category in a separate table, that includes the date of running the program, and tell me the name of each count in four fields, Date Run, MSA code, Category and Count per Category.
I want a simple easy to click button to export these fields in this table: | delineated to seperate the fields
Date Run
MSA Code
Category
Count per Category
When you click on the count for each category, it will take you to a list. The list is 25 per page.
Click company name to go to detail, in a different table capture this link for each record once. The UEI field is the key field for the record, HTML Code, Date Run, and company name, MSA code
https://web.sba.gov/dsbs/search/dsp_profile.cfm?RequestTimeout=60&SAM_UEI=PT2EV9CKDX89
On the first run, gather all data, in a second table, via the HTML code and have field the UEI as a key field and the company name
This needs to repeat for each category and also for every state
I want a simple easy to click button to export these fields from this table: | delineated to separate the fields
Date Run
MSA Code
UEI
Company Name
HTML Code
I want to run this program every week or at my discretion.
Each additional time ran, validate the “This profile was last updated” if the date is the same ignore the record and continue to the next record in the Profile List, if the UEI has not been gathered previously, grab the data, The UEI field is the key field for the record, HTML Code, Date Run, and company name, MSA code
I need a program to operate on a MAC OR a website that will do the following:
Go to the link below.
https://web.sba.gov/dsbs/search/dsp_quicksearch.cfm
Search By Metropolitan Statistical Area (The results should be Less than 5000 records per category)
The following link will provide the Metropolitan Statistical Area
https://www.naics.com/business-lists/counts-by-msa/
There are 338 MSA’s
Search results by Category:
HUBZone,
8(a),
Small Disadvantaged Business (SDB),
Woman-owned,
Veteran owned and Service Disabled Veteran-owned
(Some MSA’s might not have all categories)
Please gather the counts designated by MSA for Each Category in a separate table, that includes the date of running the program, and tell me the name of each count in four fields, Date Run, MSA code, Category and Count per Category.
I want a simple easy to click button to export these fields in this table: | delineated to seperate the fields
Date Run
MSA Code
Category
Count per Category
When you click on the count for each category, it will take you to a list. The list is 25 per page.
Click company name to go to detail, in a different table capture this link for each record once. The UEI field is the key field for the record, HTML Code, Date Run, and company name, MSA code
https://web.sba.gov/dsbs/search/dsp_profile.cfm?RequestTimeout=60&SAM_UEI=PT2EV9CKDX89
On the first run, gather all data, in a second table, via the HTML code and have field the UEI as a key field and the company name
This needs to repeat for each category and also for every state
I want a simple easy to click button to export these fields from this table: | delineated to separate the fields
Date Run
MSA Code
UEI
Company Name
HTML Code
I want to run this program every week or at my discretion.
Each additional time ran, validate the “This profile was last updated” if the date is the same ignore the record and continue to the next record in the Profile List, if the UEI has not been gathered previously, grab the data, The UEI field is the key field for the record, HTML Code, Date Run, and company name, MSA code