User:Djr13/OLMS graphing

Brief history: I added 46 of these throughout December 2014. It got overwhelming and I abandoned it for years, only later adding one more in June 2015 and updating six in May 2015(1, 2, 3, 4, 5, 6) and two in February 2016(1, 2). Not a single one of these were updated by another editor, though two were later removed. I looked eagerly toward the newly developing graph functions but was not prepared at the time to explore this new territory. This renewed effort begins (September 2019) thanks to edits by 124.170.216.250 and general maturation of the graphing and data tabulation features.

Old graph vs new
The old graphs, using Template:Line chart, had extremely redundant and cumbersome syntax, and required manual formatting changes to fit the data, and required data changes to fit the graph's limitations. They did carry a beneficial effect of this, tight control over formatting, to the degree where you could format the graph near perfectly to fit the data, and to align between graphs in a manner that facilitates spotting correlations between finances and membership. Someone even thought the old one was clearer.

Thanks to 124.170.216.250 many of these old graphs have been recently replaced with a new format. This new format has new limitations, but overall is a huge improvement for maintainability. In the replacement version, numbers can be updated merely by adding a comma followed by the data (without worrying about numbers being too big).

Currently experimenting in ../Sandbox and commons:Data:Sandbox/djr13/AFL-CIO.tab. Trying to improve formatting. Hope to use the new tabular data features if possible. Would be wonderful to automate things somehow, but there are always issues, whether with getting the reports, with the data on them, or with matters of factual context surrounding the data.

May be best to templatize these graphs for their particular informational, formatting and presentation needs. A dedicated membership-focused graph could potentially be made, a la Template:Graph:Population history. Being able to label major events (strikes/mergers/splits/legal changes) with visible (and reliably attributable) effects could be a great benefit.

Data notes
Around 2005, reporting rules changed so that agency fee payers are not counted in a union's total membership. Many unions with lots of agency fee payers thus saw a substantial drop in apparent membership in the report that followed.


 * It may be possible, and even preferable, to add agency fee payers, and breakdowns of notable membership categories (eg "non-voting", "retirees"). This requires actually looking at each report, identifying data more in-depth than that conveniently provided in OLMS's CSV exports.

I'm not absolutely certain what precise time or time range is used to count members. The most sensible (arguably) would be same as finances, the status as of the end of the reporting period. Note this period is not the same as submission date (is it the same as what OLMS calls "fiscal year"?), and it can even occur twice within the same year if the union adjusted its reporting period. Another sensible measure would be to count all people who had been members at some point during the reporting period (like Union (set theory)!), especially in industries with heavy turnover such as due to seasonal labor (see for example United Farm Workers), but this might not be accepted by OLMS. A union without historical membership records might also just use whatever number is current as of the date of filing. I've also seen obvious examples of estimation. In any case, it's possible the precise meaning of the figure may vary union to union, year to year; known issues should be explained when uploading and using the data.

Revisions happen too, revised data might need to be somehow overridden or discarded.

Overall, the data is expected to be accurate mostly due to threat of perjury.

Index of graphed unions and relevant info

 * 1199SEIU United Healthcare Workers East
 * Actors' Equity Association
 * AFL–CIO
 * American Federation of State, County and Municipal Employees
 * American Federation of Teachers
 * American Federation of Television and Radio Artists
 * American Federation of School Administrators
 * American Guild of Musical Artists; graphs removed by another editor January 2017
 * American Guild of Variety Artists
 * American Maritime Officers
 * Brotherhood of Locomotive Engineers and Trainmen
 * Change to Win Federation
 * Communications Workers of America
 * Council of School Supervisors & Administrators
 * Directors Guild of America
 * Glass, Molders, Pottery, Plastics and Allied Workers International Union
 * Graphic Communications Conference
 * Guild of Italian American Actors
 * Hebrew Actors' Union
 * Industrial Workers of the World; US OLMS membership paired with UK Certification Officer; finances not yet graphed
 * International Association of Bridge, Structural, Ornamental and Reinforcing Iron Workers
 * International Association of Machinists and Aerospace Workers
 * International Brotherhood of Teamsters
 * International Longshore and Warehouse Union
 * Laborers' International Union of North America
 * National Education Association
 * National Football League Players Association
 * New York State United Teachers
 * Pennsylvania State Education Association
 * Public Employees Federation
 * Retail, Wholesale and Department Store Union
 * Screen Actors Guild; membership data additionally graphed by category; membership legend provided in thumb caption forcing finance graph into separate thumb
 * SEIU 32BJ
 * SEIU United Healthcare Workers West
 * Service Employees International Union
 * Stage Directors and Choreographers Society
 * UNITE HERE
 * United Association
 * United Electrical, Radio and Machine Workers of America
 * United Farm Workers; note issues with seasonal labor and when members are totaled
 * United Federation of Teachers
 * United Food and Commercial Workers; split into two thumbs and tweaked by another editor April 2019
 * United Steelworkers
 * United Transportation Union
 * Workers United
 * Writers Guild of America, East
 * Writers Guild of America West; finance graph removed by another editor August 2019