From a 500-row sample across 19 columns.
zip_codezip_codeHas zip codes (`zip_code`) — joinable, but needs boundary shapes to draw.
| subway_line_used_most_often | use_of_subway_frequency | get_to_subway_via | primary_use_of_subway | average_length_subway_ride | overall_satisfaction | frequency_of_delays | approximate_delay_duration | alternative_transport | frequency_of_rerouting | top_three_complaints | most_common_reason_for_delay |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Once a week | Bus | Work | 20 - 40 min | Neutral | A few times a week | 10 - 20 min | Wait for next train | NA |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
subway_line_used_most_often | text | Survey Question: Which subway line do you use most often? | 0% | 1RA |
use_of_subway_frequency | categorical | Survey Question: How frequently do you use the subway? | 0% | Everyday / Almost everyd…More than once a week, v…Weekdays, Mon - Friof 9 |
get_to_subway_via | categorical | Survey Question: How do you get to the subway? | 0% | WalkBusNAof 12 |
primary_use_of_subway | categorical | Survey Question: What is the primary reason you use the subway? | 0% |
GET /api/datasets/4y8i-pbvd GET /api/datasets/4y8i-pbvd/quality GET /api/datasets/4y8i-pbvd/related GET /api/columns?dataset=4y8i-pbvd
| ['Delays', 'Crime / Safety', 'Station infrastructure'] |
| Waiting for signal change |
| E | Weekdays, Mon - Fri | Walk | Work | 40 - 60 min | Not satisfied | A few times a week | 10 - 20 min | Use another train | All the time | ['Delays', 'Frequent route changes', 'High fares'] | Train traffic |
| F | Once a month | Bus | Other | 40 - 60 min | Very satisfied | A few times a week | 20 - 45 min | Wait for next train | Only at night | ['Delays'] | Train traffic |
| 7 | Weekdays, Mon - Fri | Walk | Work | < 20 min | Very satisfied | Everyday | 10 - 20 min | Walk | Almost never | NA | Waiting for signal change |
| E | Weekdays, Mon - Fri | Bus | School | 20 - 40 min | Somewhat satisfied | A few times a week | 10 - 20 min | Wait for next train | Almost never | ['Delays', 'Old trains', 'Overcrowded trains'] | Train traffic |
| 1 | Everyday / Almost everyday | Walk | Work | 40 - 60 min | Not satisfied | A few times a week | 5 - 10 min | For-hire vehicle | All the time | ['Delays', 'High fares', 'Lack of handicap access'] | Train traffic |
| 1 | Everyday / Almost everyday | Walk | Work | 40 - 60 min | Not satisfied | A few times a week | 5 - 10 min | For-hire vehicle | All the time | ['Delays', 'High fares', 'Lack of handicap access'] | Train traffic |
| 1 | ~5 days per week | Walk | Work | 40 - 60 min | Neutral | Everyday | 10 - 20 min | Use another train | Only on weekends | ['Delays', 'High fares', 'Station infrastructure'] | Waiting for signal change |
| R | Everyday / Almost everyday | Walk | Work | 20 - 40 min | Highly unsatisfied | Everyday | 20 - 45 min | Use another train | All the time | ['Delays', 'Frequent route changes', 'Overcrowded trains'] | Train traffic |
| 1 | More than once a week, varies | Walk | Work | 60 - 90 min | Somewhat satisfied | Everyday | 20 - 45 min | Wait for next train | All the time | ['Delays', 'Frequent route changes', 'Customer service'] | Signal malfunction |
Showing 12 of 19 columns. All of them are listed below.
WorkOtherNAof 4 |
average_length_subway_ride | categorical | Survey Question: What is the average length of your subway ride? | 0% | 20 - 40 min40 - 60 min< 20 minof 6 |
overall_satisfaction | categorical | Survey Question: How satisfied are you with the subway service? | 0% | Not satisfiedHighly unsatisfiedSomewhat satisfiedof 6 |
frequency_of_delays | categorical | Survey Question: How frequently do you experience subway delays? | 0% | A few times a weekEverydayRarelyof 6 |
approximate_delay_duration | categorical | Survey Question: If you experience delays, approximately how long are you delayed? | 0% | 10 - 20 min5 - 10 min20 - 45 minof 6 |
alternative_transport | categorical | Survey Question: If you experience a delay greater than 15 minutes, while waiting for a train are you likely to…? | 0% | Wait for next trainUse another trainFor-hire vehicleof 7 |
frequency_of_rerouting | categorical | Survey Question: How frequently do you experience service changes/re-routing? | 0% | Only on weekendsAll the timeAlmost neverof 5 |
top_three_complaints | text | Survey Question: What are your concerns or complaints about transit service? | 0% | ['Delays', 'Frequent rou…['Delays', 'High fares',…['Delays', 'Station infr… |
most_common_reason_for_delay | categorical | Survey Question: If you are delayed on a train, what is the most common reason given by a conductor? | 0% | Train trafficSignal malfunctionNo reason is givenof 8 |
is_subway_affordable | boolean | Survey Question: At its current rate do you feel the subway is affordable | 0% | TrueFalseof 2 |
opinion_on_increased_fares | categorical | Survey Question: What do you think about the fare increases being proposed by the MTA? | 0% | PositiveNegativeNeutralof 6 |
submitted_at | date | Time and date of submission | 0% | 01/08/2019 @ 05:09 PM01/08/2019 @ 05:03 PM01/08/2019 @ 05:04 PM |
survey_stop_borough | categorical | If the survey was collected in person, the borough in which the survey was conducted | 0% | NABrooklynManhattanof 6 |
survey_stop_location | text | If the survey was collected in person, the name of the subway station at which the survey was filled in. | 0% | NASt. George Ferry Termina…Jackson Heights / Roosev… |
zip_code | text | The zip code of the respondent | 0% | NA1120910011 |
collection_method | categorical | How the survey response was collected | 0% | onlinein personof 2 |