fedspendingtransparency/usaspending-api

View on GitHub
usaspending_api/database_scripts/etl/recipient_profile_delta_view.sql

Summary

Maintainability
Test Coverage
DROP VIEW IF EXISTS recipient_profile_delta_view;

CREATE VIEW recipient_profile_delta_view AS
SELECT
  "id",
  "recipient_hash",
  "recipient_name",
  "uei",
  "recipient_level"
FROM
  "recipient_profile"