CRF Data Full

Full data set of Coronovirus Relief Fund (CRF) distributions by the US Governmen

@kaggle.danb91_crf_data_full

Table List

1 table(9.2 MB)

Crf Full Data

@kaggle.danb91_crf_data_full.crf_full_data

9.2 MB
202117 rows
20 columns

prime_recipient Prime Recipient	award_amount Award Amount	sub_recipient Sub-recipient	sub_recipient_address1 Sub-recipient Address1	sub_recipient_address2 Sub-recipient Address2	sub_recipient_address3 Sub-recipient Address3	city City	state State	zip Zip	county County	sub_recipient_congressional_district Sub-recipient Congressional District	award_number Award Number	award_type Award Type	award_description Award Description	sub_award_amount Sub-award Amount	money_spent_to_date Money Spent To Date	project_description Project Description	project_status Project Status	spending_category Spending Category	category_description Category Description
ABSENTEE SHAWNEE TRIBE OF OKLAHOMA	33101482.3	NOT YET AVAILABLE FOR PUBLIC DISPLAY	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	33101482.30039751		nan	nan	nan	nan
ADAMS, COUNTY OF	90285974.4	ADAMS 12 FIVE STAR SCHOOLS	1500 E 128TH AVE	nan	nan	DENVER	CO	80241-2601	CO-ADAMS	CO07	2	TRANSFER	Allocation to school district	8421866.47	245268.01	Allocation to school districts	Fully completed	Facilitating Distance Learning	nan
ADAMS, COUNTY OF	90285974.4	ADAMS 12 FIVE STAR SCHOOLS	1500 E 128TH AVE	nan	nan	DENVER	CO	80241-2601	CO-ADAMS	CO07	2	TRANSFER	Allocation to school district	8421866.47	5228843.14	nan	nan	Facilitating Distance Learning	nan
ADAMS, COUNTY OF	90285974.4	ADAMS 12 FIVE STAR SCHOOLS	1500 E 128TH AVE	nan	nan	DENVER	CO	80241-2601	CO-ADAMS	CO07	2	TRANSFER	Allocation to school district	8421866.47	339483.95	nan	nan	Food Programs	nan
ADAMS, COUNTY OF	90285974.4	ADAMS 12 FIVE STAR SCHOOLS	1500 E 128TH AVE	nan	nan	DENVER	CO	80241-2601	CO-ADAMS	CO07	2	TRANSFER	Allocation to school district	8421866.47	75972.24	nan	nan	Improve Telework Capabilities of Public Employees	nan
ADAMS, COUNTY OF	90285974.4	ADAMS 12 FIVE STAR SCHOOLS	1500 E 128TH AVE	nan	nan	DENVER	CO	80241-2601	CO-ADAMS	CO07	2	TRANSFER	Allocation to school district	8421866.47	2026730.21	nan	nan	Personal Protective Equipment	nan
ADAMS, COUNTY OF	90285974.4	ADAMS 12 FIVE STAR SCHOOLS	1500 E 128TH AVE	nan	nan	DENVER	CO	80241-2601	CO-ADAMS	CO07	2	TRANSFER	Allocation to school district	8421866.47	275480.54	nan	nan	Payroll for Public Health and Safety Employees	nan
ADAMS, COUNTY OF	90285974.4	ADAMS 12 FIVE STAR SCHOOLS	1500 E 128TH AVE	nan	nan	DENVER	CO	80241-2601	CO-ADAMS	CO07	2	TRANSFER	Allocation to school district	8421866.47	167850.14	nan	nan	Public Health Expenses	nan
ADAMS, COUNTY OF	90285974.4	ADAMS 12 FIVE STAR SCHOOLS	1500 E 128TH AVE	nan	nan	DENVER	CO	80241-2601	CO-ADAMS	CO07	2	TRANSFER	Allocation to school district	8421866.47	62238.24	nan	nan	COVID-19 Testing and Contact Tracing	nan
ADAMS, COUNTY OF	90285974.4	ADAMS COUNTY FIRE PROTECTION DISTRICT	8055 N WASHINGTON ST	nan	nan	DENVER	CO	80229-5818	CO-ADAMS	CO07	1	TRANSFER	Allocation to fire district	167603.09	809.4	Allocation to fire districts	Fully completed	Personal Protective Equipment	nan


CREATE TABLE crf_full_data (
  "prime_recipient" VARCHAR,
  "award_amount" DOUBLE,
  "sub_recipient" VARCHAR,
  "sub_recipient_address1" VARCHAR,
  "sub_recipient_address2" VARCHAR,
  "sub_recipient_address3" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" VARCHAR,
  "county" VARCHAR,
  "sub_recipient_congressional_district" VARCHAR,
  "award_number" VARCHAR,
  "award_type" VARCHAR,
  "award_description" VARCHAR,
  "sub_award_amount" DOUBLE,
  "money_spent_to_date" DOUBLE,
  "project_description" VARCHAR,
  "project_status" VARCHAR,
  "spending_category" VARCHAR,
  "category_description" VARCHAR
);