home / australian-dogs

australian-dogs

Custom SQL query returning 464 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
RUBY 7
BELLA 6
PUGSLEY 6
ANGUS 5
DOUG 5
DOUGLAS 5
MOLLY 5
OSCAR 5
ARCHIE 4
CHARLIE 4
COOPER 4
FRANKIE 4
HARVEY 4
LOUIE 4
OLLIE 4
ROSIE 4
BRUCE 3
BUDDY 3
CHILLI 3
CHONTAE 3
COCO 3
DAISY 3
DEXTER 3
FRANK 3
FRANKIE 3
HUGO 3
LOLA 3
MAX 3
NED 3
OSCAR 3
ROXY 3
RUBY 3
SHASTA 3
VINCENT 3
WINSTON 3
ALFIE 2
BAXTER 2
BELLA 2
BENJI 2
BOSCO 2
BRANDY 2
BRUNO 2
BUSTER 2
CHAI 2
CHARLIE 2
CHARLOTTE 2
CHLOE 2
CODY 2
DEXTER 2
DIESEL 2
DUDLEY 2
EDDIE 2
ELLA 2
ELROY 2
ELTON 2
GIZMO 2
HOLLY 2
JACK 2
LILY 2
LOUIS 2
MADDY 2
MAX 2
MIA BROOKSBY 2
MILLIE 2
MILO 2
MISSY 2
MITZI 2
MOJO 2
MYA 2
NEMO 2
PEBBLES 2
PEGGY 2
PENNY 2
PHOEBE 2
POPPY 2
PRISCILLA 2
QUEENIE 2
REX 2
RUPERT 2
RUSTY 2
SODA 2
SPUD 2
STELLA 2
SUMO 2
TANGO 2
WINNIE 2
YODA 2
ZELDA 2
ABBEY 1
ACE 1
AGGIE 1
AGNES MABEL PUGSELEY 1
ANDY 1
ANNABELLE 1
ANNIE 1
ANNIE 1
ANTIQUE LACE 1
ARABELLA 1
ARCHER 1
ARIA 1
ARNIE 1
ASH 1
ATARI 1
AUDREY 1
AZTEK 1
BAILEY 1
BARKLEY 1
BARNABY 1
BARRY 1
BARRY 1
BEAR 1
BEAR 1
BEAU 1
BECKHAM 1
BENDER 1
BENNY 1
BENSON 1
BERRY 1
BERTCHELL 1
BILBO 1
BILLIE 1
BILLY 1
BINGO 1
BINKY 1
BJ 1
BLISSY 1
BOAGS 1
BOBBIE 1
BOO 1
BORIS 1
BOSTON 1
BOXER 1
BROOKLYN BELLAMI 1
BRUNA ELLIOTT 1
BUDDA 1
BUDDHA 1
BUDDY DEMPSTER 1
BULLY 1
BUNDY MAIDEN 1
BUZZ 1
BYRON 1
CAESER 1
CARLOS 1
CASEY 1
CASH 1
CEASER 1
CEE CEE 1
CHANEL 1
CHAOS 1
CHAR 1
CHARILIE 1
CHARLES PEPPI 1
CHEKO 1
CHERRY 1
CHIANA 1
CHIKO 1
CHILLI 1
CHILLIE 1
CHINNI 1
CHIPPIE 1
CHYNA 1
CINO 1
CISCO 1
CLEO 1
CODY 1
CORAL 1
CRUMPET 1
CRUMPET 1
CUDDLES 1
DAISY 1
DAISY GRACE 1
DAKOTA 1
DAPHNE 1
DARCIE 1
DELILAH 1
DENVER 1
DENZEL 1
DESSE 1
DIESAL 1
DIESEL 1
DINO 1
DISKO 1
DOCTOR SNUGGLE 1
DOLLY 1
DORA 1
EDDIE 1
EDWARD 1
ELLIE 1
ELLIE SARA 1
ELVIS 1
EMILY 1
ENZO 1
ERIC 1
FANTA 1
FAWN (PANDANLAMO SWEET AMELIA) 1
FERGIE 1
FERGUS 1
FINLEE 1
FLEUR 1
FLORENCE 1
FLOYD LANE 1
FONZY 1
FRED 1
FRITZ 1
FYNN 1
GAZ 1
GEORGE 1
GERTI 1
GERTIE 1
GIMLI 1
GINGER 1
GIR 1
GIRLIE 1
GORDON 1
GOSAMER 1
GRUG 1
GYPSY 1
HAGRID 1
HALLE 1
HALO 1
HANNAH 1
HARLEY 1
HARPER 1
HARRIETT 1
HARRY 1
HARVEY THOMSON 1
HAYLEY 1
HILLARY 1
HOLLIE 1
HUDSON 1
HUGH 1
HUGO 1
HULLABALLOO (BOO) 1
HURLEY 1
HUTCHY 1
IGGY 1
INDI 1
INDIGO` 1
IZZY 1
JACK 1
JASPA 1
JASPER 1
JAXSON 1
JAZZ 1
JEDDA 1
JENSON 1
JESSE 1
JESSIE 1
JIMMY 1
JOEY 1
JOJO 1
KALI 1
KEESHA 1
KINKO 1
KIRBY 1
KITA 1
KIZZY 1
KRUEGER 1
KYOMIE 1
LARRY 1
LAYA 1
LAYLA 1
LENNY 1
LENNY 1
LILLY 1
LILLY 1
LILY 1
LINK 1
LLOYD 1
LOLA KOLDEJ 1
LOLLY 1
LORIEN 1
LOTTO 1
LOUIE 1
LUCINDA 1
LUCY 1
LULU 1
LULU 1
MAB 1
MACEY 1
MACY 1
MALLIE 1
MANGO 1
MARLA 1
MARLEY 1
MAY 1
MAYA 1
MEATBALL 1
MEGZ 1
MIA 1
MIA 1
MICKEY 1
MIKKI 1
MING 1
MINNIE 1
MISS MOLLY 1
MISSIE 1
MOCHA 1
MOLLIE 1
MONTE 1
MONTY 1
MORRIE 1
MOUSHI 1
MR PUGGLESWORTH 1
MUFFIN 1
MULTO 1
MURPHY 1
MURRAY 1
MUSASHI 1
MYLA 1
MYLO 1
NELLIE 1
NEO 1
NITRO 1
ODIE 1
ODIE 1
OLIVE 1
OLLY 1
OTIS 1
PABLO 1
PACO 1
PAIGE 1
PARKER 1
PAULIE 1
PEGGY 1
PELE AUSTIN 1
PEPAA 1
PEPITO 1
PEPPA 1
PEPPA 1
PEPPER 1
PEPPI 1
PEPSI 1
PERCY 1
PERI 1
PETER 1
PHOEBE 1
PICKLES 1
PIKACHU 1
PING 1
PIXIE 1
PORSCHA ROSE 1
PPK1 1
PPK10 1
PPK11 1
PPK12 1
PPK13 1
PPK14 1
PPK15 1
PPK16 1
PPK17 1
PPK18 1
PPK19 1
PPK2 1
PPK20 1
PPK3 1
PPK4 1
PPK5 1
PPK6 1
PPK7 1
PPK8 1
PPK9 1
PRINCESS 1
PRISILA 1
PUCK 1
PUDDING 1
PUDDLES 1
PUFFY 1
PUG 1
PUGGA 1
PUGGLES 1
PUGLINGTON 1
PUGSIE 1
PUGSLEE 1
PUGSY 1
PUKU 1
PUMBA 1
QUEENIE 1
QUEENIE MAY 1
RALPH 1
RALPH 1
RAMBO 1
REBEL 1
REEF 1
RICO 1
RIGBY 1
ROCCO 1
ROCKY 1
RORY 1
ROSEY 1
ROSIE 1
ROWDY 1
RUBI-MAE 1
RUDY 1
RUFUS 1
RUMMY 1
RUSTY 1
SADIE 1
SAHARA 1
SAM 1
SAPPHIRE 1
SASHA 1
SEBBY 1
SHAYAH 1
SHAYNEE 1
SHUFFLES 1
SIMBA 1
SKY 1
SKYLA 1
SMOODGE 1
SMUG 1
SNICKERS 1
SNOOKI 1
SONNY 1
SONNY 1
SOOTY 1
SOPHIE 1
SPENCER 1
SPUD 1
SPUD MURPHY 1
STELLA 1
STUEY TANG 1
SU SU 1
SUBIE 1
SUKI 1
SULLY 1
SUMOMO 1
SUZIE 1
SWAYZE 1
SYD 1
TACO 1
TALIA 1
TALLY 1
TASMANIA 1
TED 1
THOR 1
TIDO 1
TILLY 1
TOBY 1
TOBY 1
TOMMY GIRL 1
TOPSY 1
TREV 1
TWITCH 1
TYRONE 1
WALLACE WALMINGTON CHARMAN 1
WALTER 1
WILBUR 1
WILLIS 1
WILLLOW 1
WILLOUGHBY 1
WILLOW WOLVERSON 1
WILSON 1
WINKIE 1
WIZARD 1
WREX 1
YOGI 1
YOGIE 1
ZAC 1
ZEPHYR 1
ZEUS 1
ZEUS 1
ZUKI 1
ZURI MSICHANA DOMBLETON 1
Powered by Datasette · Query took 13.342ms · Data source: data.sa.gov.uk