From a 500-row sample across 39 columns.
| hh_id | num_trips | person_id | person_num | day_id | travel_dow | day_num | is_complete | travel_date | summary_complete | num_complete_trip_surveys | begin_day |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 22012096 | 0 | 2201209601 | 1 | 220120960105 | 7 | 5 | 0 | 2022-10-09T00:00:00.000 | 1 | 0 | 1 |
| 22012096 | 0 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
hh_id | text | — | 0% | 221456752204869422142077 |
num_trips | integer | — | 0% | 024 |
person_id | text | — | 0% | 220657080122036910012211035001 |
person_num | text | — | 0% | 1of 1 |
day_id | text | — | 0% |
GET /api/datasets/5njs-bq3c GET /api/datasets/5njs-bq3c/quality GET /api/datasets/5njs-bq3c/related GET /api/columns?dataset=5njs-bq3c
| 2201209601 |
| 1 |
| 220120960106 |
| 1 |
| 6 |
| 0 |
| 2022-10-10T00:00:00.000 |
| 1 |
| 0 |
| 1 |
| 22000050 | 0 | 2200005001 | 1 | 220000500101 | 4 | 1 | 0 | 2022-10-13T00:00:00.000 | 1 | 0 | 1 |
| 22000050 | 2 | 2200005001 | 1 | 220000500102 | 5 | 2 | 1 | 2022-10-14T00:00:00.000 | 1 | 2 | 1 |
| 22000050 | 0 | 2200005001 | 1 | 220000500103 | 6 | 3 | 1 | 2022-10-15T00:00:00.000 | 1 | 0 | 1 |
| 22000050 | 0 | 2200005001 | 1 | 220000500104 | 7 | 4 | 0 | 2022-10-16T00:00:00.000 | 1 | 0 | 1 |
| 22000050 | 0 | 2200005001 | 1 | 220000500105 | 1 | 5 | 1 | 2022-10-17T00:00:00.000 | 1 | 0 | 1 |
| 22000050 | 2 | 2200005001 | 1 | 220000500106 | 2 | 6 | 1 | 2022-10-18T00:00:00.000 | 1 | 2 | 1 |
| 22000050 | 0 | 2200005001 | 1 | 220000500107 | 3 | 7 | 1 | 2022-10-19T00:00:00.000 | 1 | 0 | 1 |
| 22000105 | 14 | 2200010501 | 1 | 220001050101 | 1 | 1 | 1 | 2022-10-17T00:00:00.000 | 1 | 14 | 1 |
Showing 12 of 39 columns. All of them are listed below.
221456480103220172050103220513700101 |
travel_dow | categorical | — | 0% | 342of 7 |
day_num | categorical | — | 0% | 136of 7 |
is_complete | categorical | — | 0% | 10of 2 |
travel_date | datetime | — | 0% | 2022-10-18T00:00:00.0002022-10-10T00:00:00.0002022-10-13T00:00:00.000 |
summary_complete | categorical | — | 0% | 10of 2 |
num_complete_trip_surveys | integer | — | 0% | 024 |
begin_day | categorical | — | 0% | 123of 8 |
end_day | categorical | — | 0% | 123of 8 |
telecommute_time | integer | — | 0% | 0995480 |
delivery_2 | categorical | — | 0% | 01995of 3 |
delivery_3 | categorical | — | 0% | 01995of 3 |
delivery_4 | categorical | — | 0% | 01995of 3 |
delivery_5 | categorical | — | 0% | 01995of 3 |
delivery_6 | categorical | — | 0% | 09951of 3 |
delivery_7 | categorical | — | 0% | 01995of 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 |
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_9 | 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 |
wkday_weight | float | — | 0% | 038.766692391318.867644 |
svnday_weight | float | — | 0% | 022.152395651316.714286 |