Extreme Music

EXTREME_MUSICComposition

PUBLISHER · XLSX · GBP

Configuration

Display name: Extreme Music
Key: EXTREME_MUSIC
Rights layer: Composition
File format: XLSX
Default currency: GBP
Source kind: PUBLISHER
Notes: Production music library writer statement (XLSX). No period or territory columns: earning_date is left NULL, and territory_raw carries the Source name for the override table to resolve.

Extraction query

Reads XLSXUpdated 10/12/2026

SELECT row_number() OVER () AS line_number, trim("Title") AS song_title, upper(trim(regexp_replace(replace("Title", chr(160), ' '), '[[:space:]]+', ' ', 'g'))) AS song_title_key, trim("Composer") AS writer_name, upper(trim(replace("Source", chr(160), ' '))) AS source_name_key, upper(trim(replace("Catalogue No", chr(160), ' '))) AS income_class_key, upper(trim(replace("Income Type", chr(160), ' '))) AS right_type_key, upper(trim(replace("Source", chr(160), ' '))) AS territory_raw, TRY_CAST(TRY_CAST(trim("Your Share") AS DOUBLE) AS DECIMAL(9,6)) AS share_percentage, TRY_CAST(TRY_CAST(trim("Amount Rcvd") AS DOUBLE) AS DECIMAL(14,6)) AS amount_gross, TRY_CAST(TRY_CAST(trim("Amount Due") AS DOUBLE) AS DECIMAL(14,6)) AS amount_raw, to_json(row) AS source_row FROM read_xlsx('{{file}}', header = true, all_varchar = true) AS row;

Raw row count query — overrides the generic reader for the integrity check

SELECT COUNT(*) AS raw_count FROM read_xlsx('{{file}}',
          header = true,
          all_varchar = true);

Territory resolution

Edit overrides

territory_raw is resolved to an ISO 3166-1 alpha-2 code in code via a country lookup — not with rules. Values the lookup can't resolve (historical territories, regional groupings) fall back to this override table.

ANIMATO MUSIC BULGARIA→BG

AUSTRALIAN AMCOS SYNCHRONISATION→AU

AUSTRALIAN DIRECT LICENSING→AU

CANADIAN SYNCHRONISATION→CA

EXTREME SUNDRY UK→GB

GERMAN SYNCHRONISATION→DE

IRELAND MCPS SYNCHRONISATION→IE

MECHANICAL LICENSING COLLECTIVE→US

MUSIC REPORTS USA→US

NEW ZEALAND AMCOS SYNCHRONISATION→NZ

SCANDINAVIAN STIM PERFORMANCE→SE

SONY JAPAN→JP

SONY UK→GB

SUISA - SWITZERLAND→CH

TUNECORE USA→US

UK MCPS SYNCHRONISATION→GB

USA SYNCHRONISATION→US

YOU TUBE AD-REV USA→US

YOU TUBE AD-REV USA TWO STEPS→US

Normalization rules

Edit rules

This source's own rules, grouped by the attribute each writes. First match wins, top to bottom; conditions within a rule are ANDed. Each group ends in a pinned catch-all.

Stage 1 — Raw match keys to standard enums

income_channel_std

66 rules

1OTHERincome_class_key ~ EXCESS COMMISSI*

2OTHERincome_class_key ~ MCPS * ADJ*

3STREAMING_AUDIOincome_class_key ~ SPOTIFY*

4STREAMING_AUDIOincome_class_key ~ APPLE MUSIC*

5STREAMING_AUDIOincome_class_key ~ AMAZON MUSIC*

6STREAMING_AUDIOincome_class_key ~ AMAZON UNLIMITE*

7STREAMING_AUDIOincome_class_key ~ TIDAL*

8STREAMING_AUDIOincome_class_key ~ QOBUZ*

9STREAMING_AUDIOincome_class_key ~ DEEZER*

10STREAMING_AUDIOincome_class_key ~ PANDORA*

11STREAMING_AUDIOincome_class_key ~ SOUNDCLOUD*

12INTERNET_RADIOincome_class_key ~ BBC RADIOPLAYER*

13DOWNLOADincome_class_key ~ ITUNES*

14DOWNLOADincome_class_key ~ APPLE/ITUNES*

15STREAMING_VIDEOincome_class_key ~ GEOL - *

16STREAMING_VIDEOincome_class_key ~ BBC IPLAYER*

17STREAMING_VIDEOincome_class_key ~ YOUTUBE*

18STREAMING_VIDEOincome_class_key ~ NETFLIX*

19STREAMING_VIDEOincome_class_key ~ AMAZON*

20STREAMING_VIDEOincome_class_key ~ DISNEY+*

21STREAMING_VIDEOincome_class_key ~ DISNEY PLUS*

22STREAMING_VIDEOincome_class_key ~ VIAPLAY*

23STREAMING_VIDEOincome_class_key ~ SKY STORE*

24STREAMING_VIDEOincome_class_key ~ SKY REPLAY*

25STREAMING_VIDEOincome_class_key ~ HBO*

26STREAMING_VIDEOincome_class_key ~ RAKUTEN*

27STREAMING_VIDEOincome_class_key ~ APPLE TV+*

28STREAMING_VIDEOincome_class_key ~ PARAMOUNT+*

29STREAMING_VIDEOincome_class_key ~ GOOGLE PLAY*

30STREAMING_VIDEOincome_class_key ~ INTERAKTIVE TV*

31STREAMING_VIDEOincome_class_key ~ DRTV*

32STREAMING_VIDEOincome_class_key ~ DR ON-DEMAND*

33STREAMING_VIDEOincome_class_key ~ VIAFREE*

34STREAMING_VIDEOincome_class_key ~ TV2 PLAY*

35STREAMING_VIDEOincome_class_key ~ C MORE*

36STREAMING_VIDEOincome_class_key ~ VOD *

37STREAMING_VIDEOincome_class_key ~ CATCHUP*

38STREAMING_VIDEOincome_class_key ~ FACEBOOK*

39STREAMING_VIDEOincome_class_key ~ INSTAGRAM*

40STREAMING_VIDEOincome_class_key ~ TIKTOK*

41HOME_VIDEOincome_class_key ~ BBCDVD*

42TVincome_class_key ~ BBC*

43TVincome_class_key ~ CBBC*

44TVincome_class_key ~ CBEEBIES*

45TVincome_class_key ~ ITV? *

46TVincome_class_key ~ NICK JR*

47TVincome_class_key ~ NICKELODEON*

48TVincome_class_key ~ COMEDY CENTRAL*

49TVincome_class_key ~ MTV *

50TVincome_class_key ~ VIASAT FILM*

51TVincome_class_key ~ SKY ATLANTIC*

52TVincome_class_key ~ DAVE *

53TVincome_class_key ~ EDUCATIONAL TV*

54SYNC_BLANKETincome_class_key ~ BLANKET INCOME*

55STREAMING_VIDEOsource_name_key ~ YOU TUBE AD-REV*

56STREAMING_AUDIOsource_name_key ~ MECHANICAL LICENSING COLLECTIVE

57STREAMING_AUDIOsource_name_key ~ TUNECORE*

58TVsource_name_key ~ BENELUX BUMA/STEMRA AND income_class_key ~ *

59SYNC_GENERALsource_name_key ~ *SYNCHRONISATION

60SYNC_GENERALsource_name_key ~ AUSTRALIAN DIRECT LICENSING

61SYNC_GENERALsource_name_key ~ SOURCE AUDIO

62SYNC_GENERALsource_name_key ~ SONY JAPAN AND income_class_key ~ *

63SYNC_GENERALright_type_key ~ SYNCH.*

64SYNC_GENERALright_type_key ~ MEC/SYNC*

65OTHERright_type_key ~ OTHER*

66OTHERsource_name_key ~ SONY UK

Catch-allUNCLASSIFIEDMatches every line not caught above.

right_type_std

23 rules

1PERFORMANCEsource_name_key ~ SCANDINAVIAN STIM PERFORMANCE

2MECHANICALsource_name_key ~ MECHANICAL LICENSING COLLECTIVE

3MECHANICALincome_class_key ~ SPOTIFY*

4MECHANICALincome_class_key ~ APPLE MUSIC*

5MECHANICALincome_class_key ~ AMAZON MUSIC*

6MECHANICALincome_class_key ~ AMAZON UNLIMITE*

7MECHANICALincome_class_key ~ TIDAL*

8MECHANICALincome_class_key ~ QOBUZ*

9MECHANICALincome_class_key ~ DEEZER*

10MECHANICALincome_class_key ~ PANDORA*

11MECHANICALincome_class_key ~ SOUNDCLOUD*

12MECHANICALincome_class_key ~ ITUNES*

13MECHANICALincome_class_key ~ APPLE/ITUNES*

14OTHERincome_class_key ~ EXCESS COMMISSI*

15OTHERincome_class_key ~ MCPS * ADJ*

16SYNCright_type_key ~ SYNCH.*

17SYNCright_type_key ~ MEC/SYNC*

18SYNCsource_name_key ~ *SYNCHRONISATION

19SYNCsource_name_key ~ AUSTRALIAN DIRECT LICENSING

20SYNCsource_name_key ~ SOURCE AUDIO

21SYNCsource_name_key ~ SONY JAPAN AND income_class_key ~ *

22OTHERright_type_key ~ OTHER*

23OTHERsource_name_key ~ SONY UK

Catch-allUNCLASSIFIEDMatches every line not caught above.

Stage 2 — Standard enums to derived values

is_digital

3 rules

1truenormalized_income_channel ~ STREAMING_*

2truenormalized_income_channel ~ DOWNLOAD

3truenormalized_income_channel ~ INTERNET_RADIO

Catch-allfalseMatches every line not caught above.

is_performance

1 rule

1truenormalized_right_type ~ PERFORMANCE

Catch-allfalseMatches every line not caught above.