DOI: 10.5281/zenodo.12564103
title: Deidentified Cut Flowers Import Testing Results

description: 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