participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,026 rows where station_code = "UK009Q" sorted by created_at descending
This data as json, copyable, CSV (advanced)
Suggested facets: created_at (date), updated_at (date)
Link | rowid | meteor_unique_trajectory_identifier | station_code | created_at ▲ | updated_at |
---|---|---|---|---|---|
5133863 | 5133863 | 20240916041204_CZ7XD | UK009Q | 2024-09-19T12:17:11.045Z | 2024-09-19T12:17:11.045Z |
5133860 | 5133860 | 20240916041202_sk2gP | UK009Q | 2024-09-19T12:17:11.016Z | 2024-09-19T12:17:11.016Z |
5133743 | 5133743 | 20240916040213_Ykxtc | UK009Q | 2024-09-19T12:17:06.962Z | 2024-09-19T12:17:06.962Z |
5133220 | 5133220 | 20240916030723_14w1x | UK009Q | 2024-09-19T12:16:49.677Z | 2024-09-19T12:16:49.677Z |
5133175 | 5133175 | 20240916030358_vp9Bg | UK009Q | 2024-09-19T12:16:46.198Z | 2024-09-19T12:16:46.198Z |
5133082 | 5133082 | 20240916025054_LT4mp | UK009Q | 2024-09-19T12:16:43.641Z | 2024-09-19T12:16:43.641Z |
5132994 | 5132994 | 20240916024219_Yo3GA | UK009Q | 2024-09-19T12:16:40.412Z | 2024-09-19T12:16:40.412Z |
5132991 | 5132991 | 20240916024130_Gogi0 | UK009Q | 2024-09-19T12:16:40.318Z | 2024-09-19T12:16:40.318Z |
5131604 | 5131604 | 20240915202455_nbfVv | UK009Q | 2024-09-19T12:15:11.052Z | 2024-09-19T12:15:11.052Z |
5129630 | 5129630 | 20240917041514_8JUB3 | UK009Q | 2024-09-19T12:11:55.480Z | 2024-09-19T12:11:55.480Z |
5129580 | 5129580 | 20240917041057_tYJFJ | UK009Q | 2024-09-19T12:11:50.066Z | 2024-09-19T12:11:50.066Z |
5129557 | 5129557 | 20240917040933_iY0nJ | UK009Q | 2024-09-19T12:11:48.950Z | 2024-09-19T12:11:48.950Z |
5129206 | 5129206 | 20240917033625_JsPFf | UK009Q | 2024-09-19T12:11:23.052Z | 2024-09-19T12:11:23.052Z |
5129157 | 5129157 | 20240917033052_oe73K | UK009Q | 2024-09-19T12:11:17.998Z | 2024-09-19T12:11:17.998Z |
5125906 | 5125906 | 20240918043221_RqUYE | UK009Q | 2024-09-19T12:04:31.444Z | 2024-09-19T12:06:42.105Z |
5125824 | 5125824 | 20240918040151_q8sKB | UK009Q | 2024-09-19T12:04:10.270Z | 2024-09-19T12:06:42.090Z |
5125797 | 5125797 | 20240918035553_4Km7b | UK009Q | 2024-09-19T12:04:07.455Z | 2024-09-19T12:06:42.087Z |
5125658 | 5125658 | 20240918031350_n3yTp | UK009Q | 2024-09-19T12:03:48.574Z | 2024-09-19T12:06:42.063Z |
5111718 | 5111718 | 20240914210533_16Roy | UK009Q | 2024-09-18T12:02:12.829Z | 2024-09-19T12:18:33.612Z |
5107399 | 5107399 | 20240913035416_hTfQg | UK009Q | 2024-09-17T12:13:14.356Z | 2024-09-19T12:20:47.043Z |
5106833 | 5106833 | 20240913033616_VaHVL | UK009Q | 2024-09-17T12:13:02.504Z | 2024-09-19T12:20:46.476Z |
5106119 | 5106119 | 20240913031146_n7YuO | UK009Q | 2024-09-17T12:12:42.511Z | 2024-09-19T12:20:45.502Z |
5105939 | 5105939 | 20240913030339_ozM9F | UK009Q | 2024-09-17T12:12:34.082Z | 2024-09-19T12:20:45.071Z |
5105833 | 5105833 | 20240913030012_BI2lc | UK009Q | 2024-09-17T12:12:30.310Z | 2024-09-19T12:20:44.977Z |
5105330 | 5105330 | 20240913024145_RLsGW | UK009Q | 2024-09-17T12:12:09.463Z | 2024-09-19T12:20:44.285Z |
5105240 | 5105240 | 20240913023850_B3Vms | UK009Q | 2024-09-17T12:12:05.136Z | 2024-09-19T12:20:44.161Z |
5105113 | 5105113 | 20240913023134_MOgme | UK009Q | 2024-09-17T12:11:56.156Z | 2024-09-19T12:20:43.707Z |
5104411 | 5104411 | 20240913020724_aCtMY | UK009Q | 2024-09-17T12:11:34.712Z | 2024-09-19T12:20:41.449Z |
5104306 | 5104306 | 20240913020236_ZhgY2 | UK009Q | 2024-09-17T12:11:32.397Z | 2024-09-19T12:20:41.345Z |
5104300 | 5104300 | 20240913020228_Yunhp | UK009Q | 2024-09-17T12:11:32.189Z | 2024-09-19T12:20:41.337Z |
5104055 | 5104055 | 20240913015011_H7FwX | UK009Q | 2024-09-17T12:11:23.710Z | 2024-09-19T12:20:40.942Z |
5103885 | 5103885 | 20240913014240_nUDbd | UK009Q | 2024-09-17T12:11:15.065Z | 2024-09-19T12:20:40.641Z |
5103788 | 5103788 | 20240913013943_gybDi | UK009Q | 2024-09-17T12:11:10.450Z | 2024-09-19T12:20:40.463Z |
5103658 | 5103658 | 20240913013531_NpJ3c | UK009Q | 2024-09-17T12:11:07.526Z | 2024-09-19T12:20:40.399Z |
5103318 | 5103318 | 20240913012453_wCHOp | UK009Q | 2024-09-17T12:10:50.234Z | 2024-09-19T12:20:40.011Z |
5097383 | 5097383 | 20240913004442_qIXeC | UK009Q | 2024-09-16T12:17:11.887Z | 2024-09-19T12:20:38.459Z |
5097234 | 5097234 | 20240913003823_Ip3vQ | UK009Q | 2024-09-16T12:17:09.352Z | 2024-09-19T12:20:38.009Z |
5093640 | 5093640 | 20240912033047_JhVCW | UK009Q | 2024-09-16T12:14:23.130Z | 2024-09-19T12:21:15.541Z |
5093347 | 5093347 | 20240912031840_tC1bS | UK009Q | 2024-09-16T12:14:15.872Z | 2024-09-19T12:21:15.267Z |
5092497 | 5092497 | 20240912024809_0wIbx | UK009Q | 2024-09-16T12:13:58.252Z | 2024-09-19T12:21:14.278Z |
5092302 | 5092302 | 20240912024210_4uGnz | UK009Q | 2024-09-16T12:13:47.699Z | 2024-09-19T12:21:13.820Z |
5091742 | 5091742 | 20240912022029_3Wam0 | UK009Q | 2024-09-16T12:13:21.516Z | 2024-09-19T12:21:13.374Z |
5091682 | 5091682 | 20240912021721_Iah29 | UK009Q | 2024-09-16T12:13:17.924Z | 2024-09-19T12:21:13.312Z |
5091113 | 5091113 | 20240912015800_3bOyu | UK009Q | 2024-09-16T12:12:49.589Z | 2024-09-19T12:21:12.569Z |
5089303 | 5089303 | 20240912003512_mVz1R | UK009Q | 2024-09-16T12:11:20.053Z | 2024-09-19T12:21:09.884Z |
5089023 | 5089023 | 20240912002027_5fnLm | UK009Q | 2024-09-16T12:11:12.325Z | 2024-09-19T12:21:09.680Z |
5086274 | 5086274 | 20240912222254_pEnQ8 | UK009Q | 2024-09-16T12:05:27.173Z | 2024-09-19T12:20:30.723Z |
5085851 | 5085851 | 20240912215439_N4Meq | UK009Q | 2024-09-16T12:04:58.577Z | 2024-09-19T12:20:29.646Z |
5085664 | 5085664 | 20240912214020_NaMeV | UK009Q | 2024-09-16T12:04:34.589Z | 2024-09-19T12:20:29.333Z |
5085606 | 5085606 | 20240912213504_3Vo3F | UK009Q | 2024-09-16T12:04:29.124Z | 2024-09-19T12:20:29.250Z |
5085528 | 5085528 | 20240912212453_BqznV | UK009Q | 2024-09-16T12:04:21.239Z | 2024-09-19T12:20:28.987Z |
5085506 | 5085506 | 20240912212433_jzpku | UK009Q | 2024-09-16T12:04:20.607Z | 2024-09-19T12:20:28.955Z |
5085494 | 5085494 | 20240912212255_Zje1y | UK009Q | 2024-09-16T12:04:18.970Z | 2024-09-19T12:20:28.818Z |
5085340 | 5085340 | 20240912211103_v2jhs | UK009Q | 2024-09-16T12:04:05.292Z | 2024-09-19T12:20:28.465Z |
5085305 | 5085305 | 20240912210725_98iHr | UK009Q | 2024-09-16T12:03:54.222Z | 2024-09-19T12:20:28.376Z |
5085215 | 5085215 | 20240912205951_l3Inw | UK009Q | 2024-09-16T12:03:44.357Z | 2024-09-19T12:20:28.231Z |
5075128 | 5075128 | 20240911232958_pcrET | UK009Q | 2024-09-15T12:09:25.999Z | 2024-09-19T12:21:08.426Z |
5074716 | 5074716 | 20240911225641_rEDD5 | UK009Q | 2024-09-15T12:08:45.498Z | 2024-09-19T12:21:07.624Z |
5074260 | 5074260 | 20240911222813_igvnu | UK009Q | 2024-09-15T12:08:16.133Z | 2024-09-19T12:21:07.020Z |
5074214 | 5074214 | 20240911222402_kIITf | UK009Q | 2024-09-15T12:08:09.681Z | 2024-09-19T12:21:07.009Z |
5073962 | 5073962 | 20240911215804_0XI9x | UK009Q | 2024-09-15T12:07:46.664Z | 2024-09-19T12:21:06.472Z |
5073948 | 5073948 | 20240911215643_nH9R5 | UK009Q | 2024-09-15T12:07:45.907Z | 2024-09-19T12:21:06.468Z |
5073376 | 5073376 | 20240911211821_rtlxM | UK009Q | 2024-09-15T12:07:06.778Z | 2024-09-19T12:21:05.703Z |
5072632 | 5072632 | 20240911203105_W6nom | UK009Q | 2024-09-15T12:05:53.586Z | 2024-09-19T12:21:04.546Z |
5065037 | 5065037 | 20240910025655_c04AE | UK009Q | 2024-09-14T12:16:19.077Z | 2024-09-18T12:15:18.190Z |
5046627 | 5046627 | 20240909003053_8N2TQ | UK009Q | 2024-09-13T12:07:10.478Z | 2024-09-17T12:18:59.627Z |
5046540 | 5046540 | 20240909000740_VWtfF | UK009Q | 2024-09-13T12:06:54.434Z | 2024-09-17T12:18:59.474Z |
5026522 | 5026522 | 20240905035105_LW8lm | UK009Q | 2024-09-11T12:12:40.390Z | 2024-09-13T12:19:58.630Z |
5026506 | 5026506 | 20240905034625_XGP8U | UK009Q | 2024-09-11T12:12:38.463Z | 2024-09-13T12:19:58.496Z |
5026496 | 5026496 | 20240905034350_bJ2L3 | UK009Q | 2024-09-11T12:12:36.345Z | 2024-09-13T12:19:58.433Z |
5026255 | 5026255 | 20240905024816_TmV9D | UK009Q | 2024-09-11T12:12:08.300Z | 2024-09-13T12:19:57.313Z |
5026236 | 5026236 | 20240905024557_5Jgfr | UK009Q | 2024-09-11T12:12:06.988Z | 2024-09-13T12:19:57.218Z |
5025990 | 5025990 | 20240905015440_CzE1d | UK009Q | 2024-09-11T12:11:41.254Z | 2024-09-13T12:19:56.484Z |
5025957 | 5025957 | 20240905014644_XTy7i | UK009Q | 2024-09-11T12:11:37.819Z | 2024-09-13T12:19:56.375Z |
5025946 | 5025946 | 20240905014438_Y890X | UK009Q | 2024-09-11T12:11:35.724Z | 2024-09-13T12:19:56.296Z |
5020982 | 5020982 | 20240905035105_yPOgE | UK009Q | 2024-09-10T12:15:10.074Z | 2024-09-13T12:19:58.614Z |
5020966 | 5020966 | 20240905034625_PKhZ5 | UK009Q | 2024-09-10T12:15:09.252Z | 2024-09-13T12:19:58.500Z |
5020954 | 5020954 | 20240905034350_olL02 | UK009Q | 2024-09-10T12:15:08.772Z | 2024-09-10T12:16:55.279Z |
5020701 | 5020701 | 20240905024816_aV3Kl | UK009Q | 2024-09-10T12:14:57.053Z | 2024-09-10T12:16:55.219Z |
5020682 | 5020682 | 20240905024557_XhJrc | UK009Q | 2024-09-10T12:14:56.217Z | 2024-09-10T12:16:55.214Z |
5020427 | 5020427 | 20240905015440_82NLf | UK009Q | 2024-09-10T12:14:27.335Z | 2024-09-10T12:16:55.147Z |
5020395 | 5020395 | 20240905014644_PhjbL | UK009Q | 2024-09-10T12:14:23.894Z | 2024-09-10T12:16:55.141Z |
5020388 | 5020388 | 20240905014438_CX3p2 | UK009Q | 2024-09-10T12:14:23.263Z | 2024-09-10T12:16:55.139Z |
4998791 | 4998791 | 20240903035807_2MG0D | UK009Q | 2024-09-08T12:08:05.050Z | 2024-09-11T12:21:14.873Z |
4998783 | 4998783 | 20240903035658_TjJaH | UK009Q | 2024-09-08T12:08:04.800Z | 2024-09-11T12:21:14.828Z |
4998719 | 4998719 | 20240903034026_YfIgo | UK009Q | 2024-09-08T12:08:01.382Z | 2024-09-11T12:21:14.492Z |
4998716 | 4998716 | 20240903034026_A2vPV | UK009Q | 2024-09-08T12:08:01.260Z | 2024-09-11T12:21:14.491Z |
4998689 | 4998689 | 20240903033634_3kHZd | UK009Q | 2024-09-08T12:07:59.811Z | 2024-09-11T12:21:14.294Z |
4998563 | 4998563 | 20240903031909_fdp4X | UK009Q | 2024-09-08T12:07:52.251Z | 2024-09-11T12:21:13.552Z |
4998536 | 4998536 | 20240903031715_99EiA | UK009Q | 2024-09-08T12:07:48.148Z | 2024-09-11T12:21:13.449Z |
4998390 | 4998390 | 20240903025518_P3Gw4 | UK009Q | 2024-09-08T12:07:35.223Z | 2024-09-11T12:21:12.562Z |
4998309 | 4998309 | 20240903024249_Oo09V | UK009Q | 2024-09-08T12:07:28.774Z | 2024-09-11T12:21:11.975Z |
4998207 | 4998207 | 20240903023030_XHa1T | UK009Q | 2024-09-08T12:07:23.088Z | 2024-09-11T12:21:11.459Z |
4998201 | 4998201 | 20240903023017_cc0Qp | UK009Q | 2024-09-08T12:07:22.821Z | 2024-09-11T12:21:11.455Z |
4998182 | 4998182 | 20240903022649_FKRxi | UK009Q | 2024-09-08T12:07:21.600Z | 2024-09-11T12:21:11.373Z |
4998170 | 4998170 | 20240903022548_sFY2G | UK009Q | 2024-09-08T12:07:20.944Z | 2024-09-11T12:21:11.332Z |
4997911 | 4997911 | 20240903014513_aDOMw | UK009Q | 2024-09-08T12:06:57.018Z | 2024-09-11T12:21:09.883Z |
4991942 | 4991942 | 20240901034901_lH8tF | UK009Q | 2024-09-07T12:12:41.051Z | 2024-09-09T12:27:33.603Z |
4991906 | 4991906 | 20240901033826_IcjiY | UK009Q | 2024-09-07T12:12:37.179Z | 2024-09-09T12:27:30.639Z |
4991869 | 4991869 | 20240901033008_lxI3u | UK009Q | 2024-09-07T12:12:34.428Z | 2024-09-09T12:27:27.350Z |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE participating_station ( meteor_unique_trajectory_identifier text NOT NULL, station_code text NOT NULL, created_at datetime NOT NULL DEFAULT ( strftime( '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc' ) ), updated_at datetime NOT NULL DEFAULT ( strftime( '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc' ) ), FOREIGN KEY (meteor_unique_trajectory_identifier) REFERENCES meteor (unique_trajectory_identifier), FOREIGN KEY (station_code) REFERENCES station (code), UNIQUE (meteor_unique_trajectory_identifier, station_code) ON CONFLICT IGNORE ); CREATE INDEX participating_station_station_code_covering_index ON participating_station (station_code, meteor_unique_trajectory_identifier); CREATE INDEX participating_station_created_at_index ON participating_station (created_at); CREATE INDEX participating_station_updated_at_index ON participating_station (updated_at);