About this Dataset

LinkNYC Kiosk Status (Archived)

This dataset provides a historical listing of LinkNYC Kiosks, their location, and the status of the Link’s wifi, tablet, and phone. To view the current days status on it own, visit the LinkNYC Kiosk Status dataset at the following link (https://data.cityofnewyork.us/City-Government/LinkNYC-Kiosk-Status/n6c5-95xh)
.
LinkNYC is a first-of-its-kind communications network that will bring the fastest available free public Wi-Fi to millions of New Yorkers, small businesses, and visitors. Built at no cost to taxpayers, the five-borough LinkNYC network will, through advertising proceeds, generate more than $500 million in revenue for the City over the initiative’s first 12 years. Granted a franchise by the City in 2014, CityBridge will administer construction of the LinkNYC network.
By replacing the aging network of public pay telephones with state-of-the-art Links, CityBridge will transform the physical streetscape, enhance New Yorkers’ access to information, and create new local jobs for the development, servicing and maintenance of the structures.
Organization: City of New York
Last updated: 2020-11-10T17:01:24.205583
Tags: broadband, citybridge, department-of-information-technology-and-telecommunications, doitt, intersection, kiosk, link, linknyc, linknyc-kiosk-status-historical, payphones, technology, wi-fi, wifi

Tables

Table 1

@usgov.city_of_new_york_linknyc_kiosk_status_archived.table_1

4.72 MB
288199 rows
25 columns


CREATE TABLE table_1 (
  "unique_id" VARCHAR,
  "publish_date" VARCHAR,
  "site_id" VARCHAR,
  "status" VARCHAR,
  "ppt_id" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" BIGINT,
  "boro" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "cross_street_1" VARCHAR,
  "cross_street_2" VARCHAR,
  "corner" VARCHAR,
  "install_date" VARCHAR,
  "active_date" VARCHAR,
  "wifi_status" VARCHAR,
  "tablet_status" VARCHAR,
  "phone_status" VARCHAR,
  "community_board" DOUBLE,
  "council_district" DOUBLE,
  "census_tract" DOUBLE,
  "nta" VARCHAR,
  "nta_name" VARCHAR
);