Deidentified Cut Flowers Import Testing Results

These three datasets contain de-identified data on testing for pests in imports of cut flowers 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 and 25/6/2024).

Dataset anonymized_data_cf_aggdat.csv

The first dataset (anonymized_data_cf_aggdat.csv) has one row for each line of cut flowers tested. Consignments of cut flowers are divided into lines. A total of 600 flowers are sampled from each consignment, with the number of flowers sampled from each line proportional to the volume for the line (column "volume"). 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

stats_num

volume
numeric
volume of the line

volume_unit

UN – Number of units (a unit may be a box, a carton, the overall consignment, etc.)

NO – No units indicated (usually refers to the number of stems in cut flowers – so 40430 NO means 40430 stems)

BX – Number of boxes

units in which volume is measured

arrival_date
date

creation_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.

fumigated
Not fumigated, Fumigated
Whether line was fumigated

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

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.

entryactionable

whether the entry is determined as actionable

entryIF

entry level result of onshore biosecurity verification inspection

pathway
Flowers, Foliage 
whether the goods are fresh flowers or foliage

rcd_nbr
1, 2, 3 etc
anonymised identifier of line

Dataset anonymized_data_cf_pests.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_data_cf_aggdat.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, blank
type of potential pest

Dataset anonymized_data_cf_seeds_incidents.csv

This dataset contains a row for seeds detections. Note that not all seeds detections require action. It may be linked to anonymized_data_cf_pests.csv using bottle_number as a key and to anonymized_data_cf_aggdat.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, blank
type of potential pest (always equal to seed in this spreadsheet)

comments
text field
comments

other_treatment
Reconditioned, or blank
other treatments applied