Hi, this project is focused on building and enriching a database from information located in this google sheet. After the table is built, I would like to perform web search data enrichment / data entry. process Most of the information will be found from either: one of the fields of the the google sheet, in the description column labeled 'message' or from automated data mining / manual enrichment. Finally, I would like to run some basic reports to generate some lists and insights.
Google Sheet Link
(removed by Toogit admin)
This is a 2 phase project.
Phase 1
I want to create a table with the following columns:
Date (day, month, year)
Name of Company or Fire Department
Size of Fire Departmen (Web search data enriching)
Location of Inquiry (Country)
Location of Inquiry (State)
Location of Inquiry (City)
Size of Fire Department (Web search data enriching)
Type of Firefighter or Fire Department? (Volunteer, Career, Combination, Other)
Contact Name
Email address
Phone
Type of Outreach (Firefighter, Federal Agency, State, Local, Corporate, Investor, Media, Wholesale)
Industry (Fire, Law enforcement, EMS, industrial, Teclo, military, marine, medical, etc)
Telecommunications company (Yes or no)
Demo Request (Yes or no)
Request for proposal, quote, or purchase (Yes or no)
Compatibility with other systems (yes or no)
MSA (yes or no)
Scott Safety / Scott Sight / Scott / or 3M (yes or no)
Drager (yes or no)
Type of C-THRU applications: (Seeing in low visibility environment, Handsfree navigation, navigation in submarines, brownout conditions for helicopter pilot, personal tracking in pharmaceutical manufacturing environments, etc) -----These will likely be manually entered.
Phase 2
I would then like to be able to run a query on the following request:
Number and list of different countries
Number and list of fire departments
Size of each fire department (Web search data enriching)
Number and list of volunteer
Number and list of career and combination firefighters
Number and list of all demo requests
Number and list of requests for proposal / request for quote / request for purchase?
Number and list of corporate inquiries by name
Number and list of all telecommunication company requests: Companies like Verizon, Sprint, Telus, AT&T, etc
List of countries where each telco company is based (US, Croatia, Canada, etc)
Number and list of all C-THRU applications inquiries (Seeing in low visibility environment, navigation in submarines, brownout conditions for helicopter pilot, personal tracking in pharmaceutical manufacturing environments, etc)
Number and list of different Industries ? (Fire, EMS, Law enforcement, manufacturing, military, marine, mining, etc)
Number and list of press requests
Number of list of investor requests
Number of list of inquiries about compatibility with other systems?
Number and list of inquiries that reference "MSA"
Number and list of inquiries that reference "Scott', 'Scott Safety', or '3M"
Number and list of inquiries that reference "Draeger"
Number of inquiries per year 2016, 2017, 2018, 2019, 2020
Number of total inquiries
Thank you and please let me know if this is of interest, what the estimate (cost and time)
About the recuiterMember since May 20, 2018 Hasan Kumar Red
from Uttar Pradesh, India