Importing Tables 101
Per Matt's Request ...

Is there a job of collecting interestingly-sorted tables from the sports-reference.com family of sites?  Like people putting together playlists on Spotify?

Like 1921 MLB hitters sorted by ISO:

Rk Name Age Tm PA BA OBP SLG OPS OPS+ ISO ▾
1 Babe Ruth* 26 NYY 693 .378 .512 .846 1.359 238 .469
2 Rogers Hornsby 25 STL 674 .397 .458 .639 1.097 191 .242
3 Bob Meusel 24 NYY 647 .318 .356 .559 .915 128 .241
4 High Pockets Kelly 25 NYG 647 .308 .356 .528 .884 130 .220
5 Elmer Smith* 28 CLE 504 .290 .374 .508 .882 121 .218
6 Ken Williams* 31 SLB 651 .347 .429 .561 .990 145 .214
7 Harry Heilmann 26 DET 672 .394 .444 .606 1.051 167 .213
8 Ty Cobb* 34 DET 582 .389 .452 .596 1.048 166 .207
9 Tillie Walker 33 PHA 633 .304 .389 .504 .892 126 .200
10 Bobby Veach* 33 DET 692 .338 .387 .529 .917 133 .191
Provided by Baseball-Reference.com: View Original Table
Generated 5/12/2016.

***

Ty Cobb ISO over 200?  And how can you not love someone named "High Pockets Kelly"?

Or 2015 NFL QBs sorted by touchdowns as a percentage of attempts:

Rk Tm Age Pos G GS Cmp Att Cmp% Yds TD TD% ▾
1 Cam Newton*+ CAR 26 QB 16 16 296 496 59.7 3837 35 7.1
2 Russell Wilson* SEA 27 QB 16 16 329 483 68.1 4024 34 7.0
3 Carson Palmer* ARI 36 QB 16 16 342 537 63.7 4671 35 6.5
4 Andy Dalton CIN 28 QB 13 13 255 386 66.1 3250 25 6.5
5 Tom Brady* NWE 38 QB 16 16 402 624 64.4 4770 36 5.8
6 Blake Bortles JAX 23 QB 16 16 355 606 58.6 4428 35 5.8
7 Eli Manning* NYG 34 QB 16 16 387 618 62.6 4436 35 5.7
8 Derek Carr* OAK 24 QB 16 16 350 573 61.1 3987 32 5.6
9 Ryan Fitzpatrick NYJ 33 QB 16 16 335 562 59.6 3905 31 5.5
10 Matthew Stafford DET 27 QB 16 16 398 592 67.2 4262 32 5.4
11 Aaron Rodgers* GNB 32 QB 16 16 347 572 60.7 3821 31 5.4
Provided by Pro-Football-Reference.com: View Original Table
Generated 5/12/2016.

***

Or 2016 Mariners minor leaguers sorted by total bases:

Rk Name Age Tm Lev G PA AB 2B 3B HR RBI BB SO BA OBP SLG OPS TB ▾
1 Stefen Romero 27 TAC AAA 28 118 107 5 3 6 26 8 10 .383 .424 .654 1.078 70
2 Mike Zunino 25 TAC AAA 29 116 106 8 0 9 25 7 21 .321 .371 .651 1.022 69
3 Tyler O'Neill 21 WTN AA 29 128 115 7 1 6 22 11 33 .322 .383 .557 .939 64
4 Chris Taylor 25 TAC AAA 31 138 122 12 3 2 9 16 26 .303 .384 .500 .884 61
5 Kyle Petty 25 BAK A+ 32 150 134 10 0 3 18 14 39 .306 .380 .448 .828 60
6 Dalton Kelly* 21 CLI A 29 133 113 6 2 1 11 17 21 .363 .451 .478 .929 54
7 Drew Jackson 22 BAK A+ 31 149 133 9 2 0 14 9 24 .301 .352 .398 .750 53
8 Jay Baum 23 BAK A+ 29 130 115 5 1 3 19 13 22 .270 .354 .409 .763 47
9 Tim Lopes 22 WTN AA 30 135 117 5 2 0 13 11 21 .299 .376 .376 .752 44
10 Ed Lucas 34 TAC AAA 32 122 116 11 0 3 19 5 19 .207 .246 .379 .625 44
Provided by Baseball-Reference.com: View Original Table
Generated 5/12/2016.

***

So here's what you do:

1. Find the table you want at baseball-reference.com or related site

2. Sort by the column you wish to sort by -- click once on the heading to sort high-low and click twice to sort low-high

3. There is a box to unclick if you want to include non-qualifiers (3.1 PAs per game played)  Dae-ho Lee is a nonqualifier at the moment, for example.  But to get him you'll also get a lot of pitchers and such

4. Click on the word "SHARE" at the top of the table  -- a yellow box with "sharing tools" should show up

5. Use the "Xs" in red circles or arrows to eliminate rows and columns you don't want -- like everyone lower than top 10 (if you mess up, reload the page and start over)

6. Once you have the table you want, click on "html <table>" and a box should pop up with your html code -- select all "ctrl-A" and copy "ctnl-C"

7. Then back at SSI, you need to click on "Disable rich-text" below the post or comment box -- then paste "ctrl-V" the html code where you want it

8. I find it useful to type something usually "***" before pasting so that I can find where to paste on the page of raw code, and where to come back to once I re-enable the rich text (since it will take you back to the beginning of the post or comment.

It's really not so hard.  Hope that helps.

Comments

3

...where did you find a table showing draft picks and the WAR they'd earned?  I haven't found anything like that.

Add comment

Filtered HTML

  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd><p><br>
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.

shout_filter

  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.
  • Web page addresses and e-mail addresses turn into links automatically.