This dataset is the yield of the Developer contributions pipeline. The pipeline has been configured to collect, process and yield data that matches the Contribution funding status schema.
Map resource column name to dataset field
Showing 5 column rules
| Dataset | Column | Endpoint | Field | Resource | Entry date | Start date | End date |
|---|---|---|---|---|---|---|---|
| developer-agreement | Developer-Agreement | reference | |||||
| developer-agreement | Developer Agreement | reference | |||||
| developer-agreement | Organisation | organisation | |||||
| developer-agreement | Created | entry-date | |||||
| developer-agreement | Start Date | start-date |
Combine a series of facts from multiple entries
Concatenate fields during the harmonise phase
Convert a resource
Take a missing field default value from another field
provide a default value for a missing or empty field
Filter entries
Lookup entities
Showing 5 lookup rules
| Dataset | Endpoint | Entity | Entry number | Organisation | CURIE prefix | Reference | Resource | Value | Entry date | Start date | End date |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 4306214 | local-authority-eng:SND | developer-agreement-contribution | 16/02356/LR4-S2.A.2.2 | ||||||||
| 4306215 | local-authority-eng:SND | developer-agreement-contribution | 16/02356/LR4-S2.A.2.3 | ||||||||
| 4306216 | local-authority-eng:SND | developer-agreement-contribution | 16/02356/LR4-S2.B.2.1 | ||||||||
| 4306217 | local-authority-eng:SND | developer-agreement-contribution | 16/02356/LR4-S2.B.2.2 | ||||||||
| 4306218 | local-authority-eng:SND | developer-agreement-contribution | 16/02356/LR4-S2.B.2.3 |
Assert a field value during harmonise
Showing 5 patch rules
| Dataset | Endpoint | Entry number | Field | Pattern | Resource | Value | Entry date | Start date | End date |
|---|---|---|---|---|---|---|---|---|---|
| developer-agreement-contribution | organisation | SLF | local-authority-eng:SLF | ||||||
| developer-agreement-contribution | organisation | TBMC | local-authority-eng:TON | ||||||
| developer-agreement-contribution | contribution-purpose | Affordable-housing | affordable-housing | ||||||
| developer-agreement-contribution | contribution-purpose | Affordable Housing | affordable-housing | ||||||
| developer-agreement-contribution | contribution-purpose | Affordable Housing - Financial Contribution | affordable-housing |
Remove lines from a resource during normalise
Showing 5 skip rules
| Dataset | Endpoint | Entry number | Pattern | Resource | Entry date | Start date | End date |
|---|---|---|---|---|---|---|---|
| developer-agreement | ^Developer Agreements,,,,,,,, | ||||||
| developer-agreement-contribution | ^developer agreement contributions,developer agreement contributions,,,,,,, | ||||||
| developer-agreement-contribution | ^Developer Agreement Contribution,,See Page 16 and 17,,,,, | ||||||
| developer-agreement-contribution | ^,From CSV 1,See List,as at 31/03/2020,,today,, | ||||||
| developer-agreement | ^,*[^,]*,*$ |
None
Showing 1 source.
See table of all sources for Contribution funding status dataset.