participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "USL00L" 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 |
---|---|---|---|---|---|
5505552 | 5505552 | 20241108060601_SagGr | USL00L | 2024-11-09T14:16:23.072Z | 2024-11-09T14:16:28.814Z |
5505526 | 5505526 | 20241108055512_UibQk | USL00L | 2024-11-09T14:16:22.004Z | 2024-11-09T14:16:28.807Z |
5505524 | 5505524 | 20241108055206_eQMtB | USL00L | 2024-11-09T14:16:21.689Z | 2024-11-09T14:16:28.806Z |
5505506 | 5505506 | 20241108054717_RaJgw | USL00L | 2024-11-09T14:16:21.070Z | 2024-11-09T14:16:28.802Z |
5505413 | 5505413 | 20241108050918_11ltS | USL00L | 2024-11-09T14:16:16.503Z | 2024-11-09T14:16:28.777Z |
5505401 | 5505401 | 20241108050741_ycIxS | USL00L | 2024-11-09T14:16:16.032Z | 2024-11-09T14:16:28.775Z |
5505399 | 5505399 | 20241108050705_FkY77 | USL00L | 2024-11-09T14:16:16.006Z | 2024-11-09T14:16:28.775Z |
5505367 | 5505367 | 20241108045330_egDgk | USL00L | 2024-11-09T14:16:13.806Z | 2024-11-09T14:16:28.766Z |
5505299 | 5505299 | 20241108042937_6jndO | USL00L | 2024-11-09T14:16:06.531Z | 2024-11-09T14:16:28.748Z |
5505180 | 5505180 | 20241108040415_YgCmt | USL00L | 2024-11-09T14:15:53.438Z | 2024-11-09T14:16:28.720Z |
5504906 | 5504906 | 20241108031647_1qkhf | USL00L | 2024-11-09T14:15:22.043Z | 2024-11-09T14:16:28.654Z |
5499646 | 5499646 | 20241108124954_uCsJb | USL00L | 2024-11-09T14:04:32.235Z | 2024-11-09T14:04:32.235Z |
5499454 | 5499454 | 20241108122110_A3m73 | USL00L | 2024-11-09T14:04:07.957Z | 2024-11-09T14:04:07.957Z |
5499417 | 5499417 | 20241108121704_JgUE9 | USL00L | 2024-11-09T14:04:04.470Z | 2024-11-09T14:04:04.470Z |
5499351 | 5499351 | 20241108120326_ijfV2 | USL00L | 2024-11-09T14:03:49.510Z | 2024-11-09T14:03:49.510Z |
5499127 | 5499127 | 20241108111339_T1YPW | USL00L | 2024-11-09T14:03:17.046Z | 2024-11-09T14:03:17.046Z |
5499110 | 5499110 | 20241108111118_S1JER | USL00L | 2024-11-09T14:03:13.715Z | 2024-11-09T14:03:13.715Z |
5499086 | 5499086 | 20241108110257_LTpyC | USL00L | 2024-11-09T14:03:07.388Z | 2024-11-09T14:03:07.388Z |
5499058 | 5499058 | 20241108105527_NNPDF | USL00L | 2024-11-09T14:03:03.955Z | 2024-11-09T14:03:03.955Z |
5499043 | 5499043 | 20241108105225_T3pwO | USL00L | 2024-11-09T14:03:02.379Z | 2024-11-09T14:03:02.379Z |
5499001 | 5499001 | 20241108104055_vs12G | USL00L | 2024-11-09T14:02:56.976Z | 2024-11-09T14:02:56.976Z |
5498956 | 5498956 | 20241108103337_j5VEy | USL00L | 2024-11-09T14:02:50.930Z | 2024-11-09T14:02:50.930Z |
5498942 | 5498942 | 20241108102944_EA93t | USL00L | 2024-11-09T14:02:49.041Z | 2024-11-09T14:02:49.041Z |
5498925 | 5498925 | 20241108102740_iV3Uh | USL00L | 2024-11-09T14:02:47.510Z | 2024-11-09T14:02:47.510Z |
5498868 | 5498868 | 20241108101632_RLFM4 | USL00L | 2024-11-09T14:02:39.769Z | 2024-11-09T14:02:39.769Z |
5498844 | 5498844 | 20241108101121_7uhcS | USL00L | 2024-11-09T14:02:33.656Z | 2024-11-09T14:02:33.656Z |
5498797 | 5498797 | 20241108100120_dQrF7 | USL00L | 2024-11-09T14:02:25.585Z | 2024-11-09T14:02:25.585Z |
5498777 | 5498777 | 20241108095758_lCzDp | USL00L | 2024-11-09T14:02:23.241Z | 2024-11-09T14:02:23.241Z |
5498705 | 5498705 | 20241108093834_1YIz6 | USL00L | 2024-11-09T14:02:13.908Z | 2024-11-09T14:02:13.908Z |
5498610 | 5498610 | 20241108092113_9g2C7 | USL00L | 2024-11-09T14:01:55.438Z | 2024-11-09T14:01:55.438Z |
5498584 | 5498584 | 20241108091357_YmSLp | USL00L | 2024-11-09T14:01:52.398Z | 2024-11-09T14:01:52.398Z |
5498503 | 5498503 | 20241108084620_pvDcC | USL00L | 2024-11-09T14:01:39.733Z | 2024-11-09T14:01:39.733Z |
5498474 | 5498474 | 20241108083818_idFi1 | USL00L | 2024-11-09T14:01:33.999Z | 2024-11-09T14:01:33.999Z |
5498371 | 5498371 | 20241108082208_rhlxS | USL00L | 2024-11-09T14:01:16.603Z | 2024-11-09T14:01:16.603Z |
5498363 | 5498363 | 20241108081626_gHpQu | USL00L | 2024-11-09T14:01:14.581Z | 2024-11-09T14:01:14.581Z |
5498172 | 5498172 | 20241108072137_rmdjw | USL00L | 2024-11-09T14:00:42.670Z | 2024-11-09T14:00:42.670Z |
5498133 | 5498133 | 20241108070812_i6umo | USL00L | 2024-11-09T14:00:36.414Z | 2024-11-09T14:00:36.414Z |
5498129 | 5498129 | 20241108070541_OKgki | USL00L | 2024-11-09T14:00:35.440Z | 2024-11-09T14:00:35.440Z |
5498075 | 5498075 | 20241108064327_xCyzm | USL00L | 2024-11-09T14:00:24.127Z | 2024-11-09T14:00:24.127Z |
5497896 | 5497896 | 20241107055706_4p1k3 | USL00L | 2024-11-08T14:14:29.408Z | 2024-11-09T14:18:53.406Z |
5497734 | 5497734 | 20241107044743_RRrbZ | USL00L | 2024-11-08T14:14:17.029Z | 2024-11-09T14:18:51.215Z |
5497582 | 5497582 | 20241107040319_4Is7l | USL00L | 2024-11-08T14:14:00.257Z | 2024-11-09T14:18:46.502Z |
5497489 | 5497489 | 20241107034943_qDBqC | USL00L | 2024-11-08T14:13:52.270Z | 2024-11-09T14:18:44.551Z |
5497481 | 5497481 | 20241107034854_O94FQ | USL00L | 2024-11-08T14:13:51.501Z | 2024-11-09T14:18:44.383Z |
5493652 | 5493652 | 20241107125455_SUD2T | USL00L | 2024-11-08T14:04:25.968Z | 2024-11-09T14:16:27.684Z |
5493628 | 5493628 | 20241107124659_dkTpE | USL00L | 2024-11-08T14:04:21.635Z | 2024-11-09T14:16:27.675Z |
5493583 | 5493583 | 20241107124112_mYynx | USL00L | 2024-11-08T14:04:10.728Z | 2024-11-09T14:16:27.664Z |
5493574 | 5493574 | 20241107123805_EE85z | USL00L | 2024-11-08T14:04:08.475Z | 2024-11-09T14:16:27.660Z |
5493540 | 5493540 | 20241107123043_kO4p4 | USL00L | 2024-11-08T14:04:01.420Z | 2024-11-09T14:16:27.650Z |
5493490 | 5493490 | 20241107122143_DYuZ2 | USL00L | 2024-11-08T14:03:52.483Z | 2024-11-09T14:16:27.639Z |
5493394 | 5493394 | 20241107120143_re53t | USL00L | 2024-11-08T14:03:40.605Z | 2024-11-09T14:16:27.610Z |
5493244 | 5493244 | 20241107112450_Ev2Yz | USL00L | 2024-11-08T14:03:18.064Z | 2024-11-09T14:16:27.567Z |
5493240 | 5493240 | 20241107112301_M3TBc | USL00L | 2024-11-08T14:03:15.699Z | 2024-11-09T14:16:27.566Z |
5493145 | 5493145 | 20241107110552_KPQ8x | USL00L | 2024-11-08T14:02:57.815Z | 2024-11-09T14:16:27.545Z |
5493126 | 5493126 | 20241107110038_ELqfi | USL00L | 2024-11-08T14:02:55.474Z | 2024-11-09T14:16:27.539Z |
5493082 | 5493082 | 20241107104952_bMc8o | USL00L | 2024-11-08T14:02:49.359Z | 2024-11-09T14:16:27.527Z |
5493066 | 5493066 | 20241107104736_tzYi3 | USL00L | 2024-11-08T14:02:47.938Z | 2024-11-09T14:16:27.522Z |
5493036 | 5493036 | 20241107103849_ZzrPu | USL00L | 2024-11-08T14:02:44.797Z | 2024-11-09T14:16:27.512Z |
5492841 | 5492841 | 20241107100205_85SBR | USL00L | 2024-11-08T14:02:11.824Z | 2024-11-09T14:16:27.466Z |
5492836 | 5492836 | 20241107100148_E94WX | USL00L | 2024-11-08T14:02:11.159Z | 2024-11-09T14:16:27.464Z |
5492771 | 5492771 | 20241107095357_fcDP7 | USL00L | 2024-11-08T14:02:03.783Z | 2024-11-09T14:16:27.450Z |
5492765 | 5492765 | 20241107095345_m60Xu | USL00L | 2024-11-08T14:02:03.230Z | 2024-11-09T14:16:27.449Z |
5492713 | 5492713 | 20241107093904_5N91c | USL00L | 2024-11-08T14:01:56.607Z | 2024-11-09T14:16:27.434Z |
5492643 | 5492643 | 20241107092310_2AGSx | USL00L | 2024-11-08T14:01:42.658Z | 2024-11-09T14:16:27.418Z |
5492599 | 5492599 | 20241107091327_Rk5oC | USL00L | 2024-11-08T14:01:31.734Z | 2024-11-09T14:16:27.410Z |
5492531 | 5492531 | 20241107085249_ikxLN | USL00L | 2024-11-08T14:01:21.599Z | 2024-11-09T14:16:27.393Z |
5492405 | 5492405 | 20241107082530_kRiGz | USL00L | 2024-11-08T14:01:00.327Z | 2024-11-09T14:16:27.364Z |
5492301 | 5492301 | 20241107080353_rvxlZ | USL00L | 2024-11-08T14:00:43.934Z | 2024-11-09T14:16:27.339Z |
5492261 | 5492261 | 20241107074928_uFVK2 | USL00L | 2024-11-08T14:00:39.647Z | 2024-11-09T14:16:27.330Z |
5492142 | 5492142 | 20241107070542_92iVl | USL00L | 2024-11-08T14:00:18.436Z | 2024-11-09T14:16:27.290Z |
5492110 | 5492110 | 20241107064524_MMZ4j | USL00L | 2024-11-08T14:00:12.472Z | 2024-11-09T14:16:27.277Z |
5492088 | 5492088 | 20241107063131_pIJ9G | USL00L | 2024-11-08T14:00:08.535Z | 2024-11-09T14:16:27.262Z |
5492086 | 5492086 | 20241107063032_Nj4Zy | USL00L | 2024-11-08T14:00:08.116Z | 2024-11-09T14:16:27.247Z |
5491715 | 5491715 | 20241106043955_N3rrT | USL00L | 2024-11-07T14:16:50.463Z | 2024-11-09T14:20:13.434Z |
5486142 | 5486142 | 20241106095139_h0CZE | USL00L | 2024-11-07T14:02:02.946Z | 2024-11-09T14:16:38.591Z |
5485405 | 5485405 | 20241105052715_9YUQR | USL00L | 2024-11-06T14:18:12.620Z | 2024-11-09T14:21:21.397Z |
5485394 | 5485394 | 20241105051743_BOB97 | USL00L | 2024-11-06T14:18:12.044Z | 2024-11-09T14:21:21.329Z |
5484850 | 5484850 | 20241105033437_ztr9C | USL00L | 2024-11-06T14:17:22.766Z | 2024-11-09T14:21:16.947Z |
5484453 | 5484453 | 20241105025256_e9DV2 | USL00L | 2024-11-06T14:16:55.702Z | 2024-11-09T14:21:14.207Z |
5484099 | 5484099 | 20241105020942_13gbH | USL00L | 2024-11-06T14:16:13.946Z | 2024-11-09T14:21:10.667Z |
5480418 | 5480418 | 20241105124828_lVRx3 | USL00L | 2024-11-06T14:05:30.579Z | 2024-11-09T14:19:23.937Z |
5480408 | 5480408 | 20241105124638_Sm89S | USL00L | 2024-11-06T14:05:27.336Z | 2024-11-09T14:19:23.822Z |
5480314 | 5480314 | 20241105122115_l09iE | USL00L | 2024-11-06T14:05:13.395Z | 2024-11-09T14:19:22.513Z |
5480305 | 5480305 | 20241105122026_ruoS2 | USL00L | 2024-11-06T14:05:12.130Z | 2024-11-09T14:19:22.432Z |
5480212 | 5480212 | 20241105120230_9V1QX | USL00L | 2024-11-06T14:04:58.565Z | 2024-11-09T14:19:20.528Z |
5480124 | 5480124 | 20241105114442_bOJaS | USL00L | 2024-11-06T14:04:33.837Z | 2024-11-09T14:19:18.556Z |
5480114 | 5480114 | 20241105114136_ZJISO | USL00L | 2024-11-06T14:04:32.603Z | 2024-11-09T14:19:18.447Z |
5480105 | 5480105 | 20241105113910_tsbPp | USL00L | 2024-11-06T14:04:31.369Z | 2024-11-09T14:19:17.749Z |
5480070 | 5480070 | 20241105112944_KeA0B | USL00L | 2024-11-06T14:04:26.221Z | 2024-11-09T14:19:16.579Z |
5480023 | 5480023 | 20241105111818_qu0ET | USL00L | 2024-11-06T14:04:20.029Z | 2024-11-09T14:19:15.173Z |
5479995 | 5479995 | 20241105111424_3zR2R | USL00L | 2024-11-06T14:04:16.902Z | 2024-11-09T14:19:14.861Z |
5479972 | 5479972 | 20241105111118_6UnsH | USL00L | 2024-11-06T14:04:13.091Z | 2024-11-09T14:19:14.630Z |
5479786 | 5479786 | 20241105104052_J3VuA | USL00L | 2024-11-06T14:03:34.929Z | 2024-11-09T14:19:12.285Z |
5479727 | 5479727 | 20241105102714_oyh1X | USL00L | 2024-11-06T14:03:17.928Z | 2024-11-09T14:19:10.837Z |
5479692 | 5479692 | 20241105101910_t34Qe | USL00L | 2024-11-06T14:03:05.780Z | 2024-11-09T14:19:10.532Z |
5479535 | 5479535 | 20241105095234_pxVf5 | USL00L | 2024-11-06T14:02:42.373Z | 2024-11-09T14:19:08.475Z |
5479490 | 5479490 | 20241105094054_NqICX | USL00L | 2024-11-06T14:02:24.586Z | 2024-11-09T14:19:06.860Z |
5479384 | 5479384 | 20241105091540_r5jhk | USL00L | 2024-11-06T14:02:09.814Z | 2024-11-09T14:19:05.360Z |
5479377 | 5479377 | 20241105091345_kT24x | USL00L | 2024-11-06T14:02:08.665Z | 2024-11-09T14:19:05.005Z |
5479292 | 5479292 | 20241105085942_gMOrm | USL00L | 2024-11-06T14:01:46.126Z | 2024-11-09T14:19:03.457Z |
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);