Data wants to be free, or something like that….<\/p>\n
Now that the FCC has made it easier to see all their data, it’s possible to construct information from the raw data that you can’t do by visiting the FCC web site.\u00a0 It also exposes how sloppy the FCC management of their data is.\u00a0\u00a0 They just appointed a couple guys to work on this – it’s a big job.<\/p>\n
Each Media Bureau application has parties – points of contact, lawyers, owners, consulting engineers….\u00a0 those are stored in a table called “Party”.\u00a0\u00a0 The Party # is tied to that specific entity\/person.<\/p>\n
One of the problems with database design is whether you need to capture historical information.\u00a0\u00a0 Let’s say you have an attorney who does a lot of FCC work, and is a “Party” to a large number of applications over the last 20 years.\u00a0\u00a0 He moves to a new office and gets a new phone number.\u00a0\u00a0 If I print out a 10 year old application, do I want to see his address at that time, or his current address?\u00a0 (What if he is dead?)<\/p>\n
The FCC seems to be moving toward a thing called an FRN (FCC Registration Number) that ties everything you do together like a social security number for the FCC. – but the old systems don’t use the FRN.\u00a0\u00a0\u00a0 The result is the same “Party” occurs in the party table perhaps 100s of times with slightly different information.<\/p>\n
Even so, it is interesting information – given the name of an attorney, you can see 20+ years of history of every application they were a party to, etc…<\/p>\n
You can wander around by starting at the list of current applications – look at the parties involved in that app, and follow your nose<\/p>\n
http:\/\/streamingradioguide.com\/recent-apps.php<\/a><\/p>\n or you can go right to the Party search and type in a part of a name and find all the parties that match your search, and then all of the appplications they were involved with (at least under that party ID#)<\/p>\n http:\/\/dev.streamingradioguide.com\/partyapps.php<\/a><\/p>\n Let’s say you knew there was a DC attorney named ZARAGOZA who does a lot of FCC work…<\/p>\n http:\/\/streamingradioguide.com\/partyapps.php?search=ZARAGOZA<\/a><\/p>\n","protected":false},"excerpt":{"rendered":" Data wants to be free, or something like that…. Now that the FCC has made it easier to see all their data, it’s possible to construct information from the raw data that you can’t do by visiting the FCC web … Continue reading