Name: Environmental Citations
Creator: US Government
License: http://creativecommons.org/licenses/by/3.0

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.
Organization: City of Baltimore
Last updated: 2024-06-08T09:10:36.366740
Tags: citations, city-services, environment, public-work

Tables

Table 1

@usgov.city_of_baltimore_environmental_citations_01d16.table_1

1.31 MB
16,000 rows
31 columns

CREATE TABLE table_1 (
  "objectid" 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,
  "globalid" VARCHAR
);