Thu Jul  3 14:13:50 2008


/* 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 includes all sorts of people who may not be represented in other data sources eg payroll or student records*/

/* total current card records*/


+-----+
|col1 |
+-----+
|38535|
+-----+
(1 row)


/* by card category*/


+----------+-----+
|status    |total|
+----------+-----+
|undergrad |12249|
|postgrad  | 8068|
|staff     | 6681|
|senmem    | 3808|
|college   | 2697|
|dept      | 1433|
|visitor   | 1417|
|ret       |  859|
|cardholder|  707|
|student   |  505|
|virtual   |  111|
+----------+-----+
(11 rows)


/* total people per division - exclude colleges */

+---------------------------+-----+
|division_name              |total|
+---------------------------+-----+
|Medical Sciences           | 6233|
|Social Sciences            | 4860|
|Maths, Physical & Life Sci.| 4421|
|Humanities                 | 3166|
|Central Administration     | 1476|
|Continuing Education       | 1425|
|Academic Services          | 1365|
|Council                    |  132|
|Paying Etc                 |   96|
|Other Related Bodies       |   86|
|Health and Safety          |   30|
+---------------------------+-----+
(11 rows)

/* undergrads by OSS division of their course- taken from OSS*/

+---------------------------+-----+
|division_name              |total|
+---------------------------+-----+
|Humanities                 | 4231|
|Maths, Physical & Life Sci.| 3470|
|Social Sciences            | 2236|
|Medical Sciences           | 1624|
+---------------------------+-----+
(4 rows)


/* by status*/

+---------------------------+----------+-----+
|division_name              |status    |total|
+---------------------------+----------+-----+
|Academic Services          |staff     |  990|
|Academic Services          |senmem    |  156|
|Academic Services          |ret       |  131|
|Academic Services          |dept      |   70|
|Academic Services          |cardholder|    9|
|Academic Services          |visitor   |    7|
|Academic Services          |college   |    1|
|Academic Services          |virtual   |    1|
|Central Administration     |staff     |  922|
|Central Administration     |senmem    |  221|
|Central Administration     |dept      |  149|
|Central Administration     |cardholder|  104|
|Central Administration     |ret       |   75|
|Central Administration     |visitor   |    4|
|Central Administration     |virtual   |    1|
|Continuing Education       |postgrad  |  618|
|Continuing Education       |undergrad |  602|
|Continuing Education       |staff     |  113|
|Continuing Education       |dept      |   51|
|Continuing Education       |senmem    |   31|
|Continuing Education       |ret       |    5|
|Continuing Education       |visitor   |    4|
|Continuing Education       |cardholder|    1|
|Council                    |staff     |  102|
|Council                    |dept      |   10|
|Council                    |senmem    |    7|
|Council                    |ret       |    6|
|Council                    |cardholder|    3|
|Council                    |visitor   |    3|
|Council                    |college   |    1|
|Health and Safety          |staff     |   18|
|Health and Safety          |senmem    |    6|
|Health and Safety          |ret       |    4|
|Health and Safety          |cardholder|    1|
|Health and Safety          |dept      |    1|
|Humanities                 |postgrad  | 1628|
|Humanities                 |senmem    |  995|
|Humanities                 |staff     |  201|
|Humanities                 |visitor   |  187|
|Humanities                 |ret       |   62|
|Humanities                 |dept      |   54|
|Humanities                 |cardholder|   18|
|Humanities                 |college   |   14|
|Humanities                 |virtual   |    7|
|Maths, Physical & Life Sci.|postgrad  | 1772|
|Maths, Physical & Life Sci.|staff     | 1210|
|Maths, Physical & Life Sci.|senmem    |  704|
|Maths, Physical & Life Sci.|visitor   |  285|
|Maths, Physical & Life Sci.|dept      |  201|
|Maths, Physical & Life Sci.|ret       |  185|
|Maths, Physical & Life Sci.|cardholder|   53|
|Maths, Physical & Life Sci.|college   |    9|
|Maths, Physical & Life Sci.|virtual   |    2|
|Medical Sciences           |staff     | 2345|
|Medical Sciences           |postgrad  | 1127|
|Medical Sciences           |senmem    |  881|
|Medical Sciences           |dept      |  658|
|Medical Sciences           |undergrad |  512|
|Medical Sciences           |visitor   |  410|
|Medical Sciences           |cardholder|  130|
|Medical Sciences           |ret       |  126|
|Medical Sciences           |virtual   |   36|
|Medical Sciences           |college   |    8|
|Other Related Bodies       |staff     |   70|
|Other Related Bodies       |dept      |    5|
|Other Related Bodies       |senmem    |    4|
|Other Related Bodies       |ret       |    3|
|Other Related Bodies       |visitor   |    3|
|Other Related Bodies       |cardholder|    1|
|Paying Etc                 |dept      |   85|
|Paying Etc                 |senmem    |   10|
|Paying Etc                 |cardholder|    1|
|Social Sciences            |postgrad  | 2923|
|Social Sciences            |staff     |  675|
|Social Sciences            |senmem    |  622|
|Social Sciences            |visitor   |  264|
|Social Sciences            |dept      |  149|
|Social Sciences            |cardholder|   77|
|Social Sciences            |undergrad |   76|
|Social Sciences            |ret       |   59|
|Social Sciences            |college   |   11|
|Social Sciences            |virtual   |    4|
+---------------------------+----------+-----+
(82 rows)

/* number per dept in card */


+------------------------------+----+
|nickname                      |tot |
+------------------------------+----+
|Continuing Education          |1425|
|University Offices            | 978|
|Said Business School          | 824|
|Clinical Medicine             | 741|
|History                       | 714|
|Engineering Science           | 649|
|Politics                      | 551|
|Physiology and Anatomy        | 543|
|Law                           | 515|
|Medical School Offices        | 512|
|Education                     | 490|
|Biochemistry                  | 477|
|Environment                   | 453|
|Maths                         | 425|
|English                       | 423|
|Oriental Institute            | 416|
|Zoology                       | 399|
|Modern Languages              | 383|
|Economics                     | 362|
|Pathology                     | 358|
|Classics                      | 350|
|Bodleian Library              | 345|
|Computing Lab.                | 344|
|Queen Elizabeth House         | 342|
|Experimental Psychology       | 337|
|Chemistry                     | 329|
|Theology                      | 314|
|Materials                     | 313|
|Molecular Medicine            | 293|
|Physics                       | 292|
|Public Health                 | 284|
|Philosophy                    | 267|
|Anthropology                  | 260|
|Psychiatry                    | 242|
|Archaeology                   | 220|
|Pharmacology                  | 217|
|Inorganic Chemistry           | 214|
|Particle Physics              | 207|
|Physical/Theoretical Chemistry| 203|
|Applied Social Studies        | 193|
|Ashmolean Museum              | 191|
|Estates Directorate           | 188|
|Wellcome Genetics             | 187|
|Clinical Trial Service        | 185|
|Plant Sciences                | 180|
|Computing Services            | 167|
|Clinical Neurology            | 167|
|Earth Sciences                | 161|
|Clin. Lab. Sciences           | 158|
|Surgery                       | 152|
|Statistics                    | 150|
|Radiation Oncology            | 139|
|Orthopaedic Surgery           | 139|
|University Libraries          | 136|
|Cardiovascular Medicine       | 131|
|Medical Sciences              | 131|
|Paediatrics                   | 126|
|Sociology                     | 125|
|Astrophysics                  | 121|
|Clinical Pharmacology         | 108|
|Music                         | 107|
|Said Business School Ltd      | 106|
|Doctoral Training             | 101|
|Obstetrics/Gynaecology        |  99|
|Anaesthetics                  |  94|
|Medical Oncology              |  85|
|Theoretical Physics           |  83|
|OUP                           |  82|
|OCDEM                         |  82|
|Development Office            |  81|
|Biomedical Services           |  76|
|Sport                         |  73|
|Perinatal Epidemiology        |  70|
|Condensed Physics             |  68|
|Pitt Rivers                   |  66|
|Atmospheric Physics           |  66|
|Atomic Physics                |  64|
|Structural Genomics           |  62|
|African Studies               |  61|
|Linguistics Philology         |  61|
|University Museum             |  60|
|Ophthalmology                 |  54|
|Radcliffe Science Library     |  54|
|Internet Institute            |  53|
|Isis Innovation               |  51|
|Careers Service               |  46|
|Slavonic Studies              |  45|
|Examination Schools           |  43|
|Socio-Legal Studies           |  39|
|Archaeology Research          |  37|
|Ruskin School                 |  35|
|Library Systems               |  35|
|Botanic Garden                |  33|
|Latin American Centre         |  30|
|Taylor Inst. Library          |  29|
|Learning Institute            |  29|
|ICT Support Team              |  29|
|E-Research                    |  27|
|Law Library                   |  27|
|Health Care Libraries         |  26|
|History of Science            |  26|
|Language Centre               |  26|
|Nissan Institute              |  25|
|Rothermere Institute          |  24|
|Sackler Library               |  24|
|Voltaire Foundation           |  22|
|University Club               |  22|
|Criminology                   |  20|
|Safety Office                 |  19|
|Counselling Service           |  19|
|Begbroke                      |  19|
|Environmental Change          |  19|
|Area Studies                  |  19|
|Veterinary Services           |  18|
|Ageing                        |  18|
|Social Science Library        |  17|
|COMPAS                        |  16|
|Ludwig Institute              |  15|
|Humanities Division           |  15|
|IMSU                          |  15|
|History of Medicine           |  15|
|Statistical Medicine          |  14|
|Chinese Studies               |  14|
|Rhodes House                  |  13|
|Student Union                 |  13|
|Proctors' Office              |  12|
|Alumni                        |  11|
|Occupational Health Service   |  11|
|Oxford Man                    |  11|
|History of Art                |  11|
|Phonetics                     |  10|
|European/Comparative Law      |  10|
|SBS Library                   |  10|
|History Library               |   8|
|Human Sciences                |   8|
|Sheldonian Theatre            |   8|
|EHRC                          |   7|
|Maths Physics Life Division   |   6|
|Diabetes Trials Unit          |   6|
|Philosophy Library            |   6|
|Plant Sciences Library        |   5|
|English Library               |   5|
|Social Sciences Division      |   5|
|Cont Ed Library               |   5|
|Education Library             |   5|
|Japanese Library              |   4|
|University Archives           |   4|
|Refugee Library               |   3|
|Chinese Library               |   3|
|Music Library                 |   3|
|Indian Institute Library      |   3|
|Oriental Library              |   3|
|Theology Library              |   3|
|Human Anatomy                 |   3|
|Harmsworth Library            |   3|
|Vaccine Dev.                  |   2|
|Zoology Library               |   2|
|Tropical Medicine             |   2|
|Research Institute            |   2|
|Brazilian Studies             |   2|
|Latin American Library        |   2|
|Green                         |   1|
|Maison Francaise              |   1|
|Bioanthropology               |   1|
|Exp Psychology Library        |   1|
|Metabolic Research            |   1|
+------------------------------+----+
(166 rows)


/* number per college in card */


+------------------+----+
|nickname          |tot |
+------------------+----+
|Wolfson           |1039|
|Christ Church     | 936|
|St Catherine's    | 910|
|New               | 883|
|Balliol           | 880|
|Magdalen          | 877|
|Wadham            | 830|
|St John's         | 827|
|Keble             | 823|
|St Anne's         | 810|
|Hertford          | 805|
|St Hugh's         | 780|
|St Edmund Hall    | 772|
|Exeter            | 751|
|Lady Margaret Hall| 746|
|Merton            | 736|
|Worcester         | 723|
|University        | 711|
|Brasenose         | 695|
|Lincoln           | 690|
|St Hilda's        | 679|
|Jesus             | 660|
|Pembroke          | 655|
|St Antony's       | 644|
|St Peter's        | 633|
|Oriel             | 624|
|Linacre           | 612|
|Queen's           | 607|
|Somerville        | 594|
|Trinity           | 522|
|Green             | 515|
|Corpus Christi    | 491|
|St Cross          | 477|
|Kellogg           | 455|
|Mansfield         | 445|
|Harris Manchester | 319|
|Nuffield          | 278|
|Regent's Park     | 197|
|Templeton         | 190|
|Wycliffe Hall     | 139|
|All Souls         | 128|
|Greyfriars        |  87|
|St Benet's Hall   |  66|
|St Stephen's House|  61|
|Ripon             |  59|
|Blackfriars       |  56|
|Campion Hall      |  27|
+------------------+----+
(47 rows)


Ingres 2006 Version II 9.0.4 (r64.us5/105) logout
Thu Jul  3 14:13:54 2008