Deidentified Cut Flowers Import Testing Results
Authors/Creators
-
1.
Australian National University
- 2. Maastricht University
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 |