From a 500-row sample across 39 columns.
is_completetravel_dowhh_id+32is_completehh_idnum_tripshh_day_completetravel_dowhh_id+5| hh_id | is_complete | num_trips | person_id | person_num | is_participant | day_id | day_num | travel_date | travel_dow | hh_day_complete | num_complete_trip_surveys |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 24000079 | 1 | 9 | 2400007901 | 1 | 1 | 240000790101 | 1 | 2024-05-31T00:00:00.000 | 5 | 1 | 7 |
| 24000079 | 1 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
hh_id | integer | — | 0% | 240394932410304424021564 |
is_complete | categorical | — | 0% | 10of 2 |
num_trips | integer | — | 0% | 024 |
person_id | integer | — | 0% | 240979020124117825012415128301 |
person_num | integer | — | 0% |
GET /api/datasets/naav-ygga GET /api/datasets/naav-ygga/quality GET /api/datasets/naav-ygga/related GET /api/columns?dataset=naav-ygga
is_completehh_idperson_numis_completehh_idnum_tripshh_idperson_numtravel_date+2hh_idhh_idperson_numnum_trips+2| 8 |
| 2400007901 |
| 1 |
| 1 |
| 240000790102 |
| 2 |
| 2024-06-01T00:00:00.000 |
| 6 |
| 1 |
| 6 |
| 24000079 | 1 | 7 | 2400007901 | 1 | 1 | 240000790103 | 3 | 2024-06-02T00:00:00.000 | 7 | 1 | 7 |
| 24000079 | 1 | 0 | 2400007901 | 1 | 1 | 240000790104 | 4 | 2024-06-03T00:00:00.000 | 1 | 1 | 0 |
| 24000079 | 1 | 0 | 2400007901 | 1 | 1 | 240000790105 | 5 | 2024-06-04T00:00:00.000 | 2 | 1 | 0 |
| 24000079 | 1 | 11 | 2400007901 | 1 | 1 | 240000790106 | 6 | 2024-06-05T00:00:00.000 | 3 | 1 | 7 |
| 24000079 | 0 | 5 | 2400007901 | 1 | 1 | 240000790107 | 7 | 2024-06-06T00:00:00.000 | 4 | 0 | 4 |
| 24000108 | 1 | 4 | 2400010801 | 1 | 1 | 240001080101 | 1 | 2024-05-17T00:00:00.000 | 5 | 1 | 4 |
| 24000108 | 1 | 2 | 2400010801 | 1 | 1 | 240001080102 | 2 | 2024-05-18T00:00:00.000 | 6 | 1 | 2 |
| 24000108 | 1 | 2 | 2400010801 | 1 | 1 | 240001080103 | 3 | 2024-05-19T00:00:00.000 | 7 | 1 | 2 |
Showing 12 of 39 columns. All of them are listed below.
1of 1 |
is_participant | integer | — | 0% | 1of 1 |
day_id | integer | — | 0% | 240603820103240045300101241526360102 |
day_num | categorical | — | 0% | 152of 7 |
travel_date | datetime | — | 0% | 2024-06-03T00:00:00.0002024-06-02T00:00:00.0002024-06-01T00:00:00.000 |
travel_dow | categorical | — | 0% | 516of 7 |
hh_day_complete | categorical | — | 0% | 10of 2 |
num_complete_trip_surveys | integer | — | 1% | 024 |
summary_complete | categorical | — | 0% | 10of 2 |
begin_day | categorical | — | 0% | 12995of 8 |
end_day | categorical | — | 0% | 12995of 8 |
no_travel_1 | categorical | — | 0% | 99501of 3 |
no_travel_2 | categorical | — | 0% | 99501of 3 |
no_travel_3 | categorical | — | 0% | 99501of 3 |
no_travel_4 | categorical | — | 0% | 99501of 3 |
no_travel_5 | categorical | — | 0% | 99501of 3 |
no_travel_6 | categorical | — | 0% | 99501of 3 |
no_travel_7 | categorical | — | 0% | 99501of 3 |
no_travel_8 | categorical | — | 0% | 99501of 3 |
no_travel_11 | categorical | — | 0% | 99501of 3 |
no_travel_12 | categorical | — | 0% | 99501of 3 |
no_travel_13 | categorical | — | 0% | 99501of 3 |
no_travel_99 | categorical | — | 0% | 99501of 3 |
delivery_2 | categorical | — | 0% | 01995of 3 |
delivery_4 | categorical | — | 0% | 09951of 3 |
delivery_5 | categorical | — | 0% | 01995of 3 |
delivery_6 | categorical | — | 0% | 09951of 3 |
delivery_7 | categorical | — | 0% | 09951of 3 |
delivery_8 | categorical | — | 0% | 09951of 3 |
delivery_9 | categorical | — | 0% | 09951of 3 |
delivery_996 | categorical | — | 0% | 10995of 3 |
shop_online | categorical | — | 0% | 01995of 3 |
telecommute_time | integer | — | 0% | 9950480 |
day_weight_zonal | float | — | 0% | 0341.736295234297163.099311706076 |
day_weight_citywide | float | — | 0% | 0127.30183043555443.1281878301818 |