About this Dataset

Plant Goods Consignment & Inspection Data By Point Of Entry - 2010

This dataset provides information relating to the import of plant material into points of entry around England during 2010. The dataset includes the fields: Point of Entry, 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 Commodity/Variety, Total weight (of consignment) in kg, Country of origin, Whether the consigment was inspected, Inspection ready date, Inspection ready time, Date and time application submitted, Notification time (day, hr, min), and Weekday. Attribution statement: ©Crown Copyright, APHA 2016
Publisher name: Animal and Plant Health Agency
Last updated: 2023-11-02T23:54:38Z

Tables

Plant Goods Consignment & Inspection Data By Point Of Entry - 2010

@ukgov.plant_goods_consignment_inspection_data_by_point_of_entry_2010.plant_goods_consignment_inspection_by_point_of_entry_2010

890.15 KB
65533 rows
11 columns


CREATE TABLE plant_goods_consignment_inspection_by_point_of_entry_2010 (
  "point_of_entry" VARCHAR,
  "type_of_inspection" VARCHAR,
  "import_commodity_variety" VARCHAR,
  "total_weight" DOUBLE,
  "country_of_origin" VARCHAR,
  "was_it_inspected" VARCHAR,
  "inspection_ready_date" TIMESTAMP,
  "inspection_ready_time" VARCHAR,
  "datetime_application_submitted" VARCHAR,
  "notification_time_day_hr_min" VARCHAR,
  "weekday" VARCHAR
);