Schnauzer name and type Statistics

Thought of something to make the forum better. Then please share. We welcome suggestions to improve the forum.
User avatar
TheDobbins
Puppy
Posts: 37
Joined: 24 Mar 2013, 23:43
First Name: TheDobbins
Dog #1: Essen
is a: P/S Mini Dog

Schnauzer name and type Statistics

Post by TheDobbins »

Apologies if this is already available, but wondered if you are able to pull data from the names/type of dogs which people type in on the user account screens.

It would probably make for interesting reading seeing the total number of Schnauzers by colouring/type/breed as well as things like most common/most unusual names for each breed.

What do you think?

User avatar
lj_thorne
Member
Posts: 2289
Joined: 21 Nov 2011, 14:56
First Name: Lisa
Dog #1: Barnaby
is a: P/S Mini Dog
Born: 16 Oct 2010
Dog #2: Albert
is a: B/S Mini Dog
Born: 24 Jul 2012
Dog #3: Sherman
Born: 21 Sep 2014
is a: B/S Mini Dog
Location: bedfordshire

Re: Schnauzer name and type Statistics

Post by lj_thorne »

ooh... I don't know if it's possible but yes it would be interesting.....
Human slave to my three furry boys Albert, Sherman and Rupert the Bear

Barnaby 🌈

https://m.facebook.com/schnauzerlads/

User avatar
Guinevere
Member
Posts: 2427
Joined: 30 Jan 2010, 19:19
First Name: Sharon
Dog #1: Arthur
is a: Black Mini Dog
Born: 28 Dec 2009
Location: Billinge

Re: Schnauzer name and type Statistics

Post by Guinevere »

I am thick but don't know what you mean

User avatar
Donald
Member
Posts: 2142
Joined: 07 Dec 2011, 14:27
First Name: Donald
Dog #1: Chester
is a: Black Giant Dog
Born: 01 Mar 2012
Location: Aberdeen

Re: Schnauzer name and type Statistics

Post by Donald »

I think what is meant is to get a digest of dog names, sizes and colours from the info to the right of each post.

Dean would be the person to ask.

User avatar
TheDobbins
Puppy
Posts: 37
Joined: 24 Mar 2013, 23:43
First Name: TheDobbins
Dog #1: Essen
is a: P/S Mini Dog

Re: Schnauzer name and type Statistics

Post by TheDobbins »

Donald wrote:I think what is meant is to get a digest of dog names, sizes and colours from the info to the right of each post.

Dean would be the person to ask.
Yep, that's exactly what I meant!
Eg:
Most/least common names (list of names)
Most/least common colours
Most/least common breeds
Total/average schnauzers per person
(And a mix of all the above, e.g. Most common Mini Schnauzer colour)
Things like that.

Seems a shame to have all this extra info and do nothing with it! I'd be pleased to help!

User avatar
Donald
Member
Posts: 2142
Joined: 07 Dec 2011, 14:27
First Name: Donald
Dog #1: Chester
is a: Black Giant Dog
Born: 01 Mar 2012
Location: Aberdeen

Re: Schnauzer name and type Statistics

Post by Donald »

I've no idea how much work this will create for Dean.

But I'd like to see this too.

But not if it's a huge load of work.

User avatar
Dinkum
Tech Team
Posts: 2542
Joined: 10 Jan 2011, 12:47
First Name: Dean
Dog #1: Rupert
is a: Black Mini Dog
Born: 24 Dec 2010
Dog #2: Watson
is a: Black Mini Dog
Born: 21 Feb 2012
Location: Tunbridge Wells, Kent

Re: Schnauzer name and type Statistics

Post by Dinkum »

Now I know why my ears have been ringing all day =))

Finding out the size of dog, sex, colour, etc is pretty straight forward. Not something that would be able to be done by everyone on the forum, but I would need to write a query to the database that will return the numbers. Getting this info is straight forward as there are only a few options and counting them is fairly easy.

The names of dogs is something totally different. Because it is a free form field as in anyone can put anything in there, there is no way of doing a straight forward count. You would also have to take variations into account, such as Monty and Montie.

I'll spend a few minutes on it and see what I come up with but I make no promises as my time is limited at the moment.
Dean & Jolyon
Rupert, black mini born 24/12/10
Watson, black mini born 21/02/12

I offer my advice freely, but I am not an expert, breeder, groomer or behaviourist. It is simply my experience of raising pups in a way that seems to make sense.

User avatar
TheDobbins
Puppy
Posts: 37
Joined: 24 Mar 2013, 23:43
First Name: TheDobbins
Dog #1: Essen
is a: P/S Mini Dog

Re: Schnauzer name and type Statistics

Post by TheDobbins »

No worries Dean - well done for looking into this! As you can probably tell from the creation of this post, I like facts and figures and regularly pull stats/write queries for work. If you could anonymise the info, as mentioned before, I'd be happy to help. But this is v low priority request so please don't go to any trouble. Was just intrigued!

Oh, and I completely understand about free-text fields. The curse of analysts everywhere!

User avatar
Maty
Member
Posts: 11040
Joined: 10 Sep 2011, 21:27
First Name: Kate
Dog #1: Isaura Lucidus
is a: P/S Mini Dog
Born: 10 Aug 2011
Dog #2: Darksprite Finn Mac
is a: P/S Mini Dog
Born: 17 Mar 2013
Location: Hertfordshire
Contact:

Re: Schnauzer name and type Statistics

Post by Maty »

Just from being around the forum a lot I would say the most common name is Monty, there are at least two Watsons, and only one Rodders :D
Maty

Rodders the Mini Pup, born 10/08/11, came home on 09/10/11
Creggan the Mini Pup, born 17/03/13, came home on 01/06/13

Proud of my Scottish Heritage

User avatar
MieleMoo
Member
Posts: 1141
Joined: 10 Nov 2011, 23:01
First Name: Nik
Dog #1: Miele
is a: Black Std Bitch
Born: 28 Jun 2011

Re: Schnauzer name and type Statistics

Post by MieleMoo »

Maty wrote:Just from being around the forum a lot I would say the most common name is Monty, there are at least two Watsons, and only one Rodders :D
:-" :-"
:D
Ummm you forgot the girlies
Miele: 28/06/2011
My dog's not spoiled ... I'm just well trained

User avatar
BeeBee
Member
Posts: 7576
Joined: 18 Dec 2010, 08:09
First Name: Janetta
Location: France
Contact:

Re: Schnauzer name and type Statistics

Post by BeeBee »

Definitely only one each of mine too, I mean, 2 Twinkle Berry's???
Jasmine (RIP) Renae b.01.11.10, sister to Susie-Belle (RIP), Twinkle (RIP), Cerise & Albert Claude puppy farm rescues, my muses
Creator of Schnauzerfest a good thing made possible by 1000s of good people & dogs
https://www.facebook.com/pages/Susie-Be ... 0289434936
http://www.janettaharvey.com/

User avatar
Dinkum
Tech Team
Posts: 2542
Joined: 10 Jan 2011, 12:47
First Name: Dean
Dog #1: Rupert
is a: Black Mini Dog
Born: 24 Dec 2010
Dog #2: Watson
is a: Black Mini Dog
Born: 21 Feb 2012
Location: Tunbridge Wells, Kent

Re: Schnauzer name and type Statistics

Post by Dinkum »

Here is something. I've not formatted it or anything. It's basically raw.
Dean & Jolyon
Rupert, black mini born 24/12/10
Watson, black mini born 21/02/12

I offer my advice freely, but I am not an expert, breeder, groomer or behaviourist. It is simply my experience of raising pups in a way that seems to make sense.

User avatar
jaegervalder
Member
Posts: 1357
Joined: 21 Mar 2011, 08:57
First Name: Kathleen
Dog #1: Schnapps
is a: P/S Mini Bitch
Born: 25 Oct 2006
Dog #2: Darcie
is a: P/S Mini Bitch
Born: 29 Dec 2006
Dog #3: Juno
Born: 0- 0-2010
is a: P/S Mini Bitch
Location: Brighton, Hove actually!

Re: Schnauzer name and type Statistics

Post by jaegervalder »

Definitely Only one Mental! ( Darcie to most of you)
Schnapps , the lovely big sister to mental Darcie , the untouchable
and now introducing Juno Lucina Sparkle Marzipan Sunshine.....a big name for a big dog!!
and Kathleen! (Oh and Mel, OH!)

User avatar
Caramomo
Site Admin
Posts: 9161
Joined: 20 Nov 2008, 03:47
First Name: Elaine
Dog #1: Cara
is a: Black Mini Bitch
Born: 05 Dec 2006
Dog #2: Momo
is a: Black Mini Bitch
Born: 14 Aug 2009
Dog #3: Molly
Born: 01 Aug 2010
Location: Johor Bahru , Malaysia

Re: Schnauzer name and type Statistics

Post by Caramomo »

A quick calculation based on Deans figures gives us;
Mini's 321
Standards 36
Giants 35
Bitches 186
Dogs 206

That doesn't include the figures for White Mini Dog as they totaled at 1906, so I'm guessing that includes all those who haven't entered a breed for their dog.

As for splitting it by colour and size we have;
White Mini Dog 1906
White Mini B 4
P&S Mini 220
B&S Mini 48
Black Mini 49
P&S Std 17
B&S Std 1
Black Std 18
P&S Giant 1
Black Giant 34

So P&S mini's are by far the most popular. No one has a B&S Giant. I'd love to see the photo of the B&S Standard someone says they have, I didn't think you could get those!
Cara and Mo, two black mini's and Molly a black & white Heinz 57 all served by Elaine, the cook, poop picker, and chief toy thrower.
I live by the Mini Schnauzer code; when in danger or in doubt, run in circles, scream and shout!

User avatar
TheDobbins
Puppy
Posts: 37
Joined: 24 Mar 2013, 23:43
First Name: TheDobbins
Dog #1: Essen
is a: P/S Mini Dog

Re: Schnauzer name and type Statistics

Post by TheDobbins »

Good start guys! Is it wrong that this sort of stuff excites me? Ha! :))
Well done on getting this info so quickly!

Interesting to see the split in breeds/colours. Is this what people expected?
And the 'white mini dog' scenario is one I often come across. i.e. are there really that many dogs of that type, or is this a data collection issue? I'd agree with Elaine in that it seems as if there is something not quite right there. But even at this level it's interesting to see the splits.

I have all sorts of combinations and permutations of ideas floating around:
- does the colour/breed of the dog make it any more less likely to have a name beginning with a certain letter ?
- % of dogs with names similar to their owners
- Is a male more likely to own a dog or a bitch?
- Are some colours more popular as years go on?
- average posts per user based on dog type

Maybe I'm getting carried away now! :-))

Post Reply