Last active
December 19, 2015 10:29
-
-
Save rufuspollock/5941049 to your computer and use it in GitHub Desktop.
Analysis of where the "header" rows actually appears in GLA spend data CSVs. Result of running this script https://github.com/rgrp/dataset-gla/blob/master/scripts/headings.sh. For details of files see https://github.com/rgrp/dataset-gla/blob/master/scrape.json
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 2010-11-P01.csv:4:Vendor,Expense Description,Amount,Doc No,,,^M | |
| 2010-11-P02.csv:6:Vendor,Expense Description,Amount,Doc No,,,^M | |
| 2010-11-P03.csv:6:Document No","Amount | |
| 2010-11-P04-500.csv:1:Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,SAP Document No,Amount £,Clearing Date^M | |
| 2010-11-P05-500.csv:1:Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,SAP Document No,Amount £,Clearing Date^M | |
| 2010-11-P06-500.csv:1:Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,SAP Document No,Amount £,Clearing Date^M | |
| 2010-11-P07-500.csv:1:Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,SAP Document No,Amount £,Clearing Date^M | |
| 2010-11-P08-500.csv:1:Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,SAP Document No,Amount £,Clearing Date^M | |
| 2010-11-P09-500.csv:1:Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,SAP Document No,Amount £,Clearing Date^M | |
| 2010-11-P10-500.csv:1:Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,SAP Document No,Amount £,Clearing Date^M | |
| 2010-11-P11-500.csv:1:Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,SAP Document No,Amount £,Clearing Date^M | |
| 2010-11-P12-500.csv:7:Vendor ID,Vendor Name ,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date^M | |
| 2010-11-P13-500.csv:7:Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,SAP Document No,Amount £,Clearing Date^M | |
| 2011-12-P11-500.csv:7:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date,^M | |
| 2011-12-P12-500.csv:7:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date,^M | |
| 2011-12-P13-500.csv:7:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date,^M | |
| 2011-12-P1-500.csv:7:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,^M | |
| 2011-12-P2-500.csv:7:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date^M | |
| 2011-12-P3-500.csv:7:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date^M | |
| 2011-12-P4-500.csv:7:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date^M | |
| 2011-12-P5-500.csv:7:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date^M | |
| 2011-12-P6-500.csv:7:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date,^M | |
| 2011-12-P7-500.csv:7:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date,,,^M | |
| 2011-12-P8-500.csv:7:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date,^M | |
| 2012-13-P10-250.csv:7:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date^M | |
| 2012-13-P11-250.csv:7:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date^M | |
| 2012-13-P12-250.csv:7:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date^M | |
| 2012-13-P13-250.csv:8:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date,,,^M | |
| 2012-13-P1-500.csv:8:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date,^M | |
| 2012-13-P2-250.csv:7:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date,^M | |
| 2012-13-P3-250.csv:7:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date,^M | |
| 2012-13-P4-250.csv:878:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date,^M | |
| 2012-13-P4-250.csv:8:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date,^M | |
| 2012-13-P5-250.csv:7:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date^M | |
| 2012-13-P6-250.csv:8:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date,^M | |
| 2012-13-P7-250.csv:7:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date,^M | |
| 2012-13-P9-250.csv:7:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date,^M | |
| april_2008.csv:3:,Supplier,Expense Description,Amount,,^M | |
| april_2009.csv:3:Supplier,Expense Description,Amount^M | |
| august_2008.csv:4:,Supplier,Expense Description,Amount^M | |
| august_2008.csv:7:,Supplier Name,Expense Code Description,Amount Paid^M | |
| august_2009.csv:4:,Supplier,Expense Description,Amount,Doc Type,Doc No,Date^M | |
| december_2008.csv:4:,Supplier,Expense Description,Amount,^M | |
| december_2009.csv:4:Supplier,Expense Description,Amount^M | |
| december_2009.csv:6:Supplier Name,Expense Code Description,Amount Paid^M | |
| february_2009.csv:4:,Supplier,Expense Description,Amount,,,,,^M | |
| january_2009.csv:4:,Supplier,Expense Description,Amount,,,,,^M | |
| january_2010.csv:3:,,Supplier,Expense Description,Amount,Doc Type,Doc No,Date,^M | |
| july_2008.csv:4:,Supplier,Expense Description,Amount^M | |
| july_2009.csv:4:,Supplier,Expense Description,Amount,Doc Type,Doc No,,^M | |
| june_2008.csv:4:,Supplier,Expense Description,Amount^M | |
| june_2009.csv:4:Supplier,Expense Description,Amount,,,,^M | |
| march_2009.csv:3:Supplier,Expense Description,Amount^M | |
| may_2008.csv:4:,Supplier,Expense Description,Amount^M | |
| may_2009.csv:3:,Supplier,Expense Description,Amount^M | |
| Mayor%27s%20250%20Report%20-%202013-14%20-%20P1%20%20-%20Combined.csv:8:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date,,,^M | |
| Mayors500Report-2011-12-P10-Final.csv:7:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date,^M | |
| Mayors-500-report2011-12-P9.csv:7:,Vendor ID,Vendor Name,Cost Element,Expenditure Account Code Description,Document No,Amount,Clearing Date^M | |
| november_2008.csv:4:,Supplier,Expense Description,Amount,,,,,,^M | |
| november_2008.csv:6:,Supplier Name,Expense Code Description,Amount Paid,,,,,,^M | |
| november_2009.csv:3:Supplier,Expense Description,Amount,Doc Type,Doc No,Date^M | |
| october_2008.csv:3:,Supplier,Expense Description,Amount^M | |
| october_2009.csv:4:,Supplier,Expense Description,Amount,Doc Type,Doc No,Date^M | |
| P12- 2009_10_FINAL.csv:4:Vendor,Expense Description,Amount,,,^M | |
| P13-2009-10.csv:4:Vendor,Expense Description,Amount^M | |
| september_2008.csv:4:,Supplier,Expense Description,Amount^M | |
| september_2009.csv:4:,Supplier,Expense Description,Amount,Doc Type,Doc No,Date^M | |
| # Not found | |
| 2012-13-P8-250.csv |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment