Basic Information

This collection contains data from the basic information section of each Form 471.

Usage
GET https://data.usac.org/api/sl/form471/v1/basicInformationCollection
 
{
"@odata.context": "$metadata#basicInformationCollection",
"value": [{
"applicantType": "School District",
"applicationNumber": 161003638,
"authorizedAddress1": "WEST HWY 4",
"authorizedAddress2": "",
"authorizedCity": "DAYKIN",
"authorizedEmail": "rkort@meridianmustangs.org",
"authorizedEmployer": "RANDY KORT",
"authorizedLastName": "KORT",
"authorizedPersonMiddleName": " ",
"authorizedPersonName": "RANDY",
"authorizedPhone": "402-446-7265",
"authorizedPhoneExtension": "",
"authorizedState": "NE",
"authorizedTitle": "SUPERINTENDENT",
"authorizedZipcode": "68338",
"authorizedZipcodeExt": " ",
"billedEntityAddress1": "72380 560TH aVE",
"billedEntityAddress2": "",
"billedEntityCity": "Daykin",
"billedEntityEmail": "rkort@meridianmustangs.org",
"billedEntityName": "MERIDIAN PUBLIC SCHOOL DISTRICT",
"billedEntityNumber": "138355",
"billedEntityPhone": "402-446-7265",
"billedEntityPhoneExt": "",
"billedEntityState": "NE",
"billedEntityZipcode": "68338",
"billedEntityZipcodeExt": " ",
"categoryOfService": 1,
"categoryOneDiscountRate": 70,
"categoryTwoDiscountRate": 70,
"certifiedTimestamp": "2016-03-03T23:10:33Z",
"contactEmail": "natalie.brauer@esu5.org",
"contactFirstName": "Natalie",
"contactLastName": "Brauer",
"contactMiddleName": null,
"contactPhone": "402-223-5277",
"contactPhoneExt": "220",
"fccForms471ListedByServiceProvider": "No",
"fccRegistrationNumber": "0012237897",
"fileURL": "",
"formView": "Current",
"fulltimeEnrollment": 218,
"fundingYear": 2016,
"holidayOrSummerContactInformation": "Please contact via email at all times.",
"lastModifiedTimestamp": "2016-03-04T00:10:33Z",
"nickname": "Phone.2016 -Meridian Public Schools",
"nslpCount": 106,
"nslpPercentage": 0.49,
"receivingFundsDirectlyFromServiceProvider": "No",
"status": "Committed",
"totalApplicantNonDiscountShare": 4216.04,
"totalFundingCommitmentRequestAmount": 1806.88,
"totalFundingYearPreDiscountEligibleAmount": 6022.92,
"urbanOrRuralStatus": "Rural",
"voiceDiscountRate": 30,
"windowStatus": "In Window"
}, {
"applicantType": "School",
"applicationNumber": 161003640,
"authorizedAddress1": "296 BOYS RANCH ROAD",
"authorizedAddress2": "",
"authorizedCity": "LAMPE",
"authorizedEmail": "sheila@lucboys.org",
"authorizedEmployer": "Sheila Ortman",
"authorizedLastName": "Ortman",
"authorizedPersonMiddleName": " ",
"authorizedPersonName": "Sheila",
"authorizedPhone": "417-779-5374",
"authorizedPhoneExtension": "106",
"authorizedState": "MO",
"authorizedTitle": "Director of Operations",
"authorizedZipcode": "65681",
"authorizedZipcodeExt": "7205",
"billedEntityAddress1": "296 BOYS RANCH ROAD",
"billedEntityAddress2": "",
"billedEntityCity": "LAMPE",
"billedEntityEmail": "jonathan@lucboys.org",
"billedEntityName": "LUC BOYS SCHOOL",
"billedEntityNumber": "16061043",
"billedEntityPhone": "417-779-5374",
"billedEntityPhoneExt": "127",
"billedEntityState": "MO",
"billedEntityZipcode": "65681",
"billedEntityZipcodeExt": "7205",
"categoryOfService": 1,
"categoryOneDiscountRate": 90,
"categoryTwoDiscountRate": 85,
"certifiedTimestamp": "2016-03-11T23:07:40Z",
"contactEmail": "sheila@lucboys.org",
"contactFirstName": "Sheila",
"contactLastName": "Ortman",
"contactMiddleName": " ",
"contactPhone": "417-779-5374",
"contactPhoneExt": "106",
"fccForms471ListedByServiceProvider": "No",
"fccRegistrationNumber": "0020705885",
"fileURL": "",
"formView": "Current",
"fulltimeEnrollment": 18,
"fundingYear": 2016,
"holidayOrSummerContactInformation": null,
"lastModifiedTimestamp": "2016-05-20T12:45:12Z",
"nickname": "2016-17 Verizon Acceptance x4 National Share 400",
"nslpCount": 18,
"nslpPercentage": 1.0,
"receivingFundsDirectlyFromServiceProvider": "No",
"status": "Committed",
"totalApplicantNonDiscountShare": null,
"totalFundingCommitmentRequestAmount": null,
"totalFundingYearPreDiscountEligibleAmount": null,
"urbanOrRuralStatus": "Rural",
"voiceDiscountRate": 50,
"windowStatus": "In Window"
}]
}
Basic Information Collection Metadata
<EntityType Name="basicInformation">
<Key>
<PropertyRef Name="formView"/>
<PropertyRef Name="applicationNumber"/>
</Key>
<Property Name="applicantType" Type="Edm.String"/>
<Property Name="applicationNumber" Type="Edm.Int32"/>
<Property Name="authorizedAddress1" Type="Edm.String"/>
<Property Name="authorizedAddress2" Type="Edm.String"/>
<Property Name="authorizedCity" Type="Edm.String"/>
<Property Name="authorizedEmail" Type="Edm.String"/>
<Property Name="authorizedEmployer" Type="Edm.String"/>
<Property Name="authorizedLastName" Type="Edm.String"/>
<Property Name="authorizedPersonMiddleName" Type="Edm.String"/>
<Property Name="authorizedPersonName" Type="Edm.String"/>
<Property Name="authorizedPhone" Type="Edm.String"/>
<Property Name="authorizedPhoneExtension" Type="Edm.String"/>
<Property Name="authorizedState" Type="Edm.String"/>
<Property Name="authorizedTitle" Type="Edm.String"/>
<Property Name="authorizedZipcode" Type="Edm.String"/>
<Property Name="authorizedZipcodeExt" Type="Edm.String"/>
<Property Name="billedEntityAddress1" Type="Edm.String"/>
<Property Name="billedEntityAddress2" Type="Edm.String"/>
<Property Name="billedEntityCity" Type="Edm.String"/>
<Property Name="billedEntityEmail" Type="Edm.String"/>
<Property Name="billedEntityName" Type="Edm.String"/>
<Property Name="billedEntityNumber" Type="Edm.String"/>
<Property Name="billedEntityPhone" Type="Edm.String"/>
<Property Name="billedEntityPhoneExt" Type="Edm.String"/>
<Property Name="billedEntityState" Type="Edm.String"/>
<Property Name="billedEntityZipcode" Type="Edm.String"/>
<Property Name="billedEntityZipcodeExt" Type="Edm.String"/>
<Property Name="categoryOfService" Type="Edm.Int32"/>
<Property Name="categoryOneDiscountRate" Type="Edm.Int32"/>
<Property Name="categoryTwoDiscountRate" Type="Edm.Int32"/>
<Property Name="certifiedTimestamp" Type="Edm.DateTimeOffset"/>
<Property Name="contactEmail" Type="Edm.String"/>
<Property Name="contactFirstName" Type="Edm.String"/>
<Property Name="contactLastName" Type="Edm.String"/>
<Property Name="contactMiddleName" Type="Edm.String"/>
<Property Name="contactPhone" Type="Edm.String"/>
<Property Name="contactPhoneExt" Type="Edm.String"/>
<Property Name="fccForms471ListedByServiceProvider" Type="Edm.String"/>
<Property Name="fccRegistrationNumber" Type="Edm.String"/>
<Property Name="fileURL" Type="Edm.String"/>
<Property Name="formView" Type="Edm.String"/>
<Property Name="fulltimeEnrollment" Type="Edm.Int32"/>
<Property Name="fundingYear" Type="Edm.Int32"/>
<Property Name="holidayOrSummerContactInformation" Type="Edm.String"/>
<Property Name="lastModifiedTimestamp" Type="Edm.DateTimeOffset"/>
<Property Name="nickname" Type="Edm.String"/>
<Property Name="nslpCount" Type="Edm.Int32"/>
<Property Name="nslpPercentage" Type="Edm.Double"/>
<Property Name="receivingFundsDirectlyFromServiceProvider" Type="Edm.String"/>
<Property Name="status" Type="Edm.String"/>
<Property Name="totalApplicantNonDiscountShare" Type="Edm.Double"/>
<Property Name="totalFundingCommitmentRequestAmount" Type="Edm.Double"/>
<Property Name="totalFundingYearPreDiscountEligibleAmount" Type="Edm.Double"/>
<Property Name="urbanOrRuralStatus" Type="Edm.String"/>
<Property Name="voiceDiscountRate" Type="Edm.Int32"/>
<Property Name="windowStatus" Type="Edm.String"/>
<NavigationProperty Name="Connectivity" Type="loc.usac.data.sl.form471.v1.connectivityInformation"
Partner="Form471"/>
<NavigationProperty Name="Consultants" Type="loc.usac.data.sl.form471.v1.consultant"
Partner="Form471"/>
<NavigationProperty Name="DiscountCalculations"
Type="Collection(loc.usac.data.sl.form471.v1.discountCalculation)"
Partner="Form471"/>
<NavigationProperty Name="FRNs" Type="Collection(loc.usac.data.sl.form471.v1.frn)"
Partner="Form471"/>
</EntityType>

Data Dictionary

Data Property
Description

applicantType

School district, school, library system, library, or consortium

applicationNumber

Unique number assigned to the FCC Form 471

authorizedAddress1

Authorized Address1

authorizedAddress2

Authorized Address2

authorizedCity

Authorized City

authorizedEmail

Authorized Email

authorizedEmployer

Authorized Employer

authorizedLastName

Authorized Last Name

authorizedPersonMiddleName

Authorized Person Middle Name

authorizedPersonName

Authorized Person Name

authorizedPhone

Authorized Phone

authorizedPhoneExtension

Authorized Phone Extension

authorizedState

Authorized State

authorizedTitle

Authorized Title

authorizedZipcode

Authorized Zip code

authorizedZipcodeExt

Authorized Zip code Ext

billedEntityAddress1

Billed Entity Address1

billedEntityAddress2

Billed Entity Address2

billedEntityCity

Billed Entity City

billedEntityEmail

Billed Entity Email

billedEntityName

Billed Entity Name

billedEntityNumber

Billed Entity Number

billedEntityPhone

Billed Entity Phone

billedEntityPhoneExt

Billed Entity Phone Ext

billedEntityState

Billed Entity State

billedEntityZipcode

Billed Entity Zip code

billedEntityZipcodeExt

Billed Entity Zip code Ext

categoryOfService

Category 1 includes voice and data transmission/internet access services. Category 2 includes internal connections, basic maintenance of internal connections, or managed internal broadband services.

categoryOneDiscountRate

Discount rate applied to category 1 services (except for voice services).

categoryTwoDiscountRate

Discount rate applied to category 2 services.

certifiedTimestamp

Certified Timestamp

contactEmail

Contact Email

contactFirstName

Contact First Name

contactLastName

Contact Last Name

contactMiddleName

Contact Middle Name

contactPhone

Contact Phone

contactPhoneExt

Contact Phone Ext

fccForms471ListedByServiceProvider

Has a Service Provider listed on any of the FCC Forms 471 assisted the applicant in locating funds for the non-discounted share?

fccRegistrationNumber

A 10-digit number that the FCC assigns to a business or individual that registers with the FCC. It is associated with an entity’s Taxpayer Identification Number (TIN) and is required before filing FCC Forms 499-A/Q.

fileUrl

Link to the Form 471 PDF

formView

indicates if the form is the Original or Current version

fulltimeEnrollment

Fulltime Enrollment

fundingYear

Funding Year associated with the FCC Form 471

holidayOrSummerContactInformation

Holiday/Summer Contact Information

lastModifiedTimestamp

Date and time that the form was last updated

nickname

Name entered by applicant for the FCC Form 471

nslpCount

NSLP Count

nslpPercentage

NSLP Percentage

receivingFundsDirectlyFromServiceProvider

Is applicant receiving any of the funds directly from a Service Provider ?

status

Status of the FCC Form 471 (e.g. certified)

totalApplicantNonDiscountShare

Amount applicant is expected to pay.

totalFundingCommitmentRequestAmount

Amount requested for FCC Form 471.

totalFundingYearPreDiscountEligibleAmount

Amount requested prior to discount.

urbanOrRuralStatus

Urban/rural status of the billed entity for the purposes of calculating discounts.

voiceDiscountRate

Discount rate applied to voice services.

windowStatus

Indicates if window has been certified