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

AIRWOLF

AIRWOLF

New Fish
In my continuing quest to prove I have no life whatsoever[/s] learn 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.

3w45e4fd1mb5.jpg

 
In my continuing quest to prove I have no life whatsoever[/s] learn 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.

View attachment 370
Click to expand...

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.
 
I thought my life was pathetic
Click to expand...

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).
 
I thought my life was pathetic
Click to expand...

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 [/b](that is a real example).
Click to expand...
Fuck you, u just described my fucking job.
 
In my continuing quest to prove I have no life whatsoever[/s] learn 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.

View attachment 370
Click to expand...

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.
Click to expand...

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.

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.

rhyf3dv234rd.jpg

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.
 
In my continuing quest to prove I have no life whatsoever[/s] learn 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.

View attachment 370
Click to expand...

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.
Click to expand...

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.

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.

View attachment 11534

Of course we all know this, but looking at the numbers, it is pretty sobering.
Click to expand...

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.
 
In my continuing quest to prove I have no life whatsoever[/s] learn 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.

View attachment 370
Click to expand...

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.
Click to expand...

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.

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.

View attachment 11534

Of course we all know this, but looking at the numbers, it is pretty sobering.
Click to expand...

Your spreadsheet is obviously wrong as I see no mention of #mylancers.
 
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
 
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
 
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.
 
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
Click to expand...

I can do this.

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.
Click to expand...

I can also do this.

I just need to get away from all the fun[/i] 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.
 
You must log in or register to reply here.
Back
Top