[Babase] Males with Matgrp 9, not in grp 9 at birth
Karl O. Pinc
kop at meme.com
Sat Dec 26 22:04:15 EST 2009
On 12/26/2009 08:32:27 PM, Lacey Maryott Roerish wrote:
> There are no longer any males in the DB with a matgrp of 9, but whose
> members records place them in a study group since birth!
I'm not sure exactly what you're cleaning up but there are a few
left matching your conditions above. And there also seem to be
a number of others where somebody tried to clean up by putting
census.status of A and C at the birthdate but census.status B
rows remain and place the individuals into study groups (because
the Bs were never removed?). It's possible somebody did something
for the conversion, maybe, to fix some sort of data integrity error
and get the rows to go into the database. In any case, there's
something artificial going on because we don't have real A and C
census rows going back that far. (Do we?)
Maybe what's left are the males that really were in the
study groups when real censuses started?
babase=> select distinct sname from census where status = 'B' order by
sname;
sname
-------
ALY
BAR
BJX
COW
DAR
DUT
HAR
IBI
IVA
KUS
LIP
MAX
MWA
NGU
PET
PIG
RAD
SEK
SIN
SLK
STB
TUL
WYM
(23 rows)
babase=> select census.grp, census.sname, biograph.matgrp, count(*)
from census, biograph where census.status = 'B' and biograph.sname =
census.sname group by census.grp, census.sname, biograph.matgrp order
by census.grp, census.sname;
grp | sname | matgrp | count
------+-------+--------+-------
1.00 | BJX | 9.00 | 4
1.00 | COW | 9.00 | 210
1.00 | DUT | 9.00 | 1486
1.00 | IVA | 9.00 | 329
1.00 | MAX | 9.00 | 2023
1.00 | PET | 9.00 | 2639
1.00 | SIN | 9.00 | 471
1.00 | STB | 9.00 | 1564
2.00 | ALY | 9.00 | 515
2.00 | BAR | 9.00 | 664
2.00 | HAR | 9.00 | 810
2.00 | LIP | 9.00 | 98
2.00 | SEK | 9.00 | 232
2.00 | SLK | 9.00 | 1902
2.00 | WYM | 9.00 | 222
3.00 | NGU | 9.00 | 1853
3.00 | RAD | 9.00 | 3078
3.00 | TUL | 9.00 | 1494
4.00 | IBI | 9.00 | 570
4.00 | KUS | 4.00 | 3413
4.00 | MWA | 9.00 | 4019
4.00 | PIG | 9.00 | 121
6.00 | DAR | 9.00 | 1
9.00 | DAR | 9.00 | 3638
9.00 | IBI | 9.00 | 3267
(25 rows)
A lot seem to match the pattern shown below....
babase=> select * from census where census.sname = 'BJX' order by
census.date;
cenid | date | sname | grp | status | cen
---------+------------+-------+-------+--------+-----
2024695 | 1971-07-31 | BJX | 1.00 | A | t
2024694 | 1971-08-01 | BJX | 1.00 | C | t
147562 | 1971-08-02 | BJX | 1.00 | B | f
147635 | 1971-08-03 | BJX | 1.00 | B | f
147708 | 1971-08-04 | BJX | 1.00 | B | f
147781 | 1971-08-05 | BJX | 1.00 | B | f
147924 | 1971-08-06 | BJX | 99.00 | S | f
147997 | 1971-08-07 | BJX | 99.00 | S | f
148070 | 1971-08-08 | BJX | 99.00 | S | f
148143 | 1971-08-09 | BJX | 99.00 | S | f
148216 | 1971-08-10 | BJX | 99.00 | S | f
148289 | 1971-08-11 | BJX | 99.00 | S | f
...
While you're cleaning up arn't the 'S' rows with
a group of 99.00 redundant and able to be eliminated?
Karl <kop at meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
More information about the Babase
mailing list