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.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"cityofnewyork-us/linknyc-kiosk-status-archived-8s5k-n45n\".\"linknyc_kiosk_status_archived\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.