911 Master PSAP Registry

Federal Communications Commission

@usgov.fcc_gov_911_master_psap_registry

Table List

1 table(467.63 KB)

Table 1

@usgov.fcc_gov_911_master_psap_registry.table_1

467.63 KB
8557 rows
8 columns

psap_id PSAP ID	psap_name PSAP Name	county County	city City	state State	type_of_change_full_text Type Of Change (full Text)	geocode_city_level Geocode City Level
5093	Hamburg Public Safety	Erie	Erie	NY	No Changes have been made.	Erie, NY
445	Hopi Police Department	Navajo		AZ	No Changes have been made.	AZ (34.869712, -111.760902)
2619	Miami County E9-1-1	Miami	Peru	IN	No Changes have been made.	Peru, IN (40.753762, -86.069115)
2321	Markham	Cook	Markham	IL	No Changes have been made.	Markham, IL (41.593513, -87.694621)
2984	Martin County 9-1-1	Martin	Inez	KY	No Changes have been made.	Inez, KY (37.866646, -82.539105)
2266	Hometown Etsb	Cook	Hometown	IL	No Changes have been made.	Hometown, IL (41.73199, -87.73231)
2140	Burnham Police	Cook	Burnham	IL	No Changes have been made.	Burnham, IL (41.641544, -87.541402)
5215	Tioga County 9-1-1	Tioga	Owego	NY	No Changes have been made.	Owego, NY (42.103237, -76.263163)
4972	State Police-gallup	Mckinley	Gallup	NM	No Changes have been made.	Gallup, NM (35.519123, -108.739769)
5475	Parma Police	Ashtabula	Parma	OH	No Changes have been made.	Parma, OH (41.384498, -81.734664)


CREATE TABLE table_1 (
  "psap_id" BIGINT,
  "psap_name" VARCHAR,
  "county" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "type_of_change_full_text" VARCHAR,
  "date_last_modified" TIMESTAMP,
  "geocode_city_level" VARCHAR
);