nass_data: Get data from the Quick Stats query

Description Usage Arguments Value Examples

View source: R/nass_data.R

Description

Sends query to Quick Stats API from given parameter values. Data request is limited to 50,000 records per the API. Use nass_count to determine number of records in query.

Usage

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
nass_data(
  source_desc = NULL,
  sector_desc = NULL,
  group_desc = NULL,
  commodity_desc = NULL,
  class_desc = NULL,
  prodn_practice_desc = NULL,
  util_practice_desc = NULL,
  statisticcat_desc = NULL,
  unit_desc = NULL,
  short_desc = NULL,
  domain_desc = NULL,
  domaincat_desc = NULL,
  agg_level_desc = NULL,
  state_ansi = NULL,
  state_fips_code = NULL,
  state_alpha = NULL,
  state_name = NULL,
  asd_code = NULL,
  asd_desc = NULL,
  county_ansi = NULL,
  county_code = NULL,
  county_name = NULL,
  region_desc = NULL,
  zip_5 = NULL,
  watershed_code = NULL,
  watershed_desc = NULL,
  congr_district_code = NULL,
  country_code = NULL,
  country_name = NULL,
  location_desc = NULL,
  year = NULL,
  freq_desc = NULL,
  begin_code = NULL,
  end_code = NULL,
  reference_period_desc = NULL,
  week_ending = NULL,
  key = NULL,
  format = c("CSV", "JSON", "XML"),
  numeric_vals = FALSE
)

Arguments

source_desc

"Program" - Source of data ("CENSUS" or "SURVEY"). Census program includes the Census of Ag as well as follow up projects. Survey program includes national, state, and county surveys.

sector_desc

"Sector" - Five high level, broad categories useful to narrow down choices. ("ANIMALS & PRODUCTS", "CROPS", "DEMOGRAPHICS", "ECONOMICS", or "ENVIRONMENTAL")

group_desc

"Group" - Subsets within sector (e.g., under sector_desc = "CROPS", the groups are "FIELD CROPS", "FRUIT & TREE NUTS", "HORTICULTURE", and "VEGETABLES").

commodity_desc

"Commodity" - The primary subject of interest (e.g., "CORN", "CATTLE", "LABOR", "TRACTORS", "OPERATORS").

class_desc

Generally a physical attribute (e.g., variety, size, color, gender) of the commodity.

prodn_practice_desc

A method of production or action taken on the commodity (e.g., IRRIGATED, ORGANIC, ON FEED).

util_practice_desc

Utilizations (e.g., GRAIN, FROZEN, SLAUGHTER) or marketing channels (e.g., FRESH MARKET, PROCESSING, RETAIL).

statisticcat_desc

"Category" - The aspect of a commodity being measured (e.g., "AREA HARVESTED", "PRICE RECEIVED", "INVENTORY", "SALES").

unit_desc

The unit associated with the statistic category (e.g., ACRES, $ / LB, HEAD, $, OPERATIONS).

short_desc

"Data Item" - A concatenation of six columns: commodity_desc, class_desc, prodn_practice_desc, util_practice_desc, statisticcat_desc, and unit_desc.

domain_desc

"Domain" - Generally another characteristic of operations that produce a particular commodity (e.g., "ECONOMIC CLASS", "AREA OPERATED", "NAICS CLASSIFICATION", "SALES"). For chemical usage data, the domain describes the type of chemical applied to the commodity. The domain_desc = "TOTAL" will have no further breakouts; i.e., the data value pertains completely to the short_desc.

domaincat_desc

"Domain Category" - Categories or partitions within a domain (e.g., under domain_desc = "SALES", domain categories include $1,000 TO $9,999, $10,000 TO $19,999, etc).

agg_level_desc

"Geographic Level" - Aggregation level or geographic granularity of the data. ("AGRICULTURAL DISTRICT", "COUNTY", "INTERNATIONAL", "NATIONAL", "REGION : MULTI-STATE", "REGION : SUB-STATE", "STATE", "WATERSHED", or "ZIP CODE")

state_ansi

American National Standards Institute (ANSI) standard 2-digit state codes.

state_fips_code

NASS 2-digit state codes; include 99 and 98 for US TOTAL and OTHER STATES, respectively; otherwise match ANSI codes.

state_alpha

State abbreviation, 2-character alpha code.

state_name

"State" - State full name.

asd_code

NASS defined county groups, unique within a state, 2-digit ag statistics district code.

asd_desc

"Ag District" - Ag statistics district name.

county_ansi

ANSI standard 3-digit county codes.

county_code

NASS 3-digit county codes; includes 998 for OTHER (COMBINED) COUNTIES and Alaska county codes; otherwise match ANSI codes.

county_name

"County" - County name.

region_desc

"Region" - NASS defined geographic entities not readily defined by other standard geographic levels. A region can be a less than a state (SUB-STATE) or a group of states (MULTI-STATE), and may be specific to a commodity.

zip_5

"Zip Code" - US Postal Service 5-digit zip code.

watershed_code

US Geological Survey (USGS) 8-digit Hydrologic Unit Code (HUC) for watersheds.

watershed_desc

"Watershed" - Name assigned to the HUC.

congr_district_code

US Congressional District 2-digit code.

country_code

US Census Bureau, Foreign Trade Division 4-digit country code, as of April, 2007.

country_name

Country name.

location_desc

Full description for the location dimension.

year

"Year" - The numeric year of the data and can be either a character or numeric vector. Conditional values are also possible, for example a character vector of ">=1999" of "1999<=" will give years greater than or equal to 1999. Right now the logical values can either be greater/less than or equal to with the logical at either the beginning or end of a string with the year.

freq_desc

"Period Type" - Length of time covered ("ANNUAL", "SEASON", "MONTHLY", "WEEKLY", "POINT IN TIME"). "MONTHLY" often covers more than one month. "POINT IN TIME" is as of a particular day.

begin_code

If applicable, a 2-digit code corresponding to the beginning of the reference period (e.g., for freq_desc = MONTHLY, begin_code ranges from 01 (January) to 12 (December)).

end_code

If applicable, a 2-digit code corresponding to the end of the reference period (e.g., the reference period of JAN THRU MAR will have begin_code = 01 and end_code = 03).

reference_period_desc

"Period" - The specific time frame, within a freq_desc.

week_ending

Week ending date, used when freq_desc = WEEKLY.

key

API key, default is to use the value stored in .Renviron which is stored from the nass_set_key function. If there is no API key stored in the environment, a character string can be provided.

format

Output format from API call. Defaults to CSV as it is typically the smallest sized call. Other options are JSON and XML but these are not recommended. XML currently not supported.

numeric_vals

Optional to convert the year, Value, and coefficient of variation (CV %) to numerics as opposed to defaulted character values. Default is to FALSE as some Values have a suppression code. Converting to numeric will result in suppressed values to be NA.

Value

A data frame containing query to API.

Examples

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
## Not run: 
# Get state values in 2012 for all of the values of agricultural land
nass_data(agg_level_desc = "STATE", year = "2012",
commodity_desc = "AG LAND", domain_desc = "VALUE")

## End(Not run)

## Not run: 
# Get county level values in 2012 for the specific data item
  nass_data(year = 2012, agg_level_desc = "COUNTY",
   short_desc = "AG LAND, INCL BUILDINGS - ASSET VALUE, MEASURED IN $")

## End(Not run)

rdinter/usdarnass documentation built on Feb. 10, 2020, 7:28 p.m.