Agricultural Production

Comprehensive Overview of Crop Harvest Areas and Production Practices

@kaggle.noeyislearning_agricultural_production

Table List

3 tables(307.92 MB)

Agricultural Production Animas Products 2024

Agricultural Production Census 2002

Agricultural Production Census 2007

Agricultural Production Census 2007

@kaggle.noeyislearning_agricultural_production.agricultural_production_census_2007

26.27 MB
5617531 rows
39 columns

source_desc SOURCE DESC	sector_desc SECTOR DESC	group_desc GROUP DESC	commodity_desc COMMODITY DESC	class_desc CLASS DESC	prodn_practice_desc PRODN PRACTICE DESC	util_practice_desc UTIL PRACTICE DESC	statisticcat_desc STATISTICCAT DESC	unit_desc UNIT DESC	short_desc SHORT DESC	domain_desc DOMAIN DESC	domaincat_desc DOMAINCAT DESC	agg_level_desc AGG LEVEL DESC	state_ansi STATE ANSI	state_fips_code STATE FIPS CODE	state_alpha STATE ALPHA	state_name STATE NAME	asd_code ASD CODE	asd_desc ASD DESC	county_ansi COUNTY ANSI	county_code COUNTY CODE	county_name COUNTY NAME	watershed_desc WATERSHED DESC	country_code COUNTRY CODE	country_name COUNTRY NAME	location_desc LOCATION DESC	year YEAR	freq_desc FREQ DESC	reference_period_desc REFERENCE PERIOD DESC	load_time LOAD TIME	value VALUE
CENSUS	CROPS	VEGETABLES	BEANS	SNAP	ALL PRODUCTION PRACTICES	ALL UTILIZATION PRACTICES	AREA HARVESTED	ACRES	BEANS, SNAP - ACRES HARVESTED	TOTAL	NOT SPECIFIED	COUNTY	1	1	AL	ALABAMA	10	NORTHERN VALLEY	33	33	COLBERT	nan	9000	UNITED STATES	ALABAMA, NORTHERN VALLEY, COLBERT	2007	ANNUAL	YEAR	Sun Jan 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	2
CENSUS	CROPS	FIELD CROPS	COTTON	ALL CLASSES	ALL PRODUCTION PRACTICES	ALL UTILIZATION PRACTICES	AREA HARVESTED	ACRES	COTTON - ACRES HARVESTED	TOTAL	NOT SPECIFIED	COUNTY	1	1	AL	ALABAMA	10	NORTHERN VALLEY	33	33	COLBERT	nan	9000	UNITED STATES	ALABAMA, NORTHERN VALLEY, COLBERT	2007	ANNUAL	YEAR	Sun Jan 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	11,521
CENSUS	CROPS	FIELD CROPS	COTTON	UPLAND	ALL PRODUCTION PRACTICES	ALL UTILIZATION PRACTICES	AREA HARVESTED	ACRES	COTTON, UPLAND - ACRES HARVESTED	TOTAL	NOT SPECIFIED	COUNTY	1	1	AL	ALABAMA	10	NORTHERN VALLEY	33	33	COLBERT	nan	9000	UNITED STATES	ALABAMA, NORTHERN VALLEY, COLBERT	2007	ANNUAL	YEAR	Sun Jan 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	11,521
CENSUS	CROPS	FIELD CROPS	COTTON	UPLAND	IRRIGATED	ALL UTILIZATION PRACTICES	AREA HARVESTED	ACRES	COTTON, UPLAND, IRRIGATED - ACRES HARVESTED	TOTAL	NOT SPECIFIED	COUNTY	1	1	AL	ALABAMA	10	NORTHERN VALLEY	33	33	COLBERT	nan	9000	UNITED STATES	ALABAMA, NORTHERN VALLEY, COLBERT	2007	ANNUAL	YEAR	Sun Jan 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	(D)
CENSUS	CROPS	FIELD CROPS	HAY & HAYLAGE	ALL CLASSES	ALL PRODUCTION PRACTICES	ALL UTILIZATION PRACTICES	AREA HARVESTED	ACRES	HAY & HAYLAGE - ACRES HARVESTED	TOTAL	NOT SPECIFIED	COUNTY	1	1	AL	ALABAMA	10	NORTHERN VALLEY	33	33	COLBERT	nan	9000	UNITED STATES	ALABAMA, NORTHERN VALLEY, COLBERT	2007	ANNUAL	YEAR	Sun Jan 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	12,675
CENSUS	CROPS	FIELD CROPS	HAY	ALL CLASSES	ALL PRODUCTION PRACTICES	ALL UTILIZATION PRACTICES	AREA HARVESTED	ACRES	HAY - ACRES HARVESTED	TOTAL	NOT SPECIFIED	COUNTY	1	1	AL	ALABAMA	10	NORTHERN VALLEY	33	33	COLBERT	nan	9000	UNITED STATES	ALABAMA, NORTHERN VALLEY, COLBERT	2007	ANNUAL	YEAR	Sun Jan 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	12,400
CENSUS	CROPS	FIELD CROPS	HAY	ALL CLASSES	ALL PRODUCTION PRACTICES	ALL UTILIZATION PRACTICES	PRODUCTION	TONS	HAY - PRODUCTION, MEASURED IN TONS	TOTAL	NOT SPECIFIED	COUNTY	1	1	AL	ALABAMA	10	NORTHERN VALLEY	33	33	COLBERT	nan	9000	UNITED STATES	ALABAMA, NORTHERN VALLEY, COLBERT	2007	ANNUAL	YEAR	Sun Jan 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	20,391
CENSUS	CROPS	FIELD CROPS	HAY	ALL CLASSES	IRRIGATED	ALL UTILIZATION PRACTICES	AREA HARVESTED	ACRES	HAY, IRRIGATED - ACRES HARVESTED	TOTAL	NOT SPECIFIED	COUNTY	1	1	AL	ALABAMA	10	NORTHERN VALLEY	33	33	COLBERT	nan	9000	UNITED STATES	ALABAMA, NORTHERN VALLEY, COLBERT	2007	ANNUAL	YEAR	Sun Jan 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	36
CENSUS	CROPS	FIELD CROPS	HAY	ALFALFA	ALL PRODUCTION PRACTICES	ALL UTILIZATION PRACTICES	AREA HARVESTED	ACRES	HAY, ALFALFA - ACRES HARVESTED	TOTAL	NOT SPECIFIED	COUNTY	1	1	AL	ALABAMA	10	NORTHERN VALLEY	33	33	COLBERT	nan	9000	UNITED STATES	ALABAMA, NORTHERN VALLEY, COLBERT	2007	ANNUAL	YEAR	Sun Jan 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	231
CENSUS	CROPS	FIELD CROPS	HAY	ALFALFA	ALL PRODUCTION PRACTICES	ALL UTILIZATION PRACTICES	PRODUCTION	TONS	HAY, ALFALFA - PRODUCTION, MEASURED IN TONS	TOTAL	NOT SPECIFIED	COUNTY	1	1	AL	ALABAMA	10	NORTHERN VALLEY	33	33	COLBERT	nan	9000	UNITED STATES	ALABAMA, NORTHERN VALLEY, COLBERT	2007	ANNUAL	YEAR	Sun Jan 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	548


CREATE TABLE agricultural_production_census_2007 (
  "source_desc" VARCHAR,
  "sector_desc" VARCHAR,
  "group_desc" VARCHAR,
  "commodity_desc" VARCHAR,
  "class_desc" VARCHAR,
  "prodn_practice_desc" VARCHAR,
  "util_practice_desc" VARCHAR,
  "statisticcat_desc" VARCHAR,
  "unit_desc" VARCHAR,
  "short_desc" VARCHAR,
  "domain_desc" VARCHAR,
  "domaincat_desc" VARCHAR,
  "agg_level_desc" VARCHAR,
  "state_ansi" DOUBLE,
  "state_fips_code" BIGINT,
  "state_alpha" VARCHAR,
  "state_name" VARCHAR,
  "asd_code" DOUBLE,
  "asd_desc" VARCHAR,
  "county_ansi" DOUBLE,
  "county_code" DOUBLE,
  "county_name" VARCHAR,
  "region_desc" VARCHAR,
  "zip_5" DOUBLE,
  "watershed_code" BIGINT,
  "watershed_desc" VARCHAR,
  "congr_district_code" VARCHAR,
  "country_code" BIGINT,
  "country_name" VARCHAR,
  "location_desc" VARCHAR,
  "year" BIGINT,
  "freq_desc" VARCHAR,
  "begin_code" BIGINT,
  "end_code" BIGINT,
  "reference_period_desc" VARCHAR,
  "week_ending" VARCHAR,
  "load_time" TIMESTAMP,
  "value" VARCHAR,
  "cv" VARCHAR
);