Methodology

This archive was assembled from three saved snapshots of the Calagator event list, merged into 20,988 listings. This page explains each step, gives the exact numbers, and sets out what the data can and cannot show.

Three source snapshots

The source is the public event list of Calagator, Portland's community tech calendar. Three snapshots of that list were saved, each filtered by event date. The first covers July 5, 2006 to October 5, 2010. The second covers July 5, 2010 to October 5, 2016. The third covers July 5, 2016 to October 5, 2026.

The date ranges overlap by three months at each seam. Together the three snapshots held 22,548 rows. The earliest listing that survived processing is dated September 12, 2006, and the latest is dated October 3, 2026.

Removing duplicates

Two kinds of duplicates were removed. First, 635 rows were the same listing appearing in two overlapping snapshots. Each was kept once.

Second, 897 more rows were exact duplicates: the same title, start time and venue posted twice as separate listings. Almost all of these date from 2007 and 2008. Only one copy of each was kept.

Removing 635 overlap duplicates and 897 exact duplicates from 22,548 rows left 21,016 listings. Another 28 of those were not events and were also removed: seven organizer task reminders from October 2007, seven test entries from 2008, 2015 and 2017, and 14 spam listings with random-string titles from 2009 to 2015. That left 20,988 listings. Every count on this site is based on those 20,988.

Cleaning the text

Listing text was converted to plain ASCII characters.

Apart from that conversion, titles are kept as listed. Descriptions were read in writing the narratives but are not reproduced on the site; each listing links to its original on Calagator.

Groups and series

Recurring groups and series were identified from repeated listing titles, then matched to their listings with title rules.

The process produced 248 recurring groups and series. They cover 12,315 listings, or 59 percent of the archive. The other 8,673 listings are not assigned to a group.

The largest group by listing count is Free Geek Classes, with 588 listings, followed by PDX Women in Tech (PDXWIT) with 395 and DorkbotPDX with 297. Several groups, including Portland Linux/Unix Group (PLUG) and Portland Java User Group (PJUG), have listings from 2007 through 2026.

Venues and areas

The listings name 2,383 distinct venues as written, and 1,972 listings have no venue at all. Listings whose venue was entered only as to be determined are counted among those 1,972 and are shown as Venue to be announced. Many of those names refer to the same place, entered under several calendar venue records or spelled in different ways. These were merged into 574 canonical venues in the directory.

Areas were assigned from venue names, addresses given in listings, and lookups. The archive uses 13 areas. Most are parts of the metro area, from Downtown and Pearl District and Northwest to Beaverton, Hillsboro and the Westside and Vancouver, Washington; the others are Online and Elsewhere in Oregon and Beyond.

In total, 15,754 listings are at venues with an assigned area. The other 5,234 have no recorded area. Area counts on this site therefore describe only the listings that could be placed.

Topics and formats

Topics and formats were assigned by keyword rules applied to listing titles, combined with curated topics and a format chosen for each recurring group. Listing descriptions were not used for this.

A listing can carry several topics. The most common is Learning to Code, on 3,167 listings, followed by Startups and Entrepreneurs on 2,395 and Open Source, Linux and BSD on 2,301. The 27 topic counts therefore add up to more than the number of listings, and 3,571 listings match no topic.

Each listing has exactly one of 10 formats. A listing in a recurring group takes the group's format; any other listing whose title matches none of the format rules is counted under Meetings and User Groups. That format is the largest, with 9,909 listings, followed by Workshops and Classes with 2,743 and Socials, Coffees and Happy Hours with 2,173. These labels are editorial aids for browsing and do not come from Calagator.

Eras

The twenty years are divided into six eras: The Early Calendar, The Startup Surge, The Code School Years, Community Classrooms, The Remote Years and The AI Turn. Each era has its own page with a narrative written from the listings of those years.

Era names are editorial labels for reading the archive. They summarize patterns in the calendar and are not official periods.

Limits of the data

Listings are not attendance. A listing shows that an event was announced, not how many people came or whether it took place. Cancellations and later changes may not be reflected, because a listing records what was posted.

The calendar covered only what people chose to post. Events that were never posted to the calendar are not in the archive, so a fall in listings does not by itself show a fall in events.

The first and last years are partial. The archive holds only 2 listings for 2006, and 2026 runs only to October 3, with 206 listings. Comparisons with full years should allow for that.

Online counts include only listings placed in the Online area, 850 in all. They rose from 34 in 2019 to 231 in 2020. An online event that was not placed in that area is not counted as online, so these figures should be read with that in mind.

Categories

Formats

Areas

Eras