Baselight

All 311 City Service Requests - Last 30 Days

District of Columbia

@usgov.district_of_columbia_all_311_city_service_requests_las_0dd07a26

Loading...
Loading...

About this Dataset

All 311 City Service Requests - Last 30 Days

Data provided here are from the DC's 311 service request center. They represent all service requests such as abandoned automobiles, parking meter repair and bulk trash pickup. Requests are received by the Office of Unified Communications (OUC) through the Mayor's Call Center (311), citizens web intake at https://311.dc.gov, electronic and US mail service or via other methods of communication. The Office of Unified Communications (OUC) oversees the designated call center for all 311 calls and for all District 911 calls.

Please also visit the DC 311 Service Request Map which allows the public to see service requests in the last 30 days. Users can view requests by Ward within charts. Just set the area filter to select service requests. Click on a service request to view details.
Organization: District of Columbia
Last updated: 2024-09-10T20:13:29.329088
Tags: 311, dc, district-of-columbia, livedataset, ouc, public-service, resident, service-requests, washington-dc

Tables

Table 1

@usgov.district_of_columbia_all_311_city_service_requests_las_0dd07a26.table_1
  • 11.98 MB
  • 115639 rows
  • 37 columns
Loading...

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "servicerequestid" VARCHAR,
  "streetaddress" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zipcode" DOUBLE,
  "servicecode" VARCHAR,
  "servicecodedescription" VARCHAR,
  "servicetypecodedescription" VARCHAR,
  "organizationacronym" VARCHAR,
  "servicecallcount" BIGINT,
  "adddate" TIMESTAMP,
  "resolutiondate" TIMESTAMP,
  "serviceduedate" TIMESTAMP,
  "serviceorderdate" TIMESTAMP,
  "inspectionflag" VARCHAR,
  "inspectiondate" VARCHAR,
  "inspectorname" VARCHAR,
  "serviceorderstatus" VARCHAR,
  "status_code" VARCHAR,
  "priority" VARCHAR,
  "details" VARCHAR,
  "ward" VARCHAR,
  "xcoord" DOUBLE,
  "ycoord" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "maraddressrepositoryid" BIGINT,
  "gis_id" VARCHAR,
  "globalid" VARCHAR,
  "created" VARCHAR,
  "edited" VARCHAR,
  "gdb_from_date" TIMESTAMP,
  "gdb_to_date" VARCHAR,
  "gdb_archive_oid" BIGINT,
  "objectid" BIGINT
);

Share link

Anyone who has the link will be able to view this.