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!)

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!

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.

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

Which games are not complete?

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

First drawing

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

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

Confirmed lottery post data base

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.

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

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.

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.

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

Are you also looking for games which have been retired?