`db/orbit-seed-feeds.sql`

34 lines
-- Orbit: Seed RSS Feeds
-- National TV, Wire Services, and Local TV (top 10 DMAs)

INSERT INTO orbit_feeds (name, url, feed_type, category, station) VALUES
  ('CNN Top Stories', 'https://rss.cnn.com/rss/cnn_topstories.rss', 'rss', 'national', 'CNN'),
  ('CNN Politics', 'https://rss.cnn.com/rss/cnn_allpolitics.rss', 'rss', 'national', 'CNN'),
  ('Fox News Latest', 'https://moxie.foxnews.com/google-publisher/latest.xml', 'rss', 'national', 'Fox News'),
  ('Fox News Politics', 'https://moxie.foxnews.com/google-publisher/politics.xml', 'rss', 'national', 'Fox News'),
  ('MSNBC Latest', 'https://www.msnbc.com/feeds/latest', 'rss', 'national', 'MSNBC'),
  ('NBC News', 'https://feeds.nbcnews.com/nbcnews/public/news', 'rss', 'national', 'NBC News'),
  ('ABC News Top Stories', 'https://abcnews.go.com/abcnews/topstories', 'rss', 'national', 'ABC News'),
  ('CBS News', 'https://www.cbsnews.com/latest/rss/main', 'rss', 'national', 'CBS News'),
  ('PBS NewsHour', 'https://www.pbs.org/newshour/feeds/rss/headlines', 'rss', 'national', 'PBS'),
  ('NPR News', 'https://feeds.npr.org/1001/rss.xml', 'rss', 'national', 'NPR')
ON CONFLICT (url) DO NOTHING;

INSERT INTO orbit_feeds (name, url, feed_type, category, station) VALUES
  ('AP News', 'https://rsshub.app/apnews/topics/apf-topnews', 'rss', 'wire', 'AP'),
  ('Reuters', 'https://www.reutersagency.com/feed/', 'rss', 'wire', 'Reuters')
ON CONFLICT (url) DO NOTHING;

INSERT INTO orbit_feeds (name, url, feed_type, category, station, market) VALUES
  ('WABC New York', 'https://abc7ny.com/feed/', 'rss', 'local', 'WABC', 'New York'),
  ('KABC Los Angeles', 'https://abc7.com/feed/', 'rss', 'local', 'KABC', 'Los Angeles'),
  ('WLS Chicago', 'https://abc7chicago.com/feed/', 'rss', 'local', 'WLS', 'Chicago'),
  ('KTRK Houston', 'https://abc13.com/feed/', 'rss', 'local', 'KTRK', 'Houston'),
  ('KXAS Dallas', 'https://www.nbcdfw.com/news/local/?rss=y', 'rss', 'local', 'KXAS', 'Dallas'),
  ('WPVI Philadelphia', 'https://6abc.com/feed/', 'rss', 'local', 'WPVI', 'Philadelphia'),
  ('WJLA Washington DC', 'https://wjla.com/feed', 'rss', 'local', 'WJLA', 'Washington DC'),
  ('WSB Atlanta', 'https://www.wsbtv.com/news/local/?rss=y', 'rss', 'local', 'WSB', 'Atlanta'),
  ('KPIX San Francisco', 'https://www.cbsnews.com/sanfrancisco/latest/rss/main', 'rss', 'local', 'KPIX', 'San Francisco'),
  ('WFTS Tampa', 'https://www.abcactionnews.com/feeds/rss', 'rss', 'local', 'WFTS', 'Tampa')
ON CONFLICT (url) DO NOTHING;