Skip to content

Latest commit

 

History

History
9 lines (8 loc) · 678 Bytes

README.md

File metadata and controls

9 lines (8 loc) · 678 Bytes

List of Tools for the Companies Graph

  • industries - List of Industry names
  • companies - List of Companies (id, name, summary) by fulltext search
  • companies_in_industry - Companies (id, name, summary) in a given industry by industry
  • articles_in_month - List of Articles (id, author, title, date, sentiment) in a month timeframe from the given date * (yyyy-mm-dd)
  • article - Single Article details (id, author, title, date, sentiment, site, summary, content) by article id
  • companies_in_articles - Companies (id, name, summary) mentioned in articles by list of article ids
  • people_at_company - People (name, role) associated with a company by company id