participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
661 rows where station_code = "BE000R" 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 |
---|---|---|---|---|---|
4983385 | 4983385 | 20240812004359_IK5Yr | BE000R | 2024-09-06T12:15:30.500Z | 2024-09-06T12:15:30.500Z |
4983228 | 4983228 | 20240812004223_tZhn0 | BE000R | 2024-09-06T12:15:21.875Z | 2024-09-06T12:15:21.875Z |
4982917 | 4982917 | 20240812003915_Beqv8 | BE000R | 2024-09-06T12:15:07.367Z | 2024-09-06T12:15:07.367Z |
4982559 | 4982559 | 20240812003453_0p92e | BE000R | 2024-09-06T12:14:56.046Z | 2024-09-06T12:14:56.046Z |
4982554 | 4982554 | 20240812003453_l5RR3 | BE000R | 2024-09-06T12:14:56.018Z | 2024-09-06T12:14:56.018Z |
4981749 | 4981749 | 20240812002704_GbCnY | BE000R | 2024-09-06T12:14:37.206Z | 2024-09-06T12:14:37.206Z |
4981725 | 4981725 | 20240812002644_fo4hy | BE000R | 2024-09-06T12:14:36.835Z | 2024-09-06T12:14:36.835Z |
4981616 | 4981616 | 20240812002442_Ac76h | BE000R | 2024-09-06T12:14:34.577Z | 2024-09-06T12:14:34.577Z |
4979917 | 4979917 | 20240812000608_gN0qr | BE000R | 2024-09-06T12:13:35.049Z | 2024-09-06T12:13:35.049Z |
4978425 | 4978425 | 20240811235043_5pk1U | BE000R | 2024-09-06T12:12:33.515Z | 2024-09-06T12:12:33.515Z |
4976855 | 4976855 | 20240811233403_xOC2Q | BE000R | 2024-09-06T12:11:53.738Z | 2024-09-06T12:11:53.738Z |
4976086 | 4976086 | 20240811232537_iWwJw | BE000R | 2024-09-06T12:11:09.607Z | 2024-09-06T12:11:09.607Z |
4975336 | 4975336 | 20240811231718_xeblS | BE000R | 2024-09-05T12:11:45.469Z | 2024-09-06T12:10:40.002Z |
4975132 | 4975132 | 20240811231501_c8ZSo | BE000R | 2024-09-05T12:11:40.315Z | 2024-09-06T12:10:37.579Z |
4974879 | 4974879 | 20240811231237_7vnww | BE000R | 2024-09-05T12:11:34.473Z | 2024-09-06T12:10:34.165Z |
4974716 | 4974716 | 20240811231029_IuXch | BE000R | 2024-09-05T12:11:30.939Z | 2024-09-06T12:10:31.765Z |
4974195 | 4974195 | 20240811230424_HQbVS | BE000R | 2024-09-05T12:11:20.485Z | 2024-09-06T12:10:23.455Z |
4972931 | 4972931 | 20240811225203_U9416 | BE000R | 2024-09-05T12:10:38.505Z | 2024-09-06T12:09:34.501Z |
4972587 | 4972587 | 20240811224822_rsZUQ | BE000R | 2024-09-05T12:10:28.742Z | 2024-09-06T12:09:19.485Z |
4972544 | 4972544 | 20240811224733_iZNpA | BE000R | 2024-09-05T12:10:27.915Z | 2024-09-06T12:09:17.967Z |
4972132 | 4972132 | 20240811224318_AFlKL | BE000R | 2024-09-05T12:10:17.753Z | 2024-09-06T12:09:05.128Z |
4971990 | 4971990 | 20240811224215_3dy2c | BE000R | 2024-09-05T12:10:12.408Z | 2024-09-06T12:09:03.586Z |
4971821 | 4971821 | 20240811224024_onFT3 | BE000R | 2024-09-05T12:10:04.514Z | 2024-09-06T12:08:58.919Z |
4971702 | 4971702 | 20240811223853_vrqla | BE000R | 2024-09-05T12:09:55.392Z | 2024-09-06T12:08:56.741Z |
4971528 | 4971528 | 20240811223649_jFp42 | BE000R | 2024-09-05T12:09:46.429Z | 2024-09-06T12:08:54.206Z |
4971475 | 4971475 | 20240811223544_m3UN0 | BE000R | 2024-09-05T12:09:44.710Z | 2024-09-06T12:08:53.699Z |
4971064 | 4971064 | 20240811223130_6MRSO | BE000R | 2024-09-05T12:09:36.508Z | 2024-09-06T12:08:48.376Z |
4970808 | 4970808 | 20240811222842_1KU5w | BE000R | 2024-09-05T12:09:32.386Z | 2024-09-06T12:08:44.923Z |
4969704 | 4969704 | 20240811221448_zC8PG | BE000R | 2024-09-05T12:08:55.545Z | 2024-09-06T12:07:59.265Z |
4969018 | 4969018 | 20240811220600_d1qEN | BE000R | 2024-09-05T12:08:33.872Z | 2024-09-06T12:07:41.625Z |
4968657 | 4968657 | 20240811220049_PwAtz | BE000R | 2024-09-05T12:08:23.997Z | 2024-09-06T12:07:33.828Z |
4968574 | 4968574 | 20240811215942_iHbGe | BE000R | 2024-09-05T12:08:22.411Z | 2024-09-06T12:07:32.508Z |
4968364 | 4968364 | 20240811215706_8Ny24 | BE000R | 2024-09-05T12:08:14.564Z | 2024-09-06T12:07:28.801Z |
4968126 | 4968126 | 20240811215438_DaBvv | BE000R | 2024-09-05T12:08:03.365Z | 2024-09-06T12:07:24.835Z |
4966370 | 4966370 | 20240811212855_z2rvX | BE000R | 2024-09-04T12:07:25.679Z | 2024-09-06T12:06:26.679Z |
4965854 | 4965854 | 20240811212045_IS3Dn | BE000R | 2024-09-04T12:07:09.240Z | 2024-09-06T12:06:07.606Z |
4965791 | 4965791 | 20240811211941_9ejPn | BE000R | 2024-09-04T12:07:08.108Z | 2024-09-06T12:06:06.465Z |
4965528 | 4965528 | 20240811211622_FQ7cj | BE000R | 2024-09-04T12:07:00.288Z | 2024-09-06T12:05:59.004Z |
4965162 | 4965162 | 20240811210934_UmB8q | BE000R | 2024-09-04T12:06:50.240Z | 2024-09-06T12:05:49.537Z |
4965130 | 4965130 | 20240811210901_Yys0k | BE000R | 2024-09-04T12:06:48.724Z | 2024-09-06T12:05:48.258Z |
4965118 | 4965118 | 20240811210851_V0yU4 | BE000R | 2024-09-04T12:06:48.148Z | 2024-09-06T12:05:47.799Z |
4964610 | 4964610 | 20240811205919_GElb1 | BE000R | 2024-09-04T12:06:29.143Z | 2024-09-06T12:05:26.302Z |
4964060 | 4964060 | 20240811204439_chMlW | BE000R | 2024-09-04T12:06:06.855Z | 2024-09-06T12:05:10.058Z |
4963975 | 4963975 | 20240811204226_9ekY3 | BE000R | 2024-09-04T12:06:02.863Z | 2024-09-06T12:05:07.491Z |
4953859 | 4953859 | 20240811024715_wBDwt | BE000R | 2024-09-03T12:18:02.452Z | 2024-09-06T12:28:40.673Z |
4953449 | 4953449 | 20240811023835_L2F2U | BE000R | 2024-09-03T12:17:41.666Z | 2024-09-06T12:28:26.680Z |
4953030 | 4953030 | 20240811023118_3Hjkf | BE000R | 2024-09-03T12:17:12.810Z | 2024-09-06T12:28:16.174Z |
4952861 | 4952861 | 20240811022803_ovBX7 | BE000R | 2024-09-03T12:17:07.576Z | 2024-09-06T12:28:11.051Z |
4952610 | 4952610 | 20240811022451_d6SDq | BE000R | 2024-09-03T12:17:02.899Z | 2024-09-06T12:28:06.268Z |
4952478 | 4952478 | 20240811022310_Cv43o | BE000R | 2024-09-03T12:16:59.163Z | 2024-09-06T12:28:02.866Z |
4952395 | 4952395 | 20240811022103_rK5fX | BE000R | 2024-09-03T12:16:56.972Z | 2024-09-06T12:27:59.685Z |
4950635 | 4950635 | 20240811021014_9Iy2P | BE000R | 2024-09-02T12:16:33.070Z | 2024-09-06T12:27:46.643Z |
4950276 | 4950276 | 20240811020436_c9Fk5 | BE000R | 2024-09-02T12:16:19.946Z | 2024-09-06T12:27:42.843Z |
4948873 | 4948873 | 20240811014205_lSCdV | BE000R | 2024-09-02T12:15:21.950Z | 2024-09-06T12:27:27.817Z |
4948835 | 4948835 | 20240811014154_V3XwK | BE000R | 2024-09-02T12:15:21.004Z | 2024-09-06T12:27:27.646Z |
4948807 | 4948807 | 20240811014103_TGBEL | BE000R | 2024-09-02T12:15:19.811Z | 2024-09-06T12:27:27.348Z |
4948631 | 4948631 | 20240811013725_XjZGA | BE000R | 2024-09-02T12:15:09.317Z | 2024-09-06T12:27:22.211Z |
4948304 | 4948304 | 20240811013208_YWYNq | BE000R | 2024-09-02T12:14:59.428Z | 2024-09-06T12:27:14.355Z |
4948259 | 4948259 | 20240811013135_V2cKC | BE000R | 2024-09-02T12:14:58.019Z | 2024-09-06T12:27:12.251Z |
4947861 | 4947861 | 20240811012611_fpc94 | BE000R | 2024-09-02T12:14:49.311Z | 2024-09-06T12:27:03.662Z |
4947586 | 4947586 | 20240811012119_ieQAB | BE000R | 2024-09-02T12:14:39.481Z | 2024-09-06T12:26:55.553Z |
4947451 | 4947451 | 20240811011852_WOoGE | BE000R | 2024-09-02T12:14:32.333Z | 2024-09-06T12:26:53.267Z |
4947066 | 4947066 | 20240811011248_zwXGV | BE000R | 2024-09-02T12:14:15.929Z | 2024-09-06T12:26:44.026Z |
4946877 | 4946877 | 20240811010915_34tRI | BE000R | 2024-09-02T12:14:10.586Z | 2024-09-06T12:26:38.707Z |
4946768 | 4946768 | 20240811010613_bB71J | BE000R | 2024-09-02T12:14:06.827Z | 2024-09-06T12:26:33.729Z |
4946548 | 4946548 | 20240811010225_2NSWW | BE000R | 2024-09-02T12:14:00.535Z | 2024-09-06T12:26:26.009Z |
4946534 | 4946534 | 20240811010218_g7jzw | BE000R | 2024-09-02T12:13:59.753Z | 2024-09-06T12:26:25.320Z |
4946105 | 4946105 | 20240811005705_YHLYj | BE000R | 2024-09-02T12:13:35.601Z | 2024-09-06T12:26:14.755Z |
4946048 | 4946048 | 20240811005602_kM2eA | BE000R | 2024-09-02T12:13:34.337Z | 2024-09-06T12:26:13.420Z |
4945857 | 4945857 | 20240811005233_3imhh | BE000R | 2024-09-02T12:13:27.075Z | 2024-09-06T12:26:06.929Z |
4945425 | 4945425 | 20240811004551_uFU8V | BE000R | 2024-09-02T12:13:17.002Z | 2024-09-06T12:25:54.971Z |
4945355 | 4945355 | 20240811004451_Iip7M | BE000R | 2024-09-02T12:13:15.818Z | 2024-09-06T12:25:53.915Z |
4945301 | 4945301 | 20240811004409_OlLLL | BE000R | 2024-09-02T12:13:14.345Z | 2024-09-06T12:25:51.848Z |
4944879 | 4944879 | 20240811003806_12OxV | BE000R | 2024-09-02T12:12:54.236Z | 2024-09-06T12:25:41.484Z |
4944339 | 4944339 | 20240811002758_3NYjQ | BE000R | 2024-09-02T12:12:28.295Z | 2024-09-06T12:25:19.001Z |
4944274 | 4944274 | 20240811002610_JIgbd | BE000R | 2024-09-02T12:12:26.558Z | 2024-09-06T12:25:16.870Z |
4943695 | 4943695 | 20240811001548_ac88n | BE000R | 2024-09-02T12:12:05.111Z | 2024-09-06T12:25:01.535Z |
4943393 | 4943393 | 20240811001049_3QCAM | BE000R | 2024-09-02T12:11:49.532Z | 2024-09-06T12:24:47.042Z |
4943109 | 4943109 | 20240811000544_31CLB | BE000R | 2024-09-02T12:11:42.408Z | 2024-09-06T12:24:38.856Z |
4942522 | 4942522 | 20240810235323_ZtyCU | BE000R | 2024-09-02T12:11:16.660Z | 2024-09-06T12:24:20.253Z |
4942312 | 4942312 | 20240810234926_AOs1v | BE000R | 2024-09-02T12:11:08.559Z | 2024-09-06T12:24:12.457Z |
4942014 | 4942014 | 20240810234347_46HNe | BE000R | 2024-09-02T12:10:59.691Z | 2024-09-06T12:24:02.643Z |
4941981 | 4941981 | 20240810234311_uh9I2 | BE000R | 2024-09-02T12:10:58.911Z | 2024-09-06T12:24:01.741Z |
4941720 | 4941720 | 20240810233828_0q0Wh | BE000R | 2024-09-02T12:10:44.020Z | 2024-09-06T12:23:52.241Z |
4941465 | 4941465 | 20240810233326_RG8If | BE000R | 2024-09-02T12:10:30.458Z | 2024-09-06T12:23:48.615Z |
4941267 | 4941267 | 20240810232941_NDsnw | BE000R | 2024-09-02T12:10:24.025Z | 2024-09-06T12:23:45.412Z |
4941173 | 4941173 | 20240810232748_JYG7O | BE000R | 2024-09-02T12:10:17.664Z | 2024-09-06T12:23:44.193Z |
4941134 | 4941134 | 20240810232715_o2DrV | BE000R | 2024-09-02T12:10:15.173Z | 2024-09-06T12:23:43.879Z |
4928941 | 4928941 | 20240810025751_MS0cO | BE000R | 2024-08-31T12:21:45.888Z | 2024-09-02T12:29:24.346Z |
4928658 | 4928658 | 20240810024525_XDEIu | BE000R | 2024-08-31T12:21:33.646Z | 2024-09-02T12:29:14.218Z |
4928534 | 4928534 | 20240810024248_b3dGZ | BE000R | 2024-08-31T12:21:25.796Z | 2024-09-02T12:29:12.171Z |
4928455 | 4928455 | 20240810024104_sYCVr | BE000R | 2024-08-31T12:21:22.394Z | 2024-09-02T12:29:10.205Z |
4928418 | 4928418 | 20240810024013_I47ae | BE000R | 2024-08-31T12:21:21.386Z | 2024-09-02T12:29:09.037Z |
4927909 | 4927909 | 20240810022513_NEYGN | BE000R | 2024-08-31T12:21:03.343Z | 2024-09-02T12:28:53.615Z |
4927690 | 4927690 | 20240810021832_vAIxn | BE000R | 2024-08-31T12:20:49.076Z | 2024-09-02T12:28:48.263Z |
4927539 | 4927539 | 20240810021543_l2vbu | BE000R | 2024-08-31T12:20:42.826Z | 2024-09-02T12:28:40.752Z |
4927411 | 4927411 | 20240810021214_jHWEI | BE000R | 2024-08-31T12:20:34.809Z | 2024-09-02T12:28:33.522Z |
4927386 | 4927386 | 20240810021135_APsa1 | BE000R | 2024-08-31T12:20:32.234Z | 2024-09-02T12:28:31.891Z |
4927063 | 4927063 | 20240810020323_88Olc | BE000R | 2024-08-31T12:20:15.223Z | 2024-09-02T12:28:16.761Z |
4927039 | 4927039 | 20240810020304_0WCDu | BE000R | 2024-08-31T12:20:13.831Z | 2024-09-02T12:28:15.304Z |
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);