DOI: 10.5281/zenodo.12615128
title: Deidentified Horticulture Import Testing Results

description: These three datasets contain de-identified data on testing for pests in imports of horticultural products into Australia in a period within 2021-2023. The creator of this data page is distributing the data with the permission of the data owner (emails 14/6/2024, 25/6/2024, 1/7/2024).

Dataset anonymized_hort_aggdat_01-07-2024.csv

This dataset (anonymized_hort_aggdat_01-07-2024.csv) has one row for each line of fruit or vegetables tested. Consignments of fruits or vegetables are divided into lines (details may depend on the type of fruit or vegetable). 600 units are sampled from each line, where a unit is usually a single fruit or vegetable (rounding may occur, for example if fruit are grouped into punnets). A result is then obtained from each line ("inspection result"). If the result is not Pass, then fumigation or other actions may be taken. The columns of the data are:




Variable Name
Values
Definition


entry
ANONYMIZED_VALUE1, ANONYMIZED_VALUE2, etc
anonymised identifier of the consignment


volume
numeric
volume of the line


volume_unit


KG – kilograms0GIblank

units in which volume is measured (almost always kg)


arrival_date
date
 


importer_name
ANONYMIZED_VALUE_1, ANONYMIZED_VALUE2 etc
anonymised identifer of the importer


supplier_name
ANONYMIZED_VALUE_1, ANONYMIZED_VALUE2 etc
anonymised identifer of the supplier


cargo_type
 
the freight type of the consignment (e.g., FCL and FCX are container types via sea and AIR is air freight)


port
character valued code
destination port of the consignment/entry


country
ANONYMIZED_VALUE_1, ANONYMIZED_VALUE2 etc
anonymised country of origin


finalise_type
 
whether the line was released as normal, from biosecurity control, disposed of, destroyed or exported


document_failure
Pass, Fail
whether a failure was recorded against a line at onshore document verification. Note: A fail then followed by a pass and goods moving to inspection, will display fail.


inspection_result
Pass, Fail
whether a failure was recorded against a line at onshore verification inspection. Note: A fail then followed by a pass and goods being released, will display fail. Lines that qualified for the Compliance-Based Intervention Scheme (CBIS) may not have been inspected as a result. See here for more information about CBIS.


fumigated
Not fumigated, Fumigated
Whether line was fumigated


other_treatment
character
other remedial treatment applied to the line/entry (reconditioning for seeds)


cbis_commodity


Fresh CBIS, Other



"Fresh CBIS" means that the line qualified for the Compliance-Based Intervention Scheme (CBIS) and may not have been inspected as a result. "Other" means that the line did not qualify for CBIS. See here for more information about CBIS.



actionable
 
Where the department's Science Services Group have determined that detected biosecurity risk material requires remedial action to mitigate biosecurity risk. Note: Seeds are only actioned if a high risk weed seed is detected or were 3 or more species of biosecurity concern are identified.


commodity
character
Commodity description


rcd_nbr
1, 2, 3 etc
anonymised identifier of line




 

Dataset anonymized_hort_pests_01-07-2024.csv

This dataset contains a row for when there is a pest detection. Note that not all pest detections require action. It may be linked to anonymized_hort_aggdat_01-07-2024.csv using rcd_nbr as a key. The columns of the data are:




Variable Name
Values
Definition


rcd_nbr
1, 2, 3 etc
anonymised identifier of line


bottle_number
numeric
identifier for a particular pest for a particular line


pest_type
Disease, Invertebrate, Plant, Seed, Vertebrate, Na, blank
type of potential pest




 

Dataset anonymized_hort_seeds_incidents_01-07-2024.csv

This dataset contains a row for seeds detections. Note that not all seed detections require action. It may be linked to anonymized_hort_aggdat_01-07-2024.csv by rcd_nbr as a key and to anonymized_hort_pests_01-07-2024.csv using bottle_number as a key. The columns of the data are:




Variable Name
Values
Definition


rcd_nbr
1, 2, 3 etc
anonymised identifier of line


bottle_number
numeric
identifier for a particular pest for a particular line


pest_type
Disease, Invertebrate, Plant, Seed, Vertebrate, Na, blank
type of potential pest (always equal to Seed in this spreadsheet)


comments
text field
comments


other_treatment
Reconditioned, or blank
other treatments applied