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本数据集合集包含2021年至2023年间澳大利亚园艺产品进口害虫检测的去标识化数据。本数据页面的发布者已获得数据所有者的许可后发布本数据集（相关许可邮件日期为2024年6月14日、2024年6月25日、2024年7月1日）。 数据集 anonymized_hort_aggdat_01-07-2024.csv 本数据集（anonymized_hort_aggdat_01-07-2024.csv）的每一行对应一批受检果蔬子批次（注：果蔬货物批次可细分为若干子批次，具体划分规则取决于果蔬品类）。每一个子批次将抽取600个检测单元，检测单元通常为单份果蔬，若果蔬被分装为塑料托盘盒，则可能存在取整情况。每个子批次将生成一条“检测结果”。若检测结果未通过，则需对货物实施熏蒸或其他处置措施。本数据集包含以下字段： 变量名：entry 取值：ANONYMIZED_VALUE1、ANONYMIZED_VALUE2等 定义：货物批次的匿名标识符 变量名：volume 取值：数值型 定义：该子批次的货物总量 变量名：volume_unit 取值：KG（千克）、GI或空值 定义：货物总量的计量单位（绝大多数情况下为千克） 变量名：arrival_date 取值：日期型 定义：货物抵达日期 变量名：importer_name 取值：ANONYMIZED_VALUE1、ANONYMIZED_VALUE2等 定义：进口商的匿名标识符 变量名：supplier_name 取值：ANONYMIZED_VALUE1、ANONYMIZED_VALUE2等 定义：供应商的匿名标识符 变量名：cargo_type 取值：空值或特定值 定义：货物的运输方式（例如：FCL与FCX为海运集装箱类型，AIR为空运） 变量名：port 取值：字符型编码 定义：货物抵达的目的口岸 变量名：country 取值：ANONYMIZED_VALUE1、ANONYMIZED_VALUE2等 定义：货物原产国的匿名标识符 变量名：finalise_type 取值：空值或特定值 定义：该子批次的最终处置状态，包括正常放行、脱离生物安全管控、丢弃、销毁或出口 变量名：document_failure 取值：Pass（通过）、Fail（未通过） 定义：陆上文件审核环节是否存在不合格项。注：若先审核不通过，后续整改后通过审核并进入现场查验，则该字段将显示为Fail；符合合规干预方案（Compliance-Based Intervention Scheme, CBIS）的批次可能无需接受查验。更多关于CBIS的信息可参见此处。 变量名：inspection_result 取值：Pass（通过）、Fail（未通过） 定义：陆上现场查验环节是否存在不合格项。注：若先查验不通过，后续整改后通过审核并放行货物，则该字段将显示为Fail；符合CBIS的批次可能无需接受查验。更多关于CBIS的信息可参见此处。 变量名：fumigated 取值：Not fumigated（未熏蒸）、Fumigated（已熏蒸） 定义：该子批次是否实施了熏蒸处理 变量名：other_treatment 取值：字符型 定义：该子批次/批次所采用的其他补救处理措施（例如种子的复壮处理） 变量名：cbis_commodity 取值：Fresh CBIS、Other 定义：“Fresh CBIS”表示该批次符合CBIS要求，因此可能无需接受查验；“Other”表示该批次不符合CBIS要求。更多关于CBIS的信息可参见此处。 变量名：actionable 取值：空值或特定值 定义：当本部门科学服务组判定检测到的生物安全风险物质需采取补救措施以降低生物安全风险时，该字段生效。注：仅当检测到高风险杂草种子，或识别出3种及以上具有生物安全隐患的物种时，种子类货物才会触发处置要求。 变量名：commodity 取值：字符型 定义：货物品类描述 变量名：rcd_nbr 取值：1、2、3等 定义：该子批次的匿名标识符 数据集 anonymized_hort_pests_01-07-2024.csv 本数据集的每一行对应一次害虫检出事件。需注意，并非所有害虫检出事件均需采取处置措施。本数据集可通过rcd_nbr字段与anonymized_hort_aggdat_01-07-2024.csv进行关联。本数据集包含以下字段： 变量名：rcd_nbr 取值：1、2、3等 定义：子批次的匿名标识符 变量名：bottle_number 取值：数值型 定义：对应单个子批次中某一特定害虫的编号 变量名：pest_type 取值：Disease（病害）、Invertebrate（无脊椎动物）、Plant（植物）、Seed（种子）、Vertebrate（脊椎动物）、Na（不可用）或空值 定义：潜在有害生物的类型 数据集 anonymized_hort_seeds_incidents_01-07-2024.csv 本数据集的每一行对应一次种子检出事件。需注意，并非所有种子检出事件均需采取处置措施。本数据集可通过rcd_nbr字段与anonymized_hort_aggdat_01-07-2024.csv关联，同时可通过bottle_number字段与anonymized_hort_pests_01-07-2024.csv进行关联。本数据集包含以下字段： 变量名：rcd_nbr 取值：1、2、3等 定义：子批次的匿名标识符 变量名：bottle_number 取值：数值型 定义：对应单个子批次中某一特定害虫的编号 变量名：pest_type 取值：Disease（病害）、Invertebrate（无脊椎动物）、Plant（植物）、Seed（种子）、Vertebrate（脊椎动物）、Na（不可用）或空值 定义：潜在有害生物的类型（本表格中该字段恒为Seed，即种子） 变量名：comments 取值：文本型 定义：备注信息 变量名：other_treatment 取值：Reconditioned（已复壮）或空值 定义：所采用的其他处理措施