Publicity #16585
openNew annual report data
Added by Colin McDonald over 1 year ago. Updated over 1 year ago.
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 over 1 year 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 over 1 year ago
- Status changed from New to Reporter Feedback
- Target version set to Not tracked