Google chrome history sqlite
This site had a lot of helpful information about Chrome's SQLite tables, and how to query the tables.
An example they give on that page of joining the two tables "urls" and "visits" is as follows:
SELECT urls.url, urls.title, urls.visit_count, urls.typed_count, urls.last_visit_time, urls.hidden, visits.visit_time, visits.from_visit, visits.transitionFROM urls, visitsWHERE urls.id = visits.url
And as for the "transition" field in the visits table, this value tells you how the URL was loaded into the browser. I'll let you check out the link I gave you for more details.