Consultants

This collection contains data about consultants listed within each Form 471.

Usage
GET https://data.usac.org/api/sl/form471/v1/consultantCollection
 
{
"@odata.context": "$metadata#consultantCollection",
"value": [{
"applicationNumber": 161000011,
"ben": "13215",
"billedEntityName": "CLEARY SCHOOL FOR THE DEAF",
"city": "Westbury",
"consultantRegistrationNumber": "16060891",
"contactEmail": "sbratton@e-ratecentral.com",
"email": "whimsworth@e-ratecentral.com",
"formView": "Current",
"name": "E-Rate Central",
"phoneNumber": "516-801-7800",
"phoneNumberExtension": "",
"state": "NY",
"zipCode": "11590"
}, {
"applicationNumber": 161000111,
"ben": "140817",
"billedEntityName": "CENTRAL HEIGHTS INDEP SCH DIST",
"city": "Nacogdoches",
"consultantRegistrationNumber": "16081740",
"contactEmail": "martha.labbit@suddenlink.net",
"email": "martha.labbit@suddenlink.net",
"formView": "Current",
"name": "Educational Planners, Inc.",
"phoneNumber": "936-560-4162",
"phoneNumberExtension": "",
"state": "TX",
"zipCode": "75965"
}]
}
Basic Information Collection Metadata
<EntityType Name="consultant">
<Key>
<PropertyRef Name="formView"/>
<PropertyRef Name="applicationNumber"/>
<PropertyRef Name="consultantRegistrationNumber"/>
</Key>
<Property Name="applicationNumber" Type="Edm.Int32"/>
<Property Name="ben" Type="Edm.String"/>
<Property Name="billedEntityName" Type="Edm.String"/>
<Property Name="city" Type="Edm.String"/>
<Property Name="consultantRegistrationNumber" Type="Edm.String"/>
<Property Name="contactEmail" Type="Edm.String"/>
<Property Name="email" Type="Edm.String"/>
<Property Name="formView" Type="Edm.String"/>
<Property Name="name" Type="Edm.String"/>
<Property Name="phoneNumber" Type="Edm.String"/>
<Property Name="phoneNumberExtension" Type="Edm.String"/>
<Property Name="state" Type="Edm.String"/>
<Property Name="zipCode" Type="Edm.String"/>
<NavigationProperty Name="Form471" Type="loc.usac.data.sl.form471.v1.basicInformation">
<ReferentialConstraint Property="formView" ReferencedProperty="formView"/>
<ReferentialConstraint Property="applicationNumber" ReferencedProperty="applicationNumber"/>
</NavigationProperty>
</EntityType>

Data Dictionary

Data Property
Description

applicationNumber

Unique number assigned to the FCC Form 471

ben

Billed Entity Number

billedEntityName

The name of the Billed Entity

city

Consulting firm's city

consultantRegsitrationNumber

Unique number assigned to the consulting firm

contactEmail

Contact Email

email

Consulting firm's email

formView

indicates if the form is the Original or Current version

name

Consulting firm name

phoneNumber

Consulting firm's phone number

phoneNumberExtension

Consulting firm's phone number extension

state

Consulting firm's state

zipCode

Consulting firm's zip code