VSA - SQL Query Results

Submitted query: SELECT vivaID as IDviva, viva.* FROM vvvVivaCatalogue as viva WHERE nGoodMeasurements > 40

Start: Mon Sep 14 17:31:14 BST 2020 End: Mon Sep 14 17:39:45 BST 2020

Database: VVVDR4

(Query returned at least (i.e. before it was halted) 16000000 result rows, only the first 30 rows are shown in the displayed table.)

NB The number of rows written to the output file reached the maximum allowed 8000000

  IDviva vivaID cuEventID fieldName ra dec cx cy cz htmID glJ2000 gbJ2000 zAperMag3 zAperMag3Err yAperMag3 yAperMag3Err jAperMag3 jAperMag3Err hAperMag3 hAperMag3Err ksAperMag3 ksAperMag3Err ksPawprintMeanMag eD expRMSNoise nGoodMeasurements xIndex kFi2 l2 nCorrelation2 faPcorrelation2 flagDataType eJKs eJKsErr freqPKfi2 HeightPKfi2 freqPLfi2 HeightPLfi2 freqLSG HeightLSG freqPDM HeightPDM freqSTR HeightSTR BestPeriod SNRfit aVar flagNfreq flagFbias6 flagFbias7
1 515396195307 515396195307 711 b396 +267.2832752 -18.7317988 -0.0448875 -0.9459678 -0.3211386 11582864960502 +9.1626864 +4.5821699 -9.999995E008 -9.999995E008 +17.634600 +0.065691 +17.143545 +0.054268 +16.657743 +0.071723 +16.509039 +0.116544 +16.511875 +0.1084800 +0.0824160 92 +1.3162490 +0.7111110 +0.2175830 45 +0.6841640 CCD +0.399407 +0.085180 +27.9160387 +0.7391000 +15.5465932 +0.2692000 +7.3501762 +5.7047000 +2.7266570 +0.7521000 +6.8659085 +0.0943000 +0.1456472 +1.6010000 +0.4927940 3 7 2
2 515396195317 515396195317 711 b396 +267.4416117 -18.8203101 -0.0422509 -0.9455915 -0.3226012 11583421476673 +9.1629713 +4.4080800 -9.999995E008 -9.999995E008 +17.168127 +0.043248 -9.999995E008 -9.999995E008 +15.933087 +0.036875 +15.755696 +0.057807 +15.804089 +0.0586420 +0.0508400 112 +1.1534620 +0.6666670 +0.2742790 60 +0.6661900 CCD +0.407871 +0.087251 +18.8763572 +0.7143000 +18.8763572 +0.2721000 +6.5473980 +18.3295000 +7.5501638 +0.7416000 +5.5450316 +0.0833000 +0.0529763 +1.8400000 +0.2696970 1 4 1
3 515396195318 515396195318 711 b396 +267.1780292 -18.6730953 -0.0466412 -0.9462119 -0.3201682 11582867489809 +9.1622771 +4.6978580 -9.999995E008 -9.999995E008 +17.416410 +0.054434 +16.797220 +0.039836 +16.212208 +0.047806 +16.047613 +0.075968 +16.064651 +0.0865700 +0.0609100 112 +1.4212770 +0.6666670 +0.2235520 60 +0.6661900 CCD +0.377018 +0.075769 +10.2886600 +0.7321000 +10.5826981 +0.2721000 +1.0027554 +8.1362000 +3.0082871 +0.7907000 +21.7658676 +0.0972000 +0.0944939 +1.3260000 +0.4293820 1 876 828
4 515396195351 515396195351 711 b396 +266.9810107 -18.5634412 -0.0499268 -0.9466561 -0.3183545 11582857010508 +9.1610741 +4.9143813 -9.999995E008 -9.999995E008 +15.008060 +0.007031 +14.395734 +0.005289 +13.690892 +0.005314 +13.440636 +0.007703 +13.437621 +0.0100040 +0.0106200 114 +0.9419960 +0.6885250 +0.3941550 61 +0.6652330 CCD +0.361493 +0.090119 +28.3237963 +0.7168000 +21.4939356 +0.3810000 +12.3585125 +571.8703000 +12.4377483 +0.7787000 +17.0007990 +0.0751000 +0.0588208 +2.0840000 +0.0459460 2 9 1
5 515396195377 515396195377 711 b396 +267.1640785 -18.6663535 -0.0468734 -0.9462381 -0.3200567 11582867306005 +9.1613196 +4.7126641 -9.999995E008 -9.999995E008 +15.722280 +0.012427 +15.216176 +0.010061 +14.639243 +0.011698 +14.415004 +0.017431 +14.488528 +0.0310270 +0.0203880 106 +1.5218270 +0.6792450 +0.0113190 53 +0.6736250 CCD +0.406129 +0.080997 +20.2161749 +0.7547000 +17.3865908 +0.4047000 +15.9369084 +2.1330000 +13.1202417 +0.8925000 +15.3901147 +0.0701000 +0.0762181 +1.1120000 +0.4883270 3 11 2
6 515396195398 515396195398 711 b396 +266.9688897 -18.5557456 -0.0501293 -0.9466882 -0.3182272 11582856979914 +9.1618090 +4.9281915 -9.999995E008 -9.999995E008 +16.482290 +0.023973 +16.018980 +0.020351 +15.581948 +0.027615 +15.449778 +0.045150 +15.390573 +0.0500670 +0.0380450 114 +1.3159940 +0.7049180 +0.4031040 61 +0.6652330 CCD +0.350947 +0.088131 +0.0086456 +0.7719000 +0.0086456 +0.4246000 +0.9938331 +42.5356000 +0.0030525 +0.5782000 +0.0029193 +0.0887000 +327.6003276 +2.0290000 +0.2451100 1 1 1
7 515396195424 515396195424 711 b396 +267.3570153 -18.7742413 -0.0436590 -0.9457869 -0.3218401 11582893659602 +9.1617897 +4.5004621 -9.999995E008 -9.999995E008 +13.553273 +0.002524 +12.846021 +0.001802 +12.027012 +0.001507 +11.684766 +0.001947 +11.687169 +0.0068630 +0.0061450 113 +1.1168430 +0.6833330 +0.8547880 60 +0.6661900 CCD +0.414850 +0.088371 +12.1415795 +0.7321000 +10.1311206 +1.1398000 +16.2595779 +837.6339000 +15.2593423 +0.7841000 +6.0619954 +0.0531000 +0.0655336 +1.1530000 +0.0315790 2 12 3
8 515396195515 515396195515 711 b396 +267.1820418 -18.6750000 -0.0465744 -0.9462045 -0.3201997 11582867496102 +9.1625818 +4.6936171 -9.999995E008 -9.999995E008 +17.375187 +0.052441 +16.842833 +0.041503 +16.411743 +0.057327 +15.935311 +0.068569 +15.778522 +0.0902660 +0.0499400 75 +1.8074890 +0.9428570 +0.6135130 35 +0.7021280 CCD +0.372358 +0.075020 +26.9619381 +0.8133000 +26.9619381 +0.5993000 +1.0027548 +13.3349000 +24.3686730 +0.5973000 +20.7770982 +0.0862000 +0.0481299 +2.3480000 +0.4227110 1 915 817
9 515396195527 515396195527 711 b396 +266.8741282 -18.5024102 -0.0517111 -0.9468994 -0.3173445 11581728806725 +9.1616267 +5.0326784 -9.999995E008 -9.999995E008 +17.323948 +0.050837 +16.664177 +0.036042 +16.256590 +0.050912 +15.948143 +0.070974 +16.020056 +0.1031220 +0.0590660 56 +1.7458770 -9.9999950E008 -9.9999950E008 -999 -9.9999950E008 NCD +0.378097 +0.000960 +26.8711842 +0.7857000 +26.3402376 +0.4477000 +29.2218910 +12.2315000 +29.2218910 +0.6599000 +7.0330669 +0.1130000 +0.1421855 +2.3550000 +0.3839610 3 63 24
10 515396195532 515396195532 711 b396 +267.8827112 -19.0643960 -0.0349189 -0.9445068 -0.3266306 11583477555767 +9.1648819 +3.9247172 -9.999995E008 -9.999995E008 +17.788671 +0.075012 +17.156244 +0.055665 +16.595707 +0.067598 +16.193579 +0.089057 +16.174374 +0.1583660 +0.0656720 56 +2.4114690 -9.9999950E008 -9.9999950E008 -999 -9.9999950E008 NCD +0.454907 +0.082257 +20.0593500 +0.7857000 +6.7464543 +0.6153000 +28.7985145 +7.2920000 +28.7985145 +0.5821000 +16.2389080 +0.1040000 +0.0615805 +2.7780000 +0.5774520 2 24 3
11 515396195582 515396195582 711 b396 +267.1668087 -18.6663499 -0.0468284 -0.9462404 -0.3200566 11582867294759 +9.1626483 +4.7104422 -9.999995E008 -9.999995E008 +16.908230 +0.034561 +16.391960 +0.027748 +15.875266 +0.035212 +15.584623 +0.049837 +15.715080 +0.0592650 +0.0477740 114 +1.2405280 +0.6885250 +0.2284150 61 +0.6652330 CCD +0.401624 +0.079921 +18.1421942 +0.7018000 +2.4829337 +0.2443000 +11.3383015 +13.1506000 +15.8474185 +0.8231000 +9.2661851 +0.0958000 +0.1079193 +1.5000000 +0.3148320 1 1 1
12 515396195600 515396195600 711 b396 +267.8099613 -19.0245319 -0.0361268 -0.9446886 -0.3259730 11583477851920 +9.1643327 +4.0042023 -9.999995E008 -9.999995E008 +17.023235 +0.037768 +16.537940 +0.031957 +16.035227 +0.040805 +15.858101 +0.065415 +15.849639 +0.0661080 +0.0524800 154 +1.2596800 +0.6666670 +0.2654090 60 +0.6661900 CCD +0.450285 +0.091693 +27.9118160 +0.6883000 +27.9118160 +0.2524000 +21.6765913 +9.2662000 +13.6705119 +0.8186000 +18.5197858 +0.0726000 +0.0731502 +1.1950000 +0.3009800 1 36 6
13 515396195606 515396195606 711 b396 +267.8435704 -19.0444295 -0.0355684 -0.9445964 -0.3263013 11583478557477 +9.1633123 +3.9667283 -9.999995E008 -9.999995E008 +15.706235 +0.012098 +15.205806 +0.010079 +14.668349 +0.011968 +14.406785 +0.017739 +14.341351 +0.0610380 +0.0184850 97 +3.3020290 -9.9999950E008 -9.9999950E008 -999 -9.9999950E008 NCD +0.442752 +0.074241 +2.0055493 +0.8351000 +3.0083533 +1.4707000 +2.0055493 +49.8956000 +2.0055493 +0.4213000 +0.6685223 +0.0883000 +1.4958365 +2.3050000 +0.2741370 3 822 47
14 515396195651 515396195651 711 b396 +267.4212878 -18.8153389 -0.0425876 -0.9456044 -0.3225191 11583418016699 +9.1574311 +4.4271663 -9.999995E008 -9.999995E008 +16.461285 +0.023177 +15.692802 +0.015062 +14.980350 +0.015698 +14.569196 +0.019846 +14.722323 +0.0735560 +0.0238900 113 +3.0789450 +0.8666670 +1.7408840 60 +0.6661900 CCD +0.404617 +0.093127 +29.0619545 +0.8584000 +3.0082871 +1.4714000 +2.0055213 +35.7234000 +2.0056544 +0.3798000 +1.0028886 +0.0655000 +0.4985904 +3.6590000 +0.3093680 3 755 495
15 515396195660 515396195660 711 b396 +267.4200938 -18.8126393 -0.0426080 -0.9456187 -0.3224745 11583418061406 +9.1591832 +4.4295143 -9.999995E008 -9.999995E008 +14.291342 +0.004096 +13.606822 +0.002943 +12.886740 +0.002757 +12.579558 +0.003711 +12.575136 +0.0105140 +0.0070250 114 +1.4966550 +0.6721310 +0.7796750 61 +0.6652330 CCD +0.404708 +0.093898 +29.6108789 +0.7522000 +4.3008296 +0.7999000 +5.0407190 +575.4458000 +20.3356279 +0.7555000 +27.5691252 +0.0745000 +0.2325133 +1.4970000 +0.0452490 1 17 4
16 515396195665 515396195665 711 b396 +267.4229354 -18.8117672 -0.0425613 -0.9456257 -0.3224601 11583418062117 +9.1613106 +4.4276443 -9.999995E008 -9.999995E008 +15.831860 +0.013530 +15.287381 +0.010679 +14.660253 +0.011844 +14.419453 +0.017378 +14.411216 +0.0312460 +0.0193610 112 +1.6138630 +0.7833330 +0.8445310 60 +0.6661900 CCD +0.405176 +0.092968 +16.1823396 +0.7477000 +0.7627841 +0.6374000 +4.3202724 +66.4035000 +3.3175065 +0.6596000 +0.7627841 +0.0633000 +1.3109869 +1.8130000 +0.2089160 1 63 28
17 515396195670 515396195670 711 b396 +267.4519852 -18.8253549 -0.0420785 -0.9455708 -0.3226846 11583419352832 +9.1636341 +4.3970609 -9.999995E008 -9.999995E008 +17.342358 +0.050557 +16.736343 +0.037715 +16.277502 +0.050401 +15.972200 +0.070400 +16.167421 +0.0976130 +0.0653610 91 +1.4934440 +0.7500000 +0.3683990 44 +0.6856800 CCD +0.410032 +0.086819 +29.4153862 +0.6923000 +13.2262445 +0.3198000 +28.0173735 +3.4202000 +15.0328211 +0.7504000 +3.6241957 +0.0871000 +0.0356921 +1.6170000 +0.6721440 4 49 27
18 515396195683 515396195683 711 b396 +267.2273184 -18.7007941 -0.0458197 -0.9460970 -0.3206261 11582867597279 +9.1623013 +4.6435694 -9.999995E008 -9.999995E008 +14.873353 +0.006304 +14.554885 +0.005899 +14.225100 +0.008181 +14.049885 +0.012692 +14.046879 +0.0147820 +0.0152780 123 +0.9675350 +0.6708860 +0.2763130 79 +0.6512580 CCD +0.362703 +0.088207 +24.1987377 +0.7377000 +16.5495601 +0.2946000 +15.3588560 +340.7850000 +24.6583927 +0.7702000 +16.5495601 +0.0988000 +0.0651090 +1.4140000 +0.0626940 3 13 2
19 515396195688 515396195688 711 b396 +267.2545894 -18.7157074 -0.0453654 -0.9460353 -0.3208727 11582864802863 +9.1626621 +4.6137453 -9.999995E008 -9.999995E008 +17.062073 +0.039316 +16.463882 +0.029509 +15.836906 +0.034011 +15.356580 +0.040786 +15.465451 +0.1318690 +0.0401000 100 +3.2885040 +0.6800000 +0.4215330 50 +0.6772790 CCD +0.382584 +0.083530 +23.8625348 +0.7400000 +6.2871909 +0.7198000 +9.2683874 +5.6905000 +8.8302492 +0.7563000 +23.8625348 +0.1232000 +0.1078936 +1.2970000 +0.4802840 2 3 1
20 515396195760 515396195760 711 b396 +267.2217815 -18.6967792 -0.0459122 -0.9461150 -0.3205597 11582868064829 +9.1630789 +4.6501288 -9.999995E008 -9.999995E008 +17.462473 +0.056705 +16.948637 +0.045636 +16.463526 +0.060098 +16.315830 +0.097265 +16.377270 +0.0915860 +0.0753480 109 +1.2155070 +0.6896550 +0.2218530 58 +0.6681760 CCD +0.361527 +0.088200 +26.5912620 +0.7615000 +15.7930854 +0.2408000 +4.5505223 +5.4785000 +28.9812538 +0.7977000 +15.7930854 +0.0899000 +0.0633188 +1.8760000 +0.4973680 1 1 1
21 515396195772 515396195772 711 b396 +266.9663555 -18.5537188 -0.0501718 -0.9466972 -0.3181936 11582856919099 +9.1623228 +4.9312928 -9.999995E008 -9.999995E008 +18.130281 +0.104732 +17.486074 +0.075600 +17.207565 +0.121192 +16.845755 +0.161392 +16.496841 +0.1928990 +0.0816000 70 +2.3639580 +0.9333330 +1.0148610 30 +0.7143170 CCD +0.351101 +0.087542 +29.8845014 +0.8571000 +10.4017848 +0.8875000 +22.7704259 +3.7158000 +27.8869610 +0.5348000 +7.4676589 +0.0912000 +0.1339108 +3.0510000 +0.9361690 2 32 7
22 515396195789 515396195789 711 b396 +267.7435748 -18.9871227 -0.0372297 -0.9448585 -0.3253556 11583478937875 +9.1646866 +4.0772713 -9.999995E008 -9.999995E008 +17.617496 +0.064325 +16.970583 +0.047090 +16.294160 +0.051658 +16.061111 +0.078717 +16.284400 +0.0947920 +0.0707760 105 +1.3393240 +0.7407410 +0.2541010 54 +0.6724740 CCD +0.531548 +0.094735 +25.8371235 +0.7524000 +14.7595574 +0.2929000 +22.8790309 +6.7278000 +19.4215529 +0.7762000 +11.0685002 +0.0730000 +0.0514892 +1.4020000 +0.4203490 2 22 4
23 515396195805 515396195805 711 b396 +267.4836622 -18.8431143 -0.0415513 -0.9454939 -0.3229779 11583419612122 +9.1636203 +4.3622148 -9.999995E008 -9.999995E008 +17.216343 +0.044829 +16.668224 +0.035455 +16.104822 +0.042991 +15.909424 +0.066789 +16.003132 +0.0602750 +0.0583790 64 +1.0324770 +0.7391300 +0.1621410 23 +0.7376630 CCD +0.416908 +0.088437 +13.4774257 +0.7500000 +27.0789455 +0.2408000 +6.0976785 +20.6119000 +8.9073213 +0.6798000 +29.2995858 +0.1088000 +0.1122672 +2.3510000 +0.2692410 2 2 1
24 515396195806 515396195806 711 b396 +267.4816016 -18.8464397 -0.0415845 -0.9454737 -0.3230329 11583419813635 +9.1597541 +4.3621997 -9.999995E008 -9.999995E008 +16.544786 +0.024748 +15.947051 +0.018751 +15.320923 +0.021206 +15.092084 +0.031832 +15.136041 +0.0345820 +0.0318250 110 +1.0866300 +0.6724140 +0.1749900 58 +0.6681760 CCD +0.418959 +0.088755 +19.8767260 +0.7455000 +10.0484224 +0.2501000 +11.9187870 +54.8665000 +5.9595881 +0.8080000 +10.0484224 +0.0900000 +0.1677968 +1.3950000 +0.1453740 2 3 1
25 515396195896 515396195896 711 b396 +267.5797313 -18.8961813 -0.0399532 -0.9452630 -0.3238544 11583423424607 +9.1642155 +4.2569549 -9.999995E008 -9.999995E008 +16.552250 +0.025245 +15.937427 +0.020709 +15.277009 +0.023711 +15.038735 +0.033506 +14.992872 +0.0687860 +0.0288000 114 +2.3884030 +0.8032790 +0.8970680 61 +0.6652330 CCD +0.459644 +0.074416 +18.9800962 +0.7895000 +2.0053881 +0.8452000 +1.0026223 +30.5596000 +2.0052549 +0.5377000 +1.5040052 +0.0900000 +0.4986897 +2.0530000 +0.3215630 3 156 137
26 515396195926 515396195926 711 b396 +267.0203309 -18.5873667 -0.0492702 -0.9465573 -0.3187503 11582871278579 +9.1595779 +4.8701163 -9.999995E008 -9.999995E008 +15.801641 +0.013318 +15.147840 +0.009645 +14.437334 +0.009984 +14.171914 +0.014485 +14.184760 +0.0183430 +0.0166870 114 +1.0992390 +0.6721310 +0.3299410 61 +0.6652330 CCD +0.412189 +0.085312 +28.1394898 +0.6637000 +28.1394898 +0.3106000 +8.4310796 +96.3608000 +2.3036876 +0.7191000 +8.2501023 +0.0694000 +0.0355372 +1.3780000 +0.0990520 2 5 1
27 515396195934 515396195934 711 b396 +267.0209889 -18.5889814 -0.0492588 -0.9465489 -0.3187770 11582871281646 +9.1585055 +4.8687545 -9.999995E008 -9.999995E008 +17.041180 +0.039024 +16.486542 +0.030649 +15.628888 +0.028696 +15.620344 +0.053047 +15.689879 +0.0512510 +0.0469380 81 +1.0918870 +0.8250000 +0.5116920 40 +0.6923030 CCD +0.412696 +0.084613 +28.0800963 +0.7284000 +2.6753635 +0.5847000 +23.0604077 +9.4324000 +17.0572628 +0.6306000 +1.8045686 +0.0661000 +0.0586260 +2.9040000 +0.5834670 1 47 29
28 515396195988 515396195988 711 b396 +267.5941030 -18.9039743 -0.0397143 -0.9452289 -0.3239830 11583423466995 +9.1644241 +4.2412845 -9.999995E008 -9.999995E008 +17.723495 +0.071476 +17.236094 +0.061985 +16.711592 +0.079647 +16.522415 +0.122066 +16.632084 +0.1490660 +0.0891760 80 +1.6715930 +0.7631580 +0.3446730 38 +0.6959990 CCD +0.465304 +0.074217 +28.5334577 +0.7750000 +10.9861476 +0.3470000 +10.3826596 +4.2548000 +11.1458398 +0.6919000 +1.7554332 +0.0934000 +0.0350466 +1.6960000 +0.6451030 3 3 1
29 515396196058 515396196058 711 b396 +267.3709854 -18.7800740 -0.0434269 -0.9457648 -0.3219365 11582893645120 +9.1635204 +4.4861100 -9.999995E008 -9.999995E008 +17.073284 +0.040032 +16.706343 +0.036739 +16.210460 +0.047683 +16.114304 +0.080998 +15.805475 +0.1434980 +0.0508890 110 +2.8198240 +0.7413790 +0.9543310 58 +0.6681760 CCD +0.412907 +0.086212 +29.6313870 +0.7273000 +1.0064842 +0.9027000 +0.0031857 +4.7271000 +0.0031857 +0.6241000 +4.9568222 +0.0764000 +0.0337480 +2.3570000 +0.6134290 2 31 31
30 515396196065 515396196065 711 b396 +267.4902501 -18.8460777 -0.0414418 -0.9454820 -0.3230269 11583419818818 +9.1642466 +4.3553399 -9.999995E008 -9.999995E008 +17.616095 +0.063897 +16.953985 +0.045786 +16.341640 +0.053234 +16.154140 +0.083523 +16.302002 +0.0818580 +0.0716240 94 +1.1428850 +0.8085110 +0.2294480 47 +0.6812790 CCD +0.416766 +0.088484 +26.4141412 +0.7872000 +26.4141412 +0.2808000 +9.9087172 +9.1049000 +9.9085863 +0.7189000 +19.1273462 +0.0829000 +0.1009226 +2.0860000 +0.3997710 3 4 2

(Query returned at least (i.e. before it was halted) 16000000 result rows, only the first 30 rows are shown in the displayed table.)

NB The number of rows written to the output file reached the maximum allowed 8000000

Download Results File , your results in a gzipped FITS file (Contains 8000000 rows, 1,754 MB)
Launch file in Topcat (requires Java 1.5 and Java Web Start, approx 12Mb download for Topcat application)