Loading ...
Sorry, an error occurred while loading the content.

FIX: Missing death dates

Expand Messages
  • Alberto Perdomo
    Hi, all: Below is a list of Dominican players who has died but his death dates are missing from the Master table. Rafael Robles died on August 13th, 1998 in
    Message 1 of 5 , Aug 5, 2002
    • 0 Attachment

      Hi, all:

       

      Below is a list of Dominican players who has died but his death dates are missing from the Master table.

       

       

      Rafael Robles died on August 13th, 1998 in New York City

       

               Documentation:

       

                         http://sportsillustrated.cnn.com/baseball/mlb/all_time_stats/players/r/40772/

       

               To insert this date use:

       

      update master set

        deathYear=1998,

        deathMonth=08,

        deathDay=13,

        deathCountry='USA',

        deathCity='New York',

        deathState='NY'

      where playerid='roblera01'

       

      José Oliva died on a car accident on December 22, 1997 in Santo Domingo(BTW, he was driving a Mondesi’s car)

       

               Documentation:

       

                         http://thedeadballera.crosswinds.net/Obits/OlivaJosesObit.html

       

               To insert this date use:

       

      update master set

        deathYear=1997,

        deathMonth=12,

        deathDay=22,

        deathCountry='D.R.',

        deathCity='Santo Domingo'

      where playerid='olivajo01'

       

       

      Rufino Linares died on a car accident on May 16, 1998 in Santo Domingo.

       

      Documentation:

       

      http://thedeadballera.crosswinds.net/Obits/LinaresRufinosObit.html

       

               To insert this date use:

       

      update master set

        deathYear=1998,

        deathMonth=05,

        deathDay=16,

        deathCountry='D.R.',

        deathCity='Santo Domingo'

      where playerid='linarru01'

       

      Regards,

       

      Alberto.

       

       

    • ucraimx
      My database dies not have any death location fields (city , state, country). Do I have an outdated MASTER table? BTW, this is what the query looks ile in
      Message 2 of 5 , Aug 8, 2002
      • 0 Attachment
        My database dies not have any death location fields (city , state,
        country). Do I have an outdated MASTER table?


        BTW, this is what the query looks ile in access:

        UPDATE master SET master.DeathYear = 1998, master.DeathMonth = 8,
        master.DeathDay = 13
        WHERE (((master.LahmanID)="roblera01"));


        MikeC


        --- In baseball-databank@y..., "Alberto Perdomo" <a.perdomo@c...>
        wrote:
        > Hi, all:
        >
        >
        >
        > Below is a list of Dominican players who has died but his death
        dates
        > are missing from the Master table.
        >
        >
        >
        >
        >
        > Rafael Robles died on August 13th, 1998 in New York City.
        >
        >
        >
        > Documentation:
        >
        >
        >
        >
        >
        http://sportsillustrated.cnn.com/baseball/mlb/all_time_stats/players/r
        /4
        > 0772/
        >
        >
        >
        > To insert this date use:
        >
        >
        >
        > update master set
        >
        > deathYear=1998,
        >
        > deathMonth=08,
        >
        > deathDay=13,
        >
        > deathCountry='USA',
        >
        > deathCity='New York',
        >
        > deathState='NY'
        >
        > where playerid='roblera01'
        >
        >
        >
        > José Oliva died on a car accident on December 22, 1997 in Santo
        Domingo.
        > (BTW, he was driving a Mondesi's car)
        >
        >
        >
        > Documentation:
        >
        >
        >
        >
        > http://thedeadballera.crosswinds.net/Obits/OlivaJosesObit.html
        >
        >
        >
        > To insert this date use:
        >
        >
        >
        > update master set
        >
        > deathYear=1997,
        >
        > deathMonth=12,
        >
        > deathDay=22,
        >
        > deathCountry='D.R.',
        >
        > deathCity='Santo Domingo'
        >
        > where playerid='olivajo01'
        >
        >
        >
        >
        >
        > Rufino Linares died on a car accident on May 16, 1998 in Santo
        Domingo.
        >
        >
        >
        > Documentation:
        >
        >
        >
        > http://thedeadballera.crosswinds.net/Obits/LinaresRufinosObit.html
        >
        >
        >
        > To insert this date use:
        >
        >
        >
        > update master set
        >
        > deathYear=1998,
        >
        > deathMonth=05,
        >
        > deathDay=16,
        >
        > deathCountry='D.R.',
        >
        > deathCity='Santo Domingo'
        >
        > where playerid='linarru01'
        >
        >
        >
        > Regards,
        >
        >
        >
        > Alberto.
      • ucraimx
        I see why....I m on the old access DB (4.0). Is the new one available yet? Mike C ... http://sportsillustrated.cnn.com/baseball/mlb/all_time_stats/players/r
        Message 3 of 5 , Aug 8, 2002
        • 0 Attachment
          I see why....I'm on the old access DB (4.0). Is the new one available
          yet?


          Mike C


          --- In baseball-databank@y..., "ucraimx" <ucraimx@y...> wrote:
          > My database dies not have any death location fields (city , state,
          > country). Do I have an outdated MASTER table?
          >
          >
          > BTW, this is what the query looks ile in access:
          >
          > UPDATE master SET master.DeathYear = 1998, master.DeathMonth = 8,
          > master.DeathDay = 13
          > WHERE (((master.LahmanID)="roblera01"));
          >
          >
          > MikeC
          >
          >
          > --- In baseball-databank@y..., "Alberto Perdomo" <a.perdomo@c...>
          > wrote:
          > > Hi, all:
          > >
          > >
          > >
          > > Below is a list of Dominican players who has died but his death
          > dates
          > > are missing from the Master table.
          > >
          > >
          > >
          > >
          > >
          > > Rafael Robles died on August 13th, 1998 in New York City.
          > >
          > >
          > >
          > > Documentation:
          > >
          > >
          > >
          > >
          > >
          >
          http://sportsillustrated.cnn.com/baseball/mlb/all_time_stats/players/r
          > /4
          > > 0772/
          > >
          > >
          > >
          > > To insert this date use:
          > >
          > >
          > >
          > > update master set
          > >
          > > deathYear=1998,
          > >
          > > deathMonth=08,
          > >
          > > deathDay=13,
          > >
          > > deathCountry='USA',
          > >
          > > deathCity='New York',
          > >
          > > deathState='NY'
          > >
          > > where playerid='roblera01'
          > >
          > >
          > >
          > > José Oliva died on a car accident on December 22, 1997 in Santo
          > Domingo.
          > > (BTW, he was driving a Mondesi's car)
          > >
          > >
          > >
          > > Documentation:
          > >
          > >
          > >
          > >
          > > http://thedeadballera.crosswinds.net/Obits/OlivaJosesObit.html
          > >
          > >
          > >
          > > To insert this date use:
          > >
          > >
          > >
          > > update master set
          > >
          > > deathYear=1997,
          > >
          > > deathMonth=12,
          > >
          > > deathDay=22,
          > >
          > > deathCountry='D.R.',
          > >
          > > deathCity='Santo Domingo'
          > >
          > > where playerid='olivajo01'
          > >
          > >
          > >
          > >
          > >
          > > Rufino Linares died on a car accident on May 16, 1998 in Santo
          > Domingo.
          > >
          > >
          > >
          > > Documentation:
          > >
          > >
          > >
          > > http://thedeadballera.crosswinds.net/Obits/LinaresRufinosObit.html
          > >
          > >
          > >
          > > To insert this date use:
          > >
          > >
          > >
          > > update master set
          > >
          > > deathYear=1998,
          > >
          > > deathMonth=05,
          > >
          > > deathDay=16,
          > >
          > > deathCountry='D.R.',
          > >
          > > deathCity='Santo Domingo'
          > >
          > > where playerid='linarru01'
          > >
          > >
          > >
          > > Regards,
          > >
          > >
          > >
          > > Alberto.
        • Sean Lahman
          The current release of the access database is 4.5. It includes the death info. You can download it from: http://baseball1.com/statistics/ Regards, Sean Lahman
          Message 4 of 5 , Aug 8, 2002
          • 0 Attachment
            The current release of the access database is 4.5. It includes the death
            info. You can download it from:

            http://baseball1.com/statistics/

            Regards,
            Sean Lahman


            -----Original Message-----
            From: ucraimx [mailto:ucraimx@...]
            Sent: Thursday, August 08, 2002 3:15 PM
            To: baseball-databank@yahoogroups.com
            Subject: [baseball-databank] Re: FIX: Missing death dates


            I see why....I'm on the old access DB (4.0). Is the new one available
            yet?


            Mike C


            --- In baseball-databank@y..., "ucraimx" <ucraimx@y...> wrote:
            > My database dies not have any death location fields (city , state,
            > country). Do I have an outdated MASTER table?
            >
            >
            > BTW, this is what the query looks ile in access:
            >
            > UPDATE master SET master.DeathYear = 1998, master.DeathMonth = 8,
            > master.DeathDay = 13
            > WHERE (((master.LahmanID)="roblera01"));
            >
            >
            > MikeC
            >
            >
            > --- In baseball-databank@y..., "Alberto Perdomo" <a.perdomo@c...>
            > wrote:
            > > Hi, all:
            > >
            > >
            > >
            > > Below is a list of Dominican players who has died but his death
            > dates
            > > are missing from the Master table.
            > >
            > >
            > >
            > >
            > >
            > > Rafael Robles died on August 13th, 1998 in New York City.
            > >
            > >
            > >
            > > Documentation:
            > >
            > >
            > >
            > >
            > >
            >
            http://sportsillustrated.cnn.com/baseball/mlb/all_time_stats/players/r
            > /4
            > > 0772/
            > >
            > >
            > >
            > > To insert this date use:
            > >
            > >
            > >
            > > update master set
            > >
            > > deathYear=1998,
            > >
            > > deathMonth=08,
            > >
            > > deathDay=13,
            > >
            > > deathCountry='USA',
            > >
            > > deathCity='New York',
            > >
            > > deathState='NY'
            > >
            > > where playerid='roblera01'
            > >
            > >
            > >
            > > José Oliva died on a car accident on December 22, 1997 in Santo
            > Domingo.
            > > (BTW, he was driving a Mondesi's car)
            > >
            > >
            > >
            > > Documentation:
            > >
            > >
            > >
            > >
            > > http://thedeadballera.crosswinds.net/Obits/OlivaJosesObit.html
            > >
            > >
            > >
            > > To insert this date use:
            > >
            > >
            > >
            > > update master set
            > >
            > > deathYear=1997,
            > >
            > > deathMonth=12,
            > >
            > > deathDay=22,
            > >
            > > deathCountry='D.R.',
            > >
            > > deathCity='Santo Domingo'
            > >
            > > where playerid='olivajo01'
            > >
            > >
            > >
            > >
            > >
            > > Rufino Linares died on a car accident on May 16, 1998 in Santo
            > Domingo.
            > >
            > >
            > >
            > > Documentation:
            > >
            > >
            > >
            > > http://thedeadballera.crosswinds.net/Obits/LinaresRufinosObit.html
            > >
            > >
            > >
            > > To insert this date use:
            > >
            > >
            > >
            > > update master set
            > >
            > > deathYear=1998,
            > >
            > > deathMonth=05,
            > >
            > > deathDay=16,
            > >
            > > deathCountry='D.R.',
            > >
            > > deathCity='Santo Domingo'
            > >
            > > where playerid='linarru01'
            > >
            > >
            > >
            > > Regards,
            > >
            > >
            > >
            > > Alberto.



            http://www.baseball-databank.org/

            To unsubscribe from this group, send an email to:
            baseball-databank-unsubscribe@yahoogroups.com



            Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
          • ucraimx
            Unless I m missing someting due to my lack of sleep, that MASTER does not have the death city/state/country either. I don t see any differences..... MikeC ...
            Message 5 of 5 , Aug 8, 2002
            • 0 Attachment
              Unless I'm missing someting due to my lack of sleep, that MASTER does
              not have the death city/state/country either. I don't see any
              differences.....



              MikeC



              --- In baseball-databank@y..., "Sean Lahman" <slahman@b...> wrote:
              > The current release of the access database is 4.5. It includes the
              death
              > info. You can download it from:
              >
              > http://baseball1.com/statistics/
              >
              > Regards,
              > Sean Lahman
              >
              >
              > -----Original Message-----
              > From: ucraimx [mailto:ucraimx@y...]
              > Sent: Thursday, August 08, 2002 3:15 PM
              > To: baseball-databank@y...
              > Subject: [baseball-databank] Re: FIX: Missing death dates
              >
              >
              > I see why....I'm on the old access DB (4.0). Is the new one
              available
              > yet?
              >
              >
              > Mike C
              >
              >
              > --- In baseball-databank@y..., "ucraimx" <ucraimx@y...> wrote:
              > > My database dies not have any death location fields (city , state,
              > > country). Do I have an outdated MASTER table?
              > >
              > >
              > > BTW, this is what the query looks ile in access:
              > >
              > > UPDATE master SET master.DeathYear = 1998, master.DeathMonth = 8,
              > > master.DeathDay = 13
              > > WHERE (((master.LahmanID)="roblera01"));
              > >
              > >
              > > MikeC
              > >
              > >
              > > --- In baseball-databank@y..., "Alberto Perdomo" <a.perdomo@c...>
              > > wrote:
              > > > Hi, all:
              > > >
              > > >
              > > >
              > > > Below is a list of Dominican players who has died but his death
              > > dates
              > > > are missing from the Master table.
              > > >
              > > >
              > > >
              > > >
              > > >
              > > > Rafael Robles died on August 13th, 1998 in New York City.
              > > >
              > > >
              > > >
              > > > Documentation:
              > > >
              > > >
              > > >
              > > >
              > > >
              > >
              >
              http://sportsillustrated.cnn.com/baseball/mlb/all_time_stats/players/r
              > > /4
              > > > 0772/
              > > >
              > > >
              > > >
              > > > To insert this date use:
              > > >
              > > >
              > > >
              > > > update master set
              > > >
              > > > deathYear=1998,
              > > >
              > > > deathMonth=08,
              > > >
              > > > deathDay=13,
              > > >
              > > > deathCountry='USA',
              > > >
              > > > deathCity='New York',
              > > >
              > > > deathState='NY'
              > > >
              > > > where playerid='roblera01'
              > > >
              > > >
              > > >
              > > > José Oliva died on a car accident on December 22, 1997 in Santo
              > > Domingo.
              > > > (BTW, he was driving a Mondesi's car)
              > > >
              > > >
              > > >
              > > > Documentation:
              > > >
              > > >
              > > >
              > > >
              > > > http://thedeadballera.crosswinds.net/Obits/OlivaJosesObit.html
              > > >
              > > >
              > > >
              > > > To insert this date use:
              > > >
              > > >
              > > >
              > > > update master set
              > > >
              > > > deathYear=1997,
              > > >
              > > > deathMonth=12,
              > > >
              > > > deathDay=22,
              > > >
              > > > deathCountry='D.R.',
              > > >
              > > > deathCity='Santo Domingo'
              > > >
              > > > where playerid='olivajo01'
              > > >
              > > >
              > > >
              > > >
              > > >
              > > > Rufino Linares died on a car accident on May 16, 1998 in Santo
              > > Domingo.
              > > >
              > > >
              > > >
              > > > Documentation:
              > > >
              > > >
              > > >
              > > >
              http://thedeadballera.crosswinds.net/Obits/LinaresRufinosObit.html
              > > >
              > > >
              > > >
              > > > To insert this date use:
              > > >
              > > >
              > > >
              > > > update master set
              > > >
              > > > deathYear=1998,
              > > >
              > > > deathMonth=05,
              > > >
              > > > deathDay=16,
              > > >
              > > > deathCountry='D.R.',
              > > >
              > > > deathCity='Santo Domingo'
              > > >
              > > > where playerid='linarru01'
              > > >
              > > >
              > > >
              > > > Regards,
              > > >
              > > >
              > > >
              > > > Alberto.
              >
              >
              >
              > http://www.baseball-databank.org/
              >
              > To unsubscribe from this group, send an email to:
              > baseball-databank-unsubscribe@y...
              >
              >
              >
              > Your use of Yahoo! Groups is subject to
              http://docs.yahoo.com/info/terms/
            Your message has been successfully submitted and would be delivered to recipients shortly.