About this Dataset

Environmental Citations

This dataset represent Environmental citations that are often issued for violations of Baltimore City codes related to sanitation, health, safety, and other quality-of-life issues.

If you have any questions or need to report an issue for this dataset, please use the following feedback form to submit your response, and the Open Baltimore support team will contact you.
Organization: City of Baltimore
Last updated: 2025-10-18T21:58:22.231753
Tags: citations, city-services, environment

Tables

Table 1

@usgov.city_of_baltimore_environmental_citations_527cb.table_1

13.91 MB
331,030 rows
30 columns

CREATE TABLE table_1 (
  "rowid" BIGINT,
  "citationno" BIGINT,
  "liencode" VARCHAR,
  "violationdate" TIMESTAMP,
  "duedate" TIMESTAMP,
  "agency" VARCHAR,
  "fineamount" BIGINT,
  "description" VARCHAR,
  "balance" DOUBLE,
  "lastpaiddate" TIMESTAMP,
  "lastpaidamount" DOUBLE,
  "hearingdate" TIMESTAMP,
  "hearingrequestreceiveddate" TIMESTAMP,
  "citationstatus" VARCHAR,
  "violationcodearticle" VARCHAR,
  "violationcodesection" VARCHAR,
  "violationlocation" VARCHAR,
  "block" VARCHAR,
  "lot" VARCHAR,
  "officerid" VARCHAR,
  "officerpresencerequested" VARCHAR,
  "hearingstatus" VARCHAR,
  "heartime" VARCHAR,
  "totalpaid" DOUBLE,
  "totalabated" DOUBLE,
  "totalvoided" DOUBLE,
  "neighborhood" VARCHAR,
  "policedistrict" VARCHAR,
  "councildistrict" DOUBLE,
  "location" VARCHAR
);