C4: field4_list_full.csv
---------------------------------------------------------
Type        Row_end     V(J,K)
---------------------------------------------------------
RAVE             1      sorted ((J-K)>0.5)&(logg<3.8)
2MASS        17410      sorted ((J-K)>0.5)&(V>9)&(V<=15)


C5: field5_list_full.csv
---------------------------------------------------------
Type        Row_end     V(J,K)
---------------------------------------------------------
APOGEE           255      sorted ((J-K)>0.5)&(logg<3.8)
RAVE             264      sorted ((J-K)>0.5)&(logg<3.8)
2MASS            9955     sorted ((J-K)>0.5)&(V>9)&(V<=15)

All stars are sorted by V(J,K) (from bright to faint), where 
V(J,K)=K+2.0*((J-K)+0.14)+0.382*exp((J-K-0.2)*2).


The 2MASS stars were selected with following 
criteria on their quality of photometry.
((qflg == 'AAA')|(qflg == 'AAB')|(qflg == 'ABA')|(qflg == 'ABB')|(qflg == 'BAA')|
(qflg == 'BAB')|(qflg == 'BBA')|(qflg == 'BBB'))&
(bflg=='111')&(cflg=='000')&(xflg==0)&(aflg==0)&(prox>6.0)



File description
---------------------------------------------------------------------------
columns: [epic,recno,jmag,hmag,kmag,kpmag,vmag_jk,tflag,pflag]
epic  -  epic id
recno -  row number in master epic file
ra    -  ra from epic 
dec   -  de from epic
jmag  -  2MASS J from epic 
hmag  -  2MASS H from epic 
kmag  -  2MASS Ks from epic 
kpmag -  Kp from epic
vmag_jk- V(J,K) from 2MASS J and Ks
pflag -  priority flag, related to type of source for the star
tflag -  is a 32 bit integer used to store flags that identify 
         the different type of targets. Bitmasking is used as follows. 
         APOGEE  ((tflag&(2**0))   !=0)  
         RAVE    ((tflag&(2**1))   !=0)  
         GAIAESO ((tflag&(2**2))   !=0)
         MISC    ((tflag&(2**3))   !=0)
	 UNUSED  .......4 to 9........   
         2MASS   ((tflag&(2**10))  !=0) main proposed targets 

Number counts and giant fractions
--------------------------------------------------------------------------------------------
The numbers given below are for 2MASS stars in 8 deg radius of the field center.
The columns gf(vc), gf(<vc), mf(v<c) show predictions using the code GALAXIA.
(Sharma et al 2011, http://adsabs.harvard.edu/abs/2011ApJ...730....3S, http://galaxia.sourceforge.net)

v1,v2           : mag range for the specified band
n(v)            : stars with (v>v1)&(v<v2)
n(v,c)          : stars with (v>v1)&(v<v2)&((J-K)>0.5)
n(<v) or n(<vc) : are corresponding cumulative numbers
n1d(<vc)        : average cumulative number of stars per 1 deg radius region with (v>v1)&(v<v2)&((J-K)>0.5)
n1d(<v)         : average cumulative number of stars per 1 deg radius region with (v>v1)&(v<v2)
gf(vc)          : giant fraction of stars with (v>v1)&(v<v2)&((J-K)>0.5)
gf(<vc)         : cumulative giant fraction of stars with (v>v1)&(v<v2)&((J-K)>0.5)
mf(<vc)         : cumulative M dwarf fraction with (v>v1)&(v<v2)&((J-K)>0.5)
ns(<vc)         : (On silica)&(twomass_qual_flag=True)&(v>v1)&(v<v2)&((J-K)>0.5)
ncs(<vc)        : (On silica)&(twomass_qual_flag=True)&(in 1 deg circles)&(v>v1)&(v<v2)&((J-K)>0.5)

Campaign-4
Using V(J,K)
-----------------------------------------------------------------------------------------------------------------
     v1      v2      Kp  n(v,c)    n(v) n(<v,c)   n(<v) n1d(<vc) n1d(<v)  gf(vc) gf(<vc) mf(<vc) ns(<vc) ncs(<vc)
-----------------------------------------------------------------------------------------------------------------
   9.00    9.25    8.73      45     128      45     128       0       2    0.99    0.99    0.00      19      10
   9.25    9.50    9.04      63     164     108     292       1       4    0.97    0.98    0.00      59      31
   9.50    9.75    9.24      80     208     188     500       2       7    0.99    0.98    0.00      96      47
   9.75   10.00    9.51     107     281     295     781       4      12    0.88    0.95    0.01     157      82
  10.00   10.25    9.75     128     318     423    1099       6      17    0.96    0.95    0.00     207     107
  10.25   10.50   10.02     160     361     583    1460       9      22    0.95    0.95    0.00     276     149
  10.50   10.75   10.29     225     494     808    1954      12      30    0.95    0.95    0.00     383     214
  10.75   11.00   10.54     272     642    1080    2596      16      40    0.93    0.95    0.00     525     290
  11.00   11.25   10.78     336     729    1416    3325      22      52    0.90    0.94    0.00     692     378
  11.25   11.50   11.06     384     871    1800    4196      28      65    0.92    0.93    0.00     878     485
  11.50   11.75   11.30     498    1118    2298    5314      35      83    0.89    0.92    0.00    1111     619
  11.75   12.00   11.55     688    1405    2986    6719      46     105    0.85    0.91    0.00    1435     798
  12.00   12.25   11.82     788    1648    3774    8367      59     130    0.84    0.90    0.00    1818    1009
  12.25   12.50   12.07     890    1981    4664   10348      72     161    0.79    0.88    0.00    2261    1263
  12.50   12.75   12.33    1169    2454    5833   12802      91     200    0.75    0.86    0.00    2822    1558
  12.75   13.00   12.62    1375    2882    7208   15684     112     245    0.66    0.82    0.00    3451    1907
  13.00   13.25   12.88    1643    3378    8851   19062     138     298    0.63    0.79    0.00    4224    2337
  13.25   13.50   13.15    2140    4083   10991   23145     172     362    0.55    0.75    0.01    5226    2883
  13.50   13.75   13.41    2552    4806   13543   27951     211     437    0.49    0.71    0.01    6459    3584
  13.75   14.00   13.68    3043    5624   16586   33575     259     525    0.41    0.66    0.01    7914    4349
  14.00   14.25   13.94    3657    6598   20243   40173     316     628    0.35    0.61    0.01    9633    5270
  14.25   14.50   14.19    4438    7665   24681   47838     386     748    0.30    0.56    0.01   11803    6458
  14.50   14.75   14.45    5332    8777   30013   56615     469     886    0.26    0.51    0.01   14269    7759
  14.75   15.00   14.71    6414   10326   36427   66941     570    1047    0.21    0.46    0.01   17410    9432

Campaign-5
Using V(J,K)
-----------------------------------------------------------------------------------------------------------------
     v1      v2      Kp  n(v,c)    n(v) n(<v,c)   n(<v) n1d(<vc) n1d(<v)  gf(vc) gf(<vc) mf(<vc) ns(<vc) ncs(<vc)
-----------------------------------------------------------------------------------------------------------------
   9.00    9.25    8.75      70     157      70     157       1       2    0.96    0.96    0.00      27      16
   9.25    9.50    8.96      81     192     151     349       2       5    0.98    0.98    0.00      60      32
   9.50    9.75    9.25     132     271     283     620       4       9    0.98    0.98    0.00     131      69
   9.75   10.00    9.52     155     311     438     931       6      14    0.99    0.98    0.00     211     110
  10.00   10.25    9.76     150     365     588    1296       9      20    0.97    0.98    0.00     277     146
  10.25   10.50   10.01     222     466     810    1762      12      27    0.96    0.97    0.00     380     202
  10.50   10.75   10.28     231     570    1041    2332      16      36    0.95    0.97    0.00     471     249
  10.75   11.00   10.54     255     663    1296    2995      20      46    0.96    0.97    0.00     595     309
  11.00   11.25   10.78     358     872    1654    3867      25      60    0.93    0.96    0.00     768     415
  11.25   11.50   11.06     433    1085    2087    4952      32      77    0.95    0.96    0.00     968     524
  11.50   11.75   11.31     457    1186    2544    6138      39      96    0.93    0.95    0.00    1200     661
  11.75   12.00   11.55     547    1505    3091    7643      48     119    0.88    0.94    0.00    1478     816
  12.00   12.25   11.83     590    1767    3681    9410      57     147    0.85    0.93    0.00    1772     967
  12.25   12.50   12.07     633    2037    4314   11447      67     179    0.83    0.91    0.01    2091    1140
  12.50   12.75   12.33     695    2405    5009   13852      78     216    0.77    0.89    0.01    2432    1338
  12.75   13.00   12.58     873    2967    5882   16819      92     263    0.71    0.87    0.01    2881    1596
  13.00   13.25   12.84     983    3444    6865   20263     107     317    0.66    0.84    0.01    3386    1869
  13.25   13.50   13.09    1082    4293    7947   24556     124     384    0.59    0.81    0.01    3944    2161
  13.50   13.75   13.35    1217    4931    9164   29487     143     461    0.51    0.77    0.01    4554    2484
  13.75   14.00   13.60    1462    5870   10626   35357     166     553    0.44    0.73    0.01    5267    2866
  14.00   14.25   13.84    1707    6696   12333   42053     193     658    0.38    0.68    0.02    6128    3307
  14.25   14.50   14.09    2003    7583   14336   49636     224     776    0.31    0.63    0.02    7162    3872
  14.50   14.75   14.35    2504    8817   16840   58453     263     914    0.24    0.57    0.02    8443    4575
  14.75   15.00   14.59    3019   10189   19859   68642     310    1074    0.19    0.52    0.03    9937    5392