AI-Human Workflow for Extracting and Validating Datasets from Large Media Corpuses
Jacob Reidhead · National Chengchi University
Jacob Reidhead · National Chengchi University
AI and Machine Learning in Social Science: Promises and Potentials for Future Research
Panel 2 · LLM in Social Science Research: Methods & Applications
Ewha Womans University, Seoul · Friday, October 30, 2026
Rough estimate for reading only, before any coding. The full database would take one reader about twenty years.
| Step | Researcher decides | LLM contributes | Output | AI gain |
|---|---|---|---|---|
| 1 Prepare corpus | Scope, outlets, languages, years, search terms | Can write scrapers, clean, deduplicate, identify language, expand keyword forms. Here: keyword forms only, corpus pre-existed | Candidate corpus with stable IDs | varies |
| 2 Explore | Which dimensions to explore | Reads the whole candidate corpus; lists, typologizes, counts, clusters, traces over time | Corpus inventory, exploratory typology | transforms |
| 3 Framework | Unit, variables, categories, decision and evidence rules | Proposes typologies, stress-tests definitions, drafts codebook text | Codebook and machine-readable schema | assists |
| 4 Extract | Model, settings, sample, multiple instances per document | Applies the codebook to every document; records evidence and confidence | Instance-level dataset with evidence and confidence | transforms |
| 5 Validate | Sampling design, reliability thresholds, what to do with unreliable categories | One of several coders; re-codes after revision; summarizes disagreements | Reliability table, revised codebook, error log, frozen dataset | assists |
Table 1 of the paper. The researcher has the final word at Step 3; the model has the largest effect at Steps 2 and 4.

Joint project with Anar Shaikenova and Nygmet Ibadildin, KIMEP University, Almaty
Two decades of "failed or externally imposed" integration, then a revival of Central Asian summitry since 2018. Did the region decouple from Russia after February 2022, and if so, toward what?
Needs a dataset of cooperation instances coded by coordinator and sector over time. That is what the workflow produced.
Articles by year of publication. *2026 to June. Archive depth grows over time, so the analysis normalizes by candidate articles per year.
Query labels only select candidates. Coordinator and sector are coded from the text.
## Context "corpus.xlsx" - a dataset of articles from KZ media, selected by querying references to Eurasian integration ## Open-Ended Analysis 1. EXTRACTION_DIMENSION: themes, actors, countries, institutions and organizations, events, relations 2. Extract and read the document_text field of "corpus.xlsx" 3. For each EXTRACTION_DIMENSION, generate a list of relevant items, a typology, add a brief summary, list the article id ... 4. Write a general overview. 5. Including a summary of corpus statistics. 6. Display results as text and also export ... "1 Open-ended Analysis.pdf"
Run on an earlier candidate corpus of 6,962 articles (five outlets, 2021–2025). A second prompt asked for clusters and change over time.
We treated these numbers as hypotheses, not findings. They became H1–H4.
# Context ## CodeBook_CA integration Project_1.docx ## [coder1].xlsx, [coder2].xlsx - human coded articles on CAI # FIVE_VARIABLES: Relevance, Coordination_dimension, Sector_dimension, Bilateral_ca_cooperation, coder_confidence # Open [coder1].xlsx, [coder2].xlsx. For each of the FIVE_VARIABLES, group articles coded by each category # Use these article groups ... to expand the definition of each variable category in the codebook. # Create a copy of the codebook, CodeBook_CA integration Project_2.docx. Preserve the current structure ... update the definitions.
The single prompt we would most recommend. Grounding the definitions in the coders' own decisions is what "training" an LLM coder consists of.
| Variable | Values proposed |
|---|---|
| Relevance | 1 relevant · 0 not relevant |
| Coordination | Russia-led: EAEU; CSTO; CIS; Russia bilateral · Large-power-led: China (BRI, China–CA); United States (C5+1); EU (Global Gateway); Türkiye (OTS); Gulf states; Japan; South Korea; India; Iran · International: World Bank; ADB; EBRD; AIIB; UN agencies · Indigenous: Consultative Meetings of CA heads of state; CA bilateral; CA governments' own programs |
| Sector | Security; Defense; Border; Water; Environment; Climate; Energy; Oil and gas; Minerals; Electricity; Trade; Transport and corridors; Customs and logistics; Industry; Technology and digital; |
| Bilateral CA | 1 yes · 0 no |
| Confidence | 3 high · 2 medium · 1 low |
Every value with a definition, "code when" and "do not code when" rules drawn from the articles the coders had placed there (Figure 2). Far more values than the codebook kept: next slide.
The regionalism debate is about three contenders, not twenty-one actors. Development banks and UN agencies, companies by home country, and Central Asian governments' own programs are folded in by decision rule.
Fine-grained fields merged into the policy areas the literature compares. Finance dropped after the pilot; "People" added to hold education, culture, tourism and migration.
| Variable | Values | Rule |
|---|---|---|
| Relevance | 1 / 0 | Cooperation, coordination, partnership or integration among two or more Central Asian states or the region, whether or not the word "integration" appears |
| Coordination | Russia-led (EAEU, CSTO, CIS) · Large-power-led (China, US, EU, Türkiye, Gulf formats) · Indigenous (Central Asian governments) | Who primarily leads or facilitates. A mention of an external power does not by itself make an instance externally led. IFI- and UN-facilitated projects, company cooperation by home country, and CA governments' own programs: indigenous |
| Sector | Security · Water/Environment/Climate · Energy/Oil/Gas/Minerals · Trade/Transport/Logistics · Production/Industry/Technology/Digital · People · Multidimensional (residual) | Primary policy field, decided in order by headline, lead paragraph, main purpose, and bulk of discussion. Multidimensional when three or more sectors get comparable attention |
| Bilateral CA | 1 / 0 | Instance primarily concerns two Central Asian states (indigenous only) |
| Confidence | 3 / 2 / 1 | Coder's confidence in the decision; carried into the dataset and used to stratify validation |
Table 5, coding scheme after framework revision. The model's draft values were collapsed to what the regionalism literature can use: three coordinators and six sectors plus a residual. "Finance and investment" was dropped and "People" added after the pilot rounds (slide 16). The model's own earlier proposal, a 3×3 actor-by-action design, was set aside because the question is who coordinates, not who speaks.
# Context ## CodeBook_CA integration Project_2.xlsx - read the Variables, Sector_Codes and Coordination_Codes sheets; ignore the keyword dictionary ## corpus_2.0.xlsx - candidate articles, database v3.0 # Extract every instance of CA regional integration in one of SIX_SECTORS, coordinated by one of THREE_COORDINATORS. # Code the FIVE_VARIABLES; record evidence text and confidence. # Different sectors or coordinators in one article -> separate rows, each with its own Instance_ID. # Return nothing for an article with no relevant instance.
Practical issues: batched uploads, early stops, targeted manual corrections logged in the output's README.
| Coordinator | Instances | % | High conf. |
|---|---|---|---|
| Indigenous | 1,118 | 64.1 | 59.4% |
| Large-power-led | 436 | 25.0 | 89.7% |
| Russia-led | 189 | 10.8 | 93.1% |
Russia-led cooperation is signaled by institutional names; indigenous cooperation is a residual. Dropping medium-confidence rows removes indigenous instances disproportionately.
Same codebook, same unit of analysis, same evidence rules. Human coders: Alima and Alina, undergraduate research assistants at KIMEP University. Sample: 300 high- and 200 medium-confidence instances, drawn 28 July 2026.
| Claude | Coder 1 | Coder 2 | |
|---|---|---|---|
| Claude | — | ||
| Coder 1 | — | ||
| Coder 2 | — |
Pairwise Cohen's κ (large) and % agreement (small): coordination.
High-confidence stratum (n = 276 coordination, 164 sector) Medium-confidence stratum (n = 177, 60). Validation sample, 28 July 2026 (Table 7, Figure 5). The matrix on the previous slide is the high-confidence stratum.
Decision: analyze high-confidence instances only. Taken on reliability grounds, but not content-neutral.
| Step | Instances | Articles | Human- validated |
|---|---|---|---|
| Kazakhstan Media Database v3.0 | — | 1,655,741 | — |
| Nine Boolean queries → candidate articles | — | 13,640 | — |
| Extracted by the LLM (Step 4) | 1,743 | 1,716 | 500 |
| − 512 medium-confidence instances | 1,231 | 1,205 | 300 |
| − 24 judged not relevant by humans | 1,207 | 1,185 | 276 |
| − 7 multidimensional → analytic sample | 1,200 | 1,178 | 274 |
926 of the 1,200 analysis instances were never read by a human. Their relevance is inferred from the 92.0% confirmed in the 300-instance sample.
Known bias: medium-confidence instances are disproportionately indigenous, so the analysis understates the indigenous share. We report the direction wherever it matters.
Russia-led Large-power-led Indigenous. Analytic sample n = 1,200 (Table 9).
As reported in Kazakhstan's media, Russia's regional presence is a security presence; the Central Asian states' own cooperation is economic, environmental, and cultural.
Instances per 1,000 candidate articles, 2014–2026 (*to June). Table 10, Figure 6. Click a legend button to hide or show a series.
| P(coordinator) | Δ pp | (SE) |
|---|---|---|
| Large-power-led | +14.2*** | (2.9) |
| Indigenous | −11.3*** | (3.3) |
| Russia-led | −2.9 | (2.5) |
H2 supported; H1 only in qualified form; H3 not supported in share terms; H4 supported.
Tutorials, nine courses and this workshop at orgpowerlab.org/training.






All at National Chengchi University, Taipei. Student data scientists build and audit the databases; archival researchers collect and code. Collaborators and independent researchers co-author from partner institutions (Collaborate tab).