Environmental Citations by US Government | Environmental and Climate Sciences

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.25 MB
16000 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
);