[R] Lahman Baseball Data Using R DBI Package

[Philip]

I’m trying to pull data from one table (batting) in the Lahman Baseball database.  Notice X2B for doubles and X3B for triples – fourth and fifth from the right.  

The dbGetQuery function runs fine when I leave there two out but I get error messages (in red) when I include 2B/3B or X2B/X3B.

Can anyone give me some direction?

Thanks,
Philip Heinrich
***************************************************************************************************************************************************
tail(dbReadTable(Lahman,"batting"))

ID                       playerID      yearID    stint teamID team_ID lgID   G        G_batting   AB     R     H       X2B    X3B   HR   RBI   SB
107414 107414 yastrmi01      2019       1       SFN       2920      NL     107        NA          371   64  101      22       3     21     55    2
107416 107416 yelicch01      2019        1       MIL       2911      NL     130        NA          489 100  161      29       3     44    97   30
107419 107419 youngal01     2019       1       ARI        2896      NL       17        NA            25     1      1        0       0       0      0     0
107420 107420 zagunma01   2019        1      CHN       2901      NL      30        NA             36     2      9        3       0      0       5     0
107422 107422 zavalse01      2019        1      CHA       2900      AL        5        NA             12     1      1        0       0      0       0     0
107427 107427 zimmery01     2019        1      WAS      2925      NL      52        NA           171   20    44        9      0      6      27     0
107428 107428 zobribe01       2019        1      CHN      2901      NL      47        NA           150   24   39         5      0      1      17     0
107429 107429 zuninmi01       2019        1      TBA       2922      AL      90        NA           266    30  44       10      1      9      32     0


Hack11Batting <- dbGetQuery(Lahman,"SELECT playerID,yearID,AB,R,H,2B,3B,HR,
                            RBI,SB,CS,BB,SO,IBB,HBP,SH,SF,GIDP FROM batting
                            WHERE yearID = 2018 AND AB >99")
Error: unrecognized token: "2B"

 Hack11Batting <- dbGetQuery(Lahman,"SELECT playerID,yearID,AB,R,H,X2B,X3B,HR,
                            RBI,SB,CS,BB,SO,IBB,HBP,SH,SF,GIDP FROM batting
                            WHERE yearID = 2018 AND AB >99")
Error: no such column: X2B

	[[alternative HTML version deleted]]