participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,874 rows where station_code = "BE0009" 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 |
---|---|---|---|---|---|
4983415 | 4983415 | 20240812004417_Q3cuQ | BE0009 | 2024-09-06T12:15:31.901Z | 2024-09-06T12:15:31.901Z |
4982265 | 4982265 | 20240812003154_fBFVh | BE0009 | 2024-09-06T12:14:48.221Z | 2024-09-06T12:14:48.221Z |
4982218 | 4982218 | 20240812003135_I8w8n | BE0009 | 2024-09-06T12:14:47.286Z | 2024-09-06T12:14:47.286Z |
4980974 | 4980974 | 20240812001801_M6R28 | BE0009 | 2024-09-06T12:14:25.267Z | 2024-09-06T12:14:25.267Z |
4980397 | 4980397 | 20240812001157_sONYi | BE0009 | 2024-09-06T12:13:58.728Z | 2024-09-06T12:13:58.728Z |
4980391 | 4980391 | 20240812001152_wRKqb | BE0009 | 2024-09-06T12:13:58.284Z | 2024-09-06T12:13:58.284Z |
4978966 | 4978966 | 20240811235750_AUYgg | BE0009 | 2024-09-06T12:12:47.537Z | 2024-09-06T12:12:47.537Z |
4978066 | 4978066 | 20240811234748_laFtQ | BE0009 | 2024-09-06T12:12:28.923Z | 2024-09-06T12:12:28.923Z |
4977554 | 4977554 | 20240811234059_39AcK | BE0009 | 2024-09-06T12:12:19.721Z | 2024-09-06T12:12:19.721Z |
4977506 | 4977506 | 20240811234020_PT2nl | BE0009 | 2024-09-06T12:12:18.288Z | 2024-09-06T12:12:18.288Z |
4976302 | 4976302 | 20240811232822_w4Y2x | BE0009 | 2024-09-06T12:11:23.648Z | 2024-09-06T12:11:23.648Z |
4975388 | 4975388 | 20240811231753_d1xzZ | BE0009 | 2024-09-05T12:11:48.686Z | 2024-09-06T12:10:41.036Z |
4974192 | 4974192 | 20240811230424_HQbVS | BE0009 | 2024-09-05T12:11:20.485Z | 2024-09-06T12:10:23.455Z |
4972659 | 4972659 | 20240811224905_Is14Q | BE0009 | 2024-09-05T12:10:31.058Z | 2024-09-06T12:09:22.918Z |
4972564 | 4972564 | 20240811224751_X2mlc | BE0009 | 2024-09-05T12:10:28.286Z | 2024-09-06T12:09:18.537Z |
4971073 | 4971073 | 20240811223139_P5ST8 | BE0009 | 2024-09-05T12:09:36.827Z | 2024-09-06T12:08:48.563Z |
4971005 | 4971005 | 20240811223100_dO2T8 | BE0009 | 2024-09-05T12:09:35.559Z | 2024-09-06T12:08:47.498Z |
4970676 | 4970676 | 20240811222800_MLXEG | BE0009 | 2024-09-05T12:09:31.072Z | 2024-09-06T12:08:43.982Z |
4970102 | 4970102 | 20240811222103_7EFQE | BE0009 | 2024-09-05T12:09:18.744Z | 2024-09-06T12:08:22.417Z |
4969962 | 4969962 | 20240811221917_G0qHY | BE0009 | 2024-09-05T12:09:12.306Z | 2024-09-06T12:08:15.313Z |
4969330 | 4969330 | 20240811220958_N8hsa | BE0009 | 2024-09-05T12:08:40.332Z | 2024-09-06T12:07:49.672Z |
4968740 | 4968740 | 20240811220226_boiBY | BE0009 | 2024-09-05T12:08:26.174Z | 2024-09-06T12:07:35.465Z |
4968583 | 4968583 | 20240811215954_U2h4z | BE0009 | 2024-09-05T12:08:22.751Z | 2024-09-06T12:07:32.772Z |
4968559 | 4968559 | 20240811215933_Yy2Nw | BE0009 | 2024-09-05T12:08:22.097Z | 2024-09-06T12:07:32.079Z |
4968202 | 4968202 | 20240811215529_Mx901 | BE0009 | 2024-09-05T12:08:06.909Z | 2024-09-06T12:07:26.290Z |
4967808 | 4967808 | 20240811215002_QsMg8 | BE0009 | 2024-09-05T12:07:49.232Z | 2024-09-06T12:07:09.178Z |
4967102 | 4967102 | 20240811213844_yygP0 | BE0009 | 2024-09-05T12:07:30.482Z | 2024-09-06T12:06:53.307Z |
4966990 | 4966990 | 20240811213714_2h7Zq | BE0009 | 2024-09-05T12:07:27.763Z | 2024-09-06T12:06:51.365Z |
4966003 | 4966003 | 20240811212158_t3FgA | BE0009 | 2024-09-04T12:07:16.202Z | 2024-09-06T12:06:09.370Z |
4964874 | 4964874 | 20240811210445_VPa6m | BE0009 | 2024-09-04T12:06:37.786Z | 2024-09-06T12:05:41.377Z |
4964570 | 4964570 | 20240811205821_JCm7J | BE0009 | 2024-09-04T12:06:27.100Z | 2024-09-06T12:05:25.235Z |
4964458 | 4964458 | 20240811205453_h6YIa | BE0009 | 2024-09-04T12:06:22.715Z | 2024-09-06T12:05:20.964Z |
4964417 | 4964417 | 20240811205352_jcRL4 | BE0009 | 2024-09-04T12:06:21.352Z | 2024-09-06T12:05:19.663Z |
4963838 | 4963838 | 20240811203724_SwAXc | BE0009 | 2024-09-04T12:05:57.634Z | 2024-09-06T12:04:57.827Z |
4963604 | 4963604 | 20240811202508_0ng8c | BE0009 | 2024-09-04T12:05:45.346Z | 2024-09-06T12:04:46.098Z |
4954400 | 4954400 | 20240811025937_FImmi | BE0009 | 2024-09-03T12:18:13.168Z | 2024-09-06T12:28:59.925Z |
4954241 | 4954241 | 20240811025536_uRYJK | BE0009 | 2024-09-03T12:18:10.346Z | 2024-09-06T12:28:54.471Z |
4953705 | 4953705 | 20240811024331_7Vq2u | BE0009 | 2024-09-03T12:17:54.496Z | 2024-09-06T12:28:34.738Z |
4953126 | 4953126 | 20240811023330_tmGRG | BE0009 | 2024-09-03T12:17:20.769Z | 2024-09-06T12:28:19.846Z |
4953011 | 4953011 | 20240811023100_98rOq | BE0009 | 2024-09-03T12:17:11.754Z | 2024-09-06T12:28:15.515Z |
4952762 | 4952762 | 20240811022656_0MvPu | BE0009 | 2024-09-03T12:17:05.395Z | 2024-09-06T12:28:08.478Z |
4952687 | 4952687 | 20240811022549_SLP40 | BE0009 | 2024-09-03T12:17:04.345Z | 2024-09-06T12:28:07.160Z |
4952513 | 4952513 | 20240811022348_8by4j | BE0009 | 2024-09-03T12:17:00.078Z | 2024-09-06T12:28:04.132Z |
4952253 | 4952253 | 20240811021807_5ODQh | BE0009 | 2024-09-03T12:16:53.223Z | 2024-09-06T12:27:53.938Z |
4952038 | 4952038 | 20240811021500_zCnNt | BE0009 | 2024-09-03T12:16:43.024Z | 2024-09-06T12:27:51.967Z |
4950758 | 4950758 | 20240811021133_bM8sD | BE0009 | 2024-09-02T12:16:35.651Z | 2024-09-06T12:27:49.413Z |
4949838 | 4949838 | 20240811015622_2qC6F | BE0009 | 2024-09-02T12:15:57.063Z | 2024-09-06T12:27:38.109Z |
4949609 | 4949609 | 20240811015256_5XR5g | BE0009 | 2024-09-02T12:15:50.833Z | 2024-09-06T12:27:35.732Z |
4948931 | 4948931 | 20240811014252_lqE2S | BE0009 | 2024-09-02T12:15:26.123Z | 2024-09-06T12:27:28.392Z |
4948396 | 4948396 | 20240811013324_V0pEo | BE0009 | 2024-09-02T12:15:01.700Z | 2024-09-06T12:27:16.642Z |
4946667 | 4946667 | 20240811010436_gUfm0 | BE0009 | 2024-09-02T12:14:03.020Z | 2024-09-06T12:26:29.858Z |
4946484 | 4946484 | 20240811010141_6dBdp | BE0009 | 2024-09-02T12:13:57.289Z | 2024-09-06T12:26:24.067Z |
4945722 | 4945722 | 20240811005058_sEkQN | BE0009 | 2024-09-02T12:13:24.546Z | 2024-09-06T12:26:03.710Z |
4945335 | 4945335 | 20240811004434_dDIEA | BE0009 | 2024-09-02T12:13:15.296Z | 2024-09-06T12:25:53.278Z |
4944546 | 4944546 | 20240811003133_JU9nT | BE0009 | 2024-09-02T12:12:35.807Z | 2024-09-06T12:25:26.721Z |
4944401 | 4944401 | 20240811002853_W33uk | BE0009 | 2024-09-02T12:12:30.656Z | 2024-09-06T12:25:20.928Z |
4944246 | 4944246 | 20240811002542_KweVr | BE0009 | 2024-09-02T12:12:25.941Z | 2024-09-06T12:25:16.471Z |
4944218 | 4944218 | 20240811002527_RqsYg | BE0009 | 2024-09-02T12:12:25.531Z | 2024-09-06T12:25:16.146Z |
4944100 | 4944100 | 20240811002257_tt2io | BE0009 | 2024-09-02T12:12:21.300Z | 2024-09-06T12:25:12.424Z |
4943679 | 4943679 | 20240811001532_TXFrJ | BE0009 | 2024-09-02T12:12:04.511Z | 2024-09-06T12:25:01.373Z |
4943390 | 4943390 | 20240811001049_3QCAM | BE0009 | 2024-09-02T12:11:49.532Z | 2024-09-06T12:24:47.041Z |
4942165 | 4942165 | 20240810234725_ApzAb | BE0009 | 2024-09-02T12:11:04.440Z | 2024-09-06T12:24:08.474Z |
4942059 | 4942059 | 20240810234532_eYGhq | BE0009 | 2024-09-02T12:11:01.797Z | 2024-09-06T12:24:05.598Z |
4941598 | 4941598 | 20240810233604_xiGII | BE0009 | 2024-09-02T12:10:37.229Z | 2024-09-06T12:23:50.909Z |
4941200 | 4941200 | 20240810232841_TXeM7 | BE0009 | 2024-09-02T12:10:21.541Z | 2024-09-06T12:23:44.841Z |
4941130 | 4941130 | 20240810232715_o2DrV | BE0009 | 2024-09-02T12:10:14.998Z | 2024-09-06T12:23:43.879Z |
4940583 | 4940583 | 20240810231532_a7AY2 | BE0009 | 2024-09-01T12:10:36.798Z | 2024-09-06T12:23:36.749Z |
4939070 | 4939070 | 20240810223643_GljIr | BE0009 | 2024-09-01T12:09:36.305Z | 2024-09-06T12:23:12.689Z |
4938959 | 4938959 | 20240810223312_r5F7O | BE0009 | 2024-09-01T12:09:32.685Z | 2024-09-06T12:23:09.010Z |
4938772 | 4938772 | 20240810222835_wjxPi | BE0009 | 2024-09-01T12:09:20.412Z | 2024-09-06T12:23:03.088Z |
4938557 | 4938557 | 20240810222219_HwKMl | BE0009 | 2024-09-01T12:09:10.629Z | 2024-09-06T12:22:56.671Z |
4937561 | 4937561 | 20240810215427_TH5Ox | BE0009 | 2024-09-01T12:08:27.768Z | 2024-09-06T12:22:20.732Z |
4937490 | 4937490 | 20240810215207_KNfTm | BE0009 | 2024-09-01T12:08:22.437Z | 2024-09-06T12:22:17.524Z |
4936854 | 4936854 | 20240810213300_m3h2m | BE0009 | 2024-09-01T12:07:48.842Z | 2024-09-06T12:21:50.685Z |
4936725 | 4936725 | 20240810212850_Jvq36 | BE0009 | 2024-09-01T12:07:43.071Z | 2024-09-06T12:21:45.108Z |
4936709 | 4936709 | 20240810212811_Z1X2y | BE0009 | 2024-09-01T12:07:42.101Z | 2024-09-06T12:21:44.679Z |
4936459 | 4936459 | 20240810211911_0p3HB | BE0009 | 2024-09-01T12:07:32.374Z | 2024-09-06T12:21:34.603Z |
4936427 | 4936427 | 20240810211734_wZpJw | BE0009 | 2024-09-01T12:07:31.099Z | 2024-09-06T12:21:32.966Z |
4936100 | 4936100 | 20240810210106_LfEsl | BE0009 | 2024-09-01T12:07:07.809Z | 2024-09-06T12:21:14.598Z |
4936007 | 4936007 | 20240810205708_AWSFR | BE0009 | 2024-09-01T12:07:04.490Z | 2024-09-06T12:21:11.793Z |
4935971 | 4935971 | 20240810205511_KNhuL | BE0009 | 2024-09-01T12:07:02.957Z | 2024-09-06T12:21:10.153Z |
4935606 | 4935606 | 20240810203217_XIPLQ | BE0009 | 2024-09-01T12:06:40.017Z | 2024-09-06T12:20:47.574Z |
4935596 | 4935596 | 20240810203056_Bc7Nl | BE0009 | 2024-09-01T12:06:37.708Z | 2024-09-06T12:20:46.346Z |
4928668 | 4928668 | 20240810024556_JF1XF | BE0009 | 2024-08-31T12:21:34.385Z | 2024-09-02T12:29:14.412Z |
4928295 | 4928295 | 20240810023602_0D3Ea | BE0009 | 2024-08-31T12:21:17.476Z | 2024-09-02T12:29:06.379Z |
4927591 | 4927591 | 20240810021614_9UzfG | BE0009 | 2024-08-31T12:20:44.579Z | 2024-09-02T12:28:43.171Z |
4927199 | 4927199 | 20240810020630_Qb6Yl | BE0009 | 2024-08-31T12:20:20.062Z | 2024-09-02T12:28:23.689Z |
4926894 | 4926894 | 20240810020040_OcvAL | BE0009 | 2024-08-31T12:20:08.763Z | 2024-09-02T12:28:10.960Z |
4926440 | 4926440 | 20240810015010_p9Jd1 | BE0009 | 2024-08-31T12:19:40.127Z | 2024-09-02T12:27:51.666Z |
4926081 | 4926081 | 20240810014024_G2ynV | BE0009 | 2024-08-31T12:19:28.900Z | 2024-09-02T12:27:41.154Z |
4922304 | 4922304 | 20240810011443_wmrGV | BE0009 | 2024-08-30T12:14:47.407Z | 2024-09-02T12:27:25.511Z |
4921829 | 4921829 | 20240810010348_DcaUe | BE0009 | 2024-08-30T12:14:23.178Z | 2024-09-02T12:27:15.289Z |
4920147 | 4920147 | 20240810002605_TukDs | BE0009 | 2024-08-30T12:13:09.848Z | 2024-09-02T12:26:14.364Z |
4920056 | 4920056 | 20240810002407_Ew7A7 | BE0009 | 2024-08-30T12:13:06.778Z | 2024-09-02T12:26:11.411Z |
4919901 | 4919901 | 20240810002105_P2uVS | BE0009 | 2024-08-30T12:13:02.394Z | 2024-09-02T12:26:05.019Z |
4918573 | 4918573 | 20240809235428_ymxK4 | BE0009 | 2024-08-30T12:12:06.347Z | 2024-09-02T12:25:33.591Z |
4917318 | 4917318 | 20240809233132_E15q1 | BE0009 | 2024-08-30T12:11:21.290Z | 2024-09-02T12:24:59.230Z |
4915920 | 4915920 | 20240809230035_n6Kf6 | BE0009 | 2024-08-30T12:10:22.149Z | 2024-09-02T12:24:06.878Z |
4914582 | 4914582 | 20240809222328_0Zevg | BE0009 | 2024-08-30T12:09:17.596Z | 2024-09-02T12:23:37.530Z |
4914216 | 4914216 | 20240809221048_GWplb | BE0009 | 2024-08-30T12:09:02.526Z | 2024-09-02T12:23:20.614Z |
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);