participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
62 rows where station_code = "MY000E" 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 |
|---|---|---|---|---|---|
| 6760209 | 6760209 | 20250519203625_y5c3S | MY000E | 2025-05-21T12:19:10.052Z | 2025-05-28T13:12:15.900Z |
| 6741415 | 6741415 | 20250516214906_CKbbK | MY000E | 2025-05-18T12:19:28.321Z | 2025-05-24T12:40:54.411Z |
| 6741396 | 6741396 | 20250516214720_xu7GH | MY000E | 2025-05-18T12:19:19.237Z | 2025-05-24T12:40:54.054Z |
| 6698047 | 6698047 | 20250509212939_zOVEz | MY000E | 2025-05-11T12:04:23.913Z | 2025-05-18T12:33:31.181Z |
| 6697716 | 6697716 | 20250509202753_li38D | MY000E | 2025-05-11T12:03:20.634Z | 2025-05-18T12:33:26.790Z |
| 6678514 | 6678514 | 20250506215012_RCS3v | MY000E | 2025-05-08T12:15:01.587Z | 2025-05-15T12:37:23.361Z |
| 6678510 | 6678510 | 20250506214915_53fT8 | MY000E | 2025-05-08T12:15:01.480Z | 2025-05-15T12:37:23.340Z |
| 6678503 | 6678503 | 20250506214736_YeGN5 | MY000E | 2025-05-08T12:15:00.874Z | 2025-05-15T12:37:23.297Z |
| 6678362 | 6678362 | 20250506211951_9jNg9 | MY000E | 2025-05-08T12:14:36.260Z | 2025-05-15T12:37:19.531Z |
| 6678348 | 6678348 | 20250506211715_KAUxW | MY000E | 2025-05-08T12:14:35.629Z | 2025-05-15T12:37:19.287Z |
| 6678260 | 6678260 | 20250506210225_CVs3P | MY000E | 2025-05-08T12:14:25.531Z | 2025-05-15T12:37:17.712Z |
| 6678213 | 6678213 | 20250506204814_RqEpj | MY000E | 2025-05-08T12:14:21.600Z | 2025-05-15T12:37:16.810Z |
| 6678207 | 6678207 | 20250506204615_OXUiS | MY000E | 2025-05-08T12:14:20.737Z | 2025-05-15T12:37:16.745Z |
| 6668086 | 6668086 | 20250505214646_FGTyF | MY000E | 2025-05-07T12:14:47.946Z | 2025-05-14T12:40:26.798Z |
| 6668064 | 6668064 | 20250505214038_YKARe | MY000E | 2025-05-07T12:14:43.669Z | 2025-05-14T12:40:25.375Z |
| 6668040 | 6668040 | 20250505213403_EErXf | MY000E | 2025-05-07T12:14:36.735Z | 2025-05-14T12:40:25.017Z |
| 6667935 | 6667935 | 20250505211630_8td3G | MY000E | 2025-05-07T12:14:14.291Z | 2025-05-14T12:40:22.755Z |
| 6667903 | 6667903 | 20250505211114_s9OrX | MY000E | 2025-05-07T12:14:09.034Z | 2025-05-14T12:40:22.455Z |
| 6667848 | 6667848 | 20250505210446_jIg72 | MY000E | 2025-05-07T12:13:56.346Z | 2025-05-14T12:40:20.482Z |
| 6667791 | 6667791 | 20250505205439_OFmkV | MY000E | 2025-05-07T12:13:46.581Z | 2025-05-14T12:40:18.232Z |
| 6667785 | 6667785 | 20250505205001_2Llj1 | MY000E | 2025-05-07T12:13:45.607Z | 2025-05-14T12:40:18.216Z |
| 6667777 | 6667777 | 20250505204706_Q9I00 | MY000E | 2025-05-07T12:13:44.515Z | 2025-05-14T12:40:17.855Z |
| 6667773 | 6667773 | 20250505204600_9cuZs | MY000E | 2025-05-07T12:13:43.307Z | 2025-05-14T12:40:17.647Z |
| 6667750 | 6667750 | 20250505204052_hdq0N | MY000E | 2025-05-07T12:13:38.731Z | 2025-05-14T12:40:17.393Z |
| 6667737 | 6667737 | 20250505203935_0s0Dc | MY000E | 2025-05-07T12:13:34.459Z | 2025-05-14T12:40:17.250Z |
| 6667735 | 6667735 | 20250505203755_sv4z4 | MY000E | 2025-05-07T12:13:34.401Z | 2025-05-14T12:40:17.250Z |
| 6667715 | 6667715 | 20250505203306_vXUSr | MY000E | 2025-05-07T12:13:30.442Z | 2025-05-14T12:40:17.009Z |
| 6667667 | 6667667 | 20250505202021_W7FQs | MY000E | 2025-05-07T12:13:24.437Z | 2025-05-14T12:40:16.300Z |
| 6667653 | 6667653 | 20250505201321_KhrJx | MY000E | 2025-05-07T12:13:21.114Z | 2025-05-14T12:40:15.414Z |
| 6667602 | 6667602 | 20250505193851_yAOFU | MY000E | 2025-05-07T12:13:16.793Z | 2025-05-14T12:40:13.939Z |
| 6617304 | 6617304 | 20250430201950_UFdX7 | MY000E | 2025-05-02T12:08:00.380Z | 2025-05-09T12:37:37.831Z |
| 6583902 | 6583902 | 20250426221230_x7XuJ | MY000E | 2025-04-28T12:18:53.526Z | 2025-05-05T12:31:23.891Z |
| 6568639 | 6568639 | 20250424215342_hxLOK | MY000E | 2025-04-26T12:21:35.663Z | 2025-05-03T12:32:31.931Z |
| 6568581 | 6568581 | 20250424214409_0Vo0s | MY000E | 2025-04-26T12:21:30.339Z | 2025-05-03T12:32:31.861Z |
| 6568544 | 6568544 | 20250424213709_K93pH | MY000E | 2025-04-26T12:21:23.188Z | 2025-05-03T12:32:31.793Z |
| 6568379 | 6568379 | 20250424211715_oV9RE | MY000E | 2025-04-26T12:21:00.706Z | 2025-05-03T12:32:31.280Z |
| 6568345 | 6568345 | 20250424211133_gzUUy | MY000E | 2025-04-26T12:20:58.574Z | 2025-05-03T12:32:31.228Z |
| 6568293 | 6568293 | 20250424205802_ouGj0 | MY000E | 2025-04-26T12:20:54.542Z | 2025-05-03T12:32:31.062Z |
| 6568251 | 6568251 | 20250424205212_hkMYq | MY000E | 2025-04-26T12:20:50.619Z | 2025-05-03T12:32:30.844Z |
| 6550242 | 6550242 | 20250422175001_79Tb4 | MY000E | 2025-04-24T12:16:07.371Z | 2025-05-01T12:38:29.857Z |
| 6549859 | 6549859 | 20250422163932_6WxMQ | MY000E | 2025-04-24T12:15:29.502Z | 2025-05-01T12:38:26.395Z |
| 6549849 | 6549849 | 20250422161715_c1Plo | MY000E | 2025-04-24T12:15:10.688Z | 2025-05-01T12:38:26.017Z |
| 6549839 | 6549839 | 20250422153019_Gs5Rq | MY000E | 2025-04-24T12:14:22.802Z | 2025-05-01T12:38:25.462Z |
| 6549837 | 6549837 | 20250422151521_t17DS | MY000E | 2025-04-24T12:14:10.803Z | 2025-05-01T12:38:25.105Z |
| 6527782 | 6527782 | 20250420190336_oGLnb | MY000E | 2025-04-21T12:07:10.882Z | 2025-04-29T12:36:18.228Z |
| 6527739 | 6527739 | 20250420184202_dPTuV | MY000E | 2025-04-21T12:07:05.921Z | 2025-04-29T12:36:17.466Z |
| 6523936 | 6523936 | 20250419220848_L3073 | MY000E | 2025-04-20T12:03:49.550Z | 2025-04-28T12:41:01.869Z |
| 6523934 | 6523934 | 20250419215821_9jpxp | MY000E | 2025-04-20T12:03:49.243Z | 2025-04-28T12:41:01.425Z |
| 6523930 | 6523930 | 20250419213737_ci80Y | MY000E | 2025-04-20T12:03:48.487Z | 2025-04-28T12:40:59.926Z |
| 6523916 | 6523916 | 20250419202259_mhC2D | MY000E | 2025-04-20T12:03:45.600Z | 2025-04-28T12:40:55.295Z |
| 6523912 | 6523912 | 20250419201232_NXt37 | MY000E | 2025-04-20T12:03:44.729Z | 2025-04-28T12:40:54.939Z |
| 6523910 | 6523910 | 20250419201011_v7v2w | MY000E | 2025-04-20T12:03:44.239Z | 2025-04-28T12:40:54.823Z |
| 6521440 | 6521440 | 20250418193239_ZZt4Z | MY000E | 2025-04-19T12:05:44.797Z | 2025-04-27T12:35:21.679Z |
| 6521412 | 6521412 | 20250418190045_Udh9i | MY000E | 2025-04-19T12:05:38.878Z | 2025-04-27T12:35:21.307Z |
| 6521396 | 6521396 | 20250418182519_Uqz65 | MY000E | 2025-04-19T12:05:29.080Z | 2025-04-27T12:35:21.049Z |
| 6521390 | 6521390 | 20250418181250_aqGxx | MY000E | 2025-04-19T12:05:27.782Z | 2025-04-27T12:35:20.983Z |
| 6508328 | 6508328 | 20250411215652_tbZg2 | MY000E | 2025-04-13T12:11:36.845Z | 2025-04-19T12:26:19.486Z |
| 6494865 | 6494865 | 20250408221148_U62ID | MY000E | 2025-04-10T12:18:33.904Z | 2025-04-16T12:27:19.211Z |
| 6494820 | 6494820 | 20250408220321_2MkAP | MY000E | 2025-04-10T12:18:30.909Z | 2025-04-16T12:27:18.798Z |
| 6494504 | 6494504 | 20250408192109_EYzvC | MY000E | 2025-04-10T12:17:57.043Z | 2025-04-16T12:27:13.331Z |
| 6467735 | 6467735 | 20250405195017_o84P5 | MY000E | 2025-04-06T12:22:31.261Z | 2025-04-13T12:36:55.137Z |
| 6467692 | 6467692 | 20250405185641_lbRTp | MY000E | 2025-04-06T12:22:18.428Z | 2025-04-13T12:36:51.995Z |
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);