Since the list I posted below in response to Gary's original question
is somewhat out of date, maybe a better way to answer the question is
to list projects that each one of us IS working on?

Here's my quick list:

1. Negro Leagues - Will VERY shortly have the LEAUGE and TEAM Table
completed, plus the PARKS related tables. After that, will have a
beginning MASTER file plus possibly some 1928 actual batting,
pitching and fielding data...

2. LEAGUES super/master table - This turned out to be a huge
project. Am about 50% completed, but have been waiting for the new
Minor Leagues Encyclopedia to come out before continuing (anyone have
an update on when it will be out?)

3. TEAMS super/master table - Will follow after the LEAGUES table is
completed.

4. SALARIES Table for pre-1985 - Have made good progress on 19th
century salaries, but still huge gaps from deadball era to 1984. Am
hopefull that SABR may be releasing some additional data soon...

5. INJURIES DATABASE - Focusing on years before the disabled list
came to be routinely used (pre-1960). Project just getting off the
ground.

6. JAPANESE DATA - Deferring to Michael Westbay. I do have some
historical data, primarily on players who played in both MLB and NPB,
that I need to finish putting in table form.

THANKS,
Kevin


--- In baseball-databank@yahoogroups.com, "KJOK" <kjokbaseball@y...>
wrote:
> Welcome Gary:
>
> This list needs updating, but I believe it's the last one we have
> regarding "what needs to be done" (numbers are previous message
numbers
> in this group):
>
> ==========================
> > PRIORITY 1 - Handle ASAP
> > Type:
> > (1) any item that contains errors in data
> > (2) data that existed, and is now missing
> > ==========================
> > HOF ERRORS
> > 1235
> > 1237
> > 1238
> > (Sean Forman handling.)
> >
> > BATTING ERRORS
> > 1233
> > (KJOK posted corrections.)
> >
> > PITCHING ERRORS
> > 1216-1220
> > 1232
> > (KJOK posted corrections.)
> >
> > STINT ID
> > 1215
> > 1227-1228
> > 1230-1231
> >
> > PLAYER/MANAGER ERRORS
> > 1212
> >
> > DATA ERRORS
> > 1129
> > 1144
> > 1186
> > 1191-1194
> >
> > NEW FILES - errors
> > 1091
> >
> > Positions - Existence/Loss
> > 988 - 990
> > (We used to have some PR/PH data. We don't anymore.)
> >
> > ==========================
> > PRIORITY 2 - Handle Very Very Soon
> > Type:
> > (1) Organizational, procedural items for handling BDB
> > ==========================
> > DISTINGUISH BETWEEN OFFICIAL/UNOFFICIAL ERRORS
> > 1241
> > (Some are known accepted errors.)
> >
> > POW-WOW / organizational direction
> > 1112-1113
> > 1170
> > 1202
> > (CVS, roles/responsibilities. No movement.)
> >
> > SCRIPTS / FILE STRUCTURE
> > 1092-1093
> > 1095-1097
> > 1101
> > 1109
> > 1111 (proposal/accepted)
> > 1173 (proposal)
> > (Derek to write some of the scripts.)
> >
> > FAQ - SYNTAX RULES - field delimiters
> > 987
> > 1032-1037
> > (To be used for above.)
> >
> > Access - 97/2000/XP
> > many (macro only confirmed to work with Access 2000)
> > 1079
> > 1084-1085
> > (Tom needs to create the latest schema.ini file, and give
direction
> > as to producing it programmatically. Scripts may need to be
> written.)
> >
> > ==========================
> > PRIORITY 3 - Handle Very Soon
> > Type:
> > (1) Primary Tables
> > ==========================
> > EXTRA DATA
> > 1110
> > 1114
> > 1142-1143
> > 1208
> > (Should be incorporated. Status unknown. Is Derek's XREF for
> > Retro/Player ID updated?)
> >
> >
> > ==========================
> > PRIORITY 4 - Handle Soon
> > Type:
> > (1) Design Issues, normalization, keys
> > (2) XREF to other databases
> > (3) Standards
> > ==========================
> > SIZE OF FIELDS
> > 1213
> > (Try to imrpove sizing of DB.)
> >
> > STINT ID
> > 1196
> > (Use is inconsistent or wrong.)
> >
> > PARKS
> > 1117-1120
> > 1161
> > 1181-1182
> > 1223
> > (Tom/KJOK updated and uploaded. The BDB/TEAMS table should be
> updated
> > so that it references the new PARK ID, and not the Park NAME.)
> >
> > TEAMS / FRANCHISES - XREF to retrosheet
> > 1145-1147
> > 1174-1175
> > 1183-1184
> >
> > http://groups.yahoo.com/group/RetroList/message/1904
> > 1907-1911
> > (Paul, KJOK reviewing. Discussions to follow. Tom to upload mid-
> > Jan.)
> >
> >
> > DESIGN - leagues - create table
> > 1055-1062
> > 1068-1075
> > 1077-1081
> > (Paul, KJOK, Tom should propose something.)
> >
> > DESIGN - normalization - teams/franchises
> > 1042
> > 1045
> > 1049
> > 1051-1053
> > (Should be implemented, unless more discussions required.)
> >
> > DESIGN - keys - manager table
> > 1043
> > (Should be implemented. This is in ERROR.)
> >
> > DESIGN - keys - lg ID
> > 1044
> > 1048
> > (Should be implemented. This is in ERROR.)
> >
> > Place Names - ISO standards
> > 940
> > 950
> > 952
> > 956
> > 960
> > 967-969
> > (Proposal/resolution required.)
> >
> >
> > ==========================
> > PRIORITY 5 - Handle At Some point
> > Type:
> > (1) Cool add-ons
> > (2) Secondary (tertiary?) data/tables
> > ==========================
> > POSITIONS
> > 1178
> > 1239-1240
> > (Need someone to program the determination of primary positions.
> Tom
> > has uploaded complex query, but it could be improved.)
> >
> > Umpires/HOF/Coaches/Executives/no-hitters
> > 876
> > 879
> > 881
> > 883-886
> > 888-889
> > 891-898
> > 1133
> > 1136-1139
> > 1185
> > 1199-1201
> > (Mike Crain: Umps working on. HOF completed and integrated.
> Coaches
> > near completion. Executives ongoing.)
> > (Derek: working on no-hitters from Mike.)
> >
> > END-USER INTERFACES
> > 1203-1206
> > 1209-1210
> > 1214
> > (Ongoing work by a few individuals.)
> >
> >
> > 19th-century transactions
> > 1224
> > (Mike uploaded.)
> >
> > ==========================
> > PRIORITY 6 - Unknown
> > ==========================
> > INSIDE THE PARK HR
> > 1163
> > (On hold.)
> >
> > MASTER - DOB
> > 1054
> > (No one has stepped forward to handle. Not critical.)
> >
> > Negro League data, Japanese League data, Minor League data,
> Executives
> > (No note. No one has stepped forward to handle. Not critical.)
>
>
> --- In baseball-databank@yahoogroups.com, "Gary" <gcohen33@y...>
wrote:
> >
> > Hello,
> >
> > I'd just like to introduce myself to this group and offer my
time. I
> > am a lifelong baseball fan, SQL developer, and stat geek. I've
been
> > known to spend hours on baseballreference.com just for the fun of
> it.
> > I have just recently learned of the existence of this group and
would
> > love to contribute in any way, whether it be loading data,
> > programming, quality control or otherwise.
> >
> > If anyone could give me some direction re: what is needed and
what
> > would be helpful, I would love to hear it.
> >
> > Thanks,
> >
> > Gary Cohen