Download free SAMPLE:
Philips Light Bulbs Database .xls
Buy complete database:
Coverage: cars, trucks, bikes, snowmobiles sold in United States and Canada in 1946-2020.
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.
Download free SAMPLE:
Sylvania light bulbs.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!
List of makes included (Philips)
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.
Philips automotive bulb finder 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 only 13 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, I got 133 brands and 37113 models, lights available (columns) also changed and now each light type can have multiple values.
In early 2019 Philips changed its domain name to https://www.automotivebulbfinder.com/philips/ but DID NOT updated their database as mid-2020, few customers suggested me scraping data from other websites and we choose www.sylvania-automotive.com in July 2020.
In October or November 2020 Philips website finally been updated with many 2019 and 2020 models, in January 2021 I asked programmer partner to update scraper to new domain name and after 7 days of continous scraping I posted new update on 30 January 2021.
Download file include both 2018 and 2021 updates, because I noticed that they deleted some makes and qualifiers, number of rows dropped to 33461.