{ |
{ |
"dataset":{ |
"dataset": { |
"name":"australian_federal_government_contract_spending", |
"languages": [ |
"label":"Australian Federal Government Contract Spending", |
"en" |
"description":"Spending by Australian Federal Government agencies on goods and services from 2007 onwards.", |
], |
"currency":"AUD", |
"currency": "AUD", |
"unique_keys":[ |
"name": "australian_federal_government_contract_spending", |
"id" |
"territories": [], |
], |
"default_time": null, |
"temporal_granularity":"year" |
"description": "Spending by Australian Federal Government agencies on goods and services from 2007 onwards.", |
}, |
"schema_version": "2011-12-07", |
"mapping":{ |
"label": "Australian Federal Government Contract Spending" |
"category": { |
|
"fields": [ { |
|
"column": "category", |
|
"datatype": "string", |
|
"name": "label" |
|
} ], |
|
|
|
"type": "classifier", |
|
"description": "", |
|
"taxonomy": "unspsc", |
|
"label": "Contract Goods/Services Category" |
|
}, |
}, |
"from":{ |
"mapping": { |
"fields":[ |
"category": { |
{ |
"description": "Contract Goods/Services Category", |
"column":"agencyABN", |
"datatype": "string", |
"datatype":"string", |
"label": "category", |
"name":"id" |
"column": "cat1", |
}, |
"type": "attribute", |
{ |
"dimension": "category" |
"column":"agencyName", |
}, |
"datatype":"string", |
"sourceurl": { |
"name":"label" |
"description": "Source Document URL", |
} |
"datatype": "string", |
], |
"label": "sourceurl", |
"type":"entity", |
"column": "sourceurl", |
"description":"", |
"type": "attribute", |
"label":"Government Agency Australian Business Number" |
"dimension": "sourceurl" |
}, |
}, |
"description":{ |
"from": { |
"column":"description", |
"attributes": { |
"datatype":"string", |
"name": { |
"type":"value", |
"column": "agencyABN", |
"description":"Contract as described by agency", |
"datatype": "id", |
"label":"Contract Description" |
"type": "id", |
}, |
"description": null |
"to":{ |
}, |
"fields":[ |
"label": { |
{ |
"column": "agencyName", |
"column":"supplierName", |
"datatype": "string", |
"datatype":"string", |
"type": "attribute", |
"name":"label" |
"description": null |
}, |
} |
{ |
}, |
"column":"supplierID", |
"label": "Government Agency", |
"datatype":"string", |
"type": "compound", |
"name":"id" |
"dimension": "from", |
} |
"description": "Government Agency" |
], |
}, |
"type":"entity", |
"description": { |
"description":"Government Supplier", |
"description": null, |
"label":"Supplier Name" |
"datatype": "string", |
}, |
"label": "description", |
"currency":{ |
"column": "description", |
"default_value":"AUD", |
"type": "attribute", |
"description":"All entries in AUD, foreign transactions are converted at the time of their payment", |
"dimension": "description" |
"column":"", |
}, |
"label":"", |
"publishdate": { |
"datatype":"currency", |
"description": null, |
"type":"value" |
"format": null, |
}, |
"datatype": "date", |
"amount":{ |
"label": "publishDate", |
"column":"value", |
"column": "publishDate", |
"datatype":"float", |
"type": "date", |
"type":"value", |
"dimension": "publishdate" |
"description":"The total value of the contract including all variations/amendments/extensions", |
}, |
"label":"Contract Value" |
"to": { |
}, |
"attributes": { |
"time":{ |
"name": { |
"column":"contractStart", |
"column": "supplierid", |
"datatype":"date", |
"datatype": "id", |
"type":"value", |
"type": "id" |
"description":"Start of the contract period (goods or services being received)", |
}, |
"label":"Contract Start Date" |
"label": { |
}, |
"column": "supplierName", |
"id":{ |
"datatype": "string", |
"column": "CNID", |
"type": "attribute" |
"datatype": "string", |
} |
"name": "label", |
}, |
"type": "value", |
"label": "Supplier Name", |
"description": "", |
"type": "compound", |
"label": "Contract Notice ID" |
"dimension": "to", |
} |
"description": "Government Supplier" |
}, |
}, |
|
"amount": { |
"views": [ |
"description": "The total value of the contract including all variations/amendments/extensions", |
|
"datatype": "float", |
|
"label": "value", |
|
"column": "value", |
|
"type": "measure", |
|
"dimension": "amount" |
|
}, |
|
"cnid": { |
|
"description": "Contract Notice ID", |
|
"datatype": "string", |
|
"label": "CNID", |
|
"column": "CNID", |
|
"key": true, |
|
"type": "attribute", |
|
"dimension": "cnid" |
|
}, |
|
"contractend": { |
|
"description": "End of the contract period (goods or services being received)", |
|
"format": null, |
|
"datatype": "date", |
|
"label": "contractEnd", |
|
"column": "contractEnd", |
|
"type": "date", |
|
"dimension": "contractend" |
|
}, |
|
"time": { |
|
"description": "Start of the contract period (goods or services being received)", |
|
"format": null, |
|
"datatype": "date", |
|
"label": "contractStart", |
|
"column": "contractStart", |
|
"type": "date", |
|
"dimension": "time" |
|
} |
|
}, |
|
"views": [ |
{ |
{ |
"name": "default", |
"name": "default", |
"entity": "dataset", |
"label": "Breakdown by Category", |
"label": "Default breakdown by Category", |
"cuts": {}, |
"dimension": "dataset", |
"drilldown": "category", |
"breakdown": "category", |
"entity": "dataset", |
"filters" : {"name": "australian_federal_government_contract_spending" } |
"dimension": "dataset" |
}, |
}, |
{ |
{ |
"name":"default", |
"name": "by_supplier", |
"entity": "classifier", |
"label": "Breakdown by Supplier", |
"label":"Breakdown of Spending Areas by Supplier Company", |
"cuts": {}, |
"dimension": "category", |
"drilldown": "to", |
"breakdown": "to", |
"entity": "dataset", |
"filters": {"taxonomy": "unspsc"} |
"dimension": "dataset" |
}, |
}, |
{ |
{ |
"name":"default", |
"name": "by_agency", |
"entity": "classifier", |
"label": "Breakdown by Agency", |
"label":"Breakdown of Spending Areas by Government Agency", |
"cuts": {}, |
"dimension": "category", |
"drilldown": "from", |
"breakdown": "from", |
"entity": "dataset", |
"filters": {"taxonomy": "unspsc"} |
"dimension": "dataset" |
} |
}, |
] |
{ |
|
"name": "default", |
|
"label": "Agency spending breakdown by supplier", |
|
"cuts": {}, |
|
"drilldown": "to", |
|
"entity": "dimension", |
|
"dimension": "from" |
|
}, |
|
{ |
|
"name": "default", |
|
"label": "Supplier contracts breakdown by procuring agency", |
|
"cuts": {}, |
|
"drilldown": "from", |
|
"entity": "dimension", |
|
"dimension": "to" |
|
} |
|
] |
} |
} |
|
|