Baselight
Sign In

Council Spending

Leeds City Council

@ukgov.council_spending

June 2015
@ukgov.council_spending.june_2015

Council spending

  • 518.66 KB
  • 23090 rows
  • 253 columns
  • Only the first 100 columns are shown
organisation_code

Organisation Code

organisation_label

Organisation Label

effective_date

Effective Date

organisational_unit

Organisational Unit

service_division_label

Service Division Label

category_internal_name

Category Internal Name

purpose

Purpose

detailed_expenditure_code

Detailed Expenditure Code

payment_date

Payment Date

transactionnumber

TransactionNumber

irrecoverable_vat_amount

Irrecoverable VAT Amount

amount

Amount

capital_or_revenue

Capital Or Revenue

benificiary_name

Benificiary Name

procurement_card

Procurement Card

unnamed_15

Unnamed: 15

unnamed_16

Unnamed: 16

unnamed_17

Unnamed: 17

unnamed_18

Unnamed: 18

unnamed_19

Unnamed: 19

unnamed_20

Unnamed: 20

unnamed_21

Unnamed: 21

unnamed_22

Unnamed: 22

unnamed_23

Unnamed: 23

unnamed_24

Unnamed: 24

unnamed_25

Unnamed: 25

unnamed_26

Unnamed: 26

unnamed_27

Unnamed: 27

unnamed_28

Unnamed: 28

unnamed_29

Unnamed: 29

unnamed_30

Unnamed: 30

unnamed_31

Unnamed: 31

unnamed_32

Unnamed: 32

unnamed_33

Unnamed: 33

unnamed_34

Unnamed: 34

unnamed_35

Unnamed: 35

unnamed_36

Unnamed: 36

unnamed_37

Unnamed: 37

unnamed_38

Unnamed: 38

unnamed_39

Unnamed: 39

unnamed_40

Unnamed: 40

unnamed_41

Unnamed: 41

unnamed_42

Unnamed: 42

unnamed_43

Unnamed: 43

unnamed_44

Unnamed: 44

unnamed_45

Unnamed: 45

unnamed_46

Unnamed: 46

unnamed_47

Unnamed: 47

unnamed_48

Unnamed: 48

unnamed_49

Unnamed: 49

unnamed_50

Unnamed: 50

unnamed_51

Unnamed: 51

unnamed_52

Unnamed: 52

unnamed_53

Unnamed: 53

unnamed_54

Unnamed: 54

unnamed_55

Unnamed: 55

unnamed_56

Unnamed: 56

unnamed_57

Unnamed: 57

unnamed_58

Unnamed: 58

unnamed_59

Unnamed: 59

unnamed_60

Unnamed: 60

unnamed_61

Unnamed: 61

unnamed_62

Unnamed: 62

unnamed_63

Unnamed: 63

unnamed_64

Unnamed: 64

unnamed_65

Unnamed: 65

unnamed_66

Unnamed: 66

unnamed_67

Unnamed: 67

unnamed_68

Unnamed: 68

unnamed_69

Unnamed: 69

unnamed_70

Unnamed: 70

unnamed_71

Unnamed: 71

unnamed_72

Unnamed: 72

unnamed_73

Unnamed: 73

unnamed_74

Unnamed: 74

unnamed_75

Unnamed: 75

unnamed_76

Unnamed: 76

unnamed_77

Unnamed: 77

unnamed_78

Unnamed: 78

unnamed_79

Unnamed: 79

unnamed_80

Unnamed: 80

unnamed_81

Unnamed: 81

unnamed_82

Unnamed: 82

unnamed_83

Unnamed: 83

unnamed_84

Unnamed: 84

unnamed_85

Unnamed: 85

unnamed_86

Unnamed: 86

unnamed_87

Unnamed: 87

unnamed_88

Unnamed: 88

unnamed_89

Unnamed: 89

unnamed_90

Unnamed: 90

unnamed_91

Unnamed: 91

unnamed_92

Unnamed: 92

unnamed_93

Unnamed: 93

unnamed_94

Unnamed: 94

unnamed_95

Unnamed: 95

unnamed_96

Unnamed: 96

unnamed_97

Unnamed: 97

unnamed_98

Unnamed: 98

unnamed_99

Unnamed: 99

unnamed_100

Unnamed: 100

unnamed_101

Unnamed: 101

unnamed_102

Unnamed: 102

unnamed_103

Unnamed: 103

unnamed_104

Unnamed: 104

unnamed_105

Unnamed: 105

unnamed_106

Unnamed: 106

unnamed_107

Unnamed: 107

unnamed_108

Unnamed: 108

unnamed_109

Unnamed: 109

unnamed_110

Unnamed: 110

unnamed_111

Unnamed: 111

unnamed_112

Unnamed: 112

unnamed_113

Unnamed: 113

unnamed_114

Unnamed: 114

unnamed_115

Unnamed: 115

unnamed_116

Unnamed: 116

unnamed_117

Unnamed: 117

unnamed_118

Unnamed: 118

unnamed_119

Unnamed: 119

unnamed_120

Unnamed: 120

unnamed_121

Unnamed: 121

unnamed_122

Unnamed: 122

unnamed_123

Unnamed: 123

unnamed_124

Unnamed: 124

unnamed_125

Unnamed: 125

unnamed_126

Unnamed: 126

unnamed_127

Unnamed: 127

unnamed_128

Unnamed: 128

unnamed_129

Unnamed: 129

unnamed_130

Unnamed: 130

unnamed_131

Unnamed: 131

unnamed_132

Unnamed: 132

unnamed_133

Unnamed: 133

unnamed_134

Unnamed: 134

unnamed_135

Unnamed: 135

unnamed_136

Unnamed: 136

unnamed_137

Unnamed: 137

unnamed_138

Unnamed: 138

unnamed_139

Unnamed: 139

unnamed_140

Unnamed: 140

unnamed_141

Unnamed: 141

unnamed_142

Unnamed: 142

unnamed_143

Unnamed: 143

unnamed_144

Unnamed: 144

unnamed_145

Unnamed: 145

unnamed_146

Unnamed: 146

unnamed_147

Unnamed: 147

unnamed_148

Unnamed: 148

unnamed_149

Unnamed: 149

unnamed_150

Unnamed: 150

unnamed_151

Unnamed: 151

unnamed_152

Unnamed: 152

unnamed_153

Unnamed: 153

unnamed_154

Unnamed: 154

unnamed_155

Unnamed: 155

unnamed_156

Unnamed: 156

unnamed_157

Unnamed: 157

unnamed_158

Unnamed: 158

unnamed_159

Unnamed: 159

unnamed_160

Unnamed: 160

unnamed_161

Unnamed: 161

unnamed_162

Unnamed: 162

unnamed_163

Unnamed: 163

unnamed_164

Unnamed: 164

unnamed_165

Unnamed: 165

unnamed_166

Unnamed: 166

unnamed_167

Unnamed: 167

unnamed_168

Unnamed: 168

unnamed_169

Unnamed: 169

unnamed_170

Unnamed: 170

unnamed_171

Unnamed: 171

unnamed_172

Unnamed: 172

unnamed_173

Unnamed: 173

unnamed_174

Unnamed: 174

unnamed_175

Unnamed: 175

unnamed_176

Unnamed: 176

unnamed_177

Unnamed: 177

unnamed_178

Unnamed: 178

unnamed_179

Unnamed: 179

unnamed_180

Unnamed: 180

unnamed_181

Unnamed: 181

unnamed_182

Unnamed: 182

unnamed_183

Unnamed: 183

unnamed_184

Unnamed: 184

unnamed_185

Unnamed: 185

unnamed_186

Unnamed: 186

unnamed_187

Unnamed: 187

unnamed_188

Unnamed: 188

unnamed_189

Unnamed: 189

unnamed_190

Unnamed: 190

unnamed_191

Unnamed: 191

unnamed_192

Unnamed: 192

unnamed_193

Unnamed: 193

unnamed_194

Unnamed: 194

unnamed_195

Unnamed: 195

unnamed_196

Unnamed: 196

unnamed_197

Unnamed: 197

unnamed_198

Unnamed: 198

unnamed_199

Unnamed: 199

unnamed_200

Unnamed: 200

unnamed_201

Unnamed: 201

unnamed_202

Unnamed: 202

unnamed_203

Unnamed: 203

unnamed_204

Unnamed: 204

unnamed_205

Unnamed: 205

unnamed_206

Unnamed: 206

unnamed_207

Unnamed: 207

unnamed_208

Unnamed: 208

unnamed_209

Unnamed: 209

unnamed_210

Unnamed: 210

unnamed_211

Unnamed: 211

unnamed_212

Unnamed: 212

unnamed_213

Unnamed: 213

unnamed_214

Unnamed: 214

unnamed_215

Unnamed: 215

unnamed_216

Unnamed: 216

unnamed_217

Unnamed: 217

unnamed_218

Unnamed: 218

unnamed_219

Unnamed: 219

unnamed_220

Unnamed: 220

unnamed_221

Unnamed: 221

unnamed_222

Unnamed: 222

unnamed_223

Unnamed: 223

unnamed_224

Unnamed: 224

unnamed_225

Unnamed: 225

unnamed_226

Unnamed: 226

unnamed_227

Unnamed: 227

unnamed_228

Unnamed: 228

unnamed_229

Unnamed: 229

unnamed_230

Unnamed: 230

unnamed_231

Unnamed: 231

unnamed_232

Unnamed: 232

unnamed_233

Unnamed: 233

unnamed_234

Unnamed: 234

unnamed_235

Unnamed: 235

unnamed_236

Unnamed: 236

unnamed_237

Unnamed: 237

unnamed_238

Unnamed: 238

unnamed_239

Unnamed: 239

unnamed_240

Unnamed: 240

unnamed_241

Unnamed: 241

unnamed_242

Unnamed: 242

unnamed_243

Unnamed: 243

unnamed_244

Unnamed: 244

unnamed_245

Unnamed: 245

unnamed_246

Unnamed: 246

unnamed_247

Unnamed: 247

unnamed_248

Unnamed: 248

unnamed_249

Unnamed: 249

unnamed_250

Unnamed: 250

unnamed_251

Unnamed: 251

unnamed_252

Unnamed: 252

Http://opendatacommunities.org/id/metropolitan-district-council/leedsLeeds City CouncilTue Jun 30 2015 00:00:00 GMT+0000 (Coordinated Universal Time)Central & CorporateCommercial Services Trading ServicesSupplies and ServicesOperational MaterialsMon Jun 08 2015 00:00:00 GMT+0000 (Coordinated Universal Time)1506-00001237.6RA & A Electrical Distributors LtdNo
Http://opendatacommunities.org/id/metropolitan-district-council/leedsLeeds City CouncilTue Jun 30 2015 00:00:00 GMT+0000 (Coordinated Universal Time)Central & CorporateCommercial Services Trading ServicesSupplies and ServicesOperational MaterialsMon Jun 08 2015 00:00:00 GMT+0000 (Coordinated Universal Time)1506-0000237RA & A Electrical Distributors LtdNo
Http://opendatacommunities.org/id/metropolitan-district-council/leedsLeeds City CouncilTue Jun 30 2015 00:00:00 GMT+0000 (Coordinated Universal Time)Central & CorporateCommercial Services Trading ServicesSupplies and ServicesOperational MaterialsWed Jun 17 2015 00:00:00 GMT+0000 (Coordinated Universal Time)1506-00003127.22RA & A Electrical Distributors LtdNo
Http://opendatacommunities.org/id/metropolitan-district-council/leedsLeeds City CouncilTue Jun 30 2015 00:00:00 GMT+0000 (Coordinated Universal Time)Environment & HousingEnvironmental HealthCapitalConstructionThu Jun 11 2015 00:00:00 GMT+0000 (Coordinated Universal Time)1506-0000410000CA & C GalleyNo
Http://opendatacommunities.org/id/metropolitan-district-council/leedsLeeds City CouncilTue Jun 30 2015 00:00:00 GMT+0000 (Coordinated Universal Time)Central & CorporateCommercial Services Trading ServicesSupplies and ServicesOperational MaterialsMon Jun 08 2015 00:00:00 GMT+0000 (Coordinated Universal Time)1506-0000520.4RA Andrews & Sons (Marbles & Tiles)No
Http://opendatacommunities.org/id/metropolitan-district-council/leedsLeeds City CouncilTue Jun 30 2015 00:00:00 GMT+0000 (Coordinated Universal Time)Central & CorporateCommercial Services Trading ServicesSupplies and ServicesOperational MaterialsMon Jun 22 2015 00:00:00 GMT+0000 (Coordinated Universal Time)1506-0000618.97RA Andrews & Sons (Marbles & Tiles)No
Http://opendatacommunities.org/id/metropolitan-district-council/leedsLeeds City CouncilTue Jun 30 2015 00:00:00 GMT+0000 (Coordinated Universal Time)Central & CorporateCommercial Services Trading ServicesSupplies and ServicesOperational MaterialsMon Jun 22 2015 00:00:00 GMT+0000 (Coordinated Universal Time)1506-0000773.06RA Andrews & Sons (Marbles & Tiles)No
Http://opendatacommunities.org/id/metropolitan-district-council/leedsLeeds City CouncilTue Jun 30 2015 00:00:00 GMT+0000 (Coordinated Universal Time)Central & CorporateCommercial Services Trading ServicesSupplies and ServicesOperational MaterialsMon Jun 08 2015 00:00:00 GMT+0000 (Coordinated Universal Time)1506-00008-10RA Andrews & Sons (Marbles & Tiles)No
Http://opendatacommunities.org/id/metropolitan-district-council/leedsLeeds City CouncilTue Jun 30 2015 00:00:00 GMT+0000 (Coordinated Universal Time)Central & CorporateCommercial Services Trading ServicesSupplies and ServicesStores - Central And Other DepotsMon Jun 08 2015 00:00:00 GMT+0000 (Coordinated Universal Time)1506-00009272RA Andrews & Sons (Marbles & Tiles)No
Http://opendatacommunities.org/id/metropolitan-district-council/leedsLeeds City CouncilTue Jun 30 2015 00:00:00 GMT+0000 (Coordinated Universal Time)Childrens ServicesLearning Skills & UniversalSupplies and ServicesTraining AllowancesFri Jun 12 2015 00:00:00 GMT+0000 (Coordinated Universal Time)1506-00010248.19RREDACTED PERSONAL DATANo

CREATE TABLE june_2015 (
  "organisation_code" VARCHAR,
  "organisation_label" VARCHAR,
  "effective_date" TIMESTAMP,
  "organisational_unit" VARCHAR,
  "service_division_label" VARCHAR,
  "category_internal_name" VARCHAR,
  "purpose" VARCHAR,
  "detailed_expenditure_code" DOUBLE,
  "payment_date" TIMESTAMP,
  "transactionnumber" VARCHAR,
  "irrecoverable_vat_amount" DOUBLE,
  "amount" DOUBLE,
  "capital_or_revenue" VARCHAR,
  "benificiary_name" VARCHAR,
  "procurement_card" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR,
  "unnamed_23" VARCHAR,
  "unnamed_24" VARCHAR,
  "unnamed_25" VARCHAR,
  "unnamed_26" VARCHAR,
  "unnamed_27" VARCHAR,
  "unnamed_28" VARCHAR,
  "unnamed_29" VARCHAR,
  "unnamed_30" VARCHAR,
  "unnamed_31" VARCHAR,
  "unnamed_32" VARCHAR,
  "unnamed_33" VARCHAR,
  "unnamed_34" VARCHAR,
  "unnamed_35" VARCHAR,
  "unnamed_36" VARCHAR,
  "unnamed_37" VARCHAR,
  "unnamed_38" VARCHAR,
  "unnamed_39" VARCHAR,
  "unnamed_40" VARCHAR,
  "unnamed_41" VARCHAR,
  "unnamed_42" VARCHAR,
  "unnamed_43" VARCHAR,
  "unnamed_44" VARCHAR,
  "unnamed_45" VARCHAR,
  "unnamed_46" VARCHAR,
  "unnamed_47" VARCHAR,
  "unnamed_48" VARCHAR,
  "unnamed_49" VARCHAR,
  "unnamed_50" VARCHAR,
  "unnamed_51" VARCHAR,
  "unnamed_52" VARCHAR,
  "unnamed_53" VARCHAR,
  "unnamed_54" VARCHAR,
  "unnamed_55" VARCHAR,
  "unnamed_56" VARCHAR,
  "unnamed_57" VARCHAR,
  "unnamed_58" VARCHAR,
  "unnamed_59" VARCHAR,
  "unnamed_60" VARCHAR,
  "unnamed_61" VARCHAR,
  "unnamed_62" VARCHAR,
  "unnamed_63" VARCHAR,
  "unnamed_64" VARCHAR,
  "unnamed_65" VARCHAR,
  "unnamed_66" VARCHAR,
  "unnamed_67" VARCHAR,
  "unnamed_68" VARCHAR,
  "unnamed_69" VARCHAR,
  "unnamed_70" VARCHAR,
  "unnamed_71" VARCHAR,
  "unnamed_72" VARCHAR,
  "unnamed_73" VARCHAR,
  "unnamed_74" VARCHAR,
  "unnamed_75" VARCHAR,
  "unnamed_76" VARCHAR,
  "unnamed_77" VARCHAR,
  "unnamed_78" VARCHAR,
  "unnamed_79" VARCHAR,
  "unnamed_80" VARCHAR,
  "unnamed_81" VARCHAR,
  "unnamed_82" VARCHAR,
  "unnamed_83" VARCHAR,
  "unnamed_84" VARCHAR,
  "unnamed_85" VARCHAR,
  "unnamed_86" VARCHAR,
  "unnamed_87" VARCHAR,
  "unnamed_88" VARCHAR,
  "unnamed_89" VARCHAR,
  "unnamed_90" VARCHAR,
  "unnamed_91" VARCHAR,
  "unnamed_92" VARCHAR,
  "unnamed_93" VARCHAR,
  "unnamed_94" VARCHAR,
  "unnamed_95" VARCHAR,
  "unnamed_96" VARCHAR,
  "unnamed_97" VARCHAR,
  "unnamed_98" VARCHAR,
  "unnamed_99" VARCHAR
);

Share link

Anyone who has the link will be able to view this.