Cambridgeshire County Council Expenditure Over £500

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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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
);