participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
862 rows where station_code = "BE000W" 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 |
---|---|---|---|---|---|
5503102 | 5503102 | 20241107203956_2Z8Qe | BE000W | 2024-11-09T14:12:24.971Z | 2024-11-09T14:16:28.166Z |
5503093 | 5503093 | 20241107203906_sz3Kw | BE000W | 2024-11-09T14:12:24.620Z | 2024-11-09T14:16:28.165Z |
5502455 | 5502455 | 20241107183623_JyTpB | BE000W | 2024-11-09T14:11:23.811Z | 2024-11-09T14:16:28.032Z |
5490095 | 5490095 | 20241105205914_5xquF | BE000W | 2024-11-07T14:13:10.979Z | 2024-11-09T14:19:50.821Z |
5489828 | 5489828 | 20241105201343_U1a2L | BE000W | 2024-11-07T14:12:48.642Z | 2024-11-09T14:19:47.091Z |
5489709 | 5489709 | 20241105194831_J7U1m | BE000W | 2024-11-07T14:12:39.134Z | 2024-11-09T14:19:46.067Z |
5489587 | 5489587 | 20241105192223_c6dk6 | BE000W | 2024-11-07T14:12:14.534Z | 2024-11-09T14:19:44.626Z |
5489565 | 5489565 | 20241105191711_IR1WE | BE000W | 2024-11-07T14:12:12.843Z | 2024-11-09T14:19:44.275Z |
5489485 | 5489485 | 20241105190529_wKMpW | BE000W | 2024-11-07T14:12:05.485Z | 2024-11-09T14:19:43.182Z |
5489437 | 5489437 | 20241105185154_HSsg1 | BE000W | 2024-11-07T14:12:01.866Z | 2024-11-09T14:19:42.860Z |
5489302 | 5489302 | 20241105183314_ZoVRT | BE000W | 2024-11-07T14:11:51.762Z | 2024-11-09T14:19:41.096Z |
5489237 | 5489237 | 20241105181237_QN2dU | BE000W | 2024-11-07T14:11:35.014Z | 2024-11-09T14:19:39.793Z |
5489035 | 5489035 | 20241105173924_sSWYD | BE000W | 2024-11-07T14:11:13.277Z | 2024-11-09T14:19:36.020Z |
5488955 | 5488955 | 20241105172744_9tUCD | BE000W | 2024-11-07T14:11:06.033Z | 2024-11-09T14:19:34.611Z |
5485398 | 5485398 | 20241105052102_BrLSz | BE000W | 2024-11-06T14:18:12.283Z | 2024-11-09T14:21:21.367Z |
5485377 | 5485377 | 20241105051436_Oz3yg | BE000W | 2024-11-06T14:18:11.043Z | 2024-11-09T14:21:21.243Z |
5485370 | 5485370 | 20241105050906_c2ANS | BE000W | 2024-11-06T14:18:10.522Z | 2024-11-09T14:21:21.136Z |
5485300 | 5485300 | 20241105044347_invhs | BE000W | 2024-11-06T14:18:04.448Z | 2024-11-09T14:21:20.691Z |
5485261 | 5485261 | 20241105043212_HiwW3 | BE000W | 2024-11-06T14:18:00.214Z | 2024-11-09T14:21:20.347Z |
5485240 | 5485240 | 20241105042843_SDRbw | BE000W | 2024-11-06T14:17:58.176Z | 2024-11-09T14:21:20.197Z |
5485092 | 5485092 | 20241105040308_9QCCT | BE000W | 2024-11-06T14:17:44.657Z | 2024-11-09T14:21:19.227Z |
5485077 | 5485077 | 20241105040136_QHhuX | BE000W | 2024-11-06T14:17:43.807Z | 2024-11-09T14:21:19.191Z |
5484848 | 5484848 | 20241105033356_l6Mwi | BE000W | 2024-11-06T14:17:22.544Z | 2024-11-09T14:21:16.936Z |
5484688 | 5484688 | 20241105032016_3TrUk | BE000W | 2024-11-06T14:17:10.142Z | 2024-11-09T14:21:15.873Z |
5484573 | 5484573 | 20241105030554_OzRoO | BE000W | 2024-11-06T14:17:01.293Z | 2024-11-09T14:21:15.115Z |
5484555 | 5484555 | 20241105030403_bxu2g | BE000W | 2024-11-06T14:17:00.662Z | 2024-11-09T14:21:15.059Z |
5484530 | 5484530 | 20241105030229_ngi8s | BE000W | 2024-11-06T14:16:59.868Z | 2024-11-09T14:21:14.909Z |
5484526 | 5484526 | 20241105030210_1ep73 | BE000W | 2024-11-06T14:16:59.768Z | 2024-11-09T14:21:14.869Z |
5484500 | 5484500 | 20241105025808_F0o9S | BE000W | 2024-11-06T14:16:58.273Z | 2024-11-09T14:21:14.733Z |
5484449 | 5484449 | 20241105025213_GjyE1 | BE000W | 2024-11-06T14:16:55.617Z | 2024-11-09T14:21:14.195Z |
5484265 | 5484265 | 20241105022839_CZMdH | BE000W | 2024-11-06T14:16:41.362Z | 2024-11-09T14:21:12.581Z |
5484242 | 5484242 | 20241105022430_TUz80 | BE000W | 2024-11-06T14:16:37.647Z | 2024-11-09T14:21:12.307Z |
5484090 | 5484090 | 20241105020911_3s7s7 | BE000W | 2024-11-06T14:16:12.940Z | 2024-11-09T14:21:10.617Z |
5484082 | 5484082 | 20241105020853_Plij2 | BE000W | 2024-11-06T14:16:12.056Z | 2024-11-09T14:21:10.569Z |
5483905 | 5483905 | 20241105014245_cxv0n | BE000W | 2024-11-06T14:15:52.019Z | 2024-11-09T14:21:09.328Z |
5483885 | 5483885 | 20241105014120_XZNLd | BE000W | 2024-11-06T14:15:50.630Z | 2024-11-09T14:21:09.033Z |
5483858 | 5483858 | 20241105013859_thk6H | BE000W | 2024-11-06T14:15:47.014Z | 2024-11-09T14:21:08.800Z |
5483766 | 5483766 | 20241105012857_B8EKS | BE000W | 2024-11-06T14:15:41.580Z | 2024-11-09T14:21:07.507Z |
5483626 | 5483626 | 20241105011049_hXkCm | BE000W | 2024-11-06T14:15:32.317Z | 2024-11-09T14:21:06.389Z |
5483539 | 5483539 | 20241105005509_fCvQd | BE000W | 2024-11-06T14:15:27.513Z | 2024-11-09T14:21:05.867Z |
5483529 | 5483529 | 20241105005246_cWpLG | BE000W | 2024-11-06T14:15:26.941Z | 2024-11-09T14:21:05.802Z |
5483521 | 5483521 | 20241105005220_1PvDa | BE000W | 2024-11-06T14:15:26.455Z | 2024-11-09T14:21:05.765Z |
5483496 | 5483496 | 20241105004521_9aZVy | BE000W | 2024-11-06T14:15:25.457Z | 2024-11-09T14:21:05.660Z |
5483345 | 5483345 | 20241105002812_UP12B | BE000W | 2024-11-06T14:15:01.196Z | 2024-11-09T14:21:04.930Z |
5483324 | 5483324 | 20241105002658_uD5dv | BE000W | 2024-11-06T14:14:59.746Z | 2024-11-09T14:21:04.836Z |
5483294 | 5483294 | 20241105002357_NiQnF | BE000W | 2024-11-06T14:14:54.808Z | 2024-11-09T14:21:04.656Z |
5483240 | 5483240 | 20241105001721_55lW6 | BE000W | 2024-11-06T14:14:49.129Z | 2024-11-09T14:21:04.277Z |
5483150 | 5483150 | 20241105000410_PgZMk | BE000W | 2024-11-06T14:14:42.428Z | 2024-11-09T14:21:03.660Z |
5482918 | 5482918 | 20241104233337_Z26T4 | BE000W | 2024-11-06T14:14:19.405Z | 2024-11-09T14:21:02.362Z |
5482796 | 5482796 | 20241104231516_ZYa9j | BE000W | 2024-11-06T14:14:01.725Z | 2024-11-09T14:21:01.575Z |
5482746 | 5482746 | 20241104230951_CRzrh | BE000W | 2024-11-06T14:13:49.412Z | 2024-11-09T14:21:01.357Z |
5482709 | 5482709 | 20241104230523_JOOiL | BE000W | 2024-11-06T14:13:41.242Z | 2024-11-09T14:21:01.136Z |
5482703 | 5482703 | 20241104230450_2RFZU | BE000W | 2024-11-06T14:13:40.378Z | 2024-11-09T14:21:01.092Z |
5482637 | 5482637 | 20241104225248_2ezr9 | BE000W | 2024-11-06T14:13:29.151Z | 2024-11-09T14:21:00.714Z |
5482629 | 5482629 | 20241104225114_5klYU | BE000W | 2024-11-06T14:13:27.821Z | 2024-11-09T14:21:00.642Z |
5482587 | 5482587 | 20241104224551_zgP4j | BE000W | 2024-11-06T14:13:24.903Z | 2024-11-09T14:21:00.401Z |
5482492 | 5482492 | 20241104222957_c39sh | BE000W | 2024-11-06T14:13:16.100Z | 2024-11-09T14:20:59.880Z |
5482473 | 5482473 | 20241104222528_RbQEY | BE000W | 2024-11-06T14:13:14.660Z | 2024-11-09T14:20:59.674Z |
5482368 | 5482368 | 20241104215730_nY963 | BE000W | 2024-11-06T14:13:05.125Z | 2024-11-09T14:20:58.559Z |
5482357 | 5482357 | 20241104215554_bAjK0 | BE000W | 2024-11-06T14:13:04.639Z | 2024-11-09T14:20:58.514Z |
5482350 | 5482350 | 20241104215521_u2uYo | BE000W | 2024-11-06T14:13:04.413Z | 2024-11-09T14:20:58.457Z |
5482337 | 5482337 | 20241104215154_XoVys | BE000W | 2024-11-06T14:13:03.010Z | 2024-11-09T14:20:58.355Z |
5482329 | 5482329 | 20241104215119_Vk3hA | BE000W | 2024-11-06T14:13:02.377Z | 2024-11-09T14:20:58.257Z |
5482320 | 5482320 | 20241104214951_2uR6R | BE000W | 2024-11-06T14:12:59.659Z | 2024-11-09T14:20:58.089Z |
5482318 | 5482318 | 20241104214836_T42em | BE000W | 2024-11-06T14:12:59.016Z | 2024-11-09T14:20:57.973Z |
5482261 | 5482261 | 20241104213939_fI4MP | BE000W | 2024-11-06T14:12:42.862Z | 2024-11-09T14:20:57.199Z |
5482247 | 5482247 | 20241104213518_Qde8J | BE000W | 2024-11-06T14:12:41.701Z | 2024-11-09T14:20:57.061Z |
5481922 | 5481922 | 20241104202038_WIywT | BE000W | 2024-11-06T14:11:51.004Z | 2024-11-09T14:20:52.667Z |
5481817 | 5481817 | 20241104195026_i8Nur | BE000W | 2024-11-06T14:11:37.884Z | 2024-11-09T14:20:51.491Z |
5481811 | 5481811 | 20241104194821_vn5FT | BE000W | 2024-11-06T14:11:37.282Z | 2024-11-09T14:20:51.435Z |
5481780 | 5481780 | 20241104193945_yj9n9 | BE000W | 2024-11-06T14:11:34.198Z | 2024-11-09T14:20:50.750Z |
5481757 | 5481757 | 20241104193415_t2GsE | BE000W | 2024-11-06T14:11:31.557Z | 2024-11-09T14:20:50.511Z |
5481732 | 5481732 | 20241104192525_8JubZ | BE000W | 2024-11-06T14:11:28.620Z | 2024-11-09T14:20:50.126Z |
5481549 | 5481549 | 20241104182351_boLHq | BE000W | 2024-11-06T14:10:47.607Z | 2024-11-09T14:20:47.347Z |
5481465 | 5481465 | 20241104174918_uKnin | BE000W | 2024-11-06T14:10:36.253Z | 2024-11-09T14:20:46.161Z |
5481451 | 5481451 | 20241104174745_SIulI | BE000W | 2024-11-06T14:10:34.736Z | 2024-11-09T14:20:46.040Z |
5481418 | 5481418 | 20241104173557_EBS8C | BE000W | 2024-11-06T14:10:31.011Z | 2024-11-09T14:20:45.615Z |
5481360 | 5481360 | 20241104171634_qjt0T | BE000W | 2024-11-06T14:10:13.222Z | 2024-11-09T14:20:44.722Z |
5481341 | 5481341 | 20241104170741_l1kLs | BE000W | 2024-11-06T14:10:06.907Z | 2024-11-09T14:20:44.402Z |
5478611 | 5478611 | 20241104044307_b73tC | BE000W | 2024-11-05T14:18:34.262Z | 2024-11-09T14:22:30.238Z |
5478600 | 5478600 | 20241104044150_CPEMv | BE000W | 2024-11-05T14:18:33.260Z | 2024-11-09T14:22:30.153Z |
5478501 | 5478501 | 20241104041954_vfA6x | BE000W | 2024-11-05T14:18:26.287Z | 2024-11-09T14:22:28.731Z |
5478453 | 5478453 | 20241104041406_QKcS8 | BE000W | 2024-11-05T14:18:23.831Z | 2024-11-09T14:22:28.275Z |
5478270 | 5478270 | 20241104034448_hVsvc | BE000W | 2024-11-05T14:18:08.182Z | 2024-11-09T14:22:26.416Z |
5478009 | 5478009 | 20241104030654_08ruG | BE000W | 2024-11-05T14:17:44.663Z | 2024-11-09T14:22:23.607Z |
5478002 | 5478002 | 20241104030607_dm7hx | BE000W | 2024-11-05T14:17:44.026Z | 2024-11-09T14:22:23.527Z |
5477996 | 5477996 | 20241104030544_QD03g | BE000W | 2024-11-05T14:17:43.431Z | 2024-11-09T14:22:23.377Z |
5477926 | 5477926 | 20241104025352_DMGU4 | BE000W | 2024-11-05T14:17:37.063Z | 2024-11-09T14:22:22.909Z |
5477906 | 5477906 | 20241104025220_p3mAq | BE000W | 2024-11-05T14:17:35.748Z | 2024-11-09T14:22:22.838Z |
5477882 | 5477882 | 20241104025109_vNGa9 | BE000W | 2024-11-05T14:17:34.060Z | 2024-11-09T14:22:22.678Z |
5477879 | 5477879 | 20241104025057_gmx5J | BE000W | 2024-11-05T14:17:33.473Z | 2024-11-09T14:22:22.617Z |
5477817 | 5477817 | 20241104024043_wMIoO | BE000W | 2024-11-05T14:17:28.111Z | 2024-11-09T14:22:22.181Z |
5477769 | 5477769 | 20241104023325_7H8Nz | BE000W | 2024-11-05T14:17:23.854Z | 2024-11-09T14:22:21.756Z |
5477762 | 5477762 | 20241104023255_28732 | BE000W | 2024-11-05T14:17:23.379Z | 2024-11-09T14:22:21.624Z |
5477747 | 5477747 | 20241104023143_N1tXB | BE000W | 2024-11-05T14:17:21.995Z | 2024-11-09T14:22:21.565Z |
5477719 | 5477719 | 20241104022643_5PGnk | BE000W | 2024-11-05T14:17:19.280Z | 2024-11-09T14:22:21.269Z |
5477701 | 5477701 | 20241104022241_q4Jl5 | BE000W | 2024-11-05T14:17:16.244Z | 2024-11-09T14:22:21.044Z |
5477677 | 5477677 | 20241104021939_q4xuc | BE000W | 2024-11-05T14:17:14.310Z | 2024-11-09T14:22:20.711Z |
5477502 | 5477502 | 20241104020404_pPyKO | BE000W | 2024-11-05T14:16:59.037Z | 2024-11-09T14:22:18.545Z |
5477446 | 5477446 | 20241104015450_WIr6y | BE000W | 2024-11-05T14:16:54.128Z | 2024-11-09T14:22:17.793Z |
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);