Read on Twitter
Started digging into this and while transactions are listed, there's no dollar amount for either gas or ammunition for @BaltimorePolice. @BillforBmore, @MayorBMScott is this something we can address? https://twitter.com/MayorBMScott/status/1382765614880731141
It looks like most of the null values for amount have a single quotation mark in the spending_description field. I think you might want to talk to whoever is doing the ETL for the database and have them check on the data validation for this field.
Unallocated Capital Improvements
"Ammunition
Capital Project Contract Cost - General
Consultants
and Repairs"
Site Improvements
Rental of Real Property
Demolition
and Attraction of Businesses (BDC)"
Surveys
Advertising
"Gas
Purchase of Site or Right of Way
Appraisal Services
"Ammunition
Capital Project Contract Cost - General
Consultants
and Repairs"
Site Improvements
Rental of Real Property
Demolition
and Attraction of Businesses (BDC)"
Surveys
Advertising
"Gas
Purchase of Site or Right of Way
Appraisal Services
Those are the spending_description fields that have at least 1 null amount
Also apparently there's a "Grenades" fund? List of funds that the police department hits:
Police Capital Project Fund
Special Revenue
Federal Grants Fund
NA
Baltimore Casino
State Grants Fund
Grenades
General Fund
Electric
Police Capital Project Fund
Special Revenue
Federal Grants Fund
NA
Baltimore Casino
State Grants Fund
Grenades
General Fund
Electric
Total amount hitting the " Grenades" fund is null and there's a weird preceding space, so I'm thinking this is another ETL issue.
