Web Analytics Made Easy -
StatCounter

Light bulbs database

Light bulbs car databaseDownload free SAMPLE:
Light Bulbs Database SAMPLE .xls

Buy FULL database:

Coverage: cars, trucks, bikes, snowmobiles sold in United States and Canada in 1958-2019.

Looking for European database? Please suggest websites from where I can scrap data and create a similar database! Other than https://am-application.osram.info/en where selecting each car do not make a distinct URL and light bulb types can be seen in a pop-up by clicking various parts of car = effectively impossible to scrap.

List of makes included

Acura, Advance Mixer, Alfa Romeo, AM General, American LaFrance, American Motors, Aprilia Motorcycle, Arctic Cat, Aston Martin, Asuna, Audi, Austin, Austin Healey, Autocar, Avanti, Bentley, Bering, Bertone, BMW, BMW Motorcycle, Bricklin, Buell Motorcycle, Bugatti, Buick, Cadillac, Can-Am Motorcycle, Capacity Of Texas, Chevrolet, Chrysler, Citroen, Daewoo, Daihatsu, DeLorean, Diamond Reo, Dodge, Ducati Motorcycle, Eagle, Edsel, Ferrari, Fiat, Fisker, Ford, Freightliner, Gas Gas Motorcycle, Genesis, Geo, Giant, GMC, Harley Davidson Motorcycle, Hino, Honda, Honda Motorcycle, Hummer, Hyosung Motorcycle, Hyundai, Indian Motorcycle, Indiana Phoenix, Infiniti, International, Isuzu, Iveco, Jaguar, Jeep, Kalmar, Kawasaki Motorcycle, Kenworth, Kia, Kovatch, KTM Motorcycle, Lada, Lamborghini, Land Rover, Lexus, Lincoln, Mack, Maserati, Maybach, Mazda, Mercedes-Benz, Mercury, Merkur, MG, Mini, Mitsubishi, Mitsubishi Fuso, Mobility Ventures, Moto Guzzi Motorcycle, Nissan, Oldsmobile, Opel, Peterbilt, Peugeot, Piaggio Motorcycle, Plymouth, Polaris, Polaris Motorcycle, Pontiac, Porsche, Ram, Renault, Rolls-Royce, Rover, Saab, Saturn, Scion, Seagrave Fire Apparatus, Simca, Ski-Doo, Smart, SRT, Sterling, Studebaker, Subaru, Sunbeam, Suzuki, Suzuki Motorcycle, Terex / Terex Advance, Tesla, Think, Toyota, Triumph, Triumph Motorcycle, UD, Vespa Motorcycle, Victory Motorcycle, Volkswagen, Volvo, VPG, White/GMC, Yamaha, Yamaha Motorcycle, Yugo, ZERO Motorcycle.

History

Database created in March 2017 (137 makes, 24379 models), for a customer who needed a vehicle database of light bulb types, he told me to scrap data from philipsautolighting.com, which took about 30 hours. Later I published database on website because other people were asking me for same thing.

Updated June 2017 (140 makes, 25682 models), after noticing that Philips added 2017 models.

Another customer asked me if I can scrap from xenonhids.com theoretically I can. As September 2018 neither Philips and XenonHids added 2018 models, but found another website that did added 2018 models: xenondepot.com.

Philips finally updated their website in October 2018, adding most 2018 models and few 2019 models, but as usual, it do not contain new cars as soon they are launched, but with a delay of few months. I also do not know how often Philips website will be updated in the future.

The website was also redesigned so I could not scrap it anymore with the standard “universal” scraper. I asked a programmer partner to make a custom scraper for it. Due to same reason, scraper ran much slower than before and took 150 hours to scrap all vehicles. Brands were reorganized and number of models increased greatly to 37113, lights available (columns) also changed and now each light type can have multiple values.

3 comments

1 ping

  1. It seems like this website updated the 2018 database for cars its been a while, https://www.xenonpro.com
    Maybe you can check there to get your database updated for your customers?

    1. I refreshed page multiple times and been able to open website once, but then stopped working again, showing Error 1009. Not really enjoying scraping data from websites giving errors. And why I should scrap another website when I can update Philips?

      Not sure why you didn’t saw this row
      As October 2018, Philips has been updated with 2018 and 2019 models, but website was also redesigned preventing me to scrap it with the universal scraper. I asked a programmer to make a custom scraper for it. Update of my database coming soon!

  2. very interesting post, i actually love this web site, carry on it

  1. […] Light bulbs database […]

Leave a Reply

Your email address will not be published.