participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,062 rows where station_code = "LU0002" 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 |
|---|---|---|---|---|---|
| 9616638 | 9616638 | 20260406033946_6pgF6 | LU0002 | 2026-04-07T12:13:09.798Z | 2026-04-07T12:13:20.023Z |
| 9616271 | 9616271 | 20260406024434_kY4OB | LU0002 | 2026-04-07T12:12:32.159Z | 2026-04-07T12:13:19.948Z |
| 9616264 | 9616264 | 20260406024257_PV7Ya | LU0002 | 2026-04-07T12:12:31.307Z | 2026-04-07T12:13:19.946Z |
| 9616102 | 9616102 | 20260406022130_zKlwD | LU0002 | 2026-04-07T12:12:08.820Z | 2026-04-07T12:13:19.914Z |
| 9616044 | 9616044 | 20260406021753_rYwvX | LU0002 | 2026-04-07T12:12:03.920Z | 2026-04-07T12:13:19.904Z |
| 9615639 | 9615639 | 20260406013614_kBv33 | LU0002 | 2026-04-07T12:11:08.022Z | 2026-04-07T12:13:19.836Z |
| 9615305 | 9615305 | 20260406005914_DwFKK | LU0002 | 2026-04-07T12:10:35.385Z | 2026-04-07T12:13:19.778Z |
| 9615269 | 9615269 | 20260406005413_Ylz3a | LU0002 | 2026-04-07T12:10:27.450Z | 2026-04-07T12:13:19.770Z |
| 9615248 | 9615248 | 20260406005224_sabsh | LU0002 | 2026-04-07T12:10:19.643Z | 2026-04-07T12:13:19.764Z |
| 9615125 | 9615125 | 20260406003955_gjPjg | LU0002 | 2026-04-07T12:10:04.164Z | 2026-04-07T12:13:19.740Z |
| 9614843 | 9614843 | 20260406000006_KFt5E | LU0002 | 2026-04-07T12:09:28.513Z | 2026-04-07T12:13:19.682Z |
| 9614725 | 9614725 | 20260405234451_rChL9 | LU0002 | 2026-04-07T12:09:19.629Z | 2026-04-07T12:13:19.663Z |
| 9614547 | 9614547 | 20260405232239_FbHC7 | LU0002 | 2026-04-07T12:08:55.989Z | 2026-04-07T12:13:19.626Z |
| 9614238 | 9614238 | 20260405223950_S3trg | LU0002 | 2026-04-07T12:08:17.187Z | 2026-04-07T12:13:19.552Z |
| 9614187 | 9614187 | 20260405222905_sEHpD | LU0002 | 2026-04-07T12:08:10.246Z | 2026-04-07T12:13:19.538Z |
| 9614131 | 9614131 | 20260405221929_SG0J7 | LU0002 | 2026-04-07T12:08:01.510Z | 2026-04-07T12:13:19.528Z |
| 9613943 | 9613943 | 20260405214146_e8cXt | LU0002 | 2026-04-07T12:07:40.890Z | 2026-04-07T12:13:19.489Z |
| 9611697 | 9611697 | 20260405031553_TjdEb | LU0002 | 2026-04-06T12:15:46.476Z | 2026-04-07T12:16:27.784Z |
| 9611543 | 9611543 | 20260405023310_oSKlU | LU0002 | 2026-04-06T12:15:02.348Z | 2026-04-07T12:16:14.653Z |
| 9611294 | 9611294 | 20260405011833_VNIL4 | LU0002 | 2026-04-06T12:13:54.166Z | 2026-04-07T12:16:02.779Z |
| 9611196 | 9611196 | 20260405004829_EHmjT | LU0002 | 2026-04-06T12:13:27.548Z | 2026-04-07T12:15:58.878Z |
| 9611135 | 9611135 | 20260405002813_f7hRs | LU0002 | 2026-04-06T12:13:09.098Z | 2026-04-07T12:15:55.917Z |
| 9610877 | 9610877 | 20260404224016_Fwc3k | LU0002 | 2026-04-06T12:11:52.962Z | 2026-04-07T12:15:37.920Z |
| 9610871 | 9610871 | 20260404223625_S6BEd | LU0002 | 2026-04-06T12:11:45.625Z | 2026-04-07T12:15:37.592Z |
| 9610869 | 9610869 | 20260404223615_TZi1N | LU0002 | 2026-04-06T12:11:45.221Z | 2026-04-07T12:15:37.467Z |
| 9610770 | 9610770 | 20260404214121_K2YKA | LU0002 | 2026-04-06T12:11:09.984Z | 2026-04-07T12:15:32.812Z |
| 9610740 | 9610740 | 20260404212646_5rge1 | LU0002 | 2026-04-06T12:11:00.880Z | 2026-04-07T12:15:31.198Z |
| 9610696 | 9610696 | 20260404211524_koLUO | LU0002 | 2026-04-06T12:10:47.616Z | 2026-04-07T12:15:29.364Z |
| 9606988 | 9606988 | 20260403014834_yITO0 | LU0002 | 2026-04-04T12:12:40.042Z | 2026-04-07T12:20:24.488Z |
| 9606915 | 9606915 | 20260402235518_U4iRO | LU0002 | 2026-04-04T12:12:15.997Z | 2026-04-07T12:20:21.121Z |
| 9606879 | 9606879 | 20260402225520_Al2Vw | LU0002 | 2026-04-04T12:12:08.679Z | 2026-04-07T12:20:20.027Z |
| 9606854 | 9606854 | 20260402222604_6nuiK | LU0002 | 2026-04-04T12:11:59.354Z | 2026-04-07T12:20:19.296Z |
| 9606852 | 9606852 | 20260402222604_Emgkn | LU0002 | 2026-04-04T12:11:58.946Z | 2026-04-07T12:20:19.239Z |
| 9606838 | 9606838 | 20260402220512_P3N8Z | LU0002 | 2026-04-04T12:11:53.589Z | 2026-04-07T12:20:18.716Z |
| 9606833 | 9606833 | 20260402220243_0LbsE | LU0002 | 2026-04-04T12:11:52.689Z | 2026-04-07T12:20:18.576Z |
| 9604930 | 9604930 | 20260402020512_y28QH | LU0002 | 2026-04-03T12:12:20.570Z | 2026-04-07T12:21:54.720Z |
| 9604891 | 9604891 | 20260402013954_84ItP | LU0002 | 2026-04-03T12:12:03.758Z | 2026-04-07T12:21:53.198Z |
| 9604828 | 9604828 | 20260402010820_bpVlL | LU0002 | 2026-04-03T12:11:50.051Z | 2026-04-07T12:21:51.211Z |
| 9604817 | 9604817 | 20260402005550_MR6K6 | LU0002 | 2026-04-03T12:11:38.892Z | 2026-04-07T12:21:50.930Z |
| 9604796 | 9604796 | 20260402004220_lq9Fv | LU0002 | 2026-04-03T12:11:33.667Z | 2026-04-07T12:21:50.316Z |
| 9604749 | 9604749 | 20260402002240_DiU4o | LU0002 | 2026-04-03T12:11:26.011Z | 2026-04-07T12:21:49.290Z |
| 9604634 | 9604634 | 20260401224649_2iW72 | LU0002 | 2026-04-03T12:10:56.355Z | 2026-04-07T12:21:45.802Z |
| 9604623 | 9604623 | 20260401222801_V66n3 | LU0002 | 2026-04-03T12:10:54.344Z | 2026-04-07T12:21:45.495Z |
| 9604622 | 9604622 | 20260401222655_QazKb | LU0002 | 2026-04-03T12:10:53.729Z | 2026-04-07T12:21:45.455Z |
| 9604608 | 9604608 | 20260401221247_t37Yx | LU0002 | 2026-04-03T12:10:50.934Z | 2026-04-07T12:21:44.979Z |
| 9604567 | 9604567 | 20260401210512_EiVQh | LU0002 | 2026-04-03T12:10:29.074Z | 2026-04-07T12:21:42.699Z |
| 9604523 | 9604523 | 20260401192126_atObM | LU0002 | 2026-04-03T12:09:59.502Z | 2026-04-07T12:21:27.252Z |
| 9602797 | 9602797 | 20260402031942_Wgpk2 | LU0002 | 2026-04-03T12:00:35.924Z | 2026-04-07T12:18:44.535Z |
| 9602776 | 9602776 | 20260402031518_WYerZ | LU0002 | 2026-04-03T12:00:33.715Z | 2026-04-07T12:18:44.093Z |
| 9600710 | 9600710 | 20260331012304_kTj8X | LU0002 | 2026-04-01T12:11:36.753Z | 2026-04-07T12:26:23.723Z |
| 9600586 | 9600586 | 20260330234442_IJsGp | LU0002 | 2026-04-01T12:11:15.501Z | 2026-04-07T12:26:08.648Z |
| 9600564 | 9600564 | 20260330233552_bhv0F | LU0002 | 2026-04-01T12:11:11.646Z | 2026-04-07T12:26:08.012Z |
| 9600481 | 9600481 | 20260330223855_n9Rxg | LU0002 | 2026-04-01T12:10:53.229Z | 2026-04-07T12:26:05.672Z |
| 9600477 | 9600477 | 20260330223855_OJbhg | LU0002 | 2026-04-01T12:10:52.827Z | 2026-04-07T12:26:05.570Z |
| 9600403 | 9600403 | 20260330211736_Jrrzm | LU0002 | 2026-04-01T12:10:37.889Z | 2026-04-07T12:26:02.854Z |
| 9598725 | 9598725 | 20260331034153_DjBO3 | LU0002 | 2026-04-01T12:00:45.122Z | 2026-04-07T12:22:03.453Z |
| 9598616 | 9598616 | 20260331015101_VPI3D | LU0002 | 2026-04-01T12:00:11.944Z | 2026-04-07T12:21:59.113Z |
| 9588551 | 9588551 | 20260326234819_Wn7H5 | LU0002 | 2026-03-28T12:11:21.947Z | 2026-04-04T12:42:18.943Z |
| 9588518 | 9588518 | 20260326233457_QmycH | LU0002 | 2026-03-28T12:11:18.443Z | 2026-04-04T12:42:17.424Z |
| 9588367 | 9588367 | 20260326221036_rBjV0 | LU0002 | 2026-03-28T12:10:56.897Z | 2026-04-04T12:42:01.264Z |
| 9588348 | 9588348 | 20260326215651_xXpii | LU0002 | 2026-03-28T12:10:55.560Z | 2026-04-04T12:42:00.280Z |
| 9588254 | 9588254 | 20260326195155_BSXhb | LU0002 | 2026-03-28T12:10:37.484Z | 2026-04-04T12:41:51.337Z |
| 9585513 | 9585513 | 20260327012438_lPNxl | LU0002 | 2026-03-28T12:00:32.965Z | 2026-04-05T12:32:24.777Z |
| 9580214 | 9580214 | 20260322222724_YHyVr | LU0002 | 2026-03-26T12:24:45.922Z | 2026-03-30T12:30:47.426Z |
| 9580212 | 9580212 | 20260322211101_yHZ7P | LU0002 | 2026-03-26T12:24:37.935Z | 2026-03-30T12:30:42.019Z |
| 9580162 | 9580162 | 20260323003516_Kpj5j | LU0002 | 2026-03-26T12:15:37.029Z | 2026-03-31T12:25:52.009Z |
| 9580160 | 9580160 | 20260323002912_293ib | LU0002 | 2026-03-26T12:15:35.705Z | 2026-03-31T12:25:51.274Z |
| 9580158 | 9580158 | 20260323002037_F2U4O | LU0002 | 2026-03-26T12:15:32.566Z | 2026-03-31T12:25:49.868Z |
| 9580146 | 9580146 | 20260325001229_srq2G | LU0002 | 2026-03-26T12:15:10.196Z | 2026-04-02T12:37:43.793Z |
| 9580144 | 9580144 | 20260325001142_rqXDE | LU0002 | 2026-03-26T12:15:09.899Z | 2026-04-02T12:37:43.645Z |
| 9579658 | 9579658 | 20260324220356_YL42X | LU0002 | 2026-03-26T12:14:09.024Z | 2026-04-02T12:37:19.408Z |
| 9579617 | 9579617 | 20260324215830_BzACQ | LU0002 | 2026-03-26T12:14:05.157Z | 2026-04-02T12:37:18.002Z |
| 9576445 | 9576445 | 20260325020820_SC0hM | LU0002 | 2026-03-26T12:02:16.314Z | 2026-04-03T12:35:59.134Z |
| 9576103 | 9576103 | 20260325011417_Z03VE | LU0002 | 2026-03-26T12:01:16.411Z | 2026-04-03T12:35:44.136Z |
| 9576070 | 9576070 | 20260325010944_5pREt | LU0002 | 2026-03-26T12:01:12.018Z | 2026-04-03T12:35:43.313Z |
| 9575916 | 9575916 | 20260325003929_ekn5R | LU0002 | 2026-03-26T12:00:38.967Z | 2026-04-03T12:35:29.051Z |
| 9575439 | 9575439 | 20260323220742_2oopQ | LU0002 | 2026-03-25T12:21:05.471Z | 2026-03-31T12:28:57.603Z |
| 9571595 | 9571595 | 20260324030449_cJKT8 | LU0002 | 2026-03-25T12:02:02.047Z | 2026-04-02T12:34:33.575Z |
| 9571522 | 9571522 | 20260324024500_02FU3 | LU0002 | 2026-03-25T12:01:48.061Z | 2026-04-02T12:34:30.487Z |
| 9571320 | 9571320 | 20260324011110_SCNfC | LU0002 | 2026-03-25T12:01:00.026Z | 2026-04-02T12:34:19.802Z |
| 9571307 | 9571307 | 20260324010345_n2dOl | LU0002 | 2026-03-25T12:00:55.962Z | 2026-04-02T12:34:19.145Z |
| 9571228 | 9571228 | 20260324004306_ccuOw | LU0002 | 2026-03-25T12:00:32.304Z | 2026-04-02T12:34:14.338Z |
| 9571197 | 9571197 | 20260324002605_GdJR2 | LU0002 | 2026-03-25T12:00:24.392Z | 2026-04-02T12:34:12.382Z |
| 9561495 | 9561495 | 20260320231055_mjbWg | LU0002 | 2026-03-23T12:15:30.305Z | 2026-03-28T12:37:07.670Z |
| 9561493 | 9561493 | 20260320224622_0fkhz | LU0002 | 2026-03-23T12:15:29.184Z | 2026-03-28T12:37:06.230Z |
| 9561491 | 9561491 | 20260320222318_X13Wb | LU0002 | 2026-03-23T12:15:26.138Z | 2026-03-28T12:37:04.822Z |
| 9561290 | 9561290 | 20260321231843_OSetg | LU0002 | 2026-03-23T12:12:15.512Z | 2026-03-29T12:21:06.186Z |
| 9560491 | 9560491 | 20260321213227_dkuXo | LU0002 | 2026-03-23T12:11:49.008Z | 2026-03-29T12:21:00.707Z |
| 9558726 | 9558726 | 20260321023403_rBiq5 | LU0002 | 2026-03-23T12:07:18.694Z | 2026-03-29T12:19:02.651Z |
| 9558724 | 9558724 | 20260321012402_AwymH | LU0002 | 2026-03-23T12:07:11.984Z | 2026-03-29T12:18:58.570Z |
| 9558722 | 9558722 | 20260321012349_27XMs | LU0002 | 2026-03-23T12:07:11.749Z | 2026-03-29T12:18:58.515Z |
| 9558719 | 9558719 | 20260321002429_u3FbX | LU0002 | 2026-03-23T12:07:06.822Z | 2026-03-29T12:18:46.476Z |
| 9558718 | 9558718 | 20260320235737_mbDd4 | LU0002 | 2026-03-23T12:07:00.803Z | 2026-03-29T12:18:45.092Z |
| 9555105 | 9555105 | 20260322040506_CklZB | LU0002 | 2026-03-23T12:03:10.218Z | 2026-03-30T12:28:14.474Z |
| 9554456 | 9554456 | 20260322031119_zaY3P | LU0002 | 2026-03-23T12:02:33.213Z | 2026-03-30T12:28:04.117Z |
| 9553617 | 9553617 | 20260322020130_JQ8Zv | LU0002 | 2026-03-23T12:01:43.408Z | 2026-03-30T12:27:50.260Z |
| 9552731 | 9552731 | 20260322003652_L13bi | LU0002 | 2026-03-23T12:00:46.621Z | 2026-03-30T12:27:29.096Z |
| 9552661 | 9552661 | 20260322002918_Yp43F | LU0002 | 2026-03-23T12:00:41.308Z | 2026-03-30T12:27:27.795Z |
| 9552543 | 9552543 | 20260322001816_wBKK5 | LU0002 | 2026-03-23T12:00:31.478Z | 2026-03-30T12:27:25.821Z |
| 9552403 | 9552403 | 20260322000030_8OG62 | LU0002 | 2026-03-23T12:00:21.329Z | 2026-03-30T12:27:23.415Z |
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);