cocoon icon

Data Cleaning

Powered by Cocoon

aac_shelter_cat_outcome_eng

(First 100 rows)
Before After
name outcome_type sex_upon_outcome sex_age_outcome color1 breed Spay_Neuter color outcome_subtype outcome_age__years_ dob_year outcome_weekday dob_month breed2 animal_id count_ outcome_age__days_ Periods outcome_hour coat coat_pattern color2 age_upon_outcome animal_type outcome_year age_group Cat_Kitten__outcome_ breed1 sex domestic_breed outcome_month cfa_breed dob_monthyear date_of_birth datetime monthyear Period_Range
0 None Transfer Intact Male Intact Male Kitten orange domestic shorthair No orange Partner 0.038356 2014 Tuesday 7 None A684346 1 14 2 16 orange tabby None 2 weeks Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Male True 7 False 2014-07 2014-07-07 00:00:00 2014-07-22 16:04:00 2014-07-22T16:04:00 7
1 Lucy Adoption Intact Female Intact Female Kitten blue domestic shorthair No blue /white None 0.082192 2014 Thursday 6 None A685067 1 30 1 18 blue tabby white 1 month Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 8 False 2014-08 2014-06-16 00:00:00 2014-08-14 18:45:00 2014-08-14T18:45:00 30
2 *Frida Adoption Spayed Female Spayed Female Kitten white domestic shorthair Yes white/black Offsite 0.246575 2014 Sunday 3 None A678580 1 90 3 17 white None black 3 months Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 6 False 2014-06 2014-03-26 00:00:00 2014-06-29 17:45:00 2014-06-29T17:45:00 30
3 Stella Luna Return to Owner Spayed Female Spayed Female Cat black domestic mediumhair Yes black/white None 1.000000 2013 Friday 3 None A675405 1 365 1 14 black None white 1 year Cat 2014 (-0.022, 2.2] Cat domestic mediumhair Female True 3 False 2014-03 2013-03-27 00:00:00 2014-03-28 14:55:00 2014-03-28T14:55:00 365
4 None Transfer Intact Male Intact Male Kitten black domestic shorthair No black/white Partner 0.057534 2013 Thursday 12 None A670420 1 21 3 19 black None white 3 weeks Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Male True 1 False 2014-01 2013-12-16 00:00:00 2014-01-09 19:29:00 2014-01-09T19:29:00 7
5 Elsa Adoption Spayed Female Spayed Female Kitten brown domestic shorthair Yes brown None 0.164384 2014 Wednesday 6 None A684460 1 60 2 15 brown tabby None 2 months Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 8 False 2014-08 2014-06-02 00:00:00 2014-08-13 15:04:00 2014-08-13T15:04:00 30
6 None Transfer Unknown Unknown Cat brown domestic shorthair Yes brown /white SCRP 0.657534 2013 Thursday 7 None A673952 1 240 8 14 brown tabby white 8 months Cat 2014 (-0.022, 2.2] Cat domestic shorthair Female True 3 False 2014-03 2013-07-05 00:00:00 2014-03-06 14:29:00 2014-03-06T14:29:00 30
7 Chester Adoption Neutered Male Neutered Male Kitten black domestic shorthair Yes black None 0.410959 2014 Sunday 3 None A686497 1 150 5 15 black tabby None 5 months Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Male True 8 False 2014-08 2014-03-22 00:00:00 2014-08-31 15:45:00 2014-08-31T15:45:00 30
8 *Oliver Adoption Neutered Male Neutered Male Kitten orange domestic shorthair Yes orange Foster 0.164384 2014 Friday 8 None A687965 1 60 2 18 orange tabby None 2 months Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Male True 10 False 2014-10 2014-08-03 00:00:00 2014-10-31 18:29:00 2014-10-31T18:29:00 30
9 *Preston Transfer Neutered Male Neutered Male Cat black domestic mediumhair Yes black/white Partner 1.000000 2012 Monday 12 None A668547 1 365 1 13 black None white 1 year Cat 2013 (-0.022, 2.2] Cat domestic mediumhair Male True 12 False 2013-12 2012-12-04 00:00:00 2013-12-16 13:59:00 2013-12-16T13:59:00 365
10 *Bumble Transfer Intact Female Intact Female Kitten seal siamese No seal Partner 0.164384 2014 Thursday 4 None A682393 1 60 2 12 seal point None 2 months Cat 2014 (-0.022, 2.2] Kitten siamese Female False 7 True 2014-07 2014-04-27 00:00:00 2014-07-03 12:12:00 2014-07-03T12:12:00 30
11 None Transfer Unknown Unknown Kitten black domestic shorthair Yes black Partner 0.038356 2014 Wednesday 5 None A681039 1 14 2 17 black None None 2 weeks Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 6 False 2014-06 2014-05-27 00:00:00 2014-06-11 17:11:00 2014-06-11T17:11:00 7
12 None Adoption Spayed Female Spayed Female Kitten Breed Specific domestic shorthair Yes None None 0.164384 2014 Thursday 4 None A682532 1 60 2 17 torbie torbie None 2 months Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 7 False 2014-07 2014-04-14 00:00:00 2014-07-03 17:01:00 2014-07-03T17:01:00 30
13 None Adoption Spayed Female Spayed Female Kitten black domestic shorthair Yes black None 0.246575 2014 Saturday 4 None A683779 1 90 3 17 black None None 3 months Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 7 False 2014-07 2014-04-15 00:00:00 2014-07-19 17:36:00 2014-07-19T17:36:00 30
14 None Transfer Intact Male Intact Male Kitten black domestic shorthair No black Partner 0.057534 2014 Wednesday 8 None A686829 1 21 3 16 black None None 3 weeks Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Male True 8 False 2014-08 2014-08-05 00:00:00 2014-08-27 16:27:00 2014-08-27T16:27:00 7
15 Pumpkin Died Neutered Male Neutered Male Cat orange domestic mediumhair Yes orange In Kennel 3.000000 2011 Thursday 8 None A617061 1 1095 3 9 orange tabby None 3 years Cat 2014 (2.2, 4.4] Cat domestic mediumhair Male True 9 False 2014-09 2011-08-02 00:00:00 2014-09-04 09:57:00 2014-09-04T09:57:00 365
16 Winnie Adoption Spayed Female Spayed Female Cat blue russian blue Yes blue None 4.000000 2010 Saturday 6 None A682085 1 1460 4 15 blue None None 4 years Cat 2014 (2.2, 4.4] Cat russian blue Female False 7 True 2014-07 2010-06-24 00:00:00 2014-07-12 15:00:00 2014-07-12T15:00:00 365
17 Snowflake Transfer Neutered Male Neutered Male Cat cream domestic shorthair Yes cream /white Partner 2.000000 2012 Tuesday 11 None A692877 1 730 2 15 cream tabby white 2 years Cat 2014 (-0.022, 2.2] Cat domestic shorthair Male True 12 False 2014-12 2012-11-26 00:00:00 2014-12-09 15:18:00 2014-12-09T15:18:00 365
18 Smoke Adoption Neutered Male Neutered Male Cat blue russian blue Yes blue Foster 7.000000 2007 Tuesday 7 None A683856 1 2555 7 15 blue None None 7 years Cat 2014 (6.6, 8.8] Cat russian blue Male False 8 True 2014-08 2007-07-16 00:00:00 2014-08-12 15:42:00 2014-08-12T15:42:00 365
19 *Dora Transfer Intact Female Intact Female Kitten Breed Specific domestic shorthair No None Partner 0.082192 2014 Saturday 6 None A683517 1 30 1 13 calico calico None 1 month Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 7 False 2014-07 2014-06-05 00:00:00 2014-07-19 13:08:00 2014-07-19T13:08:00 30
20 None Transfer Intact Female Intact Female Cat brown domestic mediumhair No brown SCRP 1.000000 2013 Thursday 9 None A688811 1 365 1 9 brown tabby None 1 year Cat 2014 (-0.022, 2.2] Cat domestic mediumhair Female True 9 False 2014-09 2013-09-24 00:00:00 2014-09-25 09:00:00 2014-09-25T09:00:00 365
21 None Transfer Intact Female Intact Female Cat Breed Specific domestic shorthair No None SCRP 2.000000 2012 Sunday 5 None A680225 1 730 2 17 calico calico None 2 years Cat 2014 (-0.022, 2.2] Cat domestic shorthair Female True 6 False 2014-06 2012-05-31 00:00:00 2014-06-01 17:15:00 2014-06-01T17:15:00 365
22 *Cosmo Transfer Neutered Male Neutered Male Kitten chocolate domestic shorthair Yes chocolate Partner 0.164384 2013 Sunday 8 None A662912 1 60 2 12 chocolate None None 2 months Cat 2013 (-0.022, 2.2] Kitten domestic shorthair Male True 10 False 2013-10 2013-08-10 00:00:00 2013-10-20 12:21:00 2013-10-20T12:21:00 30
23 None Transfer Intact Male Intact Male Kitten brown domestic shorthair No brown Partner 0.076712 2014 Monday 3 None A677218 1 28 4 18 brown tabby None 4 weeks Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Male True 4 False 2014-04 2014-03-21 00:00:00 2014-04-21 18:04:00 2014-04-21T18:04:00 7
24 None Transfer Intact Female Intact Female Kitten brown domestic shorthair No brown /white SCRP 0.246575 2014 Sunday 8 None A691708 1 90 3 9 brown tabby white 3 months Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 11 False 2014-11 2014-08-01 00:00:00 2014-11-09 09:00:00 2014-11-09T09:00:00 30
25 *Sophie Adoption Spayed Female Spayed Female Cat Breed Specific domestic shorthair Yes None None 1.000000 2013 Sunday 1 None A670066 1 365 1 12 torbie torbie None 1 year Cat 2014 (-0.022, 2.2] Cat domestic shorthair Female True 1 False 2014-01 2013-01-01 00:00:00 2014-01-12 12:06:00 2014-01-12T12:06:00 365
26 None Euthanasia Intact Female Intact Female Kitten brown domestic mediumhair No brown Suffering 0.164384 2013 Tuesday 9 None A667511 1 60 2 13 brown tabby None 2 months Cat 2013 (-0.022, 2.2] Kitten domestic mediumhair Female True 11 False 2013-11 2013-09-04 00:00:00 2013-11-19 13:43:00 2013-11-19T13:43:00 30
27 Mischief Return to Owner Neutered Male Neutered Male Cat blue domestic shorthair Yes blue /white None 6.000000 2008 Friday 1 None A670656 1 2190 6 12 blue tabby white 6 years Cat 2014 (4.4, 6.6] Cat domestic shorthair Male True 1 False 2014-01 2008-01-11 00:00:00 2014-01-17 12:33:00 2014-01-17T12:33:00 365
28 None Transfer Neutered Male Neutered Male Cat black domestic shorthair Yes black/white SCRP 2.000000 2012 Tuesday 9 None A688674 1 730 2 9 black None white 2 years Cat 2014 (-0.022, 2.2] Cat domestic shorthair Male True 9 False 2014-09 2012-09-22 00:00:00 2014-09-23 09:00:00 2014-09-23T09:00:00 365
29 None Euthanasia Unknown Unknown Kitten black domestic shorthair Yes black/white Suffering 0.038356 2014 Sunday 4 None A677633 1 14 2 15 black None white 2 weeks Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 4 False 2014-04 2014-04-12 00:00:00 2014-04-27 15:35:00 2014-04-27T15:35:00 7
30 None Transfer Intact Male Intact Male Kitten orange domestic shorthair No orange Partner 0.057534 2014 Saturday 8 None A688532 1 21 3 18 orange tabby None 3 weeks Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Male True 9 False 2014-09 2014-08-29 00:00:00 2014-09-20 18:26:00 2014-09-20T18:26:00 7
31 *Rose Adoption Spayed Female Spayed Female Kitten brown domestic shorthair Yes brown None 0.164384 2014 Saturday 9 None A687769 1 60 2 15 brown tabby None 2 months Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 11 False 2014-11 2014-09-09 00:00:00 2014-11-22 15:08:00 2014-11-22T15:08:00 30
32 None Adoption Spayed Female Spayed Female Kitten brown domestic shorthair Yes brown Foster 0.246575 2014 Tuesday 3 None A678060 1 90 3 15 brown tabby None 3 months Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 6 False 2014-06 2014-03-19 00:00:00 2014-06-24 15:54:00 2014-06-24T15:54:00 30
33 None Transfer Neutered Male Neutered Male Cat blue domestic shorthair Yes blue SCRP 2.000000 2012 Sunday 9 None A688036 1 730 2 9 blue tabby None 2 years Cat 2014 (-0.022, 2.2] Cat domestic shorthair Male True 9 False 2014-09 2012-09-13 00:00:00 2014-09-14 09:00:00 2014-09-14T09:00:00 365
34 *Monkey Adoption Neutered Male Neutered Male Kitten black domestic shorthair Yes black None 0.328767 2013 Thursday 6 None A663623 1 120 4 16 black None None 4 months Cat 2013 (-0.022, 2.2] Kitten domestic shorthair Male True 10 False 2013-10 2013-06-06 00:00:00 2013-10-10 16:25:00 2013-10-10T16:25:00 30
35 Lucy Adoption Spayed Female Spayed Female Kitten brown domestic longhair Yes brown Foster 0.164384 2014 Saturday 10 None A691706 1 60 2 14 brown tabby None 2 months Cat 2014 (-0.022, 2.2] Kitten domestic longhair Female True 12 False 2014-12 2014-10-01 00:00:00 2014-12-13 14:16:00 2014-12-13T14:16:00 30
36 *Mike Adoption Neutered Male Neutered Male Cat orange domestic shorthair Yes orange None 1.000000 2012 Saturday 11 None A667028 1 365 1 17 orange tabby None 1 year Cat 2013 (-0.022, 2.2] Cat domestic shorthair Male True 11 False 2013-11 2012-11-11 00:00:00 2013-11-30 17:43:00 2013-11-30T17:43:00 365
37 *Magnolia Adoption Spayed Female Spayed Female Cat brown domestic shorthair Yes brown Foster 2.000000 2012 Tuesday 2 None A672190 1 730 2 10 brown tabby None 2 years Cat 2014 (-0.022, 2.2] Cat domestic shorthair Female True 5 False 2014-05 2012-02-05 00:00:00 2014-05-13 10:15:00 2014-05-13T10:15:00 365
38 *Winston Adoption Neutered Male Neutered Male Kitten white domestic shorthair Yes white/black None 0.164384 2014 Monday 8 None A687138 1 60 2 17 white None black 2 months Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Male True 10 False 2014-10 2014-08-06 00:00:00 2014-10-13 17:05:00 2014-10-13T17:05:00 30
39 *Kim Transfer Neutered Male Neutered Male Kitten black domestic mediumhair Yes black/white Partner 0.410959 2013 Tuesday 7 None A662261 1 150 5 12 black None white 5 months Cat 2013 (-0.022, 2.2] Kitten domestic mediumhair Male True 12 False 2013-12 2013-07-24 00:00:00 2013-12-24 12:55:00 2013-12-24T12:55:00 30
40 *Alley Adoption Neutered Male Neutered Male Kitten orange domestic shorthair Yes orange None 0.246575 2013 Friday 7 None A665799 1 90 3 19 orange tabby None 3 months Cat 2013 (-0.022, 2.2] Kitten domestic shorthair Male True 11 False 2013-11 2013-07-23 00:00:00 2013-11-01 19:24:00 2013-11-01T19:24:00 30
41 None Transfer Unknown Unknown Cat brown domestic shorthair Yes brown SCRP 2.000000 2012 Wednesday 2 None A673438 1 730 2 15 brown tabby None 2 years Cat 2014 (-0.022, 2.2] Cat domestic shorthair Female True 2 False 2014-02 2012-02-24 00:00:00 2014-02-26 15:12:00 2014-02-26T15:12:00 365
42 *Martin Transfer Intact Male Intact Male Kitten orange domestic shorthair No orange Partner 0.082192 2013 Wednesday 10 None A669140 1 30 1 16 orange tabby None 1 month Cat 2013 (-0.022, 2.2] Kitten domestic shorthair Male True 12 False 2013-12 2013-10-24 00:00:00 2013-12-18 16:14:00 2013-12-18T16:14:00 30
43 None Euthanasia Intact Female Intact Female Cat brown domestic shorthair No brown /white Suffering 8.000000 2005 Tuesday 12 None A669576 1 2920 8 16 brown tabby white 8 years Cat 2013 (6.6, 8.8] Cat domestic shorthair Female True 12 False 2013-12 2005-12-23 00:00:00 2013-12-24 16:29:00 2013-12-24T16:29:00 365
44 None Transfer Intact Female Intact Female Kitten black domestic shorthair No black/white Partner 0.057534 2014 Saturday 7 None A685582 1 21 3 15 black None white 3 weeks Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 8 False 2014-08 2014-07-18 00:00:00 2014-08-09 15:58:00 2014-08-09T15:58:00 7
45 Tiki Adoption Neutered Male Neutered Male Cat black domestic shorthair Yes black/white None 10.000000 2004 Sunday 8 None A684998 1 3650 10 16 black None white 10 years Cat 2014 (8.8, 11.0] Cat domestic shorthair Male True 10 False 2014-10 2004-08-25 00:00:00 2014-10-05 16:12:00 2014-10-05T16:12:00 365
46 *Taylor Transfer Intact Female Intact Female Kitten orange domestic shorthair No orange Partner 0.164384 2013 Wednesday 8 None A664486 1 60 2 18 orange tabby None 2 months Cat 2013 (-0.022, 2.2] Kitten domestic shorthair Female True 10 False 2013-10 2013-08-04 00:00:00 2013-10-09 18:46:00 2013-10-09T18:46:00 30
47 None Euthanasia Intact Male Intact Male Kitten blue domestic shorthair No blue /white Suffering 0.057534 2014 Tuesday 9 None A689192 1 21 3 15 blue tabby white 3 weeks Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Male True 9 False 2014-09 2014-09-08 00:00:00 2014-09-30 15:08:00 2014-09-30T15:08:00 7
48 *Amber Adoption Spayed Female Spayed Female Cat Breed Specific domestic shorthair Yes None None 8.000000 2005 Thursday 10 None A665019 1 2920 8 15 torbie torbie None 8 years Cat 2013 (6.6, 8.8] Cat domestic shorthair Female True 12 False 2013-12 2005-10-12 00:00:00 2013-12-05 15:30:00 2013-12-05T15:30:00 365
49 None Euthanasia Intact Female Intact Female Kitten orange domestic shorthair No orange /white Suffering 0.076712 2014 Saturday 6 None A684110 1 28 4 14 orange tabby white 4 weeks Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 7 False 2014-07 2014-06-19 00:00:00 2014-07-19 14:55:00 2014-07-19T14:55:00 7
50 Jenny Transfer Spayed Female Spayed Female Cat blue domestic shorthair Yes blue/white Partner 3.000000 2011 Monday 4 None A677014 1 1095 3 12 blue None white 3 years Cat 2014 (2.2, 4.4] Cat domestic shorthair Female True 6 False 2014-06 2011-04-18 00:00:00 2014-06-16 12:42:00 2014-06-16T12:42:00 365
51 None Adoption Spayed Female Spayed Female Kitten blue domestic shorthair Yes blue Foster 0.246575 2014 Saturday 4 None A677959 1 90 3 11 blue tabby None 3 months Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 7 False 2014-07 2014-04-01 00:00:00 2014-07-12 11:36:00 2014-07-12T11:36:00 30
52 *Libby Adoption Spayed Female Spayed Female Kitten brown domestic shorthair Yes brown Foster 0.164384 2014 Saturday 4 None A680473 1 60 2 12 brown tabby None 2 months Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 7 False 2014-07 2014-04-26 00:00:00 2014-07-12 12:24:00 2014-07-12T12:24:00 30
53 Rainy Adoption Spayed Female Spayed Female Kitten orange domestic shorthair Yes orange /white None 0.164384 2014 Saturday 9 None A690900 1 60 2 13 orange tabby white 2 months Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 11 False 2014-11 2014-09-12 00:00:00 2014-11-22 13:23:00 2014-11-22T13:23:00 30
54 None Transfer Intact Male Intact Male Kitten orange domestic shorthair No orange /white SCRP 0.410959 2013 Thursday 5 None A664437 1 150 5 15 orange tabby white 5 months Cat 2013 (-0.022, 2.2] Kitten domestic shorthair Male True 10 False 2013-10 2013-05-03 00:00:00 2013-10-03 15:33:00 2013-10-03T15:33:00 30
55 None Adoption Neutered Male Neutered Male Cat orange domestic shorthair Yes orange None 3.000000 2011 Sunday 7 None A683956 1 1095 3 16 orange tabby None 3 years Cat 2014 (2.2, 4.4] Cat domestic shorthair Male True 7 False 2014-07 2011-07-17 00:00:00 2014-07-27 16:19:00 2014-07-27T16:19:00 365
56 None Transfer Unknown Unknown Cat silver domestic shorthair Yes silver SCRP 3.000000 2011 Tuesday 10 None A690029 1 1095 3 9 silver tabby None 3 years Cat 2014 (2.2, 4.4] Cat domestic shorthair Female True 10 False 2014-10 2011-10-13 00:00:00 2014-10-14 09:00:00 2014-10-14T09:00:00 365
57 None Transfer Intact Female Intact Female Cat blue domestic shorthair No blue Partner 15.000000 1999 Wednesday 5 None A678260 1 5475 15 15 blue tabby None 15 years Cat 2014 (13.2, 15.4] Cat domestic shorthair Female True 5 False 2014-05 1999-05-06 00:00:00 2014-05-14 15:30:00 2014-05-14T15:30:00 365
58 *Trinity Adoption Spayed Female Spayed Female Cat brown domestic shorthair Yes brown None 1.000000 2012 Friday 8 None A672918 1 365 1 15 brown tabby None 1 year Cat 2014 (-0.022, 2.2] Cat domestic shorthair Female True 3 False 2014-03 2012-08-18 00:00:00 2014-03-21 15:40:00 2014-03-21T15:40:00 365
59 None Transfer Intact Female Intact Female Kitten brown domestic shorthair No brown Partner 0.057534 2014 Sunday 5 None A681990 1 21 3 15 brown tabby None 3 weeks Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 6 False 2014-06 2014-05-31 00:00:00 2014-06-22 15:11:00 2014-06-22T15:11:00 7
60 None Transfer Intact Female Intact Female Kitten black domestic shorthair No black Partner 0.076712 2014 Friday 6 None A683735 1 28 4 16 black None None 4 weeks Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 7 False 2014-07 2014-06-23 00:00:00 2014-07-25 16:47:00 2014-07-25T16:47:00 7
61 None Transfer Intact Female Intact Female Kitten flame siamese No flame Partner 0.038356 2014 Saturday 7 None A685607 1 14 2 18 flame point None 2 weeks Cat 2014 (-0.022, 2.2] Kitten siamese Female False 8 True 2014-08 2014-07-25 00:00:00 2014-08-09 18:28:00 2014-08-09T18:28:00 7
62 None Transfer Intact Female Intact Female Cat brown domestic shorthair No brown SCRP 0.821918 2013 Monday 7 None A679736 1 300 10 18 brown tabby None 10 months Cat 2014 (-0.022, 2.2] Cat domestic shorthair Female True 5 False 2014-05 2013-07-25 00:00:00 2014-05-26 18:12:00 2014-05-26T18:12:00 30
63 None Transfer Unknown Unknown Cat black domestic longhair Yes black SCRP 0.821918 2013 Sunday 3 None A671106 1 300 10 17 black None None 10 months Cat 2014 (-0.022, 2.2] Cat domestic longhair Female True 1 False 2014-01 2013-03-18 00:00:00 2014-01-19 17:35:00 2014-01-19T17:35:00 30
64 *Orville Adoption Neutered Male Neutered Male Cat orange domestic shorthair Yes orange /white None 0.904110 2013 Sunday 6 None A678573 1 330 11 16 orange tabby white 11 months Cat 2014 (-0.022, 2.2] Cat domestic shorthair Male True 6 False 2014-06 2013-06-10 00:00:00 2014-06-08 16:53:00 2014-06-08T16:53:00 30
65 Salem Adoption Neutered Male Neutered Male Cat black domestic shorthair Yes black None 1.000000 2012 Thursday 4 None A626164 1 365 1 16 black None None 1 year Cat 2014 (-0.022, 2.2] Cat domestic shorthair Male True 1 False 2014-01 2012-04-16 00:00:00 2014-01-30 16:11:00 2014-01-30T16:11:00 365
66 *Ursula Transfer Unknown Unknown Cat brown domestic shorthair Yes brown Partner 1.000000 2012 Friday 12 None A669753 1 365 1 17 brown tabby None 1 year Cat 2014 (-0.022, 2.2] Cat domestic shorthair Female True 1 False 2014-01 2012-12-26 00:00:00 2014-01-03 17:19:00 2014-01-03T17:19:00 365
67 *Lily Adoption Spayed Female Spayed Female Kitten Breed Specific domestic shorthair Yes None None 0.164384 2014 Friday 9 None A687770 1 60 2 14 torbie torbie None 2 months Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 11 False 2014-11 2014-09-09 00:00:00 2014-11-28 14:55:00 2014-11-28T14:55:00 30
68 Garfield Transfer Neutered Male Neutered Male Cat orange domestic longhair Yes orange Partner 3.000000 2011 Wednesday 9 None A688206 1 1095 3 14 orange tabby None 3 years Cat 2014 (2.2, 4.4] Cat domestic longhair Male True 9 False 2014-09 2011-09-16 00:00:00 2014-09-17 14:06:00 2014-09-17T14:06:00 365
69 Garfield Return to Owner Neutered Male Neutered Male Cat white domestic shorthair Yes white/orange None 8.000000 2005 Monday 11 None A667359 1 2920 8 17 white tabby orange 8 years Cat 2013 (6.6, 8.8] Cat domestic shorthair Male True 11 False 2013-11 2005-11-16 00:00:00 2013-11-18 17:31:00 2013-11-18T17:31:00 365
70 Mina Adoption Spayed Female Spayed Female Cat blue domestic shorthair Yes blue None 0.493151 2014 Monday 3 None A686388 1 180 6 14 blue None None 6 months Cat 2014 (-0.022, 2.2] Cat domestic shorthair Female True 9 False 2014-09 2014-03-01 00:00:00 2014-09-01 14:11:00 2014-09-01T14:11:00 30
71 *Michonne Transfer Intact Female Intact Female Kitten black domestic shorthair No black/white Partner 0.082192 2014 Wednesday 6 None A684824 1 30 1 14 black None white 1 month Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 8 False 2014-08 2014-06-29 00:00:00 2014-08-06 14:23:00 2014-08-06T14:23:00 30
72 None Transfer Intact Male Intact Male Kitten seal siamese No seal SCRP 0.410959 2014 Saturday 3 None A686978 1 150 5 9 seal point None 5 months Cat 2014 (-0.022, 2.2] Kitten siamese Male False 8 True 2014-08 2014-03-29 00:00:00 2014-08-30 09:00:00 2014-08-30T09:00:00 30
73 *Juliet Adoption Spayed Female Spayed Female Kitten Breed Specific domestic shorthair Yes None None 0.164384 2014 Monday 4 None A680663 1 60 2 18 torbie torbie None 2 months Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 6 False 2014-06 2014-04-05 00:00:00 2014-06-30 18:17:00 2014-06-30T18:17:00 30
74 None Transfer Unknown Unknown Kitten blue domestic shorthair Yes blue/white Partner 0.038356 2014 Wednesday 5 None A681042 1 14 2 17 blue None white 2 weeks Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 6 False 2014-06 2014-05-27 00:00:00 2014-06-11 17:11:00 2014-06-11T17:11:00 7
75 *Twix Adoption Neutered Male Neutered Male Kitten blue domestic shorthair Yes blue /white Foster 0.164384 2014 Tuesday 4 None A680414 1 60 2 11 blue tabby white 2 months Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Male True 7 False 2014-07 2014-04-17 00:00:00 2014-07-08 11:16:00 2014-07-08T11:16:00 30
76 None Euthanasia Intact Male Intact Male Kitten blue domestic shorthair No blue Suffering 0.082192 2014 Tuesday 5 None A683224 1 30 1 17 blue None None 1 month Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Male True 7 False 2014-07 2014-05-24 00:00:00 2014-07-08 17:01:00 2014-07-08T17:01:00 30
77 None Transfer Unknown Unknown Kitten black domestic shorthair Yes black/white Partner 0.038356 2014 Sunday 4 None A677631 1 14 2 12 black None white 2 weeks Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 4 False 2014-04 2014-04-12 00:00:00 2014-04-27 12:07:00 2014-04-27T12:07:00 7
78 Novio Adoption Intact Male Intact Male Kitten orange domestic mediumhair No orange None 0.164384 2014 Saturday 2 None A677077 1 60 2 15 orange tabby None 2 months Cat 2014 (-0.022, 2.2] Kitten domestic mediumhair Male True 4 False 2014-04 2014-02-19 00:00:00 2014-04-26 15:43:00 2014-04-26T15:43:00 30
79 *Rust Adoption Spayed Female Spayed Female Kitten Breed Specific domestic shorthair Yes None Foster 0.164384 2014 Sunday 5 None A682239 1 60 2 16 tortie tortie None 2 months Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 8 False 2014-08 2014-05-25 00:00:00 2014-08-03 16:10:00 2014-08-03T16:10:00 30
80 None Transfer Intact Female Intact Female Cat Breed Specific domestic shorthair No None SCRP 0.493151 2014 Wednesday 6 None A693905 1 180 6 9 calico calico None 6 months Cat 2014 (-0.022, 2.2] Cat domestic shorthair Female True 12 False 2014-12 2014-06-16 00:00:00 2014-12-17 09:00:00 2014-12-17T09:00:00 30
81 None Adoption Spayed Female Spayed Female Kitten cream domestic mediumhair Yes cream None 0.164384 2014 Sunday 3 None A680819 1 60 2 15 cream tabby None 2 months Cat 2014 (-0.022, 2.2] Kitten domestic mediumhair Female True 6 False 2014-06 2014-03-24 00:00:00 2014-06-15 15:48:00 2014-06-15T15:48:00 30
82 Jelly Bean Transfer Spayed Female Spayed Female Cat Breed Specific domestic shorthair Yes None SCRP 2.000000 2012 Tuesday 11 None A692219 1 730 2 18 calico calico None 2 years Cat 2014 (-0.022, 2.2] Cat domestic shorthair Female True 11 False 2014-11 2012-11-16 00:00:00 2014-11-25 18:37:00 2014-11-25T18:37:00 365
83 Cathy Return to Owner Spayed Female Spayed Female Kitten Breed Specific domestic shorthair Yes None None 0.328767 2014 Saturday 5 None A688479 1 120 4 11 tortie tortie None 4 months Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 9 False 2014-09 2014-05-19 00:00:00 2014-09-20 11:52:00 2014-09-20T11:52:00 30
84 *Kanga Transfer Intact Female Intact Female Kitten Breed Specific domestic shorthair No None Partner 0.082192 2014 Sunday 8 None A688741 1 30 1 15 torbie torbie None 1 month Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 10 False 2014-10 2014-08-24 00:00:00 2014-10-05 15:10:00 2014-10-05T15:10:00 30
85 Zane Adoption Intact Male Intact Male Kitten brown manx No brown /white None 0.246575 2013 Sunday 6 None A664514 1 90 3 18 brown tabby white 3 months Cat 2013 (-0.022, 2.2] Kitten manx Male False 10 True 2013-10 2013-06-19 00:00:00 2013-10-13 18:51:00 2013-10-13T18:51:00 30
86 Ron Weasley Transfer Neutered Male Neutered Male Cat orange domestic shorthair Yes orange Partner 1.000000 2012 Tuesday 7 None A671065 1 365 1 13 orange tabby None 1 year Cat 2014 (-0.022, 2.2] Cat domestic shorthair Male True 1 False 2014-01 2012-07-17 00:00:00 2014-01-21 13:14:00 2014-01-21T13:14:00 365
87 None Transfer Intact Male Intact Male Kitten brown domestic mediumhair No brown Partner 0.082192 2014 Wednesday 4 None A678248 1 30 1 17 brown tabby None 1 month Cat 2014 (-0.022, 2.2] Kitten domestic mediumhair Male True 5 False 2014-05 2014-04-06 00:00:00 2014-05-21 17:37:00 2014-05-21T17:37:00 30
88 Laurel Adoption Spayed Female Spayed Female Cat lynx siamese Yes lynx None 16.000000 1998 Wednesday 1 None A670616 1 5840 16 18 lynx point None 16 years Cat 2014 (15.4, 17.6] Cat siamese Female False 2 True 2014-02 1998-01-11 00:00:00 2014-02-12 18:34:00 2014-02-12T18:34:00 365
89 None Adoption Neutered Male Neutered Male Kitten blue domestic longhair Yes blue/white None 0.164384 2014 Friday 4 None A683161 1 60 2 18 blue None white 2 months Cat 2014 (-0.022, 2.2] Kitten domestic longhair Male True 7 False 2014-07 2014-04-15 00:00:00 2014-07-11 18:54:00 2014-07-11T18:54:00 30
90 Luna Return to Owner Spayed Female Spayed Female Cat lynx siamese Yes lynx None 4.000000 2010 Monday 4 None A575091 1 1460 4 17 lynx point None 4 years Cat 2014 (2.2, 4.4] Cat siamese Female False 12 True 2014-12 2010-04-17 00:00:00 2014-12-15 17:04:00 2014-12-15T17:04:00 365
91 Marley Adoption Spayed Female Spayed Female Kitten Breed Specific domestic mediumhair Yes None None 0.164384 2014 Wednesday 6 None A688074 1 60 2 18 calico calico None 2 months Cat 2014 (-0.022, 2.2] Kitten domestic mediumhair Female True 9 False 2014-09 2014-06-30 00:00:00 2014-09-17 18:26:00 2014-09-17T18:26:00 30
92 *Alice Adoption Spayed Female Spayed Female Kitten black domestic shorthair Yes black Foster 0.246575 2013 Sunday 9 None A664952 1 90 3 19 black None None 3 months Cat 2013 (-0.022, 2.2] Kitten domestic shorthair Female True 12 False 2013-12 2013-09-11 00:00:00 2013-12-15 19:10:00 2013-12-15T19:10:00 30
93 Cuddles Return to Owner Neutered Male Neutered Male Cat blue domestic shorthair Yes blue None 3.000000 2011 Wednesday 9 None A688011 1 1095 3 15 blue tabby None 3 years Cat 2014 (2.2, 4.4] Cat domestic shorthair Male True 11 False 2014-11 2011-09-13 00:00:00 2014-11-05 15:47:00 2014-11-05T15:47:00 365
94 *Pooh Bear Adoption Neutered Male Neutered Male Cat cream domestic shorthair Yes cream None 6.000000 2007 Wednesday 12 None A644391 1 2190 6 12 cream tabby None 6 years Cat 2014 (4.4, 6.6] Cat domestic shorthair Male True 11 False 2014-11 2007-12-26 00:00:00 2014-11-12 12:58:00 2014-11-12T12:58:00 365
95 Tucker Adoption Intact Male Intact Male Kitten brown domestic longhair No brown Foster 0.246575 2014 Thursday 8 None A688552 1 90 3 14 brown tabby None 3 months Cat 2014 (-0.022, 2.2] Kitten domestic longhair Male True 12 False 2014-12 2014-08-20 00:00:00 2014-12-18 14:29:00 2014-12-18T14:29:00 30
96 None Transfer Unknown Unknown Kitten cream domestic shorthair Yes cream Partner 0.057534 2014 Thursday 10 None A691086 1 21 3 10 cream tabby None 3 weeks Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 10 False 2014-10 2014-10-07 00:00:00 2014-10-30 10:37:00 2014-10-30T10:37:00 7
97 *Louisa Died Intact Female Intact Female Kitten Breed Specific domestic shorthair No None None 0.082192 2014 Tuesday 4 None A678917 1 30 1 9 torbie torbie None 1 month Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 5 False 2014-05 2014-04-14 00:00:00 2014-05-20 09:52:00 2014-05-20T09:52:00 30
98 None Transfer Neutered Male Neutered Male Cat orange domestic mediumhair Yes orange /white SCRP 1.000000 2013 Thursday 5 None A679999 1 365 1 19 orange tabby white 1 year Cat 2014 (-0.022, 2.2] Cat domestic mediumhair Male True 5 False 2014-05 2013-05-28 00:00:00 2014-05-29 19:13:00 2014-05-29T19:13:00 365
99 None Transfer Intact Female Intact Female Kitten brown domestic shorthair No brown Partner 0.038356 2014 Monday 4 None A677713 1 14 2 14 brown tabby None 2 weeks Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 4 False 2014-04 2014-04-09 00:00:00 2014-04-28 14:49:00 2014-04-28T14:49:00 7
animal_name outcome_type cat_sex_upon_outcome cat_sex_age_outcome primary_color breed spay_neuter_status color_description outcome_subtype outcome_age_years birth_year outcome_weekday birth_month secondary_breed animal_id record_count outcome_age_days outcome_periods outcome_hour coat_color coat_pattern secondary_color age_upon_outcome animal_type outcome_year age_group_bucket outcome_animal_category primary_breed cat_sex is_domestic_breed outcome_month cfa_breed_status birth_month_year date_of_birth outcome_datetime outcome_month_year outcome_period_range
0 None Transfer Intact Male Intact Male Kitten orange domestic shorthair No orange Partner 0.038356 2014 Tuesday 7 None A684346 1 14 2 16 orange tabby None 2 weeks Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Male True 7 False 2014-07-01 2014-07-07 2014-07-22 16:04:00 2014-07-22 7
1 Lucy Adoption Intact Female Intact Female Kitten blue domestic shorthair No blue /white None 0.082192 2014 Thursday 6 None A685067 1 30 1 18 blue tabby white 1 month Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 8 False 2014-08-01 2014-06-16 2014-08-14 18:45:00 2014-08-14 30
2 Stella Luna Return to Owner Spayed Female Spayed Female Cat black domestic mediumhair Yes black/white None 1.000000 2013 Friday 3 None A675405 1 365 1 14 black None white 1 year Cat 2014 (-0.022, 2.2] Cat domestic mediumhair Female True 3 False 2014-03-01 2013-03-27 2014-03-28 14:55:00 2014-03-28 365
3 None Transfer Intact Male Intact Male Kitten black domestic shorthair No black/white Partner 0.057534 2013 Thursday 12 None A670420 1 21 3 19 black None white 3 weeks Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Male True 1 False 2014-01-01 2013-12-16 2014-01-09 19:29:00 2014-01-09 7
4 Elsa Adoption Spayed Female Spayed Female Kitten brown domestic shorthair Yes brown None 0.164384 2014 Wednesday 6 None A684460 1 60 2 15 brown tabby None 2 months Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 8 False 2014-08-01 2014-06-02 2014-08-13 15:04:00 2014-08-13 30
5 None Transfer None None brown domestic shorthair Yes brown /white SCRP 0.657534 2013 Thursday 7 None A673952 1 240 8 14 brown tabby white 8 months Cat 2014 (-0.022, 2.2] Cat domestic shorthair Female True 3 False 2014-03-01 2013-07-05 2014-03-06 14:29:00 2014-03-06 30
6 Chester Adoption Neutered Male Neutered Male Kitten black domestic shorthair Yes black None 0.410959 2014 Sunday 3 None A686497 1 150 5 15 black tabby None 5 months Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Male True 8 False 2014-08-01 2014-03-22 2014-08-31 15:45:00 2014-08-31 30
7 *Oliver Adoption Neutered Male Neutered Male Kitten orange domestic shorthair Yes orange Foster 0.164384 2014 Friday 8 None A687965 1 60 2 18 orange tabby None 2 months Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Male True 10 False 2014-10-01 2014-08-03 2014-10-31 18:29:00 2014-10-31 30
8 *Preston Transfer Neutered Male Neutered Male Cat black domestic mediumhair Yes black/white Partner 1.000000 2012 Monday 12 None A668547 1 365 1 13 black None white 1 year Cat 2013 (-0.022, 2.2] Cat domestic mediumhair Male True 12 False 2013-12-01 2012-12-04 2013-12-16 13:59:00 2013-12-16 365
9 *Bumble Transfer Intact Female Intact Female Kitten seal siamese No seal Partner 0.164384 2014 Thursday 4 None A682393 1 60 2 12 seal point None 2 months Cat 2014 (-0.022, 2.2] Kitten siamese Female False 7 True 2014-07-01 2014-04-27 2014-07-03 12:12:00 2014-07-03 30
10 None Adoption Spayed Female Spayed Female Kitten None domestic shorthair Yes None None 0.164384 2014 Thursday 4 None A682532 1 60 2 17 torbie torbie None 2 months Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 7 False 2014-07-01 2014-04-14 2014-07-03 17:01:00 2014-07-03 30
11 None Adoption Spayed Female Spayed Female Kitten black domestic shorthair Yes black None 0.246575 2014 Saturday 4 None A683779 1 90 3 17 black None None 3 months Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 7 False 2014-07-01 2014-04-15 2014-07-19 17:36:00 2014-07-19 30
12 None Transfer Intact Male Intact Male Kitten black domestic shorthair No black Partner 0.057534 2014 Wednesday 8 None A686829 1 21 3 16 black None None 3 weeks Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Male True 8 False 2014-08-01 2014-08-05 2014-08-27 16:27:00 2014-08-27 7
13 Pumpkin Died Neutered Male Neutered Male Cat orange domestic mediumhair Yes orange In Kennel 3.000000 2011 Thursday 8 None A617061 1 1095 3 9 orange tabby None 3 years Cat 2014 (2.2, 4.4] Cat domestic mediumhair Male True 9 False 2014-09-01 2011-08-02 2014-09-04 09:57:00 2014-09-04 365
14 Winnie Adoption Spayed Female Spayed Female Cat blue russian blue Yes blue None 4.000000 2010 Saturday 6 None A682085 1 1460 4 15 blue None None 4 years Cat 2014 (2.2, 4.4] Cat russian blue Female False 7 True 2014-07-01 2010-06-24 2014-07-12 15:00:00 2014-07-12 365
15 Snowflake Transfer Neutered Male Neutered Male Cat cream domestic shorthair Yes cream /white Partner 2.000000 2012 Tuesday 11 None A692877 1 730 2 15 cream tabby white 2 years Cat 2014 (-0.022, 2.2] Cat domestic shorthair Male True 12 False 2014-12-01 2012-11-26 2014-12-09 15:18:00 2014-12-09 365
16 *Dora Transfer Intact Female Intact Female Kitten None domestic shorthair No None Partner 0.082192 2014 Saturday 6 None A683517 1 30 1 13 calico calico None 1 month Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 7 False 2014-07-01 2014-06-05 2014-07-19 13:08:00 2014-07-19 30
17 None Transfer Intact Female Intact Female Kitten brown domestic shorthair No brown /white SCRP 0.246575 2014 Sunday 8 None A691708 1 90 3 9 brown tabby white 3 months Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 11 False 2014-11-01 2014-08-01 2014-11-09 09:00:00 2014-11-09 30
18 Mischief Return to Owner Neutered Male Neutered Male Cat blue domestic shorthair Yes blue /white None 6.000000 2008 Friday 1 None A670656 1 2190 6 12 blue tabby white 6 years Cat 2014 (4.4, 6.6] Cat domestic shorthair Male True 1 False 2014-01-01 2008-01-11 2014-01-17 12:33:00 2014-01-17 365
19 None Euthanasia None None black domestic shorthair Yes black/white Suffering 0.038356 2014 Sunday 4 None A677633 1 14 2 15 black None white 2 weeks Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 4 False 2014-04-01 2014-04-12 2014-04-27 15:35:00 2014-04-27 7
20 None Transfer Neutered Male Neutered Male Cat blue domestic shorthair Yes blue SCRP 2.000000 2012 Sunday 9 None A688036 1 730 2 9 blue tabby None 2 years Cat 2014 (-0.022, 2.2] Cat domestic shorthair Male True 9 False 2014-09-01 2012-09-13 2014-09-14 09:00:00 2014-09-14 365
21 *Monkey Adoption Neutered Male Neutered Male Kitten black domestic shorthair Yes black None 0.328767 2013 Thursday 6 None A663623 1 120 4 16 black None None 4 months Cat 2013 (-0.022, 2.2] Kitten domestic shorthair Male True 10 False 2013-10-01 2013-06-06 2013-10-10 16:25:00 2013-10-10 30
22 *Winston Adoption Neutered Male Neutered Male Kitten white domestic shorthair Yes white/black None 0.164384 2014 Monday 8 None A687138 1 60 2 17 white None black 2 months Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Male True 10 False 2014-10-01 2014-08-06 2014-10-13 17:05:00 2014-10-13 30
23 *Alley Adoption Neutered Male Neutered Male Kitten orange domestic shorthair Yes orange None 0.246575 2013 Friday 7 None A665799 1 90 3 19 orange tabby None 3 months Cat 2013 (-0.022, 2.2] Kitten domestic shorthair Male True 11 False 2013-11-01 2013-07-23 2013-11-01 19:24:00 2013-11-01 30
24 None Transfer None None brown domestic shorthair Yes brown SCRP 2.000000 2012 Wednesday 2 None A673438 1 730 2 15 brown tabby None 2 years Cat 2014 (-0.022, 2.2] Cat domestic shorthair Female True 2 False 2014-02-01 2012-02-24 2014-02-26 15:12:00 2014-02-26 365
25 None Transfer Intact Female Intact Female Kitten black domestic shorthair No black/white Partner 0.057534 2014 Saturday 7 None A685582 1 21 3 15 black None white 3 weeks Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 8 False 2014-08-01 2014-07-18 2014-08-09 15:58:00 2014-08-09 7
26 *Libby Adoption Spayed Female Spayed Female Kitten brown domestic shorthair Yes brown Foster 0.164384 2014 Saturday 4 None A680473 1 60 2 12 brown tabby None 2 months Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 7 False 2014-07-01 2014-04-26 2014-07-12 12:24:00 2014-07-12 30
27 None Transfer Intact Female Intact Female Kitten flame siamese No flame Partner 0.038356 2014 Saturday 7 None A685607 1 14 2 18 flame point None 2 weeks Cat 2014 (-0.022, 2.2] Kitten siamese Female False 8 True 2014-08-01 2014-07-25 2014-08-09 18:28:00 2014-08-09 7
28 *Lily Adoption Spayed Female Spayed Female Kitten None domestic shorthair Yes None None 0.164384 2014 Friday 9 None A687770 1 60 2 14 torbie torbie None 2 months Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 11 False 2014-11-01 2014-09-09 2014-11-28 14:55:00 2014-11-28 30
29 Mina Adoption Spayed Female Spayed Female Cat blue domestic shorthair Yes blue None 0.493151 2014 Monday 3 None A686388 1 180 6 14 blue None None 6 months Cat 2014 (-0.022, 2.2] Cat domestic shorthair Female True 9 False 2014-09-01 2014-03-01 2014-09-01 14:11:00 2014-09-01 30
30 None Euthanasia Intact Male Intact Male Kitten blue domestic shorthair No blue Suffering 0.082192 2014 Tuesday 5 None A683224 1 30 1 17 blue None None 1 month Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Male True 7 False 2014-07-01 2014-05-24 2014-07-08 17:01:00 2014-07-08 30
31 None Transfer None None black domestic shorthair Yes black/white Partner 0.038356 2014 Sunday 4 None A677631 1 14 2 12 black None white 2 weeks Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 4 False 2014-04-01 2014-04-12 2014-04-27 12:07:00 2014-04-27 7
32 None Transfer Intact Female Intact Female Cat None domestic shorthair No None SCRP 0.493151 2014 Wednesday 6 None A693905 1 180 6 9 calico calico None 6 months Cat 2014 (-0.022, 2.2] Cat domestic shorthair Female True 12 False 2014-12-01 2014-06-16 2014-12-17 09:00:00 2014-12-17 30
33 None Adoption Spayed Female Spayed Female Kitten cream domestic mediumhair Yes cream None 0.164384 2014 Sunday 3 None A680819 1 60 2 15 cream tabby None 2 months Cat 2014 (-0.022, 2.2] Kitten domestic mediumhair Female True 6 False 2014-06-01 2014-03-24 2014-06-15 15:48:00 2014-06-15 30
34 Luna Return to Owner Spayed Female Spayed Female Cat lynx siamese Yes lynx None 4.000000 2010 Monday 4 None A575091 1 1460 4 17 lynx point None 4 years Cat 2014 (2.2, 4.4] Cat siamese Female False 12 True 2014-12-01 2010-04-17 2014-12-15 17:04:00 2014-12-15 365
35 *Frida Adoption Spayed Female Spayed Female Kitten white domestic shorthair Yes white/black Offsite 0.246575 2014 Sunday 3 None A678580 1 90 3 17 white None black 3 months Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 6 False 2014-06-01 2014-03-26 2014-06-29 17:45:00 2014-06-29 30
36 None Transfer Intact Female Intact Female Cat brown domestic mediumhair No brown SCRP 1.000000 2013 Thursday 9 None A688811 1 365 1 9 brown tabby None 1 year Cat 2014 (-0.022, 2.2] Cat domestic mediumhair Female True 9 False 2014-09-01 2013-09-24 2014-09-25 09:00:00 2014-09-25 365
37 *Cosmo Transfer Neutered Male Neutered Male Kitten chocolate domestic shorthair Yes chocolate Partner 0.164384 2013 Sunday 8 None A662912 1 60 2 12 chocolate None None 2 months Cat 2013 (-0.022, 2.2] Kitten domestic shorthair Male True 10 False 2013-10-01 2013-08-10 2013-10-20 12:21:00 2013-10-20 30
38 *Mike Adoption Neutered Male Neutered Male Cat orange domestic shorthair Yes orange None 1.000000 2012 Saturday 11 None A667028 1 365 1 17 orange tabby None 1 year Cat 2013 (-0.022, 2.2] Cat domestic shorthair Male True 11 False 2013-11-01 2012-11-11 2013-11-30 17:43:00 2013-11-30 365
39 Tiki Adoption Neutered Male Neutered Male Cat black domestic shorthair Yes black/white None 10.000000 2004 Sunday 8 None A684998 1 3650 10 16 black None white 10 years Cat 2014 (8.8, 11.0] Cat domestic shorthair Male True 10 False 2014-10-01 2004-08-25 2014-10-05 16:12:00 2014-10-05 365
40 None Adoption Neutered Male Neutered Male Cat orange domestic shorthair Yes orange None 3.000000 2011 Sunday 7 None A683956 1 1095 3 16 orange tabby None 3 years Cat 2014 (2.2, 4.4] Cat domestic shorthair Male True 7 False 2014-07-01 2011-07-17 2014-07-27 16:19:00 2014-07-27 365
41 None Transfer Intact Female Intact Female Kitten brown domestic shorthair No brown Partner 0.057534 2014 Sunday 5 None A681990 1 21 3 15 brown tabby None 3 weeks Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 6 False 2014-06-01 2014-05-31 2014-06-22 15:11:00 2014-06-22 7
42 Garfield Return to Owner Neutered Male Neutered Male Cat white domestic shorthair Yes white/orange None 8.000000 2005 Monday 11 None A667359 1 2920 8 17 white tabby orange 8 years Cat 2013 (6.6, 8.8] Cat domestic shorthair Male True 11 False 2013-11-01 2005-11-16 2013-11-18 17:31:00 2013-11-18 365
43 None Transfer Intact Male Intact Male Kitten seal siamese No seal SCRP 0.410959 2014 Saturday 3 None A686978 1 150 5 9 seal point None 5 months Cat 2014 (-0.022, 2.2] Kitten siamese Male False 8 True 2014-08-01 2014-03-29 2014-08-30 09:00:00 2014-08-30 30
44 Jelly Bean Transfer Spayed Female Spayed Female Cat None domestic shorthair Yes None SCRP 2.000000 2012 Tuesday 11 None A692219 1 730 2 18 calico calico None 2 years Cat 2014 (-0.022, 2.2] Cat domestic shorthair Female True 11 False 2014-11-01 2012-11-16 2014-11-25 18:37:00 2014-11-25 365
45 Cathy Return to Owner Spayed Female Spayed Female Kitten None domestic shorthair Yes None None 0.328767 2014 Saturday 5 None A688479 1 120 4 11 tortie tortie None 4 months Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 9 False 2014-09-01 2014-05-19 2014-09-20 11:52:00 2014-09-20 30
46 None Transfer Intact Male Intact Male Kitten brown domestic shorthair No brown Partner 0.076712 2014 Monday 3 None A677218 1 28 4 18 brown tabby None 4 weeks Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Male True 4 False 2014-04-01 2014-03-21 2014-04-21 18:04:00 2014-04-21 7
47 Rainy Adoption Spayed Female Spayed Female Kitten orange domestic shorthair Yes orange /white None 0.164384 2014 Saturday 9 None A690900 1 60 2 13 orange tabby white 2 months Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 11 False 2014-11-01 2014-09-12 2014-11-22 13:23:00 2014-11-22 30
48 *Alice Adoption Spayed Female Spayed Female Kitten black domestic shorthair Yes black Foster 0.246575 2013 Sunday 9 None A664952 1 90 3 19 black None None 3 months Cat 2013 (-0.022, 2.2] Kitten domestic shorthair Female True 12 False 2013-12-01 2013-09-11 2013-12-15 19:10:00 2013-12-15 30
49 Tucker Adoption Intact Male Intact Male Kitten brown domestic longhair No brown Foster 0.246575 2014 Thursday 8 None A688552 1 90 3 14 brown tabby None 3 months Cat 2014 (-0.022, 2.2] Kitten domestic longhair Male True 12 False 2014-12-01 2014-08-20 2014-12-18 14:29:00 2014-12-18 30
50 None Transfer Intact Female Intact Female Kitten brown domestic shorthair No brown Partner 0.038356 2014 Monday 4 None A677713 1 14 2 14 brown tabby None 2 weeks Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 4 False 2014-04-01 2014-04-09 2014-04-28 14:49:00 2014-04-28 7
51 Buffy Transfer Spayed Female Spayed Female Cat None domestic shorthair Yes None Partner 0.739726 2014 Friday 1 None A689477 1 270 9 15 tortie tortie None 9 months Cat 2014 (-0.022, 2.2] Cat domestic shorthair Female True 10 False 2014-10-01 2014-01-04 2014-10-10 15:07:00 2014-10-10 30
52 None Adoption Intact Female Intact Female Kitten brown domestic mediumhair No brown None 0.164384 2014 Saturday 6 None A687156 1 60 2 19 brown tabby None 2 months Cat 2014 (-0.022, 2.2] Kitten domestic mediumhair Female True 9 False 2014-09-01 2014-06-16 2014-09-06 19:07:00 2014-09-06 30
53 Scout Adoption Intact Male Intact Male Kitten blue domestic shorthair No blue None 0.082192 2014 Friday 4 None A679781 1 30 1 15 blue tabby None 1 month Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Male True 6 False 2014-06-01 2014-04-28 2014-06-20 15:04:00 2014-06-20 30
54 None Transfer Intact Female Intact Female Kitten None domestic mediumhair No None SCRP 0.328767 2013 Friday 7 None A667187 1 120 4 14 calico calico None 4 months Cat 2013 (-0.022, 2.2] Kitten domestic mediumhair Female True 11 False 2013-11-01 2013-07-14 2013-11-15 14:39:00 2013-11-15 30
55 Rogue Momo Return to Owner Neutered Male Neutered Male Cat black domestic shorthair Yes black None 4.000000 2010 Monday 7 None A589009 1 1460 4 19 black None None 4 years Cat 2014 (2.2, 4.4] Cat domestic shorthair Male True 12 False 2014-12-01 2010-07-18 2014-12-15 19:17:00 2014-12-15 365
56 Kitty Adoption Spayed Female Spayed Female Cat white domestic longhair Yes white None 3.000000 2011 Thursday 10 None A689499 1 1095 3 16 white None None 3 years Cat 2014 (2.2, 4.4] Cat domestic longhair Female True 10 False 2014-10-01 2011-10-04 2014-10-09 16:33:00 2014-10-09 365
57 None Transfer Intact Male Intact Male Kitten black domestic shorthair No black Partner 0.076712 2014 Monday 3 None A677216 1 28 4 18 black None None 4 weeks Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Male True 4 False 2014-04-01 2014-03-21 2014-04-21 18:03:00 2014-04-21 7
58 *Joe Adoption Neutered Male Neutered Male Cat black domestic shorthair Yes black/white None 2.000000 2011 Friday 12 None A668683 1 730 2 11 black None white 2 years Cat 2013 (-0.022, 2.2] Cat domestic shorthair Male True 12 False 2013-12-01 2011-12-07 2013-12-13 11:43:00 2013-12-13 365
59 Sage Adoption Intact Female Intact Female Kitten cream domestic shorthair No cream None 0.164384 2014 Sunday 7 None A688519 1 60 2 14 cream tabby None 2 months Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 10 False 2014-10-01 2014-07-29 2014-10-05 14:42:00 2014-10-05 30
60 None Transfer Intact Female Intact Female Kitten brown domestic shorthair No brown Partner 0.057534 2014 Saturday 4 None A678051 1 21 3 16 brown tabby None 3 weeks Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 5 False 2014-05-01 2014-04-11 2014-05-03 16:15:00 2014-05-03 7
61 None Transfer None None black domestic shorthair Yes black Partner 0.038356 2014 Wednesday 5 None A681039 1 14 2 17 black None None 2 weeks Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 6 False 2014-06-01 2014-05-27 2014-06-11 17:11:00 2014-06-11 7
62 None Transfer Intact Female Intact Female Cat None domestic shorthair No None SCRP 2.000000 2012 Sunday 5 None A680225 1 730 2 17 calico calico None 2 years Cat 2014 (-0.022, 2.2] Cat domestic shorthair Female True 6 False 2014-06-01 2012-05-31 2014-06-01 17:15:00 2014-06-01 365
63 *Sophie Adoption Spayed Female Spayed Female Cat None domestic shorthair Yes None None 1.000000 2013 Sunday 1 None A670066 1 365 1 12 torbie torbie None 1 year Cat 2014 (-0.022, 2.2] Cat domestic shorthair Female True 1 False 2014-01-01 2013-01-01 2014-01-12 12:06:00 2014-01-12 365
64 None Euthanasia Intact Female Intact Female Kitten brown domestic mediumhair No brown Suffering 0.164384 2013 Tuesday 9 None A667511 1 60 2 13 brown tabby None 2 months Cat 2013 (-0.022, 2.2] Kitten domestic mediumhair Female True 11 False 2013-11-01 2013-09-04 2013-11-19 13:43:00 2013-11-19 30
65 None Transfer Neutered Male Neutered Male Cat black domestic shorthair Yes black/white SCRP 2.000000 2012 Tuesday 9 None A688674 1 730 2 9 black None white 2 years Cat 2014 (-0.022, 2.2] Cat domestic shorthair Male True 9 False 2014-09-01 2012-09-22 2014-09-23 09:00:00 2014-09-23 365
66 None Adoption Spayed Female Spayed Female Kitten brown domestic shorthair Yes brown Foster 0.246575 2014 Tuesday 3 None A678060 1 90 3 15 brown tabby None 3 months Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 6 False 2014-06-01 2014-03-19 2014-06-24 15:54:00 2014-06-24 30
67 Lucy Adoption Spayed Female Spayed Female Kitten brown domestic longhair Yes brown Foster 0.164384 2014 Saturday 10 None A691706 1 60 2 14 brown tabby None 2 months Cat 2014 (-0.022, 2.2] Kitten domestic longhair Female True 12 False 2014-12-01 2014-10-01 2014-12-13 14:16:00 2014-12-13 30
68 *Magnolia Adoption Spayed Female Spayed Female Cat brown domestic shorthair Yes brown Foster 2.000000 2012 Tuesday 2 None A672190 1 730 2 10 brown tabby None 2 years Cat 2014 (-0.022, 2.2] Cat domestic shorthair Female True 5 False 2014-05-01 2012-02-05 2014-05-13 10:15:00 2014-05-13 365
69 *Martin Transfer Intact Male Intact Male Kitten orange domestic shorthair No orange Partner 0.082192 2013 Wednesday 10 None A669140 1 30 1 16 orange tabby None 1 month Cat 2013 (-0.022, 2.2] Kitten domestic shorthair Male True 12 False 2013-12-01 2013-10-24 2013-12-18 16:14:00 2013-12-18 30
70 None Euthanasia Intact Female Intact Female Cat brown domestic shorthair No brown /white Suffering 8.000000 2005 Tuesday 12 None A669576 1 2920 8 16 brown tabby white 8 years Cat 2013 (6.6, 8.8] Cat domestic shorthair Female True 12 False 2013-12-01 2005-12-23 2013-12-24 16:29:00 2013-12-24 365
71 *Taylor Transfer Intact Female Intact Female Kitten orange domestic shorthair No orange Partner 0.164384 2013 Wednesday 8 None A664486 1 60 2 18 orange tabby None 2 months Cat 2013 (-0.022, 2.2] Kitten domestic shorthair Female True 10 False 2013-10-01 2013-08-04 2013-10-09 18:46:00 2013-10-09 30
72 None Euthanasia Intact Male Intact Male Kitten blue domestic shorthair No blue /white Suffering 0.057534 2014 Tuesday 9 None A689192 1 21 3 15 blue tabby white 3 weeks Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Male True 9 False 2014-09-01 2014-09-08 2014-09-30 15:08:00 2014-09-30 7
73 None Euthanasia Intact Female Intact Female Kitten orange domestic shorthair No orange /white Suffering 0.076712 2014 Saturday 6 None A684110 1 28 4 14 orange tabby white 4 weeks Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 7 False 2014-07-01 2014-06-19 2014-07-19 14:55:00 2014-07-19 7
74 None Adoption Spayed Female Spayed Female Kitten blue domestic shorthair Yes blue Foster 0.246575 2014 Saturday 4 None A677959 1 90 3 11 blue tabby None 3 months Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 7 False 2014-07-01 2014-04-01 2014-07-12 11:36:00 2014-07-12 30
75 None Transfer Intact Male Intact Male Kitten orange domestic shorthair No orange /white SCRP 0.410959 2013 Thursday 5 None A664437 1 150 5 15 orange tabby white 5 months Cat 2013 (-0.022, 2.2] Kitten domestic shorthair Male True 10 False 2013-10-01 2013-05-03 2013-10-03 15:33:00 2013-10-03 30
76 *Trinity Adoption Spayed Female Spayed Female Cat brown domestic shorthair Yes brown None 1.000000 2012 Friday 8 None A672918 1 365 1 15 brown tabby None 1 year Cat 2014 (-0.022, 2.2] Cat domestic shorthair Female True 3 False 2014-03-01 2012-08-18 2014-03-21 15:40:00 2014-03-21 365
77 None Transfer None None black domestic longhair Yes black SCRP 0.821918 2013 Sunday 3 None A671106 1 300 10 17 black None None 10 months Cat 2014 (-0.022, 2.2] Cat domestic longhair Female True 1 False 2014-01-01 2013-03-18 2014-01-19 17:35:00 2014-01-19 30
78 Salem Adoption Neutered Male Neutered Male Cat black domestic shorthair Yes black None 1.000000 2012 Thursday 4 None A626164 1 365 1 16 black None None 1 year Cat 2014 (-0.022, 2.2] Cat domestic shorthair Male True 1 False 2014-01-01 2012-04-16 2014-01-30 16:11:00 2014-01-30 365
79 *Ursula Transfer None None brown domestic shorthair Yes brown Partner 1.000000 2012 Friday 12 None A669753 1 365 1 17 brown tabby None 1 year Cat 2014 (-0.022, 2.2] Cat domestic shorthair Female True 1 False 2014-01-01 2012-12-26 2014-01-03 17:19:00 2014-01-03 365
80 Garfield Transfer Neutered Male Neutered Male Cat orange domestic longhair Yes orange Partner 3.000000 2011 Wednesday 9 None A688206 1 1095 3 14 orange tabby None 3 years Cat 2014 (2.2, 4.4] Cat domestic longhair Male True 9 False 2014-09-01 2011-09-16 2014-09-17 14:06:00 2014-09-17 365
81 *Michonne Transfer Intact Female Intact Female Kitten black domestic shorthair No black/white Partner 0.082192 2014 Wednesday 6 None A684824 1 30 1 14 black None white 1 month Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 8 False 2014-08-01 2014-06-29 2014-08-06 14:23:00 2014-08-06 30
82 *Rust Adoption Spayed Female Spayed Female Kitten None domestic shorthair Yes None Foster 0.164384 2014 Sunday 5 None A682239 1 60 2 16 tortie tortie None 2 months Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 8 False 2014-08-01 2014-05-25 2014-08-03 16:10:00 2014-08-03 30
83 *Kanga Transfer Intact Female Intact Female Kitten None domestic shorthair No None Partner 0.082192 2014 Sunday 8 None A688741 1 30 1 15 torbie torbie None 1 month Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 10 False 2014-10-01 2014-08-24 2014-10-05 15:10:00 2014-10-05 30
84 Zane Adoption Intact Male Intact Male Kitten brown manx No brown /white None 0.246575 2013 Sunday 6 None A664514 1 90 3 18 brown tabby white 3 months Cat 2013 (-0.022, 2.2] Kitten manx Male False 10 True 2013-10-01 2013-06-19 2013-10-13 18:51:00 2013-10-13 30
85 Ron Weasley Transfer Neutered Male Neutered Male Cat orange domestic shorthair Yes orange Partner 1.000000 2012 Tuesday 7 None A671065 1 365 1 13 orange tabby None 1 year Cat 2014 (-0.022, 2.2] Cat domestic shorthair Male True 1 False 2014-01-01 2012-07-17 2014-01-21 13:14:00 2014-01-21 365
86 Laurel Adoption Spayed Female Spayed Female Cat lynx siamese Yes lynx None 16.000000 1998 Wednesday 1 None A670616 1 5840 16 18 lynx point None 16 years Cat 2014 (15.4, 17.6] Cat siamese Female False 2 True 2014-02-01 1998-01-11 2014-02-12 18:34:00 2014-02-12 365
87 None Adoption Neutered Male Neutered Male Kitten blue domestic longhair Yes blue/white None 0.164384 2014 Friday 4 None A683161 1 60 2 18 blue None white 2 months Cat 2014 (-0.022, 2.2] Kitten domestic longhair Male True 7 False 2014-07-01 2014-04-15 2014-07-11 18:54:00 2014-07-11 30
88 Cuddles Return to Owner Neutered Male Neutered Male Cat blue domestic shorthair Yes blue None 3.000000 2011 Wednesday 9 None A688011 1 1095 3 15 blue tabby None 3 years Cat 2014 (2.2, 4.4] Cat domestic shorthair Male True 11 False 2014-11-01 2011-09-13 2014-11-05 15:47:00 2014-11-05 365
89 *Adam Transfer Neutered Male Neutered Male Cat cream domestic shorthair Yes cream Partner 1.000000 2013 Wednesday 7 None A683238 1 365 1 14 cream tabby None 1 year Cat 2014 (-0.022, 2.2] Cat domestic shorthair Male True 8 False 2014-08-01 2013-07-08 2014-08-06 14:37:00 2014-08-06 365
90 None Transfer Intact Male Intact Male Cat brown domestic shorthair No brown /white SCRP 3.000000 2011 Tuesday 11 None A692370 1 1095 3 18 brown tabby white 3 years Cat 2014 (2.2, 4.4] Cat domestic shorthair Male True 11 False 2014-11-01 2011-11-19 2014-11-25 18:41:00 2014-11-25 365
91 Smoke Adoption Neutered Male Neutered Male Cat blue russian blue Yes blue Foster 7.000000 2007 Tuesday 7 None A683856 1 2555 7 15 blue None None 7 years Cat 2014 (6.6, 8.8] Cat russian blue Male False 8 True 2014-08-01 2007-07-16 2014-08-12 15:42:00 2014-08-12 365
92 None Transfer Intact Male Intact Male Kitten orange domestic shorthair No orange Partner 0.057534 2014 Saturday 8 None A688532 1 21 3 18 orange tabby None 3 weeks Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Male True 9 False 2014-09-01 2014-08-29 2014-09-20 18:26:00 2014-09-20 7
93 *Orville Adoption Neutered Male Neutered Male Cat orange domestic shorthair Yes orange /white None 0.904110 2013 Sunday 6 None A678573 1 330 11 16 orange tabby white 11 months Cat 2014 (-0.022, 2.2] Cat domestic shorthair Male True 6 False 2014-06-01 2013-06-10 2014-06-08 16:53:00 2014-06-08 30
94 *Twix Adoption Neutered Male Neutered Male Kitten blue domestic shorthair Yes blue /white Foster 0.164384 2014 Tuesday 4 None A680414 1 60 2 11 blue tabby white 2 months Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Male True 7 False 2014-07-01 2014-04-17 2014-07-08 11:16:00 2014-07-08 30
95 Novio Adoption Intact Male Intact Male Kitten orange domestic mediumhair No orange None 0.164384 2014 Saturday 2 None A677077 1 60 2 15 orange tabby None 2 months Cat 2014 (-0.022, 2.2] Kitten domestic mediumhair Male True 4 False 2014-04-01 2014-02-19 2014-04-26 15:43:00 2014-04-26 30
96 *Pooh Bear Adoption Neutered Male Neutered Male Cat cream domestic shorthair Yes cream None 6.000000 2007 Wednesday 12 None A644391 1 2190 6 12 cream tabby None 6 years Cat 2014 (4.4, 6.6] Cat domestic shorthair Male True 11 False 2014-11-01 2007-12-26 2014-11-12 12:58:00 2014-11-12 365
97 None Transfer None None cream domestic shorthair Yes cream Partner 0.057534 2014 Thursday 10 None A691086 1 21 3 10 cream tabby None 3 weeks Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 10 False 2014-10-01 2014-10-07 2014-10-30 10:37:00 2014-10-30 7
98 *Louisa Died Intact Female Intact Female Kitten None domestic shorthair No None None 0.082192 2014 Tuesday 4 None A678917 1 30 1 9 torbie torbie None 1 month Cat 2014 (-0.022, 2.2] Kitten domestic shorthair Female True 5 False 2014-05-01 2014-04-14 2014-05-20 09:52:00 2014-05-20 30
99 Tiney Transfer Spayed Female Spayed Female Cat orange domestic shorthair Yes orange Partner 0.657534 2014 Wednesday 1 None A688558 1 240 8 15 orange tabby None 8 months Cat 2014 (-0.022, 2.2] Cat domestic shorthair Female True 10 False 2014-10-01 2014-01-20 2014-10-01 15:51:00 2014-10-01 30
animal_name
▲
not_null

📃 Summary: Name of animal

outcome_type
▲
not_nullaccepted_values

📃 Summary: Type of outcome (e.g. Adoption, Transfer)

cat_sex_upon_outcome
▲
not_nullaccepted_values

📃 Summary: Sex of cat at time of outcome

cat_sex_age_outcome
▲
not_nullaccepted_values

📃 Summary: Sex, age and outcome combined (e.g. Spayed Female Kitten)

primary_color
▲
not_nullaccepted_values

📃 Summary: Primary color

breed
▲
not_null

📃 Summary: Breed of animal

spay_neuter_status
▲
not_nullaccepted_values

📃 Summary: Spay/neuter status of animal

color_description
▲
not_null

📃 Summary: Color description

outcome_subtype
▲
not_nullaccepted_values

📃 Summary: Subtype of the outcome (e.g. Partner)

outcome_age_years
▲
not_null

📃 Summary: Age at outcome in years

birth_year
▲
not_null

📃 Summary: Year of birth

outcome_weekday
▲
not_nullaccepted_values

📃 Summary: Day of week of the outcome

birth_month
▲
not_null

📃 Summary: Month of birth

secondary_breed
▲
accepted_values

📃 Summary: Secondary breed of animal
❓ Missing: Animal is not a mixed breed

animal_id
▲
not_nullunique

📃 Summary: Unique animal ID
🦄 Unique: This column represents a unique identifier for each animal. For this table, each row corresponds to an animal record. animal_id is unique across all rows, as it is a unique identifier assigned to each animal.
🎨 Patterns:
  • A\d{6}
    Alphanumeric ID with format 'A' followed by 6 digits

record_count
▲
not_null

📃 Summary: Count of records

outcome_age_days
▲
not_null

📃 Summary: Age at outcome in days

outcome_periods
▲
not_null

📃 Summary: Number of time periods

outcome_hour
▲
not_null

📃 Summary: Hour of outcome

coat_color
▲
not_nullaccepted_values

📃 Summary: Coat color

coat_pattern
▲
not_nullaccepted_values

📃 Summary: Coat pattern

secondary_color
▲
accepted_values

📃 Summary: Secondary color
❓ Missing: Animal does not have a secondary color

age_upon_outcome
▲
not_null

📃 Summary: Age at outcome

animal_type
▲
not_nullaccepted_values

📃 Summary: Type of animal (cat)

outcome_year
▲
not_null

📃 Summary: Year of the outcome

age_group_bucket
▲
not_nullaccepted_values

📃 Summary: Age group bucket

outcome_animal_category
▲
not_nullaccepted_values

📃 Summary: Cat or kitten at outcome

primary_breed
▲
not_nullaccepted_values

📃 Summary: Primary breed of animal

cat_sex
▲
not_nullaccepted_values

📃 Summary: Sex of the cat

is_domestic_breed
▲
not_null

📃 Summary: Domestic breed status

outcome_month
▲
not_null

📃 Summary: Month of outcome

cfa_breed_status
▲
not_null

📃 Summary: CFA (Cat Fanciers' Assoc.) breed status

birth_month_year
▲
not_null

📃 Summary: Month and year of birth

date_of_birth
▲
not_null

📃 Summary: Date of birth

outcome_datetime
▲
not_null

📃 Summary: Date and time of outcome

outcome_month_year
▲
not_null

📃 Summary: Month and year of outcome

outcome_period_range
▲
not_nullaccepted_values

📃 Summary: Time range in days

Cocoon Cleaning Summary 🤗


📃 1. Table Summary


The table contains data about cats in an animal shelter. It includes details on each cat's age, breed, color, sex, name, and outcome (adoption, transfer, return to owner). The table also derives additional fields like time period, age group, and spay/neuter status.


📊 2. Column Rename


😎 25 columns have been renamed
Column Summary New Column Name Renamed?
0 age_upon_outcome Age at outcome age_upon_outcome ❌ No
1 animal_id Unique animal ID animal_id ❌ No
2 animal_type Type of animal (cat) animal_type ❌ No
3 breed Breed of animal breed ❌ No
4 color Color description color_description ✔️ Yes
5 date_of_birth Date of birth date_of_birth ❌ No
6 datetime Date and time of outcome outcome_datetime ✔️ Yes
7 monthyear Month and year of outcome outcome_month_year ✔️ Yes
8 name Name of animal animal_name ✔️ Yes
9 outcome_subtype Subtype of the outcome (e.g. Partner) outcome_subtype ❌ No
10 outcome_type Type of outcome (e.g. Adoption, Transfer) outcome_type ❌ No
11 sex_upon_outcome Sex of cat at time of outcome cat_sex_upon_outcome ✔️ Yes
12 count_ Count of records record_count ✔️ Yes
13 sex Sex of the cat cat_sex ✔️ Yes
14 Spay_Neuter Spay/neuter status of animal spay_neuter_status ✔️ Yes
15 Periods Number of time periods outcome_periods ✔️ Yes
16 Period_Range Time range in days outcome_period_range ✔️ Yes
17 outcome_age__days_ Age at outcome in days outcome_age_days ✔️ Yes
18 outcome_age__years_ Age at outcome in years outcome_age_years ✔️ Yes
19 Cat_Kitten__outcome_ Cat or kitten at outcome outcome_animal_category ✔️ Yes
20 sex_age_outcome Sex, age and outcome combined (e.g. Spayed Female Kitten) cat_sex_age_outcome ✔️ Yes
21 age_group Age group bucket age_group_bucket ✔️ Yes
22 dob_year Year of birth birth_year ✔️ Yes
23 dob_month Month of birth birth_month ✔️ Yes
24 dob_monthyear Month and year of birth birth_month_year ✔️ Yes
25 outcome_month Month of outcome outcome_month ❌ No
26 outcome_year Year of the outcome outcome_year ❌ No
27 outcome_weekday Day of week of the outcome outcome_weekday ❌ No
28 outcome_hour Hour of outcome outcome_hour ❌ No
29 breed1 Primary breed of animal primary_breed ✔️ Yes
30 breed2 Secondary breed of animal secondary_breed ✔️ Yes
31 cfa_breed CFA (Cat Fanciers' Assoc.) breed status cfa_breed_status ✔️ Yes
32 domestic_breed Domestic breed status is_domestic_breed ✔️ Yes
33 coat_pattern Coat pattern coat_pattern ❌ No
34 color1 Primary color primary_color ✔️ Yes
35 color2 Secondary color secondary_color ✔️ Yes
36 coat Coat color coat_color ✔️ Yes



👯‍♀️ 3. Duplicate


🔍 7 duplicates have been detected
✔️ Duplicates have been removed


✂️ 4. Leading and Trailing Whitespace


🔍 2 columns have leading and trailing whitespace
✔️ 2 columns have been trimmed


🚧 5. Erroneous Values


🔍 2 columns have erroneous values
  1. color_description: '/white' is unusual because it seems to be missing a color before the slash.
    ❌ The column has not been cleaned

  2. animal_name: '*Charlie', 'X', '*Lily', and '*Molly' are unusual because they contain atypical characters for animal names.
    ❌ The column has not been cleaned


🕵️‍♂️ 6. Disguised Missing Values


🔍 5 columns have disguised missing values
✔️ 5 columns have been cleaned
Column Disguised Missing Values Impute to NULL? Values to NULL (Sep By ,)
0 animal_name [X] True X
1 outcome_type [Missing] True Missing
2 cat_sex_upon_outcome [Unknown] True Unknown
3 cat_sex_age_outcome [Unknown Kitten, Unknown Cat] True Unknown Kitten,Unknown Cat
4 primary_color [Breed Specific] True Breed Specific



🔧 7. Data Type


✔️ 5 columns have been casted
Column Name Clause Reasoning
0 birth_month_year TO_DATE("birth_month_year" || '-01', 'YYYY-MM-DD') To transform the 'birth_month_year' column from VARCHAR to DATE, we can simply use the CAST function. The column is already in a format that Snowflake recognizes as a valid date (YYYY-MM), so no additional formatting is needed in the cast clause.\n
1 date_of_birth CAST("date_of_birth" AS TIMESTAMP) To transform the 'date_of_birth' column from VARCHAR to TIMESTAMP data type in Snowflake, we can simply use the CAST function. The existing format of the values ('YYYY-MM-DD HH24:MI:SS') matches one of the default timestamp formats recognized by Snowflake, so no additional formatting is needed in the cast clause.\n
2 outcome_datetime CAST("outcome_datetime" AS TIMESTAMP) To transform the 'outcome_datetime' column from VARCHAR to TIMESTAMP, we can use a simple CAST clause in Snowflake. The existing format of the values ('YYYY-MM-DD HH24:MI:SS') matches the default format for TIMESTAMP in Snowflake, so no additional formatting is needed.\n
3 outcome_month_year CAST("outcome_month_year" AS DATE) To transform the 'outcome_month_year' column from VARCHAR to DATE, we can use a simple CAST clause in Snowflake. The existing format of the values is 'YYYY-MM-DDTHH:mm:ss'. To cast this to a DATE, we don't need to specify the format as Snowflake will automatically recognize this common ISO 8601 timestamp format and extract just the date portion.\n
4 outcome_period_range CAST("outcome_period_range" AS VARCHAR) To transform the data type of the 'outcome_period_range' column from 'INT' to 'VARCHAR' in Snowflake, we need to use the CAST function. The CAST function allows us to convert a value from one data type to another. In this case, we will cast the 'outcome_period_range' column to the 'VARCHAR' data type. The syntax for the CAST function in Snowflake is: CAST(expression AS target_data_type) So, we will replace 'expression' with the column name 'outcome_period_range' and 'target_data_type' with 'VARCHAR'.\n



❓ 8. Missing Values


🔍 10 columns have missing values
✔️ 2 of them are acceptable
Column NULL (%) Is NULL Acceptable? Explanation
0 animal_name 43.53 False
1 cat_sex_age_outcome 8.59 False
2 cat_sex_upon_outcome 8.59 False
3 coat_pattern 34.89 False
4 color_description 12.32 False
5 outcome_subtype 36.64 False
6 outcome_type 0.11 False
7 primary_color 13.79 False
8 secondary_breed 99.82 True Animal is not a mixed breed
9 secondary_color 64.81 True Animal does not have a secondary color

🧩 These missing values are handled as follows:
Column NULL (%) Strategy
0 animal_name 43.53 🔄 Unchanged
1 cat_sex_age_outcome 8.59 🔄 Unchanged
2 cat_sex_upon_outcome 8.59 🔄 Unchanged
3 coat_pattern 34.89 🔄 Unchanged
4 color_description 12.32 🔄 Unchanged
5 outcome_subtype 36.64 🔄 Unchanged
6 outcome_type 0.11 🔄 Unchanged
7 primary_color 13.79 🔄 Unchanged