{"columns":[{"name":"person_id","type":"string"},{"name":"plan_num","type":"int32"},{"name":"plan_selected","type":"string"},{"name":"element","type":"string"},{"name":"leg_mode","type":"string"},{"name":"route_start_link","type":"string"},{"name":"route_end_link","type":"string"},{"name":"route_text","type":"string"},{"name":"route_type","type":"string"},{"name":"activity_link","type":"string"},{"name":"activity_lon","type":"double"},{"name":"activity_lat","type":"double"},{"name":"activity_type","type":"string"}],"n_rows":16,"rows_kept":16,"cut":false,"text_format":"parquet-jsonl-2026-10-02","bounds":{"document_bytes":16777216,"package_text_limit_bytes":33554432,"package_text_slack_bytes":1024,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096,"vector_min":64,"vector_head_fixed":16,"vector_head_variable":64,"kv_value_chars":1048576,"nesting_max":64,"binary_text":true},"cells_cut":0,"cells_bad_utf8":0,"cells_raw":0,"cells_binary":0,"cells_binary_text":0,"cells_vector":0,"n_row_groups":1,"reader":"pyarrow 23.0.1, python 3.13","created_by":"DuckDB version v1.3.1 (build 2063dda3e6)","schema":{"fields":[{"name":"person_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"plan_num","type":"int32","nullable":true,"metadata":null,"children":null},{"name":"plan_selected","type":"string","nullable":true,"metadata":null,"children":null},{"name":"element","type":"string","nullable":true,"metadata":null,"children":null},{"name":"leg_mode","type":"string","nullable":true,"metadata":null,"children":null},{"name":"route_start_link","type":"string","nullable":true,"metadata":null,"children":null},{"name":"route_end_link","type":"string","nullable":true,"metadata":null,"children":null},{"name":"route_text","type":"string","nullable":true,"metadata":null,"children":null},{"name":"route_type","type":"string","nullable":true,"metadata":null,"children":null},{"name":"activity_link","type":"string","nullable":true,"metadata":null,"children":null},{"name":"activity_lon","type":"double","nullable":true,"metadata":null,"children":null},{"name":"activity_lat","type":"double","nullable":true,"metadata":null,"children":null},{"name":"activity_type","type":"string","nullable":true,"metadata":null,"children":null}],"parquet":"required group field_id=-1 duckdb_schema {\n  optional binary field_id=-1 person_id (String);\n  optional int32 field_id=-1 plan_num (Int(bitWidth=32, isSigned=true));\n  optional binary field_id=-1 plan_selected (String);\n  optional binary field_id=-1 element (String);\n  optional binary field_id=-1 leg_mode (String);\n  optional binary field_id=-1 route_start_link (String);\n  optional binary field_id=-1 route_end_link (String);\n  optional binary field_id=-1 route_text (String);\n  optional binary field_id=-1 route_type (String);\n  optional binary field_id=-1 activity_link (String);\n  optional double field_id=-1 activity_lon;\n  optional double field_id=-1 activity_lat;\n  optional binary field_id=-1 activity_type (String);\n}\n"},"kv_metadata":[]}
["person1",1,"yes","activity",null,null,null,null,null,"143279",13.375960350036621,52.528472900390625,"home"]
["person1",1,"yes","leg","car","143279","68336","143279 143278 48729 77299 77298 48728 10 70105 130742 70693 68335 68336","links",null,null,null,null]
["person1",1,"yes","activity",null,null,null,null,null,"68336",13.37765121459961,52.52904510498047,"work"]
["person1",1,"yes","leg","car","68336","143279","68336 68335 70693 130742 70105 10 48728 77298 77299 48729 143278 143279","links",null,null,null,null]
["person1",1,"yes","activity",null,null,null,null,null,"143279",13.375960350036621,52.528472900390625,"home"]
["person1",2,"no","activity",null,null,null,null,null,"139054",13.387776374816895,52.49302291870117,"home"]
["person1",2,"no","leg","bike","139054","142709","139054 11897 143085 1585 83266 22773 34788 34787 34789 486 487 142709","links",null,null,null,null]
["person1",2,"no","activity",null,null,null,null,null,"142709",13.387447357177734,52.49224090576172,"work"]
["person2",1,"yes","activity",null,null,null,null,null,"139054",13.387776374816895,52.49302291870117,"home"]
["person2",1,"yes","leg","pt","139054","142709","139054 11897 143085 1585 83266 22773 34788 34787 34789 486 487 142709","links",null,null,null,null]
["person2",1,"yes","activity",null,null,null,null,null,"142709",13.387447357177734,52.49224090576172,"work"]
["person2",1,"yes","leg","walk","142709","139054","142709 487 486 34789 34787 34788 22773 83266 1585 143085 11897 139054","links",null,null,null,null]
["person2",1,"yes","activity",null,null,null,null,null,"139054",13.387776374816895,52.49302291870117,"home"]
["person3",1,"yes","activity",null,null,null,null,null,"90607",13.427651405334473,52.51839065551758,"home"]
["person3",1,"yes","leg","drt","90607","35342",null,"generic",null,null,null,null]
["person3",1,"yes","activity",null,null,null,null,null,"35342",13.428902626037598,52.51552963256836,"shopping"]