From a 500-row sample across 35 columns.
generated_onstatuscorner+35statuscornercensus_tract+19statecityMappable — Socrata point column `geocoded_column`.
Open on the map →| generated_on | site_id | status | kiosk_type | ppt_id | address | city | state | zip | boro | latitude | longitude |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2025-01-15 11:00:00.381 | qu-03-gf44819 | Activation | Link 5G | GF44819 | 75-20 ASTORIA BOULEVARD | Queens | NY | 11370 | Queens | 40.7642912 | -73.8948328 |
| 2024-09-26 11:00:00.475 | bx-06-146096 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
generated_on | datetime | Indicates the date and hour the entry was generated on. All entries in a batch will contain the same generated_on stamp. | 0% | 2026-09-11 12:00:00.5362024-02-27 08:00:00.7542024-01-24 10:00:00.747 |
site_id | text | The LinkNYC Kiosk's unique identification number. The Site ID includes the borough, community district, and PPT ID. | 0% | mn-12-120736mn-04-122580mn-03-137382 |
status | categorical | Status of LinkNYC Kiosk location. | 0% | LiveRepairInstalledof 4 |
kiosk_type | categorical | The data describes the type of kiosk being proposed. | 0% |
GET /api/datasets/n6c5-95xh GET /api/datasets/n6c5-95xh/quality GET /api/datasets/n6c5-95xh/related GET /api/columns?dataset=n6c5-95xh
census_tractcouncil_districtlatitude+12census_tractcouncil_districtlatitude+9statuscensus_tractcouncil_district+9binstatezip+2| Repair |
| Link 1.0 |
| 146096 |
| 4201 3 AVENUE |
| Bronx |
| NY |
| 10457 |
| Bronx |
| 40.84647676 |
| -73.89639316 |
| 2024-03-13 09:00:00.978 | bk-01-gf34839 | Installed | Link 5G | GF34839 | 135 HAVEMEYER STREET | Brooklyn | NY | 11211 | Brooklyn | 40.712112 | -73.9571476 |
| 2024-05-24 09:00:00.683 | bk-16-gf34731 | Installed | Link 1.0 | GF34731 | 121 LIBERTY AVENUE | Brooklyn | NY | 11212 | Brooklyn | 40.6732003 | -73.9058603 |
| 2024-01-24 10:00:00.747 | mn-12-gf0841 | Installed | Link 1.0 | GF0841 | 4119 BROADWAY | Manhattan | NY | 10033 | Manhattan | 40.8455391 | -73.9388995 |
| 2024-04-25 10:00:00.917 | bk-16-gf34727 | Installed | Link 1.0 | GF34727 | 656 HOWARD AVENUE | Brooklyn | NY | 11212 | Brooklyn | 40.6658969 | -73.9196083 |
| 2024-03-21 09:00:00.975 | qu-03-gf44729 | Installed | Link 5G | GF44729 | 81-20 NORTHERN BOULEVARD | Queens | NY | 11372 | Queens | 40.7554275 | -73.8855911 |
| 2024-02-13 10:00:00.687 | bk-06-gf34903 | Installed | Link 5G | GF34903 | 84 BEARD STREET | Brooklyn | NY | 11231 | Brooklyn | 40.6741868 | -74.0136956 |
| 2024-03-14 09:00:00.859 | qu-10-gf44812 | Installed | Link 5G | GF44812 | 133-40 131 STREET | Queens | NY | 11420 | Queens | 40.6682571 | -73.8079134 |
| 2024-03-14 17:00:00.862 | bk-04-gf34578 | Installed | Link 5G | GF34578 | 908 FLUSHING AVENUE | Brooklyn | NY | 11206 | Brooklyn | 40.7021363 | -73.9353242 |
Showing 12 of 35 columns. All of them are listed below.
Link 1.0Link 5Gof 2 |
ppt_id | text | The ID number associated with the permit to operate public pay telephone service. The PPT ID is the same as the ID for the public pay telephone the Link kiosk replaced. New sites that don’t replace pay telephones receive new PPT IDs. | 0% | 123260121579145852 |
address | text | The street associated with a building's street address and the name of the street that a site is located on. | 0% | 80-51 261 STREET85-15 258 STREET264-21 UNION TURNPIKE |
city | categorical | Location in New York City | 0% | ManhattanQueensBrooklynof 6 |
state | categorical | New York State | 0% | NYnullof 2 |
zip | text | Five (5) digit postal code assigned by the United States Postal Service. | 0% | 100251001610022 |
boro | categorical | The New York City borough where the LinkNYC kiosks are located. | 0% | ManhattanQueensBrooklynof 5 |
latitude | coordinate | Points that fall North or South of the Equator, expressed in degrees. | 0% | 40.749294640.769685740.6654168 |
longitude | coordinate | Points that fall East or West of the Prime Meridian, expressed in degrees. | 0% | -73.9213909-73.8960033-73.7094328 |
cross_street_1 | text | One of the closest streets to a potential LinkNYC site. | 0% | BROADWAY3 AVENUEMADISON AVENUE |
cross_street_2 | text | One of the closest streets to a potential LinkNYC site. | 0% | LEXINGTON AVENUEPARK AVENUEAMSTERDAM AVENUE |
corner | categorical | The direction the LinkNYC Kiosk is facing. | 0% | SESWNEof 10 |
community_board | text | Community Board: An appointed advisory group from a variety of districts throughout NYC's five boroughs. They deal with issues such as zoning, land usage, and any other matter related to the quality of life of their residents. | 0% | 106107105 |
council_district | text | Council District is the lawmaking body of the City of New York. There are 51 districts throughout NYC's five boroughs. | 0% | 432 |
census_tract | text | Permanent statistical subdivisions to provide a stable set of geographic units for the presentation of statistical data. | 0% | 100400010153001006600 |
nta | text | Neighborhood identifiers to differentiate NYC's five boroughs | 0% | Upper West SideMidtown-Midtown SouthTurtle Bay-East Midtown |
bbl | text | Every real estate property is identified by a set of 3 numbers for taxes, zoning, construction, and other purposes. | 0% | null10114075014087170001 |
bin | text | Every real estate property has an assigned 7-digit number issued by the Department of City Planning. | 1% | null30000001000000 |
install_date | datetime | Date of LinkNYC was physically installed. | 0% | 2017-09-22 20:00:00.0002017-03-10 19:00:00.0002017-10-27 20:00:00.000 |
active_date | datetime | Date of LinkNYC was physically activated. | 3% | 2016-07-18 20:00:00.0002016-07-20 20:00:00.0002018-05-16 20:00:00.000 |
wifi_status | categorical | Enumerated value of ‘up’ or ‘down’ indicating last status of link’s Wi-Fi connection. The value 'null' will be assigned if link is not activated. | 0% | upnullof 2 |
wifi_status_date | datetime | Indicates date and time for last WIFI status metric. The value 'no poll' will be assigned if link is not activated or no status has been retrieved within last hour. | 0% | 2026-09-11 08:00:00.545null2026-04-23 12:00:00.894of 11 |
tablet_status | categorical | Enumerated value of ‘up’ or ‘down’ indicating last status of link’s tablet. The value 'null' will be assigned if link is not activated. | 0% | upnulldownof 3 |
tablet_status_date | datetime | Indicates date and time for last tablet status metric. The value 'no poll' will be assigned if link is not activated or no status has been retrieved within last hour. | 0% | 2026-09-11 12:00:00.536null2024-11-11 10:00:00.481of 7 |
phone_status | categorical | Enumerated value of ‘up’ or ‘down’ indicating last status of link’s dialer. The value 'null' will be assigned if link is not activated. | 0% | upnulldownof 3 |
phone_status_date | datetime | Indicates date and time for last dialer status metric. The value 'no poll' will be assigned if link is not activated or no status has been retrieved within last hour. | 0% | 2026-09-11 12:00:00.536null2024-11-11 10:00:00.481of 7 |
geocoded_column | coordinate | — | — | — |