Light bulbs database

Sylvania

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 www.sylvania-automotive.com. 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!

Philips

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 am-application.osram.info 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.

7 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 ***

    1. All light bulbs websites are lagging in updates, Philips are missing 2019 too (only 13 models for MY 2019 are included) so Sylvania is the BEST according previous customers, and I will scrap it again every few months to get new cars they may add, but if they don’t add new cars I can’t do anything.

      In case I am wrong please tell me which is the most updated light bulbs website to see if I can make another database from it?

      You told me via email to scrap https://www.xenonpro.com/ … is easy to scrap because every car is accessible via HTML links so I avoid hassle going through drop-down boxes… but I don’t see how data offered here is better. Select BMW 2018 is complete, select 2019 and 2020 and you see NO car models other than 2-Series and motorcycles. Same about other brands, in 2019 and 2020 they have only half or even less models compared with 2018 or earlier. They may have got a database going to 2018 from other source and struggle to manually add 2019 and 2020 models, and they added only models that came in their hands. Beside this, it only contain headlights.

  2. Hello.
    I check many sites for car bulbs. But only Osram have a full list European cars. Maybe some changes in their web site and you can grab the information from it? I check the car Renault Kaptur, this car is made only in Europe. And no other sites don’t have it, except Osram.

Leave a Reply

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