Announcement

Collapse
No announcement yet.

WC and Oly DB stuff

Collapse

Unconfigured Ad Widget

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • WC and Oly DB stuff

    I spent a few hours the other day updating my database of all top-8 (top-6 in the old days) finishers in all Olympics and World Championships from 1948. As I've mentioned before, there are some inaccuracies in this data: 1) surname changes of women athletes who got married; 2) revised results due to retroactive drug DQs; 3) relay results only by nation.

    I have fixed as many as I could find of category 1, and a few of category 2, but I know there are other drug modifications I have not done.

    With that disclaimer, I offer up some "Tidbits" from the DB.

    I'm not much interested in how many gold medals, medals or place points each nation got in Beijing or in the past, but I do find it interesting to examine in what events different countries' athletes excel.

    Here's a breakdown, by country, event and sex, of countries that had more than two placers (through 8th) in an event:

    Code:
    country event	sex	count(*)
    JAM	400	F	4
    KEN	800	M	4
    KEN	3000SC	M	4
    KEN	1500	M	4
    KEN	5000	F	4
    USA	100	M	4
    JAM	100	F	3
    USA	5000	M	3
    GER	DEC	M	3
    KEN	MAR	F	3
    KEN	10000	F	3
    JAM	200	F	3
    ETH	5000	F	3
    USA	10000	F	3
    FRA	110H	M	3
    CHN	LJ	M	3
    KEN	10000	M	3
    ETH	MAR	F	3
    BLR	SP	F	3
    One would have expected to see the USA there in the 100H, but things didn't go as expected.

    More stuff later.
    Cheers,
    Alan Shank

  • #2
    Here are scores (8, 7, 6, etc.) for countries in an event, both sexes, in Beijing:

    Code:
    country	event	score
    KEN	3000SC	36
    ETH	5000	32
    KEN	10000	31
    KEN	1500	28
    USA	100	26
    KEN	800	26
    JAM	100	25
    JAM	200	23
    KEN	5000	22
    ETH	MAR	21
    USA	400H	19
    JAM	400	18
    GER	JT	18
    RUS	HJ	18
    USA	SP	18
    USA	10000	18
    USA	400	17
    KEN	MAR	16
    JAM	400R	16
    USA	1600R	15
    CHN	LJ	15
    USA	200	15
    And by event type, where:
    eventType: 1 = sprints; 2 = middle distances; 3 = track long distances;
    4 = marathon; 5 = jumps; 6 = throws; 7 = multis; 8 = relays
    9 = hurdles

    Code:
    country	event_type	score
    KEN	3	89
    JAM	1	66
    USA	1	58
    KEN	2	54
    ETH	3	49
    GER	6	40
    USA	3	38
    CHN	6	34
    USA	9	33
    RUS	5	30
    JAM	8	29
    JAM	9	25
    POL	6	25
    USA	5	23
    USA	8	22
    CHN	5	21
    ETH	4	21
    USA	6	19
    GET	6	19
    GBR	8	17
    CAN	5	16
    GBR	3	16
    KEN	4	16
    GER	7	15
    NED	1	15
    CUB	5	15
    RUS	9	15
    Cheers,
    Alan Shank

    Comment


    • #3
      Alan, you appear to have way too much time on your hands.

      And I and I'm sure lots of others here are very glad that you do. Thank you for sharing--that's good stuff.

      Comment


      • #4
        Originally posted by tandfman View Post
        Alan, you appear to have way too much time on your hands.
        Gee that's what my wife says! "Why aren't you fixing the roof?"

        Originally posted by tandfman View Post
        And I and I'm sure lots of others here are very glad that you do. Thank you for sharing--that's good stuff.
        And more to come. Had to go to an A's game w/fireworks today. They lost, of course, 8-3 to Felix Hernandez and the Mariners, but it was an excellent fireworks show, and I saw a lot of nice people I only see once a year.
        Cheers,
        Alan Shank

        Comment


        • #5
          Here is a by-nation scoring (M & W combined, both 4X1 and 4X4) for the relays, but starting with 2007, when Usain Bolt really started to come on (silver in 200 and relay).

          Code:
          country	score
          USA	169
          JAM	165
          GBR	100
          RUS	94
          GER	45
          TRI	41
          FRA	38
          BEL	37
          BAH	29
          UKR	28
          CAN	27
          BRA	26
          Cheers,
          Alan Shank

          Comment

          Working...
          X