WSSC Completed Service Alert Work Orders

Dataset

Name	Value
Catalog	Link
Metadata	Link
Data: JSON	100 Rows
Data: CSV	100 Rows
Host	data.montgomerycountymd.gov
Id	4tjk-62h7
Name	WSSC Completed Service Alert Work Orders
Attribution	Montgomery County, MD
Category	Community/Recreation
Tags	wssc work orders
Created	2015-12-08T23:22:22Z
Publication Date	2016-05-05T18:56:39Z

Description

WSSC completed service alert work-orders published on a monthly basis

Columns

| Included | Schema Type | Field Name            | Name                  | Data Type     | Render Type   |
| ======== | =========== | ===================== | ===================== | ============= | ============= |
| Yes      | series tag  | work_order_number     | Work Order Number     | text          | number        |
| Yes      | time        | date_received         | Date Received         | calendar_date | calendar_date |
| No       |             | time_of_day_received  | Time of Day Received  | text          | text          |
| Yes      | series tag  | am_pm_received        | AM or PM Received     | text          | text          |
| No       |             | date_completed        | DATE COMPLETED        | calendar_date | calendar_date |
| No       |             | time_completed        | TIME COMPLETED        | text          | text          |
| Yes      | series tag  | am_pm_completed       | AM PM COMPLETED       | text          | text          |
| Yes      | series tag  | work_description_code | WORK DESCRIPTION CODE | text          | text          |
| Yes      | series tag  | work_description      | WORK DESCRIPTION      | text          | text          |

Time Field

Value = date_received
Format & Zone = yyyy-MM-dd'T'HH:mm:ss

Series Fields

Excluded Fields = time_of_day_received,date_completed,time_completed

Data Commands

series e:4tjk-62h7 d:2015-08-28T00:00:00.000Z t:work_order_number=2443233 t:work_description_code=205 t:am_pm_received=AM t:work_description="DISCOLORED WATER" m:row_number.4tjk-62h7=1

series e:4tjk-62h7 d:2015-11-10T00:00:00.000Z t:work_order_number=2470704 t:work_description_code=901 t:am_pm_completed=PM t:am_pm_received=PM t:work_description="EMERG REPAIR TEMP PATCH" m:row_number.4tjk-62h7=2

series e:4tjk-62h7 d:2015-11-24T00:00:00.000Z t:work_order_number=2474393 t:work_description_code=217 t:am_pm_completed=PM t:am_pm_received=PM t:work_description="INSPECT FOR SERVICE LEAK" m:row_number.4tjk-62h7=3

Meta Commands

metric m:row_number.4tjk-62h7 p:long l:"Row Number"

entity e:4tjk-62h7 l:"WSSC Completed Service Alert Work Orders" t:attribution="Montgomery County, MD" t:url=https://data.montgomerycountymd.gov/api/views/4tjk-62h7

property e:4tjk-62h7 t:meta.view v:id=4tjk-62h7 v:category=Community/Recreation v:averageRating=0 v:name="WSSC Completed Service Alert Work Orders" v:attribution="Montgomery County, MD"

property e:4tjk-62h7 t:meta.view.license v:name="Public Domain"

property e:4tjk-62h7 t:meta.view.owner v:id=ajn4-zy65 v:screenName="MCG ESB Service" v:lastNotificationSeenAt=1491401045 v:displayName="MCG ESB Service"

property e:4tjk-62h7 t:meta.view.tableauthor v:id=ajn4-zy65 v:screenName="MCG ESB Service" v:roleName=administrator v:lastNotificationSeenAt=1491401045 v:displayName="MCG ESB Service"

Top Records

| work_order_number | date_received       | time_of_day_received | am_pm_received | date_completed      | time_completed | am_pm_completed | work_description_code | work_description         | 
| ================= | =================== | ==================== | ============== | =================== | ============== | =============== | ===================== | ======================== | 
| 2443233           | 2015-08-28T00:00:00 | 11:19                | AM             | 2015-08-28T00:00:00 | 00:00          |                 | 205                   | DISCOLORED WATER         | 
| 2470704           | 2015-11-10T00:00:00 | 06:43                | PM             | 2015-11-10T00:00:00 | 12:00          | PM              | 901                   | EMERG REPAIR TEMP PATCH  | 
| 2474393           | 2015-11-24T00:00:00 | 04:05                | PM             | 2015-11-24T00:00:00 | 05:25          | PM              | 217                   | INSPECT FOR SERVICE LEAK | 
| 2438891           | 2015-08-06T00:00:00 | 08:16                | AM             | 2015-08-06T00:00:00 | 00:00          |                 | 217                   | INSPECT FOR SERVICE LEAK | 
| 2454952           | 2015-09-30T00:00:00 | 11:07                | AM             | 2015-09-30T00:00:00 | 12:00          | AM              | 401                   | REPAIR INSIDE METER LEAK | 
| 2317657           | 2014-07-30T00:00:00 | 10:01                | AM             | 2014-07-30T00:00:00 | 00:00          |                 | 107                   | INSPECT SEWER ODOR       | 
| 2472094           | 2015-10-01T00:00:00 | 08:02                | PM             | 2015-10-06T00:00:00 | 00:00          | PM              | 214                   | REPLACE VALVE BOX COVER  | 
| 2440137           | 2015-08-13T00:00:00 | 12:24                | PM             | 2015-08-13T00:00:00 | 00:00          |                 | 205                   | DISCOLORED WATER         | 
| 2617369           | 2017-03-26T00:00:00 | 03:45                | PM             | 2017-03-26T00:00:00 | 08:45          | PM              | 073                   | SSO EVENT:OTHER          | 
| 2613391           | 2017-03-14T00:00:00 | 03:40                | PM             | 2017-03-14T00:00:00 | 04:00          | PM              | 106                   | CLEAN BASEMENT/SEWER     |