Skip to content

Instantly share code, notes, and snippets.

@mkwatson
Last active September 11, 2023 17:17
Show Gist options
  • Save mkwatson/2174ec5f4c234c25cd993a1f59114a85 to your computer and use it in GitHub Desktop.
Save mkwatson/2174ec5f4c234c25cd993a1f59114a85 to your computer and use it in GitHub Desktop.
# Base URL and HTTP method
# Query Parameters:
# - teamId=110 is for the Orioles
# - daysBack=-6 gathers data for the previous week
curl -G 'https://bdfed.stitch.mlbinfra.com/bdfed/stats/player' \
--data-urlencode 'stitch_env=prod' \
--data-urlencode 'season=2023' \
--data-urlencode 'sportId=1' \
--data-urlencode 'stats=season' \
--data-urlencode 'group=hitting' \
--data-urlencode 'gameType=R' \
--data-urlencode 'limit=25' \
--data-urlencode 'offset=0' \
--data-urlencode 'sortStat=hits' \
--data-urlencode 'order=desc' \
--data-urlencode 'teamId=110' \
--data-urlencode 'daysBack=-6' \
| jq -r '
.stats
| map(
select(.plateAppearances != 0)
| {
playerName,
plateAppearances,
gamesPlayed,
runs,
doubles,
homeRuns,
hits,
avg,
atBats,
slg,
rbi
}
) | (first | keys_unsorted) as $header
| [$header] + map([.[ $header[] ]])
| map(.)[]
| @tsv' \
| pbcopy
@mkwatson
Copy link
Author

Output looks like:

playerName	type	plateAppearances	gamesPlayed	runs	doubles	homeRuns	hits	avg	atBats	slg	rbi
Aaron Hicks	player	20	5	4	1	1	9	.500	18	.722	8
Austin Hays	player	24	5	8	2	1	7	.318	22	.545	5
Anthony Santander	player	23	5	5	2	1	7	.368	19	.632	4
Gunnar Henderson	player	25	5	3	2	1	6	.240	25	.520	4
Ramon Urias	player	14	4	1	0	0	6	.500	12	.500	2
Ryan Mountcastle	player	21	4	2	0	0	4	.200	20	.200	1
Ryan O'Hearn	player	9	3	4	0	1	4	.444	9	.778	2
Adley Rutschman	player	26	5	3	1	1	4	.211	19	.421	4
Jordan Westburg	player	12	3	2	2	1	4	.400	10	.900	2
Adam Frazier	player	6	4	1	1	0	3	.500	6	1.000	2
Jorge Mateo	player	12	3	4	0	0	2	.200	10	.200	0
James McCann	player	10	2	3	0	2	2	.222	9	.889	3
Cedric Mullins	player	10	5	2	1	0	2	.222	9	.333	2
Ryan McKenna	player	4	3	0	0	0	0	.000	3	.000	0

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment