Project

General

Profile

Actions

Publicity #16585

open

New annual report data

Added by Colin McDonald about 2 months ago. Updated 15 days ago.

Status:
Reporter Feedback
Priority name:
Normal
Assignee:
Category name:
Publicity
Target version:
Start date:
2022-08-09
Due date:
% Done:

0%

Estimated time:

Description

We hope to release an annual report soon getting back on our academic-year annual schedule that was disrupted during Covid. This one should cover two years, 2020-2021 and 2021-2022. To that end, can I ask for:

- Total number of Sites and Groups that we had on June 1st of 2021 and also of 2022

- Similar to #16355 from last month, overall total and by-role total of Members that joined from 6/1/20 to 5/31/21 and 6/1/21 to 5/31/22 (and understood that users can have more than one role)

- Also building off of #16355, I'd like to track all Courses over time since we launched Courses. In that prior ticket you provided this:

[totals] => Array
(
[Summer 2021] => 38
[Fall 2021] => 271
[Spring 2022] => 199
[Summer 2022] => 24
)

Would it be possible to provide the same for each semester from Fall 2018 (when I believe Courses began) to Fall 2022? And if I added each semester up, would I get (at least roughly) to the total number of Courses right now? In #12673 I asked for month by month course creation, but I think that's probably too granular at this stage for the Courses era.

We also looked at Courses in #13402 and I could pull numbers from there but I'm wondering if it's best to do a fresh query across all semesters since it's been a while since we looked at this, then it'll be easier to update in subsequent years.

Many thanks!

Actions #1

Updated by Boone Gorges about 2 months ago

Here's a couple of data dumps. I think that this will mostly cover what you want, but please let me know whether I've missed something.

First, here is the course-stats script from #16355, extended back through calendar year 2018. I think this should have the course info that you want.

Array
(
    [totals] => Array
        (
            [Winter 2018] => 0
            [Spring 2018] => 0
            [Summer 2018] => 0
            [Fall 2018] => 0
            [Winter 2019] => 0
            [Spring 2019] => 75
            [Summer 2019] => 1
            [Fall 2019] => 240
            [Winter 2020] => 2
            [Spring 2020] => 213
            [Summer 2020] => 24
            [Fall 2020] => 344
            [Winter 2021] => 6
            [Spring 2021] => 317
            [Summer 2021] => 38
            [Fall 2021] => 271
            [Winter 2022] => 11
            [Spring 2022] => 199
            [Summer 2022] => 25
        )

    [campuses_per_term] => Array
        (
            [Winter 2018] => Array
                (
                )

            [Spring 2018] => Array
                (
                )

            [Summer 2018] => Array
                (
                )

            [Fall 2018] => Array
                (
                )

            [Winter 2019] => Array
                (
                )

            [Spring 2019] => Array
                (
                    [Queens College] => 7
                    [CUNY-Wide] => 1
                    [CUNY Graduate Center] => 9
                    [City College of New York] => 14
                    [Hunter College] => 17
                    [CUNY School of Law] => 1
                    [Kingsborough Community College] => 1
                    [Borough of Manhattan Community College] => 10
                    [College of Staten Island] => 2
                    [Lehman College] => 3
                    [Queensborough Community College] => 1
                    [LaGuardia Community College] => 2
                    [Bronx Community College] => 1
                    [Brooklyn College] => 2
                )

            [Summer 2019] => Array
                (
                    [Queens College] => 1
                )

            [Fall 2019] => Array
                (
                    [Queens College] => 12
                    [Hunter College] => 14
                    [Lehman College] => 5
                    [City College of New York] => 78
                    [College of Staten Island] => 3
                    [Brooklyn College] => 15
                    [CUNY Graduate Center] => 26
                    [LaGuardia Community College] => 9
                    [Kingsborough Community College] => 3
                    [Borough of Manhattan Community College] => 51
                    [Guttman Community College] => 7
                    [Hostos Community College] => 2
                    [New York City College of Technology] => 1
                    [York College] => 2
                    [John Jay College of Criminal Justice] => 2
                    [CUNY School of Labor and Urban Studies] => 4
                    [Baruch College] => 1
                    [Bronx Community College] => 2
                    [Queensborough Community College] => 1
                )

            [Winter 2020] => Array
                (
                    [Lehman College] => 2
                )

            [Spring 2020] => Array
                (
                    [New York City College of Technology] => 1
                    [Borough of Manhattan Community College] => 10
                    [Brooklyn College] => 20
                    [York College] => 1
                    [City College of New York] => 63
                    [John Jay College of Criminal Justice] => 13
                    [CUNY Graduate Center] => 31
                    [Lehman College] => 5
                    [Queens College] => 17
                    [Hunter College] => 17
                    [College of Staten Island] => 6
                    [Baruch College] => 2
                    [LaGuardia Community College] => 3
                    [CUNY-Wide] => 5
                    [Kingsborough Community College] => 3
                    [Guttman Community College] => 8
                    [CUNY School of Labor and Urban Studies] => 3
                    [Hostos Community College] => 4
                    [Queensborough Community College] => 2
                )

            [Summer 2020] => Array
                (
                    [City College of New York] => 7
                    [Hunter College] => 1
                    [LaGuardia Community College] => 1
                    [CUNY Graduate Center] => 4
                    [Brooklyn College] => 4
                    [Queens College] => 1
                    [John Jay College of Criminal Justice] => 1
                    [College of Staten Island] => 2
                    [CUNY School of Professional Studies] => 2
                    [Guttman Community College] => 1
                )

            [Fall 2020] => Array
                (
                    [Queens College] => 25
                    [City College of New York] => 127
                    [LaGuardia Community College] => 6
                    [Borough of Manhattan Community College] => 7
                    [Kingsborough Community College] => 5
                    [Hunter College] => 12
                    [John Jay College of Criminal Justice] => 15
                    [Brooklyn College] => 29
                    [CUNY Graduate Center] => 41
                    [CUNY Graduate School of Public Health and Health Policy] => 2
                    [Lehman College] => 16
                    [College of Staten Island] => 12
                    [CUNY School of Labor and Urban Studies] => 21
                    [Baruch College] => 7
                    [York College] => 7
                    [CUNY-Wide] => 9
                    [Bronx Community College] => 2
                    [Medgar Evers College] => 1
                    [CUNY School of Law] => 1
                )

            [Winter 2021] => Array
                (
                    [CUNY-Wide] => 1
                    [City College of New York] => 1
                    [College of Staten Island] => 1
                    [Kingsborough Community College] => 2
                    [Guttman Community College] => 1
                )

            [Spring 2021] => Array
                (
                    [CUNY Graduate Center] => 40
                    [City College of New York] => 84
                    [Brooklyn College] => 20
                    [Hunter College] => 17
                    [CUNY School of Labor and Urban Studies] => 6
                    [New York City College of Technology] => 75
                    [Kingsborough Community College] => 6
                    [Queens College] => 18
                    [Guttman Community College] => 1
                    [LaGuardia Community College] => 4
                    [CUNY-Wide] => 3
                    [College of Staten Island] => 6
                    [Lehman College] => 14
                    [Queensborough Community College] => 6
                    [John Jay College of Criminal Justice] => 7
                    [Borough of Manhattan Community College] => 2
                    [York College] => 3
                    [Baruch College] => 5
                    [Hostos Community College] => 1
                )

            [Summer 2021] => Array
                (
                    [CUNY-Wide] => 3
                    [Lehman College] => 2
                    [Hunter College] => 2
                    [City College of New York] => 11
                    [LaGuardia Community College] => 2
                    [Queens College] => 3
                    [John Jay College of Criminal Justice] => 2
                    [College of Staten Island] => 1
                    [CUNY Graduate Center] => 4
                    [Brooklyn College] => 4
                    [Baruch College] => 2
                )

            [Fall 2021] => Array
                (
                    [Brooklyn College] => 36
                    [Queens College] => 28
                    [City College of New York] => 104
                    [Kingsborough Community College] => 5
                    [LaGuardia Community College] => 7
                    [CUNY Graduate Center] => 34
                    [Hunter College] => 13
                    [Baruch College] => 4
                    [Queensborough Community College] => 6
                    [CUNY-Wide] => 4
                    [Borough of Manhattan Community College] => 1
                    [Guttman Community College] => 2
                    [Lehman College] => 5
                    [College of Staten Island] => 5
                    [John Jay College of Criminal Justice] => 7
                    [York College] => 4
                    [CUNY School of Labor and Urban Studies] => 3
                    [CUNY School of Professional Studies] => 1
                    [Bronx Community College] => 1
                )

            [Winter 2022] => Array
                (
                    [Guttman Community College] => 2
                    [CUNY Graduate Center] => 2
                    [Kingsborough Community College] => 5
                    [Queens College] => 1
                    [Brooklyn College] => 1
                )

            [Spring 2022] => Array
                (
                    [CUNY-Wide] => 12
                    [York College] => 7
                    [Kingsborough Community College] => 3
                    [Hunter College] => 14
                    [CUNY Graduate Center] => 32
                    [City College of New York] => 39
                    [College of Staten Island] => 6
                    [Lehman College] => 10
                    [John Jay College of Criminal Justice] => 5
                    [Guttman Community College] => 6
                    [Brooklyn College] => 24
                    [LaGuardia Community College] => 6
                    [Queensborough Community College] => 7
                    [Queens College] => 20
                    [CUNY School of Labor and Urban Studies] => 3
                    [Borough of Manhattan Community College] => 2
                    [Baruch College] => 1
                    [CUNY School of Professional Studies] => 1
                )

            [Summer 2022] => Array
                (
                    [Hunter College] => 1
                    [John Jay College of Criminal Justice] => 3
                    [City College of New York] => 1
                    [Guttman Community College] => 1
                    [Queens College] => 4
                    [Medgar Evers College] => 2
                    [LaGuardia Community College] => 1
                    [Brooklyn College] => 4
                    [Baruch College] => 2
                    [CUNY-Wide] => 3
                    [CUNY Graduate Center] => 1
                    [Kingsborough Community College] => 1
                    [Borough of Manhattan Community College] => 1
                )

        )
)

And if I added each semester up, would I get (at least roughly) to the total number of Courses right now?

Yes, that should work with the numbers above.

- Total number of Sites and Groups that we had on June 1st of 2021 and also of 2022

mysql> select count(*) from wp_blogs where registered < '2021-06-01 00:00:00';
+----------+
| count(*) |
+----------+
|    17723 |
+----------+
1 row in set (0.01 sec)

mysql> select count(*) from wp_blogs where registered < '2022-06-01 00:00:00';
+----------+
| count(*) |
+----------+
|    22388 |
+----------+
1 row in set (0.02 sec)

mysql> select count(*) from wp_bp_groups where date_created < '2021-06-01 00:00:00';
+----------+
| count(*) |
+----------+
|     2006 |
+----------+
1 row in set (0.00 sec)

mysql> select count(*) from wp_bp_groups where date_created < '2022-06-01 00:00:00'; 
+----------+
| count(*) |
+----------+
|     2287 |
+----------+
1 row in set (0.01 sec)

- Similar to #16355 from last month, overall total and by-role total of Members that joined from 6/1/20 to 5/31/21 and 6/1/21 to 5/31/22 (and understood that users can have more than one role)

6/1/20 to 5/31/21

[new_users] => Array
        (
            [total] => 6842
            [Undergraduate Student] => 4990
            [Staff] => 106
            [Faculty] => 502
            [Administrator] => 78
            [Alumnus/a] => 113
            [Graduate Student] => 989
            [Other] => 135
            [Postdoc] => 10
            [] => 171
        )

6/1/21 to 5/31/22

[new_users] => Array
        (
            [total] => 6176
            [Undergraduate Student] => 4618
            [Graduate Student] => 925
            [Alumnus/a] => 100
            [Faculty] => 429
            [Other] => 102
            [Staff] => 107
            [Administrator] => 75
            [Postdoc] => 17
            [] => 13
        )
Actions #2

Updated by Boone Gorges 15 days ago

  • Status changed from New to Reporter Feedback
  • Target version set to Not tracked
Actions

Also available in: Atom PDF