File: readme.html (for CDBS)

Update: 11/7/2014

Files: See the end of this file.

This is readme file for the publicly released files under CDBS. This file will be updated as needed.

CDBS is the Consolidated Database System for the FCC's Media Bureau. CDBS is a relational database; the field application_id is the primary key which associates data elements for many of the various tables.

The public files under CDBS are available at: CDBS Public Database Files . Normally, these files will be updated daily.

Each file, and the data elements they contain, as ordered in the file, are listed below. In this list, char indicates a character field with exactly the specified number of characters; varchar indicates a character field with up to the specified number of characters. In addition, there are several user-defined field types. These are listed at the bottom of this document.

A more descriptive listing of the data elements is in: Engineering Data Description This PDF document describes the fields in each table in alphabetical order, not the order as they appear in the data files. The fields in each file are pipe-delimited ("|").

The files have been compressed on a Unix system with zip (-l option). They can be unzipped on a PC using PKUNZIP, WINZip, or similar utilities.

The main table for FM engineering data is fm_eng_data. The field eng_record_type can either be 'C' (current records) or 'A' (archived or superceded records). There is a similar marker for AM data in table am_ant_sys. AM data are also located in am_eng_data.

Ownership information can be located through the party table. The app_party and fac_party tables hold the associated party_id key.

Questions and corrections concerning the CDBS data should be directed to:

AM & FM Radio

Using CDBS data: Jorden Brinn, jorden.brinn@fcc.gov

Other CDBS questions: James Bradshaw, james.bradshaw@fcc.gov

TV

All CDBS questions: Hossein Hashemzadeh, hossein.hashemzadeh@fcc.gov

CDBS TABLES

altc_group

Number Column Name Type
(1) app_arn char(12)
(2) fac_callsign char(12)
(3) facility_id int
(4) file_prefix char(10)
(5) main_application_id int
(6) tracked_by_group_ind char(1)
(7) app_service char(2)
(8) altc_group_id int, NOT NULL
(9) comm_city char(20)
(10) comm_state char(2)
(11) permit_prefix varchar(10)
(12) permit_arn varchar(12)
(13) order_number int, NOT NULL
(14) last_update_date datetime

am_ant_sys

Number Column Name Type
(1) ant_mode char(3)
(2) ant_sys_id int, NOT NULL
(3) application_id int, NOT NULL
(4) aug_count tinyint
(5) bad_data_switch char(1)
(6) domestic_pattern char(1)
(7) dummy_data_switch char(1)
(8) efficiency_restricted float()
(9) efficiency_theoretical float()
(10) feed_circ_other varchar(255)
(11) feed_circ_type char(2)
(12) hours_operation char(1), NOT NULL
(13) lat_deg int
(14) lat_dir char(1)
(15) lat_min int
(16) lat_sec float()
(17) lon_deg int
(18) lon_dir char(1)
(19) lon_min int
(20) lon_sec float()
(21) q_factor float()
(22) q_factor_custom_ind ind
(23) power float()
(24) rms_augmented float()
(25) rms_standard float()
(26) rms_theoretical float()
(27) tower_count tinyint
(28) eng_record_type char(1)
(29) biased_lat float()
(30) biased_long float()
(31) mainkey char(16)
(32) am_dom_status char(1)
(33) lat_whole_secs int
(34) lon_whole_secs int
(35) ant_dir_ind char(1)
(36) grandfathered_ind char(1)
(37) specified_hrs_range varchar(25)
(38) augmented_ind char(1)
(39) last_change_date datetime

am_augs

Number Column Name Type
(1) ant_sys_id int, NOT NULL
(2) aug_id tinyint, NOT NULL
(3) azimuth_deg float()
(4) radiation_aug float()
(5) span_deg float()
(6) last_change_date datetime

am_eng_data

Number Column Name Type
(1) ant_monitor name
(2) application_id int, NOT NULL
(3) broadcast_schedule char(1)
(4) encl_fence_dist float()
(5) facility_id int, NOT NULL
(6) sampl_sys_ind ind
(7) station_class char(1)
(8) time_zone char(1)
(9) region_2_class char(1)
(10) am_dom_status char(1)
(11) old_station_class char(2)
(12) specified_hours varchar(255)
(13) feed_circ_other varchar(255)
(14) feed_circ_type varchar(2)
(15) last_update_date datetime

am_towers

Number Column Name Type
(1) ant_sys_id int, NOT NULL
(2) asrn_id int
(3) elec_hgt_deg float()
(4) field_ratio float()
(5) hag_no_obst float()
(6) hgt_overall_mtr float()
(7) hgt_rad_ab float()
(8) hgt_radiator_mtr float()
(9) orientation_deg float()
(10) phasing_deg float()
(11) rad_hgt_deg float()
(12) spacing_deg float()
(13) top_loaded_switch char(1)
(14) topload_a float()
(15) topload_b float()
(16) topload_c float()
(17) topload_d float()
(18) tower_num tinyint, NOT NULL
(19) tower_pl_codes varchar(40)
(20) tower_ref_switch char(1)
(21) asrn_na_ind ind
(22) topload_apparent_hgt float()
(23) faa_notified_ind ind
(24) tower_type char(1)
(25) last_update_date datetime

amcmnts

Number Column Name Type
(1) application_id int, NOT NULL
(2) comment_type char(5)
(3) comment varchar()

ant_make

Number Column Name Type
(1) antenna_id int, NOT NULL
(2) ant_make char(3), NOT NULL
(3) ant_model_num char(60), NOT NULL
(4) app_service char(2), NOT NULL
(5) standard_ind char(1)
(6) last_change_date datetime

ant_pattern

Number Column Name Type
(1) antenna_id int, NOT NULL
(2) azimuth float(), NOT NULL
(3) field_value float(), NOT NULL
(4) additional_az_num smallint
(5) last_change_date datetime

app_party

Number Column Name Type
(1) application_id int, NOT NULL
(2) party_id int, NOT NULL
(3) party_type char(5), NOT NULL
(4) cert_title title
(5) cert_date datetime
(6) other_fcc_id int
(7) party_notify_ind ind
(8) party_relationship varchar(255)
(9) sig_present_ind ind
(10) sig_named varchar(60)
(11) last_change_date datetime

app_tracking

Number Column Name Type
(1) application_id int, NOT NULL
(2) app_status_date datetime
(3) cutoff_date datetime
(4) cutoff_type char(1)
(5) cp_exp_date datetime
(6) app_status varchar(5)
(7) dtv_checklist varchar(1)
(8) amendment_stamped_date datetime
(9) accepted_date datetime
(10) tolling_code char(1)
(11) last_change_date datetime

application

Number Column Name Type
(1) app_arn arn
(2) app_service char(2), NOT NULL
(3) application_id int, NOT NULL
(4) facility_id int, NOT NULL
(5) file_prefix file_prefix
(6) comm_city city
(7) comm_state state
(8) fac_frequency float()
(9) station_channel int
(10) fac_callsign callsign
(11) general_app_service varchar(2)
(12) app_type varchar(4)
(13) paper_filed_ind char(1)
(14) dtv_type varchar(8)
(15) frn varchar(10)
(16) shortform_app_arn varchar(12)
(17) shortform_file_prefix varchar(10)
(18) corresp_ind char(1)
(19) assoc_facility_id int
(20) network_affil varchar(100)
(21) sat_tv_ind char(1)
(22) comm_county char(20)
(23) comm_zip1 char(5)
(24) comm_zip2 char(4)
(25) app_code varchar(10)
(26) last_change_date datetime

call_sign_history

Number Column Name Type
(1) begin_date datetime
(2) callsign callsign
(3) callsign_hist_id int
(4) callsign_seq_id tinyint, NOT NULL
(5) facility_id int, NOT NULL
(6) last_change_date datetime

dtv_agreement_group

Number Column Name Type
(1) application_id int, NOT NULL
(2) fac_callsign callsign
(3) facility_id int
(4) order_num int
(5) dtv_agreement_group_id int, NOT NULL
(6) name varchar(60)
(7) last_change_date datetime

dtv_allotment

Number Column Name Type
(1) state state, NOT NULL
(2) city city, NOT NULL
(3) analog_channel int
(4) digital_channel int, NOT NULL
(5) erp float()
(6) haat float()
(7) lat_deg int
(8) lat_dir char(1)
(9) lat_min int
(10) lat_sec int
(11) lon_deg int
(12) lon_dir char(1)
(13) lon_min int
(14) lon_sec int
(15) biased_lat float()
(16) biased_long float()
(17) last_change_date datetime

dtv_channel_assignments

Number Column Name Type
(1) facility_id int, NOT NULL
(2) state char(2)
(3) city char(20)
(4) ntsc_channel int
(5) post_dtv_channel int
(6) erp float()
(7) haat float()
(8) antenna_id int
(9) latitude char(7)
(10) longitude char(8)
(11) rcamsl int
(12) ref_azimuth smallint
(13) da_ind char(1)
(14) pre_dtv_channel int
(15) callsign varchar(12)

dtv_facility

Number Column Name Type
(1) facility_id int, NOT NULL
(2) dtv_fac_status char(5)
(3) dtv_channel int
(4) last_change_date datetime

dtv_transition

Number Column Name Type
(1) dtv_cur_channel int
(2) application_id int, NOT NULL
(3) dtv_cur_na ind
(4) ntsc_cur_channel int
(5) ntsc_cur_na ind
(6) rep_max_cert char(1)
(7) file_prefix_cer_a char(10)
(8) app_arn_cer_a char(12)
(9) file_prefix_cer_b char(10)
(10) app_arn_cer_b char(12)
(11) file_prefix_cer_d char(10)
(12) app_arn_cer_d char(12)
(13) rep_max_cer_type char(3)
(14) file_prefix_cer_e char(10)
(15) app_arn_cer_e char(12)
(16) data_cert_ind ind
(17) election char(1)
(18) elected_channel_a int
(19) elected_channel_b int
(20) alt_elected_channel int
(21) intl_coord_ind ind
(22) cont_election char(1)
(23) cont_elected_channel int
(24) conflict_decision char(1)
(25) reference_no int
(26) negot_agreemt_ind ind
(27) tech_eng_ind ind
(28) tent_chan_status char(1)
(29) tentative_channel int
(30) post_tran_dtv_channel int
(31) pre_tran_dtv_channel int
(32) post_tran_auth_file_prefix char(10)
(33) post_tran_auth_app_arn char(12)
(34) post_tran_auth_not_yet_ind char(1)
(35) construction_deadline_date datetime
(36) post_tran_operating_ind char(1)
(37) op_status char(3)
(38) op_expected_date datetime
(39) op_power_level float()
(40) op_population_perc float()
(41) construction_complete_ind char(1)
(42) expect_cons_complete_date datetime
(43) const_not_begun char(1)
(44) const_underway char(1)
(45) const_addl_needed char(1)
(46) cp_status_ind char(1)
(47) cp_mod_needed_ind char(1)
(48) cp_mod_filed_ind char(1)
(49) cp_mod_file_prefix char(10)
(50) cp_mod_app_arn char(12)
(51) cp_mod_filed_date datetime
(52) cp_mod_expected_date datetime
(53) addl_fcc_action_ind char(1)
(54) addl_fcc_action_app_arn char(12)
(55) addl_fcc_action_file_prefix char(10)
(56) addl_fcc_action_date datetime
(57) addl_intl_ind char(1)
(58) addl_faa_approval_ind char(1)
(59) addl_local_approval_ind char(1)
(60) addl_equip_ind char(1)
(61) addl_equip_new_ant_ind char(1)
(62) addl_equip_adj_ant_ind char(1)
(63) addl_equip_switch_ant_ind char(1)
(64) addl_equip_new_trans_ind char(1)
(65) addl_equip_adj_trans_ind char(1)
(66) addl_equip_gen_install_ind char(1)
(67) addl_equip_other_ind char(1)
(68) addl_tower_ind char(1)
(69) addl_coord_ind char(1)
(70) addl_other_ind char(1)
(71) analog_service_status varchar(12)
(72) analog_status_ind char(1)
(73) dtv_transition_plan_ind char(1)
(74) addl_steps_ind char(1)
(75) analog_nightlight_ind char(1)
(76) analog_turnoff_pn_compl_flg char(1)
(77) binding_termination_flg varchar(5)
(78) termination_date_not_aff datetime
(79) termination_date_aff datetime
(80) aff_term_cert_flg varchar(5)
(81) cont_analog_flg varchar(5)
(82) phone_help_ctr_flg varchar(5)
(83) walkin_help_ctr_flg varchar(5)
(84) st_analog_nightlight_ind char(1)
(85) st_analog_nightlight_end_date datetime
(86) inf_analog_nightlight_ind char(1)
(87) inf_analog_nightlight_end datetime
(88) early_term_withdraw_ind char(1)
(89) termination_time_0612_flg varchar(5
(90) termination_date_nce datetime
(91) termination_time_nce_flg varchar(5)
(92) termination_time_notaff_flg varchar(5)
(93) termination_time_aff_flg varchar(5)
(94) nce_term_cert_flg char(1)
(95) ref_contact_phone char(10)
(96) ref_contact_hours varchar(60)
(97) an_participation_notice_ind char(1)
(98) an_eligibility_showing_ind char(1)
(99) an_objection_to_elig_showg_ind char(1)
(100) an_objection_callsign char(12)
(101) an_revocation_ind char(1)
(102) last_update_date datetime

elevation_ant_make

Number Column Name Type
(1) ant_make char(3), NOT NULL
(2) ant_model_num char(60), NOT NULL
(3) elevation_antenna_id int, NOT NULL
(4) ant_comment varchar(255)

elevation_pattern

Number Column Name Type
(1) depression_angle float(), NOT NULL
(2) field_value float()
(3) field_value0 float()
(4) field_value10 float()
(5) field_value20 float()
(6) field_value30 float()
(7) field_value40 float()
(8) field_value50 float()
(9) field_value60 float()
(10) field_value70 float()
(11) field_value80 float()
(12) field_value90 float()
(13) field_value100 float()
(14) field_value110 float()
(15) field_value120 float()
(16) field_value130 float()
(17) field_value140 float()
(18) field_value150 float()
(19) field_value160 float()
(20) field_value170 float()
(21) field_value180 float()
(22) field_value190 float()
(23) field_value200 float()
(24) field_value210 float()
(25) field_value220 float()
(26) field_value230 float()
(27) field_value240 float()
(28) field_value250 float()
(29) field_value260 float()
(30) field_value270 float()
(31) field_value280 float()
(32) field_value290 float()
(33) field_value300 float()
(34) field_value310 float()
(35) field_value320 float()
(36) field_value330 float()
(37) field_value340 float()
(38) field_value350 float()
(39) elevation_antenna_id int, NOT NULL
(40) last_update_date datetime

elevation_pattern_addl

Number Column Name Type
(1) depression_angle float(), NOT NULL
(2) azimuth float(), NOT NULL
(3) field_value float(), NOT NULL
(4) elevation_antenna_id int
(5) last_update_date datetime

fac_party

Number Column Name Type
(1) facility_id int, NOT NULL
(2) party_id int, NOT NULL
(3) party_type char(5), NOT NULL
(4) last_change_date datetime

facility

Number Column Name Type
(1) comm_city city
(2) comm_state state
(3) eeo_rpt_ind ind
(4) fac_address1 address
(5) fac_address2 address
(6) fac_callsign callsign
(7) fac_channel int
(8) fac_city city
(9) fac_country country
(10) fac_frequency float()
(11) fac_service char(2)
(12) fac_state state
(13) fac_status_date datetime
(14) fac_type varchar(3)
(15) facility_id int, NOT NULL
(16) lic_expiration_date datetime
(17) fac_status varchar(5)
(18) fac_zip1 char(5)
(19) fac_zip2 char(4)
(20) station_type char(1)
(21) assoc_facility_id int
(22) callsign_eff_date datetime
(23) tsid_ntsc int
(24) tsid_dtv int
(25) digital_status char(1)
(26) sat_tv char(1)
(27) network_affil varchar(100)
(28) nielsen_dma varchar(60)
(29) tv_virtual_channel int
(30) last_change_date datetime

fm_app_indicators

Number Column Name Type
(1) application_id int, NOT NULL
(2) bt_ind ind
(3) da_ind ind
(4) no_rotation_ind varchar(1)
(5) rule_73_215_req_ind ind
(6) ant_struc_reqs_ind ind
(7) app_same_area_ind ind
(8) near_tv_6_ind ind
(9) one_step_appl_ind ind
(10) rule_73_203_ind ind
(11) rule_73_207_ind ind
(12) rule_73_213a_ind ind
(13) rule_73_213b_ind ind
(14) rule_73_213c_ind ind
(15) rule_73_315ab_ind ind
(16) studio_in_city_ind ind
(17) svc_area_in_cont_ind ind
(18) tv_6_thresh_ind ind
(19) com_own_ind ind
(20) interference_com_ind ind
(21) rule_74_1204_ind varchar(1)
(22) rel_field_values_na char(1)
(23) board_within_ind ind
(24) campus_within_ind char(1)
(25) jurisdiction_within_ind char(1)
(26) rule_73_807_ind char(1)
(27) rule_73_807f_ind char(1)
(28) rule_73_811_ind char(1)
(29) near_int_border_ind char(1)
(30) rule_73_509_ind char(1)
(31) booster_in_cont_ind char(1)
(32) tribal_307b_lpfm_area_ind char(1)
(33) last_change_date datetime

fm_eng_data

Number Column Name Type
(1) ant_input_pwr float()
(2) ant_max_pwr_gain float()
(3) ant_polarization char(1)
(4) ant_rotation float()
(5) antenna_id int
(6) antenna_type char(1)
(7) application_id int, NOT NULL
(8) asd_service char(2)
(9) asrn_na_ind ind
(10) asrn int
(11) avg_horiz_pwr_gain float()
(12) biased_lat float()
(13) biased_long float()
(14) border_code char(1)
(15) border_dist float()
(16) docket_num varchar(20)
(17) effective_erp float()
(18) elev_amsl float()
(19) elev_bldg_ag float()
(20) eng_record_type char(1)
(21) facility_id int, NOT NULL
(22) fm_dom_status varchar(6)
(23) gain_area float()
(24) haat_horiz_rc_mtr float()
(25) haat_vert_rc_mtr float()
(26) hag_horiz_rc_mtr float()
(27) hag_overall_mtr float()
(28) hag_vert_rc_mtr float()
(29) horiz_bt_erp float()
(30) horiz_erp float()
(31) lat_deg int
(32) lat_dir char(1)
(33) lat_min int
(34) lat_sec float()
(35) lon_deg int
(36) lon_dir char(1)
(37) lon_min int
(38) lon_sec float()
(39) loss_area float()
(40) max_ant_pwr_gain float()
(41) max_haat float()
(42) max_horiz_erp float()
(43) max_vert_erp float()
(44) multiplexor_loss float()
(45) power_output_vis_kw float()
(46) predict_coverage_area float()
(47) predict_pop int
(48) rcamsl_horiz_mtr float()
(49) rcamsl_vert_mtr float()
(50) station_class varchar(2)
(51) terrain_data_src char(1)
(52) vert_bt_erp float()
(53) vert_erp float()
(54) num_sections int
(55) present_area float()
(56) percent_change float()
(57) spacing float()
(58) terrain_data_src_other varchar(255)
(59) trans_power_output float()
(60) mainkey char(16)
(61) lat_whole_secs int
(62) lon_whole_secs int
(63) station_channel int
(64) lic_ant_make varchar(3)
(65) lic_ant_model_num varchar(60)
(66) min_horiz_erp float()
(67) haat_horiz_calc_ind char(1)
(68) erp_w int
(69) trans_power_output_w int
(70) market_group_num varchar(7)
(71) last_change_date datetime

frn_history

Number Column Name Type
(1) frn_history_id int, NOT NULL
(2) facility_id int, NOT NULL
(3) frn varchar(10), NOT NULL
(4) application_id int
(5) date_inserted datetime
(6) valid_ind char(1)

fmcmnts

Number Column Name Type
(1) application_id int, NOT NULL
(2) comment_type char(5)
(3) comment varchar()

gen_app_indicators

Number Column Name Type
(1) application_id int, NOT NULL
(2) edu_comm_flg char(1)
(3) cp_extended_ind ind
(4) env_prot_act_ind ind
(5) exp_rf_ind ind
(6) rule_74_1234_ind ind
(7) faa_notified_ind ind
(8) all_rules_ind ind
(9) community_rep_ind ind
(10) nce_party_cert_ind ind
(11) other_auth_ind ind
(12) rule_73_503_ind ind
(13) window_open_date datetime
(14) window_close_date datetime
(15) window_resp_ind ind
(16) additonal_info_ex_ind ind
(17) auth_exhibit_ex_ind ind
(18) childprog_ex_ind ind
(19) lic_othr_auth_ex_ind ind
(20) file_no_ex_ind ind
(21) licen_pubfile_ex_ind ind
(22) meas_ex_ind ind
(23) newcont_exbt_ex_ind ind
(24) nownnewcont_ex_ind ind
(25) station_list_ex_ind ind
(26) violprog_ex_ind ind
(27) xfere_othr_auth_ex_ind ind
(28) sales_type_flg char(1)
(29) rule_73_1125_ind ind
(30) owner_type char(3)
(31) family_media_ind char(1)
(32) insulation_ind char(1)
(33) no_lpfm_ind char(1)
(34) no_non_lpfm_ind char(1)
(35) org_type_inst_ind char(1)
(36) org_type_org_ind char(1)
(37) org_type_safety_ind char(1)
(38) rule_73_825_ind char(1)
(39) org_type_gov_ind char(1)
(40) purpose_unchanged_ind char(1)
(41) window_number varchar(8)
(42) env_prot_act_v_ind char(1)
(43) env_prot_act_ax_ind char(1)
(44) bidding_credit_code char(3)
(45) pref_coord_ind char(1)
(46) cp_ext_reason_technical char(1)
(47) cp_ext_reason_legal char(1)
(48) cp_ext_reason_financial char(1)
(49) cp_ext_reason_other char(1)
(50) cp_extended_date datetime
(51) window_id int
(52) comm_lic_change_ind char(1)
(53) sec307b_pref_ind char(1)
(54) sec307b_same_comm_or_area_ind char(1)
(55) sec307b_served_4yrs_ind char(1)
(56) lpfm_3yrs_ind char(1)
(57) sec307b_tribal_prio_ind char(1)
(58) tribal_org_ind char(1)
(59) noncom_ps_radio_serv_ind char(1)
(60) rule_73_855_ind char(1)
(61) rule_73_860_ind char(1)
(62) rule_73_827_ind char(1)
(63) last_change_date datetime

if_notification

Number Column Name Type
(1) application_id int, NOT NULL
(2) broadcast_date datetime
(3) ibiquity_cert char(1)
(4) tech_name varchar(60)
(5) tech_phone varchar(20)
(6) combined_power float()
(7) analog_power float()
(8) digital_power float()
(9) analog_remain_ind char(1)
(10) env_excluded_ind char(1)
(11) digital_power_reduced float()
(12) digital_power_reduced_na char(1)
(13) ref_file_prefix char(10)
(14) ref_app_arn char(12)
(15) test_date datetime
(16) resolved_date datetime
(17) analog_erp float()
(18) digital_erp float()
(19) last_change_date datetime

if_sta

Number Column Name Type
(1) application_id int, NOT NULL
(2) lic_ant_sys_change char(1)
(3) antenna_system char(4)
(4) ref_app_arn char(12)
(5) ref_file_prefix char(10)
(6) cp_ant_sys_file_prefix varchar(10)
(7) cp_ant_sys_app_arn char(12)
(8) silent_since_date datetime
(9) return_to_air_date datetime

int_translator

Number Column Name Type
(1) application_id int, NOT NULL
(2) delivery_method char(1)
(3) prim_callsign callsign
(4) prim_comm_city city
(5) prim_comm_state state
(6) prim_sta_out_channel int
(7) primary_via varchar(13)
(8) scnd_comm_city city
(9) scnd_comm_state state
(10) third_comm_city city
(11) third_comm_state state
(12) trans_input_channel int
(13) prim_facility_id int
(14) last_change_date datetime

intl_tracking

Number Column Name Type
(1) accepted_date datetime
(2) application_id int, NOT NULL
(3) can_coord_status char(1)
(4) change_list_date datetime
(5) change_list_num varchar(5)
(6) hours_operation char(1)
(7) ifrb_date datetime
(8) ifrb_list_flg char(1)
(9) ifrb_serial_num char(9)
(10) intl_class varchar(2)
(11) itu_coord_status char(1)
(12) mex_coord_status char(1)
(13) neg_allot_ind varchar(4)
(14) notified_pattern char(1)
(15) notified_status char(1)
(16) proposed_date datetime
(17) referred_date datetime
(18) region_2_status char(1)
(19) updating_agency varchar(4)
(20) notified_date datetime
(21) intl_status char(6)
(22) last_change_date datetime

legal

Number Column Name Type
(1) application_id int, NOT NULL
(2) legal_action_id int, NOT NULL
(3) ref_action_id int
(4) file_date datetime
(5) release_date datetime
(6) legal_status_date datetime
(7) pn_rpt_num int
(8) docket_id varchar(20)
(9) petition_code char(5)
(10) legal_status varchar(5)
(11) rulemaking_id int
(12) filing_pn_num int
(13) filing_release_date datetime
(14) legal_app_id int
(15) last_change_date datetime

legal_qualification

Number Column Name Type
(1) advs_finding_1_ind ind
(2) advs_finding_renewal_ind ind
(3) application_id int, NOT NULL
(4) at_pndg_band_ind ind
(5) character_issues_ind ind
(6) contour_overlap_ind ind
(7) drugs_ind ind
(8) foreign_compl_ind ind
(9) fx_contour_overlap_ind ind
(10) fx_int_station_ind ind
(11) multiple_owner_ind ind
(12) ownership_rpt_filed_ind ind
(13) party_id int
(14) pn_req_ind ind
(15) serv_cert_ind ind
(16) silent_sta_ind ind
(17) wrksht_inst_reviewed_ind ind
(18) auction_authorization_cert_ind ind
(19) fiveyrsafter_auction_auth_ind ind
(20) advs_finding_ind ind
(21) fx_no_primstationsup_ind ind
(22) nccp_appl_type char(3)
(23) appl_type_other_desc title
(24) auth_retrans_ind ind
(25) sales_type_flg char(1)
(26) equity_nonattrib_ind ind
(27) overlap_info_publicfile_ind ind
(28) com_own_ind char(1)
(29) owner_type char(3)
(30) pn_3526_ind char(1)
(31) ceased_ops_24hrs_ind char(1)
(32) ceased_ops_vol_ind char(1)
(33) comm_edu_ind char(1)
(34) comm_safety_ind char(1)
(35) local_prog_ind char(1)
(36) no_unlicensed_ind char(1)
(37) operating_hours_ind char(1)
(38) class_a_rules_ind char(1)
(39) eligibility_continued_ind char(1)
(40) eligibility_statement_ind char(1)
(41) eeo_req_ind char(1)
(42) point_sys_score int
(43) eeo_model_filed_ind char(1)
(44) mod_after_four_yrs_ind char(1)
(45) mod_not_downgrade_ind char(1)
(46) mod_not_fair_dist_ind char(1)
(47) mod_not_sup_tech_ind char(1)
(48) nce_qual_app_arn char(12)
(49) nce_qual_file_prefix char(10)
(50) pop_area_more_ind char(1)
(51) child_398_filed_ind char(1)
(52) no_pending_char_ind char(1)
(53) no_unresolved_char_ind char(1)
(54) no_fcc_violation_ind char(1)
(55) sales_or_time_agreement_ind char(1)
(56) multiple_owner_cross_media_ind char(1)
(57) multiple_owner2_ind char(1)
(58) allotment_request_ind char(1)
(59) anti_discrim_ind char(1)
(60) eligible_entity_ind char(1)
(61) grand_fathered_ind char(1)
(62) gf_divest_to_entity_ind char(1)
(63) gf_divest_to_trust_ind char(1)
(64) tribal_priority_thresh_ind char(1)
(65) comm_tribal_org_ind char(1)
(66) main_studio_ind char(1)
(67) street_address1 varchar(60)
(68) street_address2 varchar(60)
(69) city varchar(60)
(70) state char(2)
(71) zip1 char(5)
(72) zip2 char(4)
(73) phone varchar(20)
(74) studio_in_local_ind char(1)
(75) diversity_own_ind char(1)
(76) comm_tribal_local_ind char(1)
(77) comm_presence_est_ind char(1)
(78) comm_presence_est_date datetime
(79) email varchar(60)
(80) last_change_date datetime

lic_app_indicators

Number Column Name Type
(1) application_id int, NOT NULL
(2) auth_retrans_ind ind
(3) chng_transm_pwr_ind ind
(4) cp_stmt_incorrect_ind ind
(5) cp_terms_met_ind ind
(6) da_inst_compl_ind ind
(7) da_inst_correct_ind ind
(8) decr_c_erp_ind ind
(9) decr_nc_erp_ind ind
(10) del_cntr_prot_ind ind
(11) incr_erp_221_ind ind
(12) incr_erp_dckt_ind ind
(13) incr_erp_ind ind
(14) incr_erp_ownr_ind ind
(15) lic_app_service char(2)
(16) lic_pta_ind ind
(17) nce_to_comm_ind ind
(18) no_intl_coord_ind ind
(19) orig_cp_file_prefix file_prefix
(20) orig_cp_app_arn arn
(21) lic_file_prefix file_prefix
(22) lic_app_arn arn
(23) rad_astr_not_ind ind
(24) repl_da_compl_ind ind
(25) repl_da_ind ind
(26) rule_73_1620a1_ind ind
(27) rule_73_1675a3_ind ind
(28) rule_73_1675a_ind ind
(29) rule_73_1690c8i_ind ind
(30) rule_73_1690c_ind ind
(31) rule_73_1692_ind ind
(32) rule_73_207_ind ind
(33) rule_73_315ab_ind ind
(34) rule_73_525a1_ind ind
(35) rule_73_68_ind ind
(36) spec_op_conds_ind ind
(37) sta_id_rules_ind ind
(38) stat_ready_ind ind
(39) trans_auth_erp_ind ind
(40) type_appr_stereo_ind ind
(41) inst_ht_dif_ok_ind ind
(42) rule_73_1590 ind
(43) rule_73_1660_ind ind
(44) rule_73_1675c_1_ind ind
(45) rule_73_1675c_ind ind
(46) rule_73_1690c9_ind ind
(47) rule_73_3555_ind ind
(48) rule_73_685f_ind ind
(49) rule_73_68d3_ind ind
(50) sales_type_flg char(1)
(51) conv_lptv_cp_arn varchar(12)
(52) conv_lptv_cp_prefix varchar(10)
(53) conv_lptv_lic_arn varchar(12)
(54) conv_lptv_lic_prefix varchar(10)
(55) displaced_cp_filed_date datetime
(56) no_change_lp_cp_ind char(1)
(57) rule_73_6011_ind char(1)
(58) rule_73_6012_ind char(1)
(59) rule_73_6013_ind char(1)
(60) rule_73_6020_ind char(1)
(61) no_change_to_classa_cp_ind char(1)
(62) pta_type char(1)
(63) repl_trans_line_ind char(1)
(64) rule_73_850b_ind char(1)
(65) rule_73_1675a_nc_ind char(1)
(66) rule_73_1675a_ax_ind char(1)
(67) orig_cp_app_expiration_date datetime
(68) record_change_date datetime

nce_factors

Number Column Name Type
(1) application_id int, NOT NULL
(2) claimed_points int
(3) existing_auths int
(4) existing_cps int
(5) existing_fillin_auths int
(6) existing_fillin_cps int
(7) fill_in_serv_ind char(1)
(8) gain_area int
(9) population_served int
(10) rule_73_313_c_ind char(1)
(11) rule_73_3555_ind char(1)
(12) rule_73_7000_ind char(1)
(13) rule_73_7003_b_c_ind char(1)
(14) technical_points int
(15) total_points int
(16) divers_own_ind char(1)
(17) min_first_service_ind char(1)
(18) min_sec_service_ind char(1)
(19) supplement_date datetime
(20) first_aural_service_ind char(1)
(21) first_tribal_service_ind char(1)
(22) last_change_date datetime

ownership_capitalization

Number Column Name Type
(1) ownership_capitalization_id int, NOT NULL
(2) application_id int, NOT NULL
(3) class_of_stock varchar(60)
(4) voting_ind char(1)
(5) authorized_shares float()
(6) issued_shares float()
(7) treasury_shares float()
(8) unissued_shares float()
(9) order_number smallint
(10) class_of_stock_flg char(1)
(11) class_of_stock_other varchar(20)
(12) voting_flg char(1)
(13) last_update_date datetime

ownership_contract

Number Column Name Type
(1) ownership_contract_id int, NOT NULL
(2) application_id int, NOT NULL
(3) contract_description varchar(255)
(4) contract_person varchar(255)
(5) execution_date datetime
(6) expiration_date varchar(15)
(7) order_number smallint
(8) agreement_type_lma char(1)
(9) agreement_type_naa char(1)
(10) agreement_type_oth char(1)
(11) execution_date_month char(3)
(12) execution_date_year smallint
(13) expiration_date_month char(3)
(14) expiration_date_year smallint
(15) expiration_date_na char(1)
(16) last_update_date datetime

ownership_exemptions

Number Column Name Type
(1) ownership_exemptions_id int, NOT NULL
(2) application_id int, NOT NULL
(3) order_number smallint, NOT NULL
(4) name varchar(150)
(5) title varchar(60)
(6) last_update_date datetime

ownership_group

Number Column Name Type
(1) ownership_group_id int, NOT NULL
(2) main_application_id int, NOT NULL
(3) fac_callsign varchar(12)
(4) facility_id int, NOT NULL
(5) fac_service varchar(2)
(6) comm_city varchar(20)
(7) comm_state varchar(2)
(8) fac_service_o varchar(2)
(9) app_arn varchar(12)
(10) file_prefix char(10)
(11) order_number smallint
(12) last_update_date datetime

ownership_interests

Number Column Name Type
(1) ownership_interests_id int, NOT NULL
(2) application_id int, NOT NULL
(3) order_number smallint, NOT NULL
(4) frn varchar(10)
(5) name varchar(150)
(6) last_update_date datetime

ownership_other_int

Number Column Name Type
(1) ownership_other_int_id int, NOT NULL
(2) application_id int, NOT NULL
(3) order_number smallint, NOT NULL
(4) assets_perc decimal(4,1)
(5) comm_city varchar(20)
(6) comm_state char(2)
(7) entity_type char(1)
(8) equity_perc decimal(4,1)
(9) fac_callsign varchar(12)
(10) facility_id int
(11) name varchar(150)
(12) newspaper varchar(150)
(13) positional_int_off char(1)
(14) positional_int_dir char(1)
(15) positional_int_par char(1)
(16) positional_int_lim char(1)
(17) positional_int_stk char(1)
(18) positional_int_own char(1))
(19) positional_int_ent datetime
(20) positional_int_oth char(1)
(21) positional_int_other_info char(1)
(22) votes_perc decimal(4,1)
(23) last_update_date datetime

ownership_other_int_xml_data

Number Column Name Type
(1) application_id int, NOT NULL
(2) file_id int, NOT NULL
(3) order_number smallint, NOT NULL
(4) assets_perc decimal(4,1)
(5) comm_city varchar(20)
(6) comm_state char(2)
(7) entity_type char(1)
(8) equity_perc decimal(4,1)
(9) fac_callsign varchar(12)
(10) facility_id int
(11) name varchar(150)
(12) newspaper varchar(150)
(13) positional_int_off char(1)
(14) positional_int_dir char(1)
(15) positional_int_par char(1)
(16) positional_int_lim char(1)
(17) positional_int_stk char(1)
(18) positional_int_own char(1)
(19) positional_int_ent char(1)
(20) positional_int_oth char(1)
(21) positional_int_other_info varchar(20)
(22) votes_perc decimal(4,1)
(23) last_update_date datetime

ownership_relationships

Number Column Name Type
(1) ownership_relationships_id int, NOT NULL
(2) application_id int, NOT NULL
(3) order_number smallint, NOT NULL
(4) names varchar(255)
(5) relationship_flg char(2)
(6) last_update_date datetime

ownership_report

Number Column Name Type
(1) application_id int, NOT NULL
(2) accurate_date datetime
(3) non_attributable_ind char(1)
(4) attributable_ind char(1)
(5) related_ind char(1)
(6) exemption_ind char(1)
(7) owner_type varchar(5)
(8) entity_control_ind char(1)
(9) separate_form_ind char(1)
(10) attrib_exemption_ind char(1)
(11) capitalization_na char(1)
(12) contract_info_na char(1)
(13) individuals_related_ind char(1)
(14) lic_frn varchar(10)
(15) lic_name varchar(60)
(16) org_chart_na char(1)
(17) respondent_nature_flg char(3)
(18) resp_interests_na char(1)
(19) last_update_date datetime

ownership_structure

Number Column Name Type
(1) ownership_structure_id int, NOT NULL
(2) application_id int, NOT NULL
(3) name_address varchar(255)
(4) gender_flg char(1)
(5) ethnicity_flg varchar(5)
(6) race_flg varchar(5)
(7) citizenship char(2)
(8) positional_int varchar(60)
(9) votes_perc decimal(5,2)
(10) equity_perc decimal(5,2)
(11) active_ind char(1)
(12) office_held varchar(60)
(13) interest_perc decimal(5,2)
(14) occupation varchar(60)
(15) appointed_by varchar(60)
(16) existing_interests varchar(255)
(17) order_number smallint
(18) assets_perc decimal(5,2)
(19) entity_exemption_ind char(1)
(20) frn varchar(10)
(21) listing_type_flg char(1)
(22) personal_info_na char(1)
(23) positional_int_crd char(1)
(24) positional_int_dir char(1)
(25) positional_int_gen char(1)
(26) positional_int_inv char(1)
(27) positional_int_lim char(1)
(28) positional_int_llc char(1)
(29) positional_int_off char(1)
(30) positional_int_oth char(1)
(31) positional_int_own char(1)
(32) positional_int_stk char(1)
(33) positional_int_other_info varchar(20)
(34) relationship_flg char(1)
(35) race_american_indian char(1)
(36) race_asian char(1)
(37) race_black char(1)
(38) race_hawaiian char(1)
(39) race_white char(1)
(40) name varchar(150)
(41) city varchar(20)
(42) country varchar(20)
(43) state char(2)
(44) street_address1 varchar(60)
(45) street_address2 varchar(60)
(46) zip1 char(5)
(47) zip2 char(4)
(48) last_update_date datetime

party

Number Column Name Type
(1) party_id int, NOT NULL
(2) party_address1 address
(3) party_address2 address
(4) party_citizenship country
(5) party_city city
(6) party_company name
(7) party_country country
(8) party_email email
(9) party_fax phone
(10) party_legal_name varchar(255)
(11) party_name name
(12) party_phone phone
(13) party_state state
(14) party_zip1 char(5)
(15) party_zip2 char(4)
(16) last_change_date datetime

positional_int

Number Column Name Type
(1) application_id int, NOT NULL
(2) citizenship country
(3) name_address varchar(250), NOT NULL
(4) equity_perc percentage
(5) votes_perc percentage
(6) title name
(7) boardmember_ind ind
(8) membership_perc float()
(9) owner_perc float()
(10) assets_perc float()
(11) order_number smallint
(12) last_update_date datetime

renewal_translator_group

Number Column Name Type
(1) renewal_translator_group_id int, NOT NULL
(2) application_id int, NOT NULL
(3) order_number int, NOT NULL
(4) fac_callsign varchar(12)
(5) facility_id int
(6) tx_comm_city varchar(20)
(7) tx_comm_state char(2)
(8) onair_ind char(1)
(9) rebroad_signal_ind char(1)
(10) rebroad_callsign varchar(12)
(11) rebroad_facility_id int
(12) rebroad_comm_city varchar(20)
(13) rebroad_comm_state char(2)
(14) auth_retrans_ind char(1)
(15) app_arn char(12)
(16) file_prefix char(10)
(17) last_change_date datetime

supp_facility

Number Column Name Type
(1) parent_facility_id int, NOT NULL
(2) supp_type varchar(5), NOT NULL
(3) supp_callsign varchar(12), NOT NULL
(4) supp_fac_status varchar(5)
(5) status_date datetime
(6) site_number tinyint, NOT NULL
(7) fac_channel int
(8) comm_city char(20)
(9) comm_state char(2)
(10) last_change_date datetime

tv_app_indicators

Number Column Name Type
(1) ant_struc_reqs_ind ind
(2) application_id int, NOT NULL
(3) bt_used_ind ind
(4) da_ind ind
(5) elec_bt_prop_ind ind
(6) int_compl_ind ind
(7) mech_bt_prop_ind ind
(8) rule_73_1660_ind ind
(9) rule_73_607_ind ind
(10) rule_73_610_ind ind
(11) rule_73_614_ind ind
(12) rule_73_685ab_ind ind
(13) coverage_exhibit_ind ind
(14) rule_73_685dg_ind ind
(15) dummy_tx_flag char(1)
(16) da_exhibit_ind ind
(17) rule_74_705_ind ind
(18) rule_74_706_ind ind
(19) rule_74_707_ind ind
(20) rule_73_622_ind ind
(21) ant_5km_ind ind
(22) rule_73_62_ind ind
(23) rule_1_1307_ind ind
(24) rule_73_625_ind ind
(25) rad_astr_ind ind
(26) faa_notified_ind ind
(27) rule_73_623a_ind ind
(28) no_rotation_ind varchar(1)
(29) rel_field_values_na char(1)
(30) studio_in_comm_ind char(1)
(31) rule_73_1690c_3_ind char(1)
(32) rule_74_786d_ind char(1)
(33) no_suitable_incore_ind char(1)
(34) rule_74_786e_wirels_ind char(1)
(35) rule_74_786e_agr_ind char(1)
(36) rule_74_786e_notif_ind char(1)
(37) noise_limited_ind char(1)
(38) population_match_ind char(1)
(39) maximization_ind char(1)
(40) site_number tinyint, NOT NULL
(41) interference_prot_ind char(1)
(42) dts_covers_all_area_ind char(1)
(43) dts_coverage_within_area_flg varchar(2)
(44) dts_coverage_contiguous_ind char(1)
(45) dts_principal_comm_cover_flg varchar(2)
(46) dts_combined_interference_ind char(1)
(47) dts_trans_within_area_ind char(1)
(48) dts_elev_pattern_varies_ind char(1)
(49) last_change_date datetime

tv_eng_data

Number Column Name Type
(1) ant_input_pwr float(18)
(2) ant_max_pwr_gain float(18)
(3) ant_polarization char(1)
(4) antenna_id int
(5) antenna_type char(1)
(6) application_id int, NOT NULL
(7) asrn_na_ind varchar(1)
(8) asrn int
(9) aural_freq float(18)
(10) avg_horiz_pwr_gain float(18)
(11) biased_lat float(18)
(12) biased_long float(18)
(13) border_code char(1)
(14) carrier_freq float(18)
(15) docket_num varchar(20)
(16) effective_erp float(18)
(17) electrical_deg float(18)
(18) elev_amsl float(18)
(19) elev_bldg_ag float(18)
(20) eng_record_type char(1)
(21) fac_zone varchar(3)
(22) facility_id int, NOT NULL
(23) freq_offset char(1)
(24) gain_area float(18)
(25) haat_rc_mtr float(18)
(26) hag_overall_mtr float(18)
(27) hag_rc_mtr float(18)
(28) horiz_bt_erp float(18)
(29) lat_deg int
(30) lat_dir char(1)
(31) lat_min int
(32) lat_sec float(18)
(33) lon_deg int
(34) lon_dir char(1)
(35) lon_min int
(36) lon_sec float(18)
(37) loss_area float(18)
(38) max_ant_pwr_gain float(18)
(39) max_erp_dbk float(18)
(40) max_erp_kw float(18)
(41) max_haat float(18)
(42) mechanical_deg float(18)
(43) multiplexor_loss float(18)
(44) power_output_vis_dbk float(18)
(45) power_output_vis_kw float(18)
(46) predict_coverage_area float(18)
(47) predict_pop int
(48) terrain_data_src_other varchar(255)
(49) terrain_data_src char(3)
(50) tilt_towards_azimuth float(18)
(51) true_deg float(18)
(52) tv_dom_status varchar(6)
(53) upperband_freq float(18)
(54) vert_bt_erp float(18)
(55) visual_freq float(18)
(56) vsd_service char(2)
(57) rcamsl_horiz_mtr float(18)
(58) ant_rotation float(18)
(59) input_trans_line float(18)
(60) max_erp_to_hor float(18)
(61) trans_line_loss float(18)
(62) lottery_group int
(63) analog_channel int
(64) lat_whole_secs int
(65) lon_whole_secs int
(66) max_erp_any_angle float(18)
(67) station_channel int
(68) lic_ant_make varchar(3)
(69) lic_ant_model_num varchar(60)
(70) dt_emission_mask char(1)
(71) site_number tinyint, NOT NULL
(72) elevation_antenna_id int
(73) last_change_date datetime
User Type Storage Type Length
address varchar 40
arn char 12
callsign char 12
city varchar 20
country char 2
county varchar 30
email varchar 60
file_number char 21
file_prefix char 10
form_number varchar 10
ind char 1
name varchar 60
percentage float 8
phone char 10
state char 2
title varchar 60
url varchar 255

Release Notes for CDBS Engineering Files

In most cases, new fields are added at the end of the existing data rows. Please see the documentation file for a description of these fields.

Date Tables Fields
11/7/2014 application app_code
Date Tables Fields
9/3/2014 altc_group
legal_qualification
renewal_translator_group
Date Tables Fields
9/3/2014 gen_app_indicators additonal_info_ex_ind
all_rules_ind
auth_exhibit_ex_ind
bidding_credit_code
childprog_ex_ind
comm_lic_change_ind
community_rep_ind
cp_ext_reason_financial
cp_ext_reason_legal
cp_ext_reason_other
cp_ext_reason_technical
cp_extended_date
cp_extended_ind
env_prot_act_ax_ind
env_prot_act_ind
env_prot_act_v_ind
exp_rf_ind
faa_notified_ind
family_media_ind
file_no_ex_ind
insulation_ind
lic_othr_auth_ex_ind
licen_pubfile_ex_ind
lpfm_3yrs_ind
meas_ex_ind
nce_party_cert_ind
newcont_exbt_ex_ind
no_lpfm_ind
no_non_lpfm_ind
noncom_ps_radio_serv_ind
nownnewcont_ex_ind
org_type_gov_ind
org_type_inst_ind
org_type_org_ind
org_type_safety_ind
other_auth_ind
owner_type
pref_coord_ind
purpose_unchanged_ind
rule_73_1125_ind
rule_73_503_ind
rule_73_825_ind
rule_73_827_ind
rule_73_855_ind
rule_73_860_ind
rule_74_1234_ind
sales_type_flg
sec307b_pref_ind
sec307b_same_comm_or_area_ind
sec307b_served_4yrs_ind
sec307b_tribal_prio_ind
station_list_ex_ind
tribal_org_ind
violprog_ex_ind
window_close_date
window_id
window_number
window_open_date
window_resp_ind
xfere_othr_auth_ex_ind
last_update_date
Date Tables Fields
9/3/2014 fm_app_indicators ant_struc_reqs_ind
app_same_area_ind
board_within_ind
booster_in_cont_ind
campus_within_ind
com_own_ind
interference_com_ind
jurisdiction_within_ind
near_int_border_ind
near_tv_6_ind
one_step_appl_ind
rel_field_values_na
rule_73_203_ind
rule_73_207_ind
rule_73_213a_ind
rule_73_213b_ind
rule_73_213c_ind
rule_73_315ab_ind
rule_73_509_ind
rule_73_807_ind
rule_73_807f_ind
rule_73_811_ind
rule_74_1204_ind
studio_in_city_ind
svc_area_in_cont_ind
tribal_307b_lpfm_area_ind
tv_6_thresh_ind
last_update_date
Date Tables Fields
9/3/2014 legal application_id
legal_action_id
ref_action_id
file_date
release_date
legal_status_date
pn_rpt_num
docket_id
petition_code
legal_status
rulemaking_id
filing_pn_num
filing_release_date
legal_app_id
last_update_date
Date Tables Fields
01/23/2012 if_sta
facility tv_virtual_channel
Date Tables Fields
12/1/2010 am_towers last_update_date

Notes: Switched order of tower_type and last_change_date (now called last_update_date) (and fixed the documentation)

Date Tables Fields
12/1/2010 dtv_transition binding_termination_flg
termination_date_not_aff
termination_date_aff
aff_term_cert_flg
cont_analog_flg
phone_help_ctr_flg
walkin_help_ctr_flg
st_analog_nightlight_ind
st_analog_nightlight_end_date
inf_analog_nightlight_ind
inf_analog_nightlight_end_date
early_term_withdraw_ind
termination_time_0612_flg
termination_date_nce
termination_time_nce_flg
termination_time_notaff_flg
termination_time_aff_flg
nce_term_cert_flg
ref_contact_phone
ref_contact_hours
an_participation_notice_ind
an_eligibility_showing_ind
an_objection_to_elig_showg_ind
an_objection_callsign
an_revocation_ind

Notes: Also moved last_update_date (kept it as the last column)

Date Tables Fields
12/1/2010 nce_factors first_aural_service_ind
first_tribal_service_ind
facility frn(removed)

Notes: frn (removed incorrect column from Engineering Data Description)

Notes: Also moved last_change_date (kept it as the last column)

Date Tables Fields
12/1/2010 ownership_capitalization class_of_stock_flg
class_of_stock_other
last_update_date
voting_flg
Date Tables Fields
12/1/2010 ownership_contract agreement_type_lma
agreement_type_naa
agreement_type_oth
execution_date_month
execution_date_year
expiration_date_month
expiration_date_year
expiration_date_na
last_update_date
Date Tables Fields
12/1/2010 ownership_report attrib_exemption_ind
attrib_exemption_ind
capitalization_na
contract_info_na
individuals_related_ind
last_update_date
lic_frn
lic_name
org_chart_na
respondent_nature_flg
resp_interests_na
Date Tables Fields
12/1/2010 ownership_structure assets_perc
entity_exemption_ind
frn
last_update_date
listing_type_flg
personal_info_na
positional_int_crd
positional_int_dir
positional_int_gen
positional_int_inv
positional_int_lim
positional_int_llc
positional_int_off
positional_int_oth
positional_int_own
positional_int_stk
positional_int_other_info
relationship_flg
name
city
country
state
street_address1
street_address2
zip1
zip2
Date Tables Fields
12/1/2010 frn_history
if_notification
int_translator
lic_app_indicators
ownership_exemptions
ownership_interests
ownership_other_int
ownership_other_int_xml_data
ownership_relationships
Date Tables Fields
6/24/2009 supp_facility site_number(primary key)
fac_channel
comm_city
comm_state

Notes: Also moved last_update_date (kept it as the last column)

Date Tables Fields
3/24/2009 tv_app_indicators

Notes: Corrected the order of columns 40 to 49 in the readme file to match the data

Date Tables Fields
3/4/2009 application frn
shortform_app_arn
shortform_file_prefix
corresp_ind
assoc_facility_id
network_affil
sat_tv_ind
comm_county
comm_zip1
comm_zip2
Date Tables Fields
3/4/2009 dtv_transition addl_steps_ind
analog_nightlight_ind
analog_turnoff_pn_compl_flg
Date Tables Fields
3/4/2009 facility network_affil
nielsen_dma
Date Tables Fields
3/4/2009 tv_app_indicators maximization_ind
site_number (primary key)
interference_prot_ind
dts_covers_all_area_ind
dts_coverage_within_area_flg
dts_coverage_contiguous_ind
dts_principal_comm_cover_flg
dts_combined_interference_ind
dts_trans_within_area_ind
dts_elev_pattern_varies_ind
Date Tables Fields
3/4/2009 tv_eng_data elevation_antenna_id
site_number (added to primary key)
Date Tables Fields
3/4/2009 elevation_ant_make
elevation_pattern
elevation_pattern_addl
supp_facility
Date Tables Fields
3/4/2009 am_ant_sys augmented_ind (added to readme file)
biased_long

Note: biased_long (added to Engineering Data Description)

Date Tables Fields
3/4/2009 am_eng_data encl_fence_dist
feed_circ_other
feed_circ_type
biased_lat
biased_long

Note: encl_fence_dist, feed_circ_other, feed_circ_type (added to Engineering Data Description)

Note: biased_lat, biased_long (removed from Engineering Data Description)

Date Tables Fields
3/24/2008 tv_app_indicators displacement_type (deleted)
dtv_transition addl_steps_ind (deleted)
last_change_update (deleted)

Note: Deleted addl_steps_ind, displacement_type and last_change_update

Date Tables Fields
3/6/2008 application dtv_type
Date Tables Fields
3/6/2008 dtv_transition dtv_cur_channel
application_id
dtv_cur_na
ntsc_cur_channel
ntsc_cur_na
rep_max_cert
file_prefix_cer_a
app_arn_cer_a
file_prefix_cer_b
app_arn_cer_b
file_prefix_cer_d
app_arn_cer_d
rep_max_cer_type
file_prefix_cer_e
app_arn_cer_e
data_cert_ind
election
elected_channel_a
elected_channel_b
alt_elected_channel
intl_coord_ind
cont_election
cont_elected_channel
conflict_decision
reference_no
negot_agreemt_ind
tech_eng_ind
tent_chan_status
tentative_channel
post_tran_dtv_channel
pre_tran_dtv_channel
post_tran_auth_file_prefix
post_tran_auth_app_arn
post_tran_auth_not_yet_ind
construction_deadline_dat
post_tran_operating_ind
op_status
op_expected_date
op_power_level
op_population_perc
construction_complete_ind
expect_cons_complete_date
const_not_begun
const_underway
const_addl_needed
cp_status_ind
cp_mod_needed_ind
cp_mod_filed_ind
cp_mod_file_prefix
cp_mod_app_arn
cp_mod_filed_date
cp_mod_expected_date
addl_fcc_action_ind
addl_fcc_action_app_arn
addl_fcc_action_file_pref
addl_fcc_action_date
addl_intl_ind
addl_faa_approval_ind
addl_local_approval_ind
addl_equip_ind
addl_equip_new_ant_ind
addl_equip_adj_ant_ind
addl_equip_switch_ant_ind
addl_equip_new_trans_ind
addl_equip_adj_trans_ind
addl_equip_gen_install_in
addl_equip_other_ind
addl_tower_ind
addl_coord_ind
addl_other_ind
analog_service_status
analog_status_ind
dtv_transition_plan_ind
last_update_date

Notes: Entire table released, replacing existing fields

Date Tables Fields
3/6/2008 tv_app_indicators application_id
bt_used_ind
da_ind
mech_bt_prop_ind
no_rotation_ind
last_change_date

Notes: Entire table released, replacing existing fields:
application_id,bt_used_ind,da_ind,mech_bt_prop_ind,no_rotation_ind,last_change_date

Date Tables Fields
3/6/2008 dtv_channel_assignments
Date Tables Fields
4/1/2008 dtv_channel_assignments rcamsl
ref_azimuth
da_ind
pre_dtv_channel(renamed)
callsign
area(removed)
population(removed)
interference(removed)

Note: Fields added: rcamsl,ref_azimuth, da_ind , pre_dtv_channel, callsign
           Fields removed: area, population, interference
           Fields rename: post_dtv_channel

Date Tables Fields
4/1/2008 dtv_transition addl_steps_ind (removed)

Note: Fields removed: addl_steps_ind
           Moved last_update_date to the end

Date Tables Fields
11/21/2007 nce_factors
Date Tables Fields
5/2/2007 amcmnts(redefined)
fmcmnts(redefined)

Note: amcmnts and fmcmnts redefined

Date Tables Fields
9/20/2006 ownership_group

Note: Ownership Group table added

Date Tables Fields
4/24/2006 ownership_structure order_number
ownership_capitalization order_number
ownership_contract order_number

Note: order_number added in the three tables

Date Tables Fields
12/28/2005 tv_eng_data dt_emission_mask
Date Tables Fields
02/17/2005 dtv_agreement_group
dtv_transition
Date Tables Fields
11/18/2004 facility sat_tv
Date Tables Fields
03/25/2003 app_tracking tolling_code
Date Tables Fields
12/04/2002 facility digital_status
app_tracking accepted_date
Date Tables Fields
4/23/2002 facility tsid_ntsc
tsid_dtv
fm_eng_data market_group_num
Date Tables Fields
3/14/2002 call_sign_history
ownership_capitalization
ownership_contract
ownership_report
ownership_structure
Date Tables Fields
3/14/2002 am_tracking app_status_date
amendment_stamped_date
Date Tables Fields
8/8/2001 amcmnts
fmcmnts
Date Tables Fields
7/31/2001 am_ant_sys specified_hrs_range
Date Tables Fields
5/31/2001 sig_name specified_hrs_range
app_tracking app_status
dtv_checklist
application app_type
paper_filed_ind
code_table(link file)

Notes: Converted readme.txt to readme.html
             Added linking file: code_table
             Added last_change_date as last field in all files

Date Tables Fields
2/13/2001 am_ant_sys grandfathered_ind
fm_eng_data haat_horiz_calc_ind
erp_w
trans_power_output_w
Date Tables Fields
7/26/2000 ownership_structure race_american_indian
race_asian
race_black
race_hawaiian
race_white
Date Tables Fields
5/25/2000 fm_app_indicators rule_73_215_req_ind
fm_eng_data min_horiz_erp

Information for earlier dates not available.