E-Rate Open Competitive Bidding: Basic Information (FCC Form 470 and Related Information)

datahub.usac.org | Last Updated 21 Jul 2022

This dataset contains information from the basic information section of each FCC Form 470, including applicant details such as contact information, application number, Billed Entity Number (BEN), and funding year, and related information from the E-Rate Productivity Center (EPC).

Tags: schools, libraries, schools & libraries, schools and libraries, sld, e-rate, erate, e rate, form 470, 470, basic information, applicant information, applicant, applicant contact information, usac, broadband, usf, universal service fund

This dataset has the following 70 columns:

Column Name	API Column Name	Data Type	Description
Application Number	application_number	text	Unique application number generated at the time applicants begin to file the FCC Form 470. Applicants can request funding for multiple services under the same application number.
Form Nickname	form_nickname	text	Nickname given to an application by an applicant when filling their FCC Form 470.
Form PDF	f470_number	url	Link to download the original submitted FCC Form 470 as a PDF.
Funding Year	funding_year	text	Funding year for the FCC Form 470.
FCC Form 470 Status	f470_status	text	Current status of the FCC Form 470.
Allowable Contract Date	allowable_contract_date	calendar_date	Earliest date on which an applicant can sign a contract for contracted services or enter into an arrangement for tariffed (T) or month to-month (MTM) services with a service provider is 28 days after the certified date.
Created Date/Time	created_datetime	calendar_date	Exact date and time the FCC Form 470 was created (EST).
Created By	created_by	text	Name of the person who created the FCC Form 470.
Certified Date/Time	certified_datetime	calendar_date	Exact date and time the FCC Form 470 was certified (EST).
Certified By	certified_by	text	The person who certified the FCC Form 470.
Last Modified Date/Time	last_modified_datetime	calendar_date	Exact date and time the FCC Form 470 was last modified (EST).
Last Modified By	last_modified_by	text	Name of the person who last modified the FCC Form 470.
Billed Entity Number	ben	text	Unique billed entity number (BEN) associated with the entity name on the FCC Form 470.
Billed Entity Name	billed_entity_name	text	Name of the billed entity.
Organization Status	organization_status	text	Indicates if the organization is active (open) or closed.
Organization Type	organization_type	text	The type of the entity including school district, school, library system, library, consortium, and non-instructional facility (NIF).
Applicant Type	applicant_type	text	Applicant type including: school, school district, library, library system, or consortium.
Website URL	website_url	text	Website for the billed entity.
Latitude	latitude	number	Latitude of the applicant.
Longitude	longitude	number	Longitude of the applicant.
Billed Entity FCC Registration Number	ben_fcc_registration_number	text	Unique 10-digit number assigned by the FCC to a business or individual that registers with the FCC.
Billed Entity Address 1	billed_entity_address1	text	Applicant street address line 1.
Billed Entity Address 2	billed_entity_address2	text	Applicant street address line 2.
Billed Entity City	billed_entity_city	text	Applicant city.
Billed Entity State	billed_entity_state	text	Applicant state.
Billed Entity Zip Code	billed_entity_zip	text	Applicant zip code.
Billed Entity Zip Code Ext	billed_entity_zip_ext	text	Applicant zip code extension.
Billed Entity Email	billed_entity_email	text	Applicant email address.
Billed Entity Phone	billed_entity_phone	text	Applicant phone number.
Billed Entity Phone Ext	billed_entity_phone_ext	text	Applicant phone number extension.
Number of Eligible Entities	number_of_eligible_entities	number	Number of entities eligible for the services requested through an FCC Form 470.
Contact Name	contact_name	text	Name of the main contact provided by the applicant on the FCC Form 470.
Contact Address 1	contact_address1	text	Street address line 1 for the application’s main contact.
Contact Address 2	contact_address2	text	Street address line 2 for the application’s main contact.
Contact City	contact_city	text	City of the application’s main contact.
Contact State	contact_state	text	State of the application’s main contact.
Contact Zip	contact_zip	text	Zip code of the application’s main contact.
Contact Zip Ext	contact_zip_ext	text	Zip code extension of the application’s main contact.
Contact Phone	contact_phone	text	Phone number of the application’s main contact.
Contact Phone Ext	contact_phone_ext	text	Phone number extension of the application’s main contact.
Contact Email	contact_email	text	Email address of the main contact. This contact is used as the first point of contact through the funding request process.
Technical Contact Name	technical_contact_name	text	Name of the technical contact provided by the applicant of the FCC Form 470.
Technical Contact Title	technical_contact_title	text	Title of the technical contact provided by the applicant on the FCC Form 470.
Technical Contact Phone	technical_contact_phone	text	Phone number of the technical contact provided by the applicant on the FCC Form 470.
Technical Contact Phone Ext	technical_contact_phone_ext	text	Phone extension of the technical contact provided by the applicant of the FCC Form 470.
Technical Contact Email	technical_contact_email	text	Email address of the technical contact provided by the applicant of the FCC Form 470.
Authorized Person Name	authorized_person_name	text	Name of the person authorized to certify the FCC Form 470.
Authorized Person Address	authorized_person_address	text	Address of the person authorized to certify the FCC Form 470.
Authorized Person City	authorized_person_city	text	City of the person authorized to certify the FCC Form 470.
Authorized Person State	authorized_person_state	text	State of the person authorized to certify the FCC Form 470.
Authorized Person Zip	authorized_person_zip	text	Zip code of the person authorized to certify the FCC Form 470.
Authorized Person Zip Ext	authorized_person_zip_ext	text	Zip code extension of the person authorized to certify the FCC Form 470.
Authorized Person Phone Number	authorized_person_phone	text	Phone number of the person authorized to certify the FCC Form 470.
Authorized Person Phone Number Ext	authorized_person_phone_ext	text	Phone extension of the person authorized to certify the FCC Form 470.
Authorized Person Email	authorized_person_email	text	Email address of the person authorized to certify the FCC Form 470.
Authorized Person Title	authorized_person_title	text	Title of the person authorized to certify the FCC Form 470.
Authorized Person Employer	authorized_person_employer	text	Employer of the person authorized to certify the FCC Form 470.
Category One Description	category_one_description	text	Description of Category One services (Internet Access and/or Telecommunications) the applicant seeks discounts for.
Category Two Description	category_two_description	text	Description of Category Two services (Internal Connections, Basic Maintenance of Internal Connections, or Managed Internal Broadband Services) the applicant seeks discounts for.
Installment Type	installment_type	text	Applicant can choose to use an installment payment plan for the non-discounted portion of any special construction charges associated with the request.
Installment Min Range Years	installment_min_range_years	number	Minimum number of years over which the applicant will amortize the costs.
Installment Max Range Years	installment_max_range_years	number	Maximum number of years over which the applicant will amortize the costs.
Request for Proposal Identifier	rfp_identifier	text	Indicates whether a Request for Proposal (RFP) document was provided for the services requested.
State or Local Restrictions	state_or_local_restrictions	text	Indicates if there are state or local procurement or competitive bidding requirements that apply to the procurement of services sought by the applicant.
State or Local Restrictions Description	state_or_local_restrictions_description	text	Indicates if there are state or local procurement or competitive bidding requirements that apply to the applicant’s procurement of services.
Statewide State	statewide_state	text	Indicates that the FCC Form 470 is for the entire state.
All Public Schools Districts	all_public_schools_districts	text	Indicates that all public schools/districts in the state are included for the FCC Form 470.
All Non-Public schools	all_non_public_schools	text	Indicates that all non-public schools in the state are included for the FCC Form 470.
All Libraries	all_libraries	text	Indicates that all libraries in the state are included for the FCC Form 470.
Form Version	form_version	text	Indicates whether the form version of the application is "current" or "original." It can be used to aggregate the data between current and original applications. "Current" is the view of the form processed by USAC. "Original" is the view of the form originally submitted by the applicant upon certification.