Proud to be part of LJMU,
in partnership with the Dill Faulkes Educational Trust

 

X

NSO Statistics

Useful statistics collated about the NSO - specifically for use in the Advisory Board report amongst others.

Registration Statistics

Information on the running total of registered users on the NSO month-by-month. This only includes accounts which have not since been deleted or blocked, so users who have been active and then deleted later will not appear in this table at all.
Note from Andy:It may be possible to get useful month-by-month stats which also include users who have been active and then moved on, but we'd need to decide exactly what we want to count (e.g how active is "active"? etc) and then see what is in the database that we can use.

=2017; $y--) { $stmon = ($y == 2017) ? 6 : 1; $endmon = ($y == $curyr) ? $curmon : 12; for($mon = $endmon; $mon>=$stmon; $mon--) { $stdate = "{$y}-{$mon}-1 00:00:00"; $_m = $mon + 1; $_y = $y; if($_m > 12) {$_y = $_y + 1; $_m = 1;} $enddate = "{$_y}-${_m}-1 00:00:00"; // Date column printf("", $y, $mon); // New accounts this month (total). $sql = "SELECT COUNT(u.uid) FROM {users} AS u LEFT JOIN {users_roles} AS r ON u.uid=r.uid RIGHT JOIN {role} AS rl ON r.rid=rl.rid WHERE (status=1) && (created>=UNIX_TIMESTAMP('{$stdate}')) && (created < UNIX_TIMESTAMP('${enddate}'));"; $result = db_query($sql)->fetchField(); print ""; // New teachers this month $sql = "SELECT COUNT(u.uid) FROM {users} AS u LEFT JOIN {users_roles} AS r ON u.uid=r.uid RIGHT JOIN {role} AS rl ON r.rid=rl.rid WHERE (status=1) && (created>=UNIX_TIMESTAMP('{$stdate}')) && (created < UNIX_TIMESTAMP('${enddate}')) && (rl.name='teacher');"; $result = db_query($sql)->fetchField(); print ""; // New students this month $sql = "SELECT COUNT(u.uid) FROM {users} AS u LEFT JOIN {users_roles} AS r ON u.uid=r.uid RIGHT JOIN {role} AS rl ON r.rid=rl.rid WHERE (status=1) && (created>=UNIX_TIMESTAMP('{$stdate}')) && (created < UNIX_TIMESTAMP('${enddate}')) && (rl.name='student');"; $result = db_query($sql)->fetchField(); print ""; // New nsousers this month $sql = "SELECT COUNT(u.uid) FROM {users} AS u LEFT JOIN {users_roles} AS r ON u.uid=r.uid RIGHT JOIN {role} AS rl ON r.rid=rl.rid WHERE (status=1) && (created>=UNIX_TIMESTAMP('{$stdate}')) && (created < UNIX_TIMESTAMP('${enddate}')) && (rl.name='nsouser');"; $result = db_query($sql)->fetchField(); print ""; // Accounts still active now and created before this month (total). $sql = "SELECT COUNT(u.uid) FROM {users} AS u LEFT JOIN {users_roles} AS r ON u.uid=r.uid RIGHT JOIN {role} AS rl ON r.rid=rl.rid WHERE (status=1) && (created < UNIX_TIMESTAMP('${enddate}'));"; $result = db_query($sql)->fetchField(); print ""; // Accounts still active now and created before this month (teacher). $sql = "SELECT COUNT(u.uid) FROM {users} AS u LEFT JOIN {users_roles} AS r ON u.uid=r.uid RIGHT JOIN {role} AS rl ON r.rid=rl.rid WHERE (status=1) && (created < UNIX_TIMESTAMP('${enddate}')) && (rl.name='teacher');"; $result = db_query($sql)->fetchField(); print ""; // Accounts still active now and created before this month (student). $sql = "SELECT COUNT(u.uid) FROM {users} AS u LEFT JOIN {users_roles} AS r ON u.uid=r.uid RIGHT JOIN {role} AS rl ON r.rid=rl.rid WHERE (status=1) && (created < UNIX_TIMESTAMP('${enddate}')) && (rl.name='student');"; $result = db_query($sql)->fetchField(); print ""; // Accounts still active now and created before this month (nsouser). $sql = "SELECT COUNT(u.uid) FROM {users} AS u LEFT JOIN {users_roles} AS r ON u.uid=r.uid RIGHT JOIN {role} AS rl ON r.rid=rl.rid WHERE (status=1) && (created < UNIX_TIMESTAMP('${enddate}')) && (rl.name='nsouser');"; $result = db_query($sql)->fetchField(); print ""; print ""; } } ?>
Month New Accounts New Teachers New Students New Users Total Accounts Total Teachers Total Students Total Users
%4d-%02d{$result}{$result}{$result}{$result}{$result}{$result}{$result}{$result}

Go Observing Statistics

Information on the running total of requested observations on the NSO month-by-month.
Note the "Completed Observations" do not include observations that are partially completed, and are confused by those that are submitted for future observation so treat them with a pinch of salt.

=2024; $y--) { $stmon = ($y == 2024) ? 1 : 1; $endmon = ($y == $curyr) ? $curmon : 12; for($mon = $endmon; $mon>=$stmon; $mon--) { $stdate = "{$y}-{$mon}-1 00:00:00"; $_m = $mon + 1; $_y = $y; if($_m > 12) {$_y = $_y + 1; $_m = 1;} $enddate = "{$_y}-${_m}-1 00:00:00"; // Date column printf("", $y, $mon); // Requests this month $sql = "SELECT COUNT(id) FROM gos WHERE tsubmit >= '{$stdate}' && tsubmit<'{$enddate}';"; $res = mysqli_query($link, $sql); $row = mysqli_fetch_row($res); print ""; // Running total $sql = "SELECT COUNT(id) FROM gos WHERE tsubmit<'{$enddate}';"; $res = mysqli_query($link, $sql); $row = mysqli_fetch_row($res); print ""; // Totally completed this month $sql = "SELECT COUNT(id) FROM gos WHERE lastmod >= '{$stdate}' && lastmod<'{$enddate}' && (status='observed' || status='download');"; $res = mysqli_query($link, $sql); $row = mysqli_fetch_row($res); print "\n"; } } ?>
Month Go Observing Requests Running Total Completed Observations
%4d-%02d{$row[0]}{$row[0]}{$row[0]}
2023-12559212623622
2023-111288212064855
2023-1016821077699
2023-09572210608245
2023-08194210036323
2023-07849209842348
2023-06553208993775
2023-05773208440571
2023-04683207667738
2023-0317572069841440
2023-021003205227330
2023-011161204224638
2022-12999203063896
2022-1116912020641279
2022-1010602003731052
2022-09889199313530
2022-08310198424234
2022-07543198114580
2022-06822197571633
2022-05741196749806
2022-048071960081139
2022-03867195201565
2022-021030194334637
2022-011140193304279
2021-128031921641558
2021-1110911913610
2021-101009190270816
2021-09902189261507
2021-08330188359253
2021-07612188029497
2021-061852187417869
2021-05837185565677
2021-04441184728266
2021-03775184287375
2021-021166183512934
2021-01702182346280
2020-12 850 181644 547
2020-11 880 180794 463
2020-10 861 179914 587
2020-09 751 179053 523
2020-08 261 178302 209
2020-07 584 178041 546
2020-06 1200 177457 867
2020-05 588 176257 704
2020-04 928 175669 572
2020-03 1392 174741 880
2020-02 1771 173349 1077
2020-01 999 171578 728
2019-12 977 170579 451
2019-11 1399 169602 1642
2019-10 1639 168203 3012
2019-09 1292 166564 182
2019-08 234 165272 180
2019-07 359 165038 199
2019-06 516 164679 443
2019-05 852 164163 1914
2019-04 818 163311 652
2019-03 1305 162493 441
2019-02 1078 161188 471
2019-01 1684 160110 770
2018-12 1632 158426 1558
2018-11 1675 156794 826
2018-10 1557 155119 609
2018-09 1252 153562 521
2018-08 330 152310 131
2018-07 996 151980 587
2018-06 564 150984 359
2018-05 633 150420 509
2018-04 953 149787 398
2018-03 1647 148834 715
2018-02 1696 147187 0
2018-01 2881 145491 793
2017-12 1717 142610 2280
2017-11 3224 140893 1220
2017-10 2721 137669 1663
2017-09 4314 134948 1861
2017-08 212 130634 99
2017-07 798 130422 360
2017-06 735 129624 228
2017-05 763 128889 716
2017-04 1166 128126 692
2017-03 2885 126960 668
2017-02 2106 124075 696
2017-01 2236 121969 955
2016-12 1562 119733 1078
2016-11 2003 118171 1253
2016-10 2211 116168 1889
2016-09 2832 113957 1088
2016-08 89 111125 629
2016-07 971 111036 1926
2016-06 498 110065 295
2016-05 656 109567 623
2016-04 1210 108911 546
2016-03 2028 107701 1037
2016-02 2599 105673 672
2016-01 2922 103074 1115
2015-12 890 100152 612
2015-11 1405 99262 905
2015-10 1462 97857 866
2015-09 2478 96395 876
2015-08 168 93917 158
2015-07 703 93749 451
2015-06 739 93046 205
2015-05 394 92307 551
2015-04 1298 91913 631
2015-03 1603 90615 1535
2015-02 2605 89012 512
2015-01 1993 86407 1074
2014-12 1370 84414 1494
2014-11 2450 83044 1746
2014-10 2400 80594 1180
2014-09 1398 78194 802
2014-08 269 76796 430
2014-07 2362 76527 1986
2014-06 1333 74165 149
2014-05 786 72832 576
2014-04 937 72046 434
2014-03 2062 71109 1773
2014-02 1780 69047 783
2014-01 1858 67267 820
2013-12 1083 65409 437
2013-11 1329 64326 647
2013-10 1925 62997 1798
2013-09 1352 61072 571
2013-08 200 59720 372
2013-07 382 59520 227
2013-06 743 59138 366
2013-05 361 58395 348
2013-04 1075 58034 980
2013-03 2098 56959 767
2013-02 2302 54861 1133
2013-01 2524 52559 1464
2012-12 1906 50035 1104
2012-11 1618 48129 929
2012-10 2261 46511 1720
2012-09 1163 44250 803
2012-08 174 43087 421
2012-07 551 42913 494
2012-06 625 42362 879
2012-05 1236 41737 506
2012-04 725 40501 668
2012-03 2587 39776 4108
2012-02 1542 37189 526
2012-01 1486 35647 853
2011-12 796 34161 518
2011-11 1250 33365 769
2011-10 1964 32115 984
2011-09 1018 30151 467
2011-08 186 29133 136
2011-07 616 28947 549
2011-06 690 28331 419
2011-05 484 27641 516
2011-04 669 27157 548
2011-03 1555 26488 519
2011-02 1329 24933 924
2011-01 1529 23604 878
2010-12 470 22075 242
2010-11 1016 21605 971
2010-10 988 20589 647
2010-09 552 19601 171
2010-08 38 19049 51
2010-07 502 19011 407
2010-06 244 18509 312
2010-05 271 18265 254
2010-04 330 17994 303
2010-03 660 17664 721
2010-02 495 17004 189
2010-01 609 16509 592
2009-12 490 15900 462
2009-11 835 15410 706
2009-10 595 14575 652
2009-09 278 13980 208
2009-08 124 13702 138
2009-07 215 13578 289
2009-06 429 13363 353
2009-05 204 12934 376
2009-04 333 12730 231
2009-03 557 12397 571
2009-02 347 11840 184
2009-01 404 11493 375
2008-12 162 11089 118
2008-11 187 10927 181
2008-10 286 10740 156
2008-09 271 10454 116
2008-08 70 10183 62
2008-07 136 10113 97
2008-06 101 9977 107
2008-05 308 9876 250
2008-04 111 9568 90
2008-03 234 9457 308
2008-02 330 9223 357
2008-01 293 8893 162
2007-12 161 8600 170
2007-11 237 8439 148
2007-10 165 8202 240
2007-09 213 8037 117
2007-08 48 7824 45
2007-07 85 7776 127
2007-06 133 7691 77
2007-05 116 7558 164
2007-04 99 7442 224
2007-03 258 7343 95
2007-02 194 7085 292
2007-01 244 6891 152
2006-12 121 6647 155
2006-11 364 6526 334
2006-10 178 6162 186
2006-09 211 5984 260
2006-08 103 5773 169
2006-07 428 5670 523
2006-06 626 5242 272
2006-05 194 4616 202
2006-04 137 4422 124
2006-03 232 4285 332
2006-02 243 4053 172
2006-01 145 3810 55
2005-12 166 3665 172
2005-11 219 3499 173
2005-10 325 3280 373
2005-09 170 2955 89
2005-08 145 2785 137
2005-07 268 2640 230
2005-06 196 2372 75
2005-05 105 2176 133
2005-04 118 2071 168
2005-03 295 1953 347
2005-02 271 1658 0
2005-01 282 1387 190
2004-12 250 1105 647
2004-11 493 855 20
2004-10 288 362 200
2004-09 73 74 18