Cambridgeshire County Council Expenditure Over £500
Cambridgeshire Insight
@ukgov.cambridgeshire_county_council_expenditure_over_5001
Cambridgeshire Insight
@ukgov.cambridgeshire_county_council_expenditure_over_5001
CREATE TABLE cambridgeshire_county_council_expenditure_june_2024 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_april_2022 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_december_2021 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_february_2019 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_march_2017 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_september_2015 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_april_2018 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_october_2019 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_april_2019 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_november_2022 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_july_2023 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_june_2016 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_january_2019 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_may_2024 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_february_2023 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_november_2019 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_april_2016 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_june_2021 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_august_2015 (
"body" VARCHAR,
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_november_2024 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_january_2020 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_july_2016 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_april_2020 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_march_2018 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_november_2016 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_may_2018 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_january_2021 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_october_2015 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_august_2017 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_august_2021 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_july_2021 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_december_2024 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_december_2018 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_september_2024 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_may_2015 (
"body" VARCHAR,
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_february_2021 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_june_2017 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_june_2023 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_november_2021 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_march_2021 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_july_2020 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_april_2023 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_october_2016 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_october_2024 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_march_2023 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_october_2018 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_march_2024 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_june_2019 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"invoice_number" VARCHAR,
"account" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_september_2018 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_january_2024 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_august_2023 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_june_2015 (
"body" VARCHAR,
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_april_2021 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_march_2020 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_december_2020 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_january_2016 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_february_2020 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_december_2023 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_october_2020 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_february_2018 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_january_2025 (
"jquery_extend_drupal_settings" VARCHAR,
"n__basepath" VARCHAR,
"pathprefix" VARCHAR,
"ajaxpagestate_theme_opendata" VARCHAR,
"theme_token_7kzi46xpux6wk99hwavpaldr706izkphbmwwcii3ssc" VARCHAR,
"js_profiles_dkan_modules_contrib_panopoly_widgets_pano_213f723f" VARCHAR,
"profiles_dkan_modules_contrib_panopoly_widgets_panopol_baf8c9d5" VARCHAR,
"profiles_dkan_modules_contrib_jquery_update_replace_jq_944e6870" VARCHAR,
"misc_jquery_once_js_1" VARCHAR,
"misc_drupal_js_1" VARCHAR,
"https_maxcdn_bootstrapcdn_com_bootstrap_3_1_1_js_boots_fea3cc8f" VARCHAR,
"profiles_dkan_modules_contrib_jquery_update_replace_ui_ebc9fe1d" VARCHAR,
"profiles_dkan_modules_contrib_jquery_update_replace_ui_a247ee0b" VARCHAR,
"profiles_dkan_libraries_chosen_chosen_jquery_min_js_1" VARCHAR,
"profiles_dkan_modules_contrib_jquery_update_replace_ui_2b7d1307" VARCHAR,
"profiles_dkan_modules_contrib_panopoly_images_panopoly_2333de31" VARCHAR,
"profiles_dkan_modules_dkan_dkan_plugins_js_colorpicker_1b6add7e" VARCHAR,
"profiles_dkan_modules_contrib_recline_js_jsondataview_js_1" VARCHAR,
"profiles_dkan_modules_contrib_recline_js_restdataview_js_1" VARCHAR,
"sites_all_libraries_jquery_imagesloaded_jquery_imagesl_79c3198d" VARCHAR,
"profiles_dkan_modules_contrib_ctools_js_collapsible_div_js_1" VARCHAR,
"profiles_dkan_modules_contrib_facetapi_facetapi_js_1" VARCHAR,
"sites_all_modules_google_analytics_googleanalytics_js_1" VARCHAR,
"n_0_1" VARCHAR,
"profiles_dkan_modules_contrib_chosen_chosen_js_1" VARCHAR,
"profiles_dkan_themes_contrib_radix_assets_js_radix_script_js_1" VARCHAR,
"profiles_dkan_themes_nuboot_radix_assets_js_nuboot_rad_441344e1" VARCHAR,
"sites_all_themes_opendata_assets_js_opendata_script_js_1" VARCHAR,
"css_modules_system_system_base_css_1" VARCHAR,
"modules_system_system_messages_css_1" VARCHAR,
"modules_system_system_theme_css_1" VARCHAR,
"profiles_dkan_libraries_chosen_chosen_css_1" VARCHAR,
"profiles_dkan_modules_contrib_chosen_css_chosen_drupal_css_1" VARCHAR,
"misc_ui_jquery_ui_core_css_1" VARCHAR,
"misc_ui_jquery_ui_theme_css_1" VARCHAR,
"misc_ui_jquery_ui_tabs_css_1" VARCHAR,
"profiles_dkan_modules_contrib_date_date_api_date_css_1" VARCHAR,
"profiles_dkan_modules_contrib_date_date_popup_themes_d_b501c28a" VARCHAR,
"profiles_dkan_modules_dkan_dkan_data_story_css_dkan_da_7d44f1dc" VARCHAR,
"profiles_dkan_modules_dkan_dkan_harvest_modules_dkan_h_4e088fc5" VARCHAR,
"modules_field_theme_field_css_1" VARCHAR,
"profiles_dkan_modules_contrib_field_hidden_field_hidden_css_1" VARCHAR,
"modules_node_node_css_1" VARCHAR,
"profiles_dkan_modules_contrib_panopoly_widgets_panopol_0834f886" VARCHAR,
"profiles_dkan_modules_contrib_panopoly_widgets_panopol_b3eb4e8d" VARCHAR,
"profiles_dkan_modules_contrib_radix_layouts_radix_layouts_css_1" VARCHAR,
"modules_user_user_css_1" VARCHAR,
"profiles_dkan_modules_contrib_views_css_views_css_1" VARCHAR,
"profiles_dkan_modules_contrib_media_modules_media_wysi_05a8086e" VARCHAR,
"profiles_dkan_modules_contrib_ctools_css_ctools_css_1" VARCHAR,
"profiles_dkan_modules_contrib_panels_css_panels_css_1" VARCHAR,
"profiles_dkan_modules_contrib_ctools_css_collapsible_div_css_1" VARCHAR,
"profiles_dkan_modules_dkan_dkan_topics_theme_dkan_topics_css_1" VARCHAR,
"n__fonts_googleapis_com_css_family_open_sans_400_300_700_1" VARCHAR,
"public_font_icon_select_general_generated_1_css_1" VARCHAR,
"profiles_dkan_modules_dkan_dkan_dataset_css_dkan_dataset_css_1" VARCHAR,
"profiles_dkan_themes_nuboot_radix_assets_css_nuboot_ra_097b19a0" VARCHAR,
"profiles_dkan_themes_nuboot_radix_assets_css_dkan_flat_3cf2770f" VARCHAR,
"profiles_dkan_themes_nuboot_radix_assets_css_dkan_topics_css_1" VARCHAR,
"sites_all_themes_opendata_assets_css_opendata_style_css_1" VARCHAR,
"profiles_dkan_themes_nuboot_radix_assets_css_print_css_1" VARCHAR,
"https_cambridgeshireinsight_org_uk_sites_default_files_7a79ba4d" VARCHAR,
"profiles_dkan_themes_nuboot_radix_assets_css_ie_css_1" VARCHAR,
"profiles_dkan_themes_nuboot_radix_assets_css_ie9_css_1" VARCHAR,
"profiles_dkan_themes_nuboot_radix_assets_css_ie8_css_1" VARCHAR,
"profiles_dkan_modules_contrib_panopoly_images_panopoly_5e7e96fc" VARCHAR,
"sites_default_files_fontyourface_font_css_1" VARCHAR,
"http_fonts_googleapis_com_css_family_montserrat_300_re_d5aede73" VARCHAR,
"chosen_selector_page_node_select_not_class_u0022delta__91f28e15" VARCHAR,
"n__name_u0022workbench_moderation_u0022" VARCHAR,
"n__class_u0022filter_list_u0022" VARCHAR,
"n__id_u0022delimiter_u0022" VARCHAR,
"n__name_u0022sort_by_u0022" VARCHAR,
"n__name_u0022sort_order_u0022" VARCHAR,
"n__id_u0022lines_terminated_by_u0022" VARCHAR,
"n__id_u0022lang_dropdown_select_language_u0022" VARCHAR,
"minimum_single_0" VARCHAR,
"minimum_multiple_0" VARCHAR,
"minimum_width_0" VARCHAR,
"options_allow_single_deselect_false" VARCHAR,
"disable_search_false" VARCHAR,
"disable_search_threshold_0" VARCHAR,
"search_contains_false" VARCHAR,
"placeholder_text_multiple_choose_some_options" VARCHAR,
"placeholder_text_single_choose_an_option" VARCHAR,
"no_results_text_no_results_match" VARCHAR,
"inherit_select_classes_true" VARCHAR,
"urlisajaxtrusted_search_field_tags_expenditure_274_true" VARCHAR,
"n__search_field_tags_expenditure_274_query_20sites_20d_2cefd841" VARCHAR,
"better_exposed_filters_views_dkan_datasets_displays_pa_c0ce787a" VARCHAR,
"facetapi_facets_limit_20" VARCHAR,
"id_facetapi_facet_search_apidatasets_block_field_topic" VARCHAR,
"searcher_search_api_datasets" VARCHAR,
"realmname_block" VARCHAR,
"facetname_field_topic" VARCHAR,
"querytype_null" VARCHAR,
"widget_terms" VARCHAR,
"showmoretext_show_more" VARCHAR,
"showfewertext_show_fewer" VARCHAR,
"n__limit_20" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_december_2017 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_january_2022 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_november_2023 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_october_2022 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_april_2015 (
"body" VARCHAR,
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_february_2022 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_may_2022 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_june_2018 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_september_2020 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_october_2017 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_july_2024 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_june_2020 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_march_2019 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_april_2024 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_february_2016 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_july_2017 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_may_2020 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_august_2019 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_august_2020 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_april_2017 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_february_2017 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_august_2016 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_september_2017 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_may_2017 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_november_2020 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_may_2016 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_august_2018 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_may_2023 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_august_2022 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_august_2024 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_october_2023 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_september_2016 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_july_2019 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_february_2024 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_december_2015 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_november_2017 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_september_2023 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_december_2019 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_january_2018 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_march_2022 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_may_2021 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_september_2019 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_july_2022 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_march_2016 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_october_2021 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_july_2015 (
"body" VARCHAR,
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_november_2015 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_july_2018 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_september_2021 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_september_2022 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_january_2017 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_june_2022 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_december_2022 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_january_2023 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_may_2019 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" VARCHAR,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_november_2018 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
CREATE TABLE cambridgeshire_county_council_expenditure_december_2016 (
"body_name" VARCHAR,
"date_paid" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"supplier_name" VARCHAR,
"supplier_type" VARCHAR,
"expense_area" VARCHAR,
"cost_centre_description" VARCHAR,
"expense_type" VARCHAR
);
Anyone who has the link will be able to view this.