Historical fare data for Edmonton Transit System (ETS).
This dataset has the following 24 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| Effective Date | effective_date | calendar_date | The date on which the fares became effective. | 2018-02-01T00:00:00.000 2009-02-01T00:00:00.000 2007-02-01T00:00:00.000 2008-02-01T00:00:00.000 2019-02-01T00:00:00.000 view top 100 |
| Current Row | current_effdt | checkbox | If the Effective Date value is the greatest available value that is less than or equal to the date on which this dataset was last updated, then the value of this column will be TRUE. This enables easy filtering to just the currently effective fare information. | true view top 100 |
| Cash | cash | number | Adult cash fare (ages 25-64). | 3.25 3.20 2.50 3.50 2.75 view top 100 |
| Youth/Senior Cash | youth_senior_cash | number | Cash fare for youth (24 and under) and senior (65+). | 2.25 1.75 2.00 view top 100 |
| Adult Tickets (10) | adult_tickets_10 | number | Book of ten (10) adult tickets. | 21.00 24.00 22.80 27.00 18.50 view top 100 |
| Adult Tickets (20) | adult_tickets_20 | number | Book of twenty (20) adult tickets. | 42.00 view top 100 |
| Youth/Senior Tickets (10) | youth_senior_tickets_10 | number | Book of ten (10) youth/senior tickets. | 21.00 18.50 19.00 19.95 23.00 view top 100 |
| Adult Monthly Pass | adult_monthly_pass | number | Adult monthly pass (ages 25-64). | 97.00 89.00 59.00 84.65 66.50 view top 100 |
| DATS Monthly Pass | dats_monthly_pass | number | 89.00 84.65 74.25 66.50 91.50 view top 100 | |
| Seniors Monthly Pass | seniors_monthly_pass | number | Senior monthly pass (65+). | 14.00 11.00 34.00 13.00 15.00 view top 100 |
| Youth Monthly Pass | youth_monthly_pass | number | Youth monthly pass (24 and under). | 69.00 42.00 75.00 65.55 73.00 view top 100 |
| Senior Annual Pass | senior_annual_pass | number | Senior annual pass (65+). | 105.00 125.00 374.00 121.50 111.00 view top 100 |
| Senior Low Income Annual Pass | senior_low_income_annual | number | Senior annual pass (65+) for those with an income level within a specific range. | 54.00 45.00 136.50 49.50 46.50 view top 100 |
| Post Secondary Monthly Pass | post_secondary_monthly_pass | number | (transitioning to Youth Pass in September 2020) | 54.00 81.00 76.95 88.50 67.50 view top 100 |
| Day Pass | day_pass | number | 9.00 10.00 7.50 8.55 9.25 view top 100 | |
| AISH Monthly Pass | aish_monthly_pass | number | 29.00 35.00 33.00 32.00 30.00 view top 100 | |
| Low-Income Pass | low_income_pass | number | 35.00 view top 100 | |
| U-PASS (winter) | u_pass_winter | number | U-Pass provides eligible students at participating institutions unlimited travel on ETS and participating regional providers. | 170.00 94.50 155.00 90.00 162.50 view top 100 |
| U-PASS (summer) | u_pass_summer | number | U-Pass provides eligible students at participating institutions unlimited travel on ETS and participating regional providers. | 170.00 162.50 147.50 155.00 125.00 view top 100 |
| U-PASS (fall) | u_pass_fall | number | U-Pass provides eligible students at participating institutions unlimited travel on ETS and participating regional providers. | 170.00 94.50 155.00 162.50 147.50 view top 100 |
| ETS@Work | ets_work | number | In partnership with Edmonton employers, the ETS@Work program provides employees with a monthly discount up to 24% off the cost of a regular adult monthly pass, plus further eligibility for a federal tax credit. | 78.40 74.50 71.72 82.94 80.50 view top 100 |
| Airport Cash | airport_cash | number | One-way ticket on route 747: Cash fare. | 5.00 10.00 view top 100 |
| Airport Tickets (adult only) | airport_tickets_adult_only | text | One-way ticket on route 747: Unused adult tickets. | 2 tickets view top 100 |
| Airport Monthly Pass RTE 747 Only | airport_monthly_pass_rte | number | Monthly pass for route 747 only. | 100.00 view top 100 |