Basic Information
This collection contains data from the basic information section of each Form 471.
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" }]}<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 |