About this Dataset

LinkNYC Kiosk Status

This dataset provides the most current listing of LinkNYC Kiosks, their location, and the status of the Link’s wifi, tablet, and phone.
Organization: City of New York
Last updated: 2020-11-10T17:04:20.734050
Tags: broadband, citybridge, department-of-information-technology-and-telecommunications, doitt, intersection, kiosk, linknyc-kiosk-status, payphones, technology, wi-fi, wifi

Tables

Table 1

@usgov.city_of_new_york_linknyc_kiosk_status.table_1

241.25 kB
2,306 rows
30 columns

CREATE TABLE table_1 (
  "generated_on" TIMESTAMP,
  "site_id" VARCHAR,
  "status" VARCHAR,
  "planned_kiosk_type" VARCHAR,
  "ppt_id" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "postcode" BIGINT,
  "borough" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "cross_street_1" VARCHAR,
  "cross_street_2" VARCHAR,
  "corner_location" VARCHAR,
  "community_board" BIGINT,
  "council_district" VARCHAR,
  "census_tract" VARCHAR,
  "nta" VARCHAR,
  "bbl" VARCHAR,
  "bin" VARCHAR,
  "installation_date" TIMESTAMP,
  "activation_date" TIMESTAMP,
  "wifi_status" VARCHAR,
  "wifi_last_ts" VARCHAR,
  "tablet_status" VARCHAR,
  "tablet_last_ts" VARCHAR,
  "phone_status" VARCHAR,
  "dialer_last_ts" VARCHAR,
  "location" VARCHAR
);