Welcome Guest
Log In | Register )
The time is now 11:47 pm
You last visited July 31, 2014, 11:43 pm
All times shown are
Eastern Time (GMT-5:00)

Premium members: can I get your help?

Topic closed. 103 replies. Last post 5 years ago by Todd.

Page 1 of 7
53
PrintE-mailLink
Todd's avatar - Cylon 2.gif
Chief Bottle Washer
New Jersey
United States
Member #1
May 31, 2000
21449 Posts
Online
Posted: June 29, 2009, 11:59 pm - IP Logged

I am looking to shore-up any loose ends in the LP results database and add any remaining data that is missing.

In other words, I would like to ensure that we have the complete drawing history of every single game, back to the very first drawing.

Most games have this already, but I'm sure there are some that have missing data, even if it is from 30 years ago.

Here's where I can use your help:  Since premium members have access to the entire LP database, I am looking for premium members to help identify those games with missing data.  Maybe if you could check your own state, or even if you want to check some other states, if you could check the earliest date in the LP database for the games, and match that to the start of each game (which should be available from the state lotteries, most likely on their site), and post back with any games with missing data.

The reason I'm asking for help is that it's just a lot of legwork, and if we could spread the work around a little that would really help.  Then when the data gets loaded, we all benefit.

Thanks!!

All games, actual first draw vs. data in LP database

I'll continue updating this list based on info I receive and data that gets updated.  Let's fill in all of that "First Draw of Game" column, so we can figure out what's left to update.  (Scroll down that huge list of games, and then hopefully see why I'm asking for help!)

  • What am I missing?
  • Are any of the dates listed incorrect?
  • Yellow = Known problems
  • Gray = Completed 100%
  • White (uncolored) = need info (please write to lotteries to get start dates for games!)
StateGameFirst Draw
of Game
First Draw in
LP Database
Multi-CountryEuro Millions2/13/20042/13/2004
Multi-ProvinceCanada Lotto 6/496/12/19826/12/1982
Multi-ProvinceCanada Super 76/10/19946/10/1994
Multi-StateWild Card 25/26/19995/26/1999
Multi-State2by26/3/20026/3/2002
Multi-StateTri-State Pick 3 Midday6/29/20036/29/2003
Multi-StateTri-State Pick 311/10/198011/10/1980
Multi-StateTri-State Pick 4 Midday6/29/20036/29/2003
Multi-StateTri-State Pick 49/3/19859/3/1985
Multi-StateTri-State Weekly Grand2/3/20092/3/2009
Multi-StateHot Lotto4/10/20024/10/2002
Multi-StatePowerball4/22/19924/22/1992
Multi-StateMega Millions9/6/19969/6/1996
Multi-StateTri-State Megabucks1/3/19981/3/1998
Multi-StateWin For Life3/1/20063/1/2006
ArizonaPick 35/4/19985/4/1998
ArizonaCash 43/30/20093/30/2009
ArizonaPick 510/4/199110/4/1991
ArizonaThe Pick10/13/198410/13/1984
Atlantic CanadaSalsa Bingo4/1/20084/1/2008
Atlantic CanadaKeno Atlantic12/9/199612/9/1996
Atlantic CanadaPik 46/12/198211/2/1996
Atlantic CanadaBucko2/2/20062/2/2006
Atlantic CanadaAtlantic 6/4911/13/200211/13/2002
Atlantic CanadaTag5/4/198811/2/1996
British ColumbiaExtra8/24/19888/24/1988
British ColumbiaBC/491/29/19921/29/1992
CaliforniaDaily Derby1/20/19981/20/1998
CaliforniaMidday 311/4/200211/4/2002
CaliforniaDaily 34/13/19924/13/1992
CaliforniaDaily 45/19/20085/19/2008
CaliforniaSuperLotto Plus10/18/198610/18/1986
CaliforniaFantasy 52/4/19922/4/1992
ColoradoCash 59/20/19969/20/1996
ColoradoLotto1/28/19891/28/1989
ConnecticutMidday 32/2/19982/2/1998
ConnecticutPlay 33/17/19773/17/1977
ConnecticutMidday 42/2/19982/2/1998
ConnecticutPlay 410/24/198010/24/1980
ConnecticutLucky-4-Life4/2/20094/2/2009
ConnecticutCash 54/11/19924/11/1992
ConnecticutClassic Lotto11/18/198311/18/1983
DelawarePlay 3 Day5/18/19935/18/1993
DelawarePlay 3 Night1/24/19781/24/1978
DelawarePlay 4 Day5/18/19935/18/1993
DelawarePlay 4 Night1/11/19801/11/1980
DelawareMulti-Win Lotto1/28/20051/28/2005
FloridaCash 3 Midday5/19/20085/19/2008
FloridaCash 3 Evening4/29/19884/29/1988
FloridaPlay 4 Midday5/19/20085/19/2008
FloridaMega Money2/25/19982/25/1998
FloridaPlay 4 Evening7/4/19917/4/1991
FloridaFantasy 55/2/19895/2/1989
FloridaLotto5/7/19885/7/1988
GeorgiaCash 3 Midday1/12/19981/12/1998
GeorgiaCash 3 Evening8/10/19938/10/1993
GeorgiaCash 4 Midday2/5/20012/5/2001
GeorgiaCash 4 Evening4/6/19974/6/1997
GeorgiaFantasy 511/18/199411/18/1994
IdahoPick 36/8/20006/8/2000
IdahoDouble Play Draw 15/3/20095/3/2009
IdahoDouble Play Draw 25/3/20095/3/2009
IllinoisMidday 312/20/199312/20/1993
IllinoisDaily 32/19/19802/19/1980
IllinoisMidday 412/20/199312/20/1993
IllinoisDaily 42/16/19822/16/1982
IllinoisLittle Lotto6/1/19886/1/1988
IllinoisLotto5/26/19845/26/1984
IndianaQuick Draw3/1/20093/1/2009
IndianaDaily 3 Midday8/20/20018/20/2001
IndianaDaily 3 Evening7/2/19907/2/1990
IndianaDaily 4 Midday8/20/20018/20/2001
IndianaDaily 4 Evening7/2/19907/2/1990
IndianaLucky 5 Midday10/7/200210/7/2002
IndianaLucky 5 Evening11/5/199311/5/1993
IndianaMix and Match5/26/20065/26/2006
IndianaLotto9/24/19949/24/1994
IowaMidday 39/22/20039/22/2003
IowaPick 37/13/19987/13/1998
IowaMidday 49/22/20039/22/2003
IowaPick 49/21/20039/21/2003
IowaCash Game1/27/19921/27/1992
Ireland (Irish)Plus6/15/20076/15/2007
Ireland (Irish)Lotto9/24/19949/24/1994
Ireland (Irish)Lotto Plus 110/28/200010/28/2000
Ireland (Irish)Lotto Plus 29/4/20029/4/2002
Ireland (Irish)Monday Million9/29/20089/29/2008
KansasPick 31/21/199210/1/2000
KansasSuper Kansas Cash8/18/19962/18/2002
KentuckyPick 3 Midday3/15/19993/15/1999
KentuckyPick 3 Evening11/20/198911/20/1989
KentuckyPick 4 Midday3/15/19993/15/1999
KentuckyPick 4 Evening4/4/19944/4/1994
KentuckyCashball3/6/20013/6/2001
Kentucky3 Line Lotto4/17/20074/17/2007
LouisianaPick 38/31/19928/31/1992
LouisianaPick 43/1/19993/1/1999
LouisianaEasy 59/19/20079/19/2007
LouisianaLotto2/1/19922/1/1992
MarylandMidday Pick 35/1/19955/1/1995
MarylandPick 37/29/19767/29/1976
MarylandMidday Pick 45/1/19955/1/1995
MarylandPick 44/8/19834/8/1983
MarylandBonus Match 510/10/19919/17/1995
MarylandMulti-Match2/4/20062/4/2006
MassachusettsNumbers Midday6/9/20086/9/2008
MassachusettsNumbers Evening4/10/19764/10/1976
MassachusettsMass Cash3/28/19913/28/1991
MassachusettsMegabucks Doubler11/27/198211/27/1982
MassachusettsCash Winfall9/13/20049/13/2004
MichiganKeno4/9/19904/9/1990
MichiganMidday 312/16/199612/16/1996
MichiganDaily 36/6/19776/6/1977
MichiganMidday 412/16/199612/16/1996
MichiganDaily 410/5/19819/1/1984
MichiganFantasy 59/12/20049/12/2004
MichiganClassic Lotto 475/18/20055/18/2005
MinnesotaDaily 38/14/19908/14/1990
MinnesotaNorthstar Cash10/7/200310/7/2003
MinnesotaGopher 55/24/19915/24/1991
MissouriMidday Pick 37/26/20047/26/2004
MissouriPick 32/26/19871/1/1997
MissouriMidday Pick 47/26/20047/26/2004
MissouriPick 411/2/199811/2/1998
MissouriShow Me Cash9/8/20089/8/2008
MissouriLotto10/1/19861/1/1997
MontanaMontana Cash5/11/19911/4/1995
NebraskaPick 35/23/20055/23/2005
NebraskaPick 54/26/19954/26/1995
NebraskaMyDaY10/1/200810/1/2008
New JerseyMidday Pick 311/12/200111/12/2001
New JerseyPick 35/22/19755/22/1975
New JerseyMidday Pick 411/12/200111/12/2001
New JerseyPick 49/1/19779/1/1977
New JerseyJersey Cash 510/7/199210/7/1992
New JerseyPick 65/15/19805/15/1980
New MexicoPick 39/25/20009/25/2000
New MexicoRoad Runner Cash2/10/19981/1/1999
New YorkPick 101/12/19871/12/1987
New YorkMidday Numbers12/2/200112/2/2001
New YorkNumbers9/2/19809/2/1980
New YorkMidday Win 412/2/200112/2/2001
New YorkWin 47/21/19817/21/1981
New YorkTake 51/17/19921/17/1992
New YorkLotto11/11/197811/11/1978
North CarolinaPick 3 Midday3/31/20083/31/2008
North CarolinaPick 310/6/200610/6/2006
North CarolinaPick 44/17/20094/17/2009
North CarolinaCash 510/27/200610/27/2006
OhioTen-OH Midday8/6/20078/6/2007
OhioTen-OH Evening8/6/20078/6/2007
OhioPick 3 Midday8/16/19998/16/1999
OhioPick 3 Evening12/3/197912/3/1979
OhioPick 4 Midday8/16/19998/16/1999
OhioPick 4 Evening4/9/19814/9/1981
OhioRolling Cash 510/4/200410/4/2004
OhioClassic Lotto1/22/20071/22/2007
OklahomaPick 311/10/200511/10/2005
OklahomaCash 59/5/20069/5/2006
OntarioDaily Keno 4/30/1996
OntarioPick 31/16/19896/3/1992
OntarioEarly Bird 11/2/1996
OntarioPick 42/4/20062/4/2006
OntarioOntario 49 10/1/1997
OntarioLottario 11/2/1996
OntarioEncore10/6/2004 10/6/2004
OregonLucky Lines4/10/20064/10/2006
OregonPick 4 1pm2/11/20022/11/2002
OregonPick 4 4pm2/11/20022/11/2002
OregonPick 4 7pm4/24/20004/24/2000
OregonWin For Life2/19/20012/19/2001
OregonPick 4 10pm2/11/20022/11/2002
OregonMegabucks11/20/19851/1/1997
PennsylvaniaMidday Daily Number2/11/20032/11/2003
PennsylvaniaDaily Number3/1/19773/1/1977
PennsylvaniaMidday Big 42/11/20032/11/2003
PennsylvaniaBig 411/22/198011/22/1980
PennsylvaniaTreasure Hunt5/8/20075/8/2007
PennsylvaniaQuinto Midday8/26/20088/26/2008
PennsylvaniaQuinto Evening8/26/20088/26/2008
PennsylvaniaMix and Match1/25/20071/25/2007
PennsylvaniaCash 54/23/19924/23/1992
PennsylvaniaSuper73/13/20093/13/2009
Puerto RicoLotería Tradicional 12/28/2007
Puerto RicoPega 27/10/20027/10/2002
Puerto RicoPega 311/10/199011/10/1990
Puerto RicoPega 47/10/20027/10/2002
Puerto RicoLoto7/19/19917/19/1991
Puerto RicoRevancha9/4/20029/4/2002
QuebecAstro1/9/20061/14/2006
QuebecBanco9/15/198911/12/1996
QuebecLa Quotidienne 39/10/19792/14/1997
QuebecLa Quotidienne 49/10/19792/14/1997
QuebecTango1/16/20091/16/2009
QuebecTriplex9/4/20079/4/2007
QuebecLa Mini6/5/197011/1/1996
QuebecQuebec 4910/1/199710/1/1997
QuebecJour de Paye4/12/20074/12/2007
QuebecExtra 11/1/1996
Rhode IslandNumbers Game 1/1/1998
Rhode IslandWild Money 1/22/2002
South CarolinaMidday 37/1/20037/1/2003
South CarolinaPick 33/7/20023/7/2002
South CarolinaMidday 47/1/20037/1/2003
South CarolinaPick 41/27/20031/27/2003
South CarolinaPalmetto Cash 52/14/20052/14/2005
South CarolinaMegaMatch 62/5/20082/5/2008
South DakotaDakota Cash4/17/19934/17/1993
TennesseeMidday Cash 311/21/200511/21/2005
TennesseeCash 33/1/20043/1/2004
TennesseeMidday Cash 411/21/200511/21/2005
TennesseeCash 44/18/20054/18/2005
TennesseePick 59/1/20049/1/2004
TennesseeLotto Plus3/11/20083/11/2008
TexasPick 3 Day4/29/20024/29/2002
TexasPick 3 Night10/25/199310/25/1993
TexasDaily 4 Day10/1/200710/1/2007
TexasDaily 4 Night10/1/200710/1/2007
TexasTexas Two Step5/18/20015/18/2001
TexasCash 510/13/199510/13/1995
TexasLotto Texas11/14/199211/14/1992
UK NationalLotto HotPicks7/10/20027/10/2002
UK NationalThunderball6/12/19996/12/1999
UK NationalLotto 6/4911/19/199411/19/1994
UK NationalDaily Play9/22/20039/22/2003
UK NationalDream Number7/15/20067/15/2006
VirginiaMidday 31/30/19951/30/1995
VirginiaPick 35/22/19895/22/1989
VirginiaMidday 41/30/19951/30/1995
VirginiaPick 49/30/19919/30/1991
VirginiaMidday Cash 54/12/19994/12/1999
VirginiaCash 52/5/19932/5/1993
WashingtonKeno11/8/199211/8/1992
WashingtonDaily1/18/19841/18/1984
WashingtonMatch 48/3/20088/3/2008
WashingtonHit 53/19/20073/19/2007
WashingtonLotto7/21/19847/21/1984
Washington, D.C.DC-3 Midday11/9/199211/9/1992
Washington, D.C.DC-3 Evening8/22/19838/22/1983
Washington, D.C.DC-4 Midday11/9/199211/9/1992
Washington, D.C.DC-4 Evening3/25/19853/25/1985
Washington, D.C.DC-5 Midday7/19/20097/19/2009
Washington, D.C.DC-5 Evening7/19/20097/19/2009
Washington, D.C.DC Daily 68/28/20058/28/2005
West VirginiaDaily 32/26/19872/26/1987
West VirginiaDaily 42/26/19872/26/1987
West VirginiaCash 252/9/19902/9/1990
Western CanadaPick 39/30/199211/1/1996
Western CanadaPayDay4/5/2007 4/5/2007
Western CanadaWestern 492/10/1999 2/10/1999
Western CanadaExtra 11/1/1996
WisconsinDaily Pick 39/21/19929/21/1992
WisconsinDaily Pick 49/15/19979/15/1997
WisconsinBadger 52/17/20032/17/2003
WisconsinSuper Cash2/4/19912/4/1991
WisconsinMegabucks6/20/19926/20/1992
    Kaptainess's avatar - hiro bird.jpg

    United States
    Member #63356
    July 26, 2008
    1427 Posts
    Offline
    Posted: June 30, 2009, 12:44 am - IP Logged

    HiYa Todd!

    Love to Help, I have data from 1977 for PA Night Drawings - how would I send this load to you?  I mean its a lot of info to email you?  Snail mail?  FED Ex maybe?  LOL!

      Todd's avatar - Cylon 2.gif
      Chief Bottle Washer
      New Jersey
      United States
      Member #1
      May 31, 2000
      21449 Posts
      Online
      Posted: June 30, 2009, 1:12 am - IP Logged

      I actually have all of PA's drawings already loaded.

      That's why the thing I need help with is verifying the drawings that I have loaded in the LP database vs. what the first drawing for the game is.

      If I just get offers of sending me data, then I need to go into the LP past drawing history myself and look to see what's there -- so I'm doing the work anyway.  I'm just looking for a time-saver so I can get this done.  I hope some people can step up.

       

      Check the State Lottery Report Card
      What grade did your lottery earn?

       

      Sign the Petition for True Lottery Drawings
      Help eliminate computerized drawings!

        Amazing Grace's avatar - lion
        rainbow lake
        Canada
        Member #25177
        November 2, 2005
        10684 Posts
        Offline
        Posted: June 30, 2009, 1:13 am - IP Logged

        HiYa Todd!

        Love to Help, I have data from 1977 for PA Night Drawings - how would I send this load to you?  I mean its a lot of info to email you?  Snail mail?  FED Ex maybe?  LOL!

        Western Canada started in 1992 your results go back to 2001 nov 1

        Secret to $uccess=Law of Attraction

          Todd's avatar - Cylon 2.gif
          Chief Bottle Washer
          New Jersey
          United States
          Member #1
          May 31, 2000
          21449 Posts
          Online
          Posted: June 30, 2009, 1:15 am - IP Logged

          Which games are not complete?

           

          Check the State Lottery Report Card
          What grade did your lottery earn?

           

          Sign the Petition for True Lottery Drawings
          Help eliminate computerized drawings!

            Kaptainess's avatar - hiro bird.jpg

            United States
            Member #63356
            July 26, 2008
            1427 Posts
            Offline
            Posted: June 30, 2009, 1:32 am - IP Logged

            Aahhh!!  Duh!!  I get it now - okay - I'm on it!  :-).

              four4me's avatar - gate1
              MD
              United States
              Member #1701
              June 18, 2003
              7826 Posts
              Offline
              Posted: June 30, 2009, 1:38 am - IP Logged

              First drawing

              Maryland 7/29/1976  Pick 3 evening ........ 408

              Big John says. You don't hit the number. The number hits you!!!!

                             I'm not Big John, I'm Four4me, Big John's a friend.
                Bluegrass's avatar - nw archer.jpg
                Louisville, KY
                United States
                Member #57
                December 17, 2001
                5143 Posts
                Offline
                Posted: June 30, 2009, 1:54 am - IP Logged

                KY P-3 Mid     12/01/03     086

                KY P-3 Eve     11/20/89    207

                 

                KY P-4 Mid     3/15/99       7430

                KY P-4 Eve     4/04/94       8951

                 

                     US Flag    Life i$ good !  US Flagbg

                         

                  four4me's avatar - gate1
                  MD
                  United States
                  Member #1701
                  June 18, 2003
                  7826 Posts
                  Offline
                  Posted: June 30, 2009, 2:07 am - IP Logged

                  First drawing

                  Maryland 7/29/1976  Pick 3 evening ........ 408

                  Confirmed lottery post data base

                  Thu, Jul 29, 1976MarylandPick 34-0-8

                  Big John says. You don't hit the number. The number hits you!!!!

                                 I'm not Big John, I'm Four4me, Big John's a friend.
                    SANKORE's avatar - EmpireClear2
                    NYC
                    United States
                    Member #16934
                    June 7, 2005
                    271 Posts
                    Offline
                    Posted: June 30, 2009, 2:24 am - IP Logged

                    Hey Todd,


                    I maintain a list of the entire run of NY States' Pick-3 game.  The start of your list is right on the money. 

                    If I could suggest something for you as you try to confirm your list from around the nation, maybe you could give a number of drawings you have for each game just to see if you missed any entries.  For example in New York State, we are up to about 13,212 drawings for the pick 3 game.  If you missed any drawings, then we could compare numbers.  Or another way to check would be to give a sum total of the value of each drawing then you could see if that value matches up with someone else who has a master list. 

                    It's real easy to transpose a number when entering them into your list.

                      Mickie's avatar - Lottery-008.jpg
                      Spring Lake
                      United States
                      Member #313
                      April 26, 2002
                      181 Posts
                      Offline
                      Posted: June 30, 2009, 5:37 am - IP Logged

                      Hey Todd

                      Michigan:

                      Mid3: 12/16/96

                      Mid4: 12/16/96

                      Eve3: 06/06/77

                      Eve4: 10/05/81

                      Yours is not complete.
                      I have all numbers. Each year I compare Mich website numbers with yours. My list is complete and accurate as I can get it. Can send them to you if you want.

                      Have a good day
                      Mickie

                      MickieDisney

                        Todd's avatar - Cylon 2.gif
                        Chief Bottle Washer
                        New Jersey
                        United States
                        Member #1
                        May 31, 2000
                        21449 Posts
                        Online
                        Posted: June 30, 2009, 7:34 am - IP Logged

                        I appreciate the interest so far.  I think I need to be more specific on exactly what it is I need.

                        If you would like to check out for missing data, I need just the actual date of the first drawing of the game, and the first data in the LP system.  

                        For example:

                        • Western Canada Pick 3, actual first drawing: 12/1/1992    (this is not the real date, just an example!)
                        • Western Canada Pick 3, first draw in LP database: 11/1/2001

                        I don't even need the drawing data, just the fact that the first drawing of the game is different than what is is the system.

                        If you check the game in a state and the LP database has all the drawings for all the games in that state, a quick note like this is fine:

                        • All New Jersey games: 100% complete

                        For the states where I have imported all the data, I have very good data in there, so I'd like to just concentrate on the missing data/states right now.  I really appreciate the offers of data, but it's very important for me to get the data directly from the states themselves, so I can say that it is official.

                        Thank you for your help.

                         

                        Check the State Lottery Report Card
                        What grade did your lottery earn?

                         

                        Sign the Petition for True Lottery Drawings
                        Help eliminate computerized drawings!

                          Todd's avatar - Cylon 2.gif
                          Chief Bottle Washer
                          New Jersey
                          United States
                          Member #1
                          May 31, 2000
                          21449 Posts
                          Online
                          Posted: June 30, 2009, 7:42 am - IP Logged

                          Hey Todd,


                          I maintain a list of the entire run of NY States' Pick-3 game.  The start of your list is right on the money. 

                          If I could suggest something for you as you try to confirm your list from around the nation, maybe you could give a number of drawings you have for each game just to see if you missed any entries.  For example in New York State, we are up to about 13,212 drawings for the pick 3 game.  If you missed any drawings, then we could compare numbers.  Or another way to check would be to give a sum total of the value of each drawing then you could see if that value matches up with someone else who has a master list. 

                          It's real easy to transpose a number when entering them into your list.

                          The number of drawings for each game is displayed at the top of the page when viewiong the past results.  I think you're counting the number of midday and evening games together in your count of 13,212, right?

                          I don't worry too much about transposing because all numbers are imported into my system by computer, never hand-typed.  It ensures that whatever is on the list in entered 100% perfect.

                           

                          Check the State Lottery Report Card
                          What grade did your lottery earn?

                           

                          Sign the Petition for True Lottery Drawings
                          Help eliminate computerized drawings!

                            Mickie's avatar - Lottery-008.jpg
                            Spring Lake
                            United States
                            Member #313
                            April 26, 2002
                            181 Posts
                            Offline
                            Posted: June 30, 2009, 10:21 am - IP Logged

                            Todd, is this what you are looking for?

                             

                            Midday 3:
                            There are 3,931 Michigan Midday 3 drawings since January 1, 1998
                            Not Complete!

                            There are 4,265 Michigan Midday 3 drawings since December 16, 1996

                             

                            Midday 4:
                            There are 3,930 Michigan Midday 4 drawings since January 1, 1998
                            Not Complete!

                            There are 4,265 Michigan Midday 3 drawings since December 16, 1996

                             

                            Evening 3:
                            There are 8,119 Michigan Daily 3 drawings since September 1, 1984
                            Not Complete!

                            There are 10,364 Michigan Evening 3 drawings since June 06, 1977

                             

                            Evening 4:
                            There are 3,931 Michigan Daily 4 drawings since January 1, 1998
                            Not Complete!

                            There are 9,011 Michigan Midday 3 drawings since October 05, 1981

                             

                            Mickie

                            MickieDisney

                              Avatar
                              Atlanta, GA
                              United States
                              Member #1265
                              March 13, 2003
                              3326 Posts
                              Offline
                              Posted: June 30, 2009, 10:26 am - IP Logged

                              Are you also looking for games which have been retired?

                              Good luck to everyone!