Deidentified Horticulture Import Testing Results

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