From a 500-row sample across 8 columns.
license_numberagent_numberlicense_numberagent_numberlicense_numberlicense_number| license_number | agent_number | hackup_payment_amount | operational_payment_amount | total_payment_amount | payment_date | last_date_updated | last_time_updated |
|---|---|---|---|---|---|---|---|
| 9H72 | A0113 | $0.00 | $1,000.00 | $1,000.00 | 2020-02-07T00:00:00.000 | 2026-10-10T00:00:00.000 | 18:00:07 |
| 8J70 | — | $0.00 | $1,000.00 | $1,000.00 | 2022-09-07T00:00:00.000 | 2026-10-10T00:00:00.000 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
license_number | text | The four character letter/number combination that identifies a unique taxi medallion. | 0% | 2G979P877Y86 |
agent_number | text | The five character letter/number combination that identifies the unique agent that manages the listed medallion. Agent numbers are only listed if the agent is receiving TIF payments for the listed medallion. | 48% | A0307A0253A0358 |
hackup_payment_amount | categorical | The payment the owner or agent received, following successful hackup of a WAV vehicle, during this payment period. | 0% | $0.00$14,000.00$15,333.33of 8 |
operational_payment_amount | text | The sum of all $1,333 payments, each of which follows a successful tri-annual inspection, the owner or agent received during this payment period. |
GET /api/datasets/ht4t-wzcm GET /api/datasets/ht4t-wzcm/quality GET /api/datasets/ht4t-wzcm/related GET /api/columns?dataset=ht4t-wzcm
license_numberlast_date_updatedlast_time_updated| 18:00:07 |
| 9M55 | A0304 | $0.00 | $1,333.33 | $1,333.33 | 2017-11-17T00:00:00.000 | 2026-10-10T00:00:00.000 | 18:00:07 |
| 6J71 | A0253 | $0.00 | $1,333.33 | $1,333.33 | 2018-10-31T00:00:00.000 | 2026-10-10T00:00:00.000 | 18:00:07 |
| 9K12 | A0307 | $0.00 | $1,000.00 | $1,000.00 | 2019-05-21T00:00:00.000 | 2026-10-10T00:00:00.000 | 18:00:07 |
| 4K89 | A0105 | $0.00 | $1,333.33 | $1,333.33 | 2017-04-28T00:00:00.000 | 2026-10-10T00:00:00.000 | 18:00:07 |
| 7F39 | — | $0.00 | $1,000.00 | $1,000.00 | 2019-07-30T00:00:00.000 | 2026-10-10T00:00:00.000 | 18:00:07 |
| 7H31 | A0312 | $0.00 | $1,000.00 | $1,000.00 | 2020-07-23T00:00:00.000 | 2026-10-10T00:00:00.000 | 18:00:07 |
| 6V35 | A0253 | $0.00 | $1,000.00 | $1,000.00 | 2022-06-24T00:00:00.000 | 2026-10-10T00:00:00.000 | 18:00:07 |
| 5E92 | — | $0.00 | $1,000.00 | $1,000.00 | 2020-04-30T00:00:00.000 | 2026-10-10T00:00:00.000 | 18:00:07 |
| 0% |
$1,000.00$1,333.33$0.00 |
total_payment_amount | text | The sum of all hackup and operational payments made during the listed payment period. | 0% | $1,000.00$1,333.33$14,000.00 |
payment_date | datetime | The date payment is sent via ACH transfer to the medallion owner or agent. | 0% | 2025-05-16T00:00:00.0002025-02-10T00:00:00.0002023-02-15T00:00:00.000 |
last_date_updated | datetime | The date of update | 0% | 2026-10-10T00:00:00.000of 1 |
last_time_updated | text | The time of update | 0% | 18:00:07of 1 |