Table: samsara_raw.hos_log
Showing the first 100 rows of the table.
| log_end_time | log_start_time | vehicle_id | hos_status_type | log_recorded_location_latitude | log_recorded_location_longitude | remark | driver_id | _fivetran_deleted | _fivetran_synced |
|---|---|---|---|---|---|---|---|---|---|
| 2025-03-05T11:03:29.682Z | 2025-03-05T07:00:00.000Z | 281474982754958 | onDuty | 45.565417949 | -74.59595634 | 30756490 | false | 2025-03-07T15:12:45.688Z | |
| 2025-03-05T07:00:00.000Z | 2025-03-04T11:03:29.682Z | 281474982754958 | onDuty | 45.565417949 | -74.59595634 | 30756490 | false | 2025-03-07T15:12:45.688Z | |
| 2025-03-05T11:03:29.682Z | 2025-03-05T07:00:00.000Z | 281474982756236 | offDuty | 41.16910812 | -74.7271531 | 30761271 | false | 2025-03-07T15:12:45.688Z | |
| 2025-03-05T07:00:00.000Z | 2025-03-04T11:03:29.682Z | 281474982756236 | offDuty | 41.16910812 | -74.7271531 | 30761271 | false | 2025-03-07T15:12:45.688Z | |
| 2025-03-05T11:03:29.682Z | 2025-03-05T07:00:00.000Z | 281474982756668 | offDuty | 34.3421925 | -83.46410029 | 30761194 | false | 2025-03-07T15:12:45.688Z | |
| 2025-03-05T07:00:00.000Z | 2025-03-04T11:03:29.682Z | 281474982756668 | offDuty | 34.3421925 | -83.46410029 | 30761194 | false | 2025-03-07T15:12:45.688Z | |
| 2025-03-05T07:00:00.000Z | 2025-03-04T11:03:29.682Z | 281474982756990 | onDuty | 45.5049344 | -73.835101809 | 30756510 | false | 2025-03-07T15:12:45.688Z | |
| 2025-03-05T11:03:29.682Z | 2025-03-05T07:00:00.000Z | 281474982756990 | onDuty | 45.5049344 | -73.835101809 | 30756510 | false | 2025-03-07T15:12:45.688Z | |
| 2025-03-05T07:00:00.000Z | 2025-03-04T11:03:29.682Z | 281474985290507 | offDuty | 39.38919839 | -77.39821745 | 30761250 | false | 2025-03-07T15:12:45.688Z | |
| 2025-03-05T11:03:29.682Z | 2025-03-05T07:00:00.000Z | 281474985290507 | offDuty | 39.38919839 | -77.39821745 | 30761250 | false | 2025-03-07T15:12:45.688Z | |
| 2025-03-05T11:03:29.682Z | 2025-03-05T07:00:00.000Z | 281474985290546 | offDuty | 39.91725365 | -77.70672011 | 30761237 | false | 2025-03-07T15:12:45.688Z | |
| 2025-03-05T07:00:00.000Z | 2025-03-04T11:03:29.682Z | 281474985290546 | offDuty | 39.91725365 | -77.70672011 | 30761237 | false | 2025-03-07T15:12:45.688Z | |
| 2025-03-05T08:54:37.632Z | 2025-03-05T08:00:00.000Z | 0 | offDuty | 50.68229433 | -120.36404785 | 48591899 | false | 2025-03-07T15:12:45.689Z | |
| 2025-03-05T07:00:00.000Z | 2025-03-04T11:03:29.682Z | 281474982756198 | offDuty | 0 | 0 | 30761286 | false | 2025-03-07T15:12:45.689Z | |
| 2025-03-05T11:03:29.682Z | 2025-03-05T07:00:00.000Z | 281474982756198 | offDuty | 0 | 0 | 30761286 | false | 2025-03-07T15:12:45.689Z | |
| 2025-03-05T07:00:00.000Z | 2025-03-04T11:03:29.682Z | 281474982756310 | offDuty | 0 | 0 | 30761322 | false | 2025-03-07T15:12:45.689Z | |
| 2025-03-05T11:03:29.682Z | 2025-03-05T07:00:00.000Z | 281474982756310 | offDuty | 0 | 0 | 30761322 | false | 2025-03-07T15:12:45.689Z | |
| 2025-03-05T11:03:29.682Z | 2025-03-05T07:00:00.000Z | 281474982756311 | offDuty | 34.38384969 | -83.57362436 | 30761321 | false | 2025-03-07T15:12:45.689Z | |
| 2025-03-05T07:00:00.000Z | 2025-03-04T11:03:29.682Z | 281474982756311 | offDuty | 34.38384969 | -83.57362436 | 30761321 | false | 2025-03-07T15:12:45.689Z | |
| 2025-03-05T07:00:00.000Z | 2025-03-04T11:03:29.682Z | 281474982756652 | offDuty | 39.411932739 | -78.05475422 | 30761314 | false | 2025-03-07T15:12:45.689Z | |
| 2025-03-05T11:03:29.682Z | 2025-03-05T07:00:00.000Z | 281474982756652 | offDuty | 39.411932739 | -78.05475422 | 30761314 | false | 2025-03-07T15:12:45.689Z | |
| 2025-03-04T16:24:10.000Z | 2025-03-04T12:37:26.425Z | 281474988448103 | onDuty | 36.17844269 | -80.26515783 | 48921375 | false | 2025-03-07T15:12:45.689Z | |
| 2025-03-04T12:17:35.022Z | 2025-03-04T11:29:47.018Z | 281474988448103 | driving | 35.69375355 | -80.39828865 | 48921375 | false | 2025-03-07T15:12:45.689Z | |
| 2025-03-04T18:46:04.028Z | 2025-03-04T18:46:01.051Z | 281474988448103 | onDuty | 35.536661569 | -80.303989 | 48921375 | false | 2025-03-07T15:12:45.689Z | |
| 2025-03-04T18:40:05.018Z | 2025-03-04T18:39:39.450Z | 281474988448103 | onDuty | 35.53591449 | -80.306977279 | 48921375 | false | 2025-03-07T15:12:45.689Z | |
| 2025-03-04T16:56:16.000Z | 2025-03-04T16:24:10.000Z | 281474988448103 | offDuty | 36.17851207 | -80.26537503 | 48921375 | false | 2025-03-07T15:12:45.689Z | |
| 2025-03-04T12:37:26.425Z | 2025-03-04T12:37:12.074Z | 281474988448103 | onDuty | 36.17844269 | -80.26515783 | 48921375 | false | 2025-03-07T15:12:45.689Z | |
| 2025-03-04T11:29:47.018Z | 2025-03-04T11:26:14.003Z | 281474988448103 | onDuty | 35.69385028 | -80.39821711 | 48921375 | false | 2025-03-07T15:12:45.689Z | |
| 2025-03-04T12:17:55.939Z | 2025-03-04T12:17:35.022Z | 281474988448103 | onDuty | 36.18182632 | -80.26490675 | 48921375 | false | 2025-03-07T15:12:45.689Z | |
| 2025-03-04T12:37:12.074Z | 2025-03-04T12:26:14.019Z | 281474988448103 | driving | 36.1812213 | -80.265110699 | 48921375 | false | 2025-03-07T15:12:45.689Z | |
| 2025-03-04T18:39:39.450Z | 2025-03-04T18:38:58.006Z | 281474988448103 | onDuty | 35.53589668 | -80.30694594 | 48921375 | false | 2025-03-07T15:12:45.689Z | |
| 2025-03-04T18:46:01.051Z | 2025-03-04T18:40:05.018Z | 281474988448103 | driving | 35.53612599 | -80.30685556 | 48921375 | false | 2025-03-07T15:12:45.689Z | |
| 2025-03-04T18:38:58.006Z | 2025-03-04T17:20:45.061Z | 281474988448103 | driving | 36.178505489 | -80.26527973 | 48921375 | false | 2025-03-07T15:12:45.689Z | |
| 2025-03-04T11:26:14.003Z | 2025-03-04T11:03:29.682Z | 281474988448103 | driving | 35.53644924 | -80.30619138 | 48921375 | false | 2025-03-07T15:12:45.689Z | |
| 2025-03-04T18:55:09.996Z | 2025-03-04T18:46:04.028Z | 281474988448103 | driving | 35.53667764 | -80.3038427 | 48921375 | false | 2025-03-07T15:12:45.689Z | |
| 2025-03-04T17:20:45.061Z | 2025-03-04T16:56:16.000Z | 281474988448103 | onDuty | 36.17851626 | -80.26538248 | 48921375 | false | 2025-03-07T15:12:45.689Z | |
| 2025-03-04T12:26:14.019Z | 2025-03-04T12:17:55.939Z | 281474988448103 | onDuty | 36.18182629 | -80.26490612 | 48921375 | false | 2025-03-07T15:12:45.689Z | |
| 2025-03-05T10:19:51.014Z | 2025-03-05T10:19:46.014Z | 281474994225587 | driving | 50.32022448 | -120.39519213 | 48591899 | false | 2025-03-07T15:12:45.689Z | |
| 2025-03-05T09:08:02.006Z | 2025-03-05T08:54:41.000Z | 281474994225587 | onDuty | 50.68229433 | -120.36404785 | 48591899 | false | 2025-03-07T15:12:45.689Z | |
| 2025-03-05T10:13:23.000Z | 2025-03-05T10:02:42.031Z | 281474994225587 | onDuty | 50.322428199 | -120.42128712 | 48591899 | false | 2025-03-07T15:12:45.689Z | |
| 2025-03-05T10:13:50.006Z | 2025-03-05T10:13:23.000Z | 281474994225587 | onDuty | 50.32248193 | -120.42121643 | 48591899 | false | 2025-03-07T15:12:45.689Z | |
| 2025-03-05T10:22:02.466Z | 2025-03-05T10:21:57.466Z | 281474994225587 | driving | 50.29418407 | -120.395034589 | 48591899 | false | 2025-03-07T15:12:45.689Z | |
| 2025-03-05T11:03:29.682Z | 2025-03-05T10:22:02.466Z | 281474994225587 | driving | 50.2928143 | -120.39572007 | 48591899 | false | 2025-03-07T15:12:45.689Z | |
| 2025-03-05T10:19:46.014Z | 2025-03-05T10:13:50.006Z | 281474994225587 | driving | 50.32216385 | -120.42111308 | 48591899 | false | 2025-03-07T15:12:45.689Z | |
| 2025-03-05T10:02:42.031Z | 2025-03-05T09:08:02.006Z | 281474994225587 | driving | 50.68217347 | -120.363411369 | 48591899 | false | 2025-03-07T15:12:45.689Z | |
| 2025-03-05T10:21:57.466Z | 2025-03-05T10:19:51.014Z | 281474994225587 | driving | 50.31978153 | -120.39334071 | 48591899 | false | 2025-03-07T15:12:45.689Z | |
| 2025-03-05T08:54:41.000Z | 2025-03-05T08:54:37.632Z | 281474994225587 | offDuty | 50.68229433 | -120.36404785 | 48591899 | false | 2025-03-07T15:12:45.689Z | |
| 2025-03-05T11:01:32.709Z | 2025-03-05T06:00:00.000Z | 0 | offDuty | 32.00021574 | -102.208795199 | 50987960 | false | 2025-03-07T15:12:45.690Z | |
| 2025-03-05T05:00:00.000Z | 2025-03-04T19:13:08.000Z | 0 | offDuty | 35.53646512 | -80.306747619 | 48921375 | false | 2025-03-07T15:12:45.690Z | |
| 2025-03-05T11:03:29.682Z | 2025-03-05T07:00:00.000Z | 281474986821065 | onDuty | 24.79049794 | -104.594136979 | 50459049 | false | 2025-03-07T15:12:45.690Z | |
| 2025-03-05T07:00:00.000Z | 2025-03-04T11:03:29.682Z | 281474986821065 | onDuty | 24.79049794 | -104.594136979 | 50459049 | false | 2025-03-07T15:12:45.690Z | |
| 2025-03-04T19:12:35.002Z | 2025-03-04T19:07:04.020Z | 281474988448102 | driving | 35.53645171 | -80.3035416 | 48921651 | false | 2025-03-07T15:12:45.690Z | |
| 2025-03-04T18:55:09.033Z | 2025-03-04T18:44:05.016Z | 281474988448102 | onDuty | 35.5363385 | -80.30518496 | 48921651 | false | 2025-03-07T15:12:45.690Z | |
| 2025-03-04T11:30:02.001Z | 2025-03-04T11:19:45.131Z | 281474988448102 | driving | 35.53634688 | -80.30689915 | 48921651 | false | 2025-03-07T15:12:45.690Z | |
| 2025-03-04T18:05:05.023Z | 2025-03-04T17:58:29.045Z | 281474988448102 | onDuty | 35.4985603 | -80.56708584 | 48921651 | false | 2025-03-07T15:12:45.690Z | |
| 2025-03-04T12:26:11.014Z | 2025-03-04T12:01:12.049Z | 281474988448102 | driving | 35.55987861 | -80.517516939 | 48921651 | false | 2025-03-07T15:12:45.690Z | |
| 2025-03-04T19:21:12.027Z | 2025-03-04T19:14:09.030Z | 281474988448102 | driving | 35.535485769 | -80.303202619 | 48921651 | false | 2025-03-07T15:12:45.690Z | |
| 2025-03-04T11:57:40.012Z | 2025-03-04T11:31:29.028Z | 281474988448102 | driving | 35.53556537 | -80.30301374 | 48921651 | false | 2025-03-07T15:12:45.690Z | |
| 2025-03-04T11:31:29.028Z | 2025-03-04T11:30:02.001Z | 281474988448102 | onDuty | 35.53562523 | -80.30308186 | 48921651 | false | 2025-03-07T15:12:45.690Z | |
| 2025-03-05T05:00:00.000Z | 2025-03-04T20:00:00.000Z | 281474988448102 | offDuty | 35.536426769 | -80.30691977 | Misattributed Duty Status Time | 48921651 | false | 2025-03-07T15:12:45.690Z |
| 2025-03-04T17:25:02.018Z | 2025-03-04T17:12:15.020Z | 281474988448102 | driving | 35.51799097 | -80.59011151 | 48921651 | false | 2025-03-07T15:12:45.690Z | |
| 2025-03-04T20:00:00.000Z | 2025-03-04T19:21:12.027Z | 281474988448102 | onDuty | 35.5358238 | -80.30692256 | Misattributed Duty Status Time | 48921651 | false | 2025-03-07T15:12:45.690Z |
| 2025-03-04T19:00:41.013Z | 2025-03-04T18:55:09.033Z | 281474988448102 | driving | 35.53635794 | -80.305146789 | 48921651 | false | 2025-03-07T15:12:45.690Z | |
| 2025-03-04T19:07:04.020Z | 2025-03-04T19:00:41.013Z | 281474988448102 | onDuty | 35.536590019 | -80.303989759 | 48921651 | false | 2025-03-07T15:12:45.690Z | |
| 2025-03-05T11:03:29.682Z | 2025-03-05T05:00:00.000Z | 281474988448102 | offDuty | 35.536426769 | -80.30691977 | Misattributed Duty Status Time | 48921651 | false | 2025-03-07T15:12:45.690Z |
| 2025-03-04T11:19:45.131Z | 2025-03-04T11:03:29.682Z | 281474988448102 | onDuty | 35.53645782 | -80.30690766 | 48921651 | false | 2025-03-07T15:12:45.690Z | |
| 2025-03-04T17:12:15.020Z | 2025-03-04T12:26:11.014Z | 281474988448102 | onDuty | 35.51761258 | -80.590131179 | 48921651 | false | 2025-03-07T15:12:45.690Z | |
| 2025-03-04T17:47:45.073Z | 2025-03-04T17:25:02.018Z | 281474988448102 | onDuty | 35.52044416 | -80.58030771 | 48921651 | false | 2025-03-07T15:12:45.690Z | |
| 2025-03-04T12:01:12.049Z | 2025-03-04T11:57:40.012Z | 281474988448102 | onDuty | 35.55990542 | -80.517491109 | 48921651 | false | 2025-03-07T15:12:45.690Z | |
| 2025-03-04T17:58:29.045Z | 2025-03-04T17:47:45.073Z | 281474988448102 | driving | 35.52057343 | -80.58011056 | 48921651 | false | 2025-03-07T15:12:45.690Z | |
| 2025-03-04T18:44:05.016Z | 2025-03-04T18:05:05.023Z | 281474988448102 | driving | 35.49867483 | -80.56739516 | 48921651 | false | 2025-03-07T15:12:45.690Z | |
| 2025-03-04T19:14:09.030Z | 2025-03-04T19:12:35.002Z | 281474988448102 | onDuty | 35.53564895 | -80.3029735 | 48921651 | false | 2025-03-07T15:12:45.690Z | |
| 2025-03-04T19:09:30.124Z | 2025-03-04T18:55:26.118Z | 281474988448103 | onDuty | 35.5363379 | -80.30532982 | 48921375 | false | 2025-03-07T15:12:45.690Z | |
| 2025-03-04T18:55:26.118Z | 2025-03-04T18:55:09.996Z | 281474988448103 | onDuty | 35.5363379 | -80.30532982 | 48921375 | false | 2025-03-07T15:12:45.690Z | |
| 2025-03-04T19:13:08.000Z | 2025-03-04T19:12:01.000Z | 281474988448103 | onDuty | 35.53646512 | -80.306747619 | 48921375 | false | 2025-03-07T15:12:45.690Z | |
| 2025-03-04T19:12:01.000Z | 2025-03-04T19:09:30.124Z | 281474988448103 | driving | 35.53616917 | -80.30512141 | 48921375 | false | 2025-03-07T15:12:45.690Z | |
| 2025-03-05T08:10:01.798Z | 2025-03-05T05:00:00.000Z | 0 | offDuty | 36.496735219 | -78.08427766 | 50987961 | false | 2025-03-07T15:12:45.691Z | |
| 2025-03-05T05:00:00.000Z | 2025-03-04T18:51:57.000Z | 0 | offDuty | 35.53645387 | -80.30683124 | 50987964 | false | 2025-03-07T15:12:45.691Z | |
| 2025-03-05T05:00:00.000Z | 2025-03-04T19:35:00.000Z | 0 | offDuty | 36.496735219 | -78.08427766 | 50987961 | false | 2025-03-07T15:12:45.691Z | |
| 2025-03-05T08:52:08.457Z | 2025-03-05T05:00:00.000Z | 0 | offDuty | 35.53645387 | -80.30683124 | 50987964 | false | 2025-03-07T15:12:45.691Z | |
| 2025-03-04T19:15:19.020Z | 2025-03-04T19:04:56.000Z | 281474982756549 | onDuty | 36.5996918 | -78.150583229 | 50987961 | false | 2025-03-07T15:12:45.691Z | |
| 2025-03-05T08:55:06.070Z | 2025-03-05T08:10:24.000Z | 281474982756549 | onDuty | 36.49668401 | -78.08385158 | 50987961 | false | 2025-03-07T15:12:45.691Z | |
| 2025-03-05T09:09:37.098Z | 2025-03-05T08:55:06.070Z | 281474982756549 | driving | 36.49669386 | -78.0839694 | 50987961 | false | 2025-03-07T15:12:45.691Z | |
| 2025-03-04T12:28:43.013Z | 2025-03-04T12:06:54.000Z | 281474982756549 | onDuty | 37.35522797 | -77.500718899 | 50987961 | false | 2025-03-07T15:12:45.691Z | |
| 2025-03-04T19:33:55.000Z | 2025-03-04T19:21:00.002Z | 281474982756549 | driving | 36.54360625 | -78.18483621 | 50987961 | false | 2025-03-07T15:12:45.691Z | |
| 2025-03-04T19:21:00.002Z | 2025-03-04T19:15:19.020Z | 281474982756549 | driving | 36.599609919 | -78.15059998 | 50987961 | false | 2025-03-07T15:12:45.691Z | |
| 2025-03-04T17:37:54.019Z | 2025-03-04T17:18:32.000Z | 281474982756549 | onDuty | 37.35518786 | -77.50054828 | 50987961 | false | 2025-03-07T15:12:45.691Z | |
| 2025-03-04T19:35:00.000Z | 2025-03-04T19:33:55.000Z | 281474982756549 | onDuty | 36.496735219 | -78.08427766 | 50987961 | false | 2025-03-07T15:12:45.691Z | |
| 2025-03-05T09:58:02.000Z | 2025-03-05T09:57:32.021Z | 281474982756549 | driving | 36.94020565 | -77.734738359 | 50987961 | false | 2025-03-07T15:12:45.691Z | |
| 2025-03-04T13:16:10.000Z | 2025-03-04T13:16:02.000Z | 281474982756549 | onDuty | 37.35641154 | -77.50661037 | 50987961 | false | 2025-03-07T15:12:45.691Z | |
| 2025-03-05T11:03:29.682Z | 2025-03-05T10:04:59.024Z | 281474982756549 | driving | 36.939193379 | -77.73542891 | 50987961 | false | 2025-03-07T15:12:45.691Z | |
| 2025-03-04T17:18:32.000Z | 2025-03-04T17:11:54.037Z | 281474982756549 | driving | 37.35638179 | -77.50636294 | 50987961 | false | 2025-03-07T15:12:45.691Z | |
| 2025-03-05T09:57:32.021Z | 2025-03-05T09:49:22.000Z | 281474982756549 | onDuty | 36.94032179 | -77.73497693 | 50987961 | false | 2025-03-07T15:12:45.691Z | |
| 2025-03-04T13:16:02.000Z | 2025-03-04T12:38:14.014Z | 281474982756549 | onDuty | 37.35643558 | -77.506629369 | 50987961 | false | 2025-03-07T15:12:45.691Z | |
| 2025-03-05T09:49:22.000Z | 2025-03-05T09:09:37.098Z | 281474982756549 | driving | 36.54466887 | -78.18381722 | 50987961 | false | 2025-03-07T15:12:45.691Z | |
| 2025-03-05T08:10:24.000Z | 2025-03-05T08:10:01.798Z | 281474982756549 | offDuty | 36.49668401 | -78.08385158 | 50987961 | false | 2025-03-07T15:12:45.691Z | |
| 2025-03-05T10:04:59.024Z | 2025-03-05T09:58:02.000Z | 281474982756549 | onDuty | 36.93928374 | -77.735243999 | 50987961 | false | 2025-03-07T15:12:45.691Z | |
| 2025-03-04T12:06:54.000Z | 2025-03-04T11:12:48.027Z | 281474982756549 | driving | 36.94036563 | -77.73484231 | 50987961 | false | 2025-03-07T15:12:45.691Z | |
| 2025-03-04T19:04:56.000Z | 2025-03-04T17:37:54.019Z | 281474982756549 | driving | 37.3551252 | -77.50052071 | 50987961 | false | 2025-03-07T15:12:45.691Z | |
| 2025-03-04T11:12:48.027Z | 2025-03-04T11:03:29.682Z | 281474982756549 | onDuty | 36.94011746 | -77.73527966 | 50987961 | false | 2025-03-07T15:12:45.691Z |