About this Dataset

Funding API Updated

Funding API filtering out the "No Award" for Status from the original "Funding" dataset
with the URL: https://data.ojp.usdoj.gov/Funding-API/Funding/a7v8-ei2f
Provided data for the Coronavirus Emergency Supplemental Funding (CESF) Program, Grants and Funding Statisics, and BJA - Coronavirus Emergency Supplemental Funding (CESF) Program.
Organization: Department of Justice
Last updated: 2025-03-12T18:21:39.631656
Tags: awards, funding, grant-award-grantee, grants, solicitations

Tables

Funding - Download

@usgov.doj_gov_funding.funding_download

117.72 MB
120665 rows
69 columns


CREATE TABLE funding_download (
  "award_name" VARCHAR,
  "award_number" VARCHAR,
  "award_amount" DOUBLE,
  "award_date" TIMESTAMP,
  "city" VARCHAR,
  "county" VARCHAR,
  "congressional_district" VARCHAR,
  "state" VARCHAR,
  "office" VARCHAR,
  "opportunity_id" VARCHAR,
  "award_status" VARCHAR,
  "award_count" BIGINT,
  "title" VARCHAR,
  "description" VARCHAR,
  "fsafy" BIGINT,
  "fsagmsid" VARCHAR,
  "fsasolicitationtype" VARCHAR,
  "fsasolicitationtypecode" VARCHAR,
  "maximum_amount" DOUBLE,
  "fsaflooramount" DOUBLE,
  "fsaobligatedawardamount" DOUBLE,
  "fsaregistrationdeadline" VARCHAR,
  "fsaapplicationdeadline" VARCHAR,
  "fsaactualrelease" VARCHAR,
  "fsaupdateddate" VARCHAR,
  "fsaevaluation" VARCHAR,
  "fsacoordination" VARCHAR,
  "fsadeliverables" VARCHAR,
  "fsagovtrackingno" VARCHAR,
  "fsaactive" BOOLEAN,
  "fsaprojecttitle" VARCHAR,
  "fsasupplementnumber" BIGINT,
  "fsaapplicationid" VARCHAR,
  "fsaapplicationnumber" VARCHAR,
  "fsagranttype" VARCHAR,
  "fsaactivitiescats" VARCHAR,
  "fsaactivitiessubcats" VARCHAR,
  "fsasubjectmattercats" VARCHAR,
  "fsasubjectmattersubcats" VARCHAR,
  "fsafocusgroupscats" VARCHAR,
  "fsafocusgroupssubcats" VARCHAR,
  "fsaeligibleappcats" VARCHAR,
  "fsaeligibleappsubcats" VARCHAR,
  "fsagrantmanager" VARCHAR,
  "fsainvestigator" VARCHAR,
  "fsafilename" VARCHAR,
  "load_date" VARCHAR,
  "location_state" VARCHAR,
  "program_description" VARCHAR,
  "location_city" VARCHAR,
  "zip" DOUBLE,
  "zip4" DOUBLE,
  "location_zip" VARCHAR,
  "fsaestimatedprogramfunding" DOUBLE,
  "fsaestimatedawardaverage" DOUBLE,
  "fsaawardqtr" VARCHAR,
  "fsanumawards" DOUBLE,
  "fsaannouncementurl" VARCHAR,
  "fsaexpectedreleaseqtr" VARCHAR,
  "fsaprogramplaninitiative" VARCHAR,
  "fsaawardtype" VARCHAR,
  "fsasystem" VARCHAR,
  "fsasolstatus" VARCHAR,
  "fsadisclaimer" VARCHAR,
  "fsapocemail" VARCHAR,
  "messageid" VARCHAR,
  "fsauniqueidentifier" VARCHAR,
  "fsapocphone" VARCHAR,
  "data_updated_at" VARCHAR
);