Environment Agency says Yorkshire saw its fifth driest period on record between April and September.