home / australian-dogs

australian-dogs

Custom SQL query returning more than 1,000 rows

select name, count(*) as n from (
  select upper("Animal name") as name from [Adelaide-City-Council-dog-registrations-2013] where Breed like "%" || :breed || "%"
union all
  select upper(Animal_Name) as name from [Adelaide-City-Council-dog-registrations-2014] where Breed_Description like "%" || :breed || "%"
union all
  select upper(Animal_Name) as name from [Adelaide-City-Council-dog-registrations-2015] where Breed_Description like "%" || :breed || "%"
union all
  select upper("AnimalName") as name from [City-of-Port-Adelaide-Enfield-Dog_Registrations_2016] where AnimalBreed like "%" || :breed || "%"
union all
  select upper("Animal Name") as name from [Mitcham-dog-registrations-2015] where Breed like "%" || :breed || "%"
union all
  select upper("DOG_NAME") as name from [burnside-dog-registrations-2015] where DOG_BREED like "%" || :breed || "%"
union all
  select upper("Animal_Name") as name from [city-of-playford-2015-dog-registration] where Breed_Description like "%" || :breed || "%"
union all
  select upper("Animal Name") as name from [city-of-prospect-dog-registration-details-2016] where"Breed Description" like "%" || :breed || "%"
) group by name order by n desc;

Query parameters

This data as .json

namen
BELLA 840
MAX 549
CHARLIE 547
MOLLY 528
BUDDY 418
RUBY 385
JACK 321
OSCAR 320
LUCY 314
COOPER 312
ROXY 280
MISSY 279
TOBY 277
COCO 259
HOLLY 222
ROCKY 222
DAISY 219
ROSIE 215
BONNIE 210
BAILEY 203
MILLIE 201
CHLOE 199
JESSIE 197
SASHA 183
HARRY 180
BUSTER 179
OLLIE 178
DIESEL 173
POPPY 170
RUSTY 170
MOLLY 167
BELLA 166
MIA 164
MILO 157
MONTY 156
LILLY 155
CHARLIE 152
LUCKY 152
SAM 151
MAGGIE 149
REX 144
ZOE 144
LILY 143
SOPHIE 143
ARCHIE 139
BEAR 134
SHADOW 131
HONEY 127
BILLY 125
MILLY 123
MAX 122
RUBY 122
JASPER 119
ANGEL 113
TILLY 112
GYPSY 110
ELLA 108
LULU 108
SALLY 107
PENNY 105
OSCAR 104
LOLA 103
MARLEY 103
BOBBY 100
HARLEY 100
SCRUFFY 99
DEXTER 98
PEPPER 98
BENJI 96
ELLIE 94
BARNEY 90
JAKE 90
LEO 90
STELLA 90
ALFIE 89
TESS 89
BUNDY 88
PATCH 88
CHESTER 87
GIZMO 87
LUCY 85
SAMMY 84
RALPH 82
SANDY 82
MISTY 81
TEDDY 81
HENRY 80
ABBY 78
TOBY 78
COOPER 77
MILLIE 77
ZEUS 77
PIPPA 76
BOOF 75
JET 75
MATILDA 75
CLEO 74
HARVEY 74
ZAC 74
JESS 73
SIMBA 73
DAISY 72
JACK 72
GEMMA 71
GEORGE 71
GUS 71
BENNY 70
BUDDY 70
CASSIE 68
MURPHY 68
LADY 67
ANGUS 66
COCO 66
INDY 66
ROSIE 66
POPPY 65
BAXTER 64
BEAU 64
HUGO 64
BEN 63
BUFFY 63
CODY 62
JAZZ 62
WINSTON 62
RILEY 61
DUKE 60
HAMISH 59
HOLLY 59
WILLOW 59
BINDI 57
EDDIE 57
PEPPA 57
BAILEY 56
PRINCESS 56
SNOOPY 56
JACKSON 55
TARA 55
CHILLI 54
FRANKIE 54
TYSON 54
HARRY 53
PHOEBE 53
BELLE 52
CASPER 52
BASIL 51
BONNIE 51
OLIVER 51
TED 51
TRIXIE 51
CHLOE 50
MONTY 50
ZIGGY 50
LILY 49
SNOWY 49
TILLY 49
EBONY 48
LOUIE 48
MINNIE 48
ROXY 48
BILLIE 47
BILLY 47
LEXI 47
MAGGIE 47
NALA 47
BENTLEY 46
BRUCE 46
JESSIE 46
RUFUS 46
SCOOBY 46
TESSA 46
BOSS 45
CINDY 45
INDIE 45
OLLIE 45
TINY 45
TURBO 45
XENA 45
ARCHIE 44
PEBBLES 44
BRUNO 43
GRACIE 43
MISHKA 43
SCOUT 43
TIA 43
ZARA 43
CHARLOTTE 42
GEORGIE 42
LOUIS 42
TIGER 42
WINNIE 42
ANNIE 41
BANJO 41
BOB 41
CHARLI 41
CHOPPER 41
COOKIE 41
NELSON 41
STORM 41
BRANDY 40
CHELSEA 40
LUNA 40
MADDIE 40
WALLY 40
AMBER 39
PIP 39
RAMBO 39
SOPHIE 39
CANDY 38
DAKOTA 38
JASPER 38
JESSE 38
KIRA 38
POLLY 38
BANDIT 37
BENSON 37
JIMMY 37
SPARKY 37
ZOE 37
DUSTY 36
IZZY 36
MACK 36
PRINCE 36
SADIE 36
ALFIE 35
DIESEL 35
HUNTER 35
KODA 35
RUSTY 35
SPIKE 35
SUZIE 35
AXEL 34
KELLY 34
MAC 34
MIA 34
PIXIE 34
SOOTY 34
BJ 33
BLAZE 33
BORIS 33
BUSTER 33
DOUGAL 33
JAX 33
JED 33
LULU 33
PARIS 33
PEPE 33
RUPERT 33
SASHA 33
SPOT 33
ELLIE 32
LOKI 32
MILO 32
BUTCH 31
EMMA 31
FRED 31
HONEY 31
MILLY 31
PIPER 31
SHEBA 31
SPENCER 31
ZAK 31
FERGUS 30
FOXY 30
HEIDI 30
HENRY 30
HUDSON 30
JASMINE 30
LOLA 30
MISSY 30
MOJO 30
SUNNY 30
TASHA 30
ABBEY 29
ACE 29
GINGER 29
INDI 29
ISABELLA 29
JUNIOR 29
MADDY 29
PIPPA 29
ROSE 29
SAM 29
SCOOTER 29
BAXTER 28
CHEWY 28
CHICO 28
DARCY 28
DOLLY 28
EVIE 28
LAYLA 28
LEXIE 28
MAXIMUS 28
SHELBY 28
TINKERBELL 28
YOGI 28
MERLIN 27
ODIE 27
PADDY 27
REGGIE 27
SCRAPPY 27
SHADOW 27
SOX 27
WINSTON 27
BRONSON 26
BRUTUS 26
BUSTA 26
CASEY 26
JADE 26
JETT 26
LEO 26
MEG 26
NED 26
ROCCO 26
SUMMER 26
THOR 26
TOMMY 26
BARNEY 25
BOOTS 25
ELLY 25
FRANK 25
GEORGE 25
JEDDA 25
JEMMA 25
MOET 25
MUFFIN 25
MYA 25
ROCKY 25
SALLY 25
BISCUIT 24
BUBBLES 24
BUSINESS 24
DIVA 24
FLASH 24
FLOYD 24
FLUFFY 24
GEMMA 24
GRACE 24
MICKEY 24
MIKA 24
MOLLIE 24
MURPHY 24
PEACHES 24
PEPPER 24
TEDDY 24
WILBUR 24
WILSON 24
ZORRO 24
BOO 23
CLYDE 23
FINN 23
GUS 23
KARMA 23
PEPSI 23
RALPH 23
REBEL 23
RED 23
SAXON 23
SEBASTIAN 23
STELLA 23
SUSIE 23
AVA 22
BEAR 22
BETTY 22
CHANEL 22
DEXTER 22
DUDLEY 22
ELLA 22
FIFI 22
HARLEY 22
HARVEY 22
HUGO 22
IZZY 22
JACKIE 22
JOCK 22
JOEY 22
KAISER 22
KOBE 22
LEVI 22
MAISIE 22
MILEY 22
MISHA 22
PANDA 22
PEANUT 22
REX 22
RORY 22
ROY 22
TANK 22
TOFFEE 22
ALICE 21
ARNIE 21
AUSSIE 21
BLOSSOM 21
BOSTON 21
BUZZ 21
DOUG 21
INDY 21
JET 21
KEISHA 21
LIZZIE 21
LUCKY 21
NIKITA 21
NUGGET 21
SAMPSON 21
SPUD 21
STANLEY 21
SUKI 21
TIMMY 21
ZENA 21
ZIGGY 21
AXLE 20
BO 20
CAESAR 20
COUGAR 20
DUKE 20
HERCULES 20
JAZZ 20
KIKI 20
LARRY 20
LOTTIE 20
MIMI 20
PHOENIX 20
SARGE 20
TED 20
TESS 20
ZOEY 20
  19
AMY 19
ASTRO 19
CHESTER 19
CLEO 19
KATIE 19
KOBI 19
LILLY 19
MACCA 19
MISTY 19
MITZI 19
PEARL 19
RILEY 19
ROBBIE 19
BASIL 18
BENNY 18
BLUE 18
BLUEY 18
BODIE 18
CHASE 18
CHINO 18
GOLDIE 18
IVY 18
JERRY 18
JESS 18
JUNO 18
LEROY 18
LOUIE 18
MAC 18
MADDIE 18
MAXI 18
MAYA 18
MONTE 18
MORGAN 18
NITRO 18
OZZIE 18
ROXIE 18
SAMSON 18
SARAH 18
SONNY 18
SOOKIE 18
TAMMY 18
TEX 18
TIGGER 18
WOODY 18
ZAC 18
APRIL 17
ASH 17
BARRY 17
BOBBY 17
BOSCO 17
BRUISER 17
COSMO 17
CUJO 17
DORA 17
FLETCHER 17
FRANKIE 17
GABBY 17
GEORGIA 17
HAMISH 17
HAPPY 17
KAYLA 17
KOKO 17
MAISY 17
MUFFY 17
MURRAY 17
ODIN 17
OLIVE 17
PENNY 17
ROMEO 17
SCAMP 17
SHEEBA 17
SOCKS 17
TIFFANY 17
TINA 17
ALI 16
ALLY 16
ASHA 16
BANJO 16
BECKY 16
CHIEF 16
CLANCY 16
DANNY 16
DASH 16
EVA 16
GINGER 16
HANNAH 16
KEVIN 16
LOLLY 16
MAVERICK 16
MEEKA 16
NARLA 16
OBI 16
PATCH 16
PORTIA 16
STITCH 16
TAZ 16
ANGEL 15
ANGUS 15
BOLT 15
BOOMER 15
BRONTE 15
BUDDHA 15
CHARLI 15
CHILLI 15
DOZER 15
ELVIS 15
EMILY 15
FERGUS 15
FRITZ 15
HANK 15
HARPER 15
JAZZY 15
KIRA 15
LENNY 15
LILO 15
LOUIS 15
MANGO 15
MINI 15
MOCHA 15
MOOSE 15
NALA 15
NELLIE 15
NELSON 15
OLIVER 15
OLLY 15
OTTO 15
QUEENIE 15
RASCAL 15
RYDER 15
SHAGGY 15
SKYE 15
SMUDGE 15
TIPPY 15
ZUES 15
AMBER 14
BEAU 14
BESS 14
BESSIE 14
BLACKIE 14
BLACKY 14
BOBBIE 14
BULLET 14
CASSIE 14
CHEVY 14
CHEWIE 14
CRYSTAL 14
EBONY 14
ELLE 14
FELIX 14
FLYNN 14
KANE 14
KUMA 14
LACEY 14
LEWIS 14
LEXI 14
LIZZY 14
MAISIE 14
MISCHA 14
MISSIE 14
OZZY 14
PEPPI 14
PERCY 14
POLLY 14
RUBI 14
RUPERT 14
RUSSELL 14
SASSY 14
SNOOP 14
THOMAS 14
UNKNOWN 14
WILLOW 14
ABBY 13
ANDY 13
APOLLO 13
ARCHER 13
BACI 13
BILL 13
BUTTONS 13
CALVIN 13
CLOE 13
COCOA 13
CODY 13
ECHO 13
GRACIE 13
GUCCI 13
HOOCH 13
INDIANA 13
INDIE 13
JAFFA 13
JESSICA 13
JESSY 13
KIARA 13
KODI 13
MACEY 13
MARLEY 13
MEG 13
MINTY 13
MITZY 13
MORRIS 13
NAHLA 13
OSKAR 13
PEGGY 13
PRECIOUS 13
RINGO 13
RIPLEY 13
ROCKET 13
ROGER 13
SABRE 13
SANDY 13
SAPPHIRE 13
SHILOH 13
STAR 13
SUGAR 13
TIA 13
TOTO 13
TULLY 13
WALTER 13
YOSHI 13
ZIVA 13
ALBERT 12
ALBY 12
ATHENA 12
AUDREY 12
BERTIE 12
BILLIE 12
BLADE 12
BOOF 12
BRAX 12
BROCK 12
BRODIE 12
BRUCE 12
BUTTERS 12
CALLIE 12
CASH 12
CHARLEY 12
CHERRY 12
CHI CHI 12
CUDDLES 12
DOUGAL 12
DUDLEY 12
ELMO 12
GIDGET 12
GYPSY 12
HERO 12
HURLEY 12
JAXON 12
JJ 12
KAOS 12
KARA 12
KIMBA 12
KIRRA 12
LARA 12
LILLIE 12
MACY 12
MAISY 12
MASON 12
MAXWELL 12
MIFFY 12
NIKKI 12
NINA 12
OTIS 12
PEDRO 12
PHOEBE 12
PICKLES 12
PUPPY 12
RONNIE 12
SAMANTHA 12
SCRUFFY 12
SHELLEY 12
SHORTY 12
SID 12
SKY 12
SPARKY 12
SUSHI 12
TAFFY 12
TITAN 12
WILMA 12
ANNIE 11
BABY 11
BAMBI 11
BART 11
BELLE 11
BREE 11
BUFFY 11
CHIKO 11
COBY 11
DARCY 11
DIGGER 11
DJ 11
DUSTY 11
ELSIE 11
ERNIE 11
FRANKLIN 11
HALO 11
JAMIE 11
JD 11
JERSEY 11
JIMMY 11
JORDAN 11
KENNY 11
KING 11
LIBBY 11
MAJOR 11
MANDY 11
MARTY 11
MIKEY 11
MINNIE 11
NAPOLEON 11
NELLIE 11
NICKY 11
NINJA 11
NOAH 11
OREO 11
PABLO 11
PEPE 11
PEPPA 11
PLUTO 11
PUMPKIN 11
REUBEN 11
RICKY 11
ROWDY 11
RUFUS 11
SAMMY 11
SCOTTY 11
SCRUFF 11
SHEP 11
SHILO 11
SPIKE 11
SPOTTY 11
SYDNEY 11
TARA 11
TESSA 11
THUNDER 11
TIGER 11
TUPPENCE 11
WILFRED 11
WINNIE 11
YODA 11
ZACK 11
ZELDA 11
ZEUS 11
ABBIE 10
AJ 10
ALEX 10
ARTHUR 10
BEN 10
BENJI 10
BENSON 10
BENTLEY 10
BERT 10
BINDY 10
BONNY 10
BUDDIE 10
CHEEKY 10
CHICA 10
CHOCCO 10
CJ 10
CONAN 10
COOKIE 10
EDWARD 10
ELSA 10
FRED 10
FUDGE 10
GEORGIE 10
GIGI 10
HAYLEY 10
HECTOR 10
HOLLIE 10
HOOVER 10
JACKSON 10
JAGGER 10
JAKE 10
JASMINE 10
JAZ 10
JESSE 10
JILL 10
JOEY 10
JOSIE 10
KEIRA 10
KOBY 10
KUJO 10
LILI 10
MADDY 10
MADISON 10
MARLEE 10
MAXIE 10
MICK 10
MICKY 10
MINDY 10
MOLLIE 10
MOSES 10
NEMO 10
OAKLEY 10
ONYX 10
PEPSI 10
PIXIE 10
PUGSLEY 10
RANI 10
RASTUS 10
ROGUE 10
RORY 10
ROSY 10
RUSS 10
SCOOBY 10
SHANDY 10
SMOKEY 10
STANLEY 10
SUNNY 10
SWEETIE 10
TAYLA 10
TERRA 10
TIMMY 10
VENUS 10
VIOLET 10
WATSON 10
WHISKEY 10
YUKI 10
ABBEY 9
AKIRA 9
AUSTIN 9
BETSY 9
BINDI 9
BINGO 9
BOBO 9
BOO BOO 9
BOSS 9
BRIDGET 9
BRIDIE 9
BULLY 9
CARLY 9
CASPER 9
CHAMP 9
CHARLEE 9
CHARLOTTE 9
CHIP 9
CHOCO 9
CHUCK 9
CINDY 9
CONNOR 9
CYRUS 9
DAPHNE 9
DASH 9
DAVE 9
DIGBY 9
DIXIE 9
DOG 9
DOUGLAS 9
DUTCH 9
EDDY 9
ELVIS 9
FLETCHER 9
FREDDY 9
HERBIE 9
HUDSON 9
HUNTER 9
IGGY 9
INDIA 9
JAK 9
JAY 9
JESSI 9
JOSH 9
KASEY 9
KEESHA 9
KELLY 9
LEELA 9
LOKI 9
LUKE 9
MITZI 9
MOE 9
MOJO 9
MUFFIN 9
MURRAY 9
MUTLEY 9
NACHO 9
NELLY 9
NERO 9
NESSIE 9
OSKA 9
PARKER 9
PATCHES 9
PATRICK 9
PIPER 9
PIPPI 9
RALPHIE 9
REMY 9
ROBBIE 9
ROLLY 9
ROSCO 9
RUDY 9
SCOUT 9
SHEILA 9
SHERLOCK 9
SISSY 9
SKIP 9
SKIPPER 9
SPIRIT 9
STEVIE 9
SUZIE 9
TORI 9
TRIGGER 9
TRIXIE 9
TURBO 9
TWIGGY 9
TY 9
VEGAS 9
WAGS 9
WALLACE 9
WALLY 9
XENA 9
ZARA 9
AGGIE 8
AJAX 8
ARABELLA 8
ARNOLD 8
ASHA 8
ASHER 8
ASTRO 8
BAYLEE 8
BESSIE 8
BOOFA 8
BORIS 8
BOWSER 8
BYRON 8
CHARLY 8
CHELSEA 8
CLAIRE 8
CLAUDE 8
CLIFFORD 8
CURLY 8
DALLAS 8
DANTE 8
DELTA 8
DIGGER 8
DODGE 8
DOTTI 8
EDDIE 8
ELSIE 8
FLYNN 8
FRECKLES 8
FREDDIE 8
GEM 8
GHOST 8
GIZMO 8
HENRI 8
HOMER 8
HUMPHREY 8
JAY JAY 8
JO JO 8
JOJO 8
KAI 8
KITA 8
LADY 8
LANA 8
LEAH 8
LILA 8
LOLLIE 8
LOTTIE 8
LOU 8
MABEL 8
MACY 8
MANNY 8
MATILDA 8
MIDGE 8
MILLI 8
MINI 8
MITCH 8
MOMO 8
NANCY 8
NED 8
NOODLE 8
NORMAN 8
ODDIE 8
OLIVE 8
OPAL 8
Powered by Datasette · Query took 142.258ms · Data source: data.sa.gov.uk