-------------- SELECT version() -------------- +------------+ | version() | +------------+ | 4.1.12a-nt | +------------+ 1 row in set (0.01 sec) -------------- CREATE TABLE tblPUBACC_A2Record_Type SELECT Record_Type, count(Record_Type) FROM PUBACC_A2 GROUP BY Record_Type -------------- Query OK, 0 rows affected (0.09 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_A2unique_system_identifier SELECT unique_system_identifier, count(Record_Type) FROM PUBACC_A2 GROUP BY unique_system_identifier -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_A2ULS_File_Number SELECT ULS_File_Number, count(Record_Type) FROM PUBACC_A2 GROUP BY ULS_File_Number -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_A2EBF_Number SELECT EBF_Number, count(Record_Type) FROM PUBACC_A2 GROUP BY EBF_Number -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_A2spectrum_manager_leasing SELECT spectrum_manager_leasing, count(Record_Type) FROM PUBACC_A2 GROUP BY spectrum_manager_leasing -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_A2defacto_transfer_leasing SELECT defacto_transfer_leasing, count(Record_Type) FROM PUBACC_A2 GROUP BY defacto_transfer_leasing -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_A2new_spectrum_leasing SELECT new_spectrum_leasing, count(Record_Type) FROM PUBACC_A2 GROUP BY new_spectrum_leasing -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_A2spectrum_subleasing SELECT spectrum_subleasing, count(Record_Type) FROM PUBACC_A2 GROUP BY spectrum_subleasing -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_A2xfer_control_lessee SELECT xfer_control_lessee, count(Record_Type) FROM PUBACC_A2 GROUP BY xfer_control_lessee -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_A2revision_spectrum_lease SELECT revision_spectrum_lease, count(Record_Type) FROM PUBACC_A2 GROUP BY revision_spectrum_lease -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_A2assignment_spectrum_lease SELECT assignment_spectrum_lease, count(Record_Type) FROM PUBACC_A2 GROUP BY assignment_spectrum_lease -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_A2registered_link_action SELECT registered_link_action, count(Record_Type) FROM PUBACC_A2 GROUP BY registered_link_action -------------- Query OK, 0 rows affected (0.01 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ACrecord_type SELECT record_type, count(Record_Type) FROM PUBACC_AC GROUP BY record_type -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ACunique_system_identifier SELECT unique_system_identifier, count(Record_Type) FROM PUBACC_AC GROUP BY unique_system_identifier -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ACuls_file_number SELECT uls_file_number, count(Record_Type) FROM PUBACC_AC GROUP BY uls_file_number -------------- Query OK, 0 rows affected (0.04 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ACebf_number SELECT ebf_number, count(Record_Type) FROM PUBACC_AC GROUP BY ebf_number -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ACcall_sign SELECT call_sign, count(Record_Type) FROM PUBACC_AC GROUP BY call_sign -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ACaircraft_count SELECT aircraft_count, count(Record_Type) FROM PUBACC_AC GROUP BY aircraft_count -------------- Query OK, 0 rows affected (0.04 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ACtype_of_carrier SELECT type_of_carrier, count(Record_Type) FROM PUBACC_AC GROUP BY type_of_carrier -------------- Query OK, 0 rows affected (0.01 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ACportable_indicator SELECT portable_indicator, count(Record_Type) FROM PUBACC_AC GROUP BY portable_indicator -------------- Query OK, 0 rows affected (0.04 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ACfleet_indicator SELECT fleet_indicator, count(Record_Type) FROM PUBACC_AC GROUP BY fleet_indicator -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ACn_number SELECT n_number, count(Record_Type) FROM PUBACC_AC GROUP BY n_number -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ADRecord_Type SELECT Record_Type, count(Record_Type) FROM PUBACC_AD GROUP BY Record_Type -------------- Query OK, 0 rows affected (0.07 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ADunique_system_identifier SELECT unique_system_identifier, count(Record_Type) FROM PUBACC_AD GROUP BY unique_system_identifier -------------- Query OK, 0 rows affected (0.08 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ADULS_File_Number SELECT ULS_File_Number, count(Record_Type) FROM PUBACC_AD GROUP BY ULS_File_Number -------------- Query OK, 0 rows affected (0.06 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ADEBF_Number SELECT EBF_Number, count(Record_Type) FROM PUBACC_AD GROUP BY EBF_Number -------------- Query OK, 0 rows affected (0.05 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ADApplication_Purpose SELECT Application_Purpose, count(Record_Type) FROM PUBACC_AD GROUP BY Application_Purpose -------------- Query OK, 0 rows affected (0.08 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ADApplication_Status SELECT Application_Status, count(Record_Type) FROM PUBACC_AD GROUP BY Application_Status -------------- Query OK, 0 rows affected (0.07 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ADApplication_Fee_Exempt SELECT Application_Fee_Exempt, count(Record_Type) FROM PUBACC_AD GROUP BY Application_Fee_Exempt -------------- Query OK, 0 rows affected (0.01 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ADRegulatory_Fee_Exempt SELECT Regulatory_Fee_Exempt, count(Record_Type) FROM PUBACC_AD GROUP BY Regulatory_Fee_Exempt -------------- Query OK, 0 rows affected (0.07 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ADSource SELECT Source, count(Record_Type) FROM PUBACC_AD GROUP BY Source -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ADrequested_expiration_date_mmdd SELECT requested_expiration_date_mmdd, count(Record_Type) FROM PUBACC_AD GROUP BY requested_expiration_date_mmdd -------------- Query OK, 0 rows affected (0.04 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ADReceipt_Date SELECT Receipt_Date, count(Record_Type) FROM PUBACC_AD GROUP BY Receipt_Date -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ADNotification_Code SELECT Notification_Code, count(Record_Type) FROM PUBACC_AD GROUP BY Notification_Code -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ADNotification_date SELECT Notification_date, count(Record_Type) FROM PUBACC_AD GROUP BY Notification_date -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ADExpanding_Area_or_Contour SELECT Expanding_Area_or_Contour, count(Record_Type) FROM PUBACC_AD GROUP BY Expanding_Area_or_Contour -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ADChange_Type SELECT Change_Type, count(Record_Type) FROM PUBACC_AD GROUP BY Change_Type -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ADOriginal_Application_Purpose SELECT Original_Application_Purpose, count(Record_Type) FROM PUBACC_AD GROUP BY Original_Application_Purpose -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ADRequesting_A_Waiver SELECT Requesting_A_Waiver, count(Record_Type) FROM PUBACC_AD GROUP BY Requesting_A_Waiver -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ADHow_Many_Waivers_Requested SELECT How_Many_Waivers_Requested, count(Record_Type) FROM PUBACC_AD GROUP BY How_Many_Waivers_Requested -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ADAny_Attachments SELECT Any_Attachments, count(Record_Type) FROM PUBACC_AD GROUP BY Any_Attachments -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ADNumber_of_Requested_SIDs SELECT Number_of_Requested_SIDs, count(Record_Type) FROM PUBACC_AD GROUP BY Number_of_Requested_SIDs -------------- Query OK, 0 rows affected (0.04 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ADfee_control_num SELECT fee_control_num, count(Record_Type) FROM PUBACC_AD GROUP BY fee_control_num -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ADdate_entered SELECT date_entered, count(Record_Type) FROM PUBACC_AD GROUP BY date_entered -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ADreason SELECT reason, count(Record_Type) FROM PUBACC_AD GROUP BY reason -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ADfrequency_coordination_indicat SELECT frequency_coordination_indicat, count(Record_Type) FROM PUBACC_AD GROUP BY frequency_coordination_indicat -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ADemergency_sta SELECT emergency_sta, count(Record_Type) FROM PUBACC_AD GROUP BY emergency_sta -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ADoverall_change_type SELECT overall_change_type, count(Record_Type) FROM PUBACC_AD GROUP BY overall_change_type -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ADslow_growth_ind SELECT slow_growth_ind, count(Record_Type) FROM PUBACC_AD GROUP BY slow_growth_ind -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ADprevious_waiver SELECT previous_waiver, count(Record_Type) FROM PUBACC_AD GROUP BY previous_waiver -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_AMrecord_type SELECT record_type, count(Record_Type) FROM PUBACC_AM GROUP BY record_type -------------- Query OK, 0 rows affected (0.08 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_AMunique_system_identifier SELECT unique_system_identifier, count(Record_Type) FROM PUBACC_AM GROUP BY unique_system_identifier -------------- Query OK, 0 rows affected (0.07 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_AMuls_file_num SELECT uls_file_num, count(Record_Type) FROM PUBACC_AM GROUP BY uls_file_num -------------- Query OK, 0 rows affected (0.05 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_AMebf_number SELECT ebf_number, count(Record_Type) FROM PUBACC_AM GROUP BY ebf_number -------------- Query OK, 0 rows affected (0.05 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_AMcallsign SELECT callsign, count(Record_Type) FROM PUBACC_AM GROUP BY callsign -------------- Query OK, 0 rows affected (0.04 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_AMoperator_class SELECT operator_class, count(Record_Type) FROM PUBACC_AM GROUP BY operator_class -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_AMgroup_code SELECT group_code, count(Record_Type) FROM PUBACC_AM GROUP BY group_code -------------- Query OK, 0 rows affected (0.04 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_AMregion_code SELECT region_code, count(Record_Type) FROM PUBACC_AM GROUP BY region_code -------------- Query OK, 0 rows affected (0.06 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_AMtrustee_callsign SELECT trustee_callsign, count(Record_Type) FROM PUBACC_AM GROUP BY trustee_callsign -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_AMtrustee_indicator SELECT trustee_indicator, count(Record_Type) FROM PUBACC_AM GROUP BY trustee_indicator -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_AMphysician_certification SELECT physician_certification, count(Record_Type) FROM PUBACC_AM GROUP BY physician_certification -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_AMve_signature SELECT ve_signature, count(Record_Type) FROM PUBACC_AM GROUP BY ve_signature -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_AMsystematic_callsign_change SELECT systematic_callsign_change, count(Record_Type) FROM PUBACC_AM GROUP BY systematic_callsign_change -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_AMvanity_callsign_change SELECT vanity_callsign_change, count(Record_Type) FROM PUBACC_AM GROUP BY vanity_callsign_change -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_AMvanity_relationship SELECT vanity_relationship, count(Record_Type) FROM PUBACC_AM GROUP BY vanity_relationship -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_AMprevious_callsign SELECT previous_callsign, count(Record_Type) FROM PUBACC_AM GROUP BY previous_callsign -------------- Query OK, 0 rows affected (0.01 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_AMprevious_operator_class SELECT previous_operator_class, count(Record_Type) FROM PUBACC_AM GROUP BY previous_operator_class -------------- Query OK, 0 rows affected (0.01 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_AMtrustee_name SELECT trustee_name, count(Record_Type) FROM PUBACC_AM GROUP BY trustee_name -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ANrecord_type SELECT record_type, count(Record_Type) FROM PUBACC_AN GROUP BY record_type -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ANunique_system_identifier SELECT unique_system_identifier, count(Record_Type) FROM PUBACC_AN GROUP BY unique_system_identifier -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ANuls_file_number SELECT uls_file_number, count(Record_Type) FROM PUBACC_AN GROUP BY uls_file_number -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ANebf_number SELECT ebf_number, count(Record_Type) FROM PUBACC_AN GROUP BY ebf_number -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ANcall_sign SELECT call_sign, count(Record_Type) FROM PUBACC_AN GROUP BY call_sign -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ANantenna_action_performed SELECT antenna_action_performed, count(Record_Type) FROM PUBACC_AN GROUP BY antenna_action_performed -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ANantenna_number SELECT antenna_number, count(Record_Type) FROM PUBACC_AN GROUP BY antenna_number -------------- Query OK, 0 rows affected (0.06 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ANlocation_number SELECT location_number, count(Record_Type) FROM PUBACC_AN GROUP BY location_number -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ANreceive_zone_code SELECT receive_zone_code, count(Record_Type) FROM PUBACC_AN GROUP BY receive_zone_code -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ANantenna_type_code SELECT antenna_type_code, count(Record_Type) FROM PUBACC_AN GROUP BY antenna_type_code -------------- Query OK, 0 rows affected (0.04 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ANheight_to_tip SELECT height_to_tip, count(Record_Type) FROM PUBACC_AN GROUP BY height_to_tip -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ANheight_to_center_raat SELECT height_to_center_raat, count(Record_Type) FROM PUBACC_AN GROUP BY height_to_center_raat -------------- Query OK, 0 rows affected (0.06 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ANantenna_make SELECT antenna_make, count(Record_Type) FROM PUBACC_AN GROUP BY antenna_make -------------- Query OK, 0 rows affected (0.15 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ANantenna_model SELECT antenna_model, count(Record_Type) FROM PUBACC_AN GROUP BY antenna_model -------------- Query OK, 0 rows affected (0.06 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ANtilt SELECT tilt, count(Record_Type) FROM PUBACC_AN GROUP BY tilt -------------- Query OK, 0 rows affected (0.10 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ANpolarization_code SELECT polarization_code, count(Record_Type) FROM PUBACC_AN GROUP BY polarization_code -------------- Query OK, 0 rows affected (0.06 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ANbeamwidth SELECT beamwidth, count(Record_Type) FROM PUBACC_AN GROUP BY beamwidth -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ANgain SELECT gain, count(Record_Type) FROM PUBACC_AN GROUP BY gain -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ANazimuth SELECT azimuth, count(Record_Type) FROM PUBACC_AN GROUP BY azimuth -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ANheight_above_avg_terrain SELECT height_above_avg_terrain, count(Record_Type) FROM PUBACC_AN GROUP BY height_above_avg_terrain -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ANdiversity_height SELECT diversity_height, count(Record_Type) FROM PUBACC_AN GROUP BY diversity_height -------------- Query OK, 0 rows affected (0.04 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ANdiversity_gain SELECT diversity_gain, count(Record_Type) FROM PUBACC_AN GROUP BY diversity_gain -------------- Query OK, 0 rows affected (0.05 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ANdiversity_beam SELECT diversity_beam, count(Record_Type) FROM PUBACC_AN GROUP BY diversity_beam -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ANreflector_height SELECT reflector_height, count(Record_Type) FROM PUBACC_AN GROUP BY reflector_height -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ANreflector_width SELECT reflector_width, count(Record_Type) FROM PUBACC_AN GROUP BY reflector_width -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ANreflector_separation SELECT reflector_separation, count(Record_Type) FROM PUBACC_AN GROUP BY reflector_separation -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ANrepeater_seq_num SELECT repeater_seq_num, count(Record_Type) FROM PUBACC_AN GROUP BY repeater_seq_num -------------- Query OK, 0 rows affected (0.04 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ANback_to_back_tx_dish_gain SELECT back_to_back_tx_dish_gain, count(Record_Type) FROM PUBACC_AN GROUP BY back_to_back_tx_dish_gain -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ANback_to_back_rx_dish_gain SELECT back_to_back_rx_dish_gain, count(Record_Type) FROM PUBACC_AN GROUP BY back_to_back_rx_dish_gain -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ANlocation_name SELECT location_name, count(Record_Type) FROM PUBACC_AN GROUP BY location_name -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ANpassive_repeater_id SELECT passive_repeater_id, count(Record_Type) FROM PUBACC_AN GROUP BY passive_repeater_id -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ANalternative_cgsa_method SELECT alternative_cgsa_method, count(Record_Type) FROM PUBACC_AN GROUP BY alternative_cgsa_method -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ANpath_number SELECT path_number, count(Record_Type) FROM PUBACC_AN GROUP BY path_number -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ANline_loss SELECT line_loss, count(Record_Type) FROM PUBACC_AN GROUP BY line_loss -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ASrecord_type SELECT record_type, count(Record_Type) FROM PUBACC_AS GROUP BY record_type -------------- Query OK, 0 rows affected (0.07 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ASunique_system_identifier SELECT unique_system_identifier, count(Record_Type) FROM PUBACC_AS GROUP BY unique_system_identifier -------------- Query OK, 0 rows affected (0.06 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ASuls_file_number SELECT uls_file_number, count(Record_Type) FROM PUBACC_AS GROUP BY uls_file_number -------------- Query OK, 0 rows affected (0.10 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ASebf_number SELECT ebf_number, count(Record_Type) FROM PUBACC_AS GROUP BY ebf_number -------------- Query OK, 0 rows affected (0.06 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_AScallsign SELECT callsign, count(Record_Type) FROM PUBACC_AS GROUP BY callsign -------------- Query OK, 0 rows affected (0.07 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ASassoc_callsign SELECT assoc_callsign, count(Record_Type) FROM PUBACC_AS GROUP BY assoc_callsign -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ATRecord_Type SELECT Record_Type, count(Record_Type) FROM PUBACC_AT GROUP BY Record_Type -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ATunique_system_identifier SELECT unique_system_identifier, count(Record_Type) FROM PUBACC_AT GROUP BY unique_system_identifier -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ATULS_File_Number SELECT ULS_File_Number, count(Record_Type) FROM PUBACC_AT GROUP BY ULS_File_Number -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ATEBF_Number SELECT EBF_Number, count(Record_Type) FROM PUBACC_AT GROUP BY EBF_Number -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ATAttachment_Code SELECT Attachment_Code, count(Record_Type) FROM PUBACC_AT GROUP BY Attachment_Code -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ATAttachment_Description SELECT Attachment_Description, count(Record_Type) FROM PUBACC_AT GROUP BY Attachment_Description -------------- Query OK, 0 rows affected (0.05 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ATAttachment_Date SELECT Attachment_Date, count(Record_Type) FROM PUBACC_AT GROUP BY Attachment_Date -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ATattachment_file_name SELECT attachment_file_name, count(Record_Type) FROM PUBACC_AT GROUP BY attachment_file_name -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ATattachment_action_performed SELECT attachment_action_performed, count(Record_Type) FROM PUBACC_AT GROUP BY attachment_action_performed -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_BCrecord_type SELECT record_type, count(Record_Type) FROM PUBACC_BC GROUP BY record_type -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_BCunique_system_identifier SELECT unique_system_identifier, count(Record_Type) FROM PUBACC_BC GROUP BY unique_system_identifier -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_BCuls_file_number SELECT uls_file_number, count(Record_Type) FROM PUBACC_BC GROUP BY uls_file_number -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_BCebf_number SELECT ebf_number, count(Record_Type) FROM PUBACC_BC GROUP BY ebf_number -------------- Query OK, 0 rows affected (0.04 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_BCcallsign SELECT callsign, count(Record_Type) FROM PUBACC_BC GROUP BY callsign -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_BCbroadcast_callsign SELECT broadcast_callsign, count(Record_Type) FROM PUBACC_BC GROUP BY broadcast_callsign -------------- Query OK, 0 rows affected (0.04 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_BCbroadcast_city SELECT broadcast_city, count(Record_Type) FROM PUBACC_BC GROUP BY broadcast_city -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_BCbroadcast_state SELECT broadcast_state, count(Record_Type) FROM PUBACC_BC GROUP BY broadcast_state -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_BCparent_facility_id SELECT parent_facility_id, count(Record_Type) FROM PUBACC_BC GROUP BY parent_facility_id -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_BCparent_class_code SELECT parent_class_code, count(Record_Type) FROM PUBACC_BC GROUP BY parent_class_code -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_BCnonparent_type_code SELECT nonparent_type_code, count(Record_Type) FROM PUBACC_BC GROUP BY nonparent_type_code -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_BFrecord_type SELECT record_type, count(Record_Type) FROM PUBACC_BF GROUP BY record_type -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_BFunique_system_identifier SELECT unique_system_identifier, count(Record_Type) FROM PUBACC_BF GROUP BY unique_system_identifier -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_BFcall_sign SELECT call_sign, count(Record_Type) FROM PUBACC_BF GROUP BY call_sign -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_BFlocation_number SELECT location_number, count(Record_Type) FROM PUBACC_BF GROUP BY location_number -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_BFantenna_number SELECT antenna_number, count(Record_Type) FROM PUBACC_BF GROUP BY antenna_number -------------- Query OK, 0 rows affected (0.04 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_BFfrequency_assigned SELECT frequency_assigned, count(Record_Type) FROM PUBACC_BF GROUP BY frequency_assigned -------------- Query OK, 0 rows affected (0.08 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_BFbuildout_code SELECT buildout_code, count(Record_Type) FROM PUBACC_BF GROUP BY buildout_code -------------- Query OK, 0 rows affected (0.06 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_BFbuildout_deadline SELECT buildout_deadline, count(Record_Type) FROM PUBACC_BF GROUP BY buildout_deadline -------------- Query OK, 0 rows affected (0.07 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_BFbuildout_date SELECT buildout_date, count(Record_Type) FROM PUBACC_BF GROUP BY buildout_date -------------- Query OK, 0 rows affected (0.06 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_BLrecord_type SELECT record_type, count(Record_Type) FROM PUBACC_BL GROUP BY record_type -------------- Query OK, 0 rows affected (0.08 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_BLunique_system_identifier SELECT unique_system_identifier, count(Record_Type) FROM PUBACC_BL GROUP BY unique_system_identifier -------------- Query OK, 0 rows affected (0.05 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_BLcall_sign SELECT call_sign, count(Record_Type) FROM PUBACC_BL GROUP BY call_sign -------------- Query OK, 0 rows affected (0.04 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_BLlocation SELECT location, count(Record_Type) FROM PUBACC_BL GROUP BY location -------------- Query OK, 0 rows affected (0.01 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_BLbuildout_code SELECT buildout_code, count(Record_Type) FROM PUBACC_BL GROUP BY buildout_code -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_BLbuildout_deadline SELECT buildout_deadline, count(Record_Type) FROM PUBACC_BL GROUP BY buildout_deadline -------------- Query OK, 0 rows affected (0.04 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_BLbuildout_date SELECT buildout_date, count(Record_Type) FROM PUBACC_BL GROUP BY buildout_date -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_BOrecord_type SELECT record_type, count(Record_Type) FROM PUBACC_BO GROUP BY record_type -------------- Query OK, 0 rows affected (0.04 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_BOunique_system_identifier SELECT unique_system_identifier, count(Record_Type) FROM PUBACC_BO GROUP BY unique_system_identifier -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_BOcall_sign SELECT call_sign, count(Record_Type) FROM PUBACC_BO GROUP BY call_sign -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_BObuildout_code SELECT buildout_code, count(Record_Type) FROM PUBACC_BO GROUP BY buildout_code -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_BObuildout_deadline SELECT buildout_deadline, count(Record_Type) FROM PUBACC_BO GROUP BY buildout_deadline -------------- Query OK, 0 rows affected (0.04 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_BObuildout_date SELECT buildout_date, count(Record_Type) FROM PUBACC_BO GROUP BY buildout_date -------------- Query OK, 0 rows affected (0.09 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CFRecord_Type SELECT Record_Type, count(Record_Type) FROM PUBACC_CF GROUP BY Record_Type -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CFunique_system_identifier SELECT unique_system_identifier, count(Record_Type) FROM PUBACC_CF GROUP BY unique_system_identifier -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CFULS_File_Number SELECT ULS_File_Number, count(Record_Type) FROM PUBACC_CF GROUP BY ULS_File_Number -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CFEBF_Number SELECT EBF_Number, count(Record_Type) FROM PUBACC_CF GROUP BY EBF_Number -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CFItem_Type_Indicator SELECT Item_Type_Indicator, count(Record_Type) FROM PUBACC_CF GROUP BY Item_Type_Indicator -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CFItem_Type SELECT Item_Type, count(Record_Type) FROM PUBACC_CF GROUP BY Item_Type -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CFConstructed SELECT Constructed, count(Record_Type) FROM PUBACC_CF GROUP BY Constructed -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CFLocation_Number SELECT Location_Number, count(Record_Type) FROM PUBACC_CF GROUP BY Location_Number -------------- Query OK, 0 rows affected (0.04 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CFPath_Number SELECT Path_Number, count(Record_Type) FROM PUBACC_CF GROUP BY Path_Number -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CFFrequency_Assigned SELECT Frequency_Assigned, count(Record_Type) FROM PUBACC_CF GROUP BY Frequency_Assigned -------------- Query OK, 0 rows affected (0.17 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CFFrequency_Upper_Band SELECT Frequency_Upper_Band, count(Record_Type) FROM PUBACC_CF GROUP BY Frequency_Upper_Band -------------- Query OK, 0 rows affected (0.06 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CFnumber_of_mobiles SELECT number_of_mobiles, count(Record_Type) FROM PUBACC_CF GROUP BY number_of_mobiles -------------- Query OK, 0 rows affected (0.10 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CFaction_performed SELECT action_performed, count(Record_Type) FROM PUBACC_CF GROUP BY action_performed -------------- Query OK, 0 rows affected (0.05 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CGrecord_type SELECT record_type, count(Record_Type) FROM PUBACC_CG GROUP BY record_type -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CGunique_system_identifier SELECT unique_system_identifier, count(Record_Type) FROM PUBACC_CG GROUP BY unique_system_identifier -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CGuls_file_number SELECT uls_file_number, count(Record_Type) FROM PUBACC_CG GROUP BY uls_file_number -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CGebf_number SELECT ebf_number, count(Record_Type) FROM PUBACC_CG GROUP BY ebf_number -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CGcall_sign SELECT call_sign, count(Record_Type) FROM PUBACC_CG GROUP BY call_sign -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CGstation_available SELECT station_available, count(Record_Type) FROM PUBACC_CG GROUP BY station_available -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CGpublic_correspondence SELECT public_correspondence, count(Record_Type) FROM PUBACC_CG GROUP BY public_correspondence -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CGstation_identifier SELECT station_identifier, count(Record_Type) FROM PUBACC_CG GROUP BY station_identifier -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CGaeronautical_enroute_call_sign SELECT aeronautical_enroute_call_sign, count(Record_Type) FROM PUBACC_CG GROUP BY aeronautical_enroute_call_sign -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CGfaa_office_notified SELECT faa_office_notified, count(Record_Type) FROM PUBACC_CG GROUP BY faa_office_notified -------------- Query OK, 0 rows affected (0.04 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CGdate_faa_notified SELECT date_faa_notified, count(Record_Type) FROM PUBACC_CG GROUP BY date_faa_notified -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CGseeking_authorization SELECT seeking_authorization, count(Record_Type) FROM PUBACC_CG GROUP BY seeking_authorization -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CGregularly_engaged SELECT regularly_engaged, count(Record_Type) FROM PUBACC_CG GROUP BY regularly_engaged -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CGengaged SELECT engaged, count(Record_Type) FROM PUBACC_CG GROUP BY engaged -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CGpublic_mooring SELECT public_mooring, count(Record_Type) FROM PUBACC_CG GROUP BY public_mooring -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CGservicing SELECT servicing, count(Record_Type) FROM PUBACC_CG GROUP BY servicing -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CGfixed_station SELECT fixed_station, count(Record_Type) FROM PUBACC_CG GROUP BY fixed_station -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CGmaritime_support SELECT maritime_support, count(Record_Type) FROM PUBACC_CG GROUP BY maritime_support -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CGaeronautical_fixed SELECT aeronautical_fixed, count(Record_Type) FROM PUBACC_CG GROUP BY aeronautical_fixed -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CGunicom SELECT unicom, count(Record_Type) FROM PUBACC_CG GROUP BY unicom -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CGsearch_and_rescue SELECT search_and_rescue, count(Record_Type) FROM PUBACC_CG GROUP BY search_and_rescue -------------- Query OK, 0 rows affected (0.06 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CGflight_test_uhf SELECT flight_test_uhf, count(Record_Type) FROM PUBACC_CG GROUP BY flight_test_uhf -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CGflight_test_manufacturer SELECT flight_test_manufacturer, count(Record_Type) FROM PUBACC_CG GROUP BY flight_test_manufacturer -------------- Query OK, 0 rows affected (0.08 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CGflight_test_parent_corporation SELECT flight_test_parent_corporation, count(Record_Type) FROM PUBACC_CG GROUP BY flight_test_parent_corporation -------------- Query OK, 0 rows affected (0.10 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CGflight_test_educational SELECT flight_test_educational, count(Record_Type) FROM PUBACC_CG GROUP BY flight_test_educational -------------- Query OK, 0 rows affected (0.09 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CGflight_school_certitication SELECT flight_school_certitication, count(Record_Type) FROM PUBACC_CG GROUP BY flight_school_certitication -------------- Query OK, 0 rows affected (0.07 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CGlighter_than_air SELECT lighter_than_air, count(Record_Type) FROM PUBACC_CG GROUP BY lighter_than_air -------------- Query OK, 0 rows affected (0.08 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CGballooning SELECT ballooning, count(Record_Type) FROM PUBACC_CG GROUP BY ballooning -------------- Query OK, 0 rows affected (0.05 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CGlocated_at_airport SELECT located_at_airport, count(Record_Type) FROM PUBACC_CG GROUP BY located_at_airport -------------- Query OK, 0 rows affected (0.04 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CGradiodetermination_not_faa SELECT radiodetermination_not_faa, count(Record_Type) FROM PUBACC_CG GROUP BY radiodetermination_not_faa -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CGradiodetermination_equipment SELECT radiodetermination_equipment, count(Record_Type) FROM PUBACC_CG GROUP BY radiodetermination_equipment -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CGradiodetermination_public SELECT radiodetermination_public, count(Record_Type) FROM PUBACC_CG GROUP BY radiodetermination_public -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CGradiodetermination_elts SELECT radiodetermination_elts, count(Record_Type) FROM PUBACC_CG GROUP BY radiodetermination_elts -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CGcivil_air_patrol SELECT civil_air_patrol, count(Record_Type) FROM PUBACC_CG GROUP BY civil_air_patrol -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CGaeronautical_enroute SELECT aeronautical_enroute, count(Record_Type) FROM PUBACC_CG GROUP BY aeronautical_enroute -------------- Query OK, 0 rows affected (0.04 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CGmobile_routine SELECT mobile_routine, count(Record_Type) FROM PUBACC_CG GROUP BY mobile_routine -------------- Query OK, 0 rows affected (0.04 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CGmobile_owner_operator SELECT mobile_owner_operator, count(Record_Type) FROM PUBACC_CG GROUP BY mobile_owner_operator -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CGmobile_agreement SELECT mobile_agreement, count(Record_Type) FROM PUBACC_CG GROUP BY mobile_agreement -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CGcoast_ground_identifier SELECT coast_ground_identifier, count(Record_Type) FROM PUBACC_CG GROUP BY coast_ground_identifier -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CGselective_call_sign_identifier SELECT selective_call_sign_identifier, count(Record_Type) FROM PUBACC_CG GROUP BY selective_call_sign_identifier -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CGstation_class SELECT station_class, count(Record_Type) FROM PUBACC_CG GROUP BY station_class -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_COrecord_type SELECT record_type, count(Record_Type) FROM PUBACC_CO GROUP BY record_type -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_COunique_system_identifier SELECT unique_system_identifier, count(Record_Type) FROM PUBACC_CO GROUP BY unique_system_identifier -------------- Query OK, 0 rows affected (0.04 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_COuls_file_num SELECT uls_file_num, count(Record_Type) FROM PUBACC_CO GROUP BY uls_file_num -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_COcallsign SELECT callsign, count(Record_Type) FROM PUBACC_CO GROUP BY callsign -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_COdate SELECT date, count(Record_Type) FROM PUBACC_CO GROUP BY date -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_COdescription SELECT description, count(Record_Type) FROM PUBACC_CO GROUP BY description -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CPrecord_type SELECT record_type, count(Record_Type) FROM PUBACC_CP GROUP BY record_type -------------- Query OK, 2 rows affected (10.87 sec) Records: 2 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CPunique_system_identifier SELECT unique_system_identifier, count(Record_Type) FROM PUBACC_CP GROUP BY unique_system_identifier -------------- Query OK, 641875 rows affected (1 min 7.64 sec) Records: 641875 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CPuls_file_number SELECT uls_file_number, count(Record_Type) FROM PUBACC_CP GROUP BY uls_file_number -------------- Query OK, 3 rows affected (10.46 sec) Records: 3 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CPebf_number SELECT ebf_number, count(Record_Type) FROM PUBACC_CP GROUP BY ebf_number -------------- Query OK, 3 rows affected (9.57 sec) Records: 3 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CPcall_sign SELECT call_sign, count(Record_Type) FROM PUBACC_CP GROUP BY call_sign -------------- Query OK, 641876 rows affected (1 min 2.29 sec) Records: 641876 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CPcontrol_point_action_performed SELECT control_point_action_performed, count(Record_Type) FROM PUBACC_CP GROUP BY control_point_action_performed -------------- Query OK, 2 rows affected (10.18 sec) Records: 2 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CPcontrol_point_number SELECT control_point_number, count(Record_Type) FROM PUBACC_CP GROUP BY control_point_number -------------- Query OK, 42 rows affected (9.53 sec) Records: 42 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CPcontrol_address SELECT control_address, count(Record_Type) FROM PUBACC_CP GROUP BY control_address -------------- Query OK, 412675 rows affected (1 min 30.10 sec) Records: 412675 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CPcontrol_city SELECT control_city, count(Record_Type) FROM PUBACC_CP GROUP BY control_city -------------- Query OK, 24696 rows affected (22.36 sec) Records: 24696 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CPstate_code SELECT state_code, count(Record_Type) FROM PUBACC_CP GROUP BY state_code -------------- Query OK, 70 rows affected (14.01 sec) Records: 70 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CPcontrol_phone SELECT control_phone, count(Record_Type) FROM PUBACC_CP GROUP BY control_phone -------------- Query OK, 373997 rows affected (41.91 sec) Records: 373997 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CPcontrol_county SELECT control_county, count(Record_Type) FROM PUBACC_CP GROUP BY control_county -------------- Query OK, 1906 rows affected (13.22 sec) Records: 1906 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CSrecord_type SELECT record_type, count(Record_Type) FROM PUBACC_CS GROUP BY record_type -------------- Query OK, 0 rows affected (0.05 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CSunique_system_identifier SELECT unique_system_identifier, count(Record_Type) FROM PUBACC_CS GROUP BY unique_system_identifier -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CSuls_file_number SELECT uls_file_number, count(Record_Type) FROM PUBACC_CS GROUP BY uls_file_number -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CScall_sign SELECT call_sign, count(Record_Type) FROM PUBACC_CS GROUP BY call_sign -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CSlocation_number SELECT location_number, count(Record_Type) FROM PUBACC_CS GROUP BY location_number -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CSantenna_number SELECT antenna_number, count(Record_Type) FROM PUBACC_CS GROUP BY antenna_number -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CSfrequency_assigned SELECT frequency_assigned, count(Record_Type) FROM PUBACC_CS GROUP BY frequency_assigned -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_CScoser_result SELECT coser_result, count(Record_Type) FROM PUBACC_CS GROUP BY coser_result -------------- Query OK, 0 rows affected (0.01 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_EMrecord_type SELECT record_type, count(Record_Type) FROM PUBACC_EM GROUP BY record_type -------------- Query OK, 1 row affected (4 min 59.98 sec) Records: 1 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_EMunique_system_identifier SELECT unique_system_identifier, count(Record_Type) FROM PUBACC_EM GROUP BY unique_system_identifier -------------- Query OK, 683504 rows affected (17 min 57.76 sec) Records: 683504 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_EMuls_file_number SELECT uls_file_number, count(Record_Type) FROM PUBACC_EM GROUP BY uls_file_number -------------- Query OK, 1 row affected (5 min 4.80 sec) Records: 1 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_EMebf_number SELECT ebf_number, count(Record_Type) FROM PUBACC_EM GROUP BY ebf_number -------------- Query OK, 1 row affected (5 min 2.88 sec) Records: 1 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_EMcall_sign SELECT call_sign, count(Record_Type) FROM PUBACC_EM GROUP BY call_sign -------------- Query OK, 683501 rows affected (16 min 30.18 sec) Records: 683501 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_EMlocation_number SELECT location_number, count(Record_Type) FROM PUBACC_EM GROUP BY location_number -------------- Query OK, 219 rows affected (5 min 32.07 sec) Records: 219 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_EMantenna_number SELECT antenna_number, count(Record_Type) FROM PUBACC_EM GROUP BY antenna_number -------------- Query OK, 27 rows affected (5 min 6.89 sec) Records: 27 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_EMfrequency_assigned SELECT frequency_assigned, count(Record_Type) FROM PUBACC_EM GROUP BY frequency_assigned -------------- Query OK, 18321 rows affected (9 min 59.79 sec) Records: 18321 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_EMemission_action_performed SELECT emission_action_performed, count(Record_Type) FROM PUBACC_EM GROUP BY emission_action_performed -------------- Query OK, 1 row affected (4 min 57.15 sec) Records: 1 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_EMemission_code SELECT emission_code, count(Record_Type) FROM PUBACC_EM GROUP BY emission_code -------------- Query OK, 1527 rows affected (9 min 19.78 sec) Records: 1527 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_EMdigital_mod_rate SELECT digital_mod_rate, count(Record_Type) FROM PUBACC_EM GROUP BY digital_mod_rate -------------- Query OK, 2 rows affected (5 min 3.16 sec) Records: 2 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_EMdigital_mod_type SELECT digital_mod_type, count(Record_Type) FROM PUBACC_EM GROUP BY digital_mod_type -------------- Query OK, 1 row affected (5 min 0.52 sec) Records: 1 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_EMfrequency_number SELECT frequency_number, count(Record_Type) FROM PUBACC_EM GROUP BY frequency_number -------------- Query OK, 15242 rows affected (9 min 54.47 sec) Records: 15242 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ENrecord_type SELECT record_type, count(Record_Type) FROM PUBACC_EN GROUP BY record_type -------------- Query OK, 1 row affected (18.98 sec) Records: 1 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ENunique_system_identifier SELECT unique_system_identifier, count(Record_Type) FROM PUBACC_EN GROUP BY unique_system_identifier -------------- Query OK, 684357 rows affected (1 min 26.78 sec) Records: 684357 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ENuls_file_number SELECT uls_file_number, count(Record_Type) FROM PUBACC_EN GROUP BY uls_file_number -------------- Query OK, 1 row affected (16.56 sec) Records: 1 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ENebf_number SELECT ebf_number, count(Record_Type) FROM PUBACC_EN GROUP BY ebf_number -------------- Query OK, 1 row affected (15.52 sec) Records: 1 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ENcall_sign SELECT call_sign, count(Record_Type) FROM PUBACC_EN GROUP BY call_sign -------------- Query OK, 684354 rows affected (1 min 23.12 sec) Records: 684354 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ENentity_type SELECT entity_type, count(Record_Type) FROM PUBACC_EN GROUP BY entity_type -------------- Query OK, 3 rows affected (15.89 sec) Records: 3 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ENlicensee_id SELECT licensee_id, count(Record_Type) FROM PUBACC_EN GROUP BY licensee_id -------------- Query OK, 200840 rows affected (40.54 sec) Records: 200840 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ENentity_name SELECT entity_name, count(Record_Type) FROM PUBACC_EN GROUP BY entity_name -------------- Query OK, 356457 rows affected (3 min 47.54 sec) Records: 356457 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ENfirst_name SELECT first_name, count(Record_Type) FROM PUBACC_EN GROUP BY first_name -------------- Query OK, 6003 rows affected (21.84 sec) Records: 6003 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ENmi SELECT mi, count(Record_Type) FROM PUBACC_EN GROUP BY mi -------------- Query OK, 33 rows affected (15.71 sec) Records: 33 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ENlast_name SELECT last_name, count(Record_Type) FROM PUBACC_EN GROUP BY last_name -------------- Query OK, 29836 rows affected (23.67 sec) Records: 29836 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ENsuffix SELECT suffix, count(Record_Type) FROM PUBACC_EN GROUP BY suffix -------------- Query OK, 154 rows affected (15.90 sec) Records: 154 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ENphone SELECT phone, count(Record_Type) FROM PUBACC_EN GROUP BY phone -------------- Query OK, 355199 rows affected (55.98 sec) Records: 355199 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ENfax SELECT fax, count(Record_Type) FROM PUBACC_EN GROUP BY fax -------------- Query OK, 117070 rows affected (36.19 sec) Records: 117070 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ENemail SELECT email, count(Record_Type) FROM PUBACC_EN GROUP BY email -------------- Query OK, 28983 rows affected (21.83 sec) Records: 28983 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ENstreet_address SELECT street_address, count(Record_Type) FROM PUBACC_EN GROUP BY street_address -------------- Query OK, 302197 rows affected (1 min 2.59 sec) Records: 302197 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ENcity SELECT city, count(Record_Type) FROM PUBACC_EN GROUP BY city -------------- Query OK, 22688 rows affected (35.88 sec) Records: 22688 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ENstate SELECT state, count(Record_Type) FROM PUBACC_EN GROUP BY state -------------- Query OK, 63 rows affected (22.37 sec) Records: 63 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ENzip_code SELECT zip_code, count(Record_Type) FROM PUBACC_EN GROUP BY zip_code -------------- Query OK, 76848 rows affected (41.98 sec) Records: 76848 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ENpo_box SELECT po_box, count(Record_Type) FROM PUBACC_EN GROUP BY po_box -------------- Query OK, 16595 rows affected (22.74 sec) Records: 16595 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ENattention_line SELECT attention_line, count(Record_Type) FROM PUBACC_EN GROUP BY attention_line -------------- Query OK, 202973 rows affected (35.82 sec) Records: 202973 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ENsgin SELECT sgin, count(Record_Type) FROM PUBACC_EN GROUP BY sgin -------------- Query OK, 2433 rows affected (18.40 sec) Records: 2433 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_ENfrn SELECT frn, count(Record_Type) FROM PUBACC_EN GROUP BY frn -------------- Query OK, 229356 rows affected (42.41 sec) Records: 229356 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_F2record_type SELECT record_type, count(Record_Type) FROM PUBACC_F2 GROUP BY record_type -------------- Query OK, 0 rows affected (1.59 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_F2unique_system_identifier SELECT unique_system_identifier, count(Record_Type) FROM PUBACC_F2 GROUP BY unique_system_identifier -------------- Query OK, 0 rows affected (0.09 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_F2uls_file_number SELECT uls_file_number, count(Record_Type) FROM PUBACC_F2 GROUP BY uls_file_number -------------- Query OK, 0 rows affected (0.09 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_F2ebf_number SELECT ebf_number, count(Record_Type) FROM PUBACC_F2 GROUP BY ebf_number -------------- Query OK, 0 rows affected (0.15 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_F2call_sign SELECT call_sign, count(Record_Type) FROM PUBACC_F2 GROUP BY call_sign -------------- Query OK, 0 rows affected (0.10 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_F2location_number SELECT location_number, count(Record_Type) FROM PUBACC_F2 GROUP BY location_number -------------- Query OK, 0 rows affected (0.10 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_F2antenna_number SELECT antenna_number, count(Record_Type) FROM PUBACC_F2 GROUP BY antenna_number -------------- Query OK, 0 rows affected (0.11 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_F2frequency_number SELECT frequency_number, count(Record_Type) FROM PUBACC_F2 GROUP BY frequency_number -------------- Query OK, 0 rows affected (0.16 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_F2frequency_assigned SELECT frequency_assigned, count(Record_Type) FROM PUBACC_F2 GROUP BY frequency_assigned -------------- Query OK, 0 rows affected (0.11 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_F2frequency_upper_band SELECT frequency_upper_band, count(Record_Type) FROM PUBACC_F2 GROUP BY frequency_upper_band -------------- Query OK, 0 rows affected (0.09 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_F2offset SELECT offset, count(Record_Type) FROM PUBACC_F2 GROUP BY offset -------------- Query OK, 0 rows affected (0.05 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_F2frequency_channel_block SELECT frequency_channel_block, count(Record_Type) FROM PUBACC_F2 GROUP BY frequency_channel_block -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_F2equipment_class SELECT equipment_class, count(Record_Type) FROM PUBACC_F2 GROUP BY equipment_class -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_F2minimum_power_output SELECT minimum_power_output, count(Record_Type) FROM PUBACC_F2 GROUP BY minimum_power_output -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FArecord_type SELECT record_type, count(Record_Type) FROM PUBACC_FA GROUP BY record_type -------------- Query OK, 0 rows affected (0.06 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FAunique_system_identifier SELECT unique_system_identifier, count(Record_Type) FROM PUBACC_FA GROUP BY unique_system_identifier -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FAuls_file_number SELECT uls_file_number, count(Record_Type) FROM PUBACC_FA GROUP BY uls_file_number -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FAebf_number SELECT ebf_number, count(Record_Type) FROM PUBACC_FA GROUP BY ebf_number -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FAcall_sign SELECT call_sign, count(Record_Type) FROM PUBACC_FA GROUP BY call_sign -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FAoperator_class SELECT operator_class, count(Record_Type) FROM PUBACC_FA GROUP BY operator_class -------------- Query OK, 0 rows affected (0.04 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FAship_radar_endorsement SELECT ship_radar_endorsement, count(Record_Type) FROM PUBACC_FA GROUP BY ship_radar_endorsement -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FAsix_month_endorsement SELECT six_month_endorsement, count(Record_Type) FROM PUBACC_FA GROUP BY six_month_endorsement -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FAdate_of_birth SELECT date_of_birth, count(Record_Type) FROM PUBACC_FA GROUP BY date_of_birth -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FAcertification_not_restricted SELECT certification_not_restricted, count(Record_Type) FROM PUBACC_FA GROUP BY certification_not_restricted -------------- Query OK, 0 rows affected (0.05 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FAcert_restricted_permit SELECT cert_restricted_permit, count(Record_Type) FROM PUBACC_FA GROUP BY cert_restricted_permit -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FArestricted_permit_limited_use SELECT restricted_permit_limited_use, count(Record_Type) FROM PUBACC_FA GROUP BY restricted_permit_limited_use -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FAcole_manager_code SELECT cole_manager_code, count(Record_Type) FROM PUBACC_FA GROUP BY cole_manager_code -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FAdm_call_sign SELECT dm_call_sign, count(Record_Type) FROM PUBACC_FA GROUP BY dm_call_sign -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FAproof_of_passing SELECT proof_of_passing, count(Record_Type) FROM PUBACC_FA GROUP BY proof_of_passing -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FCrecord_type SELECT record_type, count(Record_Type) FROM PUBACC_FC GROUP BY record_type -------------- Query OK, 0 rows affected (0.12 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FCunique_system_identifier SELECT unique_system_identifier, count(Record_Type) FROM PUBACC_FC GROUP BY unique_system_identifier -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FCuls_file_number SELECT uls_file_number, count(Record_Type) FROM PUBACC_FC GROUP BY uls_file_number -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FCebf_number SELECT ebf_number, count(Record_Type) FROM PUBACC_FC GROUP BY ebf_number -------------- Query OK, 0 rows affected (0.06 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FCcoordination_number SELECT coordination_number, count(Record_Type) FROM PUBACC_FC GROUP BY coordination_number -------------- Query OK, 0 rows affected (0.08 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FCcoordinator_name SELECT coordinator_name, count(Record_Type) FROM PUBACC_FC GROUP BY coordinator_name -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FCcoordinator_phone SELECT coordinator_phone, count(Record_Type) FROM PUBACC_FC GROUP BY coordinator_phone -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FCfreq_coordination_date SELECT freq_coordination_date, count(Record_Type) FROM PUBACC_FC GROUP BY freq_coordination_date -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FCaction_performed SELECT action_performed, count(Record_Type) FROM PUBACC_FC GROUP BY action_performed -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FFrecord_type SELECT record_type, count(Record_Type) FROM PUBACC_FF GROUP BY record_type -------------- Query OK, 0 rows affected (0.04 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FFunique_system_identifier SELECT unique_system_identifier, count(Record_Type) FROM PUBACC_FF GROUP BY unique_system_identifier -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FFcallsign SELECT callsign, count(Record_Type) FROM PUBACC_FF GROUP BY callsign -------------- Query OK, 0 rows affected (0.01 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FFlocation_number SELECT location_number, count(Record_Type) FROM PUBACC_FF GROUP BY location_number -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FFantenna_number SELECT antenna_number, count(Record_Type) FROM PUBACC_FF GROUP BY antenna_number -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FFfrequency SELECT frequency, count(Record_Type) FROM PUBACC_FF GROUP BY frequency -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FFfrequency_number SELECT frequency_number, count(Record_Type) FROM PUBACC_FF GROUP BY frequency_number -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FFfreq_freeform_cond_type SELECT freq_freeform_cond_type, count(Record_Type) FROM PUBACC_FF GROUP BY freq_freeform_cond_type -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FFunique_freq_freeform_id SELECT unique_freq_freeform_id, count(Record_Type) FROM PUBACC_FF GROUP BY unique_freq_freeform_id -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FFsequence_number SELECT sequence_number, count(Record_Type) FROM PUBACC_FF GROUP BY sequence_number -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FFfreq_freeform_condition SELECT freq_freeform_condition, count(Record_Type) FROM PUBACC_FF GROUP BY freq_freeform_condition -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FRrecord_type SELECT record_type, count(Record_Type) FROM PUBACC_FR GROUP BY record_type -------------- Query OK, 1 row affected (2 min 35.66 sec) Records: 1 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FRunique_system_identifier SELECT unique_system_identifier, count(Record_Type) FROM PUBACC_FR GROUP BY unique_system_identifier -------------- Query OK, 684033 rows affected (8 min 42.29 sec) Records: 684033 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FRuls_file_number SELECT uls_file_number, count(Record_Type) FROM PUBACC_FR GROUP BY uls_file_number -------------- Query OK, 1 row affected (2 min 38.91 sec) Records: 1 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FRebf_number SELECT ebf_number, count(Record_Type) FROM PUBACC_FR GROUP BY ebf_number -------------- Query OK, 1 row affected (2 min 35.67 sec) Records: 1 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FRcall_sign SELECT call_sign, count(Record_Type) FROM PUBACC_FR GROUP BY call_sign -------------- Query OK, 684030 rows affected (8 min 12.59 sec) Records: 684030 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FRfrequency_action_performed SELECT frequency_action_performed, count(Record_Type) FROM PUBACC_FR GROUP BY frequency_action_performed -------------- Query OK, 1 row affected (2 min 37.64 sec) Records: 1 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FRlocation_number SELECT location_number, count(Record_Type) FROM PUBACC_FR GROUP BY location_number -------------- Query OK, 220 rows affected (2 min 47.96 sec) Records: 220 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FRantenna_number SELECT antenna_number, count(Record_Type) FROM PUBACC_FR GROUP BY antenna_number -------------- Query OK, 27 rows affected (2 min 36.93 sec) Records: 27 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FRclass_station_code SELECT class_station_code, count(Record_Type) FROM PUBACC_FR GROUP BY class_station_code -------------- Query OK, 163 rows affected (3 min 11.52 sec) Records: 163 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FRop_altitude_code SELECT op_altitude_code, count(Record_Type) FROM PUBACC_FR GROUP BY op_altitude_code -------------- Query OK, 6 rows affected (2 min 33.02 sec) Records: 6 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FRfrequency_assigned SELECT frequency_assigned, count(Record_Type) FROM PUBACC_FR GROUP BY frequency_assigned -------------- Query OK, 18325 rows affected (4 min 54.04 sec) Records: 18325 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FRfrequency_upper_band SELECT frequency_upper_band, count(Record_Type) FROM PUBACC_FR GROUP BY frequency_upper_band -------------- Query OK, 1077 rows affected (2 min 45.69 sec) Records: 1077 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FRfrequency_carrier SELECT frequency_carrier, count(Record_Type) FROM PUBACC_FR GROUP BY frequency_carrier -------------- Query OK, 1278 rows affected (2 min 43.05 sec) Records: 1278 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FRtime_begin_operations SELECT time_begin_operations, count(Record_Type) FROM PUBACC_FR GROUP BY time_begin_operations -------------- Query OK, 36 rows affected (2 min 34.74 sec) Records: 36 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FRtime_end_operations SELECT time_end_operations, count(Record_Type) FROM PUBACC_FR GROUP BY time_end_operations -------------- Query OK, 48 rows affected (2 min 35.36 sec) Records: 48 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FRpower_output SELECT power_output, count(Record_Type) FROM PUBACC_FR GROUP BY power_output -------------- Query OK, 836 rows affected (3 min 56.99 sec) Records: 836 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FRpower_erp SELECT power_erp, count(Record_Type) FROM PUBACC_FR GROUP BY power_erp -------------- Query OK, 6594 rows affected (4 min 49.49 sec) Records: 6594 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FRtolerance SELECT tolerance, count(Record_Type) FROM PUBACC_FR GROUP BY tolerance -------------- Query OK, 4 rows affected (2 min 34.34 sec) Records: 4 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FRfrequency_ind SELECT frequency_ind, count(Record_Type) FROM PUBACC_FR GROUP BY frequency_ind -------------- Query OK, 1 row affected (2 min 33.09 sec) Records: 1 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FRstatus SELECT status, count(Record_Type) FROM PUBACC_FR GROUP BY status -------------- Query OK, 1 row affected (2 min 33.38 sec) Records: 1 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FReirp SELECT eirp, count(Record_Type) FROM PUBACC_FR GROUP BY eirp -------------- Query OK, 81 rows affected (2 min 34.03 sec) Records: 81 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FRtransmitter_make SELECT transmitter_make, count(Record_Type) FROM PUBACC_FR GROUP BY transmitter_make -------------- Query OK, 2 rows affected (2 min 34.92 sec) Records: 2 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FRtransmitter_model SELECT transmitter_model, count(Record_Type) FROM PUBACC_FR GROUP BY transmitter_model -------------- Query OK, 2 rows affected (2 min 34.61 sec) Records: 2 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FRauto_transmitter_power_control SELECT auto_transmitter_power_control, count(Record_Type) FROM PUBACC_FR GROUP BY auto_transmitter_power_control -------------- Query OK, 2 rows affected (2 min 33.18 sec) Records: 2 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FRcnt_mobile_units SELECT cnt_mobile_units, count(Record_Type) FROM PUBACC_FR GROUP BY cnt_mobile_units -------------- Query OK, 2201 rows affected (3 min 12.14 sec) Records: 2201 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FRcnt_mob_pagers SELECT cnt_mob_pagers, count(Record_Type) FROM PUBACC_FR GROUP BY cnt_mob_pagers -------------- Query OK, 436 rows affected (2 min 44.87 sec) Records: 436 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FRfreq_seq_id SELECT freq_seq_id, count(Record_Type) FROM PUBACC_FR GROUP BY freq_seq_id -------------- Query OK, 15242 rows affected (4 min 33.12 sec) Records: 15242 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FSrecord_type SELECT record_type, count(Record_Type) FROM PUBACC_FS GROUP BY record_type -------------- Query OK, 0 rows affected (0.06 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FSunique_system_identifier SELECT unique_system_identifier, count(Record_Type) FROM PUBACC_FS GROUP BY unique_system_identifier -------------- Query OK, 0 rows affected (0.04 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FScall_sign SELECT call_sign, count(Record_Type) FROM PUBACC_FS GROUP BY call_sign -------------- Query OK, 0 rows affected (0.01 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FSlocation_number SELECT location_number, count(Record_Type) FROM PUBACC_FS GROUP BY location_number -------------- Query OK, 0 rows affected (0.10 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FSantenna_number SELECT antenna_number, count(Record_Type) FROM PUBACC_FS GROUP BY antenna_number -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FSfrequency SELECT frequency, count(Record_Type) FROM PUBACC_FS GROUP BY frequency -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FSfrequency_number SELECT frequency_number, count(Record_Type) FROM PUBACC_FS GROUP BY frequency_number -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FSspecial_condition_type SELECT special_condition_type, count(Record_Type) FROM PUBACC_FS GROUP BY special_condition_type -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FSspecial_condition_code SELECT special_condition_code, count(Record_Type) FROM PUBACC_FS GROUP BY special_condition_code -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FTrecord_type SELECT record_type, count(Record_Type) FROM PUBACC_FT GROUP BY record_type -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FTunique_system_identifier SELECT unique_system_identifier, count(Record_Type) FROM PUBACC_FT GROUP BY unique_system_identifier -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FTuls_file_number SELECT uls_file_number, count(Record_Type) FROM PUBACC_FT GROUP BY uls_file_number -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FTebf_number SELECT ebf_number, count(Record_Type) FROM PUBACC_FT GROUP BY ebf_number -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FTcall_sign SELECT call_sign, count(Record_Type) FROM PUBACC_FT GROUP BY call_sign -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FTfreq_type_action_performed SELECT freq_type_action_performed, count(Record_Type) FROM PUBACC_FT GROUP BY freq_type_action_performed -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FTlocation_number SELECT location_number, count(Record_Type) FROM PUBACC_FT GROUP BY location_number -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FTantenna_number SELECT antenna_number, count(Record_Type) FROM PUBACC_FT GROUP BY antenna_number -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FTfrequency_assigned SELECT frequency_assigned, count(Record_Type) FROM PUBACC_FT GROUP BY frequency_assigned -------------- Query OK, 0 rows affected (0.04 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FTfrequency_type_number SELECT frequency_type_number, count(Record_Type) FROM PUBACC_FT GROUP BY frequency_type_number -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_FTfrequency_type_code SELECT frequency_type_code, count(Record_Type) FROM PUBACC_FT GROUP BY frequency_type_code -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDrecord_type SELECT record_type, count(Record_Type) FROM PUBACC_HD GROUP BY record_type -------------- Query OK, 1 row affected (12.48 sec) Records: 1 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDunique_system_identifier SELECT unique_system_identifier, count(Record_Type) FROM PUBACC_HD GROUP BY unique_system_identifier -------------- Query OK, 684357 rows affected (1 min 11.43 sec) Records: 684357 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDuls_file_number SELECT uls_file_number, count(Record_Type) FROM PUBACC_HD GROUP BY uls_file_number -------------- Query OK, 237334 rows affected (28.35 sec) Records: 237334 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDebf_number SELECT ebf_number, count(Record_Type) FROM PUBACC_HD GROUP BY ebf_number -------------- Query OK, 1 row affected (11.17 sec) Records: 1 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDcall_sign SELECT call_sign, count(Record_Type) FROM PUBACC_HD GROUP BY call_sign -------------- Query OK, 684354 rows affected (1 min 5.91 sec) Records: 684354 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDlicense_status SELECT license_status, count(Record_Type) FROM PUBACC_HD GROUP BY license_status -------------- Query OK, 5 rows affected (11.18 sec) Records: 5 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDradio_service_code SELECT radio_service_code, count(Record_Type) FROM PUBACC_HD GROUP BY radio_service_code -------------- Query OK, 44 rows affected (12.07 sec) Records: 44 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDgrant_date SELECT grant_date, count(Record_Type) FROM PUBACC_HD GROUP BY grant_date -------------- Query OK, 6686 rows affected (24.30 sec) Records: 6686 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDexpired_date SELECT expired_date, count(Record_Type) FROM PUBACC_HD GROUP BY expired_date -------------- Query OK, 6057 rows affected (25.26 sec) Records: 6057 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDcancellation_date SELECT cancellation_date, count(Record_Type) FROM PUBACC_HD GROUP BY cancellation_date -------------- Query OK, 1572 rows affected (14.80 sec) Records: 1572 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDeligibility_rule_num SELECT eligibility_rule_num, count(Record_Type) FROM PUBACC_HD GROUP BY eligibility_rule_num -------------- Query OK, 1766 rows affected (17.20 sec) Records: 1766 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDapplicant_type_code SELECT applicant_type_code, count(Record_Type) FROM PUBACC_HD GROUP BY applicant_type_code -------------- Query OK, 10 rows affected (11.03 sec) Records: 10 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDalien SELECT alien, count(Record_Type) FROM PUBACC_HD GROUP BY alien -------------- Query OK, 3 rows affected (10.83 sec) Records: 3 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDalien_government SELECT alien_government, count(Record_Type) FROM PUBACC_HD GROUP BY alien_government -------------- Query OK, 4 rows affected (10.85 sec) Records: 4 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDalien_corporation SELECT alien_corporation, count(Record_Type) FROM PUBACC_HD GROUP BY alien_corporation -------------- Query OK, 3 rows affected (10.85 sec) Records: 3 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDalien_officer SELECT alien_officer, count(Record_Type) FROM PUBACC_HD GROUP BY alien_officer -------------- Query OK, 3 rows affected (10.84 sec) Records: 3 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDalien_control SELECT alien_control, count(Record_Type) FROM PUBACC_HD GROUP BY alien_control -------------- Query OK, 3 rows affected (10.84 sec) Records: 3 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDrevoked SELECT revoked, count(Record_Type) FROM PUBACC_HD GROUP BY revoked -------------- Query OK, 3 rows affected (10.85 sec) Records: 3 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDconvicted SELECT convicted, count(Record_Type) FROM PUBACC_HD GROUP BY convicted -------------- Query OK, 3 rows affected (10.87 sec) Records: 3 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDadjudged SELECT adjudged, count(Record_Type) FROM PUBACC_HD GROUP BY adjudged -------------- Query OK, 3 rows affected (10.81 sec) Records: 3 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDinvolved SELECT involved, count(Record_Type) FROM PUBACC_HD GROUP BY involved -------------- Query OK, 3 rows affected (10.86 sec) Records: 3 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDcommon_carrier SELECT common_carrier, count(Record_Type) FROM PUBACC_HD GROUP BY common_carrier -------------- Query OK, 3 rows affected (10.78 sec) Records: 3 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDnon_common_carrier SELECT non_common_carrier, count(Record_Type) FROM PUBACC_HD GROUP BY non_common_carrier -------------- Query OK, 3 rows affected (10.76 sec) Records: 3 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDprivate_comm SELECT private_comm, count(Record_Type) FROM PUBACC_HD GROUP BY private_comm -------------- Query OK, 4 rows affected (10.90 sec) Records: 4 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDfixed SELECT fixed, count(Record_Type) FROM PUBACC_HD GROUP BY fixed -------------- Query OK, 3 rows affected (10.91 sec) Records: 3 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDmobile SELECT mobile, count(Record_Type) FROM PUBACC_HD GROUP BY mobile -------------- Query OK, 4 rows affected (11.08 sec) Records: 4 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDradiolocation SELECT radiolocation, count(Record_Type) FROM PUBACC_HD GROUP BY radiolocation -------------- Query OK, 3 rows affected (10.82 sec) Records: 3 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDsatellite SELECT satellite, count(Record_Type) FROM PUBACC_HD GROUP BY satellite -------------- Query OK, 3 rows affected (10.76 sec) Records: 3 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDdevelopmental_or_sta SELECT developmental_or_sta, count(Record_Type) FROM PUBACC_HD GROUP BY developmental_or_sta -------------- Query OK, 6 rows affected (11.16 sec) Records: 6 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDinterconnected_service SELECT interconnected_service, count(Record_Type) FROM PUBACC_HD GROUP BY interconnected_service -------------- Query OK, 4 rows affected (10.93 sec) Records: 4 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDcertifier_first_name SELECT certifier_first_name, count(Record_Type) FROM PUBACC_HD GROUP BY certifier_first_name -------------- Query OK, 8431 rows affected (17.72 sec) Records: 8431 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDcertifier_mi SELECT certifier_mi, count(Record_Type) FROM PUBACC_HD GROUP BY certifier_mi -------------- Query OK, 31 rows affected (11.11 sec) Records: 31 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDcertifier_last_name SELECT certifier_last_name, count(Record_Type) FROM PUBACC_HD GROUP BY certifier_last_name -------------- Query OK, 60543 rows affected (19.94 sec) Records: 60543 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDcertifier_suffix SELECT certifier_suffix, count(Record_Type) FROM PUBACC_HD GROUP BY certifier_suffix -------------- Query OK, 96 rows affected (10.88 sec) Records: 96 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDcertifier_title SELECT certifier_title, count(Record_Type) FROM PUBACC_HD GROUP BY certifier_title -------------- Query OK, 13717 rows affected (14.10 sec) Records: 13717 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDgender SELECT gender, count(Record_Type) FROM PUBACC_HD GROUP BY gender -------------- Query OK, 3 rows affected (10.72 sec) Records: 3 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDafrican_american SELECT african_american, count(Record_Type) FROM PUBACC_HD GROUP BY african_american -------------- Query OK, 3 rows affected (10.73 sec) Records: 3 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDnative_american SELECT native_american, count(Record_Type) FROM PUBACC_HD GROUP BY native_american -------------- Query OK, 3 rows affected (10.68 sec) Records: 3 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDhawaiian SELECT hawaiian, count(Record_Type) FROM PUBACC_HD GROUP BY hawaiian -------------- Query OK, 3 rows affected (10.72 sec) Records: 3 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDasian SELECT asian, count(Record_Type) FROM PUBACC_HD GROUP BY asian -------------- Query OK, 3 rows affected (10.69 sec) Records: 3 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDwhite SELECT white, count(Record_Type) FROM PUBACC_HD GROUP BY white -------------- Query OK, 3 rows affected (10.69 sec) Records: 3 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDethnicity SELECT ethnicity, count(Record_Type) FROM PUBACC_HD GROUP BY ethnicity -------------- Query OK, 4 rows affected (10.71 sec) Records: 4 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDeffective_date SELECT effective_date, count(Record_Type) FROM PUBACC_HD GROUP BY effective_date -------------- Query OK, 5962 rows affected (23.47 sec) Records: 5962 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDlast_action_date SELECT last_action_date, count(Record_Type) FROM PUBACC_HD GROUP BY last_action_date -------------- Query OK, 1671 rows affected (21.26 sec) Records: 1671 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDauction_id SELECT auction_id, count(Record_Type) FROM PUBACC_HD GROUP BY auction_id -------------- Query OK, 1 row affected (10.77 sec) Records: 1 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDreg_stat_broad_serv SELECT reg_stat_broad_serv, count(Record_Type) FROM PUBACC_HD GROUP BY reg_stat_broad_serv -------------- Query OK, 3 rows affected (10.75 sec) Records: 3 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDband_manager SELECT band_manager, count(Record_Type) FROM PUBACC_HD GROUP BY band_manager -------------- Query OK, 4 rows affected (10.86 sec) Records: 4 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HDtype_serv_broad_serv SELECT type_serv_broad_serv, count(Record_Type) FROM PUBACC_HD GROUP BY type_serv_broad_serv -------------- Query OK, 4 rows affected (10.87 sec) Records: 4 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HSrecord_type SELECT record_type, count(Record_Type) FROM PUBACC_HS GROUP BY record_type -------------- Query OK, 0 rows affected (0.05 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HSunique_system_identifier SELECT unique_system_identifier, count(Record_Type) FROM PUBACC_HS GROUP BY unique_system_identifier -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HSuls_file_number SELECT uls_file_number, count(Record_Type) FROM PUBACC_HS GROUP BY uls_file_number -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HScallsign SELECT callsign, count(Record_Type) FROM PUBACC_HS GROUP BY callsign -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HSdate SELECT date, count(Record_Type) FROM PUBACC_HS GROUP BY date -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_HScode SELECT code, count(Record_Type) FROM PUBACC_HS GROUP BY code -------------- Query OK, 0 rows affected (0.01 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_IArecord_type SELECT record_type, count(Record_Type) FROM PUBACC_IA GROUP BY record_type -------------- Query OK, 0 rows affected (0.05 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_IAunique_system_identifier SELECT unique_system_identifier, count(Record_Type) FROM PUBACC_IA GROUP BY unique_system_identifier -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_IAuls_file_number SELECT uls_file_number, count(Record_Type) FROM PUBACC_IA GROUP BY uls_file_number -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_IAebf_number SELECT ebf_number, count(Record_Type) FROM PUBACC_IA GROUP BY ebf_number -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_IAcall_sign SELECT call_sign, count(Record_Type) FROM PUBACC_IA GROUP BY call_sign -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_IAinternational_address_1 SELECT international_address_1, count(Record_Type) FROM PUBACC_IA GROUP BY international_address_1 -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_IAinternational_address_2 SELECT international_address_2, count(Record_Type) FROM PUBACC_IA GROUP BY international_address_2 -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_IAinternational_city SELECT international_city, count(Record_Type) FROM PUBACC_IA GROUP BY international_city -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_IAcountry SELECT country, count(Record_Type) FROM PUBACC_IA GROUP BY country -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_IAinternational_zip_code SELECT international_zip_code, count(Record_Type) FROM PUBACC_IA GROUP BY international_zip_code -------------- Query OK, 0 rows affected (0.04 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_IAinternational_phone SELECT international_phone, count(Record_Type) FROM PUBACC_IA GROUP BY international_phone -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_IAinternational_fax SELECT international_fax, count(Record_Type) FROM PUBACC_IA GROUP BY international_fax -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_IRrecord_type SELECT record_type, count(Record_Type) FROM PUBACC_IR GROUP BY record_type -------------- Query OK, 0 rows affected (0.05 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_IRunique_system_identifier SELECT unique_system_identifier, count(Record_Type) FROM PUBACC_IR GROUP BY unique_system_identifier -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_IRuls_file_number SELECT uls_file_number, count(Record_Type) FROM PUBACC_IR GROUP BY uls_file_number -------------- Query OK, 0 rows affected (0.04 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_IRcall_sign SELECT call_sign, count(Record_Type) FROM PUBACC_IR GROUP BY call_sign -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_IRlocation_number SELECT location_number, count(Record_Type) FROM PUBACC_IR GROUP BY location_number -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_IRantenna_number SELECT antenna_number, count(Record_Type) FROM PUBACC_IR GROUP BY antenna_number -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_IRfrequency_assigned SELECT frequency_assigned, count(Record_Type) FROM PUBACC_IR GROUP BY frequency_assigned -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_IRirac_result SELECT irac_result, count(Record_Type) FROM PUBACC_IR GROUP BY irac_result -------------- Query OK, 0 rows affected (0.04 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_L2record_type SELECT record_type, count(Record_Type) FROM PUBACC_L2 GROUP BY record_type -------------- Query OK, 0 rows affected (0.04 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_L2unique_system_identifier SELECT unique_system_identifier, count(Record_Type) FROM PUBACC_L2 GROUP BY unique_system_identifier -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_L2uls_file_number SELECT uls_file_number, count(Record_Type) FROM PUBACC_L2 GROUP BY uls_file_number -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_L2ebf_number SELECT ebf_number, count(Record_Type) FROM PUBACC_L2 GROUP BY ebf_number -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_L2call_sign SELECT call_sign, count(Record_Type) FROM PUBACC_L2 GROUP BY call_sign -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_L2location_action_performed SELECT location_action_performed, count(Record_Type) FROM PUBACC_L2 GROUP BY location_action_performed -------------- Query OK, 0 rows affected (0.04 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_L2location_number SELECT location_number, count(Record_Type) FROM PUBACC_L2 GROUP BY location_number -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_L2registration_required SELECT registration_required, count(Record_Type) FROM PUBACC_L2 GROUP BY registration_required -------------- Query OK, 0 rows affected (0.06 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_L2protection_date SELECT protection_date, count(Record_Type) FROM PUBACC_L2 GROUP BY protection_date -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LArecord_type SELECT record_type, count(Record_Type) FROM PUBACC_LA GROUP BY record_type -------------- Query OK, 0 rows affected (0.05 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LAunique_system_identifier SELECT unique_system_identifier, count(Record_Type) FROM PUBACC_LA GROUP BY unique_system_identifier -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LAcallsign SELECT callsign, count(Record_Type) FROM PUBACC_LA GROUP BY callsign -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LAattachment_code SELECT attachment_code, count(Record_Type) FROM PUBACC_LA GROUP BY attachment_code -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LAattachment_desc SELECT attachment_desc, count(Record_Type) FROM PUBACC_LA GROUP BY attachment_desc -------------- Query OK, 0 rows affected (0.04 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LAattachment_date SELECT attachment_date, count(Record_Type) FROM PUBACC_LA GROUP BY attachment_date -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LAattachment_filename SELECT attachment_filename, count(Record_Type) FROM PUBACC_LA GROUP BY attachment_filename -------------- Query OK, 0 rows affected (0.06 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LAaction_performed SELECT action_performed, count(Record_Type) FROM PUBACC_LA GROUP BY action_performed -------------- Query OK, 0 rows affected (0.04 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LFrecord_type SELECT record_type, count(Record_Type) FROM PUBACC_LF GROUP BY record_type -------------- Query OK, 0 rows affected (0.06 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LFunique_system_identifier SELECT unique_system_identifier, count(Record_Type) FROM PUBACC_LF GROUP BY unique_system_identifier -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LFcallsign SELECT callsign, count(Record_Type) FROM PUBACC_LF GROUP BY callsign -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LFlocation_number SELECT location_number, count(Record_Type) FROM PUBACC_LF GROUP BY location_number -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LFloc_freeform_cond_type SELECT loc_freeform_cond_type, count(Record_Type) FROM PUBACC_LF GROUP BY loc_freeform_cond_type -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LFunique_loc_freeform_id SELECT unique_loc_freeform_id, count(Record_Type) FROM PUBACC_LF GROUP BY unique_loc_freeform_id -------------- Query OK, 0 rows affected (0.04 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LFsequence_number SELECT sequence_number, count(Record_Type) FROM PUBACC_LF GROUP BY sequence_number -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LFloc_freeform_condition SELECT loc_freeform_condition, count(Record_Type) FROM PUBACC_LF GROUP BY loc_freeform_condition -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LMrecord_type SELECT record_type, count(Record_Type) FROM PUBACC_LM GROUP BY record_type -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LMunique_system_identifier SELECT unique_system_identifier, count(Record_Type) FROM PUBACC_LM GROUP BY unique_system_identifier -------------- Query OK, 0 rows affected (0.04 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LMuls_file_number SELECT uls_file_number, count(Record_Type) FROM PUBACC_LM GROUP BY uls_file_number -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LMebf_number SELECT ebf_number, count(Record_Type) FROM PUBACC_LM GROUP BY ebf_number -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LMcallsign SELECT callsign, count(Record_Type) FROM PUBACC_LM GROUP BY callsign -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LMext_implement_appr SELECT ext_implement_appr, count(Record_Type) FROM PUBACC_LM GROUP BY ext_implement_appr -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LMlm_eligibility_activity SELECT lm_eligibility_activity, count(Record_Type) FROM PUBACC_LM GROUP BY lm_eligibility_activity -------------- Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOrecord_type SELECT record_type, count(Record_Type) FROM PUBACC_LO GROUP BY record_type -------------- Query OK, 1 row affected (27.19 sec) Records: 1 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOunique_system_identifier SELECT unique_system_identifier, count(Record_Type) FROM PUBACC_LO GROUP BY unique_system_identifier -------------- Query OK, 684104 rows affected (1 min 55.44 sec) Records: 684104 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOuls_file_number SELECT uls_file_number, count(Record_Type) FROM PUBACC_LO GROUP BY uls_file_number -------------- Query OK, 1 row affected (23.87 sec) Records: 1 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOebf_number SELECT ebf_number, count(Record_Type) FROM PUBACC_LO GROUP BY ebf_number -------------- Query OK, 1 row affected (23.86 sec) Records: 1 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOcall_sign SELECT call_sign, count(Record_Type) FROM PUBACC_LO GROUP BY call_sign -------------- Query OK, 684101 rows affected (1 min 46.42 sec) Records: 684101 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOlocation_action_performed SELECT location_action_performed, count(Record_Type) FROM PUBACC_LO GROUP BY location_action_performed -------------- Query OK, 1 row affected (23.67 sec) Records: 1 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOlocation_type_code SELECT location_type_code, count(Record_Type) FROM PUBACC_LO GROUP BY location_type_code -------------- Query OK, 7 rows affected (24.65 sec) Records: 7 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOlocation_class_code SELECT location_class_code, count(Record_Type) FROM PUBACC_LO GROUP BY location_class_code -------------- Query OK, 3 rows affected (23.78 sec) Records: 3 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOlocation_number SELECT location_number, count(Record_Type) FROM PUBACC_LO GROUP BY location_number -------------- Query OK, 220 rows affected (25.57 sec) Records: 220 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOsite_status SELECT site_status, count(Record_Type) FROM PUBACC_LO GROUP BY site_status -------------- Query OK, 15 rows affected (23.73 sec) Records: 15 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOcorresponding_fixed_location SELECT corresponding_fixed_location, count(Record_Type) FROM PUBACC_LO GROUP BY corresponding_fixed_location -------------- Query OK, 91 rows affected (23.67 sec) Records: 91 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOlocation_address SELECT location_address, count(Record_Type) FROM PUBACC_LO GROUP BY location_address -------------- Query OK, 518190 rows affected (3 min 10.66 sec) Records: 518190 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOlocation_city SELECT location_city, count(Record_Type) FROM PUBACC_LO GROUP BY location_city -------------- Query OK, 36655 rows affected (43.67 sec) Records: 36655 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOlocation_county SELECT location_county, count(Record_Type) FROM PUBACC_LO GROUP BY location_county -------------- Query OK, 1906 rows affected (37.44 sec) Records: 1906 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOlocation_state SELECT location_state, count(Record_Type) FROM PUBACC_LO GROUP BY location_state -------------- Query OK, 67 rows affected (29.99 sec) Records: 67 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOradius_of_operation SELECT radius_of_operation, count(Record_Type) FROM PUBACC_LO GROUP BY radius_of_operation -------------- Query OK, 506 rows affected (29.82 sec) Records: 506 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOarea_of_operation_code SELECT area_of_operation_code, count(Record_Type) FROM PUBACC_LO GROUP BY area_of_operation_code -------------- Query OK, 10 rows affected (24.09 sec) Records: 10 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOclearance_indicator SELECT clearance_indicator, count(Record_Type) FROM PUBACC_LO GROUP BY clearance_indicator -------------- Query OK, 4 rows affected (23.47 sec) Records: 4 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOground_elevation SELECT ground_elevation, count(Record_Type) FROM PUBACC_LO GROUP BY ground_elevation -------------- Query OK, 11711 rows affected (39.22 sec) Records: 11711 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOlat_degrees SELECT lat_degrees, count(Record_Type) FROM PUBACC_LO GROUP BY lat_degrees -------------- Query OK, 69 rows affected (28.38 sec) Records: 69 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOlat_minutes SELECT lat_minutes, count(Record_Type) FROM PUBACC_LO GROUP BY lat_minutes -------------- Query OK, 62 rows affected (28.91 sec) Records: 62 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOlat_seconds SELECT lat_seconds, count(Record_Type) FROM PUBACC_LO GROUP BY lat_seconds -------------- Query OK, 604 rows affected (39.35 sec) Records: 604 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOlat_direction SELECT lat_direction, count(Record_Type) FROM PUBACC_LO GROUP BY lat_direction -------------- Query OK, 12 rows affected (24.59 sec) Records: 12 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOlong_degrees SELECT long_degrees, count(Record_Type) FROM PUBACC_LO GROUP BY long_degrees -------------- Query OK, 115 rows affected (29.00 sec) Records: 115 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOlong_minutes SELECT long_minutes, count(Record_Type) FROM PUBACC_LO GROUP BY long_minutes -------------- Query OK, 64 rows affected (28.77 sec) Records: 64 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOlong_seconds SELECT long_seconds, count(Record_Type) FROM PUBACC_LO GROUP BY long_seconds -------------- Query OK, 604 rows affected (39.70 sec) Records: 604 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOlong_direction SELECT long_direction, count(Record_Type) FROM PUBACC_LO GROUP BY long_direction -------------- Query OK, 9 rows affected (24.22 sec) Records: 9 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOmax_lat_degrees SELECT max_lat_degrees, count(Record_Type) FROM PUBACC_LO GROUP BY max_lat_degrees -------------- Query OK, 18 rows affected (23.47 sec) Records: 18 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOmax_lat_minutes SELECT max_lat_minutes, count(Record_Type) FROM PUBACC_LO GROUP BY max_lat_minutes -------------- Query OK, 24 rows affected (23.49 sec) Records: 24 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOmax_lat_seconds SELECT max_lat_seconds, count(Record_Type) FROM PUBACC_LO GROUP BY max_lat_seconds -------------- Query OK, 24 rows affected (23.39 sec) Records: 24 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOmax_lat_direction SELECT max_lat_direction, count(Record_Type) FROM PUBACC_LO GROUP BY max_lat_direction -------------- Query OK, 3 rows affected (23.31 sec) Records: 3 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOmax_long_degrees SELECT max_long_degrees, count(Record_Type) FROM PUBACC_LO GROUP BY max_long_degrees -------------- Query OK, 29 rows affected (23.52 sec) Records: 29 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOmax_long_minutes SELECT max_long_minutes, count(Record_Type) FROM PUBACC_LO GROUP BY max_long_minutes -------------- Query OK, 24 rows affected (23.47 sec) Records: 24 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOmax_long_seconds SELECT max_long_seconds, count(Record_Type) FROM PUBACC_LO GROUP BY max_long_seconds -------------- Query OK, 24 rows affected (23.26 sec) Records: 24 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOmax_long_direction SELECT max_long_direction, count(Record_Type) FROM PUBACC_LO GROUP BY max_long_direction -------------- Query OK, 4 rows affected (23.37 sec) Records: 4 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOnepa SELECT nepa, count(Record_Type) FROM PUBACC_LO GROUP BY nepa -------------- Query OK, 3 rows affected (23.46 sec) Records: 3 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOquiet_zone_notification_date SELECT quiet_zone_notification_date, count(Record_Type) FROM PUBACC_LO GROUP BY quiet_zone_notification_date -------------- Query OK, 385 rows affected (24.16 sec) Records: 385 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOtower_registration_number SELECT tower_registration_number, count(Record_Type) FROM PUBACC_LO GROUP BY tower_registration_number -------------- Query OK, 26523 rows affected (35.01 sec) Records: 26523 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOheight_of_support_structure SELECT height_of_support_structure, count(Record_Type) FROM PUBACC_LO GROUP BY height_of_support_structure -------------- Query OK, 2335 rows affected (32.00 sec) Records: 2335 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOoverall_height_of_structure SELECT overall_height_of_structure, count(Record_Type) FROM PUBACC_LO GROUP BY overall_height_of_structure -------------- Query OK, 2406 rows affected (31.80 sec) Records: 2406 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOstructure_type SELECT structure_type, count(Record_Type) FROM PUBACC_LO GROUP BY structure_type -------------- Query OK, 23 rows affected (24.65 sec) Records: 23 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOairport_id SELECT airport_id, count(Record_Type) FROM PUBACC_LO GROUP BY airport_id -------------- Query OK, 1331 rows affected (23.86 sec) Records: 1331 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOlocation_name SELECT location_name, count(Record_Type) FROM PUBACC_LO GROUP BY location_name -------------- Query OK, 19275 rows affected (27.88 sec) Records: 19275 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOunits_hand_held SELECT units_hand_held, count(Record_Type) FROM PUBACC_LO GROUP BY units_hand_held -------------- Query OK, 53 rows affected (23.43 sec) Records: 53 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOunits_mobile SELECT units_mobile, count(Record_Type) FROM PUBACC_LO GROUP BY units_mobile -------------- Query OK, 90 rows affected (23.48 sec) Records: 90 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOunits_temp_fixed SELECT units_temp_fixed, count(Record_Type) FROM PUBACC_LO GROUP BY units_temp_fixed -------------- Query OK, 20 rows affected (23.46 sec) Records: 20 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOunits_aircraft SELECT units_aircraft, count(Record_Type) FROM PUBACC_LO GROUP BY units_aircraft -------------- Query OK, 19 rows affected (23.45 sec) Records: 19 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LOunits_itinerant SELECT units_itinerant, count(Record_Type) FROM PUBACC_LO GROUP BY units_itinerant -------------- Query OK, 14 rows affected (23.67 sec) Records: 14 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LSrecord_type SELECT record_type, count(Record_Type) FROM PUBACC_LS GROUP BY record_type -------------- Query OK, 0 rows affected (0.07 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LSunique_system_identifier SELECT unique_system_identifier, count(Record_Type) FROM PUBACC_LS GROUP BY unique_system_identifier -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LScall_sign SELECT call_sign, count(Record_Type) FROM PUBACC_LS GROUP BY call_sign -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LSlocation_number SELECT location_number, count(Record_Type) FROM PUBACC_LS GROUP BY location_number -------------- Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 -------------- CREATE TABLE tblPUBACC_LSspecia