I use
oshwlab.com (see
my projects), and many but not all do include BOMs. When included, you can even download the BOM in Excel 2007+ format; I suggest you use Python and one of the Excel format libraries like
pylightxl to read and convert the files. (Many of the OSHWLab projects are created using the
EasyEDA online PCB editor suite, which includes integration with JLCPCB manufacturing and LCSC parts catalog. Very gentle learning curve for hobbyists.)
The downside is that these are typically hobbyist projects –– including mine! –– so quality varies a lot, and is predominantly on the lower end of the scale. There are also a lot of variants of the same project (due to Open Source HardWare making it easy to do so, especially for us hobbyists), so you'll get very skewed results unless you human-filter the projects. Auto-scraping the entire site would also be quite
unfriendly; at minimum, contact them and describe your project and intent for the data, first.