2007 DA

I'm using the same data that they use to generate the csv files so any errors will be in both. The only difference is that in the raw data, there's a "game.isPlayed" flag which you can use to differentiate between an unreported game and an actual 0-0 tie. My guess is that given that they don't even post the scores, no one is too worried about
inaccuracies with U12.
Just making sure you knew, I’m not even remotely complaining. I am both tremendously impressed with your skills and grateful for your work. Thanks! Anyway I can help, let me know. Thanks!
 
Code:
U-12_full LA:
LAFC.......... MP: 8   W: 6   D: 2   L: 0   GF: 35   GA:  7   GD:  28   Pts: 20  Ppg:  2.5
Galaxy........ MP:10   W: 7   D: 2   L: 1   GF: 46   GA: 22   GD:  24   Pts: 23  Ppg:  2.3
TFA........... MP: 8   W: 5   D: 1   L: 2   GF: 47   GA: 12   GD:  35   Pts: 16  Ppg:    2
Pateadores.... MP:10   W: 6   D: 1   L: 3   GF: 43   GA: 34   GD:   9   Pts: 19  Ppg:  1.9
Legends....... MP: 8   W: 3   D: 2   L: 3   GF: 22   GA: 20   GD:   2   Pts: 11  Ppg: 1.38
Ventura....... MP:10   W: 3   D: 3   L: 4   GF: 21   GA: 31   GD: -10   Pts: 12  Ppg:  1.2
Golden State.. MP:10   W: 4   D: 0   L: 6   GF: 15   GA: 31   GD: -16   Pts: 12  Ppg:  1.2
LA Premier.... MP: 6   W: 2   D: 0   L: 4   GF:  8   GA: 21   GD: -13   Pts:  6  Ppg:    1
LA United..... MP: 6   W: 1   D: 1   L: 4   GF: 11   GA: 25   GD: -14   Pts:  4  Ppg: 0.67
Real So Cal... MP: 8   W: 1   D: 1   L: 6   GF: 14   GA: 26   GD: -12   Pts:  4  Ppg:  0.5
Santa Barbara. MP: 8   W: 0   D: 3   L: 5   GF: 11   GA: 44   GD: -33   Pts:  3  Ppg: 0.38

U-12 LA_A:
LAFC.......... MP: 4   W: 3   D: 1   L: 0   GF: 15   GA:  2   GD:  13   Pts: 10  Ppg:  2.5
Galaxy........ MP: 5   W: 3   D: 1   L: 1   GF: 18   GA: 15   GD:   3   Pts: 10  Ppg:    2
Legends....... MP: 4   W: 2   D: 2   L: 0   GF: 14   GA:  6   GD:   8   Pts:  8  Ppg:    2
TFA........... MP: 4   W: 2   D: 0   L: 2   GF: 29   GA: 10   GD:  19   Pts:  6  Ppg:  1.5
Pateadores.... MP: 5   W: 2   D: 1   L: 2   GF: 21   GA: 18   GD:   3   Pts:  7  Ppg:  1.4
LA United..... MP: 3   W: 1   D: 1   L: 1   GF:  7   GA:  8   GD:  -1   Pts:  4  Ppg: 1.33
Ventura....... MP: 5   W: 1   D: 3   L: 1   GF: 10   GA: 14   GD:  -4   Pts:  6  Ppg:  1.2
Golden State.. MP: 5   W: 2   D: 0   L: 3   GF:  8   GA: 18   GD: -10   Pts:  6  Ppg:  1.2
LA Premier.... MP: 3   W: 1   D: 0   L: 2   GF:  6   GA: 12   GD:  -6   Pts:  3  Ppg:    1
Real So Cal... MP: 4   W: 1   D: 0   L: 3   GF:  7   GA: 12   GD:  -5   Pts:  3  Ppg: 0.75
Santa Barbara. MP: 4   W: 0   D: 1   L: 3   GF:  5   GA: 25   GD: -20   Pts:  1  Ppg: 0.25

U-12 LA_B:
Galaxy........ MP: 5   W: 4   D: 1   L: 0   GF: 28   GA:  7   GD:  21   Pts: 13  Ppg:  2.6
TFA........... MP: 4   W: 3   D: 1   L: 0   GF: 18   GA:  2   GD:  16   Pts: 10  Ppg:  2.5
LAFC.......... MP: 4   W: 3   D: 1   L: 0   GF: 20   GA:  5   GD:  15   Pts: 10  Ppg:  2.5
Pateadores.... MP: 5   W: 4   D: 0   L: 1   GF: 22   GA: 16   GD:   6   Pts: 12  Ppg:  2.4
Ventura....... MP: 5   W: 2   D: 0   L: 3   GF: 11   GA: 17   GD:  -6   Pts:  6  Ppg:  1.2
Golden State.. MP: 5   W: 2   D: 0   L: 3   GF:  7   GA: 13   GD:  -6   Pts:  6  Ppg:  1.2
LA Premier.... MP: 3   W: 1   D: 0   L: 2   GF:  2   GA:  9   GD:  -7   Pts:  3  Ppg:    1
Legends....... MP: 4   W: 1   D: 0   L: 3   GF:  8   GA: 14   GD:  -6   Pts:  3  Ppg: 0.75
Santa Barbara. MP: 4   W: 0   D: 2   L: 2   GF:  6   GA: 19   GD: -13   Pts:  2  Ppg:  0.5
Real So Cal... MP: 4   W: 0   D: 1   L: 3   GF:  7   GA: 14   GD:  -7   Pts:  1  Ppg: 0.25
LA United..... MP: 3   W: 0   D: 0   L: 3   GF:  4   GA: 17   GD: -13   Pts:  0  Ppg:    0
 
Code:
U-12 San Diego_full:
SD Surf..... MP: 8   W: 8   D: 0   L: 0   GF: 34   GA:  2   GD:  32   Pts: 24  Ppg:    3
Strikers.... MP: 6   W: 4   D: 2   L: 0   GF: 34   GA:  5   GD:  29   Pts: 14  Ppg: 2.33
San Diego... MP:10   W: 7   D: 2   L: 1   GF: 40   GA: 13   GD:  27   Pts: 23  Ppg:  2.3
Albion...... MP: 6   W: 3   D: 2   L: 1   GF: 31   GA:  6   GD:  25   Pts: 11  Ppg: 1.83
OC Surf..... MP: 6   W: 3   D: 1   L: 2   GF: 21   GA:  9   GD:  12   Pts: 10  Ppg: 1.67
Galaxy SD... MP: 8   W: 3   D: 0   L: 5   GF:  9   GA: 12   GD:  -3   Pts:  9  Ppg: 1.13
Murrieta.... MP:10   W: 2   D: 5   L: 3   GF: 12   GA: 20   GD:  -8   Pts: 11  Ppg:  1.1
Arsenal..... MP:10   W: 3   D: 1   L: 6   GF:  8   GA: 23   GD: -15   Pts: 10  Ppg:    1
Nomads...... MP:10   W: 1   D: 2   L: 7   GF:  7   GA: 55   GD: -48   Pts:  5  Ppg:  0.5
Rebels...... MP: 8   W: 1   D: 1   L: 6   GF: 14   GA: 34   GD: -20   Pts:  4  Ppg:  0.5
Chula Vista. MP: 6   W: 0   D: 2   L: 4   GF:  7   GA: 38   GD: -31   Pts:  2  Ppg: 0.33

U-12 San Diego_A:
SD Surf..... MP: 4   W: 4   D: 0   L: 0   GF: 13   GA:  1   GD:  12   Pts: 12  Ppg:    3
San Diego... MP: 5   W: 3   D: 1   L: 1   GF: 16   GA:  9   GD:   7   Pts: 10  Ppg:    2
Strikers.... MP: 3   W: 1   D: 2   L: 0   GF: 12   GA:  4   GD:   8   Pts:  5  Ppg: 1.67
Arsenal..... MP: 5   W: 2   D: 1   L: 2   GF:  5   GA:  7   GD:  -2   Pts:  7  Ppg:  1.4
Albion...... MP: 3   W: 1   D: 1   L: 1   GF: 20   GA:  6   GD:  14   Pts:  4  Ppg: 1.33
OC Surf..... MP: 3   W: 1   D: 1   L: 1   GF: 11   GA:  3   GD:   8   Pts:  4  Ppg: 1.33
Murrieta.... MP: 5   W: 1   D: 3   L: 1   GF:  5   GA: 10   GD:  -5   Pts:  6  Ppg:  1.2
Rebels...... MP: 4   W: 1   D: 1   L: 2   GF: 10   GA: 12   GD:  -2   Pts:  4  Ppg:    1
Nomads...... MP: 5   W: 1   D: 1   L: 3   GF:  5   GA: 24   GD: -19   Pts:  4  Ppg:  0.8
Galaxy SD... MP: 4   W: 1   D: 0   L: 3   GF:  2   GA:  4   GD:  -2   Pts:  3  Ppg: 0.75
Chula Vista. MP: 3   W: 0   D: 1   L: 2   GF:  5   GA: 24   GD: -19   Pts:  1  Ppg: 0.33

U-12 San Diego_B:
SD Surf..... MP: 4   W: 4   D: 0   L: 0   GF: 21   GA:  1   GD:  20   Pts: 12  Ppg:    3
Strikers.... MP: 3   W: 3   D: 0   L: 0   GF: 22   GA:  1   GD:  21   Pts:  9  Ppg:    3
San Diego... MP: 5   W: 4   D: 1   L: 0   GF: 24   GA:  4   GD:  20   Pts: 13  Ppg:  2.6
Albion...... MP: 3   W: 2   D: 1   L: 0   GF: 11   GA:  0   GD:  11   Pts:  7  Ppg: 2.33
OC Surf..... MP: 3   W: 2   D: 0   L: 1   GF: 10   GA:  6   GD:   4   Pts:  6  Ppg:    2
Galaxy SD... MP: 4   W: 2   D: 0   L: 2   GF:  7   GA:  8   GD:  -1   Pts:  6  Ppg:  1.5
Murrieta.... MP: 5   W: 1   D: 2   L: 2   GF:  7   GA: 10   GD:  -3   Pts:  5  Ppg:    1
Arsenal..... MP: 5   W: 1   D: 0   L: 4   GF:  3   GA: 16   GD: -13   Pts:  3  Ppg:  0.6
Chula Vista. MP: 3   W: 0   D: 1   L: 2   GF:  2   GA: 14   GD: -12   Pts:  1  Ppg: 0.33
Nomads...... MP: 5   W: 0   D: 1   L: 4   GF:  2   GA: 31   GD: -29   Pts:  1  Ppg:  0.2
Rebels...... MP: 4   W: 0   D: 0   L: 4   GF:  4   GA: 22   GD: -18   Pts:  0  Ppg:    0
 
So, if we know of missing results, you want them, @focomoso? I don't mind updating the CSV file and sending it to you. (I'm just not sure how you delineate between games. I assume you make an extra column and mark 1 or 2... but I think you've long passed my ability.)
For example, the Strikers A v. Arsenal A was a 5-0 win from 9/15.
Then, this weekend, neither Albion v Murrieta games are in. Albion B won 4-3. and Albion A tied 3-3.
 
Thanks for the offer @RedDevilDad, but I don't think I'm going to update the results by hand. If the DA decides to update any of the games, my script will pick up the changes, but otherwise, it'll get too crazy to keep things synced. Maybe at the end of the season, I can run my script on your updated csv to split out the A and B games for the U12s...
 
Thanks for the offer @RedDevilDad, but I don't think I'm going to update the results by hand. If the DA decides to update any of the games, my script will pick up the changes, but otherwise, it'll get too crazy to keep things synced. Maybe at the end of the season, I can run my script on your updated csv to split out the A and B games for the U12s...
Got it. So you’re not building from the same file each week. I agree then. You’d have to change the same games every week. Ew.
Ok, Albion and Strikers parents, email your admin and get your wins reported. Lol.
 
Below are updated u12 standings thru 10/2.

Quick input on the A/B team discussion. Every u12 club is supposed to have a minimum roster of 22 players and these players are grouped into an A squad and a B squad. Every team always plays two games, and the home team always determines who will be playing who and which team will be playing when.

So, while clubs typically play in a certain pattern (some clubs always play A vs A and B vs B, and always play the B teams first and then the A teams, other clubs mix it up), there is no standardized/required order across the groups.

So, net net, accurately tracking over time how specific squads of A teams or B teams do across all games, based on the info available, is impossible.

But I completely get the desire to do so, and, if any USSDA folks are reading this, providing a field in the csv download to specify which teams are playing in a game, if that info is captured in the game card, would be super helpful.

upload_2018-10-3_8-0-11.png
 
Below are updated u12 standings thru 10/2.

Quick input on the A/B team discussion. Every u12 club is supposed to have a minimum roster of 22 players and these players are grouped into an A squad and a B squad. Every team always plays two games, and the home team always determines who will be playing who and which team will be playing when.
This isn't true. The clubs are encouraged to field two evenly matched teams and most do. There are a few clubs that refuse and a few that can't for logistical reasons and so these teams do a clear A/B, but this is generally the exception. At least it was last year and seems to be so so far this year.
 
This isn't true. The clubs are encouraged to field two evenly matched teams and most do. There are a few clubs that refuse and a few that can't for logistical reasons and so these teams do a clear A/B, but this is generally the exception. At least it was last year and seems to be so so far this year.
Focomoso, I think we're agreeing. "A" teams are supposed to always play "A" teams and "B" teams are supposed to always play "B" teams.

And, at the home team's discretion, the home team may prefer to, instead of the above, have two teams who are a mix of A and B players play two teams who are a mix of A and B players from the visiting team.

So, yes, teams will always play similar teams.

On the reporting side, the challenge is that there's no way to know for sure which types of teams are playing, unless I'm missing a field.
 
Last edited:
This isn't true. The clubs are encouraged to field two evenly matched teams and most do. There are a few clubs that refuse and a few that can't for logistical reasons and so these teams do a clear A/B, but this is generally the exception. At least it was last year and seems to be so so far this year.
For us in San Diego, it has been primarily A vs. B, while 50/50 split has been the exception.
 
For us in San Diego, it has been primarily A vs. B, while 50/50 split has been the exception.
Interesting.

Last year in LA my son played at a club that always sent out a 50/50 squad unless the opposition had A/B (except for a little experimentation at the end of the season). When parents asked why we were sticking to 50/50 when it was clear some of the competition wasn't, the coaches said that that's what US soccer asked for and they didn't want to get into trouble.

This year, he's playing on a clear A / B club, so all the games are A / B so I can't really tell what happens with the other clubs.
 
For us in San Diego, it has been primarily A vs. B, while 50/50 split has been the exception.
Yes, absolutely. We rarely saw 50/50 split last year in SD U-12 and this year's u-12 seems to be much of the same (Top 13=A/1st Game; 14-26= B/2nd Game)
 
Also, we saw a number of Youngers on the 2nd game... Several clubs are fielding large numbers of 2008s for their B team...
 
If @focomoso doesnt update within 3 minutes of my kid’s game ending, I’m prepared to reduce what we pay him!
Lol. Kidding.... of course.

Here's what the data on the DA site says, though it seems some of the results aren't correct.
Code:
U-12 LA:
LAFC.......... MP: 8   W: 6   D: 2   L: 0   GF: 35   GA:  7   GD:  28   Pts: 20  Ppg:  2.5
Galaxy........ MP:12   W: 9   D: 2   L: 1   GF: 58   GA: 23   GD:  35   Pts: 29  Ppg: 2.42
TFA........... MP:10   W: 7   D: 1   L: 2   GF: 56   GA: 13   GD:  43   Pts: 22  Ppg:  2.2
Pateadores.... MP:10   W: 6   D: 1   L: 3   GF: 43   GA: 34   GD:   9   Pts: 19  Ppg:  1.9
Legends....... MP:10   W: 5   D: 2   L: 3   GF: 29   GA: 25   GD:   4   Pts: 17  Ppg:  1.7
Ventura....... MP:12   W: 4   D: 4   L: 4   GF: 31   GA: 35   GD:  -4   Pts: 16  Ppg: 1.33
Golden State.. MP:12   W: 4   D: 0   L: 8   GF: 20   GA: 38   GD: -18   Pts: 12  Ppg:    1
LA Premier.... MP: 8   W: 2   D: 0   L: 6   GF:  9   GA: 33   GD: -24   Pts:  6  Ppg: 0.75
LA United..... MP: 8   W: 1   D: 2   L: 5   GF: 15   GA: 35   GD: -20   Pts:  5  Ppg: 0.63
Real So Cal... MP: 8   W: 1   D: 1   L: 6   GF: 14   GA: 26   GD: -12   Pts:  4  Ppg:  0.5
Santa Barbara. MP:10   W: 0   D: 3   L: 7   GF: 12   GA: 53   GD: -41   Pts:  3  Ppg:  0.3

U-12 San Diego:
SD Surf..... MP:10   W:10   D: 0   L: 0   GF: 44   GA:  3   GD:  41   Pts: 30  Ppg:    3
Albion...... MP: 8   W: 6   D: 1   L: 1   GF: 42   GA: 12   GD:  30   Pts: 19  Ppg: 2.38
Strikers.... MP: 6   W: 4   D: 2   L: 0   GF: 34   GA:  5   GD:  29   Pts: 14  Ppg: 2.33
San Diego... MP:12   W: 7   D: 2   L: 3   GF: 40   GA: 17   GD:  23   Pts: 23  Ppg: 1.92
Galaxy SD... MP:10   W: 5   D: 0   L: 5   GF: 15   GA: 13   GD:   2   Pts: 15  Ppg:  1.5
Arsenal..... MP:12   W: 5   D: 1   L: 6   GF: 11   GA: 24   GD: -13   Pts: 16  Ppg: 1.33
OC Surf..... MP: 8   W: 3   D: 1   L: 4   GF: 22   GA: 19   GD:   3   Pts: 10  Ppg: 1.25
Murrieta.... MP:10   W: 2   D: 4   L: 4   GF: 18   GA: 27   GD:  -9   Pts: 10  Ppg:    1
Nomads...... MP:10   W: 1   D: 2   L: 7   GF:  7   GA: 55   GD: -48   Pts:  5  Ppg:  0.5
Rebels...... MP: 8   W: 1   D: 1   L: 6   GF: 14   GA: 34   GD: -20   Pts:  4  Ppg:  0.5
Chula Vista. MP:10   W: 0   D: 2   L: 8   GF:  9   GA: 47   GD: -38   Pts:  2  Ppg:  0.2
 
Thank you very much for the update. LA league standings looks reasonable to me, with the two MLS teams at top. Any surprises so far for the 07 DA?
 
Ventura, for a club new to DA, is doing well. There were some folks who were skeptical of Ventura before the season started.
 
Thank you very much for the update. LA league standings looks reasonable to me, with the two MLS teams at top. Any surprises so far for the 07 DA?

The Rebels team is really a surprise.... That's the team that did well in the past few years, right?
 
The Rebels team is really a surprise.... That's the team that did well in the past few years, right?
I agree. The Rebels 07s have gone far in State Cup, Man City, etc in the past.
Arsenal’s 07s improved but lost their striker with all the dribbling skill to Legends. Murrieta Surf plays the same as always but added some finishers and are reaping the benefits. SD Surf picked up some talent from other clubs (or had kids playing with other teams over the summer). (I’m not faulting them either. We all want to develop who we have but hope for a talented player to come fill a gap.)
Chula Vista and Nomads seem the same program as last year. I feel like Albion and SD Surf are both solid at both teams.
 
I agree. The Rebels 07s have gone far in State Cup, Man City, etc in the past.
Arsenal’s 07s improved but lost their striker with all the dribbling skill to Legends. Murrieta Surf plays the same as always but added some finishers and are reaping the benefits. SD Surf picked up some talent from other clubs (or had kids playing with other teams over the summer). (I’m not faulting them either. We all want to develop who we have but hope for a talented player to come fill a gap.)
Chula Vista and Nomads seem the same program as last year. I feel like Albion and SD Surf are both solid at both teams.

The Rebels lost a lot of players. Their 1st team is still very competitive with the top teams, they just have no depth, so the 2nd team struggles. They also have only played the top 4 teams so you can't really judge them on their record to date (and no my son doesn't play for Rebels). Your assessment of the other teams is accurate. Surf are the master recruiters and have no shame about showing up to other games to recruit kids right off the touch-line (at least pre-season). Albion is deep, well coached and a lot of their kids are huge. It's sad to see what's happening with Nomads which was the Socal boys powerhouse for a couple decades.
 
Back
Top