Cookies Settings

Loading

dnb-logo
Partners
Collapse

Append Partner Data

ProductD&B Direct+
Featuredataexchange
Version1.0
Options(s)DUNS (single or multiple)
View(s)n/a
Monitor optionNo
InterfaceREST
MethodGET + POST (multiple)
Format(s)JSON
Released onJuly 31, 2015

This API will return records from each specified partner provider. When no provider is passed, the call will return all available records. Options are available to request single or multiple D-U-N-S Numbers per call.

NOTE: The version of this API call will not change when data providers are added or removed from the platform. Please check the list of datasets for available data providers.

Update History

No modifications have been made to this data layer since the initial release.

Feature Request

D&B Direct+ API calls utilize access tokens - generated from a key/secret combination - for authentication based on the Client Credentials Grant flow of the OAuth 2 specification. These access tokens expire after twenty-four hours. The error code 00040 indicates the current access token being used has expired.

Contact your D&B representative to obtain your D&B Direct+ key/secret combination. These values, along with any access tokens generated, should be considered as sensitive as a password, and must be used only by authorized parties as stated in the D&B Direct+ API agreement.

Refer to "Understanding the D&B Direct+ API Authentication Flow" for more details on the steps involved in authenticating.

Available Data Providers (and Data Set Names)

The following is a list of the available data providers along with the corresponding data set name that can be used as a parameter on feature requests.

Data Set NameProvider
dnbDun & Bradstreet
bomboraBombora
farmdataUS Farm Data
hds-providerHealthcare Data Solutions
industrial-interfaceIndustrial Interface
iridiumIridium Information Resources
oxxford-energyOxxford IT/UCIS
oxxford-financialOxxford IT/UCIS

Specification

When implementing the single D-U-N-S Number option, a valid D-U-N-S Number for a company will be required. An option is available to filter results for specific data providers (using the data set names). For the multiple D-U-N-S Number option, a single data set name and a list of valid D-U-N-S Number for a company will be required Pagination options also exist.

All D&B Direct+ function calls require the use of a secured connection (i.e. https).

Single D-U-N-S Number Request

Place a single {DUNS} into the following endpoint: https://plus.dnb.com/v1/dataexchange/organizations/{DUNS}. If you would like results for specific data providers append "?datasets={dataset,dataset,...}" to the endpoint with a comma delimited list of one or more valid data set names.

Sample Request (Single)
GET https://plus.dnb.com/v1/dataexchange/organizations/804735132
Authorization: Bearer <yourToken> (from Authentication call)
Origin: www.dnb.com

Batch (Multiple) D-U-N-S Number Request

This option is limited to results for a specific data provider (by dataset name).

Place the {dataset} into the following endpoint: https://plus.dnb.com/v1/dataexchange/dataset/{dataset}. and append "?duns={DUNS,DUNS,...}" to the endpoint with a comma delimited list of one or more valid D-U-N-S Numbers.

Sample Request (Batch GET)
GET https://plus.dnb.com/v1/dataexchange/datasets/iridium?duns=804735132,804735133
Authorization: Bearer <yourToken> (from Authentication call)
Origin: www.dnb.com

This option is also available as a POST operation, where the additional parameters (DUNS, offset, size) are submitted in the [BODY] of the request.

Sample Request (Batch POST)
POST https://plus.dnb.com/v1/dataexchange/datasets/iridium
Authorization: Bearer <yourToken> (from Authentication call)
Origin: www.dnb.com

[BODY]
{
	"duns": [
	"804735132,804735133"
	],
	"offset": 0,
	"size": 0
}

Pagination

To control the number of results in each response, you may append a page {size} and starting {offset} to the endpoint. The following example "&offset=3&size=25" would be interpreted as meaning "return the third page of results, where each page contains twenty-five records" OR "record numbers 51 to 75 in the results."

For Customers using Postman (Optional)

Postman is a Google Chrome plug-in that allows you to make API calls and inspect responses from within a browser environment. The following Postman collection is available for making calls to these features.

Direct+ Postman collection for dataexchange
DeX.plus.dnb.com.json.postman_collection

Refer to "Interacting with the D&B Data Exchange+ API Using Postman" for more details on how to quickly and easily make API calls. The consumer key/secret credentials will be required.

Feature Response

Specification

Sample Response (Single)
{
    "iridium": {
        "count": 2,
        "links": {
            "self": "/v1/organizations/009122532?dataset=iridium&offset=0&size=100",
            "next": null,
            "previous": null,
            "first": "/v1/organizations/009122532?dataset=iridium&offset=0&size=100",
            "last": "/v1/organizations/009122532?dataset=iridium&offset=0&size=100"
        },
        "items": [
            {
                "gsa": "FALSE",
                "companyName": "Hewlett-Packard Company",
                "projectDueDate": "Tue Nov 29 19:00:00 EST 2016",
                "leadMsa": "5600",
                "duns": "009122532",
                "leadState": "New York",
                "leadType": "Federal Contract Award",
                "publicationDate": "Thu Feb 05 19:00:00 EST 2015",
                "leadMsaName": "New York",
                "leadCounty": "Kings",
                "projectValue": 70104,
                "id": "SW975381",
                "leadStreet": "",
                "url": "",
                "leadCountry": "United States",
                "companyState": "California",
                "salesIntelligence": "Brooklyn, NY -- New Federal Contact Award -- Company: Hewlett-Packard Company 3000 Hanover St Palo Alto, CA 94304-1112 United States Telephone: 703-742-1025 Fax: 703-742-2674 Industry: 511210: SOFTWARE PUBLISHERS. Organization Type: CORPORATE NOT TAX EXEMPT O: OTHER THAN SMALL BUSINESS. Contract Value: $70,104.99 Contacting Agency: 3600: VETERANS AFFAIRS, DEPARTMENT OF; 3600: VETERANS AFFAIRS, DEPARTMENT OF; 00242: 242-NETWORK CONTRACT OFFICE 02. Contract Timeline: Signed Date: 12/1/2014 Completion Date: 11/30/2016 Contract Type: PO Purchase Order J: Firm Fixed Price Multi-Year: Y: Yes; Requirement: IGF::OT::IGF SOFTWARE LICENSE SERVICE AND MAINTENANCE. Place of Performance: Brooklyn NY 11209-7104 United States. Product Description: J070: MAINT/REPAIR/REBUILD OF EQUIPMENT- ADP EQUIPMENT/SOFTWARE/SUPPLIES/SUPPORT EQUIPMENT Fiscal Year 2015.",
                "leadZip": "11209",
                "leadCity": "Brooklyn"
            },
            {
                "gsa": "FALSE",
                "companyName": "Hewlett-Packard Company",
                "projectDueDate": "Thu Apr 09 20:00:00 EDT 2015",
                "leadMsa": "8840",
                "duns": "009122532",
                "leadState": "Maryland",
                "leadType": "Federal Contract Award",
                "publicationDate": "Thu May 21 20:00:00 EDT 2015",
                "leadMsaName": "Washington",
                "leadCounty": "Montgomery",
                "projectValue": 36632,
                "id": "SW1078844",
                "leadStreet": "",
                "url": "",
                "leadCountry": "United States",
                "companyState": "California",
                "salesIntelligence": "Bethesda, MD -- New Federal Contact Award -- Company: Hewlett-Packard Company 3000 Hanover St Palo Alto, CA 94304-1181 United States Telephone: 800-727-5472 Fax: 800-344-9396 Industry: 334111. Organization Type: Corporate Not Tax Exempt O: Other Than Small Business. Contract Value: $36,632.25 Contacting Agency: 7500: HEALTH AND HUMAN SERVICES, DEPARTMENT OF; 7529: NATIONAL INSTITUTES OF HEALTH; 00276: NIH, NLM, OD OA OA OFC ACQUISITIONS. Contract Timeline: Signed Date: 3/6/2015 Completion Date: 4/10/2015 Contract Type: DO Delivery Order J: Firm Fixed Price Multi-Year: N: No; Requirement: NCBI: CONFIGURABLE HP ELITE FOLIO 9480M LAPTOP W/INTEL I7 -4600U G6H04AV CONFIGURED, PER ATTACHED HP QUOTE #10195145, IN RESPONSE TO ECS III RFQ #17358.. Place of Performance: Bethesda MD 20817-1129 United States. Product Description: 7035: ADP SUPPORT EQUIPMENT Fiscal Year 2015.",
                "leadZip": "20817",
                "leadCity": "Bethesda"
            }
        ]
    },
    "bombora": {
        "count": 0,
        "links": {
            "self": "/v1/organizations/009122532?dataset=bombora&offset=0&size=100",
            "next": null,
            "previous": null,
            "first": null,
            "last": null
        },
        "items": []
    },
    "industrial-interface": {
        "count": 0,
        "links": {
            "self": "/v1/organizations/009122532?dataset=industrial-interface&offset=0&size=100",
            "next": null,
            "previous": null,
            "first": null,
            "last": null
        },
        "items": []
    }
}
Sample Response (Batch)
{
    "count": 5,
    "links": {
        "self": "/v1/datasets/iridium?duns=001020408,001382555,833081081,009137209,009122532&offset=0&size=100",
        "next": null,
        "previous": null,
        "first": "/v1/datasets/iridium?duns=001020408,001382555,833081081,009137209,009122532&offset=0&size=100",
        "last": "/v1/datasets/iridium?duns=001020408,001382555,833081081,009137209,009122532&offset=0&size=100"
    },
    "data": [
        {
            "gsa": "FALSE",
            "companyName": "Chevron Corporation",
            "projectDueDate": "Mon Aug 31 20:00:00 EDT 2015",
            "leadMsa": "3360",
            "duns": "001382555",
            "leadState": "Texas",
            "leadType": "Relocation/Construction/Expansion",
            "publicationDate": "Thu Apr 09 20:00:00 EDT 2015",
            "leadMsaName": "Houston",
            "leadCounty": "Harris",
            "projectValue": 1250000,
            "id": "SW1062829",
            "leadStreet": "1500 Louisiana St Fl 6",
            "url": "http://www.chevron.com/",
            "leadCountry": "United States",
            "companyState": "California",
            "salesIntelligence": "Houston, TX -- New Project -- Company: Chevron 6001 Bollinger Canyon Rd San Ramon CA 94583-2324 Telephone: 925-842-1000 Website: http://www.chevron.com/. Project Details: Project Type: Non-Residential Alteration. Project Details: Office Suite Remodel. Project Contact: De Harvey Builders 3630 Westchase Houston, TX 77042 Telephone: (713) 783-8710. Project Size:  Sq. Ft. Project Value: $1,250,000.00 Project location: 1500 Louisiana St Fl 6 Houston, TX 77002. Estimated Completion Date: 9/1/2015 Industry. 4939 Energy & Utilities, Gasoline and Oil Refineries.",
            "leadZip": "77002",
            "leadCity": "Houston"
        },
        {
            "projectSize": 46834,
            "gsa": "FALSE",
            "companyName": "Chevron Corporation",
            "projectDueDate": "Thu Dec 31 19:00:00 EST 2015",
            "leadMsa": "680",
            "duns": "001382555",
            "leadState": "California",
            "leadType": "Relocation/Construction/Expansion",
            "publicationDate": "Thu Jun 25 20:00:00 EDT 2015",
            "leadMsaName": "Bakersfield",
            "leadCounty": "Kern",
            "projectValue": 2716372,
            "id": "SW1089770",
            "leadStreet": "9500 Ming Ave",
            "url": "http://www.chevron.com/",
            "leadCountry": "United States",
            "companyState": "California",
            "salesIntelligence": "Bakersfield, CA -- New Project -- Company: Chevron 6001 Bollinger Canyon Rd. San Ramon CA 94583 Telephone: 925-842-1000 Website: http://www.chevron.com/. Project Details: Project Type: Commercial Construction. Description: 46,834 SF TI CHEVRON. Project Contact(s): Chevron; Whitezell Construction Inc. Project Size: 46,834 Sq. Ft. Project Value: $2,716,372.00 Project location: 9500 Ming Ave Bakersfield, CA 93311. Estimated Completion Date: 1/1/2016 Industry. 2911 Petroleum Refining.",
            "leadZip": "93311",
            "leadCity": "Bakersfield"
        },
        {
            "gsa": "FALSE",
            "companyName": "Chevron Corporation",
            "projectDueDate": "Tue Mar 31 20:00:00 EDT 2015",
            "leadMsa": "3360",
            "duns": "001382555",
            "leadState": "Texas",
            "leadType": "Relocation/Construction/Expansion",
            "publicationDate": "Thu Feb 26 19:00:00 EST 2015",
            "leadMsaName": "Houston",
            "leadCounty": "Harris",
            "id": "SW994773",
            "leadStreet": "3901 Briarpark Dr Fl 1",
            "url": "http://www.chevron.com/",
            "leadCountry": "United States",
            "companyState": "California",
            "salesIntelligence": "Houston, TX -- New Project -- Company: Chevron 6001 Bollinger Canyon Rd San Ramon CA 94583-2324 Telephone: 925-842-1000 Website: http://www.chevron.com/. Project Details: Project Type: Non-Residential Alteration. Project Details: Demo Of Interior Non Load Bearing Non Fire Rated Partitions. Project Contact: D E Harvey Builders 3630 Westchase Houston, TX 77042 Telephone: (713) 783-8710. Project Size: Not Available. Project Value: Not Available. Project location: 3901 Briarpark Dr Fl 1 Houston, TX 77042. Estimated Completion Date: 4/1/2015 Industry. 2911 Energy & Utilities, Gasoline and Oil Refineries.",
            "leadZip": "77042",
            "leadCity": "Houston"
        },
        {
            "gsa": "FALSE",
            "companyName": "Hewlett-Packard Company",
            "projectDueDate": "Tue Nov 29 19:00:00 EST 2016",
            "leadMsa": "5600",
            "duns": "009122532",
            "leadState": "New York",
            "leadType": "Federal Contract Award",
            "publicationDate": "Thu Feb 05 19:00:00 EST 2015",
            "leadMsaName": "New York",
            "leadCounty": "Kings",
            "projectValue": 70104,
            "id": "SW975381",
            "leadStreet": "",
            "url": "",
            "leadCountry": "United States",
            "companyState": "California",
            "salesIntelligence": "Brooklyn, NY -- New Federal Contact Award -- Company: Hewlett-Packard Company 3000 Hanover St Palo Alto, CA 94304-1112 United States Telephone: 703-742-1025 Fax: 703-742-2674 Industry: 511210: SOFTWARE PUBLISHERS. Organization Type: CORPORATE NOT TAX EXEMPT O: OTHER THAN SMALL BUSINESS. Contract Value: $70,104.99 Contacting Agency: 3600: VETERANS AFFAIRS, DEPARTMENT OF; 3600: VETERANS AFFAIRS, DEPARTMENT OF; 00242: 242-NETWORK CONTRACT OFFICE 02. Contract Timeline: Signed Date: 12/1/2014 Completion Date: 11/30/2016 Contract Type: PO Purchase Order J: Firm Fixed Price Multi-Year: Y: Yes; Requirement: IGF::OT::IGF SOFTWARE LICENSE SERVICE AND MAINTENANCE. Place of Performance: Brooklyn NY 11209-7104 United States. Product Description: J070: MAINT/REPAIR/REBUILD OF EQUIPMENT- ADP EQUIPMENT/SOFTWARE/SUPPLIES/SUPPORT EQUIPMENT Fiscal Year 2015.",
            "leadZip": "11209",
            "leadCity": "Brooklyn"
        },
        {
            "gsa": "FALSE",
            "companyName": "Hewlett-Packard Company",
            "projectDueDate": "Thu Apr 09 20:00:00 EDT 2015",
            "leadMsa": "8840",
            "duns": "009122532",
            "leadState": "Maryland",
            "leadType": "Federal Contract Award",
            "publicationDate": "Thu May 21 20:00:00 EDT 2015",
            "leadMsaName": "Washington",
            "leadCounty": "Montgomery",
            "projectValue": 36632,
            "id": "SW1078844",
            "leadStreet": "",
            "url": "",
            "leadCountry": "United States",
            "companyState": "California",
            "salesIntelligence": "Bethesda, MD -- New Federal Contact Award -- Company: Hewlett-Packard Company 3000 Hanover St Palo Alto, CA 94304-1181 United States Telephone: 800-727-5472 Fax: 800-344-9396 Industry: 334111. Organization Type: Corporate Not Tax Exempt O: Other Than Small Business. Contract Value: $36,632.25 Contacting Agency: 7500: HEALTH AND HUMAN SERVICES, DEPARTMENT OF; 7529: NATIONAL INSTITUTES OF HEALTH; 00276: NIH, NLM, OD OA OA OFC ACQUISITIONS. Contract Timeline: Signed Date: 3/6/2015 Completion Date: 4/10/2015 Contract Type: DO Delivery Order J: Firm Fixed Price Multi-Year: N: No; Requirement: NCBI: CONFIGURABLE HP ELITE FOLIO 9480M LAPTOP W/INTEL I7 -4600U G6H04AV CONFIGURED, PER ATTACHED HP QUOTE #10195145, IN RESPONSE TO ECS III RFQ #17358.. Place of Performance: Bethesda MD 20817-1129 United States. Product Description: 7035: ADP SUPPORT EQUIPMENT Fiscal Year 2015.",
            "leadZip": "20817",
            "leadCity": "Bethesda"
        }
    ]
}

Data Provider Field Lists

The following are lists of the fields available from each data provider that may be delivered in feature responses. These table also highlight items that may be included in the query parameter in the Partner Build-A-List Search feature.

dnb
FieldTypeDescriptionSearchable
dunsStringD-U-N-S NumberYes
nameStringCompany NameYes
tradestyleStringTrade StyleYes
physicalAddressObjectPhysical AddressYes
mailingAddressObjectMailing AddressYes
telephonePhoneTelephoneYes
sicStringSICYes
natnlidStringNational IDYes
natnlidcdStringNational ID CodeYes
lineOfBusinessStringLine of BusinessYes
revenueUsdNumberRevenue, USDYes
yearStartNumberYear StartYes
employeesHereNumberEmployees HereYes
employeesTotalNumberEmployees TotalYes
importExportCodeStringImport Export CodeYes
legalStatusNumberLegal StatusYes
statusCodeNumberStatus CodeYes
subsidiaryIndicatorNumberSudsidiary IndicatorYes
reportDateDateReport DateYes
hqDunsStringHQ DUNSYes
domesticUltimateDunsStringGlobal Ultimate DUNSYes
globalUltimateDunsStringGlobal Ultimate DUNSYes
bombora
FieldTypeDescriptionSearchable
dunsStringD-U-N-S Number 
companyNameStringCompany which is represented by Domain 
domainStringDomain. This is also the primary key 
topicStringName of the TopicYes
compositeScoreNumberPropriety Score indicating strength of the surgeYes
topMetrosStringLocations of company represented by domain where surge in topic was seen with a trend score per location. Locations are separated by semi-colons 
farmdata
FieldTypeDescriptionSearchable
dunsStringD-U-N-S Number 
titleStringStandard 'Title' associated with a person name 
firstNameStringFirst Name 
middleNameStringMiddle Name 
lastNameStringLast Name 
suffixStringSuffix 
companyStringCompany Name 
address1StringAddress 1 
address2StringAddress 2 
cityStringCity 
stateStringState 
zipcodeNumberZIP code 
zip4NumberZIP 4 
deliverypointStringDelivery point Y/N 
countyCodeNumber3 digit FIPs County Code 
countyStringCounty 
carrierRouteStringCarrier Route 
recordIdNumberRecord ID 
poboxBooleanData Values : Y/N 
phoneNumberStandard 10 digit phone 
ageStringA=19 to 24, B=25 to 34, C=35 to 44, D=45 to 54, E=55 to 64, F=65 to 74, G=75+, Blank=Uncoded 
alfalfaBooleanY = Grows listed Crop, Blank = Crop not Grown 
almondStringY = Grows listed Crop, Blank = Crop not Grown 
appleStringY = Grows listed Crop, Blank = Crop not Grown 
apricotBooleanY = Grows listed Crop, Blank = Crop not Grown 
artichokeStringY = Grows listed Crop, Blank = Crop not Grown 
asparagusStringY = Grows listed Crop, Blank = Crop not Grown 
avocadoStringY = Grows listed Crop, Blank = Crop not Grown 
bananaStringY = Grows listed Crop, Blank = Crop not Grown 
barleyStringY = Grows listed Crop, Blank = Crop not Grown 
beanStringY = Grows listed Crop, Blank = Crop not Grown 
beesStringY = Grows listed Crop, Blank = Crop not Grown 
beetStringY = Grows listed Crop, Blank = Crop not Grown 
berriesBooleanY = Grows listed Crop, Blank = Crop not Grown 
birdsStringY = Grows listed Crop, Blank = Crop not Grown 
brassicasvegetablesBooleanY = Grows listed Crop, Blank = Crop not Grown 
broccoliStringY = Grows listed Crop, Blank = Crop not Grown 
bulbandstemvegetablesBooleanY = Grows listed Crop, Blank = Crop not Grown 
cabbageStringY = Grows listed Crop, Blank = Crop not Grown 
carrotStringY = Grows listed Crop, Blank = Crop not Grown 
catusStringY = Grows listed Crop, Blank = Crop not Grown 
cauliflowerStringY = Grows listed Crop, Blank = Crop not Grown 
celeryStringY = Grows listed Crop, Blank = Crop not Grown 
citrusfruitsStringY = Grows listed Crop, Blank = Crop not Grown 
cloverStringY = Grows listed Crop, Blank = Crop not Grown 
cornBooleanY = Grows listed Crop, Blank = Crop not Grown 
cottonBooleanY = Grows listed Crop, Blank = Crop not Grown 
cucumberStringY = Grows listed Crop, Blank = Crop not Grown 
fishBooleanY = Grows listed Crop, Blank = Crop not Grown 
flowerStringY = Grows listed Crop, Blank = Crop not Grown 
forageBooleanY = Grows listed Crop, Blank = Crop not Grown 
foresttimberlandStringY = Grows listed Crop, Blank = Crop not Grown 
fruitnutsStringY = Grows listed Crop, Blank = Crop not Grown 
fruitingandfloweringvegetableBooleanY = Grows listed Crop, Blank = Crop not Grown 
garlicStringY = Grows listed Crop, Blank = Crop not Grown 
grainBooleanY = Grows listed Crop, Blank = Crop not Grown 
grapeStringY = Grows listed Crop, Blank = Crop not Grown 
grassBooleanY = Grows listed Crop, Blank = Crop not Grown 
greenhouseBooleanY = Grows listed Crop, Blank = Crop not Grown 
greensStringY = Grows listed Crop, Blank = Crop not Grown 
hayStringY = Grows listed Crop, Blank = Crop not Grown 
herbStringY = Grows listed Crop, Blank = Crop not Grown 
homegardenBooleanY = Grows listed Crop, Blank = Crop not Grown 
honeyStringY = Grows listed Crop, Blank = Crop not Grown 
leafvegetableStringY = Grows listed Crop, Blank = Crop not Grown 
leafyandsaladvegetablesBooleanY = Grows listed Crop, Blank = Crop not Grown 
melonsBooleanY = Grows listed Crop, Blank = Crop not Grown 
mushroomStringY = Grows listed Crop, Blank = Crop not Grown 
nurseryStringY = Grows listed Crop, Blank = Crop not Grown 
nutsBooleanY = Grows listed Crop, Blank = Crop not Grown 
oatsBooleanY = Grows listed Crop, Blank = Crop not Grown 
okraStringY = Grows listed Crop, Blank = Crop not Grown 
onionStringY = Grows listed Crop, Blank = Crop not Grown 
organicfarmersBooleanY = Grows listed Crop, Blank = Crop not Grown 
otherBooleanY = Grows listed Crop, Blank = Crop not Grown 
palmStringY = Grows listed Crop, Blank = Crop not Grown 
pasturelandStringY = Grows listed Crop, Blank = Crop not Grown 
peaStringY = Grows listed Crop, Blank = Crop not Grown 
pearStringY = Grows listed Crop, Blank = Crop not Grown 
pepperStringY = Grows listed Crop, Blank = Crop not Grown 
pineappleStringY = Grows listed Crop, Blank = Crop not Grown 
poddedvegetablesBooleanY = Grows listed Crop, Blank = Crop not Grown 
potatoStringY = Grows listed Crop, Blank = Crop not Grown 
raisinStringY = Grows listed Crop, Blank = Crop not Grown 
rangelandStringY = Grows listed Crop, Blank = Crop not Grown 
rapeStringY = Grows listed Crop, Blank = Crop not Grown 
recreationareaStringY = Grows listed Crop, Blank = Crop not Grown 
riceBooleanY = Grows listed Crop, Blank = Crop not Grown 
rootstuberousvegetablesBooleanY = Grows listed Crop, Blank = Crop not Grown 
soybeanBooleanY = Grows listed Crop, Blank = Crop not Grown 
spiceStringY = Grows listed Crop, Blank = Crop not Grown 
spinachStringY = Grows listed Crop, Blank = Crop not Grown 
squashStringY = Grows listed Crop, Blank = Crop not Grown 
subtropicalfruitsStringY = Grows listed Crop, Blank = Crop not Grown 
sugarbeltStringY = Grows listed Crop, Blank = Crop not Grown 
sugarcaneStringY = Grows listed Crop, Blank = Crop not Grown 
sunflowerStringY = Grows listed Crop, Blank = Crop not Grown 
tobaccoBooleanY = Grows listed Crop, Blank = Crop not Grown 
tomatoStringY = Grows listed Crop, Blank = Crop not Grown 
treefruitBooleanY = Grows listed Crop, Blank = Crop not Grown 
treesBooleanY = Grows listed Crop, Blank = Crop not Grown 
tropicalfruitsStringY = Grows listed Crop, Blank = Crop not Grown 
wheatBooleanY = Grows listed Crop, Blank = Crop not Grown 
winegrapesStringY = Grows listed Crop, Blank = Crop not Grown 
alfalfaAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
almondAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
appleAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
apricotAcreTimeA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
artichokeAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
asparagusAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
avocadoAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
bananaAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
barleyAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
bulbandStemVegetableAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
beanAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
beesAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
beetAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
berryAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
birdsAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
brassicasVegetableAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
broccoliAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
cabbageAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
carrotAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
catusAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
cauliflowerAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
celeryAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
citrusFruitAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
cloverAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
cornAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
cottonAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
cucumberAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
fruitingFloweringVegetableAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
fishAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
flowerAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
forageAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
foresttimberlandAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
garlicAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
grainAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
grapeAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
grassAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
greenhouseAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
greensAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
hayAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
herbAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
homeAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
honeyAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
leafvegetableAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
lettuceAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
leafyandSaladVegetableAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
melonsAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
mushroomAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
nurseryAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
nutsAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
oatsAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
okraAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
onionAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
otherAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
palmAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
pasturelandAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
peaAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
pearAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
pepperAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
pineappleAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
poddedVegetableAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
potatoAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
raisinAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
rangelandAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
rapeAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
recreationareaAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
riceAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
rootsandTuberousVegeAcresStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
seedAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
soybeanAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
spiceAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
spinachAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
squashAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
subtropicalAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
sugarbeltAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
sugarcaneAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
sunflowerAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
tobaccoAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
tomatoAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
treeFruitAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
treesAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
tropicalAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
wheatAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
winegrapesAcreStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
farmAcreSizeStringFarm Acre Size 
totalNumberofAcresStringA=1 to 9, B=10 to 24, C=25 to 49, D=50 to 99, E=100 to 249, F=250 to 499, G=500 to 999, H=1000 to 2499, I=2500 to 4999, J=5000 or more acres, Blank=Uncoded 
corporateFarmAcreSizeStringCorporate Farm Acre Size 
irrigationUseBooleanY = Irrigation, Blank= No Irrigation 
animalsStringY = Animal, Blank = Null 
cattleBooleanY = Raises Cattle, Blank = Does not Raise Cattle 
dairyBooleanY = Dairy Producer, Blank = Does not Produce Dairy 
goatsBooleanY = Raises Goats, Blank = Does not Raise Goats 
hogBooleanY = Raises Hogs, Blank = Does not Raise Hogs 
sheepBooleanY = Raises Sheep, Blank = Does not Raise Sheep 
cattleTotalHeadStringA=1 to 10, B=11 to 50, C=51 to 100, D=101 to 250, E=251 to 500, F=501 to 1000, G=1001 to 2500, H=2501 to 5000, Blank=Uncoded 
dairyTotalHeadStringA=1 to 10, B=11 to 50, C=51 to 100, D=101 to 250, E=251 to 500, F=501 to 1000, G=1001 to 2500, H=2501 to 5000, Blank=Uncoded 
goatTotalHeadStringA=1 to 10, B=11 to 50, C=51 to 100, D=101 to 250, E=251 to 500, F=501 to 1000, G=1001 to 2500, H=2501 to 5000, Blank=Uncoded 
hogTotalHeadTimeA=1 to 10, B=11 to 50, C=51 to 100, D=101 to 250, E=251 to 500, F=501 to 1000, G=1001 to 2500, H=2501 to 5000, Blank=Uncoded 
sheepTotalHeadStringA=1 to 10, B=11 to 50, C=51 to 100, D=101 to 250, E=251 to 500, F=501 to 1000, G=1001 to 2500, H=2501 to 5000, Blank=Uncoded 
livestockTotalHeadStringA=1 to 10, B=11 to 50, C=51 to 100, D=101 to 250, E=251 to 500, F=501 to 1000, G=1001 to 2500, H=2501 to 5000, Blank=Uncoded 
entityTypeStringEntity code: A = Individual, B = General Partnership, C = Joint Venture, D = Corporation with Stockholders,E = Limited Partnership, F = Estate, G = Trust - Revocable, H = Government, I = No Stockholders, J = Trust - Irrevocable, K = Small Business Blank=Uncoded 
numberofFarmsOwnedStringTotal Number of Farms Owned Under Management 
ownerProducerBooleanY = Is an Owner/Producer, N = Not an Owner/Producer 
ownerOperatorProducerBooleanY = Is an Owner/Producer, N = Not an Owner/Producer 
operatorProducerBooleanY = Is an Owner/Producer, N = Not an Owner/Producer 
otherProducerBooleanY = Is an Owner/Producer, N = Not an Owner/Producer 
deliverableNumberData Values : 1, Blank 
addressFilledNumberData Values : 1, Blank 
phoneFilledNumberData Values : 1, Blank 
estimatedFarmOperationRevenueStringEstimated Annual Revenue by Farm ID Specific 
estimatedCorporateOperationRevenueStringEstimated Annual Revenue by All Farms Under Management 
estimatedHouseholdIncomeStringEstimated Household Income of Farmer 
subsidyPaymentBooleanPayments Received from Government(Y or N) 
lastSubsidyPaymentStringDollar Amount Received in Range 
lastSubsidyPaymentYearNumberTimeframe of last subsidy payment (YYYY) 
croptypeSubsidyPaymentBooleanPayments Received from Government by Crop Type 
socialMediaFlagStringFarmers Using Some Form of Social Media 
hds-provider
FieldTypeDescriptionSearchable
typePhysicianBoolean-
typeDentistString-
typeMidLevelBoolean-
typePharmacistString-
typeVeterinarianString-
residentBoolean-
dunsString-Yes
phyLocIDNumber-
hDSPhyIDNumber-
siteIDNumber-
physicianPracticeTypeString-
specialty1String-
specialty1DescriptionString-
hospitalBoolean-
practiceNameString-
siteSpecialtyCategoryCodeString-
siteSpecialtyCategoryString-
stateString-
officeSizeNumber-
eMRSoftwareString-
industrial-interface
FieldTypeDescriptionSearchable
dunsStringD-U-N-S Number 
iiReferenceIdNumberIndustrial Interface Company Referance ID 
nameStringThe Company name 
urlStringThe Company Website URL 
hqStateStringState the HQ is located in 
hqCountryStringCountry the HQ is Located in 
manufacturingBusinessTypesStringManufacturing business types and designations qualified forYes
productsManufacturedStringProducts the company manufacturesYes
productsSoldStringProducts the company sells (i.e. a distributor or reseller or potentially a manufacturer who sells directly to other companies or consumers, not through distributors).Yes
servicesProvidedStringServices provided to customersYes
materialsUsedStringMaterials used in products and servicesYes
mfgEquipmentUsedStringManufacturing equipment used in company facilitiesYes
brandsRepresentedStringBrands owned or sold by this company 
otherKeywordsStringRelated products or applications that are relevant to the company but have not been verfied as manufactured or soldYes
industriesServedStringIndustries the company sells toYes
certificationsStringNamed of Industry Certifications heldYes
diversityBusinessTypesStringDiversity business types and designations qualified forYes
socialMediaIdsStringLinkedin, Twitter, Facebook, Youtube, etc. 
cageCodesStringCan Sell to U.S. Government 
globalIndicatorBooleanAffirmative indication company does business globally ('Yes' or blank). Note: Can mean the company has business opertations, manufacturing, will sell to, has sales operations, etc. globally but not indicitive of which one. 
countriesIndicatedStringIf Global Indicator value equals 'Yes' - affirmative tracked countries will be listed here 
descriptionStringCompany description 
phoneStringPhone Number 
addressStringAddress 
iridium
FieldTypeDescriptionSearchable
dunsStringD-U-N-S Number 
idStringIridium's internal ID for the event. 
salesIntelligenceStringFree-form summary of the trigger event and important details. 
leadTypeStringThe type of trigger event being reported on. 
publicationDateDateThe date Iridium reported on the event. 
projectDueDateDateThe expected timetable for the trigger event. 
projectSizeNumberThe square footage associated with the trigger event, if applicable. 
projectValueNumberThe dollar amount associated with the trigger event. 
leadStreetStringThe project location's street address. 
leadCityStringThe project location's city name. 
leadStateStringThe project location's state or province name. 
leadZipStringThe project location's zip or postal code name. 
leadCountyStringThe project location's county name. 
leadCountryStringThe project location's country name. 
leadMsaStringThe project location's 4-digit MSA code. 
leadMsaNameStringThe project location's MSA name. 
companyNameStringThe company's name. 
companyStateStringThe company headquarters state or province name. 
urlStringMain company web address. 
gsaStringWhether the project is a federal government contract. 
oxxford-energy
FieldTypeDescriptionSearchable
dunsStringD-U-N-S Number 
companyNameStringBusiness Name 
stateStringLocation State for the Business 
probableElectricityProviderStringProbable Electric Service Provider - based on historic utility service territories. 
alternateElectrictyProvider1StringElectricity Alternate Potential Provider - based on ability to have multiple service providers. 
alternateElectrictyProvider2StringElectricity Alternate Potential Provider - based on ability to have multiple service providers. 
annualKilowattConsumptionHereNumberEstimated Annual KwH Here - at this business location. 
annualKilowattConsumptionTotalNumberEstimated Annual KwH Total - for entire business family. 
probableGasProviderStringProbable Natural Gas Provider 
annualGasConsumptionHereNumberEstimated British Thermal Gas Consumption DecaTherms Here - at this business locationl. 
annualGasConsumptionTotalNumberEstimated British Thermal Gas Consumption Decatherms Total - for entire business family. 
electricUsageFactorStringElectricity Intensity - energy type and productivity and other variables as factors of cost of goods sold. 
gasUsageFactorStringNatural Gas Intensity - energy type and productivity and other variables as factors of cost of goods sold 
environmentalScoreCardNumberProduct Usage Propensity (PUP) Green Likelihood * Modeled data predicting business' likelihood of participating in 'green' initiatives or likelihood of purchasing environmentally beneficial products and or services. Oxxford has combined eliminated the Y / N indicator for greens, likely, non-greens to a numeric value - higher score equals green and lower indicates brown (non-green). Score of 1 - 4 
deepEnvironmentalScoreNumberPUP Economic Cost of Production. Analyzes energy consumption as a factor of cost-of-goods sold to help determine the positioning of a business for acquiring or purchasing energy efficient products or services. Higher score indicates better prospect. Score of 0 - 10. 
oxxford-financial
FieldTypeDescriptionSearchable
dunsStringD-U-N-S Number 
companyNameStringBusiness Name 
stateStringLocation State for the Business 
businessSweepAccountStringPropensity For a Business to Own or Maintain a Sweep Account -> A=Well above the typical propensity; B=above the norm; C=Centered toward the norm; D=Below the norm; F=Well below the norm; Blank=could not be identified for one or more of the following reasons - sales size, geography, industry, or lack of other criteria 
cashEquivalentHere(000$)NumberEstimated Cash at this Location-- An item on the balance sheet that reports the value of a company's assets that are cash or can be converted into cash immediately. In Thousands 
cashEquivalentTotal(000$)NumberEstimated Cash at Enterprise Level-- An item on the balance sheet that reports the value of a company's assets that are cash or can be converted into cash immediately. In Thousands 
businessSavingsStringPropensity for a Business to Own or Maintain Savings Account -> A=Well above the typical propensity; B=above the norm; C=Centered toward the norm; D=Below the norm; F=Well below the norm; Blank=could not be identified for one or more of the following reasons - sales size, geography, industry, or lack of other criteria 
cDAccountStringPropensity for a Business to Own or Maintain a Business CD -> A=Well above the typical propensity; B=above the norm; C=Centered toward the norm; D=Below the norm; F=Well below the norm; Blank=could not be identified for one or more of the following reasons - sales size, geography, industry, or lack of other criteria 
businessEstimatedLiabilitiesHereNumberEstimated Liabilities at this Location --liabilities include loans, accounts payable, mortgages, deferred revenues and accrued expenses. In Thousands 
businessEstimatedLiabilitiesTotalNumberEstimated Liabilities at Enterprise Level -- liabilities include loans, accounts payable, mortgages, deferred revenues and accrued expenses. In Thousands 
sBAQualificationIndicatorBooleanFlag to identify whether the firm qualifies for SBA Lending given its industry and asset/sales size 
financialInstitutionNameStringNearest financial institution as reported by the FDIC and the NCUA (National Credit Union Association) 
transactionAccount$StringPropensity for a Business to Maintain a Transaction Account -> A=Well above the typical propensity; B=above the norm; C=Centered toward the norm; D=Below the norm; F=Well below the norm; Blank=could not be identified for one or more of the following reasons - sales size, geography, industry, or lack 
commercialLoanStringPropensity for a Business to Maintain a Commercial Loan -> A=Well above the typical propensity; B=above the norm; C=Centered toward the norm; D=Below the norm; F=Well below the norm; Blank=could not be identified for one or more of the following reasons - sales size, geography, industry, or lack of other criteria 
businessCreditCardStringPropensity Business to Maintain Business Credit Cards -> A=Well above the typical propensity; B=above the norm; C=Centered toward the norm; D=Below the norm; F=Well below the norm; Blank=could not be identified for one or more of the following reasons - sales size, geography, industry, or lack of other criteria 
shortTermDebtHere(000$)NumberEstimated Short-Term Debt at Enterprise Level -- comprised of any debt incurred by a company that is due within one year. In Thousands 
shortTermDebtTotal(000$)NumberEstimated Short-Term Debt at this Location -- comprised of any debt incurred by a company that is due within one year. In Thousands 
80NumberEstimated Long-Term Debt at this Location -- include any financing or leasing obligations that are to come due in a greater than 12-month period. In Thousands 
longerTermDebtTotal(000$)NumberEstimated Long-Term Debt at Enterprise Level -- include any financing or leasing obligations that are to come due in a greater than 12-month period. In Thousands 
businessAssetsNumberEstimated Assets at this Location -- assets are either current or fixed (non-current). Current means that the asset will be consumed within one year. Generally, this includes things like cash, accounts receivable and inventory. Fixed assets are those that are expected to keep providing benefit for more than one year, such as equipment, buildings and real estate. In Thousands 
businessNetWorthNumberEstimated Net Worth at this Location -- amount by which assets exceed liabilities. Net worth is a concept applicable to individuals and businesses as a key measure of how much an entity is worth. In Thousands 
equipmentLeasingStringPropensity Equipment Leasing -> A=Well above the typical propensity; B=above the norm; C=Centered toward the norm; D=Below the norm; F=Well below the norm; Blank=could not be identified for one or more of the following reasons - sales size, geography, industry, or lack of other criteria 
lineOfCreditStringPropensity for a Business to Maintain a Business Line of Credit -> A=Well above the typical propensity; B=above the norm; C=Centered toward the norm; D=Below the norm; F=Well below the norm; Blank=could not be identified for one or more of the following reasons - sales size, geography, industry, or lack of other criteria 
longerTermDebtStringPropensity For a Business to Maintain Long-Term Debt -> A=Well above the typical propensity; B=above the norm; C=Centered toward the norm; D=Below the norm; F=Well below the norm; Blank=could not be identified for one or more of the following reasons - sales size, geography, industry, or lack of other criteria (In thousands) 
demandDepositsNumberEstimated Demand Deposits at this Location -- Funds held in an account from which deposited funds can be withdrawn at any time without any advance notice to the depository institution. Demand deposits can be 'demanded by an account holder at any time. 
accountsReceivableNumberEstimated Accounts Receivable at this Location -- Money owed by customers (individuals or corporations) to another entity in exchange for goods or services that have been delivered or used, but not yet paid for. Receivables usually come in the form of operating lines of credit and are usually due within a relatively short time period, ranging from a few days to a year. In Thousands 
accountsPayableNumberEstimated Accounts Payable at this Location -- represents an entity's obligation to pay off a short-term debt to its creditors. In Thousands 
grossMarginNumberEstimated Gross Margin at this Location -- A company's total sales revenue minus its cost of goods sold, In Thousands 
pretaxProfitNumberEstimated Pretax Profit at this Location -- A company's earnings before tax In Thousands 
payrollNumberEstimated Payroll at this Location -- The sum total of all compensation that a business must pay to its employees for a set period of time or on a given date. In Thousands 

Response Codes

Successful requests will return an HTTP 200 response. Otherwise, one of the D&B Direct+ standard response codes will be returned.

This operation may return the following HTTP Status Codes: 

HTTP Status CodeReason
200Success!
400Bad Request
404DUNS (or other resource) not found
500Server error