Inspired by the Vega implementation of NYT Amanda Cox's Budget Forecast.
| budgetYear | forecastYear | actual | forecast | value | type | |
|---|---|---|---|---|---|---|
| 1990 | 1990 | 1437937 | 93804 | actual | ||
| 1990 | 1990 | 1437937 | 1431140 | -6797 | forecast | |
| 1990 | 1991 | 1521951 | 1506100 | -15851 | forecast | |
| 1990 | 1992 | 1671557 | 1588540 | -83017 | forecast | |
| 1990 | 1993 | 1754912 | 1675180 | -79732 | forecast | |
| 1990 | 1994 | 1830726 | 1764740 | -65986 | forecast | |
| 1990 | 1995 | 1954810 | 1859840 | -94970 | forecast | |
| 1990 | 1996 | 2070688 | 1960710 | -109978 | forecast | |
| 1991 | 1991 | 1521951 | 84014 | actual | ||
| 1991 | 1991 | 1521951 | 1527515 | 5564 | forecast | |
| 1991 | 1992 | 1671557 | 1631295 | -40262 | forecast | |
| 1991 | 1993 | 1754912 | 1707855 | -47057 | forecast | |
| 1991 | 1994 | 1830726 | 1788255 | -42471 | forecast | |
| 1991 | 1995 | 1954810 | 1872045 | -82765 | forecast | |
| 1991 | 1996 | 2070688 | 1961115 | -109573 | forecast | |
| 1991 | 1997 | 2172571 | 2053745 | -118826 | forecast | |
| 1992 | 1992 | 1671557 | 149606 | actual | ||
| 1992 | 1992 | 1671557 | 1621220 | -50337 | forecast | |
| 1992 | 1993 | 1754912 | 1703830 | -51082 | forecast | |
| 1992 | 1994 | 1830726 | 1790720 | -40006 | forecast | |
| 1992 | 1995 | 1954810 | 1882070 | -72740 | forecast | |
| 1992 | 1996 | 2070688 | 1969830 | -100858 | forecast | |
| 1992 | 1997 | 2172571 | 2062010 | -110561 | forecast | |
| 1992 | 1998 | 2354379 | 2159680 | -194699 | forecast | |
| 1993 | 1993 | 1754912 | 83355 | actual | ||
| 1993 | 1993 | 1754912 | 1760870 | 5958 | forecast | |
| 1993 | 1994 | 1830726 | 1841980 | 11254 | forecast | |
| 1993 | 1995 | 1954810 | 1928660 | -26150 | forecast | |
| 1993 | 1996 | 2070688 | 2019520 | -51168 | forecast | |
| 1993 | 1997 | 2172571 | 2115010 | -57561 | forecast | |
| 1993 | 1998 | 2354379 | 2216510 | -137869 | forecast | |
| 1993 | 1999 | 2479025 | 2322460 | -156565 | forecast | |
| 1994 | 1994 | 1830726 | 75814 | actual | ||
| 1994 | 1994 | 1830726 | 1829605 | -1121 | forecast | |
| 1994 | 1995 | 1954810 | 1906715 | -48095 | forecast | |
| 1994 | 1996 | 2070688 | 1983415 | -87273 | forecast | |
| 1994 | 1997 | 2172571 | 2064925 | -107646 | forecast | |
| 1994 | 1998 | 2354379 | 2152285 | -202094 | forecast | |
| 1994 | 1999 | 2479025 | 2243525 | -235500 | forecast | |
| 1994 | 2000 | 2628678 | 2340155 | -288523 | forecast | |
| 1995 | 1995 | 1954810 | 124084 | actual | ||
| 1995 | 1995 | 1954810 | 1919920 | -34890 | forecast | |
| 1995 | 1996 | 2070688 | 2004710 | -65978 | forecast | |
| 1995 | 1997 | 2172571 | 2096100 | -76471 | forecast | |
| 1995 | 1998 | 2354379 | 2191670 | -162709 | forecast | |
| 1995 | 1999 | 2479025 | 2293100 | -185925 | forecast | |
| 1995 | 2000 | 2628678 | 2399770 | -228908 | forecast | |
| 1995 | 2001 | 2541125 | 2499950 | -41175 | forecast | |
| 1996 | 1996 | 2070688 | 115878 | actual | ||
| 1996 | 1996 | 2070688 | 2043880 | -26808 | forecast | |
| 1996 | 1997 | 2172571 | 2134840 | -37731 | forecast | |
| 1996 | 1998 | 2354379 | 2226300 | -128079 | forecast | |
| 1996 | 1999 | 2479025 | 2324160 | -154865 | forecast | |
| 1996 | 2000 | 2628678 | 2428410 | -200268 | forecast | |
| 1996 | 2001 | 2541125 | 2512960 | -28165 | forecast | |
| 1996 | 2002 | 2474730 | 2602900 | 128170 | forecast | |
| 1997 | 1997 | 2172571 | 101883 | actual | ||
| 1997 | 1997 | 2172571 | 2193445 | 20874 | forecast | |
| 1997 | 1998 | 2354379 | 2313755 | -40624 | forecast | |
| 1997 | 1999 | 2479025 | 2442075 | -36950 | forecast | |
| 1997 | 2000 | 2628678 | 2576545 | -52133 | forecast | |
| 1997 | 2001 | 2541125 | 2688735 | 147610 | forecast | |
| 1997 | 2002 | 2474730 | 2804495 | 329765 | forecast | |
| 1997 | 2003 | 2547057 | 2922295 | 375238 | forecast | |
| 1998 | 1998 | 2354379 | 181808 | actual | ||
| 1998 | 1998 | 2354379 | 2279220 | -75159 | forecast | |
| 1998 | 1999 | 2479025 | 2384320 | -94705 | forecast | |
| 1998 | 2000 | 2628678 | 2498560 | -130118 | forecast | |
| 1998 | 2001 | 2541125 | 2622690 | 81565 | forecast | |
| 1998 | 2002 | 2474730 | 2757800 | 283070 | forecast | |
| 1998 | 2003 | 2547057 | 2905300 | 358243 | forecast | |
| 1998 | 2004 | 2711843 | 3066090 | 354247 | forecast | |
| 1999 | 1999 | 2479025 | 124646 | actual | ||
| 1999 | 1999 | 2479025 | 2477805 | -1220 | forecast | |
| 1999 | 2000 | 2628678 | 2621575 | -7103 | forecast | |
| 1999 | 2001 | 2541125 | 2790875 | 249750 | forecast | |
| 1999 | 2002 | 2474730 | 2939015 | 464285 | forecast | |
| 1999 | 2003 | 2547057 | 3082135 | 535078 | forecast | |
| 1999 | 2004 | 2711843 | 3233855 | 522012 | forecast | |
| 1999 | 2005 | 2851707 | 3363345 | 511638 | forecast | |
| 2000 | 2000 | 2628678 | 149653 | actual | ||
| 2000 | 2000 | 2628678 | 2651200 | 22522 | forecast | |
| 2000 | 2001 | 2541125 | 2807510 | 266385 | forecast | |
| 2000 | 2002 | 2474730 | 2977040 | 502310 | forecast | |
| 2000 | 2003 | 2547057 | 3149890 | 602833 | forecast | |
| 2000 | 2004 | 2711843 | 3315860 | 604017 | forecast | |
| 2000 | 2005 | 2851707 | 3467780 | 616073 | forecast | |
| 2000 | 2006 | 2971116 | 3584890 | 613774 | forecast | |
| 2001 | 2001 | 2541125 | -38246 | actual | ||
| 2001 | 2001 | 2541125 | 2646535 | 105410 | forecast | |
| 2001 | 2002 | 2474730 | 2756845 | 282115 | forecast | |
| 2001 | 2003 | 2547057 | 2888555 | 341498 | forecast | |
| 2001 | 2004 | 2711843 | 3005705 | 293862 | forecast | |
| 2001 | 2005 | 2851707 | 3125895 | 274188 | forecast | |
| 2001 | 2006 | 2971116 | 3244075 | 272959 | forecast | |
| 2001 | 2007 | 3107628 | 3360095 | 252467 | forecast | |
| 2002 | 2002 | 2474730 | -66395 | actual | ||
| 2002 | 2002 | 2474730 | 2527850 | 53120 | forecast | |
| 2002 | 2003 | 2547057 | 2638832 | 91775 | forecast | |
| 2002 | 2004 | 2711843 | 2759556 | 47713 | forecast | |
| 2002 | 2005 | 2851707 | 2846473 | -5234 | forecast | |
| 2002 | 2006 | 2971116 | 2936938 | -34178 | forecast | |
| 2002 | 2007 | 3107628 | 3036513 | -71115 | forecast | |
| 2002 | 2008 | 3150924 | 3142342 | -8582 | forecast | |
| 2003 | 2003 | 2547057 | 72327 | actual | ||
| 2003 | 2003 | 2547057 | 2524482 | -22575 | forecast | |
| 2003 | 2004 | 2711843 | 2628226 | -83617 | forecast | |
| 2003 | 2005 | 2851707 | 2728010 | -123697 | forecast | |
| 2003 | 2006 | 2971116 | 2842681 | -128435 | forecast | |
| 2003 | 2007 | 3107628 | 2943541 | -164087 | forecast | |
| 2003 | 2008 | 3150924 | 3055257 | -95667 | forecast | |
| 2003 | 2009 | 2930100 | 3166835 | 236735 | forecast | |
| 2004 | 2004 | 2711843 | 158441 | actual | ||
| 2004 | 2004 | 2711843 | 2622999 | -88844 | forecast | |
| 2004 | 2005 | 2851707 | 2705527 | -146180 | forecast | |
| 2004 | 2006 | 2971116 | 2773303 | -197813 | forecast | |
| 2004 | 2007 | 3107628 | 2867270 | -240358 | forecast | |
| 2004 | 2008 | 3150924 | 2950322 | -200602 | forecast | |
| 2004 | 2009 | 2930100 | 3029369 | 99269 | forecast | |
| 2004 | 2010 | 2980761 | 3119204 | 138443 | forecast | |
| 2005 | 2005 | 2851707 | 139864 | actual | ||
| 2005 | 2005 | 2851707 | 2833171 | -18536 | forecast | |
| 2005 | 2006 | 2971116 | 2929890 | -41226 | forecast | |
| 2005 | 2007 | 3107628 | 3013753 | -93875 | forecast | |
| 2005 | 2008 | 3150924 | 3092996 | -57928 | forecast | |
| 2005 | 2009 | 2930100 | 3168364 | 238264 | forecast | |
| 2005 | 2010 | 2980761 | 3292190 | 311429 | forecast | |
| 2005 | 2011 | 3077567 | 3394422 | 316855 | forecast | |
| 2006 | 2006 | 2971116 | 119409 | actual | ||
| 2006 | 2006 | 2971116 | 2950557 | -20559 | forecast | |
| 2006 | 2007 | 3107628 | 3045884 | -61744 | forecast | |
| 2006 | 2008 | 3150924 | 3129785 | -21139 | forecast | |
| 2006 | 2009 | 2930100 | 3230948 | 300848 | forecast | |
| 2006 | 2010 | 2980761 | 3353712 | 372951 | forecast | |
| 2006 | 2011 | 3077567 | 3456617 | 379050 | forecast | |
| 2006 | 2012 | 3017636 | 3562090 | 544454 | forecast | |
| 2007 | 2007 | 3107628 | 136512 | actual | ||
| 2007 | 2007 | 3107628 | 3077218 | -30410 | forecast | |
| 2007 | 2008 | 3150924 | 3181335 | 30411 | forecast | |
| 2007 | 2009 | 2930100 | 3283437 | 353337 | forecast | |
| 2007 | 2010 | 2980761 | 3377868 | 397107 | forecast | |
| 2007 | 2011 | 3077567 | 3515435 | 437868 | forecast | |
| 2007 | 2012 | 3017636 | 3628142 | 610506 | forecast | |
| 2007 | 2013 | 2990043 | 3739529 | 749486 | forecast | |
| 2008 | 2008 | 3150924 | 43296 | actual | ||
| 2008 | 2008 | 3150924 | 3227284 | 76360 | forecast | |
| 2008 | 2009 | 2930100 | 3360937 | 430837 | forecast | |
| 2008 | 2010 | 2980761 | 3480588 | 499827 | forecast | |
| 2008 | 2011 | 3077567 | 3587958 | 510391 | forecast | |
| 2008 | 2012 | 3017636 | 3750415 | 732779 | forecast | |
| 2008 | 2013 | 2990043 | 3864513 | 874470 | forecast | |
| 2008 | 2014 | 3030019 | 3977226 | 947207 | forecast | |
| 2009 | 2009 | 2930100 | -220824 | actual | ||
| 2009 | 2009 | 2930100 | 2994009 | 63909 | forecast | |
| 2009 | 2010 | 2980761 | 3044531 | 63770 | forecast | |
| 2009 | 2011 | 3077567 | 3149288 | 71721 | forecast | |
| 2009 | 2012 | 3017636 | 3281071 | 263435 | forecast | |
| 2009 | 2013 | 2990043 | 3381186 | 391143 | forecast | |
| 2009 | 2014 | 3030019 | 3493749 | 463730 | forecast | |
| 2009 | 2015 | 3080476 | 3604966 | 524490 | forecast | |
| 2010 | 2010 | 2980761 | 50661 | actual | ||
| 2010 | 2010 | 2980761 | 2961934 | -18827 | forecast | |
| 2010 | 2011 | 3077567 | 3059759 | -17808 | forecast | |
| 2010 | 2012 | 3017636 | 3165885 | 148249 | forecast | |
| 2010 | 2013 | 2990043 | 3256675 | 266632 | forecast | |
| 2010 | 2014 | 3030019 | 3356861 | 326842 | forecast | |
| 2010 | 2015 | 3080476 | 3454204 | 373728 | forecast | |
| 2011 | 2011 | 3077567 | 96806 | actual | ||
| 2011 | 2011 | 3077567 | 3124057 | 46490 | forecast | |
| 2011 | 2012 | 3017636 | 3240186 | 222550 | forecast | |
| 2011 | 2013 | 2990043 | 3313221 | 323178 | forecast | |
| 2011 | 2014 | 3030019 | 3397430 | 367411 | forecast | |
| 2011 | 2015 | 3080476 | 3481246 | 400770 | forecast | |
| 2012 | 2012 | 3017636 | -59931 | actual | ||
| 2012 | 2012 | 3017636 | 3041017 | 23381 | forecast | |
| 2012 | 2013 | 2990043 | 3081990 | 91947 | forecast | |
| 2012 | 2014 | 3030019 | 3167441 | 137422 | forecast | |
| 2012 | 2015 | 3080476 | 3255219 | 174743 | forecast | |
| 2013 | 2013 | 2990043 | -27593 | actual | ||
| 2013 | 2013 | 2990043 | 2965471 | -24572 | forecast | |
| 2013 | 2014 | 3030019 | 3050685 | 20666 | forecast | |
| 2013 | 2015 | 3080476 | 3135541 | 55065 | forecast | |
| 2014 | 2014 | 3030019 | 39976 | actual | ||
| 2014 | 2014 | 3030019 | 2988686 | -41333 | forecast | |
| 2014 | 2015 | 3080476 | 3056360 | -24116 | forecast | |
| 2015 | 2015 | 3080476 | 50457 | actual | ||
| 2015 | 2015 | 3080476 | 3058723 | -21753 | forecast |
| [ | |
| { | |
| "budgetYear": 1990, | |
| "forecastYear": 1990, | |
| "actual": 1437937, | |
| "forecast": "", | |
| "value": 93804, | |
| "type": "actual" | |
| }, | |
| { | |
| "budgetYear": 1990, | |
| "forecastYear": 1990, | |
| "actual": 1437937, | |
| "forecast": 1431140, | |
| "value": -6797, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1990, | |
| "forecastYear": 1991, | |
| "actual": 1521951, | |
| "forecast": 1506100, | |
| "value": -15851, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1990, | |
| "forecastYear": 1992, | |
| "actual": 1671557, | |
| "forecast": 1588540, | |
| "value": -83017, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1990, | |
| "forecastYear": 1993, | |
| "actual": 1754912, | |
| "forecast": 1675180, | |
| "value": -79732, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1990, | |
| "forecastYear": 1994, | |
| "actual": 1830726, | |
| "forecast": 1764740, | |
| "value": -65986, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1990, | |
| "forecastYear": 1995, | |
| "actual": 1954810, | |
| "forecast": 1859840, | |
| "value": -94970, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1990, | |
| "forecastYear": 1996, | |
| "actual": 2070688, | |
| "forecast": 1960710, | |
| "value": -109978, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1991, | |
| "forecastYear": 1991, | |
| "actual": 1521951, | |
| "forecast": "", | |
| "value": 84014, | |
| "type": "actual" | |
| }, | |
| { | |
| "budgetYear": 1991, | |
| "forecastYear": 1991, | |
| "actual": 1521951, | |
| "forecast": 1527515, | |
| "value": 5564, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1991, | |
| "forecastYear": 1992, | |
| "actual": 1671557, | |
| "forecast": 1631295, | |
| "value": -40262, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1991, | |
| "forecastYear": 1993, | |
| "actual": 1754912, | |
| "forecast": 1707855, | |
| "value": -47057, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1991, | |
| "forecastYear": 1994, | |
| "actual": 1830726, | |
| "forecast": 1788255, | |
| "value": -42471, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1991, | |
| "forecastYear": 1995, | |
| "actual": 1954810, | |
| "forecast": 1872045, | |
| "value": -82765, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1991, | |
| "forecastYear": 1996, | |
| "actual": 2070688, | |
| "forecast": 1961115, | |
| "value": -109573, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1991, | |
| "forecastYear": 1997, | |
| "actual": 2172571, | |
| "forecast": 2053745, | |
| "value": -118826, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1992, | |
| "forecastYear": 1992, | |
| "actual": 1671557, | |
| "forecast": "", | |
| "value": 149606, | |
| "type": "actual" | |
| }, | |
| { | |
| "budgetYear": 1992, | |
| "forecastYear": 1992, | |
| "actual": 1671557, | |
| "forecast": 1621220, | |
| "value": -50337, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1992, | |
| "forecastYear": 1993, | |
| "actual": 1754912, | |
| "forecast": 1703830, | |
| "value": -51082, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1992, | |
| "forecastYear": 1994, | |
| "actual": 1830726, | |
| "forecast": 1790720, | |
| "value": -40006, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1992, | |
| "forecastYear": 1995, | |
| "actual": 1954810, | |
| "forecast": 1882070, | |
| "value": -72740, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1992, | |
| "forecastYear": 1996, | |
| "actual": 2070688, | |
| "forecast": 1969830, | |
| "value": -100858, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1992, | |
| "forecastYear": 1997, | |
| "actual": 2172571, | |
| "forecast": 2062010, | |
| "value": -110561, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1992, | |
| "forecastYear": 1998, | |
| "actual": 2354379, | |
| "forecast": 2159680, | |
| "value": -194699, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1993, | |
| "forecastYear": 1993, | |
| "actual": 1754912, | |
| "forecast": "", | |
| "value": 83355, | |
| "type": "actual" | |
| }, | |
| { | |
| "budgetYear": 1993, | |
| "forecastYear": 1993, | |
| "actual": 1754912, | |
| "forecast": 1760870, | |
| "value": 5958, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1993, | |
| "forecastYear": 1994, | |
| "actual": 1830726, | |
| "forecast": 1841980, | |
| "value": 11254, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1993, | |
| "forecastYear": 1995, | |
| "actual": 1954810, | |
| "forecast": 1928660, | |
| "value": -26150, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1993, | |
| "forecastYear": 1996, | |
| "actual": 2070688, | |
| "forecast": 2019520, | |
| "value": -51168, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1993, | |
| "forecastYear": 1997, | |
| "actual": 2172571, | |
| "forecast": 2115010, | |
| "value": -57561, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1993, | |
| "forecastYear": 1998, | |
| "actual": 2354379, | |
| "forecast": 2216510, | |
| "value": -137869, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1993, | |
| "forecastYear": 1999, | |
| "actual": 2479025, | |
| "forecast": 2322460, | |
| "value": -156565, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1994, | |
| "forecastYear": 1994, | |
| "actual": 1830726, | |
| "forecast": "", | |
| "value": 75814, | |
| "type": "actual" | |
| }, | |
| { | |
| "budgetYear": 1994, | |
| "forecastYear": 1994, | |
| "actual": 1830726, | |
| "forecast": 1829605, | |
| "value": -1121, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1994, | |
| "forecastYear": 1995, | |
| "actual": 1954810, | |
| "forecast": 1906715, | |
| "value": -48095, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1994, | |
| "forecastYear": 1996, | |
| "actual": 2070688, | |
| "forecast": 1983415, | |
| "value": -87273, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1994, | |
| "forecastYear": 1997, | |
| "actual": 2172571, | |
| "forecast": 2064925, | |
| "value": -107646, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1994, | |
| "forecastYear": 1998, | |
| "actual": 2354379, | |
| "forecast": 2152285, | |
| "value": -202094, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1994, | |
| "forecastYear": 1999, | |
| "actual": 2479025, | |
| "forecast": 2243525, | |
| "value": -235500, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1994, | |
| "forecastYear": 2000, | |
| "actual": 2628678, | |
| "forecast": 2340155, | |
| "value": -288523, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1995, | |
| "forecastYear": 1995, | |
| "actual": 1954810, | |
| "forecast": "", | |
| "value": 124084, | |
| "type": "actual" | |
| }, | |
| { | |
| "budgetYear": 1995, | |
| "forecastYear": 1995, | |
| "actual": 1954810, | |
| "forecast": 1919920, | |
| "value": -34890, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1995, | |
| "forecastYear": 1996, | |
| "actual": 2070688, | |
| "forecast": 2004710, | |
| "value": -65978, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1995, | |
| "forecastYear": 1997, | |
| "actual": 2172571, | |
| "forecast": 2096100, | |
| "value": -76471, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1995, | |
| "forecastYear": 1998, | |
| "actual": 2354379, | |
| "forecast": 2191670, | |
| "value": -162709, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1995, | |
| "forecastYear": 1999, | |
| "actual": 2479025, | |
| "forecast": 2293100, | |
| "value": -185925, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1995, | |
| "forecastYear": 2000, | |
| "actual": 2628678, | |
| "forecast": 2399770, | |
| "value": -228908, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1995, | |
| "forecastYear": 2001, | |
| "actual": 2541125, | |
| "forecast": 2499950, | |
| "value": -41175, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1996, | |
| "forecastYear": 1996, | |
| "actual": 2070688, | |
| "forecast": "", | |
| "value": 115878, | |
| "type": "actual" | |
| }, | |
| { | |
| "budgetYear": 1996, | |
| "forecastYear": 1996, | |
| "actual": 2070688, | |
| "forecast": 2043880, | |
| "value": -26808, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1996, | |
| "forecastYear": 1997, | |
| "actual": 2172571, | |
| "forecast": 2134840, | |
| "value": -37731, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1996, | |
| "forecastYear": 1998, | |
| "actual": 2354379, | |
| "forecast": 2226300, | |
| "value": -128079, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1996, | |
| "forecastYear": 1999, | |
| "actual": 2479025, | |
| "forecast": 2324160, | |
| "value": -154865, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1996, | |
| "forecastYear": 2000, | |
| "actual": 2628678, | |
| "forecast": 2428410, | |
| "value": -200268, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1996, | |
| "forecastYear": 2001, | |
| "actual": 2541125, | |
| "forecast": 2512960, | |
| "value": -28165, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1996, | |
| "forecastYear": 2002, | |
| "actual": 2474730, | |
| "forecast": 2602900, | |
| "value": 128170, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1997, | |
| "forecastYear": 1997, | |
| "actual": 2172571, | |
| "forecast": "", | |
| "value": 101883, | |
| "type": "actual" | |
| }, | |
| { | |
| "budgetYear": 1997, | |
| "forecastYear": 1997, | |
| "actual": 2172571, | |
| "forecast": 2193445, | |
| "value": 20874, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1997, | |
| "forecastYear": 1998, | |
| "actual": 2354379, | |
| "forecast": 2313755, | |
| "value": -40624, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1997, | |
| "forecastYear": 1999, | |
| "actual": 2479025, | |
| "forecast": 2442075, | |
| "value": -36950, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1997, | |
| "forecastYear": 2000, | |
| "actual": 2628678, | |
| "forecast": 2576545, | |
| "value": -52133, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1997, | |
| "forecastYear": 2001, | |
| "actual": 2541125, | |
| "forecast": 2688735, | |
| "value": 147610, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1997, | |
| "forecastYear": 2002, | |
| "actual": 2474730, | |
| "forecast": 2804495, | |
| "value": 329765, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1997, | |
| "forecastYear": 2003, | |
| "actual": 2547057, | |
| "forecast": 2922295, | |
| "value": 375238, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1998, | |
| "forecastYear": 1998, | |
| "actual": 2354379, | |
| "forecast": "", | |
| "value": 181808, | |
| "type": "actual" | |
| }, | |
| { | |
| "budgetYear": 1998, | |
| "forecastYear": 1998, | |
| "actual": 2354379, | |
| "forecast": 2279220, | |
| "value": -75159, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1998, | |
| "forecastYear": 1999, | |
| "actual": 2479025, | |
| "forecast": 2384320, | |
| "value": -94705, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1998, | |
| "forecastYear": 2000, | |
| "actual": 2628678, | |
| "forecast": 2498560, | |
| "value": -130118, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1998, | |
| "forecastYear": 2001, | |
| "actual": 2541125, | |
| "forecast": 2622690, | |
| "value": 81565, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1998, | |
| "forecastYear": 2002, | |
| "actual": 2474730, | |
| "forecast": 2757800, | |
| "value": 283070, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1998, | |
| "forecastYear": 2003, | |
| "actual": 2547057, | |
| "forecast": 2905300, | |
| "value": 358243, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1998, | |
| "forecastYear": 2004, | |
| "actual": 2711843, | |
| "forecast": 3066090, | |
| "value": 354247, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1999, | |
| "forecastYear": 1999, | |
| "actual": 2479025, | |
| "forecast": "", | |
| "value": 124646, | |
| "type": "actual" | |
| }, | |
| { | |
| "budgetYear": 1999, | |
| "forecastYear": 1999, | |
| "actual": 2479025, | |
| "forecast": 2477805, | |
| "value": -1220, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1999, | |
| "forecastYear": 2000, | |
| "actual": 2628678, | |
| "forecast": 2621575, | |
| "value": -7103, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1999, | |
| "forecastYear": 2001, | |
| "actual": 2541125, | |
| "forecast": 2790875, | |
| "value": 249750, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1999, | |
| "forecastYear": 2002, | |
| "actual": 2474730, | |
| "forecast": 2939015, | |
| "value": 464285, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1999, | |
| "forecastYear": 2003, | |
| "actual": 2547057, | |
| "forecast": 3082135, | |
| "value": 535078, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1999, | |
| "forecastYear": 2004, | |
| "actual": 2711843, | |
| "forecast": 3233855, | |
| "value": 522012, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 1999, | |
| "forecastYear": 2005, | |
| "actual": 2851707, | |
| "forecast": 3363345, | |
| "value": 511638, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2000, | |
| "forecastYear": 2000, | |
| "actual": 2628678, | |
| "forecast": "", | |
| "value": 149653, | |
| "type": "actual" | |
| }, | |
| { | |
| "budgetYear": 2000, | |
| "forecastYear": 2000, | |
| "actual": 2628678, | |
| "forecast": 2651200, | |
| "value": 22522, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2000, | |
| "forecastYear": 2001, | |
| "actual": 2541125, | |
| "forecast": 2807510, | |
| "value": 266385, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2000, | |
| "forecastYear": 2002, | |
| "actual": 2474730, | |
| "forecast": 2977040, | |
| "value": 502310, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2000, | |
| "forecastYear": 2003, | |
| "actual": 2547057, | |
| "forecast": 3149890, | |
| "value": 602833, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2000, | |
| "forecastYear": 2004, | |
| "actual": 2711843, | |
| "forecast": 3315860, | |
| "value": 604017, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2000, | |
| "forecastYear": 2005, | |
| "actual": 2851707, | |
| "forecast": 3467780, | |
| "value": 616073, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2000, | |
| "forecastYear": 2006, | |
| "actual": 2971116, | |
| "forecast": 3584890, | |
| "value": 613774, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2001, | |
| "forecastYear": 2001, | |
| "actual": 2541125, | |
| "forecast": "", | |
| "value": -38246, | |
| "type": "actual" | |
| }, | |
| { | |
| "budgetYear": 2001, | |
| "forecastYear": 2001, | |
| "actual": 2541125, | |
| "forecast": 2646535, | |
| "value": 105410, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2001, | |
| "forecastYear": 2002, | |
| "actual": 2474730, | |
| "forecast": 2756845, | |
| "value": 282115, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2001, | |
| "forecastYear": 2003, | |
| "actual": 2547057, | |
| "forecast": 2888555, | |
| "value": 341498, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2001, | |
| "forecastYear": 2004, | |
| "actual": 2711843, | |
| "forecast": 3005705, | |
| "value": 293862, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2001, | |
| "forecastYear": 2005, | |
| "actual": 2851707, | |
| "forecast": 3125895, | |
| "value": 274188, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2001, | |
| "forecastYear": 2006, | |
| "actual": 2971116, | |
| "forecast": 3244075, | |
| "value": 272959, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2001, | |
| "forecastYear": 2007, | |
| "actual": 3107628, | |
| "forecast": 3360095, | |
| "value": 252467, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2002, | |
| "forecastYear": 2002, | |
| "actual": 2474730, | |
| "forecast": "", | |
| "value": -66395, | |
| "type": "actual" | |
| }, | |
| { | |
| "budgetYear": 2002, | |
| "forecastYear": 2002, | |
| "actual": 2474730, | |
| "forecast": 2527850, | |
| "value": 53120, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2002, | |
| "forecastYear": 2003, | |
| "actual": 2547057, | |
| "forecast": 2638832, | |
| "value": 91775, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2002, | |
| "forecastYear": 2004, | |
| "actual": 2711843, | |
| "forecast": 2759556, | |
| "value": 47713, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2002, | |
| "forecastYear": 2005, | |
| "actual": 2851707, | |
| "forecast": 2846473, | |
| "value": -5234, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2002, | |
| "forecastYear": 2006, | |
| "actual": 2971116, | |
| "forecast": 2936938, | |
| "value": -34178, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2002, | |
| "forecastYear": 2007, | |
| "actual": 3107628, | |
| "forecast": 3036513, | |
| "value": -71115, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2002, | |
| "forecastYear": 2008, | |
| "actual": 3150924, | |
| "forecast": 3142342, | |
| "value": -8582, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2003, | |
| "forecastYear": 2003, | |
| "actual": 2547057, | |
| "forecast": "", | |
| "value": 72327, | |
| "type": "actual" | |
| }, | |
| { | |
| "budgetYear": 2003, | |
| "forecastYear": 2003, | |
| "actual": 2547057, | |
| "forecast": 2524482, | |
| "value": -22575, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2003, | |
| "forecastYear": 2004, | |
| "actual": 2711843, | |
| "forecast": 2628226, | |
| "value": -83617, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2003, | |
| "forecastYear": 2005, | |
| "actual": 2851707, | |
| "forecast": 2728010, | |
| "value": -123697, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2003, | |
| "forecastYear": 2006, | |
| "actual": 2971116, | |
| "forecast": 2842681, | |
| "value": -128435, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2003, | |
| "forecastYear": 2007, | |
| "actual": 3107628, | |
| "forecast": 2943541, | |
| "value": -164087, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2003, | |
| "forecastYear": 2008, | |
| "actual": 3150924, | |
| "forecast": 3055257, | |
| "value": -95667, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2003, | |
| "forecastYear": 2009, | |
| "actual": 2930100, | |
| "forecast": 3166835, | |
| "value": 236735, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2004, | |
| "forecastYear": 2004, | |
| "actual": 2711843, | |
| "forecast": "", | |
| "value": 158441, | |
| "type": "actual" | |
| }, | |
| { | |
| "budgetYear": 2004, | |
| "forecastYear": 2004, | |
| "actual": 2711843, | |
| "forecast": 2622999, | |
| "value": -88844, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2004, | |
| "forecastYear": 2005, | |
| "actual": 2851707, | |
| "forecast": 2705527, | |
| "value": -146180, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2004, | |
| "forecastYear": 2006, | |
| "actual": 2971116, | |
| "forecast": 2773303, | |
| "value": -197813, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2004, | |
| "forecastYear": 2007, | |
| "actual": 3107628, | |
| "forecast": 2867270, | |
| "value": -240358, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2004, | |
| "forecastYear": 2008, | |
| "actual": 3150924, | |
| "forecast": 2950322, | |
| "value": -200602, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2004, | |
| "forecastYear": 2009, | |
| "actual": 2930100, | |
| "forecast": 3029369, | |
| "value": 99269, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2004, | |
| "forecastYear": 2010, | |
| "actual": 2980761, | |
| "forecast": 3119204, | |
| "value": 138443, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2005, | |
| "forecastYear": 2005, | |
| "actual": 2851707, | |
| "forecast": "", | |
| "value": 139864, | |
| "type": "actual" | |
| }, | |
| { | |
| "budgetYear": 2005, | |
| "forecastYear": 2005, | |
| "actual": 2851707, | |
| "forecast": 2833171, | |
| "value": -18536, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2005, | |
| "forecastYear": 2006, | |
| "actual": 2971116, | |
| "forecast": 2929890, | |
| "value": -41226, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2005, | |
| "forecastYear": 2007, | |
| "actual": 3107628, | |
| "forecast": 3013753, | |
| "value": -93875, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2005, | |
| "forecastYear": 2008, | |
| "actual": 3150924, | |
| "forecast": 3092996, | |
| "value": -57928, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2005, | |
| "forecastYear": 2009, | |
| "actual": 2930100, | |
| "forecast": 3168364, | |
| "value": 238264, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2005, | |
| "forecastYear": 2010, | |
| "actual": 2980761, | |
| "forecast": 3292190, | |
| "value": 311429, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2005, | |
| "forecastYear": 2011, | |
| "actual": 3077567, | |
| "forecast": 3394422, | |
| "value": 316855, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2006, | |
| "forecastYear": 2006, | |
| "actual": 2971116, | |
| "forecast": "", | |
| "value": 119409, | |
| "type": "actual" | |
| }, | |
| { | |
| "budgetYear": 2006, | |
| "forecastYear": 2006, | |
| "actual": 2971116, | |
| "forecast": 2950557, | |
| "value": -20559, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2006, | |
| "forecastYear": 2007, | |
| "actual": 3107628, | |
| "forecast": 3045884, | |
| "value": -61744, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2006, | |
| "forecastYear": 2008, | |
| "actual": 3150924, | |
| "forecast": 3129785, | |
| "value": -21139, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2006, | |
| "forecastYear": 2009, | |
| "actual": 2930100, | |
| "forecast": 3230948, | |
| "value": 300848, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2006, | |
| "forecastYear": 2010, | |
| "actual": 2980761, | |
| "forecast": 3353712, | |
| "value": 372951, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2006, | |
| "forecastYear": 2011, | |
| "actual": 3077567, | |
| "forecast": 3456617, | |
| "value": 379050, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2006, | |
| "forecastYear": 2012, | |
| "actual": 3017636, | |
| "forecast": 3562090, | |
| "value": 544454, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2007, | |
| "forecastYear": 2007, | |
| "actual": 3107628, | |
| "forecast": "", | |
| "value": 136512, | |
| "type": "actual" | |
| }, | |
| { | |
| "budgetYear": 2007, | |
| "forecastYear": 2007, | |
| "actual": 3107628, | |
| "forecast": 3077218, | |
| "value": -30410, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2007, | |
| "forecastYear": 2008, | |
| "actual": 3150924, | |
| "forecast": 3181335, | |
| "value": 30411, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2007, | |
| "forecastYear": 2009, | |
| "actual": 2930100, | |
| "forecast": 3283437, | |
| "value": 353337, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2007, | |
| "forecastYear": 2010, | |
| "actual": 2980761, | |
| "forecast": 3377868, | |
| "value": 397107, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2007, | |
| "forecastYear": 2011, | |
| "actual": 3077567, | |
| "forecast": 3515435, | |
| "value": 437868, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2007, | |
| "forecastYear": 2012, | |
| "actual": 3017636, | |
| "forecast": 3628142, | |
| "value": 610506, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2007, | |
| "forecastYear": 2013, | |
| "actual": 2990043, | |
| "forecast": 3739529, | |
| "value": 749486, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2008, | |
| "forecastYear": 2008, | |
| "actual": 3150924, | |
| "forecast": "", | |
| "value": 43296, | |
| "type": "actual" | |
| }, | |
| { | |
| "budgetYear": 2008, | |
| "forecastYear": 2008, | |
| "actual": 3150924, | |
| "forecast": 3227284, | |
| "value": 76360, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2008, | |
| "forecastYear": 2009, | |
| "actual": 2930100, | |
| "forecast": 3360937, | |
| "value": 430837, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2008, | |
| "forecastYear": 2010, | |
| "actual": 2980761, | |
| "forecast": 3480588, | |
| "value": 499827, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2008, | |
| "forecastYear": 2011, | |
| "actual": 3077567, | |
| "forecast": 3587958, | |
| "value": 510391, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2008, | |
| "forecastYear": 2012, | |
| "actual": 3017636, | |
| "forecast": 3750415, | |
| "value": 732779, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2008, | |
| "forecastYear": 2013, | |
| "actual": 2990043, | |
| "forecast": 3864513, | |
| "value": 874470, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2008, | |
| "forecastYear": 2014, | |
| "actual": 3030019, | |
| "forecast": 3977226, | |
| "value": 947207, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2009, | |
| "forecastYear": 2009, | |
| "actual": 2930100, | |
| "forecast": "", | |
| "value": -220824, | |
| "type": "actual" | |
| }, | |
| { | |
| "budgetYear": 2009, | |
| "forecastYear": 2009, | |
| "actual": 2930100, | |
| "forecast": 2994009, | |
| "value": 63909, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2009, | |
| "forecastYear": 2010, | |
| "actual": 2980761, | |
| "forecast": 3044531, | |
| "value": 63770, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2009, | |
| "forecastYear": 2011, | |
| "actual": 3077567, | |
| "forecast": 3149288, | |
| "value": 71721, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2009, | |
| "forecastYear": 2012, | |
| "actual": 3017636, | |
| "forecast": 3281071, | |
| "value": 263435, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2009, | |
| "forecastYear": 2013, | |
| "actual": 2990043, | |
| "forecast": 3381186, | |
| "value": 391143, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2009, | |
| "forecastYear": 2014, | |
| "actual": 3030019, | |
| "forecast": 3493749, | |
| "value": 463730, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2009, | |
| "forecastYear": 2015, | |
| "actual": 3080476, | |
| "forecast": 3604966, | |
| "value": 524490, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2010, | |
| "forecastYear": 2010, | |
| "actual": 2980761, | |
| "forecast": "", | |
| "value": 50661, | |
| "type": "actual" | |
| }, | |
| { | |
| "budgetYear": 2010, | |
| "forecastYear": 2010, | |
| "actual": 2980761, | |
| "forecast": 2961934, | |
| "value": -18827, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2010, | |
| "forecastYear": 2011, | |
| "actual": 3077567, | |
| "forecast": 3059759, | |
| "value": -17808, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2010, | |
| "forecastYear": 2012, | |
| "actual": 3017636, | |
| "forecast": 3165885, | |
| "value": 148249, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2010, | |
| "forecastYear": 2013, | |
| "actual": 2990043, | |
| "forecast": 3256675, | |
| "value": 266632, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2010, | |
| "forecastYear": 2014, | |
| "actual": 3030019, | |
| "forecast": 3356861, | |
| "value": 326842, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2010, | |
| "forecastYear": 2015, | |
| "actual": 3080476, | |
| "forecast": 3454204, | |
| "value": 373728, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2011, | |
| "forecastYear": 2011, | |
| "actual": 3077567, | |
| "forecast": "", | |
| "value": 96806, | |
| "type": "actual" | |
| }, | |
| { | |
| "budgetYear": 2011, | |
| "forecastYear": 2011, | |
| "actual": 3077567, | |
| "forecast": 3124057, | |
| "value": 46490, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2011, | |
| "forecastYear": 2012, | |
| "actual": 3017636, | |
| "forecast": 3240186, | |
| "value": 222550, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2011, | |
| "forecastYear": 2013, | |
| "actual": 2990043, | |
| "forecast": 3313221, | |
| "value": 323178, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2011, | |
| "forecastYear": 2014, | |
| "actual": 3030019, | |
| "forecast": 3397430, | |
| "value": 367411, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2011, | |
| "forecastYear": 2015, | |
| "actual": 3080476, | |
| "forecast": 3481246, | |
| "value": 400770, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2012, | |
| "forecastYear": 2012, | |
| "actual": 3017636, | |
| "forecast": "", | |
| "value": -59931, | |
| "type": "actual" | |
| }, | |
| { | |
| "budgetYear": 2012, | |
| "forecastYear": 2012, | |
| "actual": 3017636, | |
| "forecast": 3041017, | |
| "value": 23381, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2012, | |
| "forecastYear": 2013, | |
| "actual": 2990043, | |
| "forecast": 3081990, | |
| "value": 91947, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2012, | |
| "forecastYear": 2014, | |
| "actual": 3030019, | |
| "forecast": 3167441, | |
| "value": 137422, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2012, | |
| "forecastYear": 2015, | |
| "actual": 3080476, | |
| "forecast": 3255219, | |
| "value": 174743, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2013, | |
| "forecastYear": 2013, | |
| "actual": 2990043, | |
| "forecast": "", | |
| "value": -27593, | |
| "type": "actual" | |
| }, | |
| { | |
| "budgetYear": 2013, | |
| "forecastYear": 2013, | |
| "actual": 2990043, | |
| "forecast": 2965471, | |
| "value": -24572, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2013, | |
| "forecastYear": 2014, | |
| "actual": 3030019, | |
| "forecast": 3050685, | |
| "value": 20666, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2013, | |
| "forecastYear": 2015, | |
| "actual": 3080476, | |
| "forecast": 3135541, | |
| "value": 55065, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2014, | |
| "forecastYear": 2014, | |
| "actual": 3030019, | |
| "forecast": "", | |
| "value": 39976, | |
| "type": "actual" | |
| }, | |
| { | |
| "budgetYear": 2014, | |
| "forecastYear": 2014, | |
| "actual": 3030019, | |
| "forecast": 2988686, | |
| "value": -41333, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2014, | |
| "forecastYear": 2015, | |
| "actual": 3080476, | |
| "forecast": 3056360, | |
| "value": -24116, | |
| "type": "forecast" | |
| }, | |
| { | |
| "budgetYear": 2015, | |
| "forecastYear": 2015, | |
| "actual": 3080476, | |
| "forecast": "", | |
| "value": 50457, | |
| "type": "actual" | |
| }, | |
| { | |
| "budgetYear": 2015, | |
| "forecastYear": 2015, | |
| "actual": 3080476, | |
| "forecast": 3058723, | |
| "value": -21753, | |
| "type": "forecast" | |
| } | |
| ] |
| <html> | |
| <head> | |
| <title>STATFOR Forecasts</title> | |
| <script src="https://vega.github.io/vega-editor/vendor/d3.min.js"></script> | |
| <script src="https://vega.github.io/vega-editor/vendor/vega.min.js"></script> | |
| </head> | |
| <body> | |
| <div id="vis"></div> | |
| </body> | |
| <script type="text/javascript"> | |
| // parse a spec and create a visualization view | |
| function parse(spec) { | |
| vg.parse.spec(spec, function(chart) { chart({el:"#vis"}).update(); }); | |
| } | |
| parse("spec.json"); | |
| </script> | |
| </html> |
| { | |
| "width": 800, | |
| "height": 600, | |
| "padding": {"top": 10,"left": 10,"right": 80,"bottom": 10}, | |
| "background": "#edf1f7", | |
| "signals": [ | |
| { | |
| "name": "dragging", | |
| "init": false, | |
| "streams": [ | |
| {"type": "@handle:mousedown","expr": "true"}, | |
| {"type": "mouseup","expr": "false"} | |
| ] | |
| }, | |
| { | |
| "name": "handleYear", | |
| "streams": [ | |
| { | |
| "type": "mousemove[dragging]", | |
| "expr": "clamp(eventX(), 10, 10000)", | |
| "scale": {"name": "x","invert": true} | |
| } | |
| ] | |
| }, | |
| { | |
| "name": "currentYear", | |
| "init": 2010, | |
| "expr": "clamp(handleYear, 1990, 2015)" | |
| }, | |
| { | |
| "name": "tipYear", | |
| "streams": [ | |
| { | |
| "type": "mousemove[!dragging]", | |
| "expr": "eventX()", | |
| "scale": {"name": "x","invert": true} | |
| } | |
| ] | |
| }, | |
| { | |
| "name": "tipValue", | |
| "streams": [ | |
| { | |
| "type": "mousemove[!dragging]", | |
| "expr": "eventY()", | |
| "scale": {"name": "y","invert": true} | |
| } | |
| ] | |
| }, | |
| { | |
| "name": "cursor", | |
| "streams": [ | |
| { | |
| "type": "dragging", | |
| "expr": "dragging ? 'pointer' : 'default'" | |
| } | |
| ] | |
| } | |
| ], | |
| "data": [ | |
| { | |
| "name": "all", | |
| "url": "forecasts.json" | |
| }, | |
| { | |
| "name": "forecasts", | |
| "source": "all", | |
| "transform": [ | |
| { | |
| "type": "filter", | |
| "test": "datum.type === 'forecast'" | |
| }, | |
| { | |
| "type": "formula", | |
| "field": "abs", | |
| "expr": "abs(datum.value)" | |
| }, | |
| { | |
| "type": "formula", | |
| "field": "type", | |
| "expr": "datum.value < 0 ? '➷' : '➹'" | |
| } | |
| ] | |
| }, | |
| { | |
| "name": "actuals", | |
| "source": "all", | |
| "transform": [{"type": "filter","test": "datum.type === 'actual'"}] | |
| }, | |
| { | |
| "name": "tooltip", | |
| "source": "forecasts", | |
| "transform": [ | |
| { | |
| "type": "filter", | |
| "test": "datum.budgetYear <= currentYear && datum.forecastYear == tipYear && abs(datum.forecast - tipValue) < 100000" | |
| }, | |
| { | |
| "type": "aggregate", | |
| "summarize": [ | |
| { | |
| "field": "value", | |
| "ops": ["min","argmin"], | |
| "as": ["min","argmin"] | |
| } | |
| ] | |
| }, | |
| { | |
| "type": "formula", | |
| "field": "minYear", | |
| "expr": "datum.argmin.budgetYear" | |
| } | |
| ] | |
| }, | |
| { | |
| "name": "tipForecast", | |
| "source": "forecasts", | |
| "transform": [ | |
| { | |
| "type": "lookup", | |
| "on": "tooltip", | |
| "onKey": "minYear", | |
| "keys": ["budgetYear"], | |
| "as": ["t"] | |
| }, | |
| {"type": "filter","test": "datum.t"} | |
| ] | |
| } | |
| ], | |
| "scales": [ | |
| { | |
| "name": "x", | |
| "type": "ordinal", | |
| "domain": {"data": "forecasts","field": "forecastYear"}, | |
| "range": "width", | |
| "round": true, | |
| "nice": true | |
| }, | |
| { | |
| "name": "y", | |
| "type": "linear", | |
| "exponent": 2.2, | |
| "domain": {"data": "forecasts","field": "forecast"}, | |
| "range": "height", | |
| "round": true, | |
| "zero": false, | |
| "nice": true | |
| } | |
| ], | |
| "axes": [ | |
| { | |
| "type": "x", | |
| "scale": "x", | |
| "grid": true, | |
| "layer": "back", | |
| "tickSize": 0, | |
| "properties": { | |
| "grid": { | |
| "stroke": {"value": "white"}, | |
| "strokeOpacity": {"value": 0.75} | |
| }, | |
| "axis": {"stroke": {"value": "#edf1f7"}}, | |
| "labels": {"fill": {"value": "#edf1f7"}} | |
| } | |
| }, | |
| { | |
| "type": "y", | |
| "scale": "y", | |
| "grid": true, | |
| "layer": "back", | |
| "orient": "right", | |
| "values": [ | |
| 1400000, | |
| 1600000, | |
| 1800000, | |
| 2000000, | |
| 2200000, | |
| 2400000, | |
| 2600000, | |
| 2800000, | |
| 3000000, | |
| 3200000, | |
| 3400000, | |
| 3600000, | |
| 3800000, | |
| 4000000 | |
| ], | |
| "title": "Movements", | |
| "tickSize": 1, | |
| "properties": { | |
| "grid": { | |
| "stroke": {"value": "white"}, | |
| "strokeOpacity": {"value": 0.75} | |
| }, | |
| "axis": {"stroke": {"value": "#edf1f7"}}, | |
| "labels": { | |
| "text": { | |
| "template": "{{datum.data | number:'.2s'}}" | |
| } | |
| } | |
| } | |
| } | |
| ], | |
| "marks": [ | |
| { | |
| "type": "group", | |
| "from": { | |
| "data": "forecasts", | |
| "transform": [ | |
| { | |
| "type": "filter", | |
| "test": "datum.budgetYear <= currentYear" | |
| }, | |
| {"type": "facet","groupby": ["budgetYear"]} | |
| ] | |
| }, | |
| "marks": [ | |
| { | |
| "type": "line", | |
| "properties": { | |
| "update": { | |
| "x": {"scale": "x","field": "forecastYear"}, | |
| "y": {"scale": "y","field": "forecast"}, | |
| "stroke": {"value": "steelblue"}, | |
| "strokeWidth": {"value": 1}, | |
| "strokeOpacity": {"value": 0.25} | |
| } | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "type": "symbol", | |
| "from": { | |
| "data": "actuals", | |
| "transform": [ | |
| { | |
| "type": "filter", | |
| "test": "datum.budgetYear <= currentYear" | |
| } | |
| ] | |
| }, | |
| "properties": { | |
| "update": { | |
| "x": {"scale": "x","field": "forecastYear"}, | |
| "y": {"scale": "y","field": "actual"}, | |
| "stroke": {"value": "steelblue"}, | |
| "strokeWidth": {"value": 3}, | |
| "size": {"value": 16}, | |
| "shape": {"value": "diamond"} | |
| } | |
| } | |
| }, | |
| { | |
| "type": "line", | |
| "from": {"data": "tipForecast"}, | |
| "properties": { | |
| "update": { | |
| "x": {"scale": "x","field": "forecastYear"}, | |
| "y": {"scale": "y","field": "forecast"}, | |
| "stroke": {"value": "black"}, | |
| "strokeWidth": {"value": 1} | |
| } | |
| } | |
| }, | |
| { | |
| "type": "symbol", | |
| "from": {"data": "tooltip"}, | |
| "properties": { | |
| "update": { | |
| "x": {"scale": "x","field": "argmin.forecastYear"}, | |
| "y": {"scale": "y","field": "argmin.forecast"}, | |
| "size": {"value": 50}, | |
| "fill": {"value": "black"} | |
| } | |
| } | |
| }, | |
| { | |
| "type": "rule", | |
| "properties": { | |
| "enter": { | |
| "y": {"scale": "y","value": 3900000}, | |
| "stroke": {"value": "#000"}, | |
| "strokeWidth": {"value": 1} | |
| }, | |
| "update": { | |
| "x": {"value": 0}, | |
| "x2": {"scale": "x","signal": "currentYear"} | |
| } | |
| } | |
| }, | |
| { | |
| "name": "handle", | |
| "type": "symbol", | |
| "properties": { | |
| "enter": { | |
| "y": {"scale": "y","value": 3900000,"offset": 1}, | |
| "shape": {"value": "triangle-down"}, | |
| "size": {"value": 150}, | |
| "stroke": {"value": "#000"}, | |
| "strokeWidth": {"value": 0.5} | |
| }, | |
| "update": { | |
| "x": {"scale": "x","signal": "currentYear"}, | |
| "fill": {"value": "#fff"} | |
| }, | |
| "hover": { | |
| "fill": {"value": "lemonchiffon"}, | |
| "cursor": {"value": "pointer"} | |
| } | |
| } | |
| }, | |
| { | |
| "type": "text", | |
| "properties": { | |
| "enter": { | |
| "x": {"value": 0}, | |
| "y": {"value": 16}, | |
| "fontSize": {"value": 32}, | |
| "fontWeight": {"value": "bold"}, | |
| "fill": {"value": "steelblue"} | |
| }, | |
| "update": {"text": {"signal": "currentYear"}} | |
| } | |
| }, | |
| { | |
| "type": "group", | |
| "from": {"data": "tooltip"}, | |
| "properties": { | |
| "update": { | |
| "x": { | |
| "scale": "x", | |
| "field": "argmin.forecastYear", | |
| "offset": -5 | |
| }, | |
| "y": { | |
| "scale": "y", | |
| "field": "argmin.forecast", | |
| "offset": 20 | |
| }, | |
| "width": {"value": 150}, | |
| "height": {"value": 35}, | |
| "fill": {"value": "#fff"}, | |
| "fillOpacity": {"value": 0.85}, | |
| "stroke": {"value": "#aaa"}, | |
| "strokeWidth": {"value": 0.5} | |
| } | |
| }, | |
| "marks": [ | |
| { | |
| "type": "text", | |
| "properties": { | |
| "update": { | |
| "x": {"value": 6}, | |
| "y": {"value": 14}, | |
| "text": { | |
| "template": "Forecast from early {{parent.argmin.budgetYear}}" | |
| }, | |
| "fill": {"value": "black"}, | |
| "fontWeight": {"value": "bold"} | |
| } | |
| } | |
| }, | |
| { | |
| "type": "text", | |
| "properties": { | |
| "update": { | |
| "x": {"value": 6}, | |
| "y": {"value": 29}, | |
| "text": { | |
| "template": "{{parent.argmin.forecastYear}} \t {{parent.argmin.abs|number:'d'}} flights {{parent.argmin.type}}" | |
| }, | |
| "fill": {"value": "black"}, | |
| "align": {"value": "left"} | |
| } | |
| } | |
| } | |
| ] | |
| } | |
| ] | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment