What high schools produce the most recruits in the Pac-12 recruiting footprint?

A few notes:
--The time period I used was '08-'16. I would prefer to have the last two cycles included, but I found easily readable CSV files of older classes online. I am pretty sure the source was Scout. Extracting ALL of the records from the Rivals or 247 databases requires ninja skills I don't yet posses.
--In order to keep the list of High Schools somewhat manageable, I filtered out schools that produced less than 3 recruits over that time frame.
--I am still working on my Tableau skills. Ideally I will create a table that can be drilled down to the individual recruit level and is sortable by star-ranking, etc.
High Schools Producing the Most Recruits in Pac-12 Footprint
Here is the money (screen) shot for California. It includes all high schools that produced double digit recruits over that time frame - averaging out to a minimum of a little over a recruit per cycle.

Comments
-
Good stuff
IE Life -
I thought my life was pathetic
-
Oh, forgot to mention that I also included Nevada in the geographical footprint.
-
It might be interesting to see what kind of talent they are producing as well. An average rating for each school's recruits or something along those lines.AIRWOLF said:In my continuing quest to
prove I have no life whatsoeverlearn some data analysis skills, I have created a monster table that has tabulated all of the FBS recruits from the states that I consider part of the Pac-12's natural recruiting footprint (CA, WA, OR, ID, UT, AZ, HI, CO).
A few notes:
--The time period I used was '08-'16. I would prefer to have the last two cycles included, but I found easily readable CSV files of older classes online. I am pretty sure the source was Scout. Extracting ALL of the records from the Rivals or 247 databases requires ninja skills I don't yet posses.
--In order to keep the list of High Schools somewhat manageable, I filtered out schools that produced less than 3 recruits over that time frame.
--I am still working on my Tableau skills. Ideally I will create a table that can be drilled down to the individual recruit level and is sortable by star-ranking, etc.
High Schools Producing the Most Recruits in Pac-12 Footprint
Here is the money (screen) shot for California. It includes all high schools that produced double digit recruits over that time frame - averaging out to a minimum of a little over a recruit per cycle. -
I am not arguing, but I would much rather do these tutorials using recruiting data rather than the sales and financial results of a fake bicycle company (that is a real example).WeakarmCobra said:I thought my life was pathetic
-
Fuck you, u just described my fucking job.AIRWOLF said:
I am not arguing, but I would much rather do these tutorials using recruiting data rather than the sales and financial results of a fake bicycle company (that is a real example).WeakarmCobra said:I thought my life was pathetic
-
I did a quick filter and included only recruits that eventually signed with Pac-12 schools. That filtered out the recruits that signed with Group of 5 schools, but also removed the recruits that got poached by Power 5 level schools from outside of the region.UW_Doog_Bot said:
It might be interesting to see what kind of talent they are producing as well. An average rating for each school's recruits or something along those lines.AIRWOLF said:In my continuing quest to
prove I have no life whatsoeverlearn some data analysis skills, I have created a monster table that has tabulated all of the FBS recruits from the states that I consider part of the Pac-12's natural recruiting footprint (CA, WA, OR, ID, UT, AZ, HI, CO).
A few notes:
--The time period I used was '08-'16. I would prefer to have the last two cycles included, but I found easily readable CSV files of older classes online. I am pretty sure the source was Scout. Extracting ALL of the records from the Rivals or 247 databases requires ninja skills I don't yet posses.
--In order to keep the list of High Schools somewhat manageable, I filtered out schools that produced less than 3 recruits over that time frame.
--I am still working on my Tableau skills. Ideally I will create a table that can be drilled down to the individual recruit level and is sortable by star-ranking, etc.
High Schools Producing the Most Recruits in Pac-12 Footprint
Here is the money (screen) shot for California. It includes all high schools that produced double digit recruits over that time frame - averaging out to a minimum of a little over a recruit per cycle.
The biggest takeaway, is that outside of CA there are very few high schools that produce Pac-12 level recruits year in and year out.
Of course we all know this, but looking at the numbers, it is pretty sobering. -
Looking at some of it it seems you have 35 Ca. schools who have produced 9(avg 1 per year) or more recruits. Those schools are responsible for producing almost exactly HALF or all the recruits recorded.
-
Even more sobering when you consider the average over time means only about 4 schools in that entire sample are producing more than 1 player per year. Someone send this to Kalepo's coach.AIRWOLF said:
I did a quick filter and included only recruits that eventually signed with Pac-12 schools. That filtered out the recruits that signed with Group of 5 schools, but also removed the recruits that got poached by Power 5 level schools from outside of the region.UW_Doog_Bot said:
It might be interesting to see what kind of talent they are producing as well. An average rating for each school's recruits or something along those lines.AIRWOLF said:In my continuing quest to
prove I have no life whatsoeverlearn some data analysis skills, I have created a monster table that has tabulated all of the FBS recruits from the states that I consider part of the Pac-12's natural recruiting footprint (CA, WA, OR, ID, UT, AZ, HI, CO).
A few notes:
--The time period I used was '08-'16. I would prefer to have the last two cycles included, but I found easily readable CSV files of older classes online. I am pretty sure the source was Scout. Extracting ALL of the records from the Rivals or 247 databases requires ninja skills I don't yet posses.
--In order to keep the list of High Schools somewhat manageable, I filtered out schools that produced less than 3 recruits over that time frame.
--I am still working on my Tableau skills. Ideally I will create a table that can be drilled down to the individual recruit level and is sortable by star-ranking, etc.
High Schools Producing the Most Recruits in Pac-12 Footprint
Here is the money (screen) shot for California. It includes all high schools that produced double digit recruits over that time frame - averaging out to a minimum of a little over a recruit per cycle.
The biggest takeaway, is that outside of CA there are very few high schools that produce Pac-12 level recruits year in and year out.
Of course we all know this, but looking at the numbers, it is pretty sobering. -
Your spreadsheet is obviously wrong as I see no mention of #mylancers.AIRWOLF said:
I did a quick filter and included only recruits that eventually signed with Pac-12 schools. That filtered out the recruits that signed with Group of 5 schools, but also removed the recruits that got poached by Power 5 level schools from outside of the region.UW_Doog_Bot said:
It might be interesting to see what kind of talent they are producing as well. An average rating for each school's recruits or something along those lines.AIRWOLF said:In my continuing quest to
prove I have no life whatsoeverlearn some data analysis skills, I have created a monster table that has tabulated all of the FBS recruits from the states that I consider part of the Pac-12's natural recruiting footprint (CA, WA, OR, ID, UT, AZ, HI, CO).
A few notes:
--The time period I used was '08-'16. I would prefer to have the last two cycles included, but I found easily readable CSV files of older classes online. I am pretty sure the source was Scout. Extracting ALL of the records from the Rivals or 247 databases requires ninja skills I don't yet posses.
--In order to keep the list of High Schools somewhat manageable, I filtered out schools that produced less than 3 recruits over that time frame.
--I am still working on my Tableau skills. Ideally I will create a table that can be drilled down to the individual recruit level and is sortable by star-ranking, etc.
High Schools Producing the Most Recruits in Pac-12 Footprint
Here is the money (screen) shot for California. It includes all high schools that produced double digit recruits over that time frame - averaging out to a minimum of a little over a recruit per cycle.
The biggest takeaway, is that outside of CA there are very few high schools that produce Pac-12 level recruits year in and year out.
Of course we all know this, but looking at the numbers, it is pretty sobering. -
M'eh. The great 1.7 star recruit Stan Empertmann came from an FFA high school on the plains of Eastern Washington. If they can play, it doesn't matter where they are from.
-
Bellevue is pretty high up for being in WA. Good thing we started getting their kids. Look for EC to shoot up the charts in coming years
-
PM to Joey Thomas: where are #yourbulldogs?
-
Any way to sort by which high schools UW has "pipelines" from?
2018 class we signed kids from the following schools that had produced 10 or more recruits over the designated time period:
De la Salle
Mission Viejo
Centennial (AZ)
In 2019 we have offers to kids from:
St. John Bosco (5)
Mater Dei (4)
Oaks Christian (2)
Long Beach Poly (2)
De La Salle (2)
Lutheran
Narbonne
Punahou -
I’m glad we got a toe hold into East High, SLC. Lotta beef up in thurr.
-
no Woodinville? I demand a recount
-
Getting big time recruits from De La Salle, East HS SLC and the state of Nevada were all huge in their own ways. Monumental class.
-
Can you do one where you split out schools like USC, UCLA, etc. from schools like Wazzu and OSU?
I'd be curious how schools like USC, Stanford, and others are recruiting outside the Pac-12 footprint versus inside. -
I can do this.FremontTroll said:Any way to sort by which high schools UW has "pipelines" from?
2018 class we signed kids from the following schools that had produced 10 or more recruits over the designated time period:
De la Salle
Mission Viejo
Centennial (AZ)
In 2019 we have offers to kids from:
St. John Bosco (5)
Mater Dei (4)
Oaks Christian (2)
Long Beach Poly (2)
De La Salle (2)
Lutheran
Narbonne
Punahou
I can also do this.whatshouldicareabout said:Can you do one where you split out schools like USC, UCLA, etc. from schools like Wazzu and OSU?
I'd be curious how schools like USC, Stanford, and others are recruiting outside the Pac-12 footprint versus inside.
I just need to get away from all the fun projects I have been doing around the house.
It's a hell of a thing when you have more free time on weekdays than on the weekends, but I am married and just moved into a house we remodeled. It cuts into my time spent in the basement. -
Did we tell his hs coach to fuck off yet?
-
you have a lot of hate in your lifehaie said:Did we tell his hs coach to fuck off yet?