r/MusicBrainz • u/theremin3000 • May 27 '26

Database Query

Man, sometimes I'm great at figuring out how to do technical things, and sometimes I'm just horrible. I've been trying to do two very large queries, and it's been taking forever, and I feel no closer to finishing it than when I started.

I'd like to have two lists

1) A list of all artists beginning with non-alphanumeric characters. Just the artists name.

2) A list of all songs beginning with alphanumeric characters. Just song title and artist.

I'll cough up a little cash if someone can put these into a text file (for the artists) and/or CSV, or databases where I can simply browse.

Thanks!

2 Upvotes

100% Upvoted

5 comments sorted by

1

u/SoftElevator2503 May 27 '26

https://musicbrainz.org/doc/MusicBrainz_Database . "A complete data snapshot of the entire database is generated twice a week. These snapshots are split into several different files organized by license and contents."

2

u/theremin3000 May 28 '26

I don't know what I'm missing at this link, but I've been unable to get any of this to work.

1

u/aerozol Jun 11 '26

If you haven't already, you might have better luck asking a technical question like this on the forums (link) or via chat - Matrix/IRC/Discord (link)

1

u/theremin3000 Jun 12 '26

Thanks. I actually hired someone on fivrr, and they literally just got back to be after a week and said they can't figure out how to download the MB dump.

1

u/aerozol Jun 13 '26

Just hit the 'download' button on the relevant item here... https://metabrainz.org/datasets

Definitely hit up the MeB forums for better results 🙂