http://www.ons.gov.uk/about-statistics/geography/products/index.html
Hi Haiyan,
The ONS website includes a lot of geographical lookups, the SNAC
(Standard Names and Codes) database may give you what you want,
Best wishes,
Lesley
-----Original Message-----
From: A UK-based worldwide e-mail broadcast system mailing list
[mailto:[log in to unmask]] On Behalf Of haiyan gao
Sent: 28 October 2010 10:55
To: [log in to unmask]
Subject: Re: Mapping the old PCT code in 2005 to new PCT code
Dear Andre,
Many thanks. I am looking at the 2005/06 HES patient level data, and I
only need the mapping from Super Output Area codes to the new PCT codes.
I found the mapping from the old PCT to the new PCT in NHS IC website,
but it is not what I want. Is it possible to send me the file containing
the Super Output Area code and the new PCT code, please? Or let me know
the website for the mapping.
Best wishes,
Haiyan
> Date: Wed, 27 Oct 2010 23:48:26 +0100
> From: [log in to unmask]
> Subject: Re: Mapping the old PCT code in 2005 to new PCT code
> To: [log in to unmask]
>
> What you need is two versions of the NHS Postcode file ... the latest
and
> one from, say, 2005. Each one of these maps postcodes to SOAs to PCTs.
The
> 2005 version will have the older PCT codes. Linking these two files
using a
> relational database (Access or SQL Server) should give you what you
want.
> The ONS website has the NHS postcode files.
>
> I hope this helps.
>
> Andre Francis
>
> On 27 October 2010 23:17, haiyan gao <[log in to unmask]> wrote:
>
> > Dear all,
> >
> >
> > Does anyone has the mapping code from the Super output
> > area (oacode in HES) to the new code with 152 PCT, or known where to
find
> > it?
> >
> >
> > Many thanks for your help,
> >
> > Haiyan
> >
> >
> > You may leave the list at any time by sending the command
> >
> > SIGNOFF allstat
> >
> > to [log in to unmask], leaving the subject line blank.
> >
>
> You may leave the list at any time by sending the command
>
> SIGNOFF allstat
>
> to [log in to unmask], leaving the subject line blank.
You may leave the list at any time by sending the command
SIGNOFF allstat
to [log in to unmask], leaving the subject line blank.
Visit the Milton Keynes Council web site at http://www.milton-keynes.gov.uk
Please consider the environment and don't print this email unless you really need to
**** This email and any attachments hereto are strictly confidential and intended solely for the addressee. It may contain information which is privileged. If you are not the intended addressee, you must not disclose, forward, copy or take any action in reliance of this email or attachments. If you have received this email in error, please delete it and notify us as soon as possible.
The anti-virus software used by Milton Keynes Council is updated regularly in an effort to minimise the possibility of viruses infecting our systems. However, you should be aware that there is no absolute guarantee that any files attached to this email are virus free.****
You may leave the list at any time by sending the command
SIGNOFF allstat
to [log in to unmask], leaving the subject line blank.
|