View Single Post
  #17  
Old 22nd August 2014, 04:45 PM
Chrome Prince Chrome Prince is offline
Member
 
Join Date: Jan 1970
Posts: 4,425
Lightbulb FAQ

Thought I'd post some answers to questions I frequently get:

The database is built on the Filemaker Pro Advanced platform.
All data is exportable to csv, excel, etc.
The database can be used on multiple computers.
It contains all TAB metropolitan, provincial and country races from 1999.
Dividends are from NSW TAB.
Exports can be fully customised, in that you can pick and choose which fields can be exported. This makes it a lot less intensive and easier to work with data you want.

Here is a full list of the fields contained in the database, along with explanations, each of these fields can be queried (apart from the summary fields of course:

<pre>
Field Name Field Type Further Explanation
2nd Last Run 400m Number Position at 400m
2nd Last Run 800m Number Position at 800m
2nd Last Run Age Text Race Age Restriction
2nd Last Run All Number Apprentice Allowance
2nd Last Run BP Number Barrier
2nd Last Run Class Text
2nd Last Run Date Date
2nd Last Run Distance Number
2nd Last Run Event Text
2nd Last Run Going Text Track Condition
2nd Last Run Jockey Text
2nd Last Run Last 600m Number Sectional Time
2nd Last Run Limit Number
2nd Last Run Margin Number
2nd Last Run Placing Number
2nd Last Run Prizemoney Number
2nd Last Run Prizemoney Won Number
2nd Last Run Rest Text Race Sex Restriction
2nd Last Run SP Number
2nd Last Run Starters Number
2nd Last Run Time Number Race Time
2nd Last Run Track Surface Text
2nd Last Run Venue Text
2nd Last Run Wgt Number Weight
2nd Last Run Winner Text Winner or second
3rd Last Run 400m Number Position at 400m
3rd Last Run 800m Number Position at 800m
3rd Last Run Age Text Race Age Restriction
3rd Last Run All Number Apprentice Allowance
3rd Last Run BP Number Barrier
3rd Last Run Class Text
3rd Last Run Date Date
3rd Last Run Distance Number
3rd Last Run Event Text
3rd Last Run Going Text Track Condition
3rd Last Run Jockey Text
3rd Last Run Last 600m Number Sectional Time
3rd Last Run Limit Number
3rd Last Run Margin Number
3rd Last Run Placing Number
3rd Last Run Prizemoney Number
3rd Last Run Prizemoney Won Number
3rd Last Run Rest Text Race Sex Restriction
3rd Last Run SP Number
3rd Last Run Starters Number
3rd Last Run Time Number Race Time
3rd Last Run Track Surface Text
3rd Last Run Venue Text
3rd Last Run Wgt Number Weight
3rd Last Run Winner Text Winner or second
4th Last Run 400m Number Position at 400m
4th Last Run 800m Number Position at 800m
4th Last Run Age Text Race Age Restriction
4th Last Run All Number Apprentice Allowance
4th Last Run BP Number Barrier
4th Last Run Class Text
4th Last Run Date Date
4th Last Run Distance Number
4th Last Run Event Text
4th Last Run Going Text Track Condition
4th Last Run Jockey Text
4th Last Run Last 600m Number Sectional Time
4th Last Run Limit Number
4th Last Run Margin Number
4th Last Run Placing Number
4th Last Run Prizemoney Number
4th Last Run Prizemoney Won Number
4th Last Run Rest Text Race Sex Restriction
4th Last Run SP Number
4th Last Run Starters Number
4th Last Run Time Number Race Time
4th Last Run Track Surface Text
4th Last Run Venue Text
4th Last Run Wgt Number Weight
4th Last Run Winner Text Winner or second
5th Last Run 400m Number Position at 400m
5th Last Run 800m Number Position at 800m
5th Last Run Age Text Race Age Restriction
5th Last Run All Number Apprentice Allowance
5th Last Run BP Number Barrier
5th Last Run Class Text
5th Last Run Date Date
5th Last Run Distance Number
5th Last Run Event Text
5th Last Run Going Text Track Condition
5th Last Run Jockey Text
5th Last Run Last 600m Number Sectional Time
5th Last Run Limit Number
5th Last Run Margin Number
5th Last Run Placing Number
5th Last Run Prizemoney Number
5th Last Run Prizemoney Won Number
5th Last Run Rest Text Race Sex Restriction
5th Last Run SP Number
5th Last Run Starters Number
5th Last Run Time Number Race Time
5th Last Run Track Surface Text
5th Last Run Venue Text
5th Last Run Wgt Number Weight
5th Last Run Winner Text Winner or second
Age Number
Age Restriction Text Race Age Restriction
Api Number Average Prizemoney
Api Rank Number Average Prizemoney Rank
Apprentice Text Y/N
Apprentice Claim Text Race Claiming Restrictions Y/N
Barrier Number
Career 2nds Number
Career 3rds Number
Career Place Percentage Number
Career Place Percentage Rank Number
Career Prizemoney Number
Career Prizemoney Rank Number
Career Starts Number
Career Win Percentage Number
Career Win Percentage Rank Number
Career Wins Number
Closing Price Number TAB Price
Closing Price Rank Number
Colour Text
Date Date
Day Text Day Of Week
Days Break Number Days Break Since Last Start
Days2 Number Days Break Since 2nd Last Start
Days3 Number Days Break Since 3rd Last Start
Days4 Number Days Break Since 4th Last Start
Days5 Number Days Break Since 5th Last Start
Dead 2nds Number
Dead 3rds Number
Dead Place Percentage Number
Dead Starts Number
Dead Win Percentage Number
Dead Wins Number
Distance 2nds Number
Distance 3rds Number
Distance Place Percentage Number
Distance Place Percentage Rank Number
Distance Starts Number
Distance Variation Number
Distance Win Percentage Number
Distance Win Percentage Rank Number
Distance Wins Number
Fast 2nds Number
Fast 3rds Number
Fast Place Percentage Number
Fast Starts Number
Fast Win Percentage Number
Fast Wins Number
Favourite Premium Number Second Favourite TAB price minus Favourite TAB price
First Up 2nds Number
First Up 3rds Number
First Up Place Percentage Number
First Up Place Percentage Rank Number
First Up Starts Number
First Up Win Percentage Number
First Up Win Percentage Rank Number
First Up Wins Number
Going Text Track Condition
Good 2nds Number
Good 3rds Number
Good Place Percentage Number
Good Starts Number
Good Win Percentage Number
Good Wins Number
Handicapping Text Handicap, Weight For Age, Set Weights etc.
Heavy 2nds Number
Heavy 3rds Number
Heavy Place Percentage Number
Heavy Starts Number
Heavy Win Percentage Number
Heavy Wins Number
Horse Text
Jockey Text
Last Run 400m Number Position at 400m
Last Run 800m Number Position at 800m
Last Run Age Text Race Age Restriction
Last Run All Number Apprentice Allowance
Last Run BP Number Barrier
Last Run Class Text
Last Run Date Date
Last Run Distance Number
Last Run Event Text
Last Run Going Text Track Condition
Last Run Jockey Text
Last Run Last 600m Number Sectional Time
Last Run Limit Number
Last Run Margin Number
Last Run Metro Track Text
Last Run Placing Number
Last Run Prizemoney Number
Last Run Prizemoney Won Number
Last Run Rest Text Race Sex Restriction
Last Run SP Number
Last Run Starters Number
Last Run Time Number Race Time
Last Run Track Surface Text
Last Run Venue Text
Last Run Wgt Number Weight
Last Run Winner Text Winner or second
Place Number Place TAB Dividend
Place Average Dividend Summary
Place Count Summary
Place Maximum Dividend Summary
Place Minimum Dividend Summary
Place POT Summary
Place Profit Summary
Place Return Summary
Place Strike Rate Summary
Place System Viability Summary
Prizemoney Variation Number Increase or Decrease in Race Prizemoney from Last Start
Pwls Rank Number Prizemoney Won Last Start Rank
Pwlts Number Prizemoney Won Last Three Starts
Pwlts Rank Number Prizemoney Won Last Three Starts Rank
Race Number
Race Class Text
Race Distance Number
Race Name Text
Race Prizemoney Number
Runners Number
Runs Since Spell Number
Same Going Text
Same Track Text
Selections Summary
Settled1 Number Last Start Settling Position
Settled2 Number Second Last Start Settling Position
Settled3 Number Third Last Start Settling Position
Settled4 Number Fourth Last Start Settling Position
Settled5 Number Fifth Last Start Settling Position
Sex Text
Sex Restriction Text Race Sex Restriction
Slow 2nds Number
Slow 3rds Number
Slow Place Percentage Number
Slow Starts Number
Slow Win Percentage Number
Slow Wins Number
State Text VIC, NSW, QLD, WA etc.
Tab Number
Track Text
Track 2nds Number
Track 3rds Number
Track Class Text Metro or Country
Track Place Percentage Number
Track Place Percentage Rank Number
Track Starts Number
Track Surface Text Turf, Dirt, All Weather
Track Win Percentage Number
Track Win Percentage Rank Number
Track Wins Number
Trainer Text
Weight Number
Weight Limit Number Race Weight Limit
Weight Ratio Number Topweight weight minus Second Topweight weight
Weight Variation Number Increase or Decrease in Weight from previous start
Win Number TAB Win Dividend
Win Average Dividend Summary
Win Count Summary
Win Maximum Dividend Summary
Win Minimum Dividend Summary
Win POT Summary Profit On Turnover
Win Profit Summary
Win Return Summary
Win Strike Rate Summary
Win System Viability Summary Profit or Loss Divided by Maximum Win Dividend
</pre>
__________________
RaceCensus - powerful system testing software.
Now with over 409,000 Metropolitan, Provincial and Country races!
http://www.propun.com.au/horse_raci...ng_systems.html
*RaceCensus now updated to 31/10/2024
Video overview of RaceCensus here:
http://www.youtube.com/watch?v=W821YP_b0Pg
Reply With Quote