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

AIRWOLF

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

RaceBannon

Good stuff

IE Life

FireCohen

I thought my life was pathetic

AIRWOLF

Oh, forgot to mention that I also included Nevada in the geographical footprint.

UW_Doog_Bot

AIRWOLF said:

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

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

WeakarmCobra said:

I thought my life was pathetic

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).

FireCohen

AIRWOLF said:

WeakarmCobra said:

I thought my life was pathetic

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).

Fuck you, u just described my fucking job.

AIRWOLF

UW_Doog_Bot said:

AIRWOLF said:

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

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 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.



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

UW_Doog_Bot

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.

UW_Doog_Bot

AIRWOLF said:

UW_Doog_Bot said:

AIRWOLF said:

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

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 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.



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

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.

CFetters_Nacho_Lover

AIRWOLF said:

UW_Doog_Bot said:

AIRWOLF said:

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

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 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.



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.

PurpleThrobber

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.

Ice_Holmvik

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

TTJ

PM to Joey Thomas: where are #yourbulldogs?

FremontTroll

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

Quietcowskee

I’m glad we got a toe hold into East High, SLC. Lotta beef up in thurr.

DerekJohnson

no Woodinville? I demand a recount

dnc

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.

whatshouldicareabout

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.

AIRWOLF

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 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 can also do this.

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.

haie

Did we tell his hs coach to fuck off yet?