Started digging into this and while transactions are listed, there& #39;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">https://twitter.com/MayorBMSc...

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

Those are the spending_description fields that have at least 1 null amount

Also apparently there& #39;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

Total amount hitting the " Grenades" fund is null and there& #39;s a weird preceding space, so I& #39;m thinking this is another ETL issue.