Thu Apr 16 17:32:42 2009 /* suite of sql scripts which give rough analyis of data in the University Card database */ /* it is the best indicator we have for the composition of the collegiate university */ /* as it include all sorts of people who may no be represented in other data sources eg payroll or student records*/ /* total current card records*/ +-------------+ |col1 | +-------------+ | 40208| +-------------+ (1 row) /* by card category*/ +------------+-------------+ |status |total | +------------+-------------+ |undergrad | 12058| |postgrad | 8792| |staff | 7103| |senmem | 4020| |college | 2729| |dept | 1607| |visitor | 1539| |ret | 930| |cardholder | 710| |student | 491| |virtual | 229| +------------+-------------+ (11 rows) /* total people per division - exclude colleges */ +--------------------------------------------------+-------------+ |division_name |total | +--------------------------------------------------+-------------+ |Medical Sciences | 6686| |Social Sciences | 5390| |Maths, Physical & Life Sciences | 4697| |Humanities | 3341| |University Administration and Services | 1665| |Academic Services | 1443| |Continuing Education | 1412| |Council Departments | 112| |Paying Etc | 97| |Other Related Bodies | 75| +--------------------------------------------------+-------------+ (10 rows) /* undergrads by OSS division of their course- taken from OSS*/ +--------------------------------------------------+-------------+ |division_name |total | +--------------------------------------------------+-------------+ |Humanities | 4220| |Maths, Physical & Life Sciences | 3503| |Social Sciences | 2180| |Medical Sciences | 1634| +--------------------------------------------------+-------------+ (4 rows) /* by status*/ +--------------------------------------------------+------------+-------------+ |division_name |status |total | +--------------------------------------------------+------------+-------------+ |Academic Services |staff | 1033| |Academic Services |senmem | 154| |Academic Services |ret | 140| |Academic Services |dept | 91| |Academic Services |cardholder | 13| |Academic Services |virtual | 5| |Academic Services |visitor | 5| |Academic Services |college | 2| |Continuing Education |postgrad | 718| |Continuing Education |undergrad | 458| |Continuing Education |staff | 117| |Continuing Education |dept | 56| |Continuing Education |senmem | 31| |Continuing Education |virtual | 18| |Continuing Education |ret | 7| |Continuing Education |visitor | 5| |Continuing Education |cardholder | 1| |Continuing Education |college | 1| |Council Departments |staff | 94| |Council Departments |dept | 10| |Council Departments |ret | 5| |Council Departments |senmem | 2| |Council Departments |college | 1| |Humanities |postgrad | 1683| |Humanities |senmem | 1020| |Humanities |staff | 240| |Humanities |visitor | 212| |Humanities |ret | 73| |Humanities |dept | 51| |Humanities |cardholder | 26| |Humanities |college | 20| |Humanities |virtual | 16| |Maths, Physical & Life Sciences |postgrad | 1915| |Maths, Physical & Life Sciences |staff | 1287| |Maths, Physical & Life Sciences |senmem | 730| |Maths, Physical & Life Sciences |visitor | 278| |Maths, Physical & Life Sciences |dept | 201| |Maths, Physical & Life Sciences |ret | 192| |Maths, Physical & Life Sciences |cardholder | 50| |Maths, Physical & Life Sciences |virtual | 34| |Maths, Physical & Life Sciences |college | 10| |Medical Sciences |staff | 2482| |Medical Sciences |postgrad | 1223| |Medical Sciences |senmem | 988| |Medical Sciences |dept | 746| |Medical Sciences |undergrad | 516| |Medical Sciences |visitor | 406| |Medical Sciences |cardholder | 135| |Medical Sciences |ret | 127| |Medical Sciences |virtual | 57| |Medical Sciences |college | 6| |Other Related Bodies |staff | 64| |Other Related Bodies |cardholder | 4| |Other Related Bodies |dept | 3| |Other Related Bodies |visitor | 2| |Other Related Bodies |ret | 1| |Other Related Bodies |senmem | 1| |Paying Etc |dept | 90| |Paying Etc |senmem | 7| |Social Sciences |postgrad | 3253| |Social Sciences |staff | 727| |Social Sciences |senmem | 659| |Social Sciences |visitor | 329| |Social Sciences |dept | 184| |Social Sciences |cardholder | 71| |Social Sciences |ret | 66| |Social Sciences |undergrad | 62| |Social Sciences |virtual | 26| |Social Sciences |college | 13| |University Administration and Services |staff | 1023| |University Administration and Services |senmem | 259| |University Administration and Services |dept | 175| |University Administration and Services |cardholder | 110| |University Administration and Services |ret | 90| |University Administration and Services |virtual | 5| |University Administration and Services |visitor | 3| +--------------------------------------------------+------------+-------------+ (76 rows) /* number per dept in card */ +--------------------------------------------------+-------------+ |nickname |tot | +--------------------------------------------------+-------------+ |Continuing Education | 1412| |Said Business School | 945| |University Offices | 921| |History | 741| |Clinical Medicine | 668| |Engineering Science | 667| |Politics | 611| |Law | 569| |Education | 549| |Physiology and Anatomy | 543| |Medical School Offices | 516| |Environment | 496| |Biochemistry | 474| |Maths | 472| |Oriental Institute | 458| |Zoology | 437| |English | 425| |Chemistry | 406| |Modern Languages | 389| |Computing Lab. | 383| |Queen Elizabeth House | 375| |Classics | 369| |Economics | 357| |Experimental Psychology | 344| |Pathology | 343| |Bodleian Library | 343| |Theology | 331| |Physics | 319| |Materials | 309| |Public Health | 301| |Philosophy | 292| |Anthropology | 292| |Molecular Medicine | 288| |Psychiatry | 273| |Pharmacology | 228| |Wellcome Genetics | 211| |Ashmolean Museum | 206| |Inorganic Chemistry | 205| |Estates Directorate | 202| |Particle Physics | 200| |Physical/Theoretical Chemistry | 199| |Archaeology | 195| |Clinical Neurology | 193| |Surgery | 193| |Clinical Trial Service | 192| |Social Policy and Social Work | 189| |Plant Sciences | 187| |Computing Services | 184| |NDORMS | 181| |Earth Sciences | 177| |University Libraries | 172| |Clin. Lab. Sciences | 160| |Statistics | 155| |Radiation Oncology | 154| |Cardiovascular Medicine | 151| |Sociology | 147| |Medical Sciences | 135| |Medical Sciences Division | 135| |Obstetrics/Gynaecology | 126| |Music | 119| |Doctoral Training | 118| |Astrophysics | 117| |Paediatrics | 116| |Said Business School Ltd | 115| |Area Studies | 114| |Biomedical Services | 113| |Finance | 107| |Clinical Pharmacology | 105| |OCDEM | 98| |Anaesthetics | 94| |Medical Oncology | 93| |Development Office | 92| |OUP | 84| |Theoretical Physics | 84| |Structural Genomics | 83| |Sport | 78| |Perinatal Epidemiology | 75| |Condensed Physics | 72| |Archaeology Research | 70| |Linguistics Philology | 70| |Pitt Rivers | 67| |Atomic Physics | 65| |University Museum | 63| |Atmospheric Physics | 63| |Internet Institute | 62| |Ophthalmology | 58| |Radcliffe Science Library | 58| |Isis Innovation | 58| |African Studies | 52| |Careers Service | 48| |Examination Schools | 46| |Latin American Centre | 43| |Jenner Institute | 42| |E-Research | 38| |Ruskin School | 34| |Socio-Legal Studies | 34| |Law Library | 32| |Library Systems | 31| |Taylor Inst. Library | 29| |Health Care Libraries | 29| |Language Centre | 29| |Learning Institute | 28| |ICT Support Team | 28| |Smith School | 28| |Botanic Garden | 28| |University Club | 27| |Med Sci DTC | 27| |Nissan Institute | 26| |COMPAS | 23| |Sackler Library | 22| |History of Science | 22| |Criminology | 22| |Counselling Service | 22| |Rothermere Institute | 21| |Veterinary Services | 20| |Ludwig Institute | 20| |Ageing | 20| |Voltaire Foundation | 20| |Social Science Library | 19| |Childhood Cancer Research | 18| |History of Medicine | 18| |Safety Office | 17| |Statistical Medicine | 17| |IMSU | 17| |Begbroke | 17| |Student Union | 14| |Chinese Studies | 14| |Rhodes House | 13| |Humanities Division | 13| |Tropical Medicine | 13| |European/Comparative Law | 13| |Oxford Man | 13| |Proctors' Office | 12| |Occupational Health Service | 12| |Phonetics | 11| |Environmental Change | 11| |Alumni | 10| |21 School | 10| |History of Art | 10| |History Library | 10| |Human Sciences | 9| |SBS Library | 8| |Social Sciences Division | 8| |Maths Physics Life Division | 7| |Sheldonian Theatre | 7| |Plant Sciences Library | 6| |EHRC | 6| |Philosophy Library | 6| |English Library | 5| |Cont Ed Library | 5| |Oriental Library | 5| |University Archives | 5| |Music Library | 4| |Chinese Library | 4| |Japanese Library | 4| |Theology Library | 4| |Education Library | 4| |Harmsworth Library | 3| |Zoology Library | 3| |Refugee Library | 3| |Indian Institute Library | 3| |OSEM | 3| |Research Institute | 2| |Director of IT | 2| |Brazilian Studies | 2| |Exp Psychology Library | 1| |Metabolic Research | 1| |Latin American Library | 1| +--------------------------------------------------+-------------+ (168 rows) * * * * * /* number per college in card */ +--------------------------------------------------+-------------+ |nickname |tot | +--------------------------------------------------+-------------+ |Wolfson | 1091| |Balliol | 931| |Christ Church | 927| |St Catherine's | 916| |New | 900| |Magdalen | 884| |Wadham | 847| |St John's | 847| |St Anne's | 842| |Keble | 839| |St Hugh's | 796| |Lady Margaret Hall | 778| |St Edmund Hall | 773| |Merton | 765| |Worcester | 757| |Exeter | 756| |Hertford | 749| |Green Templeton | 729| |Brasenose | 721| |University | 716| |Lincoln | 708| |Jesus | 703| |St Hilda's | 695| |St Antony's | 693| |Pembroke | 670| |Linacre | 628| |Oriel | 622| |Somerville | 620| |St Peter's | 611| |Queen's | 608| |St Cross | 564| |Kellogg | 547| |Trinity | 529| |Corpus Christi | 502| |Mansfield | 454| |Harris Manchester | 304| |Nuffield | 298| |Regent's Park | 247| |Wycliffe Hall | 188| |All Souls | 137| |St Benet's Hall | 75| |St Stephen's House | 67| |Ripon | 66| |Blackfriars | 64| |Campion Hall | 33| |Green | 8| |Templeton | 1| +--------------------------------------------------+-------------+ (47 rows) Thu Apr 16 17:32:42 2009