Skip to content

Instantly share code, notes, and snippets.

@ngtuna

ngtuna/sapa.trip

Created January 5, 2018 14:36
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save ngtuna/6c26422cddf570f9d18c9700a602c37e to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save ngtuna/6c26422cddf570f9d18c9700a602c37e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sapa.trip
select * from public.trip;
trip_id | dept_location | dest_location | request_time | departure_time |
arrive_time | estimated_distance | distance | estimated_price | price | driver_party_id | customer_party_id
| vehicle_id | status_id | last_updated_stamp | created_stamp | vehicle_type
----------------------------------+--------------------------+--------------------------+----------------------------+----------------------------+-----
-----------------------+--------------------+----------+-----------------+----------+----------------------------------+--------------------------------
--+----------------------------------+----------------+--------------------+---------------+--------------
8ab48c87606ff49d01608c8193700017 | 21.03480160,105.81212237 | 21.02252120,105.80989130 | 2017-12-25 07:09:50.314+00 | |
| 2.17 | | 21650.00 | | | 8ab48c87606ff49d01607229da82000
0 | | TRIP_CANCELLED | | | CAR4
8ab48c87606ff49d01608c8290da0018 | 21.03480504,105.81211668 | 21.02252120,105.80989130 | 2017-12-25 07:10:55.192+00 | |
| 2.17 | | 21650.00 | | | 8ab48c87606ff49d01607229da82000
0 | | TRIP_CANCELLED | | | CAR4
8ab48ca060a683f80160c54938380023 | 21.03450087,105.81343833 | 21.03013930,105.80994990 | 2018-01-05 07:46:38.262+00 | 2018-01-05 07:47:47.245+00 | 2018
-01-05 07:48:05.866+00 | 0.78 | 0.78 | 7810.00 | 7810.00 | 8ab48c87606ff49d01607c57fc1f0007 | 8ab48c87606ff49d01607229da82000
0 | 8ab48c87606ff49d01607c57fd49000a | TRIP_COMPLETED | | | CAR4
8ab48ca060a683f80160c48ab4170012 | 21.03556015,105.81244994 | 21.03013930,105.80994990 | 2018-01-05 04:18:32.597+00 | |
| 1.00 | | 9990.00 | | 8ab48c87606ff49d01607c57fc1f0007 | 8ab48c87606ff49d01607229da82000
0 | | TRIP_CANCELLED | | | CAR4
8ab48ca060a683f80160c48be9af0013 | 21.03483821,105.81220955 | 21.03013930,105.80994990 | 2018-01-05 04:19:51.847+00 | |
| 0.92 | | 9190.00 | | | 8ab48c87606ff49d01607229da82000
0 | | TRIP_CANCELLED | | | CAR4
8ab48c87606ff49d01608c83804e0019 | 21.03480317,105.81212170 | 21.02866690,105.85214840 | 2017-12-25 07:11:56.492+00 | 2017-12-25 07:12:14.771+00 | 2017
-12-25 07:12:41.803+00 | 5.86 | 5.86 | 58630.00 | 58630.00 | 8ab48c87606ff49d01607c57fc1f0007 | 8ab48c87606ff49d01607229da82000
0 | 8ab48c87606ff49d01607c57fd49000a | TRIP_COMPLETED | | | CAR4
8ab48c87606ff49d01608d1f0cac001c | 21.02105565,105.80918837 | 21.02796400,105.85101320 | 2017-12-25 10:01:50.506+00 | |
| 5.88 | | 58810.00 | | 8ab48c87606ff49d01607c57fc1f0007 | 8ab48c87606ff49d01607229da82000
0 | 8ab48c87606ff49d01607c57fd49000a | TRIP_CANCELLED | | | CAR4
8ab48ca060a683f80160c48c9f3f0014 | 21.03482664,105.81221692 | 21.02716940,105.81550700 | 2018-01-05 04:20:38.329+00 | |
| 1.50 | | 15020.00 | | | 8ab48c87606ff49d01607229da82000
0 | | TRIP_CANCELLED | | | CAR4
8ab48ca060a683f80160b5d9dca80000 | 21.03343908,105.81212506 | 21.02252120,105.80989130 | 2018-01-02 07:50:42.084+00 | |
| 2.12 | | 21230.00 | | 8ab48c87606ff49d01607c57fc1f0007 | 8ab48c87606ff49d01607229da82000
0 | 8ab48c87606ff49d01607c57fd49000a | TRIP_CANCELLED | | | CAR4
8ab48ca060a683f80160c4a394b30019 | 21.03482726,105.81221692 | 21.02252120,105.80989130 | 2018-01-05 04:45:42.96+00 | 2018-01-05 04:46:06.582+00 | 2018
-01-05 04:46:26.899+00 | 2.16 | 2.16 | 21630.00 | 21630.00 | 8ab48c87606ff49d01607c57fc1f0007 | 8ab48c87606ff49d01607229da82000
0 | 8ab48c87606ff49d01607c57fd49000a | TRIP_COMPLETED | | | CAR4
8ab48ca060a683f80160b9f86bc10004 | 21.03219202,105.81280265 | 20.97444140,105.77839900 | 2018-01-03 03:02:33.663+00 | |
| 9.58 | | 95780.00 | | | 8ab48c87606ff49d01607229da82000
0 | | TRIP_CANCELLED | | | CAR4
8ab48ca060a683f80160c487ffef000d | 21.03482632,105.81221759 | 21.03013930,105.80994990 | 2018-01-05 04:15:35.404+00 | |
| 0.92 | | 9170.00 | | | 8ab48c87606ff49d01607229da82000
0 | | TRIP_CANCELLED | | | CAR4
8ab48ca060a683f80160c4888130000e | 21.03480223,105.81220385 | 21.03013930,105.80994990 | 2018-01-05 04:16:08.494+00 | |
| 0.92 | | 9150.00 | | 8ab48c87606ff49d01607c57fc1f0007 | 8ab48c87606ff49d01607229da82000
0 | | TRIP_CANCELLED | | | CAR4
8ab48ca060a683f80160c48912fe000f | 21.03482444,105.81220955 | 21.03013930,105.80994990 | 2018-01-05 04:16:45.82+00 | |
| 0.92 | | 9170.00 | | | 8ab48c87606ff49d01607229da82000
0 | | TRIP_CANCELLED | | | CAR4
8ab48ca060a683f80160c4896f730010 | 21.03482507,105.81221558 | 21.03013930,105.80994990 | 2018-01-05 04:17:09.487+00 | |
| 0.92 | | 9170.00 | | | 8ab48c87606ff49d01607229da82000
0 | | TRIP_CANCELLED | | | CAR4
8ab48ca060a683f80160c489a7d50011 | 21.03482163,105.81221089 | 21.03013930,105.80994990 | 2018-01-05 04:17:23.922+00 | |
| 0.92 | | 9170.00 | | | 8ab48c87606ff49d01607229da82000
0 | | TRIP_CANCELLED | | | CAR4
8ab48ca060a683f80160c5711de60029 | 21.03482695,105.81221726 | 21.02716940,105.81550700 | 2018-01-05 08:30:12.965+00 | |
| 1.50 | | 15020.00 | | | 8ab48c87606ff49d01607229da82000
0 | | TRIP_CANCELLED | | | CAR4
8ab48ca060a683f80160c48ff9b50015 | 21.03484291,105.81221022 | 21.03013930,105.80994990 | 2018-01-05 04:24:18.098+00 | 2018-01-05 04:25:07.253+00 | 2018
-01-05 04:25:38.08+00 | 0.92 | 0.92 | 9190.00 | 9190.00 | 8ab48c87606ff49d01607c57fc1f0007 | 8ab48c87606ff49d01607229da82000
0 | 8ab48c87606ff49d01607c57fd49000a | TRIP_COMPLETED | | | CAR4
8ab48ca060a683f80160c543e7e60020 | 21.03478814,105.81220385 | 21.03013930,105.80994990 | 2018-01-05 07:40:50.019+00 | 2018-01-05 07:40:58.886+00 | 2018
-01-05 07:41:06.684+00 | 0.91 | 0.91 | 9130.00 | 9130.00 | 8ab48c87606ff49d01607c57fc1f0007 | 8ab48c87606ff49d01607229da82000
0 | 8ab48c87606ff49d01607c57fd49000a | TRIP_COMPLETED | | | CAR4
8ab48ca060a683f80160c495e3af0018 | 21.03482163,105.81221458 | 20.92895210,105.85330440 | 2018-01-05 04:30:45.675+00 | |
| 19.69 | | 196920.00 | | 8ab48c87606ff49d01607c57fc1f0007 | 8ab48c87606ff49d01607229da82000
0 | 8ab48c87606ff49d01607c57fd49000a | TRIP_CANCELLED | | | CAR4
8ab48ca060a683f80160c534c4d6001c | 21.03480004,105.81220251 | 21.03013930,105.80994990 | 2018-01-05 07:24:18.004+00 | 2018-01-05 07:24:51.136+00 | 2018
-01-05 07:24:59.017+00 | 0.91 | 0.91 | 9140.00 | 9140.00 | 8ab48c87606ff49d01607c57fc1f0007 | 8ab48c87606ff49d01607229da82000
0 | 8ab48c87606ff49d01607c57fd49000a | TRIP_COMPLETED | | | CAR4
8ab48ca060a683f80160c5723d4e002a | 21.03482851,105.81221156 | 21.02716940,105.81550700 | 2018-01-05 08:31:26.541+00 | |
| 1.50 | | 15020.00 | | 8ab48c87606ff49d01607c57fc1f0007 | 8ab48c87606ff49d01607229da82000
0 | | TRIP_CANCELLED | | | CAR4
8ab48ca060a683f80160c56f5cd80026 | 21.03481662,105.81221391 | 21.03013930,105.80994990 | 2018-01-05 08:28:18.006+00 | 2018-01-05 08:28:33.24+00 | 2018
-01-05 08:28:41.129+00 | 0.92 | 0.92 | 9160.00 | 9160.00 | 8ab48c87606ff49d01607c57fc1f0007 | 8ab48c87606ff49d01607229da82000
0 | 8ab48c87606ff49d01607c57fd49000a | TRIP_COMPLETED | | | CAR4
8ab48ca060a683f80160c5383364001f | 21.03485511,105.81224676 | 21.03013930,105.80994990 | 2018-01-05 07:28:02.914+00 | |
| 0.92 | | 9210.00 | | 8ab48c87606ff49d01607c57fc1f0007 | 8ab48c87606ff49d01607229da82000
0 | 8ab48c87606ff49d01607c57fd49000a | TRIP_CANCELLED | | | CAR4
8ab48ca060a683f80160c57a1605002f | 21.03482288,105.81221525 | 21.02716940,105.81550700 | 2018-01-05 08:40:00.772+00 | |
| 1.50 | | 15010.00 | | | 8ab48c87606ff49d01607229da82000
0 | | TRIP_CANCELLED | | | CAR4
8ab48ca060a683f80160c5739081002b | 21.03482601,105.81221826 | 21.02716940,105.81550700 | 2018-01-05 08:32:53.375+00 | |
| 1.50 | | 15020.00 | | | 8ab48c87606ff49d01607229da82000
0 | | TRIP_CANCELLED | | | CAR4
8ab48ca060a683f80160c575638b002c | 21.03483133,105.81221625 | 21.02716940,105.81550700 | 2018-01-05 08:34:52.937+00 | 2018-01-05 08:35:36.177+00 | 2018
-01-05 08:36:13.939+00 | 1.50 | 1.50 | 15020.00 | 15020.00 | 8ab48c87606ff49d01607c57fc1f0007 | 8ab48c87606ff49d01607229da82000
0 | 8ab48c87606ff49d01607c57fd49000a | TRIP_COMPLETED | | | CAR4
8ab48ca060a683f80160c57a68bd0030 | 21.03476342,105.81214685 | 21.02716940,105.81550700 | 2018-01-05 08:40:21.947+00 | |
| 1.50 | | 15000.00 | | | 8ab48c87606ff49d01607229da82000
0 | | TRIP_CANCELLED | | | CAR4
8ab48ca060a683f80160c57ccf5b0031 | 21.03485511,105.81227493 | 21.02716940,105.81550700 | 2018-01-05 08:42:59.289+00 | 2018-01-05 08:43:18.703+00 | 2018
-01-05 08:43:24.895+00 | 1.50 | 1.50 | 15050.00 | 15050.00 | 8ab48c87606ff49d01607c57fc1f0007 | 8ab48c87606ff49d01607229da82000
0 | 8ab48c87606ff49d01607c57fd49000a | TRIP_COMPLETED | | | CAR4
8ab48ca060a683f80160c57e4a360034 | 21.03469833,105.81225984 | 21.03013930,105.80994990 | 2018-01-05 08:44:36.276+00 | 2018-01-05 08:46:09.084+00 | 2018
-01-05 08:49:47.683+00 | 0.90 | 0.90 | 9030.00 | 9030.00 | 8ab48c87606ff49d01607c57fc1f0007 | 8ab48c87606ff49d01607229da82000
0 | 8ab48c87606ff49d01607c57fd49000a | TRIP_COMPLETED | | | CAR4
8ab48ca060a683f80160c583750c0037 | 21.03469990,105.81227325 | 21.02252120,105.80989130 | 2018-01-05 08:50:14.919+00 | 2018-01-05 08:50:21.161+00 |
| 2.15 | | 21490.00 | | 8ab48c87606ff49d01607c57fc1f0007 | 8ab48c87606ff49d01607229da82000
0 | 8ab48c87606ff49d01607c57fd49000a | TRIP_ONGOING | | | CAR4
(31 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment