ecr: 1
This data as json
| rowid | customer_name | customer_site | address_line_1 | address_line_2 | city | county | postcode | gsp | bsp | primary | voltage | licence | energy_source | connection_status | connected_export | date_connected | accepted_export | accepted_import | date_accepted | longitude | latitude | source | gsp_location | bsp_location | primary_location | ecr_project_id | primary_substation_type_id | bsp_substation_type_id | gsp_substation_type_id | country |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | ren power investments uk limited | pv solar (carlton farm) | yarmouth road | 0 | north walsham | norfolk | nr28 9na | norwich main | thorpe grid 33kv | north walsham primary 11kv | 11.0 | epn | solar | connected | 5.789 | 2011-09-29 | 0.0 | 0.0 | 0 | 1.39296861947493 | 52.8042313539648 | ukpn | norwich | thorpe | north walsham | ukpn_epn_ecr_project_0 | ukpn_epn_primary_north_walsham | ukpn_epn_bsp_thorpe | ukpn_epn_gsp_norwich | 0 |