[Babase] Total numbers by interact type

Niki Learn nlearn at princeton.edu
Mon Apr 19 15:34:11 EDT 2010


Okay, I will take a look at some of the cases and see what I find.
Meanwhile:

 

You also asked about how the numbers for grooming compared, with the idea
that groomings are less likely to actually occur between groups than are
agonisms.  That in fact appears to be the case, both by raw numbers and by
proportion of the total.  And MCEs are lower still.

 

Using Karl's warning query he sent earlier, with the following line or lines
added (right before "order by"), I got these results (I am not familiar with
these interact tables and so have not attempted to add gender to these
queries - I have been using actor_actees) out of the 5689 total mismatches
Karl reported:

 

and interact.act in ('A', 'AS', 'OS', 'DS')

                3883 agonisms (all years) - this is 1.29% of all agonisms

 

and interact.act in ('A', 'AS', 'OS', 'DS')

and interact.date >= '2000-01-01' 

and interact.date <= '2008-06-30'

                358 agonisms (2000 - 2008a only)

 

Total agonisms in babase = 300,066; total in 2000-2008a = 10,996

 

 

and interact.act = 'G'

1705 groomings (all years) - this is 0.62% of all groomings

 

and interact.act = 'G'

and interact.date >= '2000-01-01' and interact.date <= '2008-06-30'

                520 groomings (2000 - 2008a only)

 

Total grooming in babase = 274,601; total in 2000-2008a = 104,477

 

 

and interact.act in ('P', 'R')

                3 approaches/requests to groom (all three were in 2000 -
2008a) - this is 0.38% of total

 

Total approaches and requests to groom in babase = 787

 

 

and interact.act in ('M', 'C', 'E')

                98 MCEs (all years) - this is 0.30% of all MCEs

 

and interact.act in ('M', 'C', 'E')

and interact.date >= '2000-01-01' 

and interact.date <= '2008-06-30'

                22 MCEs (2000 -2008a only)

 

Total MCEs in babase = 32,708; total in 2000-2008a = 10,953

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://eeblistserv.Princeton.EDU/pipermail/babase/attachments/20100419/374b12ca/attachment-0001.html


More information about the Babase mailing list