Popular Forenames
Dear Department for Education,
Could you please provide me with a lists of the most popular forename and surnames based on the latest school census data - can you provide this as two separate CSV files or separate Excel worksheets, one for forenames and another for surnames. Can this also include count as well.
For example:
SELECT TOP 1000
[forename] as Forename
,count([forename]) as Forename_Count
FROM
[person]
GROUP BY
[forename]
ORDER BY
count([forename]) desc
Yours faithfully,
Matt Smith
Dear Mr Smith
Thank you for your recent enquiry. A reply will be sent to you as soon as
possible. For information; the departmental standard for correspondence
received is that responses should be sent within 20 working days as you
are requesting information under the Freedom of Information Act 2000. Your
correspondence has been allocated reference number 2015-0017407.
Thank you
Department for Education
Ministerial and Public Communications Division
Tel: 0370 000 2288
Communications via the GSi may be automatically logged, monitored and/or
recorded for legal purposes.
Dear Department for Education,
Could you please chase this as it is now over due.
Yours faithfully,
Matt Smith
Dear Mr Smith,
RE: Freedom of Information request – Top 1000 popular Surnames and Forenames
Thank you for your request for information, which was received on 7 April 2015. You
requested:
Could you please provide me with a list of the most popular forename and surnames based on
the latest school census data - can you provide this as two separate CSV files or separate
Excel worksheets, one for forenames and another for surnames. Can this also include count as
well?
For example:
SELECT TOP 1000
[forename] as Forename
,count([forename]) as Forename_Count
FROM
[person]
GROUP BY
[forename]
ORDER BY
count([forename]) desc
SELECT TOP 1000
[forename] as Forename
,count([forename]) as Forename_Count
FROM
[person]
GROUP BY
[forename]
ORDER BY
count([forename]) desc
I have dealt with your request under the Freedom of Information Act 2000.
I have attached an Excel spreadsheet which contains two worksheets as requested, separated
by Surname and the count and Forename and the count. This information was taken from the
Autumn School Census 2014.
The information supplied to you continues to be protected by copyright. You are free to use
it for your own purposes, including for private study and non-commercial research, and for
any other purpose authorised by an exception in current copyright law. Documents (except
photographs) can be also used in the UK without requiring permission for the purposes of
news reporting. Any other re-use, for example commercial publication, would require the
permission of the copyright holder.
Most documents produced by a government department or agency [Name of department or agency]
will be protected by Crown Copyright. Most Crown copyright information can be re-used under
the Open Government Licence
([1]http://www.nationalarchives.gov.uk/doc/o...). For information about
the OGL and about re-using Crown Copyright information please see The National Archives
website
-[2]http://www.nationalarchives.gov.uk/infor...
.
Copyright in other documents may rest with a third party. For information about obtaining
permission from a third party see the Intellectual Property Office’s website at
[3]www.ipo.gov.uk.
If you have any queries about this letter, please contact me. Please remember to quote the
reference number above in any future communications.
If you are unhappy with the way your request has been handled, you should make a complaint
to the Department by writing to me within two calendar months of the date of this letter.
Your complaint will be considered by an independent review panel, who were not involved in
the original consideration of your request.
If you are not content with the outcome of your complaint to the Department, you may then
contact the Information Commissioner’s Office.
Yours sincerely
Melanie Armstrong
Data Development Unit (DDU)
Education Data Division
[4][email address][5]www.education.gov.uk
Communications via the GSi may be automatically logged, monitored and/or
recorded for legal purposes.
References
Visible links
1. http://www.nationalarchives.gov.uk/doc/o...
blocked::http://www.nationalarchives.gov.uk/doc/o...
http://www.nationalarchives.gov.uk/doc/o...
2. http://www.nationalarchives.gov.uk/infor...
blocked::http://www.nationalarchives.gov.uk/infor...
http://www.nationalarchives.gov.uk/infor...
3. http://www.ipo.gov.uk/
blocked::http://www.ipo.gov.uk/
http://www.ipo.gov.uk/
4. mailto:[email address]
5. http://www.education.gov.uk/
We work to defend the right to FOI for everyone
Help us protect your right to hold public authorities to account. Donate and support our work.
Donate Now