Potato Cyst Nematode Survey - Ware Exports 2014
Animal and Plant Health Agency
@ukgov.potato_cyst_nematode_survey_ware_exports_2014
Animal and Plant Health Agency
@ukgov.potato_cyst_nematode_survey_ware_exports_2014
This dataset provides information on Potato Cyst Nematode (PCN) sampling for Ware Exports during 2014. Ware potatoes are those sold for consumption. The dataset is broken down by region, and includes the fields: Region, Visit date, Job code, Job description, Quantity area (Hectares), Cysts non viable, Fields non viable cysts, Area non viable cysts, Cysts viable globodera pallida, Cysts viable globodera rostochiensis, Pallida infested, Quantity area (Hectares) pallida infested, Rostochiensis infected, Quantity area (Hectares) rostochiensis infected, Combined pallida rostochiensis infected, Quantity area (Hectares) combined pallida rostochiensis infected. Attribution statement: ©Crown Copyright, APHA 2016
Publisher name: Animal and Plant Health Agency
Last updated: 2023-11-03T00:23:52Z
CREATE TABLE potato_cyst_nematode_survey_ware_exports_2014 (
"region" VARCHAR,
"visit_date" TIMESTAMP,
"job_code" VARCHAR,
"job_desc" VARCHAR,
"quantity_area_ha" DOUBLE -- Quantity Area (Ha.),
"cysts_non_viable" DOUBLE,
"fields_non_viable_cysts" DOUBLE,
"area_non_viable_cysts" DOUBLE,
"cysts_viable_globodera_pallida" DOUBLE,
"cysts_viable_globoderarostochiensis" DOUBLE,
"pallida_infested" DOUBLE,
"quantity_area_ha_pallida_infested" DOUBLE -- Quantity Area (Ha.) Pallida Infested,
"rostochiensis_infested" DOUBLE,
"quantity_area_ha_rostochiensis_infested" DOUBLE -- Quantity Area (Ha.) Rostochiensis Infested,
"combined_pallida_rostochiensis_infested" DOUBLE -- Combined Pallida & Rostochiensis Infested,
"quantity_area_ha_combined_pallida_rostochiensis_infested" DOUBLE -- Quantity Area (Ha.) Combined Pallida & Rostochiensis Infested
);Anyone who has the link will be able to view this.