44
'ExtraGalactic_NewsLetter_lvra' filter results
'ExtraGalactic_NewsLetter_lvra' filter results
(IN DEV!) Extra-Galactic Transient candidates received in the past 24h. This filter uses the r0b_lvra annotator (score >0.9) to select most likely candidates. The filter is streamed via kafka with the topic name lasair_18ExtraGalactic_NewsLetter_lvra .
Your kafka stream has produced 80 alerts today (46,116 bytes of your quota of 100,000,000)

SELECT objects.diaObjectId,
       r0b_lvra.classification AS r0b_score,
       objects.lastDiaSourceMjdTai AS latest_MJD,
       objects.timestamp AS Alert_arrival_time,
       objects.latestR,
       objects.nDiaSources,
       objects.ebv,
       objects.ra,
       objects.decl,
       objects.tns_name,
       objects.firstDiaSourceMjdTai,
       sherlock_classifications.separationArcsec,
       sherlock_classifications.direct_distance,
       sherlock_classifications.distance,
       sherlock_classifications.z,
       sherlock_classifications.photoZ,
       sherlock_classifications.photoZErr,
       sherlock_classifications.physical_separation_kpc,
       sherlock_classifications.classification AS sherlock_classifications,
       r0b_lvra.timestamp AS VRAtimestamp
FROM objects,
     sherlock_classifications,
     annotations AS r0b_lvra
WHERE objects.diaObjectId=sherlock_classifications.diaObjectId
  AND objects.diaObjectId=r0b_lvra.diaObjectId
  AND r0b_lvra.topic="r0b_lvra"
  AND objects.nDiaSources > 2
  AND r0b_lvra.classification>0.9
  AND mjdnow() - objects.lastDiaSourceMjdTai < 1
  AND sherlock_classifications.classification IN ("SN",
                                                  "NT",
                                                  "ORPHAN",
                                                  "UNCLEAR")

Filter Results

A list of objects passing the 'ExtraGalactic_NewsLetter_lvra' filter.
diaObjectId r0b_score latest_MJD Alert_arrival_time latestR nDiaSources ebv ra decl tns_name firstDiaSourceMjdTai separationArcsec direct_distance distance z photoZ photoZErr physical_separation_kpc sherlock_classifications VRAtimestamp
170019695992242795 0.9785313315961414 61099.0424163051 Feb. 28, 2026, 1:04 a.m. 0.943659 4 0.0106804 52.82386 -29.691605 None 61088.09394479483 3.123 None None 0.109912 None None 6.259 SN Feb. 28, 2026, 1:06 a.m.
170028485704679570 0.9135905293731879 61099.04033165692 Feb. 28, 2026, 1:01 a.m. 0.810919 248 0.0115243 64.83291 -46.986095 None 61090.04758412875 0.08 None None None None None None SN Feb. 28, 2026, 1:06 a.m.
313893023209488448 0.976257813742284 61099.03989788437 Feb. 28, 2026, 1:01 a.m. 0.975267 323 0.0136393 61.89895 -48.341054 None 61033.285258179065 0.329 None None None None None None SN Feb. 28, 2026, 1:06 a.m.
313664313300090962 0.9856678265115657 61099.04427907211 Feb. 28, 2026, 1:08 a.m. 0.915568 435 0.0136235 61.97601 -47.738266 None 60981.278783090966 1.234 None None None None None None SN Feb. 28, 2026, 1:10 a.m.
170019696482451458 0.9047225609821405 61099.04427907211 Feb. 28, 2026, 1:08 a.m. 0.768897 264 0.0157381 61.62061 -47.420835 None 61088.09847637328 0.43 None None None None None None SN Feb. 28, 2026, 1:10 a.m.
170019696438935593 0.9795067230724848 61099.04427907211 Feb. 28, 2026, 1:08 a.m. 0.976508 360 0.0156763 62.95295 -47.749222 None 61088.09847637328 0.709 None None None None None None SN Feb. 28, 2026, 1:10 a.m.
314051320244339039 0.9793991630923944 61099.043839907725 Feb. 28, 2026, 1:08 a.m. 0.999243 87 0.00700003 58.98985 -50.843221 None 61069.07776294004 2.576 None None None None None None SN Feb. 28, 2026, 1:10 a.m.
170028486051233796 0.911260203987765 61099.043839907725 Feb. 28, 2026, 1:07 a.m. 0.773346 111 0.011832 58.01783 -50.550772 None 61090.05311199976 5.807 None None None None None None SN Feb. 28, 2026, 1:10 a.m.
170019696299475118 0.9752613335744604 61099.04427907211 Feb. 28, 2026, 1:08 a.m. 0.998896 421 0.00988322 60.15059 -48.419644 None 61088.098045202045 0.701 None None None None None None SN Feb. 28, 2026, 1:10 a.m.
313998539799134474 0.9047607061639598 61099.04427907211 Feb. 28, 2026, 1:08 a.m. 0.999973 204 0.0161996 63.01385 -49.470959 None 61057.177794279196 1.051 None None None None None None SN Feb. 28, 2026, 1:10 a.m.
170019696442081285 0.929678133880307 61099.04427907211 Feb. 28, 2026, 1:08 a.m. 0.954434 362 0.0151955 62.67004 -48.379963 None 61088.09847637328 0.316 None None None None None None SN Feb. 28, 2026, 1:10 a.m.
314051320318263356 0.9753974819685193 61099.043839907725 Feb. 28, 2026, 1:07 a.m. 0.998544 122 0.00971709 56.86212 -48.948286 None 61069.07776294004 0.342 None None None None None None SN Feb. 28, 2026, 1:10 a.m.
170028485826838677 0.9593619647676709 61099.043839907725 Feb. 28, 2026, 1:08 a.m. 0.910087 353 0.0108966 57.80999 -48.975734 None 61090.04802149777 0.545 None None None None None None SN Feb. 28, 2026, 1:10 a.m.
313637935719645190 0.9128871498586827 61099.043839907725 Feb. 28, 2026, 1:08 a.m. 0.60259 316 0.00821675 58.98699 -48.120597 2025able 60975.20468840409 0.998 None None None None None None SN Feb. 28, 2026, 1:10 a.m.
170019696345088120 0.9767985232898967 61099.043839907725 Feb. 28, 2026, 1:08 a.m. 0.997773 338 0.00782946 58.08645 -48.019421 None 61088.098045202045 0.429 None None None None None None SN Feb. 28, 2026, 1:10 a.m.
170028485772837139 0.9886462322244683 61099.043839907725 Feb. 28, 2026, 1:08 a.m. 0.999952 101 0.0122589 61.27173 -50.239290 None 61090.04802149777 0.147 None None None None None None SN Feb. 28, 2026, 1:11 a.m.
314051320305156133 0.9467864139050101 61099.043839907725 Feb. 28, 2026, 1:08 a.m. 1.0 449 0.0113482 60.37767 -48.821995 2026dmz 61069.07776294004 1.369 None None None None None None SN Feb. 28, 2026, 1:11 a.m.
170019696272736349 0.9255502091226007 61099.04427907211 Feb. 28, 2026, 1:08 a.m. 0.883854 450 0.0113021 61.49711 -49.245788 None 61088.098045202045 1.56 None None None None None None SN Feb. 28, 2026, 1:11 a.m.
170046083740205236 0.9778248779385166 61099.043839907725 Feb. 28, 2026, 1:08 a.m. 0.996869 137 0.00931332 56.87561 -49.855856 None 61094.096463297436 0.193 None None None None None None SN Feb. 28, 2026, 1:11 a.m.
313699514821640259 0.9824386752142933 61099.04320692332 Feb. 28, 2026, 1:08 a.m. 0.999781 120 0.0114528 51.62055 -28.114118 2025aijl 60989.260516038936 2.022 None None None None None None SN Feb. 28, 2026, 1:11 a.m.
313756671181062188 0.9520174450237818 61099.04320692332 Feb. 28, 2026, 1:07 a.m. 0.930604 78 0.0103821 53.92386 -29.222971 None 61002.22660231944 0.393 None None None None None None SN Feb. 28, 2026, 1:11 a.m.
170028485836800148 0.959833006671407 61099.04427907211 Feb. 28, 2026, 1:08 a.m. 0.744651 141 0.0138462 60.77927 -48.726763 None 61090.04802149777 2.036 None None None None None None SN Feb. 28, 2026, 1:11 a.m.
313761043604045880 0.958823576264925 61099.04427907211 Feb. 28, 2026, 1:08 a.m. 1.0 651 0.0127092 61.96482 -48.713443 2025agpz 61003.336679130254 0.093 None None None None None None SN Feb. 28, 2026, 1:11 a.m.
170019696466198671 0.953390990899688 61099.04427907211 Feb. 28, 2026, 1:08 a.m. 0.929922 367 0.0153188 61.85109 -47.356484 None 61088.09847637328 0.514 None None None None None None SN Feb. 28, 2026, 1:11 a.m.
170019696437887107 0.9288258699652961 61099.04427907211 Feb. 28, 2026, 1:08 a.m. 0.923776 327 0.0129493 63.49543 -47.280030 None 61088.09847637328 0.519 None None None None None None SN Feb. 28, 2026, 1:11 a.m.
170028485646483572 0.9253901415098831 61099.04427907211 Feb. 28, 2026, 1:08 a.m. 0.609018 380 0.0121657 62.15138 -49.001441 2025rha 61090.04758412875 5.147 None None None None None None SN Feb. 28, 2026, 1:11 a.m.
313831458352922664 0.9291026791895142 61099.043839907725 Feb. 28, 2026, 1:08 a.m. 0.999983 672 0.0114813 61.15741 -48.502014 None 61019.28926317879 None None None None None None None ORPHAN Feb. 28, 2026, 1:11 a.m.
170019696328835126 0.9214769640168358 61099.043839907725 Feb. 28, 2026, 1:08 a.m. 0.905992 353 0.00668884 58.79311 -49.039451 None 61088.098045202045 0.12 None None None None None None SN Feb. 28, 2026, 1:11 a.m.
313994139532263447 0.9760428659244775 61099.04320692332 Feb. 28, 2026, 1:08 a.m. 1.0 41 0.00716686 53.25136 -27.861038 2023aefc 61056.11907005917 1.849 None None 0.01 None None 0.388 SN Feb. 28, 2026, 1:11 a.m.
313928193953234970 0.9151491212401592 61099.04320692332 Feb. 28, 2026, 1:07 a.m. 0.970421 74 0.0108377 54.64841 -27.699329 None 61041.22012609638 0.553 None None None None None None SN Feb. 28, 2026, 1:11 a.m.
170019696041525298 0.9696225811139617 61099.04320692332 Feb. 28, 2026, 1:08 a.m. 0.9985 7 0.0151981 51.58988 -28.798757 None 61088.09394479483 0.25 None None None None None None SN Feb. 28, 2026, 1:11 a.m.
170028510630903956 0.9276262883962016 61099.315350998135 Feb. 28, 2026, 7:38 a.m. 0.59455 890 0.0236092 150.60763 2.977954 2025ifv 61090.18106558244 1.176 None None 0.103562 None None 2.237 NT Feb. 28, 2026, 7:40 a.m.
170028512626868461 0.9327242048275329 61099.315350998135 Feb. 28, 2026, 7:38 a.m. 0.776946 153 0.0233753 149.97176 3.382108 None 61090.189604142084 2.067 None None None None None None SN Feb. 28, 2026, 7:41 a.m.
170059283425656877 0.9755290823079469 61099.314880045866 Feb. 28, 2026, 7:38 a.m. 0.706664 22 0.022679 150.84283 2.963673 2018drj 61097.18844818038 2.226 None None 0.084629 0.076133 0.014447 3.537 SN Feb. 28, 2026, 7:41 a.m.
170028500582924412 0.968649894954816 61099.315350998135 Feb. 28, 2026, 7:38 a.m. 0.690127 944 0.0206769 149.90239 2.157240 None 61090.1077735384 1.039 None None 0.3115 None None 4.747 NT Feb. 28, 2026, 7:41 a.m.
313871013236965412 0.9342934977089 61099.314880045866 Feb. 28, 2026, 7:38 a.m. 0.897865 1023 0.0204358 149.29356 1.680092 2026bbz 61028.31880498472 0.105 None None None 0.646268 0.169686 None SN Feb. 28, 2026, 7:42 a.m.
170028500567196157 0.9577988575784174 61099.31781569319 Feb. 28, 2026, 7:41 a.m. 0.979101 237 0.0296675 149.63381 3.870647 None 61090.1077735384 2.964 None None None None None None SN Feb. 28, 2026, 7:45 a.m.
170019716323082348 0.9709773409596024 61099.31781569319 Feb. 28, 2026, 7:41 a.m. 0.998163 958 0.0188734 150.29185 2.416635 None 61088.211979366155 0.706 None None None 0.707169 0.075584 None SN Feb. 28, 2026, 7:45 a.m.
170019717277810735 0.9510050993252603 61099.31781569319 Feb. 28, 2026, 7:41 a.m. 1.0 649 0.0333571 151.74028 1.927048 2026ctw 61088.21785947578 0.2 None None None None None None SN Feb. 28, 2026, 7:45 a.m.
170028510676516998 0.9011534040433363 61099.317347570504 Feb. 28, 2026, 7:41 a.m. 0.902025 254 0.0348187 151.33658 2.186835 None 61090.180597784965 1.882 None None 2.388 None None 15.331 SN Feb. 28, 2026, 7:45 a.m.
313853517419249797 0.969014549306188 61099.317347570504 Feb. 28, 2026, 7:41 a.m. 0.999748 1160 0.0207994 149.44407 2.548380 None 61024.24593270644 0.036 None None None 0.652215 0.168226 None SN Feb. 28, 2026, 7:45 a.m.
170028510880989380 0.9650322796652998 61099.31781569319 Feb. 28, 2026, 7:41 a.m. 0.91638 887 0.0317488 149.44422 3.598054 None 61090.1077735384 0.797 None None None None None None SN Feb. 28, 2026, 7:46 a.m.
313853517419249672 0.9054480671939095 61099.317347570504 Feb. 28, 2026, 7:41 a.m. 0.985781 1151 0.0189609 149.52558 2.744415 None 61024.24593270644 3.761 None None 0.878 None None 29.087 SN Feb. 28, 2026, 7:46 a.m.
313871015514997074 0.9409859815537173 61099.31781569319 Feb. 28, 2026, 7:41 a.m. 0.643394 583 0.0253847 149.91657 0.587597 None 61028.33159580127 3.155 None None 0.065502 None None 3.967 SN Feb. 28, 2026, 7:46 a.m.
Need Help?

Start with our documentation on readthedocs, you might find the FAQ section especially useful.

If you still have questions, want to report a bug, or make a feature request, please reach out to us on the Lasair topic on the Rubin Community pages.

readthedocs Lasair Community
Help