About this Dataset

Iowa Certified Organic Farms And Businesses

This dataset contains information on certified organic farms and businesses physically located in Iowa. These farms and businesses have successfully passed an inspection from a USDA National Organic Program Accredited Inspection Agency.

For more information please visit the USDA National Organic Program website: http://www.ams.usda.gov/AMSv1.0/nop
Organization: State of Iowa
Last updated: 2023-01-19T23:54:26.884486
Tags: businesses, organic-farms, usda-national-organic-program

Tables

Table 1

@usgov.state_of_iowa_iowa_certified_organic_farms_and_businesses.table_1

200.08 kB
954 rows
25 columns

CREATE TABLE table_1 (
  "operation_id" BIGINT,
  "operation_name" VARCHAR,
  "other_former_names" VARCHAR,
  "certifier_name" VARCHAR,
  "operation_certification_status" VARCHAR,
  "operation_certification_status_effective_date" TIMESTAMP,
  "crops_status" VARCHAR,
  "crops_effective_date" TIMESTAMP,
  "crops_certified_products" VARCHAR,
  "livestock_status" VARCHAR,
  "livestock_effective_date" TIMESTAMP,
  "livestock_certified_products" VARCHAR,
  "wild_crops_status" VARCHAR,
  "wild_crops_effective_date" TIMESTAMP,
  "wild_crops_certified_products" VARCHAR,
  "handling_status" VARCHAR,
  "handling_effective_date" TIMESTAMP,
  "handling_certified_products" VARCHAR,
  "physical_address_street_1" VARCHAR,
  "physical_address_street_2" VARCHAR,
  "physical_address_city" VARCHAR,
  "physical_address_state" VARCHAR,
  "physical_address_zip_code" VARCHAR,
  "physical_location" VARCHAR,
  "record_updated" TIMESTAMP
);