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 | 1468423053 1469196143 1481163625 1482598759 1483429822 view top 100 |
Opened | created | calendar_date | Date & Time the MC311 Service Request was opened | 2021-09-03T13:31:01.000 2021-09-12T07:21:08.000 2022-01-07T11:23:54.000 2022-01-24T08:27:48.000 2022-02-02T14:08:33.000 view top 100 |
Closed | closed | calendar_date | Date & Time the MC311 Service Request was closed | view top 100 |
Status | sr_stat_id | text | Current status (since the last daily update) of the MC311 Service Request (Closed, In Progress) | In Progress view top 100 |
Department | department | text | Code for the County Department assigned to resolve the Service Request | DOT view top 100 |
Area | sr_area | text | Area in the County Department assigned to resolve the Service Request | Tree Maintenance view top 100 |
Sub-Area | sr_sub_area | text | Sub-Area in the County Department/Area assigned to resolve the Service Request | Tree Planting Requests view top 100 |
Attached Solution (Topic) | faq_ques_text | text | Describes the solution selected to resolve the Service Request | Request County to Plant a Tree 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 | 260 view top 100 |
City | x_city | text | City location for the Service Request (where available) | Silver Spring Bethesda Rockville Kensington 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) | 20817 20902 20895 20901 20853 view top 100 |
Source | sr_subtype_cd | text | Source for receiving the Service Request (examples: Web, Phone) | Web Phone Internal view top 100 |
Election District | x_electiondist | text | Election District, where location is available | 13 7 4 5 8 view top 100 |
Maryland State District | x_mdstatedist | text | Maryland State Election District number, where location is available | 18 16 19 20 15 view top 100 |
Congressional District | x_congdist | text | U. S. Congressional District, where location is available | 8 6 3 view top 100 |
Congressional Member | x_cong_memb | text | U. S. Congress Member for the location, where location is available | JAMIE RASKIN. (Democrat) DAVID TRONE (Democrat) JOHN P. SARBANES (Democrat) view top 100 |
Council District | x_councildist | text | Montgomery County Council District, where location is available | 6 1 4 5 7 view top 100 |
Council Member Name | x_councilmbr | text | Montgomery County Council Member for the location, where location is available | Andrew Friedson Natali Fani-Gonz??A!lez Kate Stewart Dawn Luedtke Kristin Mink view top 100 |
Changed Date | last_upd | calendar_date | Date & Time the MC311 Service Request record was last updated in the system | 2021-09-15T11:04:07.000 2022-01-07T16:47:20.000 2022-01-24T14:19:14.000 2022-02-02T19:33:03.000 2022-03-01T12:16:09.000 view top 100 |
# of Days Open | number_of_days_open | number | Number of County Business days the Service Request has been opened. | 46 269 279 221 24 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 |