This database is bundled with the package, and contains all data frames in the datasets package.

datasetsDb()

Examples

library(DBI) db <- RSQLite::datasetsDb() dbListTables(db)
#> [1] "BOD" "CO2" "ChickWeight" "DNase" #> [5] "Formaldehyde" "Indometh" "InsectSprays" "LifeCycleSavings" #> [9] "Loblolly" "Orange" "OrchardSprays" "PlantGrowth" #> [13] "Puromycin" "Theoph" "ToothGrowth" "USArrests" #> [17] "USJudgeRatings" "airquality" "anscombe" "attenu" #> [21] "attitude" "cars" "chickwts" "esoph" #> [25] "faithful" "freeny" "infert" "iris" #> [29] "longley" "morley" "mtcars" "npk" #> [33] "pressure" "quakes" "randu" "rock" #> [37] "sleep" "stackloss" "swiss" "trees" #> [41] "warpbreaks" "women"
dbReadTable(db, "CO2")
#> Plant Type Treatment conc uptake #> 1 Qn1 Quebec nonchilled 95 16.0 #> 2 Qn1 Quebec nonchilled 175 30.4 #> 3 Qn1 Quebec nonchilled 250 34.8 #> 4 Qn1 Quebec nonchilled 350 37.2 #> 5 Qn1 Quebec nonchilled 500 35.3 #> 6 Qn1 Quebec nonchilled 675 39.2 #> 7 Qn1 Quebec nonchilled 1000 39.7 #> 8 Qn2 Quebec nonchilled 95 13.6 #> 9 Qn2 Quebec nonchilled 175 27.3 #> 10 Qn2 Quebec nonchilled 250 37.1 #> 11 Qn2 Quebec nonchilled 350 41.8 #> 12 Qn2 Quebec nonchilled 500 40.6 #> 13 Qn2 Quebec nonchilled 675 41.4 #> 14 Qn2 Quebec nonchilled 1000 44.3 #> 15 Qn3 Quebec nonchilled 95 16.2 #> 16 Qn3 Quebec nonchilled 175 32.4 #> 17 Qn3 Quebec nonchilled 250 40.3 #> 18 Qn3 Quebec nonchilled 350 42.1 #> 19 Qn3 Quebec nonchilled 500 42.9 #> 20 Qn3 Quebec nonchilled 675 43.9 #> 21 Qn3 Quebec nonchilled 1000 45.5 #> 22 Qc1 Quebec chilled 95 14.2 #> 23 Qc1 Quebec chilled 175 24.1 #> 24 Qc1 Quebec chilled 250 30.3 #> 25 Qc1 Quebec chilled 350 34.6 #> 26 Qc1 Quebec chilled 500 32.5 #> 27 Qc1 Quebec chilled 675 35.4 #> 28 Qc1 Quebec chilled 1000 38.7 #> 29 Qc2 Quebec chilled 95 9.3 #> 30 Qc2 Quebec chilled 175 27.3 #> 31 Qc2 Quebec chilled 250 35.0 #> 32 Qc2 Quebec chilled 350 38.8 #> 33 Qc2 Quebec chilled 500 38.6 #> 34 Qc2 Quebec chilled 675 37.5 #> 35 Qc2 Quebec chilled 1000 42.4 #> 36 Qc3 Quebec chilled 95 15.1 #> 37 Qc3 Quebec chilled 175 21.0 #> 38 Qc3 Quebec chilled 250 38.1 #> 39 Qc3 Quebec chilled 350 34.0 #> 40 Qc3 Quebec chilled 500 38.9 #> 41 Qc3 Quebec chilled 675 39.6 #> 42 Qc3 Quebec chilled 1000 41.4 #> 43 Mn1 Mississippi nonchilled 95 10.6 #> 44 Mn1 Mississippi nonchilled 175 19.2 #> 45 Mn1 Mississippi nonchilled 250 26.2 #> 46 Mn1 Mississippi nonchilled 350 30.0 #> 47 Mn1 Mississippi nonchilled 500 30.9 #> 48 Mn1 Mississippi nonchilled 675 32.4 #> 49 Mn1 Mississippi nonchilled 1000 35.5 #> 50 Mn2 Mississippi nonchilled 95 12.0 #> 51 Mn2 Mississippi nonchilled 175 22.0 #> 52 Mn2 Mississippi nonchilled 250 30.6 #> 53 Mn2 Mississippi nonchilled 350 31.8 #> 54 Mn2 Mississippi nonchilled 500 32.4 #> 55 Mn2 Mississippi nonchilled 675 31.1 #> 56 Mn2 Mississippi nonchilled 1000 31.5 #> 57 Mn3 Mississippi nonchilled 95 11.3 #> 58 Mn3 Mississippi nonchilled 175 19.4 #> 59 Mn3 Mississippi nonchilled 250 25.8 #> 60 Mn3 Mississippi nonchilled 350 27.9 #> 61 Mn3 Mississippi nonchilled 500 28.5 #> 62 Mn3 Mississippi nonchilled 675 28.1 #> 63 Mn3 Mississippi nonchilled 1000 27.8 #> 64 Mc1 Mississippi chilled 95 10.5 #> 65 Mc1 Mississippi chilled 175 14.9 #> 66 Mc1 Mississippi chilled 250 18.1 #> 67 Mc1 Mississippi chilled 350 18.9 #> 68 Mc1 Mississippi chilled 500 19.5 #> 69 Mc1 Mississippi chilled 675 22.2 #> 70 Mc1 Mississippi chilled 1000 21.9 #> 71 Mc2 Mississippi chilled 95 7.7 #> 72 Mc2 Mississippi chilled 175 11.4 #> 73 Mc2 Mississippi chilled 250 12.3 #> 74 Mc2 Mississippi chilled 350 13.0 #> 75 Mc2 Mississippi chilled 500 12.5 #> 76 Mc2 Mississippi chilled 675 13.7 #> 77 Mc2 Mississippi chilled 1000 14.4 #> 78 Mc3 Mississippi chilled 95 10.6 #> 79 Mc3 Mississippi chilled 175 18.0 #> 80 Mc3 Mississippi chilled 250 17.9 #> 81 Mc3 Mississippi chilled 350 17.9 #> 82 Mc3 Mississippi chilled 500 17.9 #> 83 Mc3 Mississippi chilled 675 18.9 #> 84 Mc3 Mississippi chilled 1000 19.9
dbGetQuery(db, "SELECT * FROM CO2 WHERE conc < 100")
#> Plant Type Treatment conc uptake #> 1 Qn1 Quebec nonchilled 95 16.0 #> 2 Qn2 Quebec nonchilled 95 13.6 #> 3 Qn3 Quebec nonchilled 95 16.2 #> 4 Qc1 Quebec chilled 95 14.2 #> 5 Qc2 Quebec chilled 95 9.3 #> 6 Qc3 Quebec chilled 95 15.1 #> 7 Mn1 Mississippi nonchilled 95 10.6 #> 8 Mn2 Mississippi nonchilled 95 12.0 #> 9 Mn3 Mississippi nonchilled 95 11.3 #> 10 Mc1 Mississippi chilled 95 10.5 #> 11 Mc2 Mississippi chilled 95 7.7 #> 12 Mc3 Mississippi chilled 95 10.6