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  -- {"basePath":"\/",
  "pathprefix" VARCHAR  -- PathPrefix:"",
  "ajaxpagestate_theme_opendata" VARCHAR  -- AjaxPageState:{"theme":"opendata",
  "theme_token_7kzi46xpux6wk99hwavpaldr706izkphbmwwcii3ssc" VARCHAR  -- Theme Token:"7kzI46xpuX6wk99hwAvpAlDR706IzkPHBMwwCii3Ssc",
  "js_profiles_dkan_modules_contrib_panopoly_widgets_pano_213f723f" VARCHAR  -- Js:{"profiles\/dkan\/modules\/contrib\/panopoly Widgets\/panopoly-widgets.js":1,
  "profiles_dkan_modules_contrib_panopoly_widgets_panopol_baf8c9d5" VARCHAR  -- Profiles\/dkan\/modules\/contrib\/panopoly Widgets\/panopoly-widgets-spotlight.js:1,
  "profiles_dkan_modules_contrib_jquery_update_replace_jq_944e6870" VARCHAR  -- Profiles\/dkan\/modules\/contrib\/jquery Update\/replace\/jquery\/1.10\/jquery.min.js:1,
  "misc_jquery_once_js_1" VARCHAR  -- Misc\/jquery.once.js:1,
  "misc_drupal_js_1" VARCHAR  -- Misc\/drupal.js:1,
  "https_maxcdn_bootstrapcdn_com_bootstrap_3_1_1_js_boots_fea3cc8f" VARCHAR  -- Https:\/\/maxcdn.bootstrapcdn.com\/bootstrap\/3.1.1\/js\/bootstrap.min.js:1,
  "profiles_dkan_modules_contrib_jquery_update_replace_ui_ebc9fe1d" VARCHAR  -- Profiles\/dkan\/modules\/contrib\/jquery Update\/replace\/ui\/ui\/minified\/jquery.ui.core.min.js:1,
  "profiles_dkan_modules_contrib_jquery_update_replace_ui_a247ee0b" VARCHAR  -- Profiles\/dkan\/modules\/contrib\/jquery Update\/replace\/ui\/ui\/minified\/jquery.ui.widget.min.js:1,
  "profiles_dkan_libraries_chosen_chosen_jquery_min_js_1" VARCHAR  -- Profiles\/dkan\/libraries\/chosen\/chosen.jquery.min.js:1,
  "profiles_dkan_modules_contrib_jquery_update_replace_ui_2b7d1307" VARCHAR  -- Profiles\/dkan\/modules\/contrib\/jquery Update\/replace\/ui\/ui\/minified\/jquery.ui.tabs.min.js:1,
  "profiles_dkan_modules_contrib_panopoly_images_panopoly_2333de31" VARCHAR  -- Profiles\/dkan\/modules\/contrib\/panopoly Images\/panopoly-images.js:1,
  "profiles_dkan_modules_dkan_dkan_plugins_js_colorpicker_1b6add7e" VARCHAR  -- Profiles\/dkan\/modules\/dkan\/dkan Plugins\/js\/colorPicker.behavior.js:1,
  "profiles_dkan_modules_contrib_recline_js_jsondataview_js_1" VARCHAR  -- Profiles\/dkan\/modules\/contrib\/recline\/js\/jsondataview.js:1,
  "profiles_dkan_modules_contrib_recline_js_restdataview_js_1" VARCHAR  -- Profiles\/dkan\/modules\/contrib\/recline\/js\/restdataview.js:1,
  "sites_all_libraries_jquery_imagesloaded_jquery_imagesl_79c3198d" VARCHAR  -- Sites\/all\/libraries\/jquery.imagesloaded\/jquery.imagesloaded.min.js:1,
  "profiles_dkan_modules_contrib_ctools_js_collapsible_div_js_1" VARCHAR  -- Profiles\/dkan\/modules\/contrib\/ctools\/js\/collapsible-div.js:1,
  "profiles_dkan_modules_contrib_facetapi_facetapi_js_1" VARCHAR  -- Profiles\/dkan\/modules\/contrib\/facetapi\/facetapi.js:1,
  "sites_all_modules_google_analytics_googleanalytics_js_1" VARCHAR  -- Sites\/all\/modules\/google Analytics\/googleanalytics.js:1,
  "n_0_1" VARCHAR  -- 0:1,
  "profiles_dkan_modules_contrib_chosen_chosen_js_1" VARCHAR  -- Profiles\/dkan\/modules\/contrib\/chosen\/chosen.js:1,
  "profiles_dkan_themes_contrib_radix_assets_js_radix_script_js_1" VARCHAR  -- Profiles\/dkan\/themes\/contrib\/radix\/assets\/js\/radix.script.js:1,
  "profiles_dkan_themes_nuboot_radix_assets_js_nuboot_rad_441344e1" VARCHAR  -- Profiles\/dkan\/themes\/nuboot Radix\/assets\/js\/nuboot Radix.script.js:1,
  "sites_all_themes_opendata_assets_js_opendata_script_js_1" VARCHAR  -- Sites\/all\/themes\/opendata\/assets\/js\/opendata.script.js:1},
  "css_modules_system_system_base_css_1" VARCHAR  -- Css:{"modules\/system\/system.base.css":1,
  "modules_system_system_messages_css_1" VARCHAR  -- Modules\/system\/system.messages.css:1,
  "modules_system_system_theme_css_1" VARCHAR  -- Modules\/system\/system.theme.css:1,
  "profiles_dkan_libraries_chosen_chosen_css_1" VARCHAR  -- Profiles\/dkan\/libraries\/chosen\/chosen.css:1,
  "profiles_dkan_modules_contrib_chosen_css_chosen_drupal_css_1" VARCHAR  -- Profiles\/dkan\/modules\/contrib\/chosen\/css\/chosen-drupal.css:1,
  "misc_ui_jquery_ui_core_css_1" VARCHAR  -- Misc\/ui\/jquery.ui.core.css:1,
  "misc_ui_jquery_ui_theme_css_1" VARCHAR  -- Misc\/ui\/jquery.ui.theme.css:1,
  "misc_ui_jquery_ui_tabs_css_1" VARCHAR  -- Misc\/ui\/jquery.ui.tabs.css:1,
  "profiles_dkan_modules_contrib_date_date_api_date_css_1" VARCHAR  -- Profiles\/dkan\/modules\/contrib\/date\/date Api\/date.css:1,
  "profiles_dkan_modules_contrib_date_date_popup_themes_d_b501c28a" VARCHAR  -- Profiles\/dkan\/modules\/contrib\/date\/date Popup\/themes\/datepicker.1.7.css:1,
  "profiles_dkan_modules_dkan_dkan_data_story_css_dkan_da_7d44f1dc" VARCHAR  -- Profiles\/dkan\/modules\/dkan\/dkan Data Story\/css\/dkan Data Story.css:1,
  "profiles_dkan_modules_dkan_dkan_harvest_modules_dkan_h_4e088fc5" VARCHAR  -- Profiles\/dkan\/modules\/dkan\/dkan Harvest\/modules\/dkan Harvest Dashboard\/css\/dkan Harvest Dashboard.css:1,
  "modules_field_theme_field_css_1" VARCHAR  -- Modules\/field\/theme\/field.css:1,
  "profiles_dkan_modules_contrib_field_hidden_field_hidden_css_1" VARCHAR  -- Profiles\/dkan\/modules\/contrib\/field Hidden\/field Hidden.css:1,
  "modules_node_node_css_1" VARCHAR  -- Modules\/node\/node.css:1,
  "profiles_dkan_modules_contrib_panopoly_widgets_panopol_0834f886" VARCHAR  -- Profiles\/dkan\/modules\/contrib\/panopoly Widgets\/panopoly-widgets.css:1,
  "profiles_dkan_modules_contrib_panopoly_widgets_panopol_b3eb4e8d" VARCHAR  -- Profiles\/dkan\/modules\/contrib\/panopoly Widgets\/panopoly-widgets-spotlight.css:1,
  "profiles_dkan_modules_contrib_radix_layouts_radix_layouts_css_1" VARCHAR  -- Profiles\/dkan\/modules\/contrib\/radix Layouts\/radix Layouts.css:1,
  "modules_user_user_css_1" VARCHAR  -- Modules\/user\/user.css:1,
  "profiles_dkan_modules_contrib_views_css_views_css_1" VARCHAR  -- Profiles\/dkan\/modules\/contrib\/views\/css\/views.css:1,
  "profiles_dkan_modules_contrib_media_modules_media_wysi_05a8086e" VARCHAR  -- Profiles\/dkan\/modules\/contrib\/media\/modules\/media Wysiwyg\/css\/media Wysiwyg.base.css:1,
  "profiles_dkan_modules_contrib_ctools_css_ctools_css_1" VARCHAR  -- Profiles\/dkan\/modules\/contrib\/ctools\/css\/ctools.css:1,
  "profiles_dkan_modules_contrib_panels_css_panels_css_1" VARCHAR  -- Profiles\/dkan\/modules\/contrib\/panels\/css\/panels.css:1,
  "profiles_dkan_modules_contrib_ctools_css_collapsible_div_css_1" VARCHAR  -- Profiles\/dkan\/modules\/contrib\/ctools\/css\/collapsible-div.css:1,
  "profiles_dkan_modules_dkan_dkan_topics_theme_dkan_topics_css_1" VARCHAR  -- Profiles\/dkan\/modules\/dkan\/dkan Topics\/theme\/dkan Topics.css:1,
  "n__fonts_googleapis_com_css_family_open_sans_400_300_700_1" VARCHAR  -- \/\/fonts.googleapis.com\/css?family=Open+Sans::400,300,700:1,
  "public_font_icon_select_general_generated_1_css_1" VARCHAR  -- Public:\/\/font-icon-select-general-generated-1.css:1,
  "profiles_dkan_modules_dkan_dkan_dataset_css_dkan_dataset_css_1" VARCHAR  -- Profiles\/dkan\/modules\/dkan\/dkan Dataset\/css\/dkan Dataset.css:1,
  "profiles_dkan_themes_nuboot_radix_assets_css_nuboot_ra_097b19a0" VARCHAR  -- Profiles\/dkan\/themes\/nuboot Radix\/assets\/css\/nuboot Radix.style.css:1,
  "profiles_dkan_themes_nuboot_radix_assets_css_dkan_flat_3cf2770f" VARCHAR  -- Profiles\/dkan\/themes\/nuboot Radix\/assets\/css\/dkan-flaticon.css:1,
  "profiles_dkan_themes_nuboot_radix_assets_css_dkan_topics_css_1" VARCHAR  -- Profiles\/dkan\/themes\/nuboot Radix\/assets\/css\/dkan-topics.css:1,
  "sites_all_themes_opendata_assets_css_opendata_style_css_1" VARCHAR  -- Sites\/all\/themes\/opendata\/assets\/css\/opendata.style.css:1,
  "profiles_dkan_themes_nuboot_radix_assets_css_print_css_1" VARCHAR  -- Profiles\/dkan\/themes\/nuboot Radix\/assets\/css\/print.css:1,
  "https_cambridgeshireinsight_org_uk_sites_default_files_7a79ba4d" VARCHAR  -- Https:\/\/data.cambridgeshireinsight.org.uk\/sites\/default\/files\/colorizer\/opendata-5d55b06d.css:1,
  "profiles_dkan_themes_nuboot_radix_assets_css_ie_css_1" VARCHAR  -- Profiles\/dkan\/themes\/nuboot Radix\/assets\/css\/ie.css:1,
  "profiles_dkan_themes_nuboot_radix_assets_css_ie9_css_1" VARCHAR  -- Profiles\/dkan\/themes\/nuboot Radix\/assets\/css\/ie9.css:1,
  "profiles_dkan_themes_nuboot_radix_assets_css_ie8_css_1" VARCHAR  -- Profiles\/dkan\/themes\/nuboot Radix\/assets\/css\/ie8.css:1,
  "profiles_dkan_modules_contrib_panopoly_images_panopoly_5e7e96fc" VARCHAR  -- Profiles\/dkan\/modules\/contrib\/panopoly Images\/panopoly-images.css:1,
  "sites_default_files_fontyourface_font_css_1" VARCHAR  -- Sites\/default\/files\/fontyourface\/font.css:1,
  "http_fonts_googleapis_com_css_family_montserrat_300_re_d5aede73" VARCHAR  -- Http:\/\/fonts.googleapis.com\/css?family=Montserrat:300,regular\u0026subset=latin:1}},
  "chosen_selector_page_node_select_not_class_u0022delta__91f28e15" VARCHAR  -- Chosen:{"selector":".page-node Select:not([class*=\u0022delta-order\u0022],
  "n__name_u0022workbench_moderation_u0022" VARCHAR  -- [name*=\u0022workbench Moderation\u0022],
  "n__class_u0022filter_list_u0022" VARCHAR  -- [class*=\u0022filter-list\u0022],
  "n__id_u0022delimiter_u0022" VARCHAR  -- [id*=\u0022delimiter\u0022],
  "n__name_u0022sort_by_u0022" VARCHAR  -- [name*=\u0022sort By\u0022],
  "n__name_u0022sort_order_u0022" VARCHAR  -- [name*=\u0022sort Order\u0022],
  "n__id_u0022lines_terminated_by_u0022" VARCHAR  -- [id*=\u0022lines-terminated-by\u0022],
  "n__id_u0022lang_dropdown_select_language_u0022" VARCHAR  -- [id*=\u0022lang-dropdown-select-language\u0022])",
  "minimum_single_0" VARCHAR,
  "minimum_multiple_0" VARCHAR,
  "minimum_width_0" VARCHAR,
  "options_allow_single_deselect_false" VARCHAR  -- Options:{"allow Single Deselect":false,
  "disable_search_false" VARCHAR,
  "disable_search_threshold_0" VARCHAR,
  "search_contains_false" VARCHAR,
  "placeholder_text_multiple_choose_some_options" VARCHAR  -- Placeholder Text Multiple:"Choose Some Options",
  "placeholder_text_single_choose_an_option" VARCHAR  -- Placeholder Text Single:"Choose An Option",
  "no_results_text_no_results_match" VARCHAR  -- No Results Text:"No Results Match",
  "inherit_select_classes_true" VARCHAR  -- Inherit Select Classes:true}},
  "urlisajaxtrusted_search_field_tags_expenditure_274_true" VARCHAR  -- UrlIsAjaxTrusted:{"\/search\/field Tags\/expenditure-274":true,
  "n__search_field_tags_expenditure_274_query_20sites_20d_2cefd841" VARCHAR  -- \/search\/field Tags\/expenditure-274?query=%20sites%20default%20files%20CambsPayments2025-01.csv\u0026sort By=changed:true},
  "better_exposed_filters_views_dkan_datasets_displays_pa_c0ce787a" VARCHAR  -- Better Exposed Filters:{"views":{"dkan Datasets":{"displays":{"panel Pane 1":{"filters":{"query":{"required":false}}}}}}},
  "facetapi_facets_limit_20" VARCHAR  -- Facetapi:{"facets":[{"limit":"20",
  "id_facetapi_facet_search_apidatasets_block_field_topic" VARCHAR  -- Id:"facetapi-facet-search-apidatasets-block-field-topic",
  "searcher_search_api_datasets" VARCHAR  -- Searcher:"search Api@datasets",
  "realmname_block" VARCHAR  -- RealmName:"block",
  "facetname_field_topic" VARCHAR  -- FacetName:"field Topic",
  "querytype_null" VARCHAR,
  "widget_terms" VARCHAR  -- Widget:"terms",
  "showmoretext_show_more" VARCHAR  -- ShowMoreText:"Show More",
  "showfewertext_show_fewer" VARCHAR  -- ShowFewerText:"Show Fewer"},
  "n__limit_20" VARCHAR  -- {"limit":20
);

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