Information on all MC311 Service Requests received (via email or phone) since July 1, 2012. This data is updated daily. The PIO’s business requirement includes adding the following data elements to the new and enhanced open data site being proposed by DTS. This data is derived from requests for service which originate in the CSC, from the County’s web portal, and via “walk-ins” from county departments including but not limited to DHCA. • SLA – to indicate the number of days in county business days the department has to fulfill the request. County business days must exclude weekends, county holidays and days when the county is closed due to inclement weather (snow days, etc) per CountyStat’s business requirement. This field has been published in the existing MC311 Service Requests dataset with the field name ‘Attached Solution SLA Days’. • +/- SLA –to indicate the number of days a service request is over or under SLA as is currently measured by CountyStat. The following 4 fields will be added to fulfill this line item # of days open – Number of County Business days the Service Request has been opened. Within SLA Window? - To indicate the number of days a service request is over or under SLA as is currently measured by CountyStat. SLA Yes – Number of days to fulfill the service request is under the SLA window. SLA No -– Number of days to fulfill the service request is over the SLA window.
This dataset has the following 24 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| SR ID | sr_num | text | Service Request ID Number (unique identifier) assigned by the MC311 Call Center | 1106504424 1106517966 1106521542 1106536112 1106542661 view top 100 |
| Opened | created | calendar_date | Date & Time the MC311 Service Request was opened | 2015-06-02T14:36:17.000 2020-07-17T13:21:49.000 2014-05-27T16:33:43.000 2017-04-20T13:27:14.000 2019-11-15T10:28:37.000 view top 100 |
| Closed | closed | calendar_date | Date & Time the MC311 Service Request was closed | 2018-05-04T08:44:48.000 2018-03-23T15:58:31.000 2018-07-20T09:28:09.000 2018-01-29T15:06:56.000 2022-05-23T11:13:33.000 view top 100 |
| Status | sr_stat_id | text | Current status (since the last daily update) of the MC311 Service Request (Closed, In Progress) | Closed In Progress view top 100 |
| Department | department | text | Code for the County Department assigned to resolve the Service Request | DEP view top 100 |
| Area | sr_area | text | Area in the County Department assigned to resolve the Service Request | Solid Waste view top 100 |
| Sub-Area | sr_sub_area | text | Sub-Area in the County Department/Area assigned to resolve the Service Request | Cart Repair Cart Single Family Cart Townhouse Cart Pick-Up Cart Missing view top 100 |
| Attached Solution (Topic) | faq_ques_text | text | Describes the solution selected to resolve the Service Request | Cart Repair (Paper Recycling) Cart Repair Request 65 Gallon Cart Delivery (Paper Recycling) 35 Gallon Cart Delivery (Paper Recycling) Cart Repair view top 100 |
| Attached Solution SLA Days | x_sla | number | Service Level Agreement (SLA) for the number of days expected for the attached solution to resolve the Service Request | 10 8 15 6 7 view top 100 |
| City | x_city | text | City location for the Service Request (where available) | SILVER SPRING Silver Spring BETHESDA ROCKVILLE POTOMAC view top 100 |
| State | x_state | text | State location for the Service Request | MD view top 100 |
| Zip Code | x_zipcode | text | 5 digit postal Zip Code for the Service Request (where available) | 20854 20817 20902 20906 20901 view top 100 |
| Source | sr_subtype_cd | text | Source for receiving the Service Request (examples: Web, Phone) | Phone Internal Web CE Event Twitter view top 100 |
| Election District | x_electiondist | text | Election District, where location is available | 13 7 5 9 10 view top 100 |
| Maryland State District | x_mdstatedist | text | Maryland State Election District number, where location is available | 16 14 15 18 19 view top 100 |
| Congressional District | x_congdist | text | U. S. Congressional District, where location is available | 8 6 3 4 0 view top 100 |
| Congressional Member | x_cong_memb | text | U. S. Congress Member for the location, where location is available | CHRISTOPHER VAN HOLLEN,JR -Dem JAMIE RASKIN. (Democrat) DAVID TRONE (Democrat) JOHN K. DELANEY -Dem Jamie Raskin -Dem view top 100 |
| Council District | x_councildist | text | Montgomery County Council District, where location is available | 1 4 2 5 3 view top 100 |
| Council Member Name | x_councilmbr | text | Montgomery County Council Member for the location, where location is available | Nancy Navarro Craig Rice Roger Berliner Tom Hucker Andrew Friedson view top 100 |
| Changed Date | last_upd | calendar_date | Date & Time the MC311 Service Request record was last updated in the system | 2024-05-24T14:02:23.000 2018-05-04T12:44:48.000 2018-03-23T19:58:31.000 2018-07-20T13:28:09.000 2018-01-29T20:06:56.000 view top 100 |
| # of Days Open | number_of_days_open | number | Number of County Business days the Service Request has been opened. | 6 7 5 8 4 view top 100 |
| Within SLA Windows | within_sla_window | text | To indicate the number of days a service request is over or under SLA as is currently measured by CountyStat. | Yes No view top 100 |
| SLA Yes | sla_yes | text | Number of days to fulfill the service request is under the SLA window. | 1 0 view top 100 |
| SLA No | sla_no | text | Number of days to fulfill the service request is over the SLA window. | 0 1 view top 100 |