# funnel rows in data/journalists.csv.gz read: 173133 dropped, platform_domain == 1: 12540 dropped, media_typed == 0: 32991 published base: 127602 (expected 127602) rows at the 40 page outlets: 31911 (25.0% of 127602) rows with role reporter or editor, whole base: 100561 (78.8%) rows excluded from the ratio (other six roles): 27041 role reporter 46013 36.1% role editor 54548 42.7% role correspondent 5463 4.3% role columnist 2522 2.0% role anchor/presenter 8678 6.8% role producer 2856 2.2% role critic 897 0.7% role other-editorial 6625 5.2% reporter+editor rows at the 40: 25318 # collection window, fetched_at over the base earliest fetched_at: 2026-07-22T08:09:12.693000 latest fetched_at: 2026-09-15T10:07:27.109000 2026-07 45211 35.4% of 127602 2026-08 82383 64.6% of 127602 2026-09 8 0.0% of 127602 rows with no fetched_at: 0 # source of the outlet the row sits at (data/raw/outlets.csv.gz `source` column, carried onto the person row) source rows rep ed e/r r/e e/r-n pdl-core 75142 26048 32313 1.24 0.81 1.02 wikidata-org 23169 9523 9497 1.00 1.00 0.81 known-list 17753 7263 6639 0.91 1.09 0.81 wikidata-employer 11538 3179 6099 1.92 0.52 1.60 source rows sum: 127602 of 127602 # parent-company domains 8 of the 12 parent-company domains carry rows, 3313 rows in all with rows: foxcorporation.com, gettyimages.com, hearst.com, iheartmedia.com, paramount.com, pearson.com, skygroup.sky, voxmedia.com no rows: condenast.com, nbcuniversal.com, netflix.com, newscorp.com # item 1: the 40 outlets with pages, by editors per reporter # outlet country type rows rep ed corr e/r r/e e/r-n 1 The Indian Express India newspapers 446 90 255 73 2.83 0.35 1.23 2 ESPN United States broadcasters 957 226 600 16 2.65 0.38 2.24 3 Financial Times United Kingdom newspapers 595 128 313 99 2.45 0.41 2.25 4 The Telegraph United Kingdom newspapers 457 125 236 44 1.89 0.53 1.64 5 CNN United States broadcasters 1030 263 495 100 1.88 0.53 1.54 6 NDTV India broadcasters 670 194 362 65 1.87 0.54 1.08 7 The Times United Kingdom newspapers 504 140 258 56 1.84 0.54 1.24 8 The New York Times United States newspapers 2168 632 1144 169 1.81 0.55 1.57 9 ABS-CBN News Philippines online 393 121 215 26 1.78 0.56 0.74 10 ETV Bharat India online 688 238 418 9 1.76 0.57 1.61 11 The Guardian United Kingdom newspapers 718 204 354 71 1.74 0.58 1.27 12 Sky News United Kingdom broadcasters 375 104 179 47 1.72 0.58 1.57 13 CBS News United States broadcasters 577 158 259 88 1.64 0.61 1.38 14 Forbes United States online 406 124 188 11 1.52 0.66 1.41 15 Zee Media India broadcasters 939 304 410 70 1.35 0.74 0.52 16 ITV United Kingdom broadcasters 586 180 230 39 1.28 0.78 1.12 17 New York Post United States newspapers 373 148 189 <5 1.28 0.78 0.88 18 ABC News United States broadcasters 669 235 279 67 1.19 0.84 0.94 19 Sinclair Broadcast Group United States broadcasters 537 144 168 11 1.17 0.86 0.88 20 NBC News United States broadcasters 571 203 233 64 1.15 0.87 0.96 21 Fox News Media United States broadcasters 526 187 210 59 1.12 0.89 0.82 22 The Wall Street Journal (Dow Jones) United States newspapers 1535 676 726 62 1.07 0.93 0.97 23 USA Today United States newspapers 413 174 175 23 1.01 0.99 0.94 24 Los Angeles Times United States newspapers 470 178 172 12 0.97 1.03 0.81 25 CNBC United States broadcasters 372 143 136 41 0.95 1.05 0.78 26 Bloomberg United States online 1785 839 761 74 0.91 1.10 0.85 27 SABC South Africa broadcasters 1043 359 280 9 0.78 1.28 0.56 28 Fairfax Media Australia online 521 262 199 7 0.76 1.32 0.58 29 News Corp Australia Australia online 397 203 154 <5 0.76 1.32 0.65 30 RTE Ireland broadcasters 405 152 115 32 0.76 1.32 0.63 31 Reuters United Kingdom wire-agencies 710 224 160 284 0.71 1.40 0.67 32 Associated Press United States wire-agencies 1057 502 344 155 0.69 1.46 0.54 33 BBC United Kingdom broadcasters 3935 1957 1038 135 0.53 1.89 0.46 34 Deutsche Welle Germany broadcasters 732 379 198 101 0.52 1.91 0.46 35 AFP France wire-agencies 865 497 226 131 0.45 2.20 0.40 36 ABC News (Australia) Australia broadcasters 1194 641 246 27 0.38 2.61 0.31 37 Anadolu Agency Turkey wire-agencies 383 166 57 159 0.34 2.91 0.21 38 SVT Sweden broadcasters 486 409 63 6 0.15 6.49 0.13 39 DR - Danmarks Radio Denmark broadcasters 659 578 58 8 0.10 9.97 0.09 40 Sveriges Radio Sweden broadcasters 764 711 17 11 0.02 41.82 0.02 exact editors-per-reporter, ranks 20 to 40 (4 decimals, the sort key; ties broken by editorial rows): 20 NBC News 1.1478 rows 571 21 Fox News Media 1.1230 rows 526 22 The Wall Street Journal (Dow Jones) 1.0740 rows 1535 23 USA Today 1.0057 rows 413 24 Los Angeles Times 0.9663 rows 470 25 CNBC 0.9510 rows 372 26 Bloomberg 0.9070 rows 1785 27 SABC 0.7799 rows 1043 28 Fairfax Media 0.7595 rows 521 29 News Corp Australia 0.7586 rows 397 30 RTE 0.7566 rows 405 31 Reuters 0.7143 rows 710 32 Associated Press 0.6853 rows 1057 33 BBC 0.5304 rows 3935 34 Deutsche Welle 0.5224 rows 732 35 AFP 0.4547 rows 865 36 ABC News (Australia) 0.3838 rows 1194 37 Anadolu Agency 0.3434 rows 383 38 SVT 0.1540 rows 486 39 DR - Danmarks Radio 0.1003 rows 659 40 Sveriges Radio 0.0239 rows 764 narrow-editor ranking, all 40 (rank_narrow in the CSV): 1 Financial Times narrow 2.25 (2.2500) wide 2.45 (wide rank 3) 2 ESPN narrow 2.24 (2.2389) wide 2.65 (wide rank 2) 3 The Telegraph narrow 1.64 (1.6400) wide 1.89 (wide rank 4) 4 ETV Bharat narrow 1.61 (1.6050) wide 1.76 (wide rank 10) 5 The New York Times narrow 1.57 (1.5744) wide 1.81 (wide rank 8) 6 Sky News narrow 1.57 (1.5673) wide 1.72 (wide rank 12) 7 CNN narrow 1.54 (1.5399) wide 1.88 (wide rank 5) 8 Forbes narrow 1.41 (1.4113) wide 1.52 (wide rank 14) 9 CBS News narrow 1.38 (1.3797) wide 1.64 (wide rank 13) 10 The Guardian narrow 1.27 (1.2745) wide 1.74 (wide rank 11) 11 The Times narrow 1.24 (1.2429) wide 1.84 (wide rank 7) 12 The Indian Express narrow 1.23 (1.2333) wide 2.83 (wide rank 1) 13 ITV narrow 1.12 (1.1222) wide 1.28 (wide rank 16) 14 NDTV narrow 1.08 (1.0773) wide 1.87 (wide rank 6) 15 The Wall Street Journal (Dow Jones) narrow 0.97 (0.9749) wide 1.07 (wide rank 22) 16 NBC News narrow 0.96 (0.9606) wide 1.15 (wide rank 20) 17 USA Today narrow 0.94 (0.9425) wide 1.01 (wide rank 23) 18 ABC News narrow 0.94 (0.9362) wide 1.19 (wide rank 18) 19 Sinclair Broadcast Group narrow 0.88 (0.8819) wide 1.17 (wide rank 19) 20 New York Post narrow 0.88 (0.8784) wide 1.28 (wide rank 17) 21 Bloomberg narrow 0.85 (0.8462) wide 0.91 (wide rank 26) 22 Fox News Media narrow 0.82 (0.8235) wide 1.12 (wide rank 21) 23 Los Angeles Times narrow 0.81 (0.8146) wide 0.97 (wide rank 24) 24 CNBC narrow 0.78 (0.7832) wide 0.95 (wide rank 25) 25 ABS-CBN News narrow 0.74 (0.7355) wide 1.78 (wide rank 9) 26 Reuters narrow 0.67 (0.6741) wide 0.71 (wide rank 31) 27 News Corp Australia narrow 0.65 (0.6453) wide 0.76 (wide rank 29) 28 RTE narrow 0.63 (0.6316) wide 0.76 (wide rank 30) 29 Fairfax Media narrow 0.58 (0.5763) wide 0.76 (wide rank 28) 30 SABC narrow 0.56 (0.5599) wide 0.78 (wide rank 27) 31 Associated Press narrow 0.54 (0.5398) wide 0.69 (wide rank 32) 32 Zee Media narrow 0.52 (0.5164) wide 1.35 (wide rank 15) 33 Deutsche Welle narrow 0.46 (0.4644) wide 0.52 (wide rank 34) 34 BBC narrow 0.46 (0.4604) wide 0.53 (wide rank 33) 35 AFP narrow 0.40 (0.3964) wide 0.45 (wide rank 35) 36 ABC News (Australia) narrow 0.31 (0.3105) wide 0.38 (wide rank 36) 37 Anadolu Agency narrow 0.21 (0.2108) wide 0.34 (wide rank 37) 38 SVT narrow 0.13 (0.1271) wide 0.15 (wide rank 38) 39 DR - Danmarks Radio narrow 0.09 (0.0900) wide 0.10 (wide rank 39) 40 Sveriges Radio narrow 0.02 (0.0239) wide 0.02 (wide rank 40) # item 2a: type table, old base (typed, non-parent) against the new one (publishable only: typed, non-parent, with a name and a country) type old rows old outl old e/r | rows outlets e/r newspapers 44536 3116 1.22 | 44234 3062 1.22 broadcasters 52705 3139 0.90 | 52664 3115 0.89 online 16917 2236 1.86 | 16885 2216 1.86 wire-agencies 5450 60 0.65 | 5448 59 0.65 magazines 4222 183 4.54 | 4222 183 4.54 type rows: old 123830, new 123453, difference 377 (typed outlets with no publishable name or country) outlets dropped from the type table: 99 # item 2: editors per reporter by cut cut segment rows rep ed e/r r/e e/r-n outlet_type newspapers 44234 16485 20081 1.22 0.82 1.05 outlet_type broadcasters 52664 20595 18424 0.89 1.12 0.70 outlet_type online 16885 5000 9285 1.86 0.54 1.57 outlet_type wire-agencies 5448 2545 1665 0.65 1.53 0.55 outlet_type magazines 4222 595 2700 4.54 0.22 4.11 country United States 69377 22945 30040 1.31 0.76 1.12 country United Kingdom 12094 3479 6085 1.75 0.57 1.51 country India 7656 2432 3829 1.57 0.64 0.91 country Australia 4170 1770 1609 0.91 1.10 0.77 country Canada 3026 912 1601 1.76 0.57 1.56 country Sweden 1879 1593 195 0.12 8.17 0.10 country Germany 1643 848 546 0.64 1.55 0.58 country South Africa 1530 506 490 0.97 1.03 0.67 country Indonesia 1520 696 624 0.90 1.12 0.51 country France 1369 864 305 0.35 2.83 0.30 country Denmark 1125 960 121 0.13 7.93 0.11 country Brazil 1024 140 784 5.60 0.18 5.24 country Italy 907 324 403 1.24 0.80 1.02 country Singapore 787 201 389 1.94 0.52 1.65 country Spain 770 199 425 2.14 0.47 2.01 country Turkey 742 181 329 1.82 0.55 1.48 country Ireland 717 254 247 0.97 1.03 0.84 country Hong Kong 644 235 334 1.42 0.70 1.28 country Philippines 632 191 354 1.85 0.54 0.91 country Nigeria 605 276 202 0.73 1.37 0.57 country Pakistan 562 248 185 0.75 1.34 0.50 country Norway 550 467 55 0.12 8.49 0.10 country Belgium 536 281 144 0.51 1.95 0.44 country China 535 193 249 1.29 0.78 1.26 country Israel 530 153 281 1.84 0.54 1.47 country Egypt 525 277 181 0.65 1.53 0.52 country Netherlands 512 180 223 1.24 0.81 1.08 country Japan 506 147 193 1.31 0.76 1.21 country United Arab Emirates 503 141 204 1.45 0.69 1.13 country New Zealand 439 215 147 0.68 1.46 0.55 country Finland 408 278 92 0.33 3.02 0.26 country Mexico 406 72 256 3.56 0.28 3.25 country Bangladesh 395 181 139 0.77 1.30 0.43 country Slovenia 343 215 89 0.41 2.42 0.38 country South Korea 339 192 100 0.52 1.92 0.49 country Poland 323 180 116 0.64 1.55 0.48 country Kenya 289 153 78 0.51 1.96 0.41 country Argentina 279 28 224 8.00 0.12 7.21 country Russia 264 77 113 1.47 0.68 1.34 country Romania 263 82 133 1.62 0.62 1.05 country Portugal 236 100 92 0.92 1.09 0.79 country Lithuania 235 138 75 0.54 1.84 0.44 country Switzerland 223 137 54 0.39 2.54 0.22 group the 40 outlets with pages 31911 13198 12120 0.92 1.09 0.74 group every other outlet in the base 95691 32815 42428 1.29 0.77 1.08 all published base 127602 46013 54548 1.19 0.84 0.98 # item 3: correspondents as a share of editorial rows wire agency Associated Press rows 1057 corr 155 ( 14.7%) rep 502 ( 47.5%) wire agency AFP rows 865 corr 131 ( 15.1%) rep 497 ( 57.5%) wire agency Reuters rows 710 corr 284 ( 40.0%) rep 224 ( 31.5%) wire agency PA Media rows 309 corr 28 ( 9.1%) rep 153 ( 49.5%) wire agency Anadolu Agency rows 383 corr 159 ( 41.5%) rep 166 ( 43.3%) wire agency (group total, th rows 3324 corr 757 ( 22.8%) rep 1542 ( 46.4%) national newspaper The New York Times rows 2168 corr 169 ( 7.8%) rep 632 ( 29.2%) national newspaper The Wall Street Journal (Dow Jones rows 1535 corr 62 ( 4.0%) rep 676 ( 44.0%) national newspaper The Guardian rows 718 corr 71 ( 9.9%) rep 204 ( 28.4%) national newspaper Financial Times rows 595 corr 99 ( 16.6%) rep 128 ( 21.5%) national newspaper The Times rows 504 corr 56 ( 11.1%) rep 140 ( 27.8%) national newspaper Los Angeles Times rows 470 corr 12 ( 2.6%) rep 178 ( 37.9%) national newspaper The Telegraph rows 457 corr 44 ( 9.6%) rep 125 ( 27.4%) national newspaper The Indian Express rows 446 corr 73 ( 16.4%) rep 90 ( 20.2%) national newspaper USA Today rows 413 corr 23 ( 5.6%) rep 174 ( 42.1%) national newspaper New York Post rows 373 corr <5 ( 0.8%) rep 148 ( 39.7%) national newspaper (group to rows 6893 corr 586 ( 8.5%) rep 2173 ( 31.5%) national newspaper (group to rows 7679 corr 612 ( 8.0%) rep 2495 ( 32.5%) # item 4: role mix and top titles The New York Times: 2168 editorial rows role reporter 632 29.2% role editor 1144 52.8% role correspondent 169 7.8% role columnist 52 2.4% role anchor/presenter <5 0.1% role producer 0 0.0% role critic 19 0.9% role other-editorial 150 6.9% editor_kind text 995 87.0% of 1144 editors editor_kind photo 97 8.5% of 1144 editors editor_kind video 28 2.4% of 1144 editors editor_kind copy 23 2.0% of 1144 editors editor_kind audio <5 0.1% of 1144 editors title Reporter 197 9.1% title Journalist 75 3.5% title Photo Editor 67 3.1% title Staff Editor 62 2.9% title Senior Staff Editor 47 2.2% title Editor 45 2.1% title Senior Editor 43 2.0% title Staff Writer 34 1.6% title Correspondent 28 1.3% title Assistant Editor 25 1.2% editors whose title carries chief/executive/deputy/senior: 394 of 1144 editors (34.4%) BBC: 3935 editorial rows role reporter 1957 49.7% role editor 1038 26.4% role correspondent 135 3.4% role columnist 5 0.1% role anchor/presenter 668 17.0% role producer 26 0.7% role critic 19 0.5% role other-editorial 87 2.2% editor_kind text 901 86.8% of 1038 editors editor_kind photo 67 6.5% of 1038 editors editor_kind video 56 5.4% of 1038 editors editor_kind copy 9 0.9% of 1038 editors editor_kind audio 5 0.5% of 1038 editors title Journalist 419 10.6% title Broadcast Journalist 349 8.9% title Senior Journalist 150 3.8% title Senior Broadcast Journalist 138 3.5% title Radio Presenter 101 2.6% title Presenter 93 2.4% title Reporter 74 1.9% title Editor 73 1.9% title Assistant Editor 57 1.4% title Television Presenter 50 1.3% editors whose title carries chief/executive/deputy/senior: 207 of 1038 editors (19.9%) # item 4b: NYT and BBC by company domain (round 2) The New York Times, domains ['nytco.com', 'nytimes.com'] nytco.com rows 1801 rep 566 ed 963 e/r 1.70 r/e 0.59 nytimes.com rows 367 rep 66 ed 181 e/r 2.74 r/e 0.36 The New York Times, nytimes.com only: rows 367 rep 66 ed 181 e/r 2.74 r/e 0.36 BBC, domains ['bbc.co.uk', 'bbc.com', 'bbcstudios.com'] bbc.co.uk rows 3192 rep 1734 ed 635 e/r 0.37 r/e 2.73 bbc.com rows 463 rep 161 ed 248 e/r 1.54 r/e 0.65 bbcstudios.com rows 280 rep 62 ed 155 e/r 2.50 r/e 0.40 BBC excluding bbcstudios.com: rows 3655 rep 1895 ed 883 e/r 0.47 r/e 2.15 wrote classifier_rules.txt (10009 bytes from data/classify.py) wrote 5 CSVs to /Users/jakob/Documents/Python Projects/journalistlabs.com/static/data/nyt-two-editors-per-reporter-bbc-two-reporters-per-editor