I would like to make a spreadsheet or app that will produce a report if I enter in any of the following:
Identify a company by imputing one of the following:
Vin, MC Number, DOT Number, Lic Plate number, company name, email, etc
I have the API connection to the get the information.
Once the name of the company is found:
I like to pull any other information such as Vin, Lic Plate number, email, phone, address, etc that is the same as
in otherwords
I put a vin number in. i get that truck is found with Terry Trucking
Terry Trucking has 5 vins associated with 3 other companies, ABC trucking, DEF Trucking, and sad boy trucking.
Besides that ABC trucking have the same phone number
and DEF trucking use the same address.
the API can be found here
https://data.transportation.gov/Trucking-and-Motorcoaches/Inspections-Per-Unit/wt8s-2hbx/about_data?referrer=grok.com
https://data.transportation.gov/Trucking-and-Motorcoaches/SMS-Input-Motor-Carrier-Census-Information/kjg3-diqy/about_data
https://data.transportation.gov/Trucking-and-Motorcoaches/Vehicle-Inspection-File/fx4q-ay7w/about_data
... Show more