About this Dataset

311 Citizen Requests For Service

This dataset includes all requests for service received from the City-Parish 311 Call Center, including requests for service submitted online and through the Red Stick 311 mobile application, dating back to January 1, 2016. Submitter names, phone numbers, and e-mail addresses are redacted for privacy purposes. Data is updated daily from the Public Works Business Office and 311 Call Center.

Phone numbers are redacted to protect the contact information and privacy of citizens by replacing raw digits with XXX-XXX-XXXX. For any questions about this process, please contact opendata@brgov.com.
Organization: City of Baton Rouge
Last updated: 2020-11-12T14:59:53.547239
Tags: 311, public-works, request, service

Tables

Table 1

@usgov.city_of_baton_rouge_311_citizen_requests_for_service.table_1

91.29 MB
906,885 rows
23 columns

CREATE TABLE table_1 (
  "service_request_id" BIGINT,
  "status" VARCHAR,
  "create_date" VARCHAR,
  "close_date" VARCHAR,
  "last_action_date" VARCHAR,
  "parent_type" VARCHAR,
  "type" VARCHAR,
  "comments" VARCHAR,
  "street_number" VARCHAR,
  "street_name" VARCHAR,
  "full_address" VARCHAR,
  "cross_street" VARCHAR,
  "city" VARCHAR,
  "department" VARCHAR,
  "division" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "geolocation" VARCHAR,
  "typei_d" BIGINT,
  "parent_id" BIGINT,
  "deptdiv_id" BIGINT,
  "department_division_name" VARCHAR,
  "status_id" BIGINT
);