Surveillance tech: data-quality report (read this before quoting anything)

Custom SQL query returning 6 rows (hide)

SELECT 'exact/near duplicate rows'        AS issue, count(*) AS rows
  FROM surveillance_spending WHERE dup_rank > 1
UNION ALL SELECT 'ceilings ("not to exceed"), not payments', count(*)
  FROM surveillance_spending WHERE amount_type = 'ceiling'
UNION ALL SELECT 'proposed / recommended, not approved', count(*)
  FROM surveillance_spending WHERE amount_type IN ('proposed','recommended')
UNION ALL SELECT 'estimated amounts', count(*)
  FROM surveillance_spending WHERE amount_type = 'estimated'
UNION ALL SELECT 'city attribution disagrees with source link', count(*)
  FROM surveillance_spending WHERE geo_suspect = 1
UNION ALL SELECT 'implausible amount, needs manual review', count(*)
  FROM surveillance_spending WHERE anomaly = 1

Edit SQL