Grant Data From Funders
Cambridgeshire Insight
@ukgov.grant_data_from_funders1
Cambridgeshire Insight
@ukgov.grant_data_from_funders1
CREATE TABLE grants_from_funders_cambridgeshire_and_peterborough (
"identifier" VARCHAR,
"title" VARCHAR,
"description" VARCHAR,
"currency" VARCHAR,
"amount_awarded" BIGINT,
"award_date" TIMESTAMP,
"url" VARCHAR,
"planned_dates_duration_months" VARCHAR,
"recipient_org_identifier" VARCHAR,
"recipient_org_name" VARCHAR,
"recipient_org_charity_number" VARCHAR,
"recipient_org_company_number" VARCHAR,
"recipient_org_location_0_geographic_code_type" VARCHAR,
"recipient_org_location_0_geographic_code" VARCHAR,
"recipient_org_location_0_name" VARCHAR,
"recipient_org_location_1_geographic_code_type" VARCHAR,
"recipient_org_location_1_geographic_code" VARCHAR,
"recipient_org_location_1_name" VARCHAR,
"recipient_org_location_2_geographic_code_type" VARCHAR,
"recipient_org_location_2_geographic_code" VARCHAR,
"recipient_org_location_2_name" VARCHAR,
"funding_org_identifier" VARCHAR,
"funding_org_name" VARCHAR,
"beneficiary_location_0_name" VARCHAR,
"beneficiary_location_0_country_code" VARCHAR,
"beneficiary_location_0_geographic_code" VARCHAR,
"beneficiary_location_0_geographic_code_type" VARCHAR,
"beneficiary_location_1_name" VARCHAR,
"beneficiary_location_1_country_code" VARCHAR,
"beneficiary_location_1_geographic_code" VARCHAR,
"beneficiary_location_1_geographic_code_type" VARCHAR,
"beneficiary_location_2_name" VARCHAR,
"beneficiary_location_2_country_code" VARCHAR,
"beneficiary_location_2_geographic_code" VARCHAR,
"beneficiary_location_2_geographic_code_type" VARCHAR,
"beneficiary_location_3_name" VARCHAR,
"beneficiary_location_3_country_code" VARCHAR,
"beneficiary_location_3_geographic_code" VARCHAR,
"beneficiary_location_3_geographic_code_type" VARCHAR,
"beneficiary_location_4_name" VARCHAR,
"beneficiary_location_4_country_code" VARCHAR,
"beneficiary_location_4_geographic_code" VARCHAR,
"beneficiary_location_4_geographic_code_type" VARCHAR,
"beneficiary_location_5_name" VARCHAR,
"beneficiary_location_5_country_code" VARCHAR,
"beneficiary_location_5_geographic_code" VARCHAR,
"beneficiary_location_5_geographic_code_type" VARCHAR,
"beneficiary_location_6_name" VARCHAR,
"beneficiary_location_6_country_code" VARCHAR,
"beneficiary_location_6_geographic_code" VARCHAR,
"beneficiary_location_6_geographic_code_type" VARCHAR,
"beneficiary_location_7_name" VARCHAR,
"beneficiary_location_7_country_code" VARCHAR,
"beneficiary_location_7_geographic_code" VARCHAR,
"beneficiary_location_7_geographic_code_type" VARCHAR,
"the_following_fields_are_not_in_the_360_giving_standar_69d31aae" VARCHAR,
"data_source" VARCHAR,
"publisher_name" VARCHAR,
"recipient_region" VARCHAR,
"recipient_district" VARCHAR,
"recipient_ward" VARCHAR,
"retrieved_for_use_in_grantnav" TIMESTAMP,
"license_see_note" VARCHAR,
"note_this_also_contains_os_crown_copyright_and_databas_b778c606" VARCHAR
);
Anyone who has the link will be able to view this.