Baselight

Farm Census District Electoral Area 2015

OpenDataNI

@ukgov.farm_census_district_electoral_area_20155

Table 1
@ukgov.farm_census_district_electoral_area_20155.table_1

  • 36.97 KB
  • 80 rows
  • 30 columns
objectid

OBJECTID

finalr_dea

FinalR DEA

objectid_1

OBJECTID.1

id

Id

dea_code

DEA Code

dea_name

DEA Name

year

Year

number_of_farms

Number Of Farms

number_of_lfa_farms

Number Of Lfa Farms

num_of_non_lfa_farms

Num Of Non Lfa Farms

total_area_farmed_in_hectares

Total Area Farmed In Hectares

average_so_farm_000

Average SO/farm ('000)

total_crops_in_hectares

Total Crops In Hectares

total_grass_rough_grazing_in_hectares

Total Grass & Rough Grazing In Hectares

total_number_of_cattle

Total Number Of Cattle

total_number_of_sheep

Total Number Of Sheep

total_number_of_pigs

Total Number Of Pigs

total_number_of_poultry_000

Total Number Of Poultry ('000)

number_of_farmers

Number Of Farmers

no_of_self_employed

No Of Self Employed

no_of_spouses

No Of Spouses

no_of_other_workers

No Of Other Workers

total_number_of_agricultural_labour

Total Number Of Agricultural Labour

number_of_v_small_farms

Number Of V.Small Farms

number_of_small_farms

Number Of Small Farms

number_of_medium_farms

Number Of Medium Farms

number_of_large_farms

Number Of Large Farms

globalid

GlobalID

shape_area

Shape, Area

shape_length

Shape, Length

1Airport11N10000101Airport201528910818116663101690156092885922126218723835321999187639196431832d440f718-b40a-4e2a-9a72-2e0c9a7bed18293708362.289413100747.572398369
2Antrim22N10000102Antrim201594513510222112178233336810313147113c1bfa7b-2b1c-4e23-acc1-fcb53f3e886123495232.910644524180.8615673707
3Ards Peninsula374N10001101Ards Peninsula201536610356173531112652142564016018549154101134692901243159082394415689a2622ac-60a5-4d89-8e51-f743c248d633270692906.758698118287.00466761
4Armagh48N10000201Armagh20157863913952217411399520952542481966299251820948492176760188459898325806b624d8-a7c6-400e-a497-4639b80103da277192347.830315114854.790239755
5Ballyarnett532N10000501Ballyarnett201512488381302155976011253139362281339da9b1c-ef1c-4ea9-a8a9-a5e59879c15c19365521.760139527647.5647510068
6Ballyclare63N10000103Ballyclare20151507872617413122459151329811278420820189112447630910222818115ea217-79b7-4db9-814d-9b65036ca03c77944818.983093352996.5527933484
7Ballymena753N10000801Ballymena20151129239852021537134127136417101493aeee7-86b9-43f0-b4de-3d266685960a13292174.241195722321.0261474089
8Ballymoney825N10000401Ballymoney2015411210201183091427081726833381326631306880751530511320583327661324258fc8c5c-ec8b-4bb4-9060-55d4011ccbd8234619368.682755100204.834298914
9Balmoral915N10000301Balmoral2015333333333333333333337ae6172d-0c36-464b-b4eb-4b60ec74f6bf16149325.979011523421.2176129363
10Banbridge109N10000202Banbridge20155453351218758764276415784407933263795621326923851642391095403662848b6109484-6fcf-43d0-ad2a-7cf7d5367d03231042388.829819113443.433571892

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "finalr_dea" VARCHAR,
  "objectid_1" BIGINT,
  "id" BIGINT,
  "dea_code" VARCHAR,
  "dea_name" VARCHAR,
  "year" BIGINT,
  "number_of_farms" BIGINT,
  "number_of_lfa_farms" BIGINT,
  "num_of_non_lfa_farms" BIGINT,
  "total_area_farmed_in_hectares" BIGINT,
  "average_so_farm_000" BIGINT,
  "total_crops_in_hectares" BIGINT,
  "total_grass_rough_grazing_in_hectares" BIGINT,
  "total_number_of_cattle" BIGINT,
  "total_number_of_sheep" BIGINT,
  "total_number_of_pigs" BIGINT,
  "total_number_of_poultry_000" BIGINT,
  "number_of_farmers" BIGINT,
  "no_of_self_employed" BIGINT,
  "no_of_spouses" BIGINT,
  "no_of_other_workers" BIGINT,
  "total_number_of_agricultural_labour" BIGINT,
  "number_of_v_small_farms" BIGINT,
  "number_of_small_farms" BIGINT,
  "number_of_medium_farms" BIGINT,
  "number_of_large_farms" BIGINT,
  "globalid" VARCHAR,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE
);

Share link

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