As of 18th Jan 2010 /* 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 | +-----+ |41215| +-----+ (1 row) /* by card category*/ /* ** card STATUS 'college' will generally not appear in in any other stats as they wont have a dept */ +----------+-----+ |status |total| +----------+-----+ |undergrad |12150| |postgrad | 9121| |staff | 7154| |senmem | 4115| |college | 2898|** |dept | 1698| |visitor | 1627| |ret | 1061| |cardholder| 698| |student | 508| |virtual | 185| +----------+-----+ (11 rows) /* total people per division - exclude colleges */ +--------------------------------------+-----+ |division_name |total| +--------------------------------------+-----+ |Medical Sciences | 6948| |Social Sciences | 5467| |Maths, Physical & Life Sciences | 4857| |Humanities | 3518| |University Administration and Services| 1582| |Academic Services | 1532| |Continuing Education | 1466| |not on tree | 100| |Council Departments | 96| |Societies, Other & Companies | 80| +--------------------------------------+-----+ (10 rows) /* undergrads by OSS division of their course- taken from OSS*/ +-------------------------------+-----+ |division_name |total| +-------------------------------+-----+ |Humanities | 4221| |Maths, Physical & Life Sciences| 3573| |Social Sciences | 2182| |Medical Sciences | 1675| +-------------------------------+-----+ (4 rows) /* by status*/ +--------------------------------------+----------+-----+ |division_name |status |total| +--------------------------------------+----------+-----+ |Academic Services |staff | 1100| |Academic Services |ret | 159| |Academic Services |senmem | 153| |Academic Services |dept | 93| |Academic Services |cardholder| 12| |Academic Services |visitor | 11| |Academic Services |virtual | 3| |Academic Services |college | 1| |Continuing Education |postgrad | 766| |Continuing Education |undergrad | 444| |Continuing Education |staff | 114| |Continuing Education |dept | 56| |Continuing Education |senmem | 31| |Continuing Education |virtual | 31| |Continuing Education |visitor | 11| |Continuing Education |ret | 10| |Continuing Education |cardholder| 2| |Continuing Education |college | 1| |Council Departments |staff | 75| |Council Departments |dept | 11| |Council Departments |ret | 7| |Council Departments |senmem | 2| |Council Departments |college | 1| |Humanities |postgrad | 1804| |Humanities |senmem | 1050| |Humanities |staff | 226| |Humanities |visitor | 212| |Humanities |ret | 90| |Humanities |dept | 67| |Humanities |college | 31| |Humanities |cardholder| 27| |Humanities |virtual | 11| |Maths, Physical & Life Sciences |postgrad | 2038| |Maths, Physical & Life Sciences |staff | 1283| |Maths, Physical & Life Sciences |senmem | 768| |Maths, Physical & Life Sciences |visitor | 308| |Maths, Physical & Life Sciences |ret | 198| |Maths, Physical & Life Sciences |dept | 180| |Maths, Physical & Life Sciences |cardholder| 46| |Maths, Physical & Life Sciences |virtual | 23| |Maths, Physical & Life Sciences |college | 13| |Medical Sciences |staff | 2634| |Medical Sciences |postgrad | 1238| |Medical Sciences |senmem | 1015| |Medical Sciences |dept | 836| |Medical Sciences |undergrad | 514| |Medical Sciences |visitor | 413| |Medical Sciences |ret | 138| |Medical Sciences |cardholder| 121| |Medical Sciences |virtual | 29| |Medical Sciences |college | 10| |Social Sciences |postgrad | 3275| |Social Sciences |staff | 734| |Social Sciences |senmem | 675| |Social Sciences |visitor | 361| |Social Sciences |dept | 184| |Social Sciences |ret | 72| |Social Sciences |cardholder| 67| |Social Sciences |undergrad | 54| |Social Sciences |virtual | 33| |Social Sciences |college | 12| |Societies, Other & Companies |staff | 63| |Societies, Other & Companies |dept | 10| |Societies, Other & Companies |visitor | 4| |Societies, Other & Companies |cardholder| 1| |Societies, Other & Companies |ret | 1| |Societies, Other & Companies |senmem | 1| |University Administration and Services|staff | 902| |University Administration and Services|senmem | 255| |University Administration and Services|dept | 169| |University Administration and Services|cardholder| 139| |University Administration and Services|ret | 112| |University Administration and Services|visitor | 3| |University Administration and Services|virtual | 2| |not on tree |dept | 92| |not on tree |senmem | 6| |not on tree |cardholder| 1| |not on tree |ret | 1| +--------------------------------------+----------+-----+ (78 rows) /* number per dept in card */ +------------------------------+----+ |nickname |tot | +------------------------------+----+ |Continuing Education |1466| |Said Business School | 978| |University Offices | 963| |History | 766| |Engineering Science | 678| |Clinical Medicine | 678| |Politics | 620| |Law | 581| |Education | 560| |Medical School Offices | 514| |Maths | 509| |Physiology and Anatomy | 503| |English | 474| |Environment | 470| |Biochemistry | 465| |Oriental Institute | 460| |Chemistry | 444| |Zoology | 433| |Modern Languages | 420| |Computing Lab. | 385| |Classics | 359| |Queen Elizabeth House | 354| |Economics | 354| |Physics | 347| |Theology | 339| |Bodleian Library | 338| |Pathology | 329| |Experimental Psychology | 327| |Materials | 326| |Public Health | 319| |Philosophy | 313| |Anthropology | 297| |Psychiatry | 278| |Molecular Medicine | 269| |Ashmolean Museum | 253| |Wellcome Genetics | 232| |Pharmacology | 223| |Estates Directorate | 210| |Clinical Neurology | 207| |Surgery | 206| |University Libraries | 204| |Inorganic Chemistry | 203| |Physical/Theoretical Chemistry| 201| |Archaeology | 201| |Plant Sciences | 196| |Clinical Trial Service | 193| |NDORMS | 191| |Computing Services | 190| |Social Policy and Social Work | 190| |Particle Physics | 190| |Earth Sciences | 173| |Clin. Lab. Sciences | 170| |Radiation Oncology | 167| |Statistics | 151| |Cardiovascular Medicine | 150| |Doctoral Training | 147| |Sociology | 144| |Music | 142| |Obstetrics/Gynaecology | 137| |Paediatrics | 130| |Said Business School Ltd | 126| |Medical Sciences Division | 122| |Area Studies | 121| |Astrophysics | 111| |OCDEM | 107| |Finance | 107| |Medical Sciences Office | 106| |Clinical Pharmacology | 104| |Biomedical Services | 98| |Medical Oncology | 96| |Perinatal Epidemiology | 92| |Development Office | 92| |Theoretical Physics | 91| |Structural Genomics | 90| |Anaesthetics | 84| |OUP | 84| |Linguistics Philology | 82| |Condensed Physics | 80| |Internet Institute | 77| |Archaeology Research | 77| |Pitt Rivers | 73| |Jenner Institute | 68| |Sport | 67| |Atomic Physics | 66| |Atmospheric Physics | 65| |Isis Innovation | 63| |Ophthalmology | 62| |Radcliffe Science Library | 59| |University Museum | 59| |Med Sci DTC | 50| |Tropical Medicine | 47| |African Studies | 44| |Examination Schools | 44| |Careers Service | 43| |Ruskin School | 40| |Latin American Centre | 39| |Med Sci Teach Cent | 37| |E-Research | 35| |Language Centre | 35| |Socio-Legal Studies | 33| |Taylor Inst. Library | 32| |ICT Support Team | 32| |Law Library | 31| |Health Care Libraries | 30| |Nissan Institute | 30| |Botanic Garden | 30| |Learning Institute | 29| |Smith School | 29| |History of Science | 25| |Criminology | 25| |Voltaire Foundation | 25| |Library Systems | 24| |European/Comparative Law | 23| |Counselling Service | 23| |Social Science Library | 23| |Ludwig Institute | 22| |COMPAS | 22| |Oxford Man | 22| |University Club | 22| |Rothermere Institute | 21| |Ageing | 21| |Statistical Medicine | 21| |Sackler Library | 21| |Veterinary Services | 19| |Humanities Division | 19| |Childhood Cancer Research | 18| |Safety Office | 17| |IMSU | 17| |Begbroke | 17| |History of Medicine | 17| |Rhodes House | 16| |Human Sciences | 15| |Student Union | 14| |Occupational Health Service | 13| |Chinese Studies | 12| |Proctors' Office | 11| |Phonetics | 11| |Alumni | 11| |History of Art | 11| |Social Sciences Division | 10| |21 School | 10| |Maths Physics Life Division | 9| |SBS Library | 8| |EHRC | 7| |Sheldonian Theatre | 7| |History Library | 7| |Cont Ed Library | 6| |Philosophy Library | 6| |Plant Sciences Library | 5| |English Library | 5| |Oriental Library | 5| |University Archives | 5| |Education Library | 5| |Chinese Library | 4| |Conference Oxford | 4| |Japanese Library | 4| |Music Library | 3| |Zoology Library | 3| |Indian Institute Library | 3| |Environmental Change | 3| |Theology Library | 3| |OSEM | 3| |Harmsworth Library | 3| |Director of IT | 2| |Brazilian Studies | 1| |Latin American Library | 1| +------------------------------+----+ (166 rows) /* number per college in card */ +------------------+----+ |nickname |tot | +------------------+----+ |Wolfson |1084| |Balliol | 951| |Christ Church | 941| |St Catherine's | 938| |New | 904| |Magdalen | 900| |St Anne's | 873| |St John's | 856| |Keble | 843| |Wadham | 842| |St Hugh's | 841| |Merton | 793| |Lady Margaret Hall| 792| |Hertford | 790| |St Edmund Hall | 783| |Worcester | 782| |Brasenose | 781| |Exeter | 760| |Green Templeton | 750| |Lincoln | 749| |University | 727| |Jesus | 718| |Pembroke | 699| |St Hilda's | 689| |St Antony's | 660| |Oriel | 650| |Somerville | 643| |Linacre | 643| |Queen's | 624| |Kellogg | 623| |St Cross | 604| |St Peter's | 595| |Trinity | 533| |Corpus Christi | 522| |Mansfield | 464| |Harris Manchester | 316| |Nuffield | 302| |Regent's Park | 242| |Wycliffe Hall | 186| |All Souls | 147| |Blackfriars | 79| |Ripon | 78| |St Benet's Hall | 73| |St Stephen's House| 66| |Campion Hall | 33| +------------------+----+ (45 rows) Mon Jan 18 10:59:57 2010