The Record Collectors Guild Forum Index

Post new topic   Reply to topic
View previous topic Printable version Log in to check your private messages View next topic
Author Message
UrmelOffline
Post subject: Database for a Radioshow  PostPosted: Feb 06, 2011 - 06:04 AM
Level 1
Level 1


Joined: Feb 04, 2011
Posts: 4

Status: Offline
What do you think?

I'm an old radiofreak!
Alan Bangs, some of you know him ...
made a radio show from 1975 till 1995, from 1996 till 1998 and now from April 2010 till not sure Wink
I taped this shows every week, from 1985 till 1990 twice a week.

Every single Tape (Radio-Show) is now on my Hard Drive and I'll cataloguing every Single show with every single Song.

Searching every Track with, Catalog #, Format etc.

What do you think is the best way to find my needed infos to build a Database

here is a extract


_____________________________________________________________________________________________________________________________


Night Flight • 9. November 1980

Edition Nr. ?? in 1980 • Edition ??? since May 25, 1975


DISC 1 [43:59.293]

01. Orchestral Manoeuvres In The Dark - 2nd Thought
Album: «Organisation» • Released: October 24, 1980 • Label: Dindisc • Country: UK • Catalog #: DID 6 • Format: Vinyl, LP

02. Talking Heads - The Overload
Album: «Remain In Light» • Released: October 8, 1980 • Label: Sire • Country: US • Catalog #: SRK 6095 • Format: Vinyl, LP

03. Patti Smith - Kimberly
Album: «Horses» • Released: November 1975 • Label: Arista • Country: US • Catalog #: AL 4066 • Format: Vinyl, LP

04. Twinkle Brothers - Patoo
Album: «Countrymen» • Released: 1980 • Label: Virgin • Country: UK • Catalog #: 202 825-320 • Format: Vinyl, LP

05. Twinkle Brothers - Never Get Burn
Album: «Countrymen» • Released: 1980 • Label: Virgin • Country: UK • Catalog #: 202 825-320 • Format: Vinyl, LP

06. The Ruts - S.U.S.
Album: «The Crack» • Released: September 1979 • Label: Virgin • Country: UK • Catalog #: V 2132 • Format: Vinyl, LP

07. The Who - A Legal Matter
Album: «My Generation» • Released: December 3, 1965 • Label: Brunswick • Country: UK • Catalog #: LAT 8616 • Format: Vinyl, LP

08. John Lennon/Plastic Ono Band - Remember
Album: «John Lennon/Plastic Ono Band» • Released: December 11, 1970 • Label: Apple • Country: US • Catalog #: SW 3372 • Format: Vinyl, LP

09. Doll By Doll - Butcher Boy
Album: «Remember» • Released: March 1979 • Label: Automatic • Country: UK • Catalog #: K 56618 • Format: Vinyl, LP

10. The Doors - Roadhouse Blues
Album: «Morrison Hotel» • Released: February 1970 • Label: Elektra • Country: US • Catalog #: EKS 75007 • Format: Vinyl, LP


DISC 2 [44:12.064]

01. The Doors - Roadhouse Blues
Album: «Morrison Hotel» • Released: February 1970 • Label: Elektra • Country: US • Catalog #: EKS 75007 • Format: Vinyl, LP

02. Talking Heads - Houses In Motion
Album: «Remain In Light» • Released: October 8, 1980 • Label: Sire • Country: US • Catalog #: SRK 6095 • Format: Vinyl, LP

03. The Rass-Es Band - Gravitational Echoes
Album: «Harder Na Rass» • Released: 1979 • Label: Ballistic • Country: UK • Catalog #: LBR 1031 • Format: Vinyl, LP

04. Spandau Ballet - To Cut A Long Story Short
Single: «To Cut A Long Story Short» • Released: November 3, 1980 • Label: Chrysalis • Country: UK • Catalog #: CHR 1331 • Format: Vinyl, 7"

05. The Ruts - Love In Vain
Album: «Grin And Bear It» • Released: October 1980 • Label: Virgin • Country: UK • Catalog #: V 2188 • Format: Vinyl, LP, Compilation

06. Kevin Coyne - Day To Day
Album: «Bursting Bubbles» • Released: March 28, 1980 • Label: Virgin • Country: UK • Catalog #: V 2152 • Format: Vinyl, LP

07. Can - Moonshake
Album: «Future Days» • Released: 1973 • Label: United Artists • Country: Germany • Catalog #: UAS 29 505 • Format: Vinyl, LP

08. Garland Jeffreys - Ballad Of Me
Album: «Garland Jeffreys» • Released: 1973 • Label: Atlantic • Country: Germany • Catalog #: ATL 50716 • Format: Vinyl, LP

09. Neil Young - The Old Homestead
Album: «Hawks And Doves» • Released: November 3, 1980 • Label: Reprise • Country: US • Catalog #: HS 2297 • Format: Vinyl, LP

10. John Lennon/Plastic Ono Band - Isolation
Album: «John Lennon/Plastic Ono Band» • Released: December 11, 1970 • Label: Apple • Country: US • Catalog #: SW 3372 • Format: Vinyl, LP


_____________________________________________________________________________________________________________________________


Night Flight • 16. November 1980

Edition ?? in 1980 • Edition ???, since May 25, 1975


DISC 1 [44:05.333]

01. Gay And Terry Woods - Back To You
Album: «The Time Is Right» • Released: 1976 • Label: Antilles • Country: US • Catalog #: AN 7029 • Format: Vinyl, LP

02. Dire Straits - Romeo And Juliet
Album: «Making Movies» • Released: October 17, 1980 • Label: Vertigo • Country: UK • Catalog #: 6359 034 • Format: Vinyl, LP

03. John Martyn - Some People Are Crazy
Album: «Grace And Danger» • Released: October 1980 • Label: Island • Country: UK • Catalog #: ILPS 9560 • Format: Vinyl, LP

04. Van Morrison - Saint Dominic's Preview
Album: «Saint Dominic's Preview» • Released: July 1972 • Label: Warner Bros. • Country: US • Catalog #: BS 2633 • Format: Vinyl, LP

05. Gay And Terry Woods - The Reward
Album: «Tender Hooks» • Released: 1978 • Label: Rockburgh • Country: UK • Catalog #: ROC 104 • Format: Vinyl, LP

06. Neil Young - Lost In Space
Album: «Hawks And Doves» • Released: November 3, 1980 • Label: Reprise • Country: US • Catalog #: HS 2297 • Format: Vinyl, LP

07. Scullion - 18
Album: «Balance And Control» • Released: 1980 • Label: WEA • Country: US • Catalog #: K 58205 • Format: Vinyl, LP

08. John Martyn - Lookin' On
Album: «Grace And Danger» • Released: October 1980 • Label: Island • Country: UK • Catalog #: ILPS 9560 • Format: Vinyl, LP


DISC 2 [44:09.307]

01. Can - Future Days
Album: «Future Days» • Released: 1973 • Label: United Artists • Country: Germany • Catalog #: UAS 29 505 • Format: Vinyl, LP

02. Gay And Terry Woods - Solace
Album: «Renowned» • Released: 1976 • Label: Polydor • Country: UK • Catalog #: 2383 406 • Format: Vinyl, LP

03. Bruce Springsteen - Wreck On The Highway
Album: «The River» • Released: October 13, 1980 • Label: Columbia • Country: US • Catalog #: PC2 36854 • Format: 2 x Vinyl, LP

04. Naná Vasconcelos - Cego Aderaldo
Album: «Saudades» • Released: March 1979 • Label: ECM • Country: Germany • Catalog #: ECM 1147 • Format: Vinyl, LP

05. John Martyn - Sweet Little Mystery
Album: «Grace And Danger» • Released: October 1980 • Label: Island • Country: UK • Catalog #: ILPS 9560 • Format: Vinyl, LP

06.
Album: «» • Released: • Label: • Country: • Catalog #: • Format: Vinyl

07. Skip James - Devil Got My Woman
Album: «Devil Got My Woman» • Released: 1968 • Label: Vanguard • Country: US • Catalog #: VSD 79273 • Format: Vinyl, LP
 
 View user's profile Send private message  
Reply with quote Back to top
Global_Dog_ProductionsOffline
Post subject:   PostPosted: Feb 06, 2011 - 10:11 PM
R.C.Guild-SM
R.C.Guild-SM


Joined: May 01, 2006
Posts: 1146
Location: Portland, Oregon
Status: Offline
[date] - [song number] - [artist] - [song title] - [label] - [country] - [prefix] - [number] - [format] - [release date] (you might want to break this into 3 fields for month, day and year).

Prefixes can be messy, and many numbering systems use prefixes for combined numbering systems such as CBS and EMI. In some cases such as the US CBS used certain letters as price codes combined with an "E" for Epic, "C" for Columbia, etc. In Europe EMI took it even further with a combined numbering system that used 45s, EPs and LPs all together.

Late in the 60s EMI created what is arguably one of the biggest nightmares when it consolidated all of its labels in Europe for the most part into a single unified numbering system that included singles, EPs and LPs. The numbering on them consisted of a prefix that began with a one or two digit number that indicated the country of origin followed by a "C" and then three more digits to complete the prefix. "006" was used to indicate singles but some singles got different numbers but all singles always had two zeros followed by a single digit. "064" was the most common indicator for a single LP and "164" for double LPs.

Country codes likewise weren't always consistant. 1 was the country code for West Germany but some records issued in Spain began with "1J". "1A" was used by numerous countries. These are the country codes I know of...

1 = West Germany
2 = France
2J = Greece
3 = Italy
4 = Belgium
4E = Sweden
5 = Holland
6 = Denmark
7 = Sweden
8C = Norway
8E = Portugal - I know of one Angolan single using 8E
10 = Spain
14 = Greece
31 = Brazil

Other countries I know were a part of this numbering system but I don't know the numbers for are Israel and Switzerland. I would imagine there were many others. 1A appears to be an "all Europe" prefix country code.

The actual record number following these prefixes was 5 digits and the following series would probably be the ones folks here would be most interested in.

00000 series - overlaps the 90000/60000 series, includes a group called The Beatles.
90000 series - 1969 - 1977
60000 series - 1977 - ? this is a continuation of the 90000 series after they ran out of numbers.

There isn't a whole lot of consistancy here for example some Pink Floyd issues are in the 00000 series and others are in the 90000 series.

Labels I know of using this series of numbers are A&M, Apple, Ariola, Arista, Asylum, Bell, Blue Thumb, Capitol. Columbia, Crystal, EMI, EMI Pathe, EMI Electrola, EMI Odeon, EMI Pathe, Electrola, Emidisc, Fame, Fantasy, HMV, Harvest, Immediate, Imperial, Italiana, Liberty, Motown, Odeon, Parlophone, Pathe, Pathe Marconi, Probe, Purple, RAK, Rare Earth, Regal Zonophone, Rolling Stones, Sonopresse, Stateside, Tamla Motown, United Artists.

_________________
http://www.globaldogproductions.info/
 
 View user's profile Send private message  
Reply with quote Back to top
UrmelOffline
Post subject:   PostPosted: Feb 07, 2011 - 01:38 AM
Level 1
Level 1


Joined: Feb 04, 2011
Posts: 4

Status: Offline
Global_Dog_Productions wrote:
[date] - [song number] - [artist] - [song title] - [label] - [country] - [prefix] - [number] - [format] - [release date] (you might want to break this into 3 fields for month, day and year).

Prefixes can be messy, and many numbering systems use prefixes for combined numbering systems such as CBS and EMI. In some cases such as the US CBS used certain letters as price codes combined with an "E" for Epic, "C" for Columbia, etc. In Europe EMI took it even further with a combined numbering system that used 45s, EPs and LPs all together.

Late in the 60s EMI created what is arguably one of the biggest nightmares when it consolidated all of its labels in Europe for the most part into a single unified numbering system that included singles, EPs and LPs. The numbering on them consisted of a prefix that began with a one or two digit number that indicated the country of origin followed by a "C" and then three more digits to complete the prefix. "006" was used to indicate singles but some singles got different numbers but all singles always had two zeros followed by a single digit. "064" was the most common indicator for a single LP and "164" for double LPs.

Country codes likewise weren't always consistant. 1 was the country code for West Germany but some records issued in Spain began with "1J". "1A" was used by numerous countries. These are the country codes I know of...

1 = West Germany
2 = France
2J = Greece
3 = Italy
4 = Belgium
4E = Sweden
5 = Holland
6 = Denmark
7 = Sweden
8C = Norway
8E = Portugal - I know of one Angolan single using 8E
10 = Spain
14 = Greece
31 = Brazil

Other countries I know were a part of this numbering system but I don't know the numbers for are Israel and Switzerland. I would imagine there were many others. 1A appears to be an "all Europe" prefix country code.

The actual record number following these prefixes was 5 digits and the following series would probably be the ones folks here would be most interested in.

00000 series - overlaps the 90000/60000 series, includes a group called The Beatles.
90000 series - 1969 - 1977
60000 series - 1977 - ? this is a continuation of the 90000 series after they ran out of numbers.

There isn't a whole lot of consistancy here for example some Pink Floyd issues are in the 00000 series and others are in the 90000 series.

Labels I know of using this series of numbers are A&M, Apple, Ariola, Arista, Asylum, Bell, Blue Thumb, Capitol. Columbia, Crystal, EMI, EMI Pathe, EMI Electrola, EMI Odeon, EMI Pathe, Electrola, Emidisc, Fame, Fantasy, HMV, Harvest, Immediate, Imperial, Italiana, Liberty, Motown, Odeon, Parlophone, Pathe, Pathe Marconi, Probe, Purple, RAK, Rare Earth, Regal Zonophone, Rolling Stones, Sonopresse, Stateside, Tamla Motown, United Artists.



Oh thank you Sir;
that's pretty good, very interesting and it helps a lot.
 
 View user's profile Send private message  
Reply with quote Back to top
Global_Dog_ProductionsOffline
Post subject:   PostPosted: Feb 07, 2011 - 02:33 AM
R.C.Guild-SM
R.C.Guild-SM


Joined: May 01, 2006
Posts: 1146
Location: Portland, Oregon
Status: Offline
Actually except for the prefixs I really didn't add anything. My database us at over 341,000 so I have a pretty good handle on this.

Best of luck,

Andy

_________________
http://www.globaldogproductions.info/
 
 View user's profile Send private message  
Reply with quote Back to top
Display posts from previous:     
Jump to:  
All times are GMT
Post new topic   Reply to topic
View previous topic Printable version Log in to check your private messages View next topic
Powered by PNphpBB2 © 2003-2007 The PNphpBB Group
Credits