Publicity #16585
openNew annual report data
0%
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!
Updated by Boone Gorges about 2 years 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 )
Updated by Boone Gorges about 2 years ago
- Status changed from New to Reporter Feedback
- Target version set to Not tracked