r - How to run .sqlite files? -

i have downloaded file called "database.sqlite" "https://www.kaggle.com/benhamner/d/kaggle/college-scorecard/exploring-the-us-college-scorecard-data" .i have connect database r don't know how run file or create database , use data file .i use mac , sqlite version 3.8.5.any highly appreciated.

hi can find sample referenced here

library("rsqlite") con = dbconnect(drv="sqlite", dbname="country.sqlite") alltables = dblisttables(con) p1 = dbgetquery( con,'select * populationtable' ) p2 = dbgetquery( con,'select count(*) areastable' ) p3 = dbgetquery(con, "select population date(timestamp) < date('now', 'weekday 0', '-7 days')") dbclearresult(p3) p4 = dbgetquery(con, "select * populationtable jobdescription '%manager%'")