Archival Research Report DuckDB Datalake Network Analysis October 2026

Signatory Network Map:
SCM Manifesto × UGtastic × SCMC

Of the 27,601 confirmed Software Craftsmanship Manifesto signatories in the datalake, 54 appear in Mike Hall's UGtastic interview archive or presented at SCMC meetings — connecting the written pledge to lived practice across Chicago-area developer communities.

54
Signatories Matched
52
UGtastic Interviews
3
SCMC Presenters
1
Both Connections
27,601
Total Signatories
28.3%
Interview Coverage

Methodology

27,601 SCM Manifesto signatories were loaded from the zdots DuckDB datalake (scm_signatories table, hydrated via the public REST API across 307 pages). Names were normalized and matched against 191 UGtastic interviewees (_data/interviews.yml, 184 recorded conversations) and 11 SCMC presenters (_data/scmc_videos.yml) using variant expansion — stripping parentheticals, middle initials, and quotes to maximize recall without false positives. The 28.3% figure reflects what fraction of people Mike interviewed are verifiable SCM Manifesto signatories.

UGtastic × SCMC Dual Presence

4 people appear in both the UGtastic interview archive and SCMC presentations — interviewed by Mike Hall and also presenting at the McHenry County user group he organized.

Igor Polevoy
Scott Seely
Andy Lester
Mike Jansen

Matched Signatories (54)

Sorted by signatory number (earliest signers first). The signatory number is the immutable database primary key from the SCM Manifesto ledger — the order in which each person signed relative to the full historical corpus.

# Name Connection Context
#2 Corey Haines
Cleveland, OH
🎙️ UGtastic Cranking Design to 11: Corey Haines on the Global Day of Code Retreat an... General + 1 more
#4 Micah Martin
Libertyville, IL
🎙️ UGtastic Community Building And User-group Organizing: Mike Hall Interviews Micah... SCNA 2014
#15 Dave Hoover
Chicago, IL, USA
🎙️ UGtastic The Apprenticeship Move: Dave Hoover on GeekFest and Developer Mentorship Geekfest
#16 Colin Jones
Mundelein, IL
🎙️ UGtastic Developer Education And Learning: Mike Hall Interviews Colin Jones | SCN... SCNA 2012
#17 Eric Smith
Vernon Hills, IL
🏠 SCMC HTML5 and JavaScript Game Development
#24 Zach Dennis
Grand Rapids, MI
🎙️ UGtastic Ruby And Rails Practice: Mike Hall Interviews Zach Dennis | SCNA 2012 SCNA 2012
#31 Cory Foy
Tampa, FL
🎙️ UGtastic Community Building And User-group Organizing: Mike Hall Interviews Cory ... SCNA 2012
#35 Gary Bernhardt
Cleveland, OH
🎙️ UGtastic Conference Speaking And Presentation Skills: Mike Hall Interviews Gary B... SCNA 2012
#49 Bobby Johnson
Olympia, WA
🎙️ UGtastic South Sound .net: Mike Hall Interviews Bobby Johnson | SCNA 2011 SCNA 2011
#110 Obie Fernandez
Jacksonville, FL
🎙️ UGtastic The Rails Way And Consulting Practice: Mike Hall Interviews Obie Fernand... RailsConf 2022
#141 Adewale Oshineye
London, United Kingdom
🎙️ UGtastic Mike Hall Interviews Adewale Oshineye on Software Craftsmanship | SCNA 2013 SCNA 2014
#177 Justin Searls
Columbus, OH
🎙️ UGtastic Community Building And User-group Organizing: Mike Hall Interviews Justi... SCNA 2013
#207 Tim Ottinger
Illinois
🎙️ UGtastic Software Craftsmanship And Practice: Mike Hall Interviews Tim Ottinger General
#223 Ethan Gunderson
Wisconsin
🎙️ UGtastic The Frictionless Web: Gathers.us and the Reality of 2012 NoSQL Gathers.us and ChicagoDB
#279 Hadi Hariri
Malaga, Spain
🎙️ UGtastic Developer Community And Conference Conversations: Mike Hall Interviews H... General
#349 Aaron Bedra
Chapel Hill, NC
🎙️ UGtastic Directed Practice: Aaron Bedra on Clojure Koans, Technical Writing, and ... General
#352 Dean Wampler
Chicago, IL
🎙️ UGtastic Conference Speaking And Presentation Skills: Mike Hall Interviews Dean W... GOTO Conference 2023
#405 Charley Baker
Denver, CO
🎙️ UGtastic Developer Community And Conference Conversations: Mike Hall Interviews C... General
#462 James Edward Gray II
Edmond, OK
🎙️ UGtastic Developer Community And Conference Conversations: Mike Hall Interviews J... General
#533 Matt Polito
Elgin, IL
🎙️ UGtastic Community Building And User-group Organizing: Mike Hall Interviews Matt ... SCNA 2012
#534 Chet Hendrickson
Farmington Hill, MI, USA
🎙️ UGtastic Visual Thinking in Agile: Chet Hendrickson & Ron Jefferies on Presentati... SCNA 2014
#557 Ken Auer
Holly Springs, NC
🎙️ UGtastic Developer Community And Conference Conversations: Mike Hall Interviews K... General
#569 Mark Simpson
Cambridge, MA
🎙️ UGtastic Community Building And User-group Organizing: Mike Hall Interviews Mark ... SCNA 2012
#592 Sergio Pereira
Grayslake, IL
🎙️ UGtastic Chicago Alt.NET: Mike Hall Interviews Sergio Pereira | SCNA 2011 SCNA 2011
#735 Stephen Anderson
Madison, WI, USA
🎙️ UGtastic Developer Community And Conference Conversations: Mike Hall Interviews S... General + 2 more
#1094 David Dickinson
South Bend, IN
🎙️ UGtastic Developer Community And Conference Conversations: Mike Hall Interviews D... General
#1144 Andrea Magnorsky
Dublin, Ireland
🎙️ UGtastic From Prototypes to Podcasts: Andrea Magnorsky on Game Jams, Alt.NET, and... General
#2026 Carl Erickson
Grand Rapids, MI, USA
🎙️ UGtastic Web Development And Frontend Practice: Mike Hall Interviews Carl Erickso... SCNA 2012
#2299 Michael Norton
Wadsworth, OH
🎙️ UGtastic Cleveland & Pittsburgh Community: Mike Hall Interviews Michael Norton | ... SCNA 2011
#2924 Jerry Cattell
Chicago, IL
🎙️ UGtastic Chicago Devops Community Organizing: Mike Hall Interviews Jerry Cattell ... GOTO Conference 2023
#3882 JC Grubbs
Chicago, IL
🎙️ UGtastic Web Development And Frontend Practice: Mike Hall Interviews JC Grubbs | ... ChicagoWebConf 2012
#4025 Ola Bini
Stockholm, Sweden
🎙️ UGtastic Conference Speaking And Presentation Skills: Mike Hall Interviews Ola Bi... GOTO Conference 2022
#4184 Steve Kim
Los Angeles, CA
🎙️ UGtastic Chicago Software Craftsmanship: Mike Hall Interviews Steve Kim Chicago Software Craftsmanship
#4520 Mike Clement
Orem, UT
🎙️ UGtastic Community Building And User-group Organizing: Mike Hall Interviews Mike ... SCNA 2012
#4788 Sandro Mancuso
London, UK
🎙️ UGtastic Developer Community And Conference Conversations: Mike Hall Interviews S... General + 2 more
#4810 Dustin Updyke
Pittsburgh, PA
🎙️ UGtastic Pittsburgh Sc: Mike Hall Interviews Dustin Updyke | SCNA 2011 SCNA 2011
#5717 Brad Wilkening
Chicago, IL
🎙️ UGtastic Conference Speaking And Presentation Skills: Mike Hall Interviews Brad W... SCNA 2012
#6043 Anna Lear
Waterloo, ON
🎙️ UGtastic Developer Community And Conference Conversations: Mike Hall Interviews A... General
#6046 Ryan Gerry
McHenry, IL
🎙️ UGtastic Community Building And User-group Organizing: Mike Hall Interviews Ryan ... GOTO Conference 2022
#6129 David Dickinson
South Bend, IN
🎙️ UGtastic Developer Community And Conference Conversations: Mike Hall Interviews D... General
#6648 Micah Martin
Charleston, SC
🎙️ UGtastic Community Building And User-group Organizing: Mike Hall Interviews Micah... SCNA 2014
#6875 Mike Lee
San Antonio, TX
🎙️ UGtastic Developer Community And Conference Conversations: Mike Hall Interviews M... General
#7586 Ross Beehler
South Bend, IN
🎙️ UGtastic Developer Community And Conference Conversations: Mike Hall Interviews D... General
#7942 Drew Shefman
Houston, TX, USA
🎙️ UGtastic Houston Adobe User Group: Mike Hall Interviews Drew Shefman | SCNA 2011 SCNA 2011
#8274 Mike Jansen
Chicago, IL
🎙️ UGtastic 🏠 SCMC Developer Education And Learning: Mike Hall Interviews Mike Jansen | SCN... SCNA 2012 TDD Your JavaScript With Backbone.js
#8489 Eric MacAdie
Chicago, Illinois
🎙️ UGtastic Ruby And Rails Practice: Mike Hall Interviews Eric MacAdie | WindyCityRa... WindyCityRails 2012
#9515 Sarah Gray
Chicago, IL
🎙️ UGtastic Conference Speaking And Presentation Skills: Mike Hall Interviews Sarah ... SCNA 2014
#10422 Eric Smith
Philadelphia, PA
🏠 SCMC HTML5 and JavaScript Game Development
#10472 Paul Baker
Salt Lake City, Utah
🎙️ UGtastic Developer Education And Learning: Mike Hall Interviews Paul Baker General
#11052 Ken Auer
Holly Springs, NC
🎙️ UGtastic Developer Community And Conference Conversations: Mike Hall Interviews K... General
#11270 Drew Shefman
Houston, TX
🎙️ UGtastic Houston Adobe User Group: Mike Hall Interviews Drew Shefman | SCNA 2011 SCNA 2011
#13178 Tony
Chicago
🎙️ UGtastic Refresh Chicago: Mike Hall Interviews John Refresh Chicago
#19366 John
South Africa
🎙️ UGtastic Refresh Chicago: Mike Hall Interviews John Refresh Chicago
#20663 Colin Jones
Mundelein, IL
🎙️ UGtastic Developer Education And Learning: Mike Hall Interviews Colin Jones | SCN... SCNA 2012

What This Map Reveals

Pledge → Practice

The 28.3% rate — 54 out of 191 UGtastic guests being verifiable signatories — suggests Mike's archive disproportionately captured people who had formally committed to the Craftsmanship movement, not just people who were nearby or available.

Early Signers Over-represented

The matched signatories skew heavily toward low signatory numbers — several appear in the first 600 of 27,601. These were people who signed in 2009–2010, at the founding moment, and who Mike was actively recording 2011–2015 at SCNA, GOTO, and local events.

SCMC as Local Nexus

3 signatory-matched SCMC presenters represent a direct pipeline: practitioners who pledged their craft online, then drove to McHenry County to share it in-person. The 4 UGtastic × SCMC overlaps are people who did all three: signed, presented locally, and were recorded.

Related Insights

⋂
Agile × Craftsmanship: The Manifesto Intersection
1,853 SCM signatories also signed the Agile Manifesto. 13 are in the UGtastic archive — people who stood at both founding moments. Plus: the "craftsmanship-first" signal (37 UGtastic interviewees in SCM but not Agile).
Data Sources & Provenance
  • SCM Signatories: 27,601 records from ~/.local/state/zdots/datalake.duckdb (scm_signatories table), hydrated from the full forensic investigation via 307 API pages
  • UGtastic Interviews: 184 interviews, 191 interviewees — _data/interviews.yml
  • SCMC Presentations: 11 recorded speakers — _data/scmc_videos.yml
  • Network Map Data: _data/research/signatory_network_map.json (generated 2026-10-02)
Navigational Directory • Living Research Corpus

Software Craftsmanship & Chicago Community History

Archival Lead: Mike Hall (SCMC Co-Founder • UGtastic Creator)
🏙️ Monograph & Origins
🔍 Forensics & Datalake
🏛️ Living History & Community
🤖 Philosophy & Age of AI