About this Dataset

Private Registered Provider Housing In Our Area

This data is based on the Homes and Communities Agency (HCA) Statistical Data Return (SDR).
It provides a list of Private Registered Providers (including registered social landlords, housing associations, almshouses etc) who own and manage homes in the Cambridge housing sub-region and Peterborough.

The 2013-14 data includes a simple yes/no as to whether providers own general needs, supported housing, housing for older people and low cost homes ownership housing.

The 2014-15 and 2015-16 data includes the number of homes owned and managed under the same four headings.

The 2016-17 data is provided in three sections: housing stock, rents, and affordable rents. These are the worksheets form the SDR which provide information by local authority area. The full SDR contains much more information, but not by local authority; just by housing provider. Each provider may own and manage homes in a number of local authorities.
Publisher name: Cambridgeshire Insight
Last updated: 2024-09-14T15:33:54Z

Tables

Local Registered Provider Housing 'affordable' Rent, 2016-17

@ukgov.private_registered_provider_housing_in_our_area1.local_registered_provider_housing_affordable_rent_2016_17

187.56 KB
83 rows
167 columns


CREATE TABLE local_registered_provider_housing_affordable_rent_2016_17 (
  "prp_name" VARCHAR,
  "prp_registration_number" VARCHAR,
  "size_of_organisation" VARCHAR,
  "local_authority_name" VARCHAR,
  "la_code" VARCHAR,
  "aff_rent_general_needs_owned_bedspace_non_self_contain_91a09f4c" DOUBLE,
  "aff_rent_general_needs_owned_bedspace_non_self_contain_b2900a8b" DOUBLE,
  "aff_rent_general_needs_owned_bedspace_non_self_contain_b68c2cb6" DOUBLE,
  "aff_rent_general_needs_owned_bedspace_non_self_contain_c94942b9" DOUBLE,
  "aff_rent_general_needs_owned_bedspace_non_self_contain_4d283410" VARCHAR,
  "aff_rent_general_needs_owned_bedspace_non_self_contain_f7019089" VARCHAR,
  "aff_rent_general_needs_owned_bedspace_non_self_contain_1848464d" VARCHAR,
  "aff_rent_general_needs_owned_bedspace_non_self_contain_c6774b1c" VARCHAR,
  "aff_rent_general_needs_owned_bedspace_non_self_contain_9b41b636" DOUBLE,
  "aff_rent_general_needs_owned_bedsit_total_units_bedspa_0516aa07" DOUBLE,
  "aff_rent_general_needs_owned_bedsit_average_weekly_ren_cca42a93" DOUBLE,
  "aff_rent_general_needs_owned_bedsit_accommodation_with_36c52601" DOUBLE,
  "aff_rent_general_needs_owned_bedsit_average_service_ch_22b64ca2" DOUBLE,
  "aff_rent_general_needs_owned_bedsit_accommodation_with_a71937ff" DOUBLE,
  "aff_rent_general_needs_owned_bedsit_average_service_ch_124d42a6" DOUBLE,
  "aff_rent_general_needs_owned_bedsit_total_units_bedspa_ea5f104b" VARCHAR,
  "aff_rent_general_needs_owned_bedsit_average_weekly_ren_aa6dac3a" VARCHAR,
  "aff_rent_general_needs_owned_bedsit_total_units_bedspaces" DOUBLE,
  "aff_rent_general_needs_owned_one_bedroom_total_units_b_d84ecd51" DOUBLE,
  "aff_rent_general_needs_owned_one_bedroom_average_weekl_5118ec90" DOUBLE,
  "aff_rent_general_needs_owned_one_bedroom_accommodation_92821cd7" DOUBLE,
  "aff_rent_general_needs_owned_one_bedroom_average_servi_8991ebfb" DOUBLE,
  "aff_rent_general_needs_owned_one_bedroom_accommodation_ac514580" DOUBLE,
  "aff_rent_general_needs_owned_one_bedroom_average_servi_f8cf87ec" DOUBLE,
  "aff_rent_general_needs_owned_one_bedroom_total_units_b_71584af5" VARCHAR,
  "aff_rent_general_needs_owned_one_bedroom_average_weekl_f442f1be" VARCHAR,
  "aff_rent_general_needs_owned_one_bedroom_total_units_bedspaces" DOUBLE,
  "aff_rent_general_needs_owned_two_bedrooms_total_units__905cfe29" DOUBLE,
  "aff_rent_general_needs_owned_two_bedrooms_average_week_c6de2700" DOUBLE,
  "aff_rent_general_needs_owned_two_bedrooms_accommodatio_ed6d130b" DOUBLE,
  "aff_rent_general_needs_owned_two_bedrooms_average_serv_26130e57" DOUBLE,
  "aff_rent_general_needs_owned_two_bedrooms_accommodatio_4ede126d" DOUBLE,
  "aff_rent_general_needs_owned_two_bedrooms_average_serv_29cd6dd6" DOUBLE,
  "aff_rent_general_needs_owned_two_bedrooms_total_units__5e87c433" VARCHAR,
  "aff_rent_general_needs_owned_two_bedrooms_average_week_53244cee" VARCHAR,
  "aff_rent_general_needs_owned_two_bedrooms_total_units_bedspaces" DOUBLE,
  "aff_rent_general_needs_owned_three_bedrooms_total_unit_2d7acc7e" DOUBLE,
  "aff_rent_general_needs_owned_three_bedrooms_average_we_24f78a97" DOUBLE,
  "aff_rent_general_needs_owned_three_bedrooms_accommodat_fdb86b05" DOUBLE,
  "aff_rent_general_needs_owned_three_bedrooms_average_se_097f0b31" DOUBLE,
  "aff_rent_general_needs_owned_three_bedrooms_accommodat_d3438ba7" DOUBLE,
  "aff_rent_general_needs_owned_three_bedrooms_average_se_2b234f58" DOUBLE,
  "aff_rent_general_needs_owned_three_bedrooms_total_unit_74cdd866" VARCHAR,
  "aff_rent_general_needs_owned_three_bedrooms_average_we_3e60c34d" VARCHAR,
  "aff_rent_general_needs_owned_three_bedrooms_total_unit_e876c403" DOUBLE,
  "aff_rent_general_needs_owned_four_bedrooms_total_units_f512bf9b" DOUBLE,
  "aff_rent_general_needs_owned_four_bedrooms_average_wee_2a4d30b1" DOUBLE,
  "aff_rent_general_needs_owned_four_bedrooms_accommodati_16a6e97f" DOUBLE,
  "aff_rent_general_needs_owned_four_bedrooms_average_ser_548b0aaf" DOUBLE,
  "aff_rent_general_needs_owned_four_bedrooms_accommodati_b2081ab8" VARCHAR,
  "aff_rent_general_needs_owned_four_bedrooms_average_ser_8830b41f" VARCHAR,
  "aff_rent_general_needs_owned_four_bedrooms_total_units_664ecbd5" VARCHAR,
  "aff_rent_general_needs_owned_four_bedrooms_average_wee_c669317f" VARCHAR,
  "aff_rent_general_needs_owned_four_bedrooms_total_units_1197418b" DOUBLE,
  "aff_rent_general_needs_owned_five_bedrooms_total_units_c374adff" DOUBLE,
  "aff_rent_general_needs_owned_five_bedrooms_average_wee_344551d7" DOUBLE,
  "aff_rent_general_needs_owned_five_bedrooms_accommodati_510f6703" DOUBLE,
  "aff_rent_general_needs_owned_five_bedrooms_average_ser_c1c85369" DOUBLE,
  "aff_rent_general_needs_owned_five_bedrooms_accommodati_81c276cc" VARCHAR,
  "aff_rent_general_needs_owned_five_bedrooms_average_ser_438f3b1e" VARCHAR,
  "aff_rent_general_needs_owned_five_bedrooms_total_units_f017abc3" VARCHAR,
  "aff_rent_general_needs_owned_five_bedrooms_average_wee_57ef6108" VARCHAR,
  "aff_rent_general_needs_owned_five_bedrooms_total_units_c5985086" DOUBLE,
  "aff_rent_general_needs_owned_six_or_more_bedrooms_tota_cea8559b" VARCHAR,
  "aff_rent_general_needs_owned_six_or_more_bedrooms_aver_ec864226" VARCHAR,
  "aff_rent_general_needs_owned_six_or_more_bedrooms_acco_c9d5672e" VARCHAR,
  "aff_rent_general_needs_owned_six_or_more_bedrooms_aver_38aca55e" VARCHAR,
  "aff_rent_general_needs_owned_six_or_more_bedrooms_acco_f23823a6" VARCHAR,
  "aff_rent_general_needs_owned_six_or_more_bedrooms_aver_8883690f" VARCHAR,
  "aff_rent_general_needs_owned_six_or_more_bedrooms_tota_05d0aa7e" VARCHAR,
  "aff_rent_general_needs_owned_six_or_more_bedrooms_aver_976c0571" VARCHAR,
  "aff_rent_general_needs_owned_six_or_more_bedrooms_tota_d5f6688a" VARCHAR,
  "aff_rent_general_needs_owned_total_self_contained_weig_25122512" DOUBLE,
  "aff_rent_general_needs_owned_total_self_contained_weig_6ae3f4c6" DOUBLE,
  "aff_rent_general_needs_owned_total_self_contained_weig_18b2ae9b" DOUBLE,
  "aff_rent_general_needs_owned_total_self_contained_weig_558a7a93" DOUBLE,
  "aff_rent_general_needs_owned_total_self_contained_weig_03b32278" DOUBLE,
  "aff_rent_general_needs_owned_total_self_contained_weig_eafb58e6" DOUBLE,
  "aff_rent_general_needs_owned_total_self_contained_weig_a200b648" VARCHAR,
  "aff_rent_general_needs_owned_total_self_contained_weig_0cbb1fce" VARCHAR,
  "aff_rent_general_needs_owned_total_self_contained_weig_48819d90" DOUBLE,
  "aff_rent_general_needs_owned_total_units_bedspaces_exc_f999171a" DOUBLE,
  "aff_rent_general_needs_owned_weighted_average_weekly_r_245dcc7e" DOUBLE,
  "aff_rent_general_needs_owned_total_accommodation_with__29aab8fb" DOUBLE,
  "aff_rent_general_needs_owned_weighted_average_service__ec8effe5" DOUBLE,
  "aff_rent_general_needs_owned_total_accommodation_with__f218ed27" DOUBLE,
  "aff_rent_general_needs_owned_weighted_average_service__ab8523f6" DOUBLE,
  "aff_rent_general_needs_total_units_bedspaces_subject_t_fcfe38f0" VARCHAR,
  "aff_rent_general_needs_weighted_average_weekly_rent_of_fa0838c5" VARCHAR,
  "aff_rent_general_needs_total_units_bedspaces" DOUBLE,
  "aff_rent_supported_housing_and_housing_for_older_peopl_cd8f8c60" VARCHAR,
  "aff_rent_supported_housing_and_housing_for_older_peopl_4e0e1070" VARCHAR,
  "aff_rent_supported_housing_and_housing_for_older_peopl_ef6a6a7e" VARCHAR,
  "aff_rent_supported_housing_and_housing_for_older_peopl_69df776b" VARCHAR,
  "aff_rent_supported_housing_and_housing_for_older_peopl_635504f6" VARCHAR
);

Local Registered Provider Housing Rents, 2016-17

@ukgov.private_registered_provider_housing_in_our_area1.local_registered_provider_housing_rents_2016_17

257.72 KB
161 rows
203 columns


CREATE TABLE local_registered_provider_housing_rents_2016_17 (
  "prp_name" VARCHAR,
  "prp_registration_number" VARCHAR,
  "size_of_organisation" VARCHAR,
  "local_authority_name" VARCHAR,
  "la_code" VARCHAR,
  "general_needs_owned_bedspace_non_self_contained_total__5e5f1bdb" DOUBLE,
  "general_needs_owned_bedspace_non_self_contained_averag_834b7464" DOUBLE,
  "general_needs_owned_bedspace_non_self_contained_number_dcaa321f" DOUBLE,
  "general_needs_owned_bedspace_non_self_contained_averag_dc1c189c" DOUBLE,
  "general_needs_owned_bedspace_non_self_contained_number_373f8b30" VARCHAR,
  "general_needs_owned_bedspace_non_self_contained_averag_0a58e5b8" VARCHAR,
  "general_needs_owned_bedspace_non_self_contained_total__a6627098" DOUBLE,
  "general_needs_owned_bedspace_non_self_contained_averag_e9e19eb6" DOUBLE,
  "general_needs_owned_bedspace_non_self_contained_total__5f9ab7e1" VARCHAR,
  "general_needs_owned_bedspace_non_self_contained_averag_a7260c66" VARCHAR,
  "general_needs_owned_bedspace_non_self_contained_total__94482323" DOUBLE,
  "general_needs_owned_bedsit_total_units_bedspaces_exclu_8fdf6033" DOUBLE,
  "general_needs_owned_bedsit_average_weekly_rent_excludi_1a014e6f" DOUBLE,
  "general_needs_owned_bedsit_number_of_units_bedspaces_w_411fc7ba" DOUBLE,
  "general_needs_owned_bedsit_average_service_charge_elig_5415be59" DOUBLE,
  "general_needs_owned_bedsit_number_of_units_bedspaces_w_07f19eb7" DOUBLE,
  "general_needs_owned_bedsit_average_service_charge_not__32773705" DOUBLE,
  "general_needs_owned_bedsit_total_number_of_units_bedsp_678e32c6" DOUBLE,
  "general_needs_owned_bedsit_average_social_rent_rate_ca_e9a8ad0d" DOUBLE,
  "general_needs_owned_bedsit_total_number_of_units_bedsp_cc86d2a5" VARCHAR,
  "general_needs_owned_bedsit_average_weekly_rent_of_prop_5217b907" VARCHAR,
  "general_needs_owned_bedsit_total_units_bedspaces" DOUBLE,
  "general_needs_owned_one_bedroom_total_units_bedspaces__18983523" DOUBLE,
  "general_needs_owned_one_bedroom_average_weekly_rent_ex_7092916e" DOUBLE,
  "general_needs_owned_one_bedroom_number_of_units_bedspa_a370bda9" DOUBLE,
  "general_needs_owned_one_bedroom_average_service_charge_46340f40" DOUBLE,
  "general_needs_owned_one_bedroom_number_of_units_bedspa_9ef73c67" DOUBLE,
  "general_needs_owned_one_bedroom_average_service_charge_2d6119b3" DOUBLE,
  "general_needs_owned_one_bedroom_total_number_of_units__b7389740" DOUBLE,
  "general_needs_owned_one_bedroom_average_social_rent_ra_b8e9ea06" DOUBLE,
  "general_needs_owned_one_bedroom_total_number_of_units__ff7900cf" VARCHAR,
  "general_needs_owned_one_bedroom_average_weekly_rent_of_c304c04b" VARCHAR,
  "general_needs_owned_one_bedroom_total_units_bedspaces" DOUBLE,
  "general_needs_owned_two_bedrooms_total_units_bedspaces_116f805b" DOUBLE,
  "general_needs_owned_two_bedrooms_average_weekly_rent_e_c5d0b90b" DOUBLE,
  "general_needs_owned_two_bedrooms_number_of_units_bedsp_8f799f43" DOUBLE,
  "general_needs_owned_two_bedrooms_average_service_charg_d16c3f68" DOUBLE,
  "general_needs_owned_two_bedrooms_number_of_units_bedsp_d2a07068" DOUBLE,
  "general_needs_owned_two_bedrooms_average_service_charg_f415048c" DOUBLE,
  "general_needs_owned_two_bedrooms_total_number_of_units_1a8fc798" DOUBLE,
  "general_needs_owned_two_bedrooms_average_social_rent_r_1e1a16bf" DOUBLE,
  "general_needs_owned_two_bedrooms_total_number_of_units_409caa86" VARCHAR,
  "general_needs_owned_two_bedrooms_average_weekly_rent_o_c191612a" VARCHAR,
  "general_needs_owned_two_bedrooms_total_units_bedspaces" DOUBLE,
  "general_needs_owned_three_bedrooms_total_units_bedspac_7976140d" DOUBLE,
  "general_needs_owned_three_bedrooms_average_weekly_rent_b2a4a8a0" DOUBLE,
  "general_needs_owned_three_bedrooms_number_of_units_bed_d66c0fd8" DOUBLE,
  "general_needs_owned_three_bedrooms_average_service_cha_6604591f" DOUBLE,
  "general_needs_owned_three_bedrooms_number_of_units_bed_06248f08" DOUBLE,
  "general_needs_owned_three_bedrooms_average_service_cha_0b2a1393" DOUBLE,
  "general_needs_owned_three_bedrooms_total_number_of_uni_217c6d53" DOUBLE,
  "general_needs_owned_three_bedrooms_average_social_rent_55fce3bc" DOUBLE,
  "general_needs_owned_three_bedrooms_total_number_of_uni_2bd6bc47" VARCHAR,
  "general_needs_owned_three_bedrooms_average_weekly_rent_28af9e14" VARCHAR,
  "general_needs_owned_three_bedrooms_total_units_bedspaces" DOUBLE,
  "general_needs_owned_four_bedrooms_total_units_bedspace_a976c5e2" DOUBLE,
  "general_needs_owned_four_bedrooms_average_weekly_rent__13d734dc" DOUBLE,
  "general_needs_owned_four_bedrooms_number_of_units_beds_2ac051e8" DOUBLE,
  "general_needs_owned_four_bedrooms_average_service_char_a197c4df" DOUBLE,
  "general_needs_owned_four_bedrooms_number_of_units_beds_f1ab5210" DOUBLE,
  "general_needs_owned_four_bedrooms_average_service_char_18c008dc" DOUBLE,
  "general_needs_owned_four_bedrooms_total_number_of_unit_0528eff0" DOUBLE,
  "general_needs_owned_four_bedrooms_average_social_rent__5e4586e1" DOUBLE,
  "general_needs_owned_four_bedrooms_total_number_of_unit_68bd7dc7" VARCHAR,
  "general_needs_owned_four_bedrooms_average_weekly_rent__80a5734c" VARCHAR,
  "general_needs_owned_four_bedrooms_total_units_bedspaces" DOUBLE,
  "general_needs_owned_five_bedrooms_total_units_bedspace_be23b5a4" DOUBLE,
  "general_needs_owned_five_bedrooms_average_weekly_rent__96848f5f" DOUBLE,
  "general_needs_owned_five_bedrooms_number_of_units_beds_53fa2d05" DOUBLE,
  "general_needs_owned_five_bedrooms_average_service_char_8e1cbdda" DOUBLE,
  "general_needs_owned_five_bedrooms_number_of_units_beds_9a4ba254" VARCHAR,
  "general_needs_owned_five_bedrooms_average_service_char_1a78f7bf" VARCHAR,
  "general_needs_owned_five_bedrooms_total_number_of_unit_83dc5d4f" VARCHAR,
  "general_needs_owned_five_bedrooms_average_social_rent__2532ede3" DOUBLE,
  "general_needs_owned_five_bedrooms_total_number_of_unit_94f135ab" VARCHAR,
  "general_needs_owned_five_bedrooms_average_weekly_rent__9bef5aa4" VARCHAR,
  "general_needs_owned_five_bedrooms_total_units_bedspaces" DOUBLE,
  "general_needs_owned_six_or_more_bedrooms_total_units_b_2f48c597" DOUBLE,
  "general_needs_owned_six_or_more_bedrooms_average_weekl_e95445c7" DOUBLE,
  "general_needs_owned_six_or_more_bedrooms_number_of_uni_ebea82cb" DOUBLE,
  "general_needs_owned_six_or_more_bedrooms_average_servi_1fb0dc08" DOUBLE,
  "general_needs_owned_six_or_more_bedrooms_number_of_uni_e6191923" VARCHAR,
  "general_needs_owned_six_or_more_bedrooms_average_servi_dc2c4729" VARCHAR,
  "general_needs_owned_six_or_more_bedrooms_total_number__4286e21c" VARCHAR,
  "general_needs_owned_six_or_more_bedrooms_average_socia_2f903c33" DOUBLE,
  "general_needs_owned_six_or_more_bedrooms_total_number__ee091611" VARCHAR,
  "general_needs_owned_six_or_more_bedrooms_average_weekl_18c63a04" VARCHAR,
  "general_needs_owned_six_or_more_bedrooms_total_units_bedspaces" DOUBLE,
  "general_needs_owned_self_contained_total_units_bedspac_89cfbd61" DOUBLE,
  "general_needs_owned_self_contained_average_weekly_rent_02ec08c8" DOUBLE,
  "general_needs_owned_self_contained_number_of_units_bed_3aeb5c67" DOUBLE,
  "general_needs_owned_self_contained_average_service_cha_1a361112" DOUBLE,
  "general_needs_owned_self_contained_number_of_units_bed_f453f74d" DOUBLE,
  "general_needs_owned_self_contained_average_service_cha_0975b067" DOUBLE,
  "general_needs_owned_self_contained_total_number_of_uni_03a18269" DOUBLE
);

Local Registered Provider Housing Stock, 2016-17

@ukgov.private_registered_provider_housing_in_our_area1.local_registered_provider_housing_stock_2016_17

31.56 KB
221 rows
26 columns


CREATE TABLE local_registered_provider_housing_stock_2016_17 (
  "prp_name" VARCHAR,
  "prp_registration_number" VARCHAR,
  "size_of_organisation" VARCHAR,
  "local_authority_name" VARCHAR,
  "la_code" VARCHAR,
  "general_needs_self_contained_owned_low_cost_rental_acc_c2d12657" DOUBLE,
  "general_needs_bedspace_non_self_contained_owned_low_co_7e17879e" DOUBLE,
  "supported_housing_owned_low_cost_rental_accommodation__4731bd43" DOUBLE,
  "housing_for_older_people_owned_low_cost_rental_accommo_57183488" DOUBLE,
  "total_number_of_owned_units_which_fail_the_dhs_by_loca_aca88bde" DOUBLE,
  "general_needs_self_contained_managed_low_cost_rental_a_1886c17e" DOUBLE,
  "general_needs_bedspace_non_self_contained_managed_low__9c16970d" DOUBLE,
  "supported_housing_managed_low_cost_rental_accommodatio_39062d8b" DOUBLE,
  "housing_for_older_people_managed_low_cost_rental_accom_8318be5f" DOUBLE,
  "low_cost_home_ownership_units_owned_where_purchaser_ha_508e7878" DOUBLE,
  "low_cost_home_ownership_units_managed_only_where_purch_6b2d2321" DOUBLE,
  "first_tranche_low_cost_home_ownership_sales" DOUBLE,
  "n_100_staircased_low_cost_home_ownership_sales" DOUBLE,
  "total_sales_to_registered_providers" DOUBLE,
  "total_sales_to_tenants" DOUBLE,
  "total_sales_to_other" DOUBLE,
  "total_demolitions" DOUBLE,
  "other_losses" DOUBLE,
  "general_needs_self_contained_units_vacant_and_availabl_549bddea" DOUBLE,
  "general_needs_self_contained_units_vacant_and_not_avai_c17a64b2" DOUBLE,
  "total_general_needs_self_contained_units_vacant" DOUBLE
);

Private Registered Provider Housing 2014-15

@ukgov.private_registered_provider_housing_in_our_area1.private_registered_provider_housing_2014_15

16.11 KB
238 rows
12 columns


CREATE TABLE private_registered_provider_housing_2014_15 (
  "la_code" VARCHAR,
  "local_authority_name" VARCHAR,
  "prp_name" VARCHAR,
  "prp_registration_number" VARCHAR,
  "total_general_needs_stock_owned" DOUBLE,
  "total_general_needs_stock_managed" DOUBLE,
  "total_supported_housing_owned" DOUBLE,
  "total_supported_housing_managed" DOUBLE,
  "total_housing_for_older_people_owned" DOUBLE,
  "total_housing_for_older_people_managed" DOUBLE,
  "total_low_cost_home_ownership_where_purchaser_has_100__6fa7c935" DOUBLE,
  "total_low_cost_home_ownership_where_purchaser_has_100__77836771" DOUBLE
);

Private Registered Provider Housing 2015-16

@ukgov.private_registered_provider_housing_in_our_area1.private_registered_provider_housing_2015_16

16.47 KB
227 rows
12 columns


CREATE TABLE private_registered_provider_housing_2015_16 (
  "la_code" VARCHAR,
  "local_authority_name" VARCHAR,
  "prp_name" VARCHAR,
  "prp_registration_number" VARCHAR,
  "total_general_needs_stock_owned" BIGINT,
  "total_general_needs_stock_managed" DOUBLE,
  "total_supported_housing_owned" DOUBLE,
  "total_supported_housing_managed" DOUBLE,
  "total_housing_for_older_people_owned" DOUBLE,
  "total_housing_for_older_people_managed" DOUBLE,
  "total_low_cost_home_ownership_where_purchaser_has_100__6fa7c935" DOUBLE,
  "total_low_cost_home_ownership_where_purchaser_has_100__77836771" DOUBLE
);