# Task 2 — 10-row samples from tvviewers (read-only). NOT for git. ## ==== global_sports ==== global_id prog_type source_id source_table information_source country channel content_type week_day prog_date program ama_000 program_en alternative alternative_en comment nota secondary secondary_en program_secondary start_time end_time duration viewership_minutes_000 start_time_str end_time_str duration_str duration_minutes sub_genre sub_genre_id event_name sub_event parent_event event_context temp_event_name event_id match_level sub_match_level match_level_ai telecast_type telecast_platform telecast_platform2 pan_market metered_estimated broadcaster telecast_type_backup telecast_type_source event_gender event_agegroup sports_team1 sports_team2 sports_teams sports_teams_ai broadcast_day_date broadcast_start_time broadcast_end_time level genre_code genre_1 genre_2 genre_3 agb_type ama_pct shr_pct ttv_ama_pct ttv_ama_000 year_num month_num week_num lower_start_time daypart lower_end_time event_name_2 sub_genre_2 telecast_type_2 information_source_details info_1 info_2 info_3 notes created_at updated_at 65536 Program 1 italy_sports NULL Italy Rai 2 NULL Saturday 2025-01-04 RAI SPORT-DRIBBLING 235.0000 RAI SPORT-DRIBBLING Dribbling Dribbling NULL NULL NULL NULL RAI SPORT-DRIBBLING / 18:25:31 18:58:56 00:33:26 7856.833 18:25:31 18:58:56 00:33:26 33 NULL NULL NON_EVENT_STUDIO NULL NON_EVENT_STUDIO NULL NULL NULL NULL NULL NULL NON_EVENT NULL NULL NULL NULL NULL NON_EVENT NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 1 JK Sport non-defined n.a. Simple 0.40 1.90 22.10 12687.7000 2025 1 1 18 PRIME 19 NULL NULL NULL NULL NULL NULL NULL NULL 2026-03-16 03:27:23 2026-07-24 05:08:47 65537 Program 2 italy_sports NULL Italy Rai 2 NULL Saturday 2025-01-04 NOVANTESIMO MINUTO DEL SABATO 446.9000 NINETIETH MINUTE OF SATURDAY Novantesimo Minuto Ninetieth Minute NULL NULL NULL NULL NOVANTESIMO MINUTO DEL SABATO / 22:59:41 24:02:04 01:02:24 27886.560 22:59:41 24:02:04 01:02:24 62 NULL NULL NON_EVENT NULL NON_EVENT NULL NULL NULL NULL NULL NULL NON_EVENT NULL NULL NULL NULL NULL NON_EVENT NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 1 JK Sport non-defined n.a. Simple 0.80 3.60 21.90 12583.1000 2025 1 1 23 LATE_NIGHT 24 NULL NULL NULL NULL NULL NULL NULL NULL 2026-03-16 03:27:23 2026-07-24 05:08:47 65538 Program 3 italy_sports NULL Italy Rai 2 NULL Sunday 2025-01-05 RAI SPORT LIVE 237.9000 RAI SPORT LIVE NULL NULL NULL NULL NULL NULL RAI SPORT LIVE / 15:07:33 17:52:09 02:44:37 39162.305 15:07:33 17:52:09 02:44:37 165 NULL NULL NON_EVENT NULL NOT_AN_EVENT NULL NULL NULL NULL NULL NULL LIVE NULL NULL NULL NULL NULL LIVE NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 1 JK Sport non-defined n.a. Gross 0.40 1.90 21.60 12415.5000 2025 1 1 15 AFTERNOON 18 NULL NULL NULL NULL NULL NULL NULL NULL 2026-03-16 03:27:23 2026-08-12 04:39:14 65539 Program 4 italy_sports NULL Italy Rai 2 NULL Sunday 2025-01-05 RAI SPORT LIVE 277.2000 RAI SPORT LIVE NULL NULL NULL NULL NETTO NET RAI SPORT LIVE / NETTO 15:07:33 17:52:09 01:23:27 23132.340 15:07:33 17:52:09 01:23:27 83 NULL NULL NON_EVENT NULL NOT_AN_EVENT NULL NULL NULL NULL NULL NULL LIVE NULL NULL NULL NULL NULL LIVE NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2 JK Sport non-defined n.a. Net 0.50 2.20 22.00 12610.3000 2025 1 1 15 AFTERNOON 18 NULL NULL NULL NULL NULL NULL NULL NULL 2026-03-16 03:27:23 2026-08-12 04:39:14 65540 Program 5 italy_sports NULL Italy Rai 2 NULL Sunday 2025-01-05 RAI SPORT LIVE 128.4000 RAI SPORT LIVE NULL NULL NULL NULL PARZIALE PARTIAL RAI SPORT LIVE / PARZIALE 15:07:33 15:22:18 00:14:46 1896.040 15:07:33 15:22:18 00:14:46 15 NULL NULL NON_EVENT NULL NOT_AN_EVENT NULL NULL NULL NULL NULL NULL LIVE NULL NULL NULL NULL NULL LIVE NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2 JK Sport non-defined n.a. Partial 0.20 1.00 22.50 12906.8000 2025 1 1 15 AFTERNOON 15 NULL NULL NULL NULL NULL NULL NULL NULL 2026-03-16 03:27:23 2026-08-12 04:39:14 65541 Program 6 italy_sports NULL Italy Rai 2 NULL Sunday 2025-01-05 PALLAVOLO CAMPIONATO ITALIANO 197.4000 ITALIAN VOLLEYBALL CHAMPIONSHIP NULL NULL NULL NULL CIVITANOVA-VERONA CIVITANOVA-VERONA PALLAVOLO CAMPIONATO ITALIANO / CIVITANOVA-VERONA 15:22:19 16:43:28 01:21:10 16022.300 15:22:19 16:43:28 01:21:10 81 Volleyball NULL Italian SuperLega NULL Italian SuperLega NULL NULL NULL NULL NULL N/A LIVE NULL NULL NULL NULL NULL LIVE NULL NULL NULL CIVITANOVA VERONA CIVITANOVA|VERONA CIVITANOVA|VERONA NULL NULL NULL 2 JVC Sport volley-ball men's volley-ball Simple 0.30 1.60 21.30 12215.3000 2025 1 1 15 AFTERNOON 17 NULL NULL NULL NULL NULL NULL NULL NULL 2026-03-16 03:27:23 2026-07-24 05:08:47 65542 Program 7 italy_sports NULL Italy Rai 2 NULL Sunday 2025-01-05 RAI SPORT LIVE 309.2000 RAI SPORT LIVE NULL NULL NULL NULL PARZIALE PARTIAL RAI SPORT LIVE / PARZIALE 16:43:29 17:52:09 01:08:41 21236.887 16:43:29 17:52:09 01:08:41 69 NULL NULL NON_EVENT NULL NOT_AN_EVENT NULL NULL NULL NULL NULL NULL LIVE NULL NULL NULL NULL NULL LIVE NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2 JK Sport non-defined n.a. Partial 0.50 2.50 21.90 12546.6000 2025 1 1 17 PRIME 18 NULL NULL NULL NULL NULL NULL NULL NULL 2026-03-16 03:27:23 2026-08-12 04:39:14 65543 Program 8 italy_sports NULL Italy Rai 2 NULL Sunday 2025-01-05 PRES.LA DOMENICA SPORTIVA AL 90ESIMO 942.4000 PRESENTING THE SPORTS SUNDAY AT NINETIETH MINUTE NULL NULL NULL NULL NULL NULL PRES.LA DOMENICA SPORTIVA AL 90ESIMO / 22:51:19 23:23:59 00:32:41 30800.773 22:51:19 23:23:59 00:32:41 33 NULL NULL SPORTS MAGAZINE NULL NON_EVENT NULL NULL NULL PRELIMINARY NULL NULL STUDIO TV NULL NULL NULL NULL NON_EVENT NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 1 JK Sport non-defined n.a. Simple 1.60 6.00 27.30 15651.1000 2025 1 1 23 LATE_NIGHT 23 NULL NULL NULL NULL NULL NULL NULL NULL 2026-03-16 03:27:23 2026-08-14 06:28:58 65544 Program 9 italy_sports NULL Italy Rai 2 NULL Sunday 2025-01-05 LA DOMENICA SPORTIVA AL 90ESIMO 921.8000 SPORTS SUNDAY AT NINETIETH MINUTE La Domenica Sportiva... al 90' Sports Sunday... at 90' NULL NULL NULL NULL LA DOMENICA SPORTIVA AL 90ESIMO / 23:25:04 24:34:09 01:09:06 63696.380 23:25:04 24:34:09 01:09:06 69 NULL NULL SPORTS MAGAZINE NULL NON_EVENT NULL NULL NULL PRELIMINARY NULL NULL REVIEW TV NULL NULL NULL NULL NON_EVENT NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 1 JK Sport non-defined n.a. Simple 1.60 8.60 18.60 10676.0000 2025 1 1 23 LATE_NIGHT 25 NULL NULL NULL NULL NULL NULL NULL NULL 2026-03-16 03:27:23 2026-08-14 06:44:13 65545 Program 10 italy_sports NULL Italy Rai 2 NULL Sunday 2025-01-05 L'ALTRA DS 323.1000 THE OTHER DS NULL NULL NULL NULL NULL NULL L'ALTRA DS / 24:37:36 25:10:25 00:32:50 10608.450 24:37:36 25:10:25 00:32:50 33 NULL NULL NON_EVENT_STUDIO NULL NON_EVENT_STUDIO NULL NULL NULL NULL NULL NULL NON_EVENT NULL NULL NULL NULL NULL NON_EVENT NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 1 JK Sport non-defined n.a. Simple 0.60 5.50 10.20 5861.8000 2025 1 1 25 OVERNIGHT 25 NULL NULL NULL NULL NULL NULL NULL NULL 2026-03-16 03:27:23 2026-07-24 05:08:47 ## ==== global_sports_stats ==== country channel sub_genre event_name telecast_type week_day lower_start_time avg_ama_000 max_ama_000 median_ama_000 p95_ama_000 low_ama_000 shr_pct ama_pct ttv_ama_pct ttv_ama_000 avg_daily_rch_000 max_daily_rch_000 median_daily_rch_000 low_daily_rch_000 row_count updated_at Romania Antena 1 NULL NULL NULL Friday 7 455.3333 483.0000 446.0000 NULL 437.0000 28.067 2.633 9.333 1622.3333 NULL NULL NULL NULL 3 2026-03-19 16:56:37 Romania Antena 1 NULL NULL NULL Friday 8 465.0000 531.0000 454.0000 NULL 436.0000 20.500 2.667 13.067 2280.0000 NULL NULL NULL NULL 6 2026-03-19 16:56:37 Romania Antena 1 NULL NULL NULL Friday 20 751.3333 909.0000 739.0000 NULL 654.0000 10.411 4.311 41.378 7211.4444 NULL NULL NULL NULL 9 2026-03-19 16:56:37 Romania Antena 1 NULL NULL NULL Monday 7 450.0000 450.0000 450.0000 NULL 450.0000 25.500 2.600 10.100 1767.0000 NULL NULL NULL NULL 1 2026-03-19 16:56:37 Romania Antena 1 NULL NULL NULL Monday 8 513.5000 542.0000 513.5000 NULL 485.0000 22.950 2.950 12.850 2240.0000 NULL NULL NULL NULL 2 2026-03-19 16:56:37 Romania Antena 1 NULL NULL NULL Monday 20 670.0000 836.0000 642.0000 NULL 582.0000 9.075 3.813 42.313 7372.6250 NULL NULL NULL NULL 8 2026-03-19 16:56:37 Romania Antena 1 NULL NULL NULL Saturday 7 505.0000 576.0000 514.0000 NULL 436.0000 33.543 2.914 8.643 1505.8571 NULL NULL NULL NULL 7 2026-03-19 16:56:37 Romania Antena 1 NULL NULL NULL Saturday 8 494.5455 551.0000 502.0000 NULL 448.0000 21.664 2.845 13.191 2299.4545 NULL NULL NULL NULL 11 2026-03-19 16:56:37 Romania Antena 1 NULL NULL NULL Saturday 9 496.5000 536.0000 502.5000 NULL 445.0000 18.650 2.850 15.350 2676.5000 NULL NULL NULL NULL 4 2026-03-19 16:56:37 Romania Antena 1 NULL NULL NULL Saturday 20 695.2222 872.0000 665.0000 NULL 568.0000 9.778 3.978 40.833 7113.1111 NULL NULL NULL NULL 9 2026-03-19 16:56:37 ## ==== gl_ratings ==== gl_id gsiq_country gsiq_channel channel_group is_english standard_channel_name broadcaster telecast_platform telecast_platform_2 gl_territory gl_channel epg_id ti_total_day_share_bk ti_total_day_share channel_rating channel_rating_bk tvuniverse ti_prime_day_share low_ama_000 mean_ama_000 median_ama_000 max_ama_000 football_ama_000 tennis_ama_000 rugby_ama_000 cricket_ama_000 basketball_ama_000 motorsports_ama_000 athletics_ama_000 america_football_ama_000 gg_nonprime_mean_ama_000 gg_nonprime_median_ama_000 gg_nonprime_max_ama_000 gg_prime_mean_ama_000 gg_prime_median_ama_000 gg_prime_max_ama_000 is_hd_channel hd_confidence hd_info_source sd_share hd_share confidence_share prefer_gl_ratings_ama channel_genre channel_sub_genre channel_level real_id real_country real_channel parent_real_channel gs_map_country gs_map_channel gs_map_rating input_table_name gsiq_table gsiq_duplicate national_tv_viewers cumulative_tv_viewers ti_prime_day_viewers ti_total_day_share_clone channel_weight ya_total_day_share ya_prime_time_share daily_reach_percent cumulative_reach_percent cumulative_definition data_availability status genre access_type ti_td_viewers daily_tv_viewers channel_avghourly_reach source_data ref_channel_id notes delay_status delay_from_channel base_channel is_duplicate primary_duplicate_gl_id country_01 country_02 country_03 country_04 country_05 country_06 country_07 country_08 country_09 country_10 created_at updated_at 2 Argentina Canal 9 AR NULL yes Canal 9 Canal 9 FTA FTA Argentina Canal 9 AR 3421 1.800 0.481175 0.802771 0.802771 41045.40 4.000 15.000 115.000 90.000 280.000 55.000 8.000 5.000 0.000 6.000 4.000 3.000 1.000 210.000 190.000 450.000 350.000 320.000 850.000 0 40 API 100.00000 0.00000 40.00000 NULL Entertainment General Entertainment NULL NULL NULL NULL NULL United Kingdom TNT Sports 1 0.780000 epg_db.epg_data_3 EPG_DATA_3 NULL 18187000 NULL 727480 0.450 0.950 3.500 3.000 NULL NULL Yearly Programme Domestic Public REGIONAL/LOCAL FTA 800228 NULL NULL pratik NULL FTA network, broad general audience NULL NULL TNT Sports AR NULL 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2026-07-06 04:19:23 2026-08-07 12:12:53 3 Argentina El Trece AR NULL yes El Trece El Trece FTA FTA Argentina El Trece AR 3461 0.420 0.560355 0.189696 0.189696 41045.40 11.800 18.000 140.000 110.000 320.000 110.000 18.000 14.000 0.000 11.000 9.000 7.000 2.000 450.000 410.000 950.000 750.000 680.000 1800.000 0 60 API 80.00000 20.00000 60.00000 NULL Entertainment General Entertainment NULL NULL NULL NULL NULL United Kingdom TNT Sports 1 0.780000 epg_db.epg_data_3 EPG_DATA_3 NULL 18187000 NULL 2146066 0.850 0.900 10.000 10.700 NULL NULL Yearly Programme Private GENERALIST FTA 1927822 NULL NULL pratik NULL Top FTA network, strong share NULL NULL TNT Sports AR DUPLICATE_PRIMARY 3 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2026-07-06 04:19:23 2026-08-07 12:12:53 4 Argentina NetTV.ar NULL yes Net TV Grupo Perfil (Argentina) FTA FTA Argentina NetTV.ar 3527 1.000 0.689480 0.354649 0.354649 41045.40 0.500 39.200 174.000 147.000 392.000 9.000 1.000 1.000 0.000 1.000 1.000 1.000 0.000 35.000 30.000 80.000 60.000 50.000 130.000 0 50 API 100.00000 0.00000 50.00000 NULL Entertainment General Entertainment NULL NULL NULL NULL NULL United Kingdom TNT Sports 1 0.780000 epg_data.epg_all EPG_ALL NULL 18187000 NULL 90935 0.220 1.100 0.400 0.500 NULL NULL Yearly Programme Private GENERALIST FTA 90935 NULL NULL pratik NULL Newer FTA, growing slowly NULL NULL TNT Sports AR DUPLICATE_PRIMARY 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2026-07-06 04:19:23 2026-08-07 12:12:53 5 Argentina Telefe AR NULL yes Telefe Telefe FTA FTA Argentina Telefe AR 3548 0.550 0.096235 0.217188 0.217188 41045.40 18.800 7.467 31.000 28.000 48.000 135.000 22.000 16.000 0.000 12.000 10.000 8.000 2.000 550.000 500.000 1200.000 950.000 880.000 2500.000 0 50 API 100.00000 0.00000 50.00000 NULL Entertainment General Entertainment NULL NULL NULL NULL NULL United Kingdom TNT Sports 1 0.780000 epg_db.epg_data_3 EPG_DATA_3 NULL 18187000 NULL 3419156 0.900 0.900 18.800 22.600 NULL NULL Yearly Programme Private GENERALIST FTA 2837172 NULL NULL pratik NULL Top FTA channel, highest reach NULL NULL TNT Sports AR DUPLICATE_PRIMARY 5 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2026-07-06 04:19:23 2026-08-07 12:12:53 6 Argentina TV Pública AR NULL NULL TV Publica TV Pública AR FTA FTA Argentina TV Pública AR NULL 1.600 0.280178 0.632320 0.632320 41045.40 1.800 22.933 92.000 86.000 138.000 118.000 22.000 12.000 1.000 12.000 18.000 14.000 1.000 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL General Entertainment Public Broadcasting NULL NULL NULL NULL NULL United Kingdom TNT Sports 1 0.780000 NULL EPG_DATA_3 NULL 18187000 NULL 327366 1.700 NULL 1.500 1.900 NULL NULL Yearly Programme Domestic Public GENERALIST FTA 309179 NULL NULL NULL NULL NULL NULL NULL NULL DUPLICATE_PRIMARY 6 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2026-07-06 04:19:23 2026-08-07 12:12:53 14 Armenia ATV AM NULL yes ATV ATV (Turkuvaz Media Group) FTA FTA Armenia ATV AM 3599 1.000 0.853730 4.370629 4.370629 1716.00 5.700 1.413 8.300 5.300 21.000 4.000 1.000 0.000 0.000 1.000 0.000 0.000 0.000 18.000 15.000 45.000 35.000 30.000 85.000 0 70 API 100.00000 0.00000 80.00000 NULL Entertainment General NULL NULL NULL NULL NULL United Kingdom TNT Sports 1 0.780000 epg_db.epg_data_3 EPG_DATA_3 NULL 1716406 1366259 97835 0.820 0.950 4.600 4.400 17.500 79.600 Yearly Programme Private ENTERTAINMENT FTA 101268 300371 NULL pratik NULL Private broadcaster; strong entertainment programming NULL NULL ArmenianPublicTV.am NULL 14 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2026-07-06 04:19:23 2026-08-07 12:12:53 27 Australia 10 Bold AU NULL yes 10 Bold Network 10 FTA FTA Australia 10 Bold AU 3670 1.600 0.600000 0.600000 0.600000 25000.00 NULL 30.400 121.000 114.000 179.000 55.000 4.000 8.000 8.000 14.000 55.000 10.000 2.000 85.000 75.000 190.000 180.000 160.000 450.000 2 90 API 0.00000 100.00000 95.00000 NULL Entertainment General NULL NULL NULL NULL NULL United Kingdom TNT Sports 1 0.780000 epg_db.epg_data_3 EPG_DATA_3 NULL NULL NULL NULL 0.700 0.950 NULL NULL NULL NULL Yearly Programme Private GENERALIST FTA NULL NULL NULL pratik NULL FTA multichannel; reruns; moderate average audience NULL NULL Fox Footy AU NULL 27 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2026-07-06 04:19:23 2026-08-07 12:12:53 28 Australia 7Mate AU NULL yes 7mate Seven Network FTA FTA Australia 7Mate AU 3711 0.770 0.322000 0.322000 0.322000 25000.00 NULL 15.733 64.000 59.000 97.000 265.000 18.000 16.000 185.000 8.000 86.000 48.000 4.000 110.000 95.000 250.000 220.000 200.000 550.000 2 90 API 0.00000 100.00000 95.00000 NULL Entertainment General Entertainment NULL NULL NULL NULL NULL United Kingdom TNT Sports 1 0.780000 epg_db.epg_data_3 EPG_DATA_3 y NULL NULL NULL 0.820 0.950 NULL NULL NULL NULL Yearly Programme Private GENERALIST FTA NULL NULL NULL pratik NULL FTA multichannel; sport/men skew; higher share NULL NULL Fox Footy AU DUPLICATE_PRIMARY 28 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2026-07-06 04:19:23 2026-08-07 12:12:53 29 Australia 7TWO AU NULL yes 7two Seven Network FTA FTA Australia 7TWO AU 3724 1.800 0.678000 0.678000 0.678000 25000.00 NULL 34.400 137.000 129.000 202.000 70.000 10.000 6.000 55.000 4.000 20.000 22.000 1.000 90.000 80.000 210.000 190.000 170.000 480.000 2 90 API 0.00000 100.00000 95.00000 NULL Entertainment General Entertainment NULL NULL NULL NULL NULL United Kingdom TNT Sports 1 0.780000 epg_db.epg_data_3 EPG_DATA_3 y NULL NULL NULL 0.650 1.100 NULL NULL NULL NULL Yearly Programme Private GENERALIST FTA NULL NULL NULL pratik NULL FTA multichannel; general entertainment; moderate NULL NULL Fox Footy AU DUPLICATE_PRIMARY 29 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2026-07-06 04:19:23 2026-08-07 12:12:53 35 Australia Seven.au NULL yes Seven Seven Network OTT OTT Australia Seven.au 4146 0.740 0.208000 0.208000 0.208000 25000.00 NULL 10.133 41.000 38.000 63.000 435.000 60.000 22.000 520.000 15.000 78.000 255.000 8.000 320.000 280.000 750.000 650.000 580.000 1800.000 2 90 API 0.00000 100.00000 95.00000 NULL Entertainment General Entertainment NULL NULL NULL NULL NULL United Kingdom TNT Sports 1 0.780000 epg_data.epg_all EPG_ALL NULL NULL NULL NULL 2.300 0.900 NULL NULL NULL NULL Technical Programme Private GENERALIST FTA NULL NULL NULL pratik NULL Primary Seven network; very high reach NULL NULL Fox Footy AU NULL 35 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2026-07-06 04:19:23 2026-08-07 12:12:53 ## ==== india_channel_subgenre_stats ==== unique_id channel sub_genre max_avg_daily_rch_000 low_avg_daily_rch_000 avg_daily_rch_000 max_avg_ama_000 low_avg_ama_000 avg_ama_000 1 Sony Ten 3 Athletics 4403.190 664.830 1519.452 1036.770 489.600 807.259 2 Sony Sports Ten 3 Athletics 2066.770 562.580 1064.580 1012.330 389.580 647.817 3 Sony Ten 1 Athletics 4333.890 267.310 1126.638 1986.430 237.160 603.916 4 Sports18 1(v) Athletics 1339.230 288.570 706.036 966.370 231.830 553.078 5 Sony SIX(v) Athletics 1925.050 291.040 869.578 560.980 265.130 380.196 6 Sports18 2 Athletics 753.090 131.280 402.536 697.570 82.730 313.988 7 Sony Ten 2 Athletics 1187.920 235.800 567.816 605.850 175.690 299.449 8 DD Sports Athletics 1063.840 93.940 441.416 436.370 63.600 253.323 9 Sports18 Khel Athletics 930.870 108.260 327.444 381.570 53.450 248.667 10 Sports18 3(v) Athletics 876.910 117.230 349.169 447.690 92.240 219.473 ## ==== uk_channel_subgenre_stats ==== unique_id channel sub_genre max_avg_daily_rch_000 low_avg_daily_rch_000 avg_daily_rch_000 max_avg_ama_000 low_avg_ama_000 avg_ama_000 1 BBC 1 -none- 6254.000 3561.000 5112.400 4352.500 1617.500 3240.985 2 ITV1/Breakfast (inc. HD & +1) -none- 5958.000 2415.000 4219.275 3359.700 2082.900 2698.038 3 CH4 (Stagger) -none- 3363.000 1473.000 2317.200 2110.700 710.700 1206.025 4 BBC 2 -none- 2298.000 1276.000 1743.200 1631.500 585.100 1112.360 5 5 (Stagger) -none- 2252.000 548.000 1460.750 1496.000 423.200 794.300 6 E4 (Stagger) -none- 1960.000 351.000 1048.450 1297.900 180.500 577.745 7 Sky Sports Main Event -none- 2679.000 706.000 1602.300 1200.700 162.000 504.390 8 TNT Sports 2 -none- 1666.000 618.000 1170.750 563.400 114.700 354.500 9 ITV3 (Stagger) -none- 997.000 492.000 753.600 458.500 307.000 345.220 10 Sky Sports Golf -none- 2107.000 145.000 1025.000 652.800 56.100 257.443 ## ==== viewership_by_hour ==== hour_num hour_general_percentage hour_sports_percentage notes 0 0.08 0.35 Late night, niche events only 1 0.07 0.25 Falls further 2 0.06 0.18 Very low 3 0.05 0.12 Near trough 4 0.05 0.10 Bottom of the curve 5 0.10 0.15 Early risers, devotional/news 6 0.15 0.30 Morning bump 7 0.20 0.45 Morning commute, kids/news 8 0.25 0.50 Daytime starts 9 0.28 0.40 Light daypart viewing ## ==== tvuniverse ==== territory_id territory territory_type region continent world_region world_sub_region gdp_billion_usd priority_id map_country map_country_nat map_country_tvuniverse population total_individuals_2025 tvuniverse_percentage missing_channel_weight country_session_hard_max_pct country_day_hard_max_pct total_individuals_2024 cricket football tennis formula_1 athletics hockey horse_racing equestrian combat_sports rugby cycling baseball boxing wrestling bull_fighting kabaddi esports notes map_country_old total_individuals_agegroup total_individuals_old total_individuals_2024_ratio young_adults_agegroup youngadults total_day prime_time time_shifted_viewing sources population_ratio created_at updated_at 1 Argentina Country Latin America South America Latin America and the Caribbean South America 683.37 25 United Kingdom Italy 60580 45606.0000 41045.4000 90.000 0.30000 NULL NULL 45800 NULL 0.85 0.3 NULL NULL 0.25 NULL NULL NULL 0.25 0.1 NULL 0.2 NULL NULL NULL NULL NULL United Kingdom 4+ 18187 0.03889 20-34 4533 06:00-30:00 20:00-24:00 Live Kantar Ibope Media 0.03180 2026-07-07 05:49:39 2026-08-09 01:18:26 2 Armenia Country CIS Asia Asia Western Asia 27.86 118 United Kingdom India 60580 2780.0000 1716.0000 61.727 1.00000 NULL NULL 2300 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL United Kingdom 4+ 1716 0.00256 15-24 230 06:00-30:00 18:00-24:00 Live Admosphere Armenia CJSC 0.00194 2026-07-07 05:49:39 2026-08-09 01:18:26 4 Australia Country Anglophone Oceania Oceania Australia and New Zealand 1829.51 15 United Kingdom United Kingdom 60580 27309.0000 25000.0000 91.545 0.45000 NULL NULL 23500 0.55 NULL 0.55 NULL 0.28 0.3 NULL 0.08 NULL 0.35 0.2 0.1 NULL NULL NULL NULL NULL NULL United Kingdom 0+ 23500 0.02611 18-34 1634 02:00-26:00 18:00-22:30 Live + VOSDAL + 7 days Regional TAM / Nielsen Television Audience Measurement 0.01904 2026-07-07 05:49:39 2026-08-09 01:18:26 5 Austria Country Western Europe Europe Europe Western Europe 566.46 30 United Kingdom Germany 60580 8994.0000 8295.0000 92.228 0.65000 NULL NULL 7500 NULL NULL NULL NULL NULL NULL NULL 0.1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL United Kingdom 3+ 8295 0.00833 12-29 1701 03:00-27:00 20:00-23:00 Live + VOSDAL + 7 days AGTT / GfK 0.00627 2026-07-07 05:49:39 2026-08-09 01:18:26 6 Belgium Country Western Europe Europe Europe Western Europe 716.98 23 United Kingdom France 60580 11630.0000 10470.0000 90.026 0.65000 NULL NULL 9000 NULL NULL NULL NULL NULL 0.35 NULL 0.1 NULL NULL 0.6 NULL NULL NULL NULL NULL NULL NULL United Kingdom 4+ 10470 0.01000 15-34 2582 02:00-26:00 19:00-23:00 Live + VOSDAL + 7 days CIM / GfK Belgium 0.00811 2026-07-07 05:49:39 2026-08-09 01:18:26 9 Bosnia and Herzegovina Country Eastern Europe Europe Europe Southern Europe 33.24 112 United Kingdom Germany 60580 3422.0000 3366.0000 98.364 0.85000 NULL NULL 3366 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL United Kingdom 4+ 3366 0.00374 15-24 468 02:00-26:00 19:00-23:00 Live Audience Measurement 0.00239 2026-07-07 05:49:39 2026-08-09 01:18:26 10 Brazil Country Latin America South America Latin America and the Caribbean South America 2256.91 11 United Kingdom Italy 60580 217240.0000 184654.0000 85.000 0.20000 NULL NULL 200000 NULL 0.9 0.15 NULL 0.22 NULL NULL NULL NULL NULL 0.08 NULL 0.15 0.1 NULL NULL 0.15 NULL United Kingdom 4+ 71601 0.22222 18-34 18014 06:00-30:00 20:00-24:00 Live Kantar Ibope Media 0.15149 2026-07-07 05:49:39 2026-08-09 01:18:26 11 Bulgaria Country Central Europe Europe Europe Eastern Europe 127.92 67 United Kingdom Germany 60580 6714.0000 6626.0000 98.689 0.65000 NULL NULL 6500 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL United Kingdom 4+ 6626 0.00722 18-34 1230 06:00-30:00 19:00-24:00 Live + VOSDAL + 7 days Nielsen Admosphere Bulgaria JSC 0.00468 2026-07-07 05:49:39 2026-08-09 01:18:26 12 Cambodia Country Southeast Asia Asia Asia South-eastern Asia 48.80 98 United Kingdom India 60580 17847.9800 11601.1870 65.000 0.65000 NULL NULL 12000 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL United Kingdom 4+ 2977 0.01333 15-24 641 03:00-27:00 18:00-23:00 Live Kantar Media 0.01185 2026-07-07 05:49:39 2026-08-09 01:18:26 13 Cameroon Country Sub-Saharan Africa Africa Sub-Saharan Africa Middle Africa 60.58 91 United Kingdom France 60580 29879.3370 16433.6354 55.000 0.45000 NULL NULL 18000 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL United Kingdom 15+ 3700 0.02000 15-24 1450 05:00-29:00 NULL Live Médiamétrie 0.01953 2026-07-07 05:49:39 2026-08-09 01:18:26 ## ==== map_country_map_channel ==== id map_country sub_genre map_channel map_priority map_rating source_type source_note is_active map_confidence_score created_at updated_at 1 Canada Athletics CMT 1 1.2000 auto Auto from global_sports_stats | rows=7, slots=4, wdays=2, wavg_ama=7.16 1 1.0000 2026-02-21 14:55:21 2026-02-21 14:55:21 2 Canada Baseball TVA Sports 1 1.1400 auto Auto from global_sports_stats | rows=9, slots=9, wdays=7, wavg_ama=6.04 1 1.0000 2026-02-21 14:55:21 2026-02-21 14:55:21 3 Canada Baseball TVA Sports 2 2 1.0200 auto Auto from global_sports_stats | rows=6, slots=6, wdays=5, wavg_ama=6.20 1 0.8769 2026-02-21 14:55:21 2026-02-21 14:55:21 4 Canada Basketball TSN 1 1.2000 auto Auto from global_sports_stats | rows=14, slots=12, wdays=7, wavg_ama=112.41 1 1.0000 2026-02-21 14:55:21 2026-02-21 14:55:21 5 Canada Basketball SportsnetOne 2 1.0000 auto Auto from global_sports_stats | rows=14, slots=10, wdays=5, wavg_ama=22.93 1 0.8672 2026-02-21 14:55:21 2026-02-21 14:55:21 6 Canada Basketball TSN2 3 1.1800 auto Auto from global_sports_stats | rows=10, slots=8, wdays=4, wavg_ama=2.36 1 0.6680 2026-02-21 14:55:21 2026-02-21 14:55:21 7 Canada Combat Sports TVA Sports 2 1 1.0200 auto Auto from global_sports_stats | rows=13, slots=12, wdays=7, wavg_ama=6.25 1 1.0000 2026-02-21 14:55:21 2026-02-21 14:55:21 8 Canada Combat Sports Sportsnet360 2 0.9400 auto Auto from global_sports_stats | rows=5, slots=4, wdays=4, wavg_ama=21.08 1 0.8231 2026-02-21 14:55:21 2026-02-21 14:55:21 9 Canada Golf TSN 1 1.2000 auto Auto from global_sports_stats | rows=3, slots=3, wdays=3, wavg_ama=1.33 1 1.0000 2026-02-21 14:55:21 2026-02-21 14:55:21 10 Canada Golf TSN2 2 1.1800 auto Auto from global_sports_stats | rows=3, slots=3, wdays=3, wavg_ama=1.03 1 0.9785 2026-02-21 14:55:21 2026-02-21 14:55:21 ## ==== channel_match_ratings ==== id country channel channel_weight 1 India Asianet News 0.700 2 India Bansal News 0.400 3 India DD Sports 0.600 4 India DTamil 0.500 5 India Discovery Turbo 0.550 6 India STAR Sports 1 Kannada 1.000 7 India NDTV 24x7 0.650 8 India News Time Bangla 0.600 9 India Eurosport 0.700 10 India Sahara Samay MP/Chattisgarh 0.450 ## ==== country_alias ==== country_alias_id country alias_country confidence_score notes created_at updated_at 1 United Kingdom UK 100.00 Normalize UK to United Kingdom 2026-05-29 08:49:02 2026-05-29 08:49:02 2 United Kingdom U.K. 100.00 Normalize U.K. to United Kingdom 2026-05-29 08:49:02 2026-05-29 08:49:02 3 United Kingdom Great Britain 100.00 Normalize Great Britain to United Kingdom 2026-05-29 08:49:02 2026-05-29 08:49:02 4 United Kingdom Britain 100.00 Normalize Britain to United Kingdom 2026-05-29 08:49:02 2026-05-29 08:49:02 5 United States USA 100.00 Normalize USA to United States 2026-05-29 08:49:02 2026-05-29 08:49:02 6 United States US 100.00 Normalize US to United States 2026-05-29 08:49:02 2026-05-29 08:49:02 7 United States U.S. 100.00 Normalize U.S. to United States 2026-05-29 08:49:02 2026-05-29 08:49:02 8 United States United States of America 100.00 Normalize United States of America to United States 2026-05-29 08:49:02 2026-05-29 08:49:02 9 Turkey Türkiye 100.00 Normalize Türkiye / Turkiye to Turkey 2026-05-29 08:49:02 2026-05-29 08:49:02 10 UAE United Arab Emirates 100.00 Normalize United Arab Emirates to UAE 2026-05-29 08:49:02 2026-05-29 08:49:02 ## ==== pan_mapping ==== id country_name channel_name input_table_name continent world_region pan_channel_id pan_channel_name pan_region verified created_at updated_at 1 Saudi Arabia ART Aflam 1 SA epg_db.epg_data_4 NULL NULL NULL NULL NULL NULL 2025-12-12 12:54:59 2025-12-12 12:54:59 2 Mozambique Africanews.mz epg_data.bevy_programmes NULL NULL NULL NULL NULL NULL 2025-12-12 12:54:59 2025-12-12 12:54:59 3 Mozambique Afro Music (P).mz epg_data.bevy_programmes NULL NULL NULL NULL NULL NULL 2025-12-12 12:54:59 2025-12-12 12:54:59 4 Mozambique Al Jazeera.mz epg_data.bevy_programmes NULL NULL NULL NULL NULL NULL 2025-12-12 12:54:59 2025-12-12 12:54:59 5 Mozambique Best Brasil.mz epg_data.bevy_programmes NULL NULL NULL NULL NULL NULL 2025-12-12 12:54:59 2025-12-12 12:54:59 6 Mozambique CNN International.mz epg_data.bevy_programmes NULL NULL NULL NULL NULL NULL 2025-12-12 12:54:59 2025-12-12 12:54:59 7 Mozambique Cartoonito.mz epg_data.bevy_programmes NULL NULL NULL NULL NULL NULL 2025-12-12 12:54:59 2025-12-12 12:54:59 8 Mozambique Disney Channel (P).mz epg_data.bevy_programmes NULL NULL NULL NULL NULL NULL 2025-12-12 12:54:59 2025-12-12 12:54:59 9 Mozambique Disney Junior.mz epg_data.bevy_programmes NULL NULL NULL NULL NULL NULL 2025-12-12 12:54:59 2025-12-12 12:54:59 10 Mozambique ECO TV.mz epg_data.bevy_programmes NULL NULL NULL NULL NULL NULL 2025-12-12 12:54:59 2025-12-12 12:54:59 ## ==== event_country_interest_factor ==== id event_name event_id event_season country event_country_interest_factor notes created_at updated_at 1 Six Nations Championship NULL NULL United Kingdom 1.15 England, Wales, Scotland combined; free-to-air + strong legacy rivalry 2026-02-11 04:17:33 2026-02-22 05:37:37 2 Six Nations Championship NULL NULL France 1.40 Host nation with strong national engagement; free-to-air coverage drives significant uplift 2026-02-11 04:17:33 2026-02-18 18:12:20 3 Six Nations Championship NULL NULL Ireland 5.00 Extremely high per-capita rugby engagement 2026-02-11 04:17:33 2026-02-11 07:48:48 4 Six Nations Championship NULL NULL Italy 2.00 Moderate uplift due to national participation 2026-02-11 04:17:33 2026-02-11 04:53:10 5 Six Nations Championship NULL NULL Germany 1.05 Rugby niche; no additional event uplift 2026-02-11 04:17:33 2026-02-22 11:31:15 6 Six Nations Championship NULL NULL Netherlands 1.00 Neutral rugby interest 2026-02-11 04:17:33 2026-02-11 04:17:33 7 Six Nations Championship NULL NULL United States 1.00 Pay-TV/streaming; niche sport 2026-02-11 04:17:33 2026-02-11 04:17:33 8 Six Nations Championship NULL NULL Australia 1.00 Time-zone disadvantage 2026-02-11 04:17:33 2026-02-11 04:17:33 9 Six Nations Championship NULL NULL South Africa 1.10 Strong rugby culture but secondary interest 2026-02-11 04:17:33 2026-02-22 11:32:55 10 Six Nations Championship NULL NULL Canada 1.00 Limited rugby audience 2026-02-11 04:17:33 2026-02-11 04:17:33 ## ==== event_country_tvuniverse_factor ==== id event_name event_id event_season country tv_universe_000 event_ama_000 event_country_tvuniverse_percentage global_event_ama_000 country_perc_of_global_event_ama channel_1 channel_1_ama_000 channel_2 channel_2_ama_000 ott_1 ott_1_ama_000 ott_2 ott_2_ama_000 channel_3 channel_3_ama_000 channel_4 channel_4_ama_000 channel_5 channel_5_ama_000 notes created_at updated_at 945 United States F1 Grand Prix 1027 2026 United States 309118.000 2200.000 0.71170 76100.000 2.90000 NULL NULL NULL NULL Apple TV 2200.000 NULL NULL NULL NULL NULL NULL NULL NULL Home GP; 2026 US rights are Apple TV exclusive, no separate linear channel modeled. AMA is single-day/event, not cumulative. 2026-06-02 11:22:04 2026-08-10 06:31:01 946 United States F1 Grand Prix 1027 2026 United Kingdom 60580.000 6500.000 10.72961 76100.000 8.50000 Sky Sports F1 5300.000 NULL NULL NOW / Sky Go 1200.000 NULL NULL NULL NULL NULL NULL NULL NULL Top F1 market; Sky primary live rights, OTT modeled as incremental digital viewing. AMA is single-day/event, not cumulative. 2026-06-02 11:22:04 2026-08-10 06:31:01 947 United States F1 Grand Prix 1027 2026 Italy 58230.000 6800.000 11.67783 76100.000 8.90000 Sky Sport F1 5400.000 TV8 400.000 NOW / Sky Go 1000.000 NULL NULL NULL NULL NULL NULL NULL NULL Top F1 market; Sky primary with limited/free coverage modeled low. AMA is single-day/event, not cumulative. 2026-06-02 11:22:04 2026-08-10 06:31:01 948 United States F1 Grand Prix 1027 2026 Germany 75290.000 6500.000 8.63328 76100.000 8.50000 Sky Sport F1 5200.000 RTL 600.000 WOW / Sky Go 700.000 NULL NULL NULL NULL NULL NULL NULL NULL Top F1 market; Sky primary with RTL selected-race/free coverage modeled conservatively. AMA is single-day/event, not cumulative. 2026-06-02 11:22:04 2026-08-10 06:31:01 949 United States F1 Grand Prix 1027 2026 France 57614.000 4200.000 7.28989 76100.000 5.50000 Canal+ 3400.000 NULL NULL myCANAL 800.000 NULL NULL NULL NULL NULL NULL NULL NULL Strong European F1 market; Canal+ rights with OTT split. AMA is single-day/event, not cumulative. 2026-06-02 11:22:04 2026-08-10 06:31:01 950 United States F1 Grand Prix 1027 2026 Netherlands 16111.000 3500.000 21.72429 76100.000 4.60000 NULL NULL NULL NULL Viaplay 2800.000 F1 TV Pro 700.000 NULL NULL NULL NULL NULL NULL Very high F1 penetration; Verstappen-driven market, mostly streaming/pay platform. AMA is single-day/event, not cumulative. 2026-06-02 11:22:04 2026-08-10 06:31:01 951 United States F1 Grand Prix 1027 2026 Brazil 184654.000 4500.000 2.43699 76100.000 5.90000 TV Globo 2100.000 sportv 1700.000 Globoplay 500.000 F1 TV Pro 200.000 NULL NULL NULL NULL NULL NULL Large F1 market; Globo/sportv TV with smaller OTT split. AMA is single-day/event, not cumulative. 2026-06-02 11:22:04 2026-08-10 06:31:01 952 United States F1 Grand Prix 1027 2026 Spain 45665.000 3700.000 8.10249 76100.000 4.90000 DAZN F1 2800.000 NULL NULL DAZN 900.000 NULL NULL NULL NULL NULL NULL NULL NULL Strong F1 market; DAZN F1 channel/app distribution modeled together. AMA is single-day/event, not cumulative. 2026-06-02 11:22:04 2026-08-10 06:31:01 953 United States F1 Grand Prix 1027 2026 Mexico 112200.000 2500.000 2.22816 76100.000 3.30000 TUDN 750.000 Sky Sports 850.000 ViX 300.000 Sky+ 250.000 Izzi 350.000 NULL NULL NULL NULL Important Americas F1 market; TUDN/Sky/Izzi rights distribution. AMA is single-day/event, not cumulative. 2026-06-02 11:22:04 2026-08-10 06:31:01 954 United States F1 Grand Prix 1027 2026 Canada 37428.000 1900.000 5.07641 76100.000 2.50000 TSN 1200.000 RDS 250.000 TSN+ 250.000 NULL NULL RDS 2 100.000 Noovo 100.000 NULL NULL Top-10 F1 market; TSN/RDS primary live coverage. AMA is single-day/event, not cumulative. 2026-06-02 11:22:04 2026-08-10 06:31:01 ## ==== event_host_country_factor ==== id event_id event_name season_year host_country_name match_date host_country_factor confidence_score active_flag notes created_by created_at updated_at 1 NULL Monte Carlo Masters 2026 France NULL 1.1000 0.8000 1 General host-country uplift for Monte Carlo Masters 2026. Applies to all France channels for all match dates. manual 2026-05-04 09:24:25 2026-05-04 09:24:25 2 NULL UEFA Europa League 2026 Turkey 2026-05-20 1.0300 0.8000 1 Host-country uplift for UEFA Europa League Final 2025/26 held at Beşiktaş Park, Istanbul manual 2026-05-21 14:06:56 2026-05-22 14:17:50 3 NULL UEFA Europa League 2026 United Kingdom 2026-05-20 1.4000 0.8000 1 Team-country uplift for Aston Villa / UK interest in UEFA Europa League Final 2025/26 manual 2026-05-21 14:06:56 2026-05-21 14:06:56 4 NULL UEFA Conference League 2026 Germany 2026-05-27 1.1500 0.8000 1 Host-country uplift for UEFA Conference League Final hosted in Germany. manual 2026-05-30 11:09:48 2026-05-30 11:09:48 5 NULL UEFA Champions League 2026 Hungary 2026-05-30 1.1500 0.8000 1 Host-country uplift for UEFA Champions League Final 2026 hosted in Budapest, Hungary manual 2026-06-04 07:09:49 2026-06-04 07:09:49 6 89 French Open (Roland-Garros) 2026 France 2026-06-07 1.1000 0.8000 1 Host-country uplift for French Open / Roland-Garros Men's Final in France. manual 2026-06-09 01:08:47 2026-06-09 01:08:47 7 140 National Basketball Association (NBA) NULL China NULL 1.8000 0.8500 1 NBA China Games / international NBA game hosted in China or Macau. Apply uplift only when event is hosted there and broadcast country is China/Hong Kong/Macau as applicable. chatgpt 2026-07-07 07:11:46 2026-07-07 07:11:46 8 140 National Basketball Association (NBA) NULL France NULL 1.6000 0.8000 1 NBA Paris Games / international NBA game hosted in France. Apply uplift to host-country audience. chatgpt 2026-07-07 07:11:46 2026-07-07 07:11:46 9 140 National Basketball Association (NBA) NULL Mexico NULL 1.6000 0.8000 1 NBA Mexico City Games / international NBA game hosted in Mexico. Apply uplift to host-country audience. chatgpt 2026-07-07 07:11:46 2026-07-07 07:11:46 10 140 National Basketball Association (NBA) NULL UAE NULL 1.5000 0.7500 1 NBA Abu Dhabi Games / international NBA game hosted in UAE. Apply uplift to host-country audience. chatgpt 2026-07-07 07:11:46 2026-07-07 07:19:02 ## ==== sports_team_weight ==== id event_name event_id event_season event_season_key team_name team_country team_rank ama_team_weight weight_band city state alias total_matches_played total_won_matches total_lost_matches notes team_alias_1 team_alias_2 team_alias_3 team_alias_4 team_alias_5 team_alias_6 team_alias_7 created_at updated_at 1 NCAA Division I Men's Basketball Championship (March Madness) 781 NULL NO_SEASON Duke United States 1 1.50 Elite Draw NULL NULL NULL 149 124 25 Built like a top-end draw: seed 1, 2026 NET No. 1, and 124-25 across the last four D-I seasons. Championship pedigree and broad casual-viewer pull keep the AMA ceiling high. NULL NULL NULL NULL NULL NULL NULL 2026-04-06 04:09:08 2026-05-21 10:54:03 2 NCAA Division I Men's Basketball Championship (March Madness) 781 NULL NO_SEASON Arizona United States 3 1.47 Elite Draw NULL NULL NULL 146 115 31 Seed 1 with 2026 NET No. 3 and a 115-31 four-year base. Big 12 visibility and bracket familiarity translate into real national audience lift. NULL NULL NULL NULL NULL NULL NULL 2026-04-06 04:09:08 2026-05-21 10:54:03 3 NCAA Division I Men's Basketball Championship (March Madness) 781 NULL NO_SEASON Connecticut United States 10 1.46 Elite Draw NULL NULL NULL 152 125 27 Built like a top-end draw: seed 2, 2026 NET No. 10, and 125-27 across the last four D-I seasons. Championship pedigree and broad casual-viewer pull keep the AMA ceiling high. NULL NULL NULL NULL NULL NULL NULL 2026-04-06 04:09:08 2026-05-21 10:54:03 4 NCAA Division I Men's Basketball Championship (March Madness) 781 NULL NO_SEASON Florida United States 4 1.45 Elite Draw NULL NULL NULL 144 103 41 Built like a top-end draw: seed 1, 2026 NET No. 4, and 103-41 across the last four D-I seasons. SEC visibility and bracket familiarity translate into real national audience lift. NULL NULL NULL NULL NULL NULL NULL 2026-04-06 04:09:08 2026-05-21 10:54:03 5 NCAA Division I Men's Basketball Championship (March Madness) 781 NULL NO_SEASON Houston United States 5 1.45 Elite Draw NULL NULL NULL 151 130 21 Built like a top-end draw: seed 2, 2026 NET No. 5, and 130-21 across the last four D-I seasons. Big 12 visibility and bracket familiarity translate into real national audience lift. NULL NULL NULL NULL NULL NULL NULL 2026-04-06 04:09:08 2026-05-21 10:54:03 6 NCAA Division I Men's Basketball Championship (March Madness) 781 NULL NO_SEASON Michigan United States 2 1.44 Elite Draw NULL NULL NULL 141 88 53 No. 1 seed, 2026 NET No. 2, and a 88-53 four-year D-I record. Big Ten visibility and bracket familiarity translate into real national audience lift. NULL NULL NULL NULL NULL NULL NULL 2026-04-06 04:09:08 2026-05-21 10:54:03 7 NCAA Division I Men's Basketball Championship (March Madness) 781 NULL NO_SEASON Purdue United States 9 1.44 Elite Draw NULL NULL NULL 149 117 32 Built like a top-end draw: seed 2, 2026 NET No. 9, and 117-32 across the last four D-I seasons. Big Ten visibility and bracket familiarity translate into real national audience lift. NULL NULL NULL NULL NULL NULL NULL 2026-04-06 04:09:08 2026-05-21 10:54:03 8 NCAA Division I Men's Basketball Championship (March Madness) 781 NULL NO_SEASON Iowa State United States 6 1.42 Elite Draw NULL NULL NULL 142 102 40 Seed 2 with 2026 NET No. 6 and a 102-40 four-year base. Recent four-year results are strong enough to push the matchup factor above baseline. NULL NULL NULL NULL NULL NULL NULL 2026-04-06 04:09:08 2026-05-21 10:54:03 9 NCAA Division I Men's Basketball Championship (March Madness) 781 NULL NO_SEASON Gonzaga United States 7 1.42 Elite Draw NULL NULL NULL 140 113 27 No. 3 seed, 2026 NET No. 7, and a 113-27 four-year D-I record. WCC visibility and bracket familiarity translate into real national audience lift. NULL NULL NULL NULL NULL NULL NULL 2026-04-06 04:09:08 2026-05-21 10:54:03 10 NCAA Division I Men's Basketball Championship (March Madness) 781 NULL NO_SEASON Michigan State United States 11 1.41 Elite Draw NULL NULL NULL 141 98 43 Built like a top-end draw: seed 3, 2026 NET No. 11, and 98-43 across the last four D-I seasons. Championship pedigree and broad casual-viewer pull keep the AMA ceiling high. NULL NULL NULL NULL NULL NULL NULL 2026-04-06 04:09:08 2026-05-21 10:54:03 ## ==== match_level_weights ==== id match_level weight 1 REGULAR 1.000 2 GROUP 1.000 3 LEAGUE 1.000 4 QUALIFIER 1.150 5 ROUND_OF_32 1.150 6 ROUND_OF_16 1.250 7 PLAYOFF 1.250 8 ELIMINATOR 1.300 9 QUARTER_FINAL 1.400 10 SEMI_FINAL 1.700 ## ==== match_level_weight_by_event ==== id event_name season_name sport match_level normalized_match_level match_level_weight notes created_at updated_at 1 ICC Men's T20 World Cup 2026 Cricket Group Match NULL 1.0000 Base weight for group-stage matches 2026-03-31 17:52:26 2026-03-31 17:52:26 2 ICC Men's T20 World Cup 2026 Cricket Super 8 NULL 1.1500 Higher importance than group stage 2026-03-31 17:52:26 2026-03-31 17:52:26 3 ICC Men's T20 World Cup 2026 Cricket Semi Final NULL 1.3000 Knockout uplift 2026-03-31 17:52:26 2026-03-31 17:52:26 4 ICC Men's T20 World Cup 2026 Cricket Final NULL 1.5000 Highest importance match 2026-03-31 17:52:26 2026-03-31 17:52:26 5 FIFA World Cup 2026 Football Group Match NULL 1.0000 Base weight for group-stage matches 2026-04-02 03:47:44 2026-04-02 03:47:44 6 FIFA World Cup 2026 Football Round of 16 NULL 1.1500 First knockout round 2026-04-02 03:47:44 2026-04-02 03:47:44 7 FIFA World Cup 2026 Football Quarter Final NULL 1.2500 High-stakes knockout match 2026-04-02 03:47:44 2026-04-02 03:47:44 8 FIFA World Cup 2026 Football Semi Final NULL 1.3500 Final four stage 2026-04-02 03:47:44 2026-04-02 03:47:44 9 FIFA World Cup 2026 Football Final NULL 1.5000 Highest importance match 2026-04-02 03:47:44 2026-04-02 03:47:44 10 Olympic Games 2026 Multi-Sport Qualification / Heats NULL 0.9000 Early-round qualification events 2026-04-02 03:48:08 2026-04-02 03:48:08 ## ==== event_fallback_mapping ==== id primary_event_id primary_event_name primary_event_multiplier fallback_event_id_1 fallback_event_name_1 fallback_event_multiplier_1 fallback_event_id_2 fallback_event_name_2 fallback_event_multiplier_2 fallback_event_id_3 fallback_event_name_3 fallback_event_multiplier_3 fallback_event_id_4 fallback_event_name_4 fallback_event_multiplier_4 notes created_at updated_at 1 40 FIFA World Cup 1.0000 9 Under-19 Cricket World Cup 0.7800 4 ICC World Test Championship 0.7600 1661 Amateur Golf Championship 0.5500 21 Zim Afro T10 0.4200 NULL 2026-04-27 04:18:23 2026-07-24 07:14:39 2 722 Olympic Games 1.0000 952 Olympics 1.0000 1524 Olympic Games Paris 2024 0.9800 1042 Eurosport Olympics 0.8200 1395 More Paralympics Live: Paris 2024 0.2800 NULL 2026-04-27 04:27:22 2026-04-27 04:27:22 3 91 US Open 1.0000 1247 U.S. Open 2024 1.0000 966 Tennis Grand Slam Tournament 0.9800 90 Wimbledon 1.0500 89 French Open (Roland-Garros) 0.9400 NULL 2026-04-27 04:36:18 2026-04-27 04:36:18 4 693 Euro 2024 1.0000 42 UEFA European Championship (Euro) 1.0000 40 FIFA World Cup 1.2500 58 UEFA Champions League 0.9000 1930 UEFA World Cup Qualifiers 0.6000 NULL 2026-04-27 04:36:35 2026-04-27 04:36:35 6 1386 Super Bowl LVIII 1.0000 1913 Super Bowl 1.0000 1579 NFL Conference Championship 0.4600 1577 NFL Divisional Round 0.3200 1574 NFL Wild Card Round 0.2400 NULL 2026-04-27 04:42:35 2026-04-27 04:42:35 7 1524 Olympic Games Paris 2024 1.0000 722 Olympic Games 1.0000 952 Olympics 1.0000 1395 More Paralympics Live: Paris 2024 0.3500 636 Summer Olympics (Modern Pentathlon) 0.1800 NULL 2026-04-27 04:42:53 2026-04-27 04:42:53 8 1806 NFL Sunday Night Football 1.0000 1437 Live NFL: Monday Night Football 0.9200 1814 Thursday Night Football 0.7200 1500 Live: NFL Football 0.8800 649 National Football League (NFL) 0.8500 NULL 2026-04-27 04:43:54 2026-04-27 04:43:54 9 42 UEFA European Championship (Euro) 1.0000 693 Euro 2024 1.0000 40 FIFA World Cup 1.2200 58 UEFA Champions League 0.6200 660 UEFA Nations League 0.4800 NULL 2026-04-27 04:47:54 2026-04-27 04:47:54 10 118 Summer Olympics (Athletics) 1.0000 119 World Athletics Championships 0.6500 121 Diamond League Series 0.3500 126 European Athletics Championships 0.3000 610 Asian Games (Athletics) 0.2800 NULL 2026-04-27 04:50:13 2026-04-27 04:50:13 12 649 National Football League (NFL) 1.0000 1500 Live: NFL Football 1.0000 1806 NFL Sunday Night Football 1.1500 1437 Live NFL: Monday Night Football 0.9500 1814 Thursday Night Football 0.7500 NULL 2026-04-27 04:53:34 2026-04-27 04:53:34 ## ==== event_category_map ==== id priority_id event_name standard_event_name parent_event_name sub_genre genre_id weight global_linear_mean_ama_000 global_linear_median_ama_000 global_linear_max_ama_000 global_ott_mean_ama_000 global_ott_median_ama_000 global_ott_max_ama_000 duration_minutes uk_event_name uk_sub_genre india_event_name india_sub_genre country match_format matches_count teams_count traditional_tv_viewership ott_viewership organizer frequency event_level duplicate_status duplicate_id key_interest_countries China India United States Indonesia Pakistan Brazil Nigeria Bangladesh Russia Mexico Japan Egypt Philippines DR Congo Vietnam Iran Turkey Germany Thailand United Kingdom France Tanzania South Africa Italy Myanmar Kenya South Korea Colombia Spain Uganda Argentina Algeria Sudan Ukraine Iraq Afghanistan Poland Canada Morocco Uzbekistan Malaysia Mozambique Ghana Peru Saudi Arabia Madagascar Côte d'Ivoire Cameroon Nepal Venezuela Australia North Korea Niger Mali Syria Taiwan Burkina Faso Sri Lanka Malawi Zambia Kazakhstan Chile Chad Romania Somalia Guatemala Netherlands Ecuador Cambodia Senegal Zimbabwe Guinea Rwanda Benin Burundi Tunisia Bolivia Belgium Haiti Cuba South Sudan Dominican Republic Czech Republic Greece Portugal Jordan Azerbaijan Sweden Honduras United Arab Emirates Hungary Belarus Austria Switzerland Croatia Oman Liberia Panama Kuwait Mauritania Georgia Moldova Uruguay Bosnia and Herzegovina Mongolia Armenia Albania Jamaica Lithuania Namibia Gambia Botswana Lesotho Qatar Slovenia North Macedonia Latvia Kosovo Bahrain Trinidad and Tobago Estonia Timor-Leste Mauritius Cyprus Republic of Moldova Guinea-Bissau Gabon Comoros Solomon Islands Eswatini Equatorial Guinea Djibouti Réunion Fiji Maldives Cape Verde description 1 40 ICC Cricket World Cup NULL NULL Cricket 1 100.00 45000.000 38000.000 110000.000 13500.000 11000.000 36000.000 NULL ICC Cricket World Cup Cricket ICC World Cup CRICKET International ODI 48 10 170000 60000 ICC Every 4 years International Tournament NULL NULL India, Pakistan, Bangladesh, United Kingdom, Australia NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL

BARC India (official TV measurement body) released:

\n \n \n \n

 

\n \n

Disney+ Hotstar reported Peak concurrency

\n \n 2 45 ICC Men's T20 World Cup NULL NULL Cricket 1 95.00 38000.000 32000.000 95000.000 14000.000 11500.000 42000.000 NULL ICC World T20 Cricket Cricket ICC World Cup T20 CRICKET International T20 55 20 140000 50000 ICC Every 2 years International Tournament NULL NULL India, Pakistan, Bangladesh, Australia, United Kingdom NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 3 53 ICC Champions Trophy NULL NULL Cricket 1 77.50 32000.000 27000.000 80000.000 9600.000 8200.000 26000.000 NULL ICC Champions Trophy One-Day International Cricket Cricket ICC Champions Trophy CRICKET International ODI 15 8 110000 30000 ICC Irregular International Tournament NULL NULL India, Pakistan, Bangladesh, South Africa, United Kingdom NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 4 63 ICC World Test Championship NULL NULL Cricket 1 40.00 22000.000 18500.000 52000.000 6600.000 5500.000 17000.000 NULL ICC World Test Championship Cricket ICC World Test Championship CRICKET International Test 69 9 50000 20000 ICC 2-year cycle International Tournament NULL NULL India, Australia, United Kingdom, South Africa, New Zealand NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 5 57 Asia Cup NULL NULL Cricket 1 65.00 26000.000 21500.000 70000.000 7800.000 6500.000 21000.000 NULL NULL NULL ASIA CUP CRICKET CRICKET Asia ODI/T20 13 6 80000 30000 Asian Cricket Council Every 2 years International Tournament NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 6 134 Commonwealth Games (Cricket) NULL NULL Cricket 1 27.50 8000.000 4500.000 24000.000 3600.000 3000.000 9600.000 NULL NULL NULL Commonwealth Games (Cricket) CRICKET Commonwealth T20 (Women) 16 8 10000 4000 Commonwealth Games Federation Occasional Multi-sport Event NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 7 314 ICC Women's Cricket World Cup NULL NULL Cricket 1 30.00 2500.000 1450.000 6500.000 5400.000 4500.000 15000.000 NULL ICC Women's World Cup Cricket Women's Cricket World Cup CRICKET International ODI 31 8 25000 10000 ICC Every 4 years International Tournament NULL NULL India, Australia, United Kingdom, South Africa, New Zealand NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 8 275 Women's T20 World Cup NULL NULL Cricket 1 45.00 3250.000 1900.000 9100.000 6400.000 5300.000 18000.000 NULL ICC Women's World T20 Cricket ICC WOMENS T20 WORLD CUP CRICKET International T20 23 10 30000 15000 ICC Every 2 years International Tournament NULL NULL India, Australia, United Kingdom, South Africa, Bangladesh NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 9 343 Under-19 Cricket World Cup NULL NULL Cricket 1 32.50 2000.000 1100.000 6000.000 2400.000 1900.000 7000.000 NULL ICC Under-19 Cricket World Cup Cricket Under-19 Cricket World Cup CRICKET International ODI (U19) 41 16 12000 5000 ICC Every 2 years International Tournament NULL NULL India, Pakistan, Bangladesh, South Africa, Sri Lanka NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 10 54 Indian Premier League (IPL) NULL NULL Cricket 1 100.00 30000.000 25500.000 85000.000 13500.000 11000.000 38000.000 NULL Indian Premier League Cricket IPL CRICKET India T20 74 10 40000 20000 BCCI Annual Franchise League NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL ## ==== fixture_interest ==== id event_name season_name country home_team away_team fixture_key match_stage fixture_interest_factor source_type notes created_at updated_at 1 Ligue 1 2025-26 GLOBAL Paris Saint-Germain Marseille marseille|psg League 1.3000 manual Le Classique; strongest regular-season Ligue 1 fixture 2026-03-12 15:39:36 2026-03-12 17:35:34 2 Ligue 1 2025-26 GLOBAL Paris Saint-Germain Monaco monaco|psg League 1.2200 manual High star power and title-race relevance 2026-03-12 15:39:36 2026-03-12 17:35:34 3 Ligue 1 2025-26 GLOBAL Lyon Marseille lyon|marseille League 1.1800 manual Historically high-interest major-club fixture 2026-03-12 15:39:36 2026-03-12 15:39:36 4 Ligue 1 2025-26 GLOBAL Lyon Saint-Etienne lyon|saint-etienne League 1.2400 manual Major derby fixture with above-normal domestic pull 2026-03-12 15:39:36 2026-03-12 15:39:36 5 Ligue 1 2025-26 GLOBAL Lille Lens lens|lille League 1.2000 manual Derby du Nord; strong regional and national interest 2026-03-12 15:39:36 2026-03-12 15:39:36 6 Ligue 1 2025-26 GLOBAL Paris Saint-Germain Lyon lyon|psg League 1.1600 manual Large-club matchup with elevated interest 2026-03-12 15:39:36 2026-03-12 17:35:34 7 Ligue 1 2025-26 GLOBAL Paris Saint-Germain Lille lille|psg League 1.1200 manual Strong fixture versus upper-tier club 2026-03-12 15:39:36 2026-03-12 17:35:34 8 Ligue 1 2025-26 GLOBAL Monaco Marseille marseille|monaco League 1.1400 manual Strong top-half matchup with wider appeal 2026-03-12 15:39:36 2026-03-12 15:39:36 9 Ligue 1 2025-26 GLOBAL Monaco Lyon lyon|monaco League 1.1200 manual Upper-tier fixture with moderate uplift 2026-03-12 15:39:36 2026-03-12 15:39:36 10 Ligue 1 2025-26 GLOBAL Marseille Nice marseille|nice League 1.1000 manual South France rivalry flavor; moderate uplift 2026-03-12 15:39:36 2026-03-12 15:39:36 ## ==== ott_multipliers ==== ott_id country tv_to_ott_multiplier tv_to_ott_multiplier_backup ooh_multiplier ooh_multiplier_backup household_min_size household_max_size 1 Afrique 0.2000 0.5500 0.1200 0.2400 1.80 2.60 2 Albania 0.2500 0.5500 0.1000 0.1820 1.60 2.20 3 Algeria 0.2200 0.4000 0.1200 0.2925 2.00 2.80 4 Angola 0.1800 0.2800 0.1400 0.2795 2.10 2.90 5 Argentina 0.3500 0.5200 0.1500 0.2600 2.00 2.70 6 Armenia 0.2500 0.5500 0.0900 0.1495 1.70 2.30 7 Australia 0.3500 0.6800 0.1200 0.1300 1.60 2.30 8 Austria 0.3000 0.6300 0.1000 0.1300 1.50 2.00 9 Azerbaijan 0.2500 0.5500 0.1000 0.1820 1.80 2.40 10 Bahrain 0.4000 0.6600 0.1500 0.1495 2.00 2.70 ## ==== global_sports_ama_caps ==== country channel sub_genre event_name telecast_type max_ama_000 median_ama_000 avg_ama_000 ttv_ama_000 row_count cap_multiplier cap_ama_000 cap_rule source_grain updated_at Romania DigiSport 2 NULL UEFA Champions League LIVE 61.0000 49.3333 50.5556 4279.7778 5 1.700 103.7000 LIVE max_ama_000 * 1.7 country_channel_event_telecast 2026-06-26 12:12:38 Romania DigiSport 4 NULL UEFA Champions League LIVE 7.0000 6.0000 6.0000 5978.0000 2 1.700 11.9000 LIVE max_ama_000 * 1.7 country_channel_event_telecast 2026-06-26 12:12:38 Romania Prima Sport 2 NULL UEFA Champions League LIVE 13.0000 6.5000 6.5119 3483.3810 13 1.700 22.1000 LIVE max_ama_000 * 1.7 country_channel_event_telecast 2026-06-26 12:12:38 Canada A&E NULL NON_EVENT NON_EVENT 111.0000 46.5446 48.0599 3734.5783 245 2.000 222.0000 NON_LIVE max_ama_000 * 2.0 country_channel_event_telecast 2026-06-26 12:12:38 Canada A&E NULL NON_EVENT_STUDIO_SHOW STUDIO 235.9000 43.5887 44.5315 4717.8210 68 2.000 471.8000 NON_LIVE max_ama_000 * 2.0 country_channel_event_telecast 2026-06-26 12:12:38 Canada A&E NULL NOT_AN_EVENT LIVE 145.4000 51.8176 52.5542 4525.3238 147 1.700 247.1800 LIVE max_ama_000 * 1.7 country_channel_event_telecast 2026-06-26 12:12:38 Canada A&E NULL NOT_AN_EVENT NON_EVENT 245.7000 44.3140 47.0447 3977.0771 855 2.000 491.4000 NON_LIVE max_ama_000 * 2.0 country_channel_event_telecast 2026-06-26 12:12:38 Canada Adult Swim NULL NON_EVENT NON_EVENT 61.3000 13.7307 15.2230 4272.0106 496 2.000 122.6000 NON_LIVE max_ama_000 * 2.0 country_channel_event_telecast 2026-06-26 12:12:38 Canada Adult Swim NULL NON_EVENT_STUDIO_SHOW STUDIO 36.6000 6.8231 7.4267 3121.7151 33 2.000 73.2000 NON_LIVE max_ama_000 * 2.0 country_channel_event_telecast 2026-06-26 12:12:38 Canada Adult Swim NULL NOT_AN_EVENT NON_EVENT 135.4000 10.8429 12.0072 3594.6350 1053 2.000 270.8000 NON_LIVE max_ama_000 * 2.0 country_channel_event_telecast 2026-06-26 12:12:38 ## ==== country_genre_demographics ==== demographics_id country genre_id genre ama_male_percentage ama_female_percentage ama_a4to15_percentage ama_a16to24_percentage ama_a25to34_percentage ama_a35to44_percentage ama_a45to54_percentage ama_a55to64_percentage ama_65_plus_percentage reach_male_percentage reach_female_percentage reach_a4to15_percentage reach_a16to24_percentage reach_a25to34_percentage reach_a35to44_percentage reach_a45to54_percentage reach_a55to64_percentage reach_65plus_percentage created_at updated_at source_info 1 United Kingdom NULL American Football 67.71617 32.28383 3.08575 4.01492 14.71826 15.32768 21.08889 21.08091 20.68359 67.71617 32.28383 3.08575 4.01492 14.71826 15.32768 21.08889 21.08091 20.68359 2026-01-15 17:02:37 2026-08-06 14:53:01 ID 1: United Kingdom / American Football; normalized modeled; not measured. 2 United Kingdom NULL American Sports 71.67127 28.32873 2.52652 3.28635 10.80589 19.85705 14.80285 26.64977 22.07157 71.67127 28.32873 2.52652 3.28635 10.80589 19.85705 14.80285 26.64977 22.07157 2026-01-15 17:02:37 2026-08-06 14:53:01 ID 2: United Kingdom / American Sports; normalized modeled; not measured. 3 United Kingdom NULL Angling/Fishing 86.11904 13.88096 0.24151 0.80537 1.13278 0.71659 11.36000 28.83581 56.90794 86.11904 13.88096 0.24151 0.80537 1.13278 0.71659 11.36000 28.83581 56.90794 2026-01-15 17:02:37 2026-08-06 14:53:01 ID 3: United Kingdom / Angling/Fishing; normalized modeled; not measured. 4 United Kingdom NULL Athletics 47.81075 52.18925 1.14379 2.09669 3.85963 8.14136 15.15659 19.59853 50.00341 47.81075 52.18925 1.14379 2.09669 3.85963 8.14136 15.15659 19.59853 50.00341 2026-01-15 17:02:37 2026-08-06 14:53:01 ID 4: United Kingdom / Athletics; normalized modeled; not measured. 5 United Kingdom NULL Australian Football 81.23522 18.76478 5.21890 6.78355 3.90857 15.40527 31.92209 26.88654 9.87508 81.23522 18.76478 5.21890 6.78355 3.90857 15.40527 31.92209 26.88654 9.87508 2026-01-15 17:02:37 2026-08-06 14:53:01 ID 5: United Kingdom / Australian Football; normalized modeled; not measured. 6 United Kingdom NULL Basketball 61.99397 38.00603 4.38004 8.01392 10.20790 12.39734 20.84028 22.84593 21.31459 61.99397 38.00603 4.38004 8.01392 10.20790 12.39734 20.84028 22.84593 21.31459 2026-01-15 17:02:37 2026-08-06 14:53:01 ID 6: United Kingdom / Basketball; normalized modeled; not measured. 7 United Kingdom NULL Bowls 58.14597 41.85403 0.07600 0.22847 2.08936 4.63865 5.76632 15.79412 71.40708 58.14597 41.85403 0.07600 0.22847 2.08936 4.63865 5.76632 15.79412 71.40708 2026-01-15 17:02:37 2026-08-06 14:53:01 ID 7: United Kingdom / Bowls; normalized modeled; not measured. 8 United Kingdom NULL Boxing 69.35806 30.64194 1.12836 2.26013 8.81619 11.92629 18.00831 20.06466 37.79606 69.35806 30.64194 1.12836 2.26013 8.81619 11.92629 18.00831 20.06466 37.79606 2026-01-15 17:02:37 2026-08-06 14:53:01 ID 8: United Kingdom / Boxing; normalized modeled; not measured. 9 United Kingdom NULL Contact Sports 77.46122 22.53878 7.34687 14.67625 24.43544 15.32567 24.05686 5.39703 8.76188 77.46122 22.53878 7.34687 14.67625 24.43544 15.32567 24.05686 5.39703 8.76188 2026-01-15 17:02:37 2026-08-06 14:53:01 ID 9: United Kingdom / Contact Sports; normalized modeled; not measured. 10 United Kingdom NULL Cricket 67.06053 32.93947 1.07765 1.97566 3.24229 6.63999 12.18357 22.50662 52.37422 67.06053 32.93947 1.07765 1.97566 3.24229 6.63999 12.18357 22.50662 52.37422 2026-01-15 17:02:37 2026-08-06 14:53:01 ID 10: United Kingdom / Cricket; normalized modeled; not measured.