Thu Dec 6 12:04:26 2012 /* 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*/ /* script location: /srv/babylon/svn/live/projects/unit_management/sql */ /* total current card records*/ +-----+ |col1 | +-----+ |46032| +-----+ (1 row) /* by card category*/ +----------+-----+ |status |total| +----------+-----+ |undergrad |12266| |postgrad |10618| |staff | 7905| |senmem | 4470| |college | 3342| |dept | 2349| |visitor | 1938| |ret | 1262| |cardholder| 891| |student | 669| |virtual | 294| |retfr | 28| +----------+-----+ (12 rows) /* total people per division - exclude colleges */ +--------------------------------------+-----+ |division_name |total| +--------------------------------------+-----+ |Medical Sciences | 8141| |Social Sciences | 6290| |Maths, Physical & Life Sciences | 5833| |Humanities | 3904| |University Administration and Services| 2109| |Continuing Education | 1616| |Academic Services | 1466| |Societies, Other & Companies | 142| |not on tree | 142| |Council Departments | 5| +--------------------------------------+-----+ (10 rows) /* undergrads by OSS division of their course- taken from OSS*/ +-------------------------------+-----+ |division_name |total| +-------------------------------+-----+ |Humanities | 4245| |Maths, Physical & Life Sciences| 3574| |Social Sciences | 2217| |Medical Sciences | 1691| +-------------------------------+-----+ (4 rows) /* by status*/ +--------------------------------------+----------+-----+ |division_name |status |total| +--------------------------------------+----------+-----+ |Academic Services |staff | 966| |Academic Services |ret | 157| |Academic Services |senmem | 124| |Academic Services |cardholder| 106| |Academic Services |dept | 100| |Academic Services |visitor | 10| |Academic Services |college | 2| |Academic Services |virtual | 1| |Continuing Education |postgrad | 799| |Continuing Education |undergrad | 539| |Continuing Education |staff | 115| |Continuing Education |dept | 92| |Continuing Education |senmem | 34| |Continuing Education |virtual | 21| |Continuing Education |ret | 9| |Continuing Education |visitor | 3| |Continuing Education |cardholder| 2| |Continuing Education |college | 2| |Council Departments |staff | 4| |Council Departments |ret | 1| |Humanities |postgrad | 1972| |Humanities |senmem | 1071| |Humanities |staff | 286| |Humanities |visitor | 239| |Humanities |dept | 128| |Humanities |ret | 103| |Humanities |college | 51| |Humanities |cardholder| 24| |Humanities |virtual | 22| |Humanities |student | 8| |Maths, Physical & Life Sciences |postgrad | 2596| |Maths, Physical & Life Sciences |staff | 1439| |Maths, Physical & Life Sciences |senmem | 810| |Maths, Physical & Life Sciences |visitor | 309| |Maths, Physical & Life Sciences |cardholder| 88| |Maths, Physical & Life Sciences |virtual | 55| |Maths, Physical & Life Sciences |college | 19| |Maths, Physical & Life Sciences |student | 12| |Medical Sciences |staff | 3002| |Medical Sciences |postgrad | 1499| |Medical Sciences |senmem | 1170| |Medical Sciences |dept | 1138| |Medical Sciences |undergrad | 512| |Medical Sciences |visitor | 444| |Medical Sciences |ret | 181| |Medical Sciences |cardholder| 133| |Medical Sciences |virtual | 51| |Medical Sciences |college | 8| |Medical Sciences |student | 3| |Social Sciences |postgrad | 3752| |Social Sciences |staff | 847| |Social Sciences |senmem | 731| |Social Sciences |visitor | 539| |Social Sciences |dept | 195| |Social Sciences |ret | 97| |Social Sciences |virtual | 53| |Social Sciences |cardholder| 34| |Social Sciences |student | 25| |Social Sciences |college | 17| |Societies, Other & Companies |staff | 99| |Societies, Other & Companies |dept | 27| |Societies, Other & Companies |visitor | 9| |Societies, Other & Companies |senmem | 6| |Societies, Other & Companies |cardholder| 1| |University Administration and Services|staff | 1112| |University Administration and Services|senmem | 348| |University Administration and Services|dept | 284| |University Administration and Services|cardholder| 166| |University Administration and Services|ret | 164| |University Administration and Services|virtual | 26| |University Administration and Services|visitor | 5| |University Administration and Services|college | 4| |not on tree |dept | 104| |not on tree |retfr | 28| |not on tree |senmem | 8| |not on tree |cardholder| 1| |not on tree |ret | 1| +--------------------------------------+----------+-----+ (79 rows) /* number per dept in card */ +-----------------------------------+----+ |nickname |tot | +-----------------------------------+----+ |Continuing Education |1616| |Said Business School | 973| |History | 837| |Engineering Science | 781| |Computer Science | 776| |Law | 745| |Education | 697| |Maths | 641| |Politics | 600| |OUCE | 548| |NDM | 539| |Physiology and Anatomy | 527| |English | 523| |Zoology | 517| |Medical School Offices | 512| |Clinical Neurosciences | 506| |Oriental Institute | 495| |IT Services | 448| |Biochemistry | 439| |Theology Faculty | 417| |Experimental Psychology | 415| |International Development | 413| |Ashmolean Museum | 389| |Economics | 388| |Oncology | 381| |Modern Languages | 376| |Materials | 374| |Philosophy | 340| |Psychiatry | 328| |Organic Chemistry | 328| |Pathology | 326| |Archaeology | 304| |NDORMS | 298| |Estates Services | 277| |Physical/Theoretical Chemistry | 258| |Anthropology | 251| |Surgical Sciences | 242| |Inorganic Chemistry | 237| |Public Health | 235| |Primary Health Care | 230| |Clinical Trial Service | 222| |Pharmacology | 217| |Finance | 214| |Clin. Lab. Sciences | 208| |Earth Sciences | 205| |Wellcome Genetics | 202| |Condensed Matter Physics | 195| |Physics | 194| |Social Policy | 194| |Plant Sciences | 189| |Particle Physics | 176| |Obstetrics/Gynaecology | 171| |Cardiovascular Medicine | 170| |Statistics | 170| |University Offices | 163| |Music | 161| |Paediatrics | 155| |Tropical Medicine | 144| |Kennedy | 142| |WIMM | 139| |Medical Sciences Office | 139| |Sociology | 139| |Said Business School Ltd | 138| |Classical Languages & Literature | 138| |Classics | 138| |Biomedical Services | 137| |Astrophysics | 136| |OCDEM | 135| |Med Sci DTC | 122| |Atomic Physics | 120| |Jenner Institute | 118| |Medical Sciences Division | 116| |Theoretical Physics | 109| |Atmospheric Physics | 103| |Bodleian Special Collections | 103| |Internet Institute | 103| |Structural Genomics | 100| |Student Admin | 100| |Development Office | 98| |Linguistics Philology | 96| |Classical Archaeology | 96| |Isis Innovation | 93| |Bodleian | 92| |OUP | 88| |Research Services | 84| |NPEU | 84| |Pitt Rivers | 79| |RDM Investigative Medicine | 78| |Doctoral Training (MPLS) | 74| |Blavatnik | 71| |Criminology | 69| |Cancer Epidemiology | 68| |Chemistry | 68| |Security Services | 66| |Ruskin School | 65| |Facilities Management | 65| |Bodleian Reader Services | 63| |Archaeology Research | 62| |Clinical Pharmacology | 62| |Sport | 60| |Radcliffe Science Library | 59| |University Museum | 59| |Student Welfare | 57| |Bodleian Enterprise Units | 57| |Area Studies | 56| |Latin American Centre | 56| |African Studies | 56| |Personnel | 54| |Collections & Resource Descriptions| 53| |OeRC | 53| |School of Anthropology | 53| |Medical Oncology | 46| |BDLSS | 46| |Chemical Biology | 45| |Socio-Legal Studies | 44| |Smith School | 44| |Careers Service | 44| |Conservation & Collection Care | 42| |Language Centre | 42| |Bodleian Facilities Management | 39| |REES | 39| |Ludwig Institute | 39| |Taylor Inst. Library | 38| |Public Affairs | 37| |Chinese Studies(Social Sci) | 37| |Undergraduate Admissions | 36| |Oxford Man | 35| |Humanities Division | 35| |Structural Biology | 35| |Med Sci Teach Cent | 33| |Botanic Garden | 33| |French | 33| |Graduate Admissions | 32| |COMPAS | 32| |Sackler Library | 30| |Learning Institute | 30| |Law Library | 29| |FM & Messenger Service | 29| |Social Science Library | 28| |Health Care Libraries | 28| |Nissan Institute | 28| |Retired FR | 28| |History of Science | 27| |NDM Strategic | 26| |Chemistry Research Laboratory | 26| |Rhodes House | 26| |Social Sciences Division | 25| |European/Comparative Law | 25| |Maths Physics Life Division | 24| |Begbroke Science Park | 23| |Ageing | 23| |University Club | 22| |Occupational Health Service | 20| |German | 20| |History of Medicine | 20| |PRAS | 20| |Bodleian Personnel | 20| |Student Union | 18| |Divisional Administration | 18| |IMSU | 18| |InSIS | 17| |Voltaire Foundation | 17| |Legal Services | 17| |CCMP | 17| |Equality | 16| |Alumni | 16| |Oxford Ltd | 16| |Council Secretariat | 15| |Martin School | 15| |Safety Office | 15| |Childhood Cancer Research | 15| |History of Art | 14| |Russian | 14| |Spanish | 14| |Rothermere Institute | 14| |Proctors Office | 13| |Bioscience DTP | 11| |Sainsbury Library | 10| |Chinese Studies | 10| |Book Storage Facility | 10| |Phonetics | 10| |Human Sciences | 9| |Education Policy | 9| |Academic Registrar | 9| |Italian | 8| |Student Services | 8| |History Library | 8| |Bodleian Accounts Section | 8| |Vice Chancellor's Office | 7| |Cont Ed Library | 6| |Philosophy Faculty Library | 6| |Music Library | 6| |English Library | 6| |Endowment Management | 5| |University Archives | 5| |Bodleian Communications | 5| |Education Library | 5| |Sheldonian Theatre | 5| |Bodleian Libraries Admissions | 5| |Child Care | 5| |Portuguese | 5| |Chinese Studies Library | 4| |International Strategy | 4| |Japanese Library | 4| |Byzantine and Modern Greek | 3| |Voltaire Foundation Ltd | 3| |Brain Activity | 3| |Harmsworth Library | 3| |Plant Sciences Library | 3| |Spinout Equity Mgmt | 3| |EHRC | 3| |Oriental Institute Library | 3| |Bodleian Estates | 3| |Latin American Ctr Library | 3| |Conference Oxford | 3| |Theology Library | 2| |Official Papers | 2| |Celtic | 2| |PGMDE | 1| |Director of IT | 1| |CCVTM | 1| |South Asian Studies | 1| |Zoology Library | 1| |Tylor Library | 1| |Radcliffe Dept of Medicine | 1| |Bodleian User Education | 1| +-----------------------------------+----+ (226 rows) /* number per college in card */ +------------------+----+ |nickname |tot | +------------------+----+ |Wolfson |1246| |St Catherine's |1092| |New |1022| |Balliol | 987| |Kellogg | 974| |Christ Church | 958| |St Hugh's | 946| |St Anne's | 924| |St Edmund Hall | 915| |Magdalen | 915| |Keble | 908| |Wadham | 865| |Hertford | 854| |St John's | 849| |Merton | 836| |Lady Margaret Hall| 831| |Worcester | 805| |Green Templeton | 793| |Brasenose | 792| |University | 791| |Pembroke | 785| |Exeter | 783| |Lincoln | 775| |St Hilda's | 764| |Jesus | 761| |St Cross | 742| |Somerville | 707| |St Antony's | 704| |Oriel | 696| |Queen's | 653| |Linacre | 634| |St Peter's | 634| |Trinity | 558| |Corpus Christi | 517| |Mansfield | 472| |Harris Manchester | 354| |Nuffield | 316| |Wycliffe Hall | 276| |Regent's Park | 254| |All Souls | 173| |Blackfriars | 102| |St Stephen's House| 91| |St Benet's Hall | 77| |Ripon College | 75| |Campion Hall | 57| +------------------+----+ (45 rows) Thu Dec 6 12:04:31 2012 |Maths, Physical & Life Sciences |dept | 281| |Maths, Physical & Life Sciences |ret | 224|