Non Dairy Cattle Population By Breed, Sex And County On 1 January 2013

CREATE TABLE non_dairy_cattle_population_by_breed_sex_and_county_on_5086d8ed (
  "breed" VARCHAR,
  "sex" VARCHAR,
  "devon" BIGINT,
  "cumbria" BIGINT,
  "north_yorkshire" BIGINT,
  "dyfed" BIGINT,
  "aberdeen" BIGINT,
  "cornwall" BIGINT,
  "powys" BIGINT,
  "somerset" BIGINT,
  "hereford_worcester" BIGINT,
  "northumberland" BIGINT,
  "shropshire" BIGINT,
  "gwynedd" BIGINT,
  "ayr" BIGINT,
  "dumfries" BIGINT,
  "derbyshire" BIGINT,
  "staffordshire" BIGINT,
  "clwyd" BIGINT,
  "kirkcudbright" BIGINT,
  "wigtown" BIGINT,
  "wiltshire" BIGINT,
  "lancashire" BIGINT,
  "durham" BIGINT,
  "leicestershire" BIGINT,
  "gloucestershire" BIGINT,
  "orkney" BIGINT,
  "lincolnshire" BIGINT,
  "dorset" BIGINT,
  "lanark" BIGINT,
  "cheshire" BIGINT,
  "perth" BIGINT,
  "norfolk" BIGINT,
  "banff" BIGINT,
  "oxfordshire" BIGINT,
  "northamptonshire" BIGINT,
  "buckinghamshire" BIGINT,
  "humberside" BIGINT,
  "berwick" BIGINT,
  "hampshire" BIGINT,
  "avon" BIGINT,
  "roxburgh" BIGINT,
  "west_yorkshire" BIGINT,
  "caithness" BIGINT,
  "warwickshire" BIGINT,
  "gwent" BIGINT,
  "fife" BIGINT,
  "argyll" BIGINT,
  "angus" BIGINT,
  "kincardine" BIGINT,
  "kent" BIGINT,
  "nottinghamshire" BIGINT,
  "inverness" BIGINT,
  "east_sussex" BIGINT,
  "stirling" BIGINT,
  "suffolk" BIGINT,
  "ross_and_cromarty" BIGINT,
  "west_sussex" BIGINT,
  "moray" BIGINT,
  "cambridgeshire" BIGINT,
  "south_yorkshire" BIGINT,
  "mid_lothian" BIGINT,
  "essex" BIGINT,
  "renfrew" BIGINT,
  "west_glamorgan" BIGINT,
  "surrey" BIGINT,
  "mid_glamorgan" BIGINT,
  "berkshire" BIGINT,
  "east_lothian" BIGINT,
  "greater_manchester" BIGINT,
  "peebles" BIGINT,
  "west_lothian" BIGINT,
  "south_glamorgan" BIGINT,
  "cleveland" BIGINT,
  "hertfordshire" BIGINT,
  "bedfordshire" BIGINT,
  "bute" BIGINT,
  "selkirk" BIGINT,
  "isle_of_wight" BIGINT,
  "dunbarton" BIGINT,
  "sutherland" BIGINT,
  "nairn" BIGINT,
  "tyne_wear" BIGINT,
  "kinross" BIGINT,
  "west_midlands" BIGINT,
  "shetland" BIGINT,
  "merseyside" BIGINT,
  "clackmannan" BIGINT,
  "greater_london" BIGINT,
  "scilly_isles" BIGINT
);