participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
864 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 |
---|---|---|---|---|---|
5527911 | 5527911 | 20241111185907_tpR3t | BE000W | 2024-11-13T14:09:32.734Z | 2024-11-20T14:25:22.934Z |
5524102 | 5524102 | 20241111031418_OawSX | BE000W | 2024-11-12T14:16:32.758Z | 2024-11-19T14:22:17.235Z |
5503102 | 5503102 | 20241107203956_2Z8Qe | BE000W | 2024-11-09T14:12:24.971Z | 2024-11-16T14:28:02.604Z |
5503093 | 5503093 | 20241107203906_sz3Kw | BE000W | 2024-11-09T14:12:24.620Z | 2024-11-16T14:28:02.544Z |
5502455 | 5502455 | 20241107183623_JyTpB | BE000W | 2024-11-09T14:11:23.811Z | 2024-11-16T14:27:55.979Z |
5490095 | 5490095 | 20241105205914_5xquF | BE000W | 2024-11-07T14:13:10.979Z | 2024-11-14T14:23:17.505Z |
5489828 | 5489828 | 20241105201343_U1a2L | BE000W | 2024-11-07T14:12:48.642Z | 2024-11-14T14:23:15.788Z |
5489709 | 5489709 | 20241105194831_J7U1m | BE000W | 2024-11-07T14:12:39.134Z | 2024-11-14T14:23:15.328Z |
5489587 | 5489587 | 20241105192223_c6dk6 | BE000W | 2024-11-07T14:12:14.534Z | 2024-11-14T14:23:13.889Z |
5489565 | 5489565 | 20241105191711_IR1WE | BE000W | 2024-11-07T14:12:12.843Z | 2024-11-14T14:23:13.793Z |
5489485 | 5489485 | 20241105190529_wKMpW | BE000W | 2024-11-07T14:12:05.485Z | 2024-11-14T14:23:13.580Z |
5489437 | 5489437 | 20241105185154_HSsg1 | BE000W | 2024-11-07T14:12:01.866Z | 2024-11-14T14:23:13.311Z |
5489302 | 5489302 | 20241105183314_ZoVRT | BE000W | 2024-11-07T14:11:51.762Z | 2024-11-14T14:23:12.334Z |
5489237 | 5489237 | 20241105181237_QN2dU | BE000W | 2024-11-07T14:11:35.014Z | 2024-11-14T14:23:11.144Z |
5489035 | 5489035 | 20241105173924_sSWYD | BE000W | 2024-11-07T14:11:13.277Z | 2024-11-14T14:23:09.671Z |
5488955 | 5488955 | 20241105172744_9tUCD | BE000W | 2024-11-07T14:11:06.033Z | 2024-11-14T14:23:08.828Z |
5485398 | 5485398 | 20241105052102_BrLSz | BE000W | 2024-11-06T14:18:12.283Z | 2024-11-13T14:27:42.112Z |
5485377 | 5485377 | 20241105051436_Oz3yg | BE000W | 2024-11-06T14:18:11.043Z | 2024-11-13T14:27:42.078Z |
5485370 | 5485370 | 20241105050906_c2ANS | BE000W | 2024-11-06T14:18:10.522Z | 2024-11-13T14:27:42.073Z |
5485300 | 5485300 | 20241105044347_invhs | BE000W | 2024-11-06T14:18:04.448Z | 2024-11-13T14:27:41.580Z |
5485261 | 5485261 | 20241105043212_HiwW3 | BE000W | 2024-11-06T14:18:00.214Z | 2024-11-13T14:27:41.440Z |
5485240 | 5485240 | 20241105042843_SDRbw | BE000W | 2024-11-06T14:17:58.176Z | 2024-11-13T14:27:41.254Z |
5485092 | 5485092 | 20241105040308_9QCCT | BE000W | 2024-11-06T14:17:44.657Z | 2024-11-13T14:27:40.705Z |
5485077 | 5485077 | 20241105040136_QHhuX | BE000W | 2024-11-06T14:17:43.807Z | 2024-11-13T14:27:40.609Z |
5484848 | 5484848 | 20241105033356_l6Mwi | BE000W | 2024-11-06T14:17:22.544Z | 2024-11-13T14:27:39.970Z |
5484688 | 5484688 | 20241105032016_3TrUk | BE000W | 2024-11-06T14:17:10.142Z | 2024-11-13T14:27:39.344Z |
5484573 | 5484573 | 20241105030554_OzRoO | BE000W | 2024-11-06T14:17:01.293Z | 2024-11-13T14:27:38.645Z |
5484555 | 5484555 | 20241105030403_bxu2g | BE000W | 2024-11-06T14:17:00.662Z | 2024-11-13T14:27:38.619Z |
5484530 | 5484530 | 20241105030229_ngi8s | BE000W | 2024-11-06T14:16:59.868Z | 2024-11-13T14:27:38.570Z |
5484526 | 5484526 | 20241105030210_1ep73 | BE000W | 2024-11-06T14:16:59.768Z | 2024-11-13T14:27:38.552Z |
5484500 | 5484500 | 20241105025808_F0o9S | BE000W | 2024-11-06T14:16:58.273Z | 2024-11-13T14:27:38.359Z |
5484449 | 5484449 | 20241105025213_GjyE1 | BE000W | 2024-11-06T14:16:55.617Z | 2024-11-13T14:27:38.094Z |
5484265 | 5484265 | 20241105022839_CZMdH | BE000W | 2024-11-06T14:16:41.362Z | 2024-11-13T14:27:37.597Z |
5484242 | 5484242 | 20241105022430_TUz80 | BE000W | 2024-11-06T14:16:37.647Z | 2024-11-13T14:27:37.570Z |
5484090 | 5484090 | 20241105020911_3s7s7 | BE000W | 2024-11-06T14:16:12.940Z | 2024-11-13T14:27:37.271Z |
5484082 | 5484082 | 20241105020853_Plij2 | BE000W | 2024-11-06T14:16:12.056Z | 2024-11-13T14:27:37.267Z |
5483905 | 5483905 | 20241105014245_cxv0n | BE000W | 2024-11-06T14:15:52.019Z | 2024-11-13T14:27:37.004Z |
5483885 | 5483885 | 20241105014120_XZNLd | BE000W | 2024-11-06T14:15:50.630Z | 2024-11-13T14:27:36.975Z |
5483858 | 5483858 | 20241105013859_thk6H | BE000W | 2024-11-06T14:15:47.014Z | 2024-11-13T14:27:36.918Z |
5483766 | 5483766 | 20241105012857_B8EKS | BE000W | 2024-11-06T14:15:41.580Z | 2024-11-13T14:27:36.782Z |
5483626 | 5483626 | 20241105011049_hXkCm | BE000W | 2024-11-06T14:15:32.317Z | 2024-11-13T14:27:36.532Z |
5483539 | 5483539 | 20241105005509_fCvQd | BE000W | 2024-11-06T14:15:27.513Z | 2024-11-13T14:27:36.385Z |
5483529 | 5483529 | 20241105005246_cWpLG | BE000W | 2024-11-06T14:15:26.941Z | 2024-11-13T14:27:36.369Z |
5483521 | 5483521 | 20241105005220_1PvDa | BE000W | 2024-11-06T14:15:26.455Z | 2024-11-13T14:27:36.353Z |
5483496 | 5483496 | 20241105004521_9aZVy | BE000W | 2024-11-06T14:15:25.457Z | 2024-11-13T14:27:36.336Z |
5483345 | 5483345 | 20241105002812_UP12B | BE000W | 2024-11-06T14:15:01.196Z | 2024-11-13T14:27:36.055Z |
5483324 | 5483324 | 20241105002658_uD5dv | BE000W | 2024-11-06T14:14:59.746Z | 2024-11-13T14:27:36.038Z |
5483294 | 5483294 | 20241105002357_NiQnF | BE000W | 2024-11-06T14:14:54.808Z | 2024-11-13T14:27:36.001Z |
5483240 | 5483240 | 20241105001721_55lW6 | BE000W | 2024-11-06T14:14:49.129Z | 2024-11-13T14:27:35.884Z |
5483150 | 5483150 | 20241105000410_PgZMk | BE000W | 2024-11-06T14:14:42.428Z | 2024-11-13T14:27:35.773Z |
5482918 | 5482918 | 20241104233337_Z26T4 | BE000W | 2024-11-06T14:14:19.405Z | 2024-11-13T14:27:35.352Z |
5482796 | 5482796 | 20241104231516_ZYa9j | BE000W | 2024-11-06T14:14:01.725Z | 2024-11-13T14:27:35.148Z |
5482746 | 5482746 | 20241104230951_CRzrh | BE000W | 2024-11-06T14:13:49.412Z | 2024-11-13T14:27:35.077Z |
5482709 | 5482709 | 20241104230523_JOOiL | BE000W | 2024-11-06T14:13:41.242Z | 2024-11-13T14:27:35.054Z |
5482703 | 5482703 | 20241104230450_2RFZU | BE000W | 2024-11-06T14:13:40.378Z | 2024-11-13T14:27:35.046Z |
5482637 | 5482637 | 20241104225248_2ezr9 | BE000W | 2024-11-06T14:13:29.151Z | 2024-11-13T14:27:34.948Z |
5482629 | 5482629 | 20241104225114_5klYU | BE000W | 2024-11-06T14:13:27.821Z | 2024-11-13T14:27:34.927Z |
5482587 | 5482587 | 20241104224551_zgP4j | BE000W | 2024-11-06T14:13:24.903Z | 2024-11-13T14:27:34.883Z |
5482492 | 5482492 | 20241104222957_c39sh | BE000W | 2024-11-06T14:13:16.100Z | 2024-11-13T14:27:34.724Z |
5482473 | 5482473 | 20241104222528_RbQEY | BE000W | 2024-11-06T14:13:14.660Z | 2024-11-13T14:27:34.665Z |
5482368 | 5482368 | 20241104215730_nY963 | BE000W | 2024-11-06T14:13:05.125Z | 2024-11-13T14:27:34.424Z |
5482357 | 5482357 | 20241104215554_bAjK0 | BE000W | 2024-11-06T14:13:04.639Z | 2024-11-13T14:27:34.409Z |
5482350 | 5482350 | 20241104215521_u2uYo | BE000W | 2024-11-06T14:13:04.413Z | 2024-11-13T14:27:34.404Z |
5482337 | 5482337 | 20241104215154_XoVys | BE000W | 2024-11-06T14:13:03.010Z | 2024-11-13T14:27:34.375Z |
5482329 | 5482329 | 20241104215119_Vk3hA | BE000W | 2024-11-06T14:13:02.377Z | 2024-11-13T14:27:34.361Z |
5482320 | 5482320 | 20241104214951_2uR6R | BE000W | 2024-11-06T14:12:59.659Z | 2024-11-13T14:27:34.340Z |
5482318 | 5482318 | 20241104214836_T42em | BE000W | 2024-11-06T14:12:59.016Z | 2024-11-13T14:27:34.339Z |
5482261 | 5482261 | 20241104213939_fI4MP | BE000W | 2024-11-06T14:12:42.862Z | 2024-11-13T14:27:34.203Z |
5482247 | 5482247 | 20241104213518_Qde8J | BE000W | 2024-11-06T14:12:41.701Z | 2024-11-13T14:27:34.176Z |
5481922 | 5481922 | 20241104202038_WIywT | BE000W | 2024-11-06T14:11:51.004Z | 2024-11-13T14:27:33.455Z |
5481817 | 5481817 | 20241104195026_i8Nur | BE000W | 2024-11-06T14:11:37.884Z | 2024-11-13T14:27:33.188Z |
5481811 | 5481811 | 20241104194821_vn5FT | BE000W | 2024-11-06T14:11:37.282Z | 2024-11-13T14:27:33.173Z |
5481780 | 5481780 | 20241104193945_yj9n9 | BE000W | 2024-11-06T14:11:34.198Z | 2024-11-13T14:27:32.688Z |
5481757 | 5481757 | 20241104193415_t2GsE | BE000W | 2024-11-06T14:11:31.557Z | 2024-11-13T14:27:32.618Z |
5481732 | 5481732 | 20241104192525_8JubZ | BE000W | 2024-11-06T14:11:28.620Z | 2024-11-13T14:27:32.432Z |
5481549 | 5481549 | 20241104182351_boLHq | BE000W | 2024-11-06T14:10:47.607Z | 2024-11-13T14:27:30.443Z |
5481465 | 5481465 | 20241104174918_uKnin | BE000W | 2024-11-06T14:10:36.253Z | 2024-11-13T14:27:29.176Z |
5481451 | 5481451 | 20241104174745_SIulI | BE000W | 2024-11-06T14:10:34.736Z | 2024-11-13T14:27:28.855Z |
5481418 | 5481418 | 20241104173557_EBS8C | BE000W | 2024-11-06T14:10:31.011Z | 2024-11-13T14:27:28.469Z |
5481360 | 5481360 | 20241104171634_qjt0T | BE000W | 2024-11-06T14:10:13.222Z | 2024-11-13T14:27:28.050Z |
5481341 | 5481341 | 20241104170741_l1kLs | BE000W | 2024-11-06T14:10:06.907Z | 2024-11-13T14:27:27.982Z |
5478611 | 5478611 | 20241104044307_b73tC | BE000W | 2024-11-05T14:18:34.262Z | 2024-11-12T14:28:16.393Z |
5478600 | 5478600 | 20241104044150_CPEMv | BE000W | 2024-11-05T14:18:33.260Z | 2024-11-12T14:28:16.308Z |
5478501 | 5478501 | 20241104041954_vfA6x | BE000W | 2024-11-05T14:18:26.287Z | 2024-11-12T14:28:15.737Z |
5478453 | 5478453 | 20241104041406_QKcS8 | BE000W | 2024-11-05T14:18:23.831Z | 2024-11-12T14:28:15.476Z |
5478270 | 5478270 | 20241104034448_hVsvc | BE000W | 2024-11-05T14:18:08.182Z | 2024-11-12T14:28:14.772Z |
5478009 | 5478009 | 20241104030654_08ruG | BE000W | 2024-11-05T14:17:44.663Z | 2024-11-12T14:28:13.842Z |
5478002 | 5478002 | 20241104030607_dm7hx | BE000W | 2024-11-05T14:17:44.026Z | 2024-11-12T14:28:13.828Z |
5477996 | 5477996 | 20241104030544_QD03g | BE000W | 2024-11-05T14:17:43.431Z | 2024-11-12T14:28:13.755Z |
5477926 | 5477926 | 20241104025352_DMGU4 | BE000W | 2024-11-05T14:17:37.063Z | 2024-11-12T14:28:13.311Z |
5477906 | 5477906 | 20241104025220_p3mAq | BE000W | 2024-11-05T14:17:35.748Z | 2024-11-12T14:28:13.212Z |
5477882 | 5477882 | 20241104025109_vNGa9 | BE000W | 2024-11-05T14:17:34.060Z | 2024-11-12T14:28:13.144Z |
5477879 | 5477879 | 20241104025057_gmx5J | BE000W | 2024-11-05T14:17:33.473Z | 2024-11-12T14:28:13.140Z |
5477817 | 5477817 | 20241104024043_wMIoO | BE000W | 2024-11-05T14:17:28.111Z | 2024-11-12T14:28:13.033Z |
5477769 | 5477769 | 20241104023325_7H8Nz | BE000W | 2024-11-05T14:17:23.854Z | 2024-11-12T14:28:12.870Z |
5477762 | 5477762 | 20241104023255_28732 | BE000W | 2024-11-05T14:17:23.379Z | 2024-11-12T14:28:12.828Z |
5477747 | 5477747 | 20241104023143_N1tXB | BE000W | 2024-11-05T14:17:21.995Z | 2024-11-12T14:28:12.599Z |
5477719 | 5477719 | 20241104022643_5PGnk | BE000W | 2024-11-05T14:17:19.280Z | 2024-11-12T14:28:12.529Z |
5477701 | 5477701 | 20241104022241_q4Jl5 | BE000W | 2024-11-05T14:17:16.244Z | 2024-11-12T14:28:12.469Z |
5477677 | 5477677 | 20241104021939_q4xuc | BE000W | 2024-11-05T14:17:14.310Z | 2024-11-12T14:28:12.397Z |
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);