Expenditure Over £500 - April 2018

@ukgov.stockport_council_expenditure_over_500.expenditure_over_500_april_2018

66.59 kB
7,764 rows
6 columns

CREATE TABLE expenditure_over_500_april_2018 (
  "merchant_category" VARCHAR,
  "supplier_name" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Expenditure Over £500 - April 2019

@ukgov.stockport_council_expenditure_over_500.expenditure_over_500_april_2019

65.78 kB
7,606 rows
7 columns

CREATE TABLE expenditure_over_500_april_2019 (
  "supplier" VARCHAR,
  "merchant_category" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "paid_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Expenditure Over £500 - April 2020

@ukgov.stockport_council_expenditure_over_500.expenditure_over_500_april_2020

88.61 kB
17,603 rows
6 columns

CREATE TABLE expenditure_over_500_april_2020 (
  "merchant_category" VARCHAR,
  "supplier" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Expenditure Over £500 - April 2021

@ukgov.stockport_council_expenditure_over_500.expenditure_over_500_april_2021

106.31 kB
24,421 rows
6 columns

CREATE TABLE expenditure_over_500_april_2021 (
  "merchant_category" VARCHAR,
  "supplier" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Expenditure Over £500 - August 2018

@ukgov.stockport_council_expenditure_over_500.expenditure_over_500_august_2018

64.89 kB
7,958 rows
6 columns

CREATE TABLE expenditure_over_500_august_2018 (
  "merchant_category" VARCHAR,
  "supplier" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Expenditure Over £500 - August 2019

@ukgov.stockport_council_expenditure_over_500.expenditure_over_500_august_2019

67.01 kB
7,779 rows
7 columns

CREATE TABLE expenditure_over_500_august_2019 (
  "merchant_category" VARCHAR,
  "supplier" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "paid_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Expenditure Over £500 - August 2020

@ukgov.stockport_council_expenditure_over_500.expenditure_over_500_august_2020

73.86 kB
14,791 rows
6 columns

CREATE TABLE expenditure_over_500_august_2020 (
  "merchant_category" VARCHAR,
  "supplier" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Expenditure Over £500 - August 2021

@ukgov.stockport_council_expenditure_over_500.expenditure_over_500_august_2021

85.64 kB
18,569 rows
6 columns

CREATE TABLE expenditure_over_500_august_2021 (
  "merchant_category" VARCHAR,
  "supplier" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Expenditure Over £500 - December 2018

@ukgov.stockport_council_expenditure_over_500.expenditure_over_500_december_2018

68.5 kB
8,401 rows
7 columns

CREATE TABLE expenditure_over_500_december_2018 (
  "merchant_category" VARCHAR,
  "supplier" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "paid_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Expenditure Over £500 - December 2019

@ukgov.stockport_council_expenditure_over_500.expenditure_over_500_december_2019

66.3 kB
8,895 rows
6 columns

CREATE TABLE expenditure_over_500_december_2019 (
  "merchant_category" VARCHAR,
  "supplier" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Expenditure Over £500 - December 2020

@ukgov.stockport_council_expenditure_over_500.expenditure_over_500_december_2020

90.64 kB
19,362 rows
6 columns

CREATE TABLE expenditure_over_500_december_2020 (
  "merchant_category" VARCHAR,
  "supplier" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Expenditure Over £500 - February 2019

@ukgov.stockport_council_expenditure_over_500.expenditure_over_500_february_2019

65.89 kB
6,898 rows
7 columns

CREATE TABLE expenditure_over_500_february_2019 (
  "supplier" VARCHAR,
  "merchant_category" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "paid_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Expenditure Over £500 - February 2021

@ukgov.stockport_council_expenditure_over_500.expenditure_over_500_february_2021

83.66 kB
17,201 rows
6 columns

CREATE TABLE expenditure_over_500_february_2021 (
  "merchant_category" VARCHAR,
  "supplier" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Expenditure Over £500 - January 2019

@ukgov.stockport_council_expenditure_over_500.expenditure_over_500_january_2019

70.47 kB
8,388 rows
7 columns

CREATE TABLE expenditure_over_500_january_2019 (
  "supplier" VARCHAR,
  "merchant_category" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "paid_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Expenditure Over £500 - January 2020

@ukgov.stockport_council_expenditure_over_500.expenditure_over_500_january_2020

68.31 kB
9,522 rows
6 columns

CREATE TABLE expenditure_over_500_january_2020 (
  "merchant_category" VARCHAR,
  "supplier" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Expenditure Over £500 - January 2021

@ukgov.stockport_council_expenditure_over_500.expenditure_over_500_january_2021

86.19 kB
19,644 rows
6 columns

CREATE TABLE expenditure_over_500_january_2021 (
  "merchant_category" VARCHAR,
  "supplier" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Expenditure Over £500 - July 2018

@ukgov.stockport_council_expenditure_over_500.expenditure_over_500_july_2018

71.82 kB
8,490 rows
6 columns

CREATE TABLE expenditure_over_500_july_2018 (
  "merchant_category" VARCHAR,
  "supplier_name" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Expenditure Over £500 - July 2019

@ukgov.stockport_council_expenditure_over_500.expenditure_over_500_july_2019

64.25 kB
7,683 rows
7 columns

CREATE TABLE expenditure_over_500_july_2019 (
  "merchant_category" VARCHAR,
  "supplier" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "paid_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Expenditure Over £500 - July 2020

@ukgov.stockport_council_expenditure_over_500.expenditure_over_500_july_2020

81.36 kB
16,427 rows
6 columns

CREATE TABLE expenditure_over_500_july_2020 (
  "merchant_category" VARCHAR,
  "supplier" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Expenditure Over £500 - July 2021

@ukgov.stockport_council_expenditure_over_500.expenditure_over_500_july_2021

85.71 kB
16,910 rows
6 columns

CREATE TABLE expenditure_over_500_july_2021 (
  "merchant_category" VARCHAR,
  "supplier" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Expenditure Over £500 - June 2018

@ukgov.stockport_council_expenditure_over_500.expenditure_over_500_june_2018

55.58 kB
6,382 rows
6 columns

CREATE TABLE expenditure_over_500_june_2018 (
  "merchant_category" VARCHAR,
  "supplier_name" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Expenditure Over £500 - June 2019

@ukgov.stockport_council_expenditure_over_500.expenditure_over_500_june_2019

66.56 kB
7,907 rows
7 columns

CREATE TABLE expenditure_over_500_june_2019 (
  "merchant_category" VARCHAR,
  "supplier" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "paid_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Expenditure Over £500 - June 2020

@ukgov.stockport_council_expenditure_over_500.expenditure_over_500_june_2020

77.44 kB
15,959 rows
6 columns

CREATE TABLE expenditure_over_500_june_2020 (
  "merchant_category" VARCHAR,
  "supplier" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Expenditure Over £500 - June 2021

@ukgov.stockport_council_expenditure_over_500.expenditure_over_500_june_2021

94.55 kB
19,538 rows
6 columns

CREATE TABLE expenditure_over_500_june_2021 (
  "merchant_category" VARCHAR,
  "supplier" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Expenditure Over £500 - March 2018

@ukgov.stockport_council_expenditure_over_500.expenditure_over_500_march_2018

65.09 kB
8,761 rows
5 columns

CREATE TABLE expenditure_over_500_march_2018 (
  "merchant_category" VARCHAR,
  "supplier_name" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "net_amount" DOUBLE
);

Expenditure Over £500 - March 2019

@ukgov.stockport_council_expenditure_over_500.expenditure_over_500_march_2019

78.12 kB
8,329 rows
7 columns

CREATE TABLE expenditure_over_500_march_2019 (
  "supplier" VARCHAR,
  "merchant_category" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "paid_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Expenditure Over £500 - March 2020

@ukgov.stockport_council_expenditure_over_500.expenditure_over_500_march_2020

73.07 kB
13,444 rows
6 columns

CREATE TABLE expenditure_over_500_march_2020 (
  "merchant_category" VARCHAR,
  "supplier" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Expenditure Over £500 - March 2021

@ukgov.stockport_council_expenditure_over_500.expenditure_over_500_march_2021

114.15 kB
26,065 rows
6 columns

CREATE TABLE expenditure_over_500_march_2021 (
  "merchant_category" VARCHAR,
  "supplier" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Expenditure Over £500 - May 2018

@ukgov.stockport_council_expenditure_over_500.expenditure_over_500_may_2018

61.22 kB
6,961 rows
6 columns

CREATE TABLE expenditure_over_500_may_2018 (
  "merchant_category" VARCHAR,
  "supplier_name" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Expenditure Over £500 - May 2019

@ukgov.stockport_council_expenditure_over_500.expenditure_over_500_may_2019

60.89 kB
6,901 rows
7 columns

CREATE TABLE expenditure_over_500_may_2019 (
  "supplier" VARCHAR,
  "merchant_category" VARCHAR,
  "services_to_people" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "paid_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Expenditure Over £500 - May 2020

@ukgov.stockport_council_expenditure_over_500.expenditure_over_500_may_2020

75.23 kB
15,811 rows
6 columns

CREATE TABLE expenditure_over_500_may_2020 (
  "merchant_category" VARCHAR,
  "supplier" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Expenditure Over £500 - May 2021

@ukgov.stockport_council_expenditure_over_500.expenditure_over_500_may_2021

86.58 kB
18,605 rows
6 columns

CREATE TABLE expenditure_over_500_may_2021 (
  "merchant_category" VARCHAR,
  "supplier" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Expenditure Over £500 - November 2018

@ukgov.stockport_council_expenditure_over_500.expenditure_over_500_november_2018

73.78 kB
8,145 rows
7 columns

CREATE TABLE expenditure_over_500_november_2018 (
  "merchant_category" VARCHAR,
  "supplier" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "paid_date" TIMESTAMP,
  "n__net_amount" DOUBLE  -- Net Amount
);

Expenditure Over £500 - November 2019

@ukgov.stockport_council_expenditure_over_500.expenditure_over_500_november_2019

63.73 kB
8,067 rows
7 columns

CREATE TABLE expenditure_over_500_november_2019 (
  "merchant_category" VARCHAR,
  "supplier" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "paid_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Expenditure Over £500 - November 2020

@ukgov.stockport_council_expenditure_over_500.expenditure_over_500_november_2020

87.96 kB
19,676 rows
6 columns

CREATE TABLE expenditure_over_500_november_2020 (
  "merchant_category" VARCHAR,
  "supplier" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Expenditure Over £500 - October 2018

@ukgov.stockport_council_expenditure_over_500.expenditure_over_500_october_2018

68.29 kB
7,800 rows
7 columns

CREATE TABLE expenditure_over_500_october_2018 (
  "merchant_category" VARCHAR,
  "supplier" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "paid_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Expenditure Over £500 - October 2019

@ukgov.stockport_council_expenditure_over_500.expenditure_over_500_october_2019

69.07 kB
8,118 rows
7 columns

CREATE TABLE expenditure_over_500_october_2019 (
  "merchant_category" VARCHAR,
  "supplier" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "paid_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Expenditure Over £500 - October 2020

@ukgov.stockport_council_expenditure_over_500.expenditure_over_500_october_2020

74.68 kB
14,483 rows
6 columns

CREATE TABLE expenditure_over_500_october_2020 (
  "merchant_category" VARCHAR,
  "supplier" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Expenditure Over £500 - October 2021

@ukgov.stockport_council_expenditure_over_500.expenditure_over_500_october_2021

82.8 kB
18,031 rows
6 columns

CREATE TABLE expenditure_over_500_october_2021 (
  "merchant_category" VARCHAR,
  "supplier" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Expenditure Over £500 - September 2018

@ukgov.stockport_council_expenditure_over_500.expenditure_over_500_september_2018

61.09 kB
6,776 rows
7 columns

CREATE TABLE expenditure_over_500_september_2018 (
  "merchant_category" VARCHAR,
  "supplier" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "paid_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Expenditure Over £500 - September 2019

@ukgov.stockport_council_expenditure_over_500.expenditure_over_500_september_2019

63.73 kB
8,067 rows
7 columns

CREATE TABLE expenditure_over_500_september_2019 (
  "merchant_category" VARCHAR,
  "supplier" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "paid_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Expenditure Over £500 - September 2020

@ukgov.stockport_council_expenditure_over_500.expenditure_over_500_september_2020

83.91 kB
16,773 rows
6 columns

CREATE TABLE expenditure_over_500_september_2020 (
  "merchant_category" VARCHAR,
  "supplier" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Expenditure Over £500 - September 2021

@ukgov.stockport_council_expenditure_over_500.expenditure_over_500_september_2021

92.49 kB
18,787 rows
6 columns

CREATE TABLE expenditure_over_500_september_2021 (
  "merchant_category" VARCHAR,
  "supplier" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Over £500 Spend - April 2022

@ukgov.stockport_council_expenditure_over_500.over_500_spend_april_2022

96.73 kB
22,783 rows
6 columns

CREATE TABLE over_500_spend_april_2022 (
  "merchant_category" VARCHAR,
  "supplier" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Over £500 Spend - April 2023

@ukgov.stockport_council_expenditure_over_500.over_500_spend_april_2023

101.16 kB
21,178 rows
6 columns

CREATE TABLE over_500_spend_april_2023 (
  "merchant_category" VARCHAR,
  "supplier" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Over £500 Spend April 2024

@ukgov.stockport_council_expenditure_over_500.over_500_spend_april_2024

104.58 kB
20,932 rows
6 columns

CREATE TABLE over_500_spend_april_2024 (
  "merchant_category" VARCHAR,
  "supplier" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Over £500 Spend - August 2022

@ukgov.stockport_council_expenditure_over_500.over_500_spend_august_2022

95.39 kB
20,965 rows
6 columns

CREATE TABLE over_500_spend_august_2022 (
  "merchant_category" VARCHAR,
  "supplier" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Over £500 Spend August 2023

@ukgov.stockport_council_expenditure_over_500.over_500_spend_august_2023

106.13 kB
24,611 rows
6 columns

CREATE TABLE over_500_spend_august_2023 (
  "merchant_category" VARCHAR,
  "supplier" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Over £500 Spend August 2024

@ukgov.stockport_council_expenditure_over_500.over_500_spend_august_2024

94.61 kB
16,936 rows
6 columns

CREATE TABLE over_500_spend_august_2024 (
  "merchant_category" VARCHAR,
  "supplier" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Over £500 Spend - December 2022

@ukgov.stockport_council_expenditure_over_500.over_500_spend_december_2022

89.02 kB
18,115 rows
6 columns

CREATE TABLE over_500_spend_december_2022 (
  "merchant_category" VARCHAR,
  "supplier" VARCHAR,
  "service" VARCHAR,
  "summary_of_purpose_of_expenditure" VARCHAR,
  "invoice_date" TIMESTAMP,
  "net_amount" DOUBLE
);

Tables