MLB/Scores/COL at SF
May 18, 2018 · 2018 · Regular season

01/Line score

9 innings
Runs by inning
Club123456789R
COL0003010026
SF1000000001
X marks a half-inning that was never played

02/Box score

10 lines
Both sides
COLORADO ROCKIES 6
HITTING
PlayerPOSABRHHRRBIBBSOSBAVG
Kyle FreelandP231510150.217
Nolan Arenado3B42200100.500
Trevor StorySS41200100.500
PITCHING
PlayerIPHERBBSOBFERAWHIP
Kyle Freeland6.25115241.350.90
Bryan Shaw1.1000240.000.00
Mike Dunn1.0001240.001.00
SAN FRANCISCO GIANTS 1
HITTING
PlayerPOSABRHHRRBIBBSOSBAVG
Andrew McCutchenRF40000020.000
PITCHING
PlayerIPHERBBSOBFERAWHIP
Derek Holland6.06413256.001.17
Reyes Moronta2.0101280.001.00
José A. Váldez1.03210718.004.00

The line score is derived from the play log rather than read from a stored innings table, because the play log covers 2015 onward where that table starts in 2023. The two were compared on their overlap and agree on every inning-half except the ones the stored table marks unplayed, which is the case shown as X above: when the home club leads after the top of the last inning it does not bat, and printing a zero there would say it batted and failed to score. Games before 2015 have no play log and so no line score, only the final. Batting average in the hitting table is this game alone, not the season. Earned run average and WHIP in the pitching table are likewise this appearance, which is why a one-inning reliever who allowed a run reads 9.00. Innings come from the out count rather than the stored decimal: “6.1” means six innings and one out. No venue is shown because no MLB fixture in this database carries one.