participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,572 rows where station_code = "UK00BA" 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 |
---|---|---|---|---|---|
5454896 | 5454896 | 20241031054114_Yq36M | UK00BA | 2024-11-02T12:23:26.111Z | 2024-11-08T14:23:26.147Z |
5454822 | 5454822 | 20241031052426_2yRcp | UK00BA | 2024-11-02T12:23:24.206Z | 2024-11-08T14:23:25.825Z |
5454814 | 5454814 | 20241031052254_7f3pm | UK00BA | 2024-11-02T12:23:23.935Z | 2024-11-08T14:23:25.801Z |
5454808 | 5454808 | 20241031052205_JIlLt | UK00BA | 2024-11-02T12:23:23.808Z | 2024-11-08T14:23:25.710Z |
5454789 | 5454789 | 20241031051641_voIyP | UK00BA | 2024-11-02T12:23:23.145Z | 2024-11-08T14:23:25.649Z |
5454710 | 5454710 | 20241031045757_G6kk1 | UK00BA | 2024-11-02T12:23:17.859Z | 2024-11-08T14:23:24.842Z |
5454668 | 5454668 | 20241031045333_pVNad | UK00BA | 2024-11-02T12:23:16.023Z | 2024-11-08T14:23:24.674Z |
5454636 | 5454636 | 20241031044754_d7Wih | UK00BA | 2024-11-02T12:23:15.003Z | 2024-11-08T14:23:24.510Z |
5454630 | 5454630 | 20241031044726_r5oo3 | UK00BA | 2024-11-02T12:23:14.830Z | 2024-11-08T14:23:24.494Z |
5454550 | 5454550 | 20241031043734_Gk7IS | UK00BA | 2024-11-02T12:23:11.430Z | 2024-11-08T14:23:23.862Z |
5454492 | 5454492 | 20241031042951_5e20c | UK00BA | 2024-11-02T12:23:07.644Z | 2024-11-08T14:23:23.366Z |
5454454 | 5454454 | 20241031042452_8OtK6 | UK00BA | 2024-11-02T12:23:06.442Z | 2024-11-08T14:23:23.040Z |
5454433 | 5454433 | 20241031042124_kcvkD | UK00BA | 2024-11-02T12:23:06.223Z | 2024-11-08T14:23:22.963Z |
5454356 | 5454356 | 20241031041153_nz3u5 | UK00BA | 2024-11-02T12:23:03.450Z | 2024-11-08T14:23:22.472Z |
5454231 | 5454231 | 20241031040034_0yq9j | UK00BA | 2024-11-02T12:22:55.565Z | 2024-11-08T14:23:21.658Z |
5454205 | 5454205 | 20241031035545_lYDGS | UK00BA | 2024-11-02T12:22:54.431Z | 2024-11-08T14:23:21.340Z |
5454090 | 5454090 | 20241031034058_92XpZ | UK00BA | 2024-11-02T12:22:50.489Z | 2024-11-08T14:23:20.310Z |
5453857 | 5453857 | 20241031031012_yDb94 | UK00BA | 2024-11-02T12:22:43.823Z | 2024-11-08T14:23:19.585Z |
5453757 | 5453757 | 20241031025647_ldDz8 | UK00BA | 2024-11-02T12:22:41.985Z | 2024-11-08T14:23:18.989Z |
5453745 | 5453745 | 20241031025446_5gauI | UK00BA | 2024-11-02T12:22:41.605Z | 2024-11-08T14:23:18.962Z |
5453727 | 5453727 | 20241031025242_kpT2g | UK00BA | 2024-11-02T12:22:41.254Z | 2024-11-08T14:23:18.936Z |
5453667 | 5453667 | 20241031024048_h2xAZ | UK00BA | 2024-11-02T12:22:39.383Z | 2024-11-08T14:23:18.631Z |
5453595 | 5453595 | 20241031022824_5Eolw | UK00BA | 2024-11-02T12:22:36.686Z | 2024-11-08T14:23:18.170Z |
5453488 | 5453488 | 20241031021533_suTNg | UK00BA | 2024-11-02T12:22:34.496Z | 2024-11-08T14:23:17.588Z |
5453468 | 5453468 | 20241031021433_C3sav | UK00BA | 2024-11-02T12:22:34.207Z | 2024-11-08T14:23:17.537Z |
5453414 | 5453414 | 20241031020958_T3SLL | UK00BA | 2024-11-02T12:22:33.187Z | 2024-11-08T14:23:17.307Z |
5453376 | 5453376 | 20241031020641_vwfG0 | UK00BA | 2024-11-02T12:22:32.794Z | 2024-11-08T14:23:17.225Z |
5453329 | 5453329 | 20241031020301_PjpLB | UK00BA | 2024-11-02T12:22:31.868Z | 2024-11-08T14:23:16.735Z |
5453317 | 5453317 | 20241031020151_O3cL5 | UK00BA | 2024-11-02T12:22:31.753Z | 2024-11-08T14:23:16.590Z |
5453255 | 5453255 | 20241031015350_Le1BT | UK00BA | 2024-11-02T12:22:30.428Z | 2024-11-08T14:23:16.230Z |
5453244 | 5453244 | 20241031015324_KqijA | UK00BA | 2024-11-02T12:22:30.218Z | 2024-11-08T14:23:16.209Z |
5453224 | 5453224 | 20241031015201_UuaOJ | UK00BA | 2024-11-02T12:22:30.032Z | 2024-11-08T14:23:16.184Z |
5453081 | 5453081 | 20241031013544_pwdEC | UK00BA | 2024-11-02T12:22:25.968Z | 2024-11-08T14:23:15.933Z |
5450688 | 5450688 | 20241031202009_3L1qa | UK00BA | 2024-11-02T12:15:44.746Z | 2024-11-09T14:24:17.569Z |
5444465 | 5444465 | 20241031012315_PH2uD | UK00BA | 2024-11-01T12:21:18.471Z | 2024-11-08T14:23:15.669Z |
5444393 | 5444393 | 20241031011553_zYtgX | UK00BA | 2024-11-01T12:21:15.440Z | 2024-11-08T14:23:15.299Z |
5444288 | 5444288 | 20241031010507_wd3n4 | UK00BA | 2024-11-01T12:21:12.105Z | 2024-11-08T14:23:14.279Z |
5444274 | 5444274 | 20241031010430_QV9mi | UK00BA | 2024-11-01T12:21:11.976Z | 2024-11-08T14:23:14.270Z |
5444212 | 5444212 | 20241031005937_HXc0G | UK00BA | 2024-11-01T12:21:10.099Z | 2024-11-08T14:23:14.115Z |
5444167 | 5444167 | 20241031005442_dX8l1 | UK00BA | 2024-11-01T12:21:08.103Z | 2024-11-08T14:23:14.032Z |
5444144 | 5444144 | 20241031005205_KUDsg | UK00BA | 2024-11-01T12:21:07.767Z | 2024-11-08T14:23:14.019Z |
5444087 | 5444087 | 20241031004703_07GZP | UK00BA | 2024-11-01T12:21:05.537Z | 2024-11-08T14:23:13.815Z |
5444058 | 5444058 | 20241031004152_Huvtu | UK00BA | 2024-11-01T12:21:03.780Z | 2024-11-08T14:23:13.767Z |
5444022 | 5444022 | 20241031003829_xy2xj | UK00BA | 2024-11-01T12:21:01.792Z | 2024-11-08T14:23:13.547Z |
5443926 | 5443926 | 20241031002938_eF623 | UK00BA | 2024-11-01T12:20:57.366Z | 2024-11-08T14:23:13.237Z |
5443909 | 5443909 | 20241031002713_TZ28n | UK00BA | 2024-11-01T12:20:56.258Z | 2024-11-08T14:23:13.067Z |
5443897 | 5443897 | 20241031002636_5Mtdl | UK00BA | 2024-11-01T12:20:56.110Z | 2024-11-08T14:23:13.052Z |
5443878 | 5443878 | 20241031002311_fZnmk | UK00BA | 2024-11-01T12:20:55.240Z | 2024-11-08T14:23:12.961Z |
5443870 | 5443870 | 20241031002233_6iFui | UK00BA | 2024-11-01T12:20:55.117Z | 2024-11-08T14:23:12.954Z |
5443854 | 5443854 | 20241031002028_bRhO6 | UK00BA | 2024-11-01T12:20:54.412Z | 2024-11-08T14:23:12.731Z |
5443847 | 5443847 | 20241031002027_qulJ4 | UK00BA | 2024-11-01T12:20:54.046Z | 2024-11-08T14:23:12.726Z |
5443754 | 5443754 | 20241031001103_GDQlG | UK00BA | 2024-11-01T12:20:48.758Z | 2024-11-08T14:23:12.135Z |
5443721 | 5443721 | 20241031000803_OGizp | UK00BA | 2024-11-01T12:20:47.636Z | 2024-11-08T14:23:12.049Z |
5443632 | 5443632 | 20241030235603_BHI3e | UK00BA | 2024-11-01T12:20:43.068Z | 2024-11-08T14:23:11.809Z |
5443627 | 5443627 | 20241030235547_oeD2P | UK00BA | 2024-11-01T12:20:42.936Z | 2024-11-08T14:23:11.805Z |
5443606 | 5443606 | 20241030235042_kaeMR | UK00BA | 2024-11-01T12:20:41.341Z | 2024-11-08T14:23:11.712Z |
5440862 | 5440862 | 20241030231617_rOR0p | UK00BA | 2024-11-01T12:15:55.202Z | 2024-11-08T14:23:10.835Z |
5440614 | 5440614 | 20241030223312_rdKXI | UK00BA | 2024-11-01T12:15:39.029Z | 2024-11-08T14:23:10.014Z |
5440592 | 5440592 | 20241030223045_4mckj | UK00BA | 2024-11-01T12:15:38.373Z | 2024-11-08T14:23:09.953Z |
5440546 | 5440546 | 20241030222632_XdSPO | UK00BA | 2024-11-01T12:15:36.325Z | 2024-11-08T14:23:09.885Z |
5440418 | 5440418 | 20241030220853_1tx8l | UK00BA | 2024-11-01T12:15:29.499Z | 2024-11-08T14:23:09.370Z |
5440320 | 5440320 | 20241030215617_TNViU | UK00BA | 2024-11-01T12:15:22.173Z | 2024-11-08T14:23:08.954Z |
5440318 | 5440318 | 20241030215554_ZwxHj | UK00BA | 2024-11-01T12:15:21.836Z | 2024-11-08T14:23:08.939Z |
5440223 | 5440223 | 20241030214412_Q2xZa | UK00BA | 2024-11-01T12:15:01.716Z | 2024-11-08T14:23:07.979Z |
5430389 | 5430389 | 20241028222515_hwSrf | UK00BA | 2024-10-31T12:18:17.144Z | 2024-11-06T14:27:19.666Z |
5430374 | 5430374 | 20241028222147_ka1Pv | UK00BA | 2024-10-31T12:18:14.869Z | 2024-11-06T14:27:19.614Z |
5421239 | 5421239 | 20241028051540_rnaTw | UK00BA | 2024-10-30T12:19:45.136Z | 2024-11-05T14:27:17.870Z |
5409510 | 5409510 | 20241027042230_ZaRyf | UK00BA | 2024-10-29T12:17:27.029Z | 2024-11-04T14:29:01.919Z |
5408862 | 5408862 | 20241027034647_9Rrkv | UK00BA | 2024-10-29T12:16:55.008Z | 2024-11-04T14:29:00.733Z |
5408772 | 5408772 | 20241027034250_M3BSv | UK00BA | 2024-10-29T12:16:49.334Z | 2024-11-04T14:29:00.465Z |
5407103 | 5407103 | 20241027022230_r3dcA | UK00BA | 2024-10-29T12:15:12.389Z | 2024-11-04T14:28:56.846Z |
5406907 | 5406907 | 20241027020834_i4q8E | UK00BA | 2024-10-29T12:14:55.721Z | 2024-11-04T14:28:56.645Z |
5406899 | 5406899 | 20241027020738_ISO3D | UK00BA | 2024-10-29T12:14:53.866Z | 2024-11-04T14:28:56.589Z |
5406860 | 5406860 | 20241027020439_0A7AZ | UK00BA | 2024-10-29T12:14:50.745Z | 2024-11-04T14:28:56.519Z |
5405525 | 5405525 | 20241027004120_HgLRc | UK00BA | 2024-10-29T12:13:00.074Z | 2024-11-04T14:28:53.586Z |
5405492 | 5405492 | 20241027003916_iUq8e | UK00BA | 2024-10-29T12:12:59.052Z | 2024-11-04T14:28:53.560Z |
5405483 | 5405483 | 20241027003841_rQvnl | UK00BA | 2024-10-29T12:12:58.479Z | 2024-11-04T14:28:53.548Z |
5405294 | 5405294 | 20241027002707_xYNQt | UK00BA | 2024-10-29T12:12:48.269Z | 2024-11-04T14:28:53.254Z |
5405237 | 5405237 | 20241027002508_n8JUC | UK00BA | 2024-10-29T12:12:45.720Z | 2024-11-04T14:28:53.148Z |
5405173 | 5405173 | 20241027001859_Ac0e3 | UK00BA | 2024-10-29T12:12:37.071Z | 2024-11-04T14:28:52.753Z |
5405103 | 5405103 | 20241027001344_ckHDe | UK00BA | 2024-10-29T12:12:27.470Z | 2024-11-04T14:28:52.678Z |
5405054 | 5405054 | 20241027001103_RJiYj | UK00BA | 2024-10-29T12:12:20.312Z | 2024-11-04T14:28:52.622Z |
5404943 | 5404943 | 20241027000206_GcvvA | UK00BA | 2024-10-29T12:12:08.794Z | 2024-11-04T14:28:52.436Z |
5404602 | 5404602 | 20241026234003_k2iKG | UK00BA | 2024-10-29T12:11:45.558Z | 2024-11-04T14:28:51.377Z |
5404434 | 5404434 | 20241026232624_aDLGn | UK00BA | 2024-10-29T12:11:26.247Z | 2024-11-04T14:28:51.000Z |
5404357 | 5404357 | 20241026231910_s1lZf | UK00BA | 2024-10-29T12:11:12.501Z | 2024-11-04T14:28:50.788Z |
5404275 | 5404275 | 20241026231326_6dOEF | UK00BA | 2024-10-29T12:11:04.250Z | 2024-11-04T14:28:50.573Z |
5404245 | 5404245 | 20241026231121_7nHby | UK00BA | 2024-10-29T12:11:02.998Z | 2024-11-04T14:28:50.551Z |
5403409 | 5403409 | 20241026215414_l20z6 | UK00BA | 2024-10-29T12:09:27.764Z | 2024-11-04T14:28:48.729Z |
5403326 | 5403326 | 20241026214045_GDS6I | UK00BA | 2024-10-29T12:09:21.897Z | 2024-11-04T14:28:48.330Z |
5403097 | 5403097 | 20241026211748_OAwnL | UK00BA | 2024-10-29T12:08:53.728Z | 2024-11-04T14:28:47.701Z |
5403077 | 5403077 | 20241026211518_74PqD | UK00BA | 2024-10-29T12:08:52.434Z | 2024-11-04T14:28:47.680Z |
5403058 | 5403058 | 20241026211040_D0Fyz | UK00BA | 2024-10-29T12:08:50.780Z | 2024-11-04T14:28:47.632Z |
5402973 | 5402973 | 20241026205452_q5fGv | UK00BA | 2024-10-29T12:08:41.010Z | 2024-11-04T14:28:47.222Z |
5402864 | 5402864 | 20241026203545_giBFc | UK00BA | 2024-10-29T12:08:29.585Z | 2024-11-04T14:28:46.728Z |
5402739 | 5402739 | 20241026201728_El9Yn | UK00BA | 2024-10-29T12:08:02.355Z | 2024-11-04T14:28:46.424Z |
5402615 | 5402615 | 20241026200426_Gll2y | UK00BA | 2024-10-29T12:07:48.056Z | 2024-11-04T14:28:45.609Z |
5402076 | 5402076 | 20241026184122_v3ec2 | UK00BA | 2024-10-29T12:06:22.041Z | 2024-11-04T14:28:42.139Z |
5400182 | 5400182 | 20241026055029_ulbyN | UK00BA | 2024-10-28T12:20:25.562Z | 2024-11-03T14:27:41.457Z |
5400037 | 5400037 | 20241026052811_whAnn | UK00BA | 2024-10-28T12:20:19.940Z | 2024-11-03T14:27:41.149Z |
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);