Table: samsara_raw.defect
Showing the first 100 rows of the table.
| id | mechanic_notes | is_resolved | trailer_id | defect_type | comment | vehicle_id | _fivetran_deleted | resolved_by_id | _fivetran_synced | resolved_at_time | created_at_time | resolved_by_name | mechanic_notes_updated_at_time | resolved_by_type |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19137203 | false | Lights | Top marker lights shorting out | false | 2025-03-06T05:23:01.739Z | 2024-08-15T04:35:13.929Z | ||||||||
| 15854576 | false | Reflectors | false | 2025-03-06T05:22:59.686Z | 2024-03-01T13:27:46.589Z | |||||||||
| 15854577 | false | Suspension | false | 2025-03-06T05:22:59.686Z | 2024-03-01T13:27:46.589Z | |||||||||
| 16097521 | false | Doors | Na | false | 2025-03-06T05:22:59.695Z | 2024-03-14T16:41:00.433Z | ||||||||
| 15854584 | false | Landing Gear | false | 2025-03-06T05:22:59.686Z | 2024-03-01T13:27:46.589Z | |||||||||
| 15854583 | false | Doors | false | 2025-03-06T05:22:59.686Z | 2024-03-01T13:27:46.589Z | |||||||||
| 15854574 | false | Coupling Devices | false | 2025-03-06T05:22:59.686Z | 2024-03-01T13:27:46.589Z | |||||||||
| 23893881 | false | Roof | No roof | false | 2025-04-24T22:19:31.861Z | 2025-03-26T00:42:20.517Z | ||||||||
| 15854582 | false | Brake Connections | false | 2025-03-06T05:22:59.686Z | 2024-03-01T13:27:46.589Z | |||||||||
| 16093779 | false | Doors | Na | false | 2025-03-06T05:22:59.695Z | 2024-03-14T13:14:20.081Z | ||||||||
| 23877880 | false | Roof | No roof | false | 2025-04-24T22:19:31.860Z | 2025-03-25T13:22:41.350Z | ||||||||
| 15854585 | false | Roof | false | 2025-03-06T05:22:59.686Z | 2024-03-01T13:27:46.589Z | |||||||||
| 15854575 | false | Lights | false | 2025-03-06T05:22:59.686Z | 2024-03-01T13:27:46.589Z | |||||||||
| 16847387 | false | Brakes | ABS light is on the dashboard | false | 2025-03-06T05:23:00.502Z | 2024-04-24T00:12:11.181Z | ||||||||
| 23732222 | false | Other | Abs light is on | false | 2025-04-24T22:19:31.855Z | 2025-03-19T12:30:38.920Z | ||||||||
| 15854578 | false | Tires | false | 2025-03-06T05:22:59.686Z | 2024-03-01T13:27:46.589Z | |||||||||
| 15854581 | false | Brakes | false | 2025-03-06T05:22:59.686Z | 2024-03-01T13:27:46.589Z | |||||||||
| 15854580 | false | Other | false | 2025-03-06T05:22:59.686Z | 2024-03-01T13:27:46.589Z | |||||||||
| 15854579 | false | Wheels Rims | false | 2025-03-06T05:22:59.686Z | 2024-03-01T13:27:46.589Z | |||||||||
| 23603282 | false | Clutch | N/A | 281474982756255 | false | 2025-04-24T22:19:31.846Z | 2025-03-13T20:08:45.258Z | |||||||
| 23757194 | false | Clutch | Na | 281474982756255 | false | 2025-04-24T22:19:31.855Z | 2025-03-20T09:32:13.588Z | |||||||
| 22844611 | false | Clutch | No clutch | 281474982756255 | false | 2025-03-06T05:23:03.811Z | 2025-02-10T12:33:13.924Z | |||||||
| 23960863 | false | Clutch | Na | 281474982756255 | false | 2025-04-24T22:19:31.861Z | 2025-03-28T09:25:59.052Z | |||||||
| 25214616 | false | Clutch | Automatic | 281474982756255 | false | 2025-05-17T08:39:06.717Z | 2025-05-16T07:33:52.151Z | |||||||
| 24041553 | false | Fifth Wheel | N/A | 281474982756255 | false | 2025-04-24T22:19:31.861Z | 2025-04-01T09:06:42.440Z | |||||||
| 24475010 | false | Fifth Wheel | Na | 281474982756255 | false | 2025-04-24T22:19:33.172Z | 2025-04-17T20:21:04.621Z | |||||||
| 24595016 | false | Fifth Wheel | Nun | 281474982756255 | false | 2025-04-24T22:19:33.175Z | 2025-04-23T08:53:40.879Z | |||||||
| 22749397 | false | Fifth Wheel | Na | 281474982756255 | false | 2025-03-06T05:23:03.810Z | 2025-02-05T18:31:34.252Z | |||||||
| 23915887 | false | Fifth Wheel | N/A | 281474982756255 | false | 2025-04-24T22:19:31.861Z | 2025-03-26T19:20:34.147Z | |||||||
| 24614056 | false | Fifth Wheel | Nun | 281474982756255 | false | 2025-04-24T22:19:33.175Z | 2025-04-23T20:42:34.089Z | |||||||
| 24041554 | false | Clutch | N/A | 281474982756255 | false | 2025-04-24T22:19:31.861Z | 2025-04-01T09:06:42.440Z | |||||||
| 24456109 | false | Fifth Wheel | Na | 281474982756255 | false | 2025-04-24T22:19:33.172Z | 2025-04-17T08:22:21.605Z | |||||||
| 26709331 | false | 13. Check heater and AC | AC kinda working | 281474982756255 | false | 2025-07-15T14:38:05.855Z | 2025-07-14T08:40:39.363Z | |||||||
| 23787345 | false | Fifth Wheel | N/A | 281474982756255 | false | 2025-04-24T22:19:31.855Z | 2025-03-21T09:19:35.216Z | |||||||
| 23237230 | false | Fifth Wheel | N/A | 281474982756255 | false | 2025-03-06T05:23:03.815Z | 2025-02-26T22:21:06.937Z | |||||||
| 24829178 | false | Clutch | Na | 281474982756255 | false | 2025-05-09T05:40:03.429Z | 2025-05-01T21:06:13.356Z | |||||||
| 24054985 | false | Clutch | Not available | 281474982756255 | false | 2025-04-24T22:19:31.862Z | 2025-04-01T17:21:28.670Z | |||||||
| 24808905 | false | Coupling Devices | Na | 281474982756255 | false | 2025-05-09T05:40:03.426Z | 2025-05-01T08:58:45.813Z | |||||||
| 25229854 | false | Fifth Wheel | M/A | 281474982756255 | false | 2025-05-17T20:37:08.346Z | 2025-05-16T17:22:44.045Z | |||||||
| 24136566 | false | Clutch | NA | 281474982756255 | false | 2025-04-24T22:19:31.862Z | 2025-04-04T11:03:32.287Z | |||||||
| 25229855 | false | Clutch | Automatic | 281474982756255 | false | 2025-05-17T20:37:08.346Z | 2025-05-16T17:22:44.045Z | |||||||
| 24054984 | false | Fifth Wheel | Not available | 281474982756255 | false | 2025-04-24T22:19:31.862Z | 2025-04-01T17:21:28.670Z | |||||||
| 23725601 | false | Coupling Devices | Na | 281474982756255 | false | 2025-04-24T22:19:31.846Z | 2025-03-19T08:26:52.651Z | |||||||
| 23915888 | false | Clutch | Automatic | 281474982756255 | false | 2025-04-24T22:19:31.861Z | 2025-03-26T19:20:34.147Z | |||||||
| 24456110 | false | Clutch | Na | 281474982756255 | false | 2025-04-24T22:19:33.172Z | 2025-04-17T08:22:21.605Z | |||||||
| 23586184 | false | Clutch | N/A | 281474982756255 | false | 2025-04-24T22:19:31.846Z | 2025-03-13T08:31:20.466Z | |||||||
| 24614057 | false | Clutch | Automatic | 281474982756255 | false | 2025-04-24T22:19:33.175Z | 2025-04-23T20:42:34.089Z | |||||||
| 23787343 | false | Windshield Wiper Fluid | Windshield washer not working | 281474982756255 | false | 2025-04-24T22:19:31.855Z | 2025-03-21T09:19:35.216Z | |||||||
| 23960862 | false | Fifth Wheel | Na | 281474982756255 | false | 2025-04-24T22:19:31.861Z | 2025-03-28T09:25:59.052Z | |||||||
| 22950621 | false | Fifth Wheel | Na | 281474982756255 | false | 2025-03-06T05:23:03.813Z | 2025-02-14T10:21:04.728Z | |||||||
| 23616260 | false | Clutch | N/A | 281474982756255 | false | 2025-04-24T22:19:31.846Z | 2025-03-14T09:26:53.238Z | |||||||
| 24583442 | false | Clutch | Automatic | 281474982756255 | false | 2025-04-24T22:19:33.173Z | 2025-04-22T21:16:56.813Z | |||||||
| 26728059 | false | 13. Check heater and AC | No work | 281474982756255 | false | 2025-07-15T20:39:07.013Z | 2025-07-14T20:00:23.490Z | |||||||
| 23725603 | false | Clutch | Na | 281474982756255 | false | 2025-04-24T22:19:31.846Z | 2025-03-19T08:26:52.651Z | |||||||
| 24829177 | false | Fifth Wheel | Na | 281474982756255 | false | 2025-05-09T05:40:03.429Z | 2025-05-01T21:06:13.356Z | |||||||
| 23787346 | false | Clutch | NA | 281474982756255 | false | 2025-04-24T22:19:31.855Z | 2025-03-21T09:19:35.216Z | |||||||
| 23586183 | false | Fifth Wheel | N/A | 281474982756255 | false | 2025-04-24T22:19:31.846Z | 2025-03-13T08:31:20.466Z | |||||||
| 24456108 | false | Coupling Devices | Na | 281474982756255 | false | 2025-04-24T22:19:33.172Z | 2025-04-17T08:22:21.605Z | |||||||
| 24808906 | false | Fifth Wheel | Na | 281474982756255 | false | 2025-05-09T05:40:03.429Z | 2025-05-01T08:58:45.813Z | |||||||
| 23616259 | false | Fifth Wheel | N/A | 281474982756255 | false | 2025-04-24T22:19:31.846Z | 2025-03-14T09:26:53.238Z | |||||||
| 24475011 | false | Clutch | Na | 281474982756255 | false | 2025-04-24T22:19:33.172Z | 2025-04-17T20:21:04.621Z | |||||||
| 23787344 | false | Coupling Devices | NA | 281474982756255 | false | 2025-04-24T22:19:31.855Z | 2025-03-21T09:19:35.216Z | |||||||
| 23757193 | false | Fifth Wheel | Na | 281474982756255 | false | 2025-04-24T22:19:31.855Z | 2025-03-20T09:32:13.588Z | |||||||
| 24829176 | false | Coupling Devices | Na | 281474982756255 | false | 2025-05-09T05:40:03.429Z | 2025-05-01T21:06:13.356Z | |||||||
| 23725602 | false | Fifth Wheel | Na | 281474982756255 | false | 2025-04-24T22:19:31.846Z | 2025-03-19T08:26:52.651Z | |||||||
| 22856428 | false | Fifth Wheel | N/a | 281474982756255 | false | 2025-03-06T05:23:03.811Z | 2025-02-10T20:39:15.450Z | |||||||
| 26967808 | false | 13. Check heater and AC | Ac needs repair | 281474982756255 | false | 2025-08-01T03:01:17.238Z | 2025-07-23T13:37:34.089Z | |||||||
| 24595017 | false | Clutch | Automatic | 281474982756255 | false | 2025-04-24T22:19:33.175Z | 2025-04-23T08:53:40.879Z | |||||||
| 24475009 | false | Coupling Devices | Na | 281474982756255 | false | 2025-04-24T22:19:33.172Z | 2025-04-17T20:21:04.621Z | |||||||
| 24563070 | false | Fifth Wheel | None | 281474982756255 | false | 2025-04-24T22:19:33.172Z | 2025-04-22T08:25:10.889Z | |||||||
| 24136565 | false | Fifth Wheel | NA | 281474982756255 | false | 2025-04-24T22:19:31.862Z | 2025-04-04T11:03:32.287Z | |||||||
| 25028751 | false | Clutch | Na | 281474982756255 | false | 2025-05-10T14:37:35.936Z | 2025-05-09T11:35:48.179Z | |||||||
| 25214615 | false | Fifth Wheel | N/A | 281474982756255 | false | 2025-05-17T08:39:06.713Z | 2025-05-16T07:33:52.151Z | |||||||
| 24583441 | false | Fifth Wheel | Doesnot have | 281474982756255 | false | 2025-04-24T22:19:33.172Z | 2025-04-22T21:16:56.813Z | |||||||
| 24808907 | false | Clutch | Na | 281474982756255 | false | 2025-05-09T05:40:03.429Z | 2025-05-01T08:58:45.813Z | |||||||
| 22737019 | false | Fifth Wheel | Na | 281474982756255 | false | 2025-03-06T05:23:03.809Z | 2025-02-05T10:19:50.074Z | |||||||
| 26728060 | false | 21. Tire chains are serviceable (when required) | Na | 281474982756255 | false | 2025-07-15T20:39:07.013Z | 2025-07-14T20:00:23.490Z | |||||||
| 25028750 | false | Fifth Wheel | Na | 281474982756255 | false | 2025-05-10T14:37:35.936Z | 2025-05-09T11:35:48.179Z | |||||||
| 24563071 | false | Clutch | Automatic | 281474982756255 | false | 2025-04-24T22:19:33.172Z | 2025-04-22T08:25:10.889Z | |||||||
| 22844610 | false | Fifth Wheel | No fifth wheel | 281474982756255 | false | 2025-03-06T05:23:03.811Z | 2025-02-10T12:33:13.924Z | |||||||
| 23603281 | false | Fifth Wheel | N/A | 281474982756255 | false | 2025-04-24T22:19:31.846Z | 2025-03-13T20:08:45.258Z | |||||||
| 21728422 | true | Coupling Devices | Na | 281474982756255 | false | 50987990 | 2025-03-06T05:23:03.247Z | 2025-01-21T10:27:41.000Z | 2024-12-16T09:39:26.760Z | Dakota Jones | 2025-01-21T10:27:43.133Z | driver | ||
| 21728423 | true | Fifth Wheel | Na | 281474982756255 | false | 50987990 | 2025-03-06T05:23:03.247Z | 2025-01-21T10:27:41.000Z | 2024-12-16T09:39:26.760Z | Dakota Jones | 2025-01-21T10:27:43.149Z | driver | ||
| 21728424 | true | Clutch | N | 281474982756255 | false | 50987990 | 2025-03-06T05:23:03.247Z | 2025-01-21T10:27:41.000Z | 2024-12-16T09:39:26.760Z | Dakota Jones | 2025-01-21T10:27:43.154Z | driver | ||
| 21744540 | true | Fifth Wheel | Na | 281474982756255 | false | 50987990 | 2025-03-06T05:23:03.247Z | 2025-01-21T10:27:41.000Z | 2024-12-16T21:40:03.554Z | Dakota Jones | 2025-01-21T10:27:43.160Z | driver | ||
| 21744541 | true | Clutch | Na | 281474982756255 | false | 50987990 | 2025-03-06T05:23:03.247Z | 2025-01-21T10:27:41.000Z | 2024-12-16T21:40:03.554Z | Dakota Jones | 2025-01-21T10:27:43.165Z | driver | ||
| 21781010 | true | Clutch | N/A | 281474982756255 | false | 50987990 | 2025-03-06T05:23:03.247Z | 2025-01-21T10:27:41.000Z | 2024-12-18T09:26:26.741Z | Dakota Jones | 2025-01-21T10:27:43.171Z | driver | ||
| 21781011 | true | Fifth Wheel | N/A | 281474982756255 | false | 50987990 | 2025-03-06T05:23:03.248Z | 2025-01-21T10:27:41.000Z | 2024-12-18T09:26:26.741Z | Dakota Jones | 2025-01-21T10:27:43.176Z | driver | ||
| 21781012 | true | Coupling Devices | N/A | 281474982756255 | false | 50987990 | 2025-03-06T05:23:03.248Z | 2025-01-21T10:27:41.000Z | 2024-12-18T09:26:26.741Z | Dakota Jones | 2025-01-21T10:27:43.180Z | driver | ||
| 22156724 | true | Fifth Wheel | Na | 281474982756255 | false | 50987990 | 2025-03-06T05:23:03.537Z | 2025-01-21T10:27:41.000Z | 2025-01-09T10:17:06.824Z | Dakota Jones | 2025-01-21T10:27:43.192Z | driver | ||
| 22156725 | true | Clutch | Na | 281474982756255 | false | 50987990 | 2025-03-06T05:23:03.537Z | 2025-01-21T10:27:41.000Z | 2025-01-09T10:17:06.824Z | Dakota Jones | 2025-01-21T10:27:43.197Z | driver | ||
| 22171284 | true | Fifth Wheel | Na | 281474982756255 | false | 50987990 | 2025-03-06T05:23:03.537Z | 2025-01-21T10:27:41.000Z | 2025-01-09T21:29:10.790Z | Dakota Jones | 2025-01-21T10:27:43.204Z | driver | ||
| 22171285 | true | Clutch | Na | 281474982756255 | false | 50987990 | 2025-03-06T05:23:03.537Z | 2025-01-21T10:27:41.000Z | 2025-01-09T21:29:10.790Z | Dakota Jones | 2025-01-21T10:27:43.209Z | driver | ||
| 22250357 | true | Clutch | None | 281474982756255 | false | 50987990 | 2025-03-06T05:23:03.538Z | 2025-01-21T10:27:41.000Z | 2025-01-14T11:14:41.012Z | Dakota Jones | 2025-01-21T10:27:43.216Z | driver | ||
| 22276841 | true | Clutch | None | 281474982756255 | false | 50987990 | 2025-03-06T05:23:03.538Z | 2025-01-21T10:27:41.000Z | 2025-01-15T10:57:11.703Z | Dakota Jones | 2025-01-21T10:27:43.222Z | driver | ||
| 22304295 | true | Clutch | None | 281474982756255 | false | 50987990 | 2025-03-06T05:23:03.538Z | 2025-01-21T10:27:41.000Z | 2025-01-16T10:39:33.739Z | Dakota Jones | 2025-01-21T10:27:43.228Z | driver | ||
| 22330657 | true | Coupling Devices | Na | 281474982756255 | false | 50987990 | 2025-03-06T05:23:03.538Z | 2025-01-21T10:27:41.000Z | 2025-01-17T09:30:45.491Z | Dakota Jones | 2025-01-21T10:27:43.233Z | driver | ||
| 22330658 | true | Fifth Wheel | Na | 281474982756255 | false | 50987990 | 2025-03-06T05:23:03.538Z | 2025-01-21T10:27:41.000Z | 2025-01-17T09:30:45.491Z | Dakota Jones | 2025-01-21T10:27:43.237Z | driver | ||
| 22330659 | true | Clutch | Na | 281474982756255 | false | 50987990 | 2025-03-06T05:23:03.538Z | 2025-01-21T10:27:41.000Z | 2025-01-17T09:30:45.491Z | Dakota Jones | 2025-01-21T10:27:43.240Z | driver | ||
| 22346069 | true | Coupling Devices | Ma | 281474982756255 | false | 50987990 | 2025-03-06T05:23:03.538Z | 2025-01-21T10:27:41.000Z | 2025-01-17T20:49:58.400Z | Dakota Jones | 2025-01-21T10:27:43.245Z | driver |