I don’t know why people don’t use the EPREL database for this. You can get CRI, full spectra, flicker, etc for all LED bulbs that are legal to sell in the EU, and sometimes R9 and so on too. Just scan the QR code in the store and then read all the info, or search here: EPREL Public website

If you’re really good with OCR, it shouldn’t be hard to automatically process the spectrum images to calculate everything you need. Surely it’s not so hard to write a program to process images like this into a CSV of the SPD?

Here is a list of all E27 bulbs over 599lm with CRI, luminous flux, and some other info: https://files.catbox.moe/x2zo0p.csv. You can open this in Excel and then use the filter to find relevant bulbs.

There are other fields too, but some don’t map cleanly into CSV, so I can’t just export all of them. Can share the script I used to download if anyone cares.

Anyway: Why aren’t there any good high-CRI (>90), high-R9 (>60) bulbs that have decent luminous flux (>1000lm)? Why are they all so weak?

1 Thank