Summary Of Inspection Statistics - Controlled Plant Goods By Point Of Entry 2012
Animal and Plant Health Agency
@ukgov.summary_of_inspection_statistics_controlled_plant_good_4495e2e0
Animal and Plant Health Agency
@ukgov.summary_of_inspection_statistics_controlled_plant_good_4495e2e0
This dataset provides a summary of the Import Inspection Statistics for Controlled Plant Goods by Point of Entry (POE) 2012. Controlled goods are those which are subject to formal plant health controls when imported, including the provision of a phytosanitary certificate. 'Phytosanitary Certificates' are produced by APHA (or an overseas equivalent agency) to certify that a plant commodity is healthy prior to export. This dataset includes the fields: Type of Inspection (Mandatory - 100% inspection rate for high risk material; Controlled - where the commodity is subject to regulated inspections; Reduced - low-risk import goods for which inspections are permitted at a less than 100% rate), Import Inspection Location Name, Botanical Name, Number of consignments, Plant Health Movement Document (PHMD) supplied?, Consignment corrected total for PHMD, Inspection count, Inspected %, Document check count, Doc %, ID check count, ID check %, Failed physical, Failed physical %, Failed doc, Failed doc %, Failed ID, Failed ID %, Total failed, Total failed %. 'PHMD' are required where goods have cleared customs in one EU country and are moving through into a different EU country. Percentage figures shown are for the reporting period indicated, and deonte the percentage of checks done on a named commodity for the reporting period. Attribution statement: ©Crown Copyright, APHA 2016
Publisher name: Animal and Plant Health Agency
Last updated: 2023-11-03T01:49:22Z
CREATE TABLE summary_of_inspection_statistics_controlled_plant_good_4495e2e0 (
"unnamed_0" VARCHAR -- Unnamed: 0,
"summary_of_national_import_inspection_statistics_for_c_ba652090" VARCHAR -- Summary Of National Import Inspection Statistics For Controlled Goods By Point Of Entry From 01/01/2012 To 31/12/2012,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8,
"unnamed_9" VARCHAR -- Unnamed: 9,
"unnamed_10" VARCHAR -- Unnamed: 10,
"unnamed_11" VARCHAR -- Unnamed: 11,
"unnamed_12" VARCHAR -- Unnamed: 12,
"unnamed_13" VARCHAR -- Unnamed: 13,
"unnamed_14" VARCHAR -- Unnamed: 14,
"unnamed_15" VARCHAR -- Unnamed: 15,
"unnamed_16" VARCHAR -- Unnamed: 16,
"unnamed_17" VARCHAR -- Unnamed: 17,
"unnamed_18" VARCHAR -- Unnamed: 18
);Anyone who has the link will be able to view this.