Business Rates - Rochdale Borough Council
Rochdale Borough Council
@ukgov.business_rates_rochdale_borough_council
Rochdale Borough Council
@ukgov.business_rates_rochdale_borough_council
CREATE TABLE table_1 (
"property_reference" VARCHAR,
"account_holder_1" VARCHAR,
"account_holder_2" VARCHAR,
"property_name_1" VARCHAR,
"property_name_2" VARCHAR,
"property_address_1" VARCHAR,
"property_address_2" VARCHAR,
"property_address_3" VARCHAR,
"property_address_4" VARCHAR,
"property_post_code" VARCHAR,
"liable_from" VARCHAR,
"rv" VARCHAR,
"description" VARCHAR,
"empty_y_n" VARCHAR,
"empty_from_date" VARCHAR,
"discretionary_rate_relief" BIGINT,
"mandatory_relief" BIGINT,
"small_busienss_rate_relief_y_n" VARCHAR,
"empty_exemption_type" VARCHAR,
"chief_executive_relief_y_n" VARCHAR,
"retail_hostitality_leisure_relief_y_n" VARCHAR,
"transitional_or_supporting_small_business_relief_y_n" VARCHAR
);
CREATE TABLE table_2 (
"property_reference" VARCHAR,
"account_holder_1" VARCHAR,
"account_holder_2" VARCHAR,
"property_name_1" VARCHAR,
"property_name_2" VARCHAR,
"property_address_1" VARCHAR,
"property_address_2" VARCHAR,
"property_address_3" VARCHAR,
"property_address_4" VARCHAR,
"property_post_code" VARCHAR,
"liable_from" VARCHAR,
"rv" DOUBLE,
"description" VARCHAR,
"empty_y_n" VARCHAR,
"empty_from" VARCHAR,
"discretionary_relief" DOUBLE,
"mandatory_relief" DOUBLE,
"sbrr_y_n" VARCHAR,
"s44a_y_n" VARCHAR,
"hardship_y_n" VARCHAR,
"local_discount_y_n" VARCHAR,
"retail" VARCHAR
);
CREATE TABLE table_3 (
"property_ref" VARCHAR,
"account_holder_1" VARCHAR,
"account_holder_2" VARCHAR,
"property_name_1" VARCHAR,
"property_name_2" VARCHAR,
"property_address_1" VARCHAR,
"property_address_2" VARCHAR,
"property_address_3" VARCHAR,
"property_address_4" VARCHAR,
"property_post_code" VARCHAR,
"liable_from" VARCHAR,
"rv" BIGINT,
"description" VARCHAR,
"empty_y_n" VARCHAR,
"empty_from" VARCHAR,
"discretionary_relief" BIGINT,
"mandatory_relief" BIGINT,
"small_business_rate_relief_y_n" VARCHAR,
"supporting_small_business_relief_y_n" VARCHAR,
"retail_hospitality_and_leisure_relief_y_n" VARCHAR
);
CREATE TABLE table_4 (
"property_ref" VARCHAR,
"liable_name_1" VARCHAR,
"liable_name_2" VARCHAR,
"start_of_liability" VARCHAR,
"property_name_1" VARCHAR,
"property_name_2" VARCHAR,
"property_address_1" VARCHAR,
"property_address_2" VARCHAR,
"property_address_3" VARCHAR,
"property_address_4" VARCHAR,
"property_postcode" VARCHAR,
"rateable_value_2017" BIGINT,
"vo_code" VARCHAR,
"property_description" VARCHAR,
"empty" VARCHAR,
"empty_from" VARCHAR,
"charity" VARCHAR,
"disc" BIGINT,
"mand" BIGINT,
"sbrr" VARCHAR,
"s44a" VARCHAR,
"s49" VARCHAR,
"local_discount" VARCHAR,
"occupied" VARCHAR
);
CREATE TABLE table_5 (
"property_ref" VARCHAR,
"liable_name_1" VARCHAR,
"liable_name_2" VARCHAR,
"start_of_liability" VARCHAR,
"property_name_1" VARCHAR,
"property_name_2" VARCHAR,
"property_address_1" VARCHAR,
"property_address_2" VARCHAR,
"property_address_3" VARCHAR,
"property_address_4" VARCHAR,
"property_postcode" VARCHAR,
"rateable_value_2010" BIGINT,
"property_description" VARCHAR,
"empty" VARCHAR,
"empty_from" VARCHAR,
"charity" VARCHAR,
"disc" BIGINT,
"mand" BIGINT,
"occupied" VARCHAR
);
CREATE TABLE table_6 (
"property_ref" VARCHAR,
"liable_name_1" VARCHAR,
"liable_name_2" VARCHAR,
"start_of_liability" VARCHAR,
"property_name_1" VARCHAR,
"property_name_2" VARCHAR,
"property_address_1" VARCHAR,
"property_address_2" VARCHAR,
"property_address_3" VARCHAR,
"property_address_4" VARCHAR,
"property_postcode" VARCHAR,
"rateable_value_2010" BIGINT,
"property_description" VARCHAR,
"empty" VARCHAR,
"empty_from" VARCHAR,
"charity" VARCHAR,
"disc" BIGINT,
"mand" BIGINT,
"sbrr" VARCHAR,
"occupied" VARCHAR
);
CREATE TABLE table_7 (
"property_ref" VARCHAR,
"rate_payer" VARCHAR,
"start_of_liability" VARCHAR,
"property_name_1" VARCHAR,
"property_name_2" VARCHAR,
"property_address_1" VARCHAR,
"property_address_2" VARCHAR,
"property_address_3" VARCHAR,
"property_address_4" VARCHAR,
"property_postcode" VARCHAR,
"rateable_value_2010" BIGINT,
"property_description" VARCHAR,
"empty" VARCHAR,
"empty_from" VARCHAR,
"charity" VARCHAR,
"discretionary_relief" BIGINT,
"mandatory_relief" BIGINT,
"small_business_rate_relief" VARCHAR,
"retail_relief" VARCHAR,
"occupied" VARCHAR
);
CREATE TABLE table_8 (
"property_reference" VARCHAR,
"account_holder_1" VARCHAR,
"account_holder_2" VARCHAR,
"property_name_1" VARCHAR,
"property_name_2" VARCHAR,
"property_address_1" VARCHAR,
"property_address_2" VARCHAR,
"property_address_3" VARCHAR,
"property_address_4" VARCHAR,
"property_post_code" VARCHAR,
"liable_from" VARCHAR,
"rv" BIGINT,
"description" VARCHAR,
"empty_y_n" VARCHAR,
"empty_from" VARCHAR,
"discretionary_relief" BIGINT,
"mandatory_relief" BIGINT,
"small_business_rate_relief_y_n" VARCHAR,
"retail_hospitality_and_leisure_relief_y_n" VARCHAR
);
CREATE TABLE table_9 (
"rp_type" VARCHAR,
"property_reference" VARCHAR,
"account_holder_1" VARCHAR,
"account_holder_2" VARCHAR,
"property_name_1" VARCHAR,
"property_name_2" VARCHAR,
"property_address_1" VARCHAR,
"property_address_2" VARCHAR,
"property_address_3" VARCHAR,
"property_address_4" VARCHAR,
"property_post_code" VARCHAR,
"liable_from" VARCHAR,
"rv" BIGINT,
"empty_y_n" VARCHAR,
"empty_from" VARCHAR,
"discretionary_relief" BIGINT,
"mandatory_relief" BIGINT,
"small_business_rate_relief_y_n" VARCHAR,
"retail_hospitality_and_leisure_relief_y_n" VARCHAR
);
CREATE TABLE table_10 (
"property_reference" VARCHAR,
"account_holder_1" VARCHAR,
"account_holder_2" VARCHAR,
"property_name_1" VARCHAR,
"property_name_2" VARCHAR,
"property_address_1" VARCHAR,
"property_address_2" VARCHAR,
"property_address_3" VARCHAR,
"property_address_4" VARCHAR,
"property_post_code" VARCHAR,
"liable_from" VARCHAR,
"rv" BIGINT,
"description" VARCHAR,
"empty_y_n" VARCHAR,
"empty_from" VARCHAR,
"discretionary_relief" BIGINT,
"mandatory_relief" BIGINT,
"sbrr_y_n" VARCHAR,
"s44a_y_n" VARCHAR,
"hardship_y_n" VARCHAR,
"retail_discount_y_n" VARCHAR,
"expanded_retail_discount_y_n" VARCHAR
);
CREATE TABLE table_11 (
"property_reference" VARCHAR,
"account_holder_1" VARCHAR,
"account_holder_2" VARCHAR,
"property_name_1" VARCHAR,
"property_name_2" VARCHAR,
"property_address_1" VARCHAR,
"property_address_2" VARCHAR,
"property_address_3" VARCHAR,
"property_address_4" VARCHAR,
"property_post_code" VARCHAR,
"liable_from" VARCHAR,
"rv" BIGINT,
"description" VARCHAR,
"empty_y_n" VARCHAR,
"empty_from" VARCHAR,
"discretionary_relief" BIGINT,
"mandatory_relief" BIGINT,
"small_business_rate_relief_y_n" VARCHAR,
"retail_hospitality_and_leisure_relief_y_n" VARCHAR
);
CREATE TABLE table_12 (
"property_reference" VARCHAR,
"account_holder_1" VARCHAR,
"account_holder_2" VARCHAR,
"liability_start_date" VARCHAR,
"property_name_1" VARCHAR,
"property_name_2" VARCHAR,
"property_address_1" VARCHAR,
"property_address_2" VARCHAR,
"property_address_3" VARCHAR,
"property_address_4" VARCHAR,
"post_code" VARCHAR,
"n__charged_amount" VARCHAR,
"rateable_value" BIGINT,
"property_description" VARCHAR,
"charity_relief" VARCHAR,
"discretionary" BIGINT,
"mandatory" BIGINT,
"rural_relief" VARCHAR,
"discretionary_ca41a5" BIGINT,
"mandatory_1" BIGINT,
"small_business_rate_relief" VARCHAR,
"exemption" VARCHAR,
"empty_relief" VARCHAR,
"part_occupation_relief" VARCHAR,
"hardship_relief" VARCHAR,
"retail_relief" VARCHAR,
"occupied_relief" VARCHAR
);
CREATE TABLE table_13 (
"property_ref" VARCHAR,
"liable_name_1" VARCHAR,
"start_of_liability" VARCHAR,
"property_name_1" VARCHAR,
"property_name_2" VARCHAR,
"property_address_1" VARCHAR,
"property_address_2" VARCHAR,
"property_address_3" VARCHAR,
"property_address_4" VARCHAR,
"property_postcode" VARCHAR,
"rateable_value_2017" BIGINT,
"vo_code" VARCHAR,
"property_description" VARCHAR,
"empty" VARCHAR,
"empty_from" VARCHAR,
"charity" VARCHAR,
"disc" BIGINT,
"mand" BIGINT,
"sbrr" VARCHAR,
"s44a" VARCHAR,
"local_discount" VARCHAR,
"occupied" VARCHAR
);
CREATE TABLE table_14 (
"property_reference" VARCHAR,
"account_holder_1" VARCHAR,
"account_holder_2" VARCHAR,
"property_name_1" VARCHAR,
"property_name_2" VARCHAR,
"property_address_1" VARCHAR,
"property_address_2" VARCHAR,
"property_address_3" VARCHAR,
"property_address_4" VARCHAR,
"property_postcode" VARCHAR,
"liable_from" VARCHAR,
"rv" BIGINT,
"property_description" VARCHAR,
"charity_y_n" VARCHAR,
"disc" BIGINT,
"mand" BIGINT,
"sbrr_y_n" VARCHAR,
"s44a_y_n" VARCHAR,
"hardship_y_n" VARCHAR,
"local_discount" VARCHAR,
"retail_relief_y_n" VARCHAR
);
CREATE TABLE table_15 (
"property_ref" VARCHAR,
"account_holder_1" VARCHAR,
"account_holder_2" VARCHAR,
"property_name_1" VARCHAR,
"property_name_2" VARCHAR,
"property_address_1" VARCHAR,
"property_address_2" VARCHAR,
"property_address_3" VARCHAR,
"property_address_4" VARCHAR,
"property_post_code" VARCHAR,
"liable_from" VARCHAR,
"rv" BIGINT,
"description" VARCHAR,
"empty_y_n" VARCHAR,
"empty_from" VARCHAR,
"discretionary_relief" BIGINT,
"mandatory_relief" BIGINT,
"small_business_rate_relief_y_n" VARCHAR,
"supporting_small_business" VARCHAR,
"expanded_retail_discount" VARCHAR,
"non_la_nussery_discount" VARCHAR
);
CREATE TABLE table_16 (
"property_ref" VARCHAR,
"liable_name_1" VARCHAR,
"liable_name_2" VARCHAR,
"start_of_liability" VARCHAR,
"property_name_1" VARCHAR,
"property_name_2" VARCHAR,
"property_address_1" VARCHAR,
"property_address_2" VARCHAR,
"property_address_3" VARCHAR,
"property_address_4" VARCHAR,
"property_postcode" VARCHAR,
"rateable_value_2017" BIGINT,
"property_description" VARCHAR,
"empty" VARCHAR,
"empty_from" VARCHAR,
"charity" VARCHAR,
"disc" BIGINT,
"mand" BIGINT,
"sbrr" VARCHAR,
"s44a" VARCHAR
);
CREATE TABLE table_17 (
"property_reference" VARCHAR,
"account_holder_1" VARCHAR,
"account_holder_2" VARCHAR,
"property_name_1" VARCHAR,
"property_name_2" VARCHAR,
"property_address_1" VARCHAR,
"property_address_2" VARCHAR,
"property_address_3" VARCHAR,
"property_address_4" VARCHAR,
"property_post_code" VARCHAR,
"liable_from" VARCHAR,
"rv" BIGINT,
"description" VARCHAR,
"empty_y_n" VARCHAR,
"empty_from" VARCHAR,
"discretionary_relief" BIGINT,
"mandatory_relief" BIGINT,
"small_business_rate_relief_y_n" VARCHAR,
"supporting_small_business_relief_y_n" VARCHAR,
"expanded_retail_discount_relief_y_n" VARCHAR,
"non_la_nursery_discount_y_n" VARCHAR
);
CREATE TABLE table_18 (
"property_ref" VARCHAR,
"liable_name_1" VARCHAR,
"liable_name_2" VARCHAR,
"start_of_liability" VARCHAR,
"property_name_1" VARCHAR,
"property_name_2" VARCHAR,
"property_address_1" VARCHAR,
"property_address_2" VARCHAR,
"property_address_3" VARCHAR,
"property_address_4" VARCHAR,
"property_postcode" VARCHAR,
"rateable_value_2017" BIGINT,
"property_description" VARCHAR,
"charity" VARCHAR,
"disc" BIGINT,
"mand" BIGINT,
"sbrr" VARCHAR,
"s44a" VARCHAR,
"s49" VARCHAR,
"local_discount" VARCHAR
);
Anyone who has the link will be able to view this.