One entry per newspaper interest
column |
type |
description |
lms_application_id |
varchar(32) |
Primary index used for all applications. Corresponds with the FCC’s application identifier used in LMS and therefore can be used to cross reference with FCC raw data. Unless otherwise indicated, all relational tables in eLMS are linked by lms_application_id |
news_sequence |
int |
Sequence of newspaper within an application ID. |
frn |
varchar(11) |
FRN for newspaper |
name |
varchar(80) |
Name of entity that owns the newspaper |
newspaper_name |
varchar(80) |
Name of the newspaper |
location_city |
varchar(80) |
City name of primary area that the newspaper serves |
location_state |
varchar(2) |
Two letter state code of the primary area that the newspaper serves. |
pi_director |
varchar(1) |
Positional interest – director |
pi_genl_partner |
varchar(1) |
Positional interest – general partner |
pi_lc_llc_pllc_member |
varchar(1) |
Positional interest – LC/LLC/PLLC member |
pi_limited_partner |
varchar(1) |
Positional interest – limited partner |
pi_officer |
varchar(1) |
Positional interest – officer |
pi_parent_entity |
varchar(1) |
Positional interest – parent entity |
pi_stockholder |
varchar(1) |
Positional interest – stockholder |
pi_other |
varchar(1) |
Positional interest – other |
pi_other_desc |
varchar(255) |
Description of positional interest if “other” is selected |
pi_owner |
varchar(1) |
Positional interest – owner |
voting_pct |
float |
Voting percentage |
equity_pct |
float |
Equity percentage |
assets_pct |
float |
Assets percentage |