MLS All Time Tables

Discussion in 'Statistics and Analysis' started by Auxodium, Mar 26, 2004.

  1. Auxodium

    Auxodium New Member

    Apr 11, 2003
    Perth, Australia
    Does anyone know where i can see an all time MLS table of all teams that have played in the MLS that shows their wins, losses, draws, goals for, against, games played since formation.

    I have a whole database on the National soccer legaue in Australia and that has 41 teams in 27 seasons of the NSL who have participated. So the MLS database will be easier to, and smaller to deal with.

    Could anyone help me please?
     
  2. Auxodium

    Auxodium New Member

    Apr 11, 2003
    Perth, Australia
    does that exclude the finals?
    because i would like to imput this into a table of my own of regular season table and then a finals table then and then a combined table.


    This pdf is great thanks mate :D
     
  3. mellon002

    mellon002 Member

    Jan 24, 2003
    Towson, MD
    I know www.dcunited.com has some in-depth statistics and you could cross-reference the numbers in the other link with the database on dc's website to see if it is just regular season.
     
  4. Auxodium

    Auxodium New Member

    Apr 11, 2003
    Perth, Australia
  5. mpruitt

    mpruitt Member

    Feb 11, 2002
    E. Somerville
    Club:
    New England Revolution
    The MLS stats page, although a little awkard is actually pretty good with having numbers. I'm sure that if you look around the varios drop down bars that they have yuo'll be able to find what you're looking for.
     
  6. AndyMead

    AndyMead Homo Sapien

    Nov 2, 1999
    Seat 12A
    Club:
    Sporting Kansas City
    Contact the league through mlsnet.com and ask them to send you a media guide once the season starts.
     
  7. Auxodium

    Auxodium New Member

    Apr 11, 2003
    Perth, Australia
    yeah i think i will do that! So i just email them for a media guide? I thought they would cost a few bob as the NSL one costs $15 AUS and that is like 150 pages :O
     
  8. AndyMead

    AndyMead Homo Sapien

    Nov 2, 1999
    Seat 12A
    Club:
    Sporting Kansas City
    I don't know how much it will cost, I'm just saying that the media guide will have the information you're looking for.
     
  9. ChrisE

    ChrisE Member

    Jul 1, 2002
    Brooklyn
    Club:
    --other--
    Nat'l Team:
    American Samoa
    Let me save you some money, GF (although I'm sure the media guide is really interesting; I'd like to get one for myself...); I ranked the tables by points, SOW's are shootout wins, which existed when the league ended tied games with a variation on pk's in the league's first four years. To get points, take 3*wins+ties-2*shootout wins

    Code:
    [size=1]
    	GP	W	L	T	Pts	GF	GA	SOW
    L.Angeles	244	132	87	25	399	426	307	11
    D.C. U.	244	119	103	22	343	426	389	18
    Columbus	244	109	111	24	325	401	377	13
    Dallas	244	109	114	21	318	383	399	15
    K. City	245	105	110	30	313	361	388	16
    San Jose	244	107	111	26	309	373	367	19
    Colorado	244	103	118	23	308	356	425	12
    Chicago	181	97	61	23	304	326	243	5
    Metrostars	244	102	125	17	301	357	405	11
    New Eng.	245	97	125	23	280	360	425	17
    Tampa Bay	187	83	98	6	235	312	336	10
    Miami	122	56	56	10	158	199	219	10
    [b][/size]
     
  10. AndyMead

    AndyMead Homo Sapien

    Nov 2, 1999
    Seat 12A
    Club:
    Sporting Kansas City
    Shootout Wins were only worth 1 point.

     
  11. ChrisE

    ChrisE Member

    Jul 1, 2002
    Brooklyn
    Club:
    --other--
    Nat'l Team:
    American Samoa
    Sorry, I wasn't clear about that. Since shootout wins were counted as 'wins' by the league, to adjust for them you need to add 1 point for the SOW but subtract 3 because it wasn't a regular win, netting -2pts/SOW.

    I redid the table to include Shootout losses; both shootout wins and losses are included in the regular wins and losses columns, but it should be really easy to separate them if you want:

    Code:
    [size=1]
    		GP	W	L	T	Pts	GF	GA	SOW	SOL
    L.A.		244	132	87	25	399	426	307	11	14
    D.C.		244	119	103	22	343	426	389	17	13
    Columbus		244	109	111	24	325	401	377	13	18
    Dallas		244	109	114	21	318	383	399	15	13
    K. City		245	105	110	30	313	361	388	16	14
    San Jose		244	107	111	26	309	373	367	19	20
    Colorado		244	103	118	23	308	356	425	12	12
    Chicago		181	97	61	23	304	326	243	5	6
    Metrostars		244	102	125	17	301	357	405	11	8
    New Eng.		245	97	125	23	280	360	425	17	17
    Tampa Bay		187	83	98	6	235	312	336	10	17
    Miami		122	56	56	10	158	199	219	10	4
    [/size]
     
  12. Auxodium

    Auxodium New Member

    Apr 11, 2003
    Perth, Australia
    Thanks for that people! In the NSL table they have dismissed SOW & Losses as we had that in the 1993-1994 season to the 1995-1996 season. so if i don't include those in the table will that change anything? Or will i just add that to draws?

    Thanks again.
     
  13. ChrisE

    ChrisE Member

    Jul 1, 2002
    Brooklyn
    Club:
    --other--
    Nat'l Team:
    American Samoa
    To get rid of SOW's and SOL's, subtract them from the win and loss categories, respectively, and add them both to the ties.
     
  14. Auxodium

    Auxodium New Member

    Apr 11, 2003
    Perth, Australia
    ok i will do that. Thanks for that! How current is this table? 1996-2002? or 2003?
     
  15. ChrisE

    ChrisE Member

    Jul 1, 2002
    Brooklyn
    Club:
    --other--
    Nat'l Team:
    American Samoa
    It's through 2003.

    (We stay on top of things here in the Stats forum.)
     
  16. Auxodium

    Auxodium New Member

    Apr 11, 2003
    Perth, Australia
    great! thanks for that! i will be ready soon for the MLS kick off! :D can't wait for that and the new APL kicking off in 2005! :D
     
  17. LeeS

    LeeS Member

    Mar 23, 2002
    San Francisco, CA
    Club:
    San Jose Earthquakes
    Nat'l Team:
    United States
    I have this information through 2003... All teams w-l-t, Gf's/Ga's, points in reg season, MLS cup playoffs and overall.

    But I don't know how to post it as a table.

    Lee
     
  18. ChrisE

    ChrisE Member

    Jul 1, 2002
    Brooklyn
    Club:
    --other--
    Nat'l Team:
    American Samoa
    Hopefully yours agrees with mine, but, if you've got it set up as a table already, just use [ code ] [ size=1 ]. You can also just quote my post on this thread to see how I did it.
     
  19. LeeS

    LeeS Member

    Mar 23, 2002
    San Francisco, CA
    Club:
    San Jose Earthquakes
    Nat'l Team:
    United States
    Okay here it is...
    One HUGE difference is that I converted all shoot-out games (reg & playoffs) into "ties"

    Code:
    [size=1]
    	Regular Season								MLS Cup Playoffs								Overall							
    Team	GP	W	L	T	Pts	GF	GA	Dif	GP	W	L	T	Pts	GF	GA	Dif	GP	W	L	T	Pts	GF	GA	Dif
    LosAngeles	244	121	73	50	413	426	307	119	38	21	10	7	70	67	48	19	282	142	83	57	483	493	355	138
    DCUnited	244	101	90	53	356	426	389	37	25	15	6	4	49	44	30	14	269	116	96	57	405	470	419	51
    Columbus	244	96	93	55	343	401	377	24	24	10	11	3	33	36	41	-5	268	106	104	58	376	437	418	19
    Chicago	181	92	55	34	310	326	243	83	28	14	9	5	47	44	27	17	209	106	64	39	357	370	270	100
    KansasCity	245	89	96	60	327	361	388	-27	23	8	10	5	29	34	35	-1	268	97	106	65	356	395	423	-28
    SanJose	244	88	91	65	329	373	367	6	15	9	6	0	27	28	19	9	259	97	97	65	356	401	386	15
    Dallas	244	94	101	49	331	383	399	-16	23	5	13	5	20	30	45	-15	267	99	114	54	351	413	444	-31
    Colorado	244	91	106	47	320	356	425	-69	19	5	10	4	19	18	29	-11	263	96	116	51	339	374	454	-80
    MetroStars	244	91	116	37	310	357	405	-48	15	5	6	4	19	24	26	-2	259	96	122	41	329	381	431	-50
    NERevs	245	80	108	57	297	360	425	-65	15	4	6	5	17	14	21	-7	260	84	114	62	314	374	446	-72
    TampaBay	187	73	81	33	252	312	336	-24	11	2	9	0	6	12	23	-11	198	75	90	33	258	324	359	-35
    FusionFC	122	46	52	24	162	199	219	-20	10	3	5	2	11	6	13	-7	132	49	57	26	173	205	232	-27
    		
    [/size]
    [/QUOTE]
     
  20. Auxodium

    Auxodium New Member

    Apr 11, 2003
    Perth, Australia
    Brilliant! Thanks guys! Really great! :D

    when does the MLS kick off? Coz the NSL here is finished for good and the APL won't start until 2005! or in 10 months time :(


    and that is up to date this table?
     
  21. Auxodium

    Auxodium New Member

    Apr 11, 2003
    Perth, Australia
    Could you be o so kind to email that table as i am having troubles putting it u see. Damn computer will not accept it as it is! :(
     
  22. Auxodium

    Auxodium New Member

    Apr 11, 2003
    Perth, Australia
    I am going to be very busy so can someone who gets the MLS rounds scores please pm me that would be brilliant!

    cheers all :D
     
  23. LeeS

    LeeS Member

    Mar 23, 2002
    San Francisco, CA
    Club:
    San Jose Earthquakes
    Nat'l Team:
    United States
    Hey GF...
    Did the workbook I emailed you work out?

    Lee
     
  24. Auxodium

    Auxodium New Member

    Apr 11, 2003
    Perth, Australia
    yep all spot on but i might fall behind with the stats so please assist me.

    oh could you re arrange the tanle in W D L format? that would be great :D

    1000 thanks :D
     

Share This Page