Database |> Language |> 

Examples

Football headlines

SELECT
  h3.title.h5 AS headline
, span.date_time__KhlCV.time AS how_long_ago
FROM
  https://www.goal.com/en-us/category/transfers/1/k94w8e1yy9ch14mllpf4srnks
GROUP BY
  div.content-wrapper;

Sequoia’s Fintech investments

SELECT
  td.company-listing__cell-wide.company-listing__text.u-md-hide AS company_tagline
, th.company-listing__cell-wide.company-listing__head AS company_name
, td.u-lg-hide AS company_stage
, li AS investor
FROM
  https://www.sequoiacap.com/our-companies/?_categories=fintech&_sort=stage_current-asc#all-panel
GROUP BY
  tr.aos-init.aos-animate;

Sequoia companies that have gotten acquired

SELECT
  th.company-listing__cell-wide.company-listing__head AS company_name
, td.company-listing__cell-wide.company-listing__text.u-md-hide AS company_function
, td.u-lg-hide AS company_status
, li AS investor
FROM
  https://www.sequoiacap.com/our-companies/?_stage_current=acquired&_sort=stage_current-asc#all-panel
GROUP BY
  tr.aos-init;

Hummingbird VC portfolio company names

SELECT
  p.paragraph.break-spaces.hide-tablet AS what_does_it_do
, p.text-sm.hide-tablet AS location
, p.text-sm AS name
FROM
  https://www.hummingbird.vc/portfolio
GROUP BY
  div.grid-item-row;

Propel VC portfolio company names

SELECT
  a.company-t AS portco
FROM
  https://www.propel.vc/investments
GROUP BY
  div.company_link_cover;

Abstract VC portfolio company names

SELECT
  a AS portco
FROM
  https://www.abstractvc.com/companies
WHERE portco != '' AND portco != 'About' AND portco != '
GROUP BY
  div.MuiGrid-item;

Abstract VC’s portfolio company logos

SELECT
  img.featured-logo AS portco
FROM
  https://abstractvc.com/companies
GROUP BY
  div.featured-inner;

Obligatory demo getting posts from Hacker News

SELECT
  a AS post_title,
  a@href AS post_link
FROM
  https://news.ycombinator.com
GROUP BY
  span.titleline;

Scraping a list of web scraping services from a scraping service website

SELECT
  a@href AS scraping_tool
FROM
  https://www.octoparse.com/blog/top-30-free-web-scraping-software
GROUP BY
  strong;

---