Light bulbs database


Download free SAMPLE:

Sylvania SAMPLE .xlsx

Buy complete database:

Tired of lack of updates in Philips website, few customer suggested me scraping data from other websites and we choose It was a headache to make a scraper for it, and following customer requirements (one column for each bulb type) it resulted in a database with 924 columns because light bulb labels vary a lot, there are many labels specific to one or few models only. I don’t know if is ideal format so your suggestions are welcome!


Download free SAMPLE:
Light Bulbs Database SAMPLE .xls

Buy complete 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 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.


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, 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 theoretically I can. As September 2018 neither Philips and XenonHids added 2018 models, but found another website that did added 2018 models:

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 thoughts on “Light bulbs database

    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!

  1. if anyone understand what is the problem with below customer and how I can make databases to find cars compatible with certain headlight, let me know!

    (12:59:32 AM) Visitor 53298416: no unfortunaly this will not help me
    (12:59:37 AM) Visitor 53298416: thanks tho
    (12:59:46 AM) Teoalida: how it should be to help you?
    (1:00:27 AM) Visitor 53298416: by putting a the headlight number and for it to show me all cars that the headlight works with
    (1:01:09 AM) Teoalida: are you able to use Excel filter function to show only rows displaying cars with certain light type?
    (1:01:38 AM) Visitor 53298416: no
    (1:10:03 AM) *** Visitor 53298416 has left ***

Leave a Reply

Your email address will not be published. Required fields are marked *