From a 500-row sample across 8 columns.
| svc_request_number | workorder_number | workorder_activity_code | workorder_activity_description | workorder_added | time_stamp | workorder_started | workorder_completed |
|---|---|---|---|---|---|---|---|
| 860449 | 895401 | SA25 | REPAIR CONNECTION | 2004-07-16T10:00:04.000 | 2015-07-07T00:45:01.000 | — | — |
| 168089 | 100322 | SA27 | PERFORM OTHER MANHOLE WORK | 2000-06-01T13:20:07.000 | 2015-06-29T00:40:55.000 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
svc_request_number | integer | Link to Service Requests where applicable | 0% | 186167551187509181186022279 |
workorder_number | integer | Primary key for work order | 0% | 843072196843082331843018596 |
workorder_activity_code | text | Activity being performed | 0% | SCCSSFCWL3D |
workorder_activity_description | text | Literal descriptor of activity | 0% | CLEAN CATCH BASIN/INLETFLUSH PAST HOUSE CONNECT… |
GET /api/datasets/4fvw-nn9c GET /api/datasets/4fvw-nn9c/quality GET /api/datasets/4fvw-nn9c/related GET /api/columns?dataset=4fvw-nn9c
| — |
| — |
| 428803 | 843089280 | WA10 | RESET/REPLACE VALVE BOX | 2002-04-08T23:03:19.000 | 2015-06-16T00:45:01.000 | 2015-06-10T08:20:00.000 | 2015-06-10T11:00:00.000 |
| 185634611 | 842762063 | SA26 | REPLACE MANHOLE CASTING | 2013-09-03T09:13:14.000 | 2016-02-26T00:45:03.000 | 2016-02-25T00:45:00.000 | 2016-02-25T03:00:00.000 |
| 895478 | 842882322 | SRL | LINE SEWER (CONTRACTOR) | 2014-04-23T13:47:23.000 | 2017-01-10T00:45:01.000 | 2016-11-29T00:00:00.000 | 2016-12-13T00:00:00.000 |
| 2011048 | 1780489 | WHF | FLUSH HYDRANTS IN AREA | 2008-12-02T13:48:23.000 | 2016-02-18T00:45:01.000 | 2016-02-17T17:41:00.000 | 2016-02-17T17:41:00.000 |
| 185673001 | 843073274 | SVAC | VACTOR SEWER | 2015-05-07T10:25:54.000 | 2015-05-08T00:45:09.000 | 2015-05-05T10:45:00.000 | 2015-05-05T11:45:00.000 |
| 185645826 | 843047233 | SRB | REPAIR SEWER BREAK (CONTRACT.) | 2015-04-03T08:15:43.000 | 2015-11-24T00:45:08.000 | 2015-11-14T07:00:00.000 | 2015-11-17T15:00:00.000 |
| 1011746 | 1006805 | SA25 | REPAIR CONNECTION | 2005-02-16T11:18:09.000 | 2015-07-07T00:45:01.000 | — | — |
| 185537818 | 843454743 | SCC | CLEAN CATCH BASIN/INLET | 2016-08-01T20:54:30.000 | 2016-08-02T00:45:02.000 | 2016-06-30T11:40:00.000 | 2016-06-30T12:45:00.000 |
ISSUE 3-DAY NOTICEworkorder_started | datetime | When work order was started | 8% | 2022-01-19T00:00:00.0002024-06-12T00:00:00.0002021-05-17T10:00:00.000 |
workorder_completed | datetime | When work order was completed | 8% | 2019-04-09T00:00:00.0002022-01-19T00:05:00.0002025-09-26T00:00:00.000 |
workorder_added | datetime | When work order was added into system | 0% | 2016-04-04T10:36:11.0002015-11-16T15:59:21.0002015-10-20T13:37:53.000 |
time_stamp | datetime | — | 0% | 2025-08-07T00:50:02.0002022-08-02T00:50:02.0002021-09-29T00:50:02.000 |