Cataloging The TV News Archive By Channel Over The Past Quarter-Century: 8 Million Broadcasts & 5.65M Hours From 214 Channels

As we continue to analyze, explore and examine the Internet Archive's TV News Archive's insights into our global world, we are heavily leveraging our new BigQuery + Bigtable GCS digital twin to analytically map its more than 8 million broadcasts totaling 5.65 million hours of global television news. Let's compile a master channel inventory that tallies the Archive's complete holdings in its TV News collection by channel over the past quarter-century. In all, 214 channels are represented in its holdings.

We'll use the following digital twin query:

select chan, COUNT(1) numShows, ROUND(sum(sec)) secAirtime from (
select JSON_EXTRACT_SCALAR(DOWN, '$.chan') chan,  CAST(JSON_EXTRACT_SCALAR(DOWN, '$.durSec') AS FLOAT64) sec FROM (
  SELECT  
    rowkey,
    ( select array(select value from unnest(cell))[OFFSET(0)]  from unnest(cf.column) where name in ('DOWN') ) DOWN
  FROM `[PROJECTID].bigtableconnections.digtwin` where  CAST(substr(rowkey, 0, 8) as NUMERIC) > 20000000 
 ) 
) group by chan order by secAirtime desc

This yields: