======================================================================== 7. FUNNEL ======================================================================== classified editorial rows 173133 (expected 173133) dropped, platform domain 12540 dropped, outlet not media-typed 32991 published base 127602 (expected 127602) of which country_code == GB 12094 (expected 12094) GB share of the base 9.5% ======================================================================== 1. UK ROWS WHOSE JOB TITLE NAMES THE ROYALS ======================================================================== rule: the job title matches \broyal (case-insensitive, word-start) raw matches, title only, of 12094 UK rows: 19 the scout's whole-word rule \broyal\b gives: 16 the word-start rule adds 3 rows, all of them plural Royals: Editor, Culture, Society (Home Affairs) and Royals BBC Foreign Desk Editor and Royals Commentator Coordinator NBC News Emea Assignment Editor - Music & Royals Getty Images hand-removed from the raw 19: 0 none. No UK row's title carries Royal Air Force, Royal Opera, Royal Shakespeare, Mount Royal or any other non-monarchy use of the word. Those appear in the headline, not the title, and the headline-inclusive figure below shows what they add. kept: 19 of 12094 UK rows noun in the kept titles: correspondent 8, editor 8, reporter 3 classifier role column: editor 8, correspondent 8, reporter 3 the kept rows, grouped by outlet (no names; a small named list is printed in full, so no cell is suppressed here): GB News (4) Deputy Royal Editor editor Royal Correspondent correspondent Royal Correspondent correspondent Royal Editor editor Daily Express (3) Deputy Royal Editor editor Royal Reporter reporter Royal Reporter reporter Daily Mirror (2) Deputy Royal Editor editor Royal Reporter reporter BBC (1) Editor, Culture, Society (Home Affairs) and Royals editor Getty Images (1) Emea Assignment Editor - Music & Royals editor ITN (1) Royal Correspondent correspondent ITV (1) Itv Royal Editor editor NBC News (1) Foreign Desk Editor and Royals Commentator Coordinator editor Newsweek (1) Chief Royal Correspondent correspondent PA Media (1) Royal Correspondent correspondent Sky News (1) Royal Correspondent correspondent The Telegraph (1) Entertainment & Royal Correspondent correspondent US Weekly (1) Royal Correspondent correspondent the phrase royal correspondent appears in 8 of the 19 kept titles. The other 11 read royal editor, deputy royal editor, royal reporter or name the royals inside a wider title. 15 of the 19 kept rows sit at an outlet table A puts in the United Kingdom; the other 4 are UK-located people at outlets table A puts elsewhere: Getty Images (United States), NBC News (United States), Newsweek (United States), US Weekly (United States) country_code is the person's own country, never the outlet's. headline included (title + " || " + headline), same regex: raw matches of 12094 UK rows: 43 of those, 24 match on the headline only 15 of the headline-only rows carry a non-monarchy Royal (Royal Air Force, Royal Opera House, Royal Caribbean, the Royal Society, the Royal Courts of Justice), which is why the report quotes the title-only figure. 2 the Royal Meteorological Society, a learned society 2 Royal Marines, an armed service, not the monarchy 1 Royal Air Force, an armed service, not the monarchy 1 Royal Opera House, an arts venue 1 the Royal Geographical Society, a learned society 1 a conservatoire, a music school 1 the Royal Television Society, an awards body 1 a writers' charity 1 a botanic garden 1 a court building, a law round not a royal one 1 a ballet company 1 Royal Caribbean, a cruise line 1 a Royal Society, a learned society ======================================================================== 2. UK ROWS WHOSE JOB TITLE NAMES CYBERSECURITY ======================================================================== rule: the job title matches \bcyber ?security\b|\bcyber-security\b matches, title only, of 12094 UK rows: 2 Cybersecurity Reporter Bloomberg Cybersecurity Reporter The Register headline included: 6 of 12094 UK rows + Reporter BBC (matched in the headline) + Journalist BBC (matched in the headline) + Editor-in-chief Matter Alpha (matched in the headline) + Senior Journalist Cybernews (matched in the headline) widened lexicon, title only. Each match names the word that matched. matches: 2 of 12094 UK rows Cybersecurity Reporter Bloomberg cybersecurity Cybersecurity Reporter The Register cybersecurity per word: cybersecurity 2, cyber (bare) 0, hacker 0, hacking 0, infosec 0, information security 0, ransomware 0, malware 0, data breach 0, surveillance 0, privacy 0, data protection 0, GDPR 0 widened lexicon, headline included: 8 of 12094 UK rows national security in the title, UK: 1 of 12094 rows. It is kept OUT of the lexicon: it names a defence and intelligence round, not a computer-security round. ======================================================================== 3. ROYAL, CYBER AND TECHNOLOGY TITLES AT THE LARGEST OUTLETS BY UK ROWS ======================================================================== UK rows = rows whose country_code is GB at that canonical outlet. Every column is a title-only count over those same UK rows. Both tables rank the same publishable canonical outlets the site's /outlets/ pages use: parent-company domains and outlets missing a name, a country or a type are excluded. TABLE A. The 25 largest outlets by UK-located rows, whatever country the outlet itself is in. outlet_country is the outlet's country, not the person's. rank outlet outlet country UK rows royal cyber wide tech 1 BBC United Kingdom 3074 1 0 0 4 2 The Guardian United Kingdom 466 0 0 0 3 3 ITV United Kingdom 446 1 0 0 1 4 The Times United Kingdom 422 0 0 0 2 5 The Telegraph United Kingdom 403 1 0 0 3 6 Financial Times United Kingdom 374 0 0 0 6 7 Sky News United Kingdom 292 1 0 0 3 8 Bloomberg United States 258 0 1 1 3 9 ITN United Kingdom 240 1 0 0 0 10 The Sun United Kingdom 226 0 0 0 0 11 PA Media United Kingdom 224 1 0 0 1 12 Daily Mirror United Kingdom 169 2 0 0 0 13 Daily Express United Kingdom 155 3 0 0 1 14 The Independent United Kingdom 154 0 0 0 1 15 Daily Mail United Kingdom 153 0 0 0 2 16 The New York Times United States 152 0 0 0 0 17 The Economist United Kingdom 149 0 0 0 1 18 Channel 4 United Kingdom 144 0 0 0 0 19 The Wall Street Journal (Dow J United States 107 0 0 0 0 20 CNN United States 106 0 0 0 0 21 The Tab United Kingdom 99 0 0 0 0 22 Reuters United Kingdom 92 0 0 0 0 23 GB News United Kingdom 85 4 0 0 0 24 The Standard United Kingdom 82 0 0 0 1 25 Associated Press United States 78 0 0 0 0 5 of the 25 are outlets table A puts outside the United Kingdom: Bloomberg, The New York Times, The Wall Street Journal (Dow Jones), CNN, Associated Press TABLE B. The 20 largest UK-country outlets by UK-located rows. Same columns, restricted to outlets whose own country is GB. rank outlet UK rows royal cyber wide tech 1 BBC 3074 1 0 0 4 2 The Guardian 466 0 0 0 3 3 ITV 446 1 0 0 1 4 The Times 422 0 0 0 2 5 The Telegraph 403 1 0 0 3 6 Financial Times 374 0 0 0 6 7 Sky News 292 1 0 0 3 8 ITN 240 1 0 0 0 9 The Sun 226 0 0 0 0 10 PA Media 224 1 0 0 1 11 Daily Mirror 169 2 0 0 0 12 Daily Express 155 3 0 0 1 13 The Independent 154 0 0 0 1 14 Daily Mail 153 0 0 0 2 15 The Economist 149 0 0 0 1 16 Channel 4 144 0 0 0 0 17 The Tab 99 0 0 0 0 18 Reuters 92 0 0 0 0 19 GB News 85 4 0 0 0 20 The Standard 82 0 0 0 1 GB News, 85 UK rows: 23rd of all outlets by UK rows, 19th of the UK-country outlets. Both ranks are printed because the report walks through it and it is in neither top 20 on the all-outlet ranking. table A: 24 of the 25 have no cybersecurity title, 9 have at least one royal title. table B: 20 of the 20 have no cybersecurity title, 9 have at least one royal title. ======================================================================== 4. CYBERSECURITY TITLES WORLDWIDE ======================================================================== title-only matches: 23 of 127602 rows, across 17 canonical outlets Cybersecurity Reporter Axios US Cybersecurity Tech News Reporter BleepingComputer RO Cybersecurity Reporter Bloomberg GB Cybersecurity Reporter CNN US Senior Cybersecurity Expert and Tech Reviewer Cybernews RS Tech and Cybersecurity Journalist Cybernews LT Cybersecurity Correspondent Newsweek US Cybersecurity Correspondent at Npr NPR US Cybersecurity Editor Politico US Cybersecurity Reporter Politico US Cybersecurity Reporter Politico US Cybersecurity and Intelligence Reporter Politico US Cybersecurity Editor & Deputy Tech Editor POLITICO Europe BE Cybersecurity Reporter POLITICO Europe BE Cybersecurity Correspondent Reuters US Senior Writer Editor, Cybersecurity TechCrunch US Senior Cybersecurity Reporter The Messenger US Cybersecurity Correspondent The New York Times US Cybersecurity Reporter The Record UA Senior Cybersecurity Reporter at the Record by Recorded The Record US Cybersecurity Reporter The Register GB Cybersecurity and Intelligence Reporter The Wall Street Journal (Dow US International Multimedia Journalist Cyber Security Spec Voice of America US by outlet: Politico 4, POLITICO Europe 2, The Record 2, Cybernews 2, Axios 1, Bloomberg 1, CNN 1, Voice of America 1, NPR 1, The New York Times 1, Reuters 1, The Messenger 1, The Register 1, BleepingComputer 1, Newsweek 1, TechCrunch 1, The Wall Street Journal (Dow Jones) 1 by country of the person: US 15, GB 2, BE 2, UA 1, RO 1, LT 1, RS 1 headline included: 57 of 127602 rows the 50 largest newsrooms on file, as the site's /outlets/ table ranks them (parent-company domains and untyped or unnamed outlets excluded), with their cybersecurity-title count: outlet rows cyber wide BBC 3935 0 0 The New York Times 2168 1 1 Bloomberg 1785 1 1 The Wall Street Journal (Dow Jones 1535 1 1 ABC News (Australia) 1194 0 0 Associated Press 1057 0 0 SABC 1043 0 0 CNN 1030 1 1 ESPN 957 0 0 Zee Media 939 0 0 AFP 865 0 0 Sveriges Radio 764 0 0 Deutsche Welle 732 0 0 The Guardian 718 0 0 Reuters 710 1 1 ETV Bharat 688 0 0 NDTV 670 0 0 ABC News 669 0 0 DR - Danmarks Radio 659 0 0 Financial Times 595 0 0 ITV 586 0 0 CBS News 577 0 0 NBC News 571 0 0 Sinclair Broadcast Group 537 0 0 Fox News Media 526 0 0 Fairfax Media 521 0 0 The Times 504 0 0 SVT 486 0 0 Los Angeles Times 470 0 0 The Telegraph 457 0 0 The Indian Express 446 0 0 USA Today 413 0 0 Forbes 406 0 0 RTE 405 0 0 News Corp Australia 397 0 0 ABS-CBN News 393 0 0 Anadolu Agency 383 0 0 Sky News 375 0 0 New York Post 373 0 0 CNBC 372 0 0 Vogue 349 0 0 The Globe and Mail 347 0 0 RTV Slovenija 341 0 0 ETV 333 0 0 South China Morning Post 328 0 0 Voice of America 327 1 1 PA Media 309 0 0 Mediacorp 305 0 0 Politico 299 4 5 India TV 298 0 1 43 of the 50 have none; 7 have at least one. widened lexicon, title only: 30 of 127602 rows per word: cybersecurity 23, cyber (bare) 5, hacker 0, hacking 0, infosec 0, information security 0, ransomware 0, malware 0, data breach 0, surveillance 1, privacy 2, data protection 0, GDPR 0 the widening adds 7 rows to the 23 cybersecurity titles: Cyber Journalist India TV cyber (bare) Cyber and Intelligence Reporter POLITICO Europe cyber (bare) Cyber-tech Senior Editor The Cipher Brief cyber (bare) Reporter Covering Digital Privacy and Federal Cybe The Record cyber (bare); privacy News Surveillance Research Editor Entertainment Weekly surveillance Privacy Reporter Politico privacy Cyber Journalist (Web Reporter) 7 News, Whdh-TV cyber (bare) headline included: 83 of 127602 rows privacy / data protection / GDPR in the title: 2 of 127602 rows Reporter Covering Digital Privacy and Federal Cybe The Record US privacy Privacy Reporter Politico US privacy headline included: 8 of 127602 rows at the 50 largest newsrooms: 1 UK rows: 0 of 12094 ======================================================================== 5. THE SAME UNIT FOR OTHER BEATS (title-only counts) ======================================================================== beat world per 1,000 UK per 1,000 technology 492 3.86 56 4.63 ai 63 0.49 11 0.91 crypto 42 0.33 3 0.25 sports 4877 38.22 528 43.66 health 590 4.62 68 5.62 politics 1633 12.80 230 19.02 royals (kept) 23 0.18 19 1.57 cybersecurity (this report) 23 0.18 2 0.17 cyber, widened 30 0.24 2 0.17 privacy 2 0.02 0 0.00 ======================================================================== 6. LEXICON PROVENANCE AND RECONCILIATION ======================================================================== this report's own regexes: royal (word-start), royal (whole word), cybersecurity (narrow), security (widened), privacy subset, national security (excluded), title noun, the royal hand-removal list the site classifier's own regexes, imported from data/classify.py: sports, politics, health, technology, ai, crypto, cybersecurity the classifier's cybersecurity beat regex over the job title: \b(cyber ?security|cyber|infosec|information security|hacking|ransomware|data breach)\b world 28 of 127602, UK 2 of 12094 this report's narrow cybersecurity regex over the job title: \bcyber ?security\b|\bcyber-security\b world 23 of 127602, UK 2 of 12094 the 5-row difference, every title: Cyber Journalist India TV IN Cyber Journalist (Web Reporter) 7 News, Whdh-TV US Cyber and Intelligence Reporter POLITICO Europe BE Cyber-tech Senior Editor The Cipher Brief US Reporter Covering Digital Privacy and Federal Cyber Policy The Record US all 23 rows of the narrow rule are inside the classifier's 28. The classifier's beat regex is what /journalists/cybersecurity/ counts, over title + headline; over the title alone it is the 28 above. Over title + headline, the field pair the classifier actually reads, the same regex reaches 72 rows worldwide and 8 UK rows. added to beat_title_counts.csv as cybersecurity (site classifier) beside cybersecurity (this report) 23. bare cyber, both forms, world titles: \bcyber\b(?! ?security) 5 of 127602 \bcyber\b 6 of 127602 the lexicon uses the lookahead. The one row plain cyber adds is already counted by the narrow cybersecurity rule, because its title spells the word with a space: International Multimedia Journalist Cyber Security Special Voice of America the hand-removal list over world titles: 4 of 27 raw royal matches - Royals Live Host & In-game Reporter Fanduel Sports Network Wes an in-game host at a regional sports broadcaster (FanDuel Sports Network), not a monarchy round - Kansas City Royals Reporter The Kansas City Star a baseball team - Associate Editor, Royal Shakespeare Company\'s Compl Palgrave Macmillan Royal Shakespeare Company, a theatre company - Managing Editor, Mount Royal Soccer (Part of the Sb Vox Media Mount Royal, a place name (Montreal) fetched_at over the 42 matched rows the CSVs publish: min 2026-07-23T20:46:16.188000 median 2026-08-06T09:52:53.763000 max 2026-08-12T07:21:13.989000 dedupe check. Rows at GB News whose title is exactly Royal Correspondent: 2. Distinct full_name among them: 2. Distinct company_domain among them: 1. The round-2 dedupe key is (full_name, title, company_domain), so two rows with one name could not both survive it; the count above says whether they are two people. No name is printed. ======================================================================== HEADLINES ======================================================================== UK rows whose title names the royals, kept: 19 of 12094 UK rows UK rows whose title names cybersecurity: 2 of 12094 UK rows world rows whose title names cybersecurity: 23 of 127602 rows, 17 outlets of the 50 largest newsrooms, with none: 43 of 50 wrote 8 CSVs, lexicon.txt and a copy of this script to static/data/britain-19-royal-journalists-2-cybersecurity-reporters/ === revision ids, for oldid permalinks BBC_News pageid 1139893 revid 1373835035 permalink https://en.wikipedia.org/w/index.php?title=BBC_News&oldid=1373835035 List_of_BBC_newsreaders_and_reporters pageid 69639010 revid 1184433269 permalink https://en.wikipedia.org/w/index.php?title=List_of_BBC_newsreaders_and_reporters&oldid=1184433269 Category:Royal_correspondents pageid 71851597 revid 1278331052 permalink https://en.wikipedia.org/w/index.php?title=Category:Royal_correspondents&oldid=1278331052 === wikipedia-bbc-news HTTP 200 87161 chars https://en.wikipedia.org/wiki/BBC_News infobox, number of employees: 7,000 (5,500 journalists) [ 1 ] Parent BBC Divisions BBC New body: "},"num_employees":{"wt":"7,000 (5,500 journalists)