participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
251 rows where station_code = "RU0018" 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 |
---|---|---|---|---|---|
5136469 | 5136469 | 20240919015005_Y3nmD | RU0018 | 2024-09-20T12:02:14.828Z | 2024-09-20T12:06:54.862Z |
5135626 | 5135626 | 20240915164842_DBV7f | RU0018 | 2024-09-19T12:19:34.150Z | 2024-09-20T12:17:52.602Z |
5128504 | 5128504 | 20240917015303_yv3aL | RU0018 | 2024-09-19T12:10:39.931Z | 2024-09-20T12:10:54.342Z |
5127600 | 5127600 | 20240916223144_fxO8q | RU0018 | 2024-09-19T12:09:25.413Z | 2024-09-20T12:10:23.617Z |
5127520 | 5127520 | 20240916221608_YPYfR | RU0018 | 2024-09-19T12:09:17.240Z | 2024-09-20T12:10:21.225Z |
5114538 | 5114538 | 20240915014708_8eQlh | RU0018 | 2024-09-18T12:05:21.148Z | 2024-09-20T12:16:16.584Z |
5114432 | 5114432 | 20240915014149_GfleL | RU0018 | 2024-09-18T12:05:16.096Z | 2024-09-20T12:16:14.272Z |
5114018 | 5114018 | 20240915012329_VWdX3 | RU0018 | 2024-09-18T12:04:58.856Z | 2024-09-20T12:16:07.777Z |
5114012 | 5114012 | 20240915012227_psTVa | RU0018 | 2024-09-18T12:04:58.166Z | 2024-09-20T12:16:07.537Z |
5113624 | 5113624 | 20240915010103_siPSr | RU0018 | 2024-09-18T12:04:35.412Z | 2024-09-20T12:16:00.206Z |
5113580 | 5113580 | 20240915005915_vKWgi | RU0018 | 2024-09-18T12:04:32.843Z | 2024-09-20T12:15:59.684Z |
5113132 | 5113132 | 20240915002357_GlGZk | RU0018 | 2024-09-18T12:03:57.823Z | 2024-09-20T12:15:47.442Z |
5112739 | 5112739 | 20240914234721_2piM4 | RU0018 | 2024-09-18T12:03:26.140Z | 2024-09-20T12:15:36.867Z |
5102562 | 5102562 | 20240914013150_T3eSC | RU0018 | 2024-09-17T12:07:25.163Z | 2024-09-20T12:18:53.972Z |
5102558 | 5102558 | 20240914013118_EedY2 | RU0018 | 2024-09-17T12:07:23.952Z | 2024-09-20T12:18:53.927Z |
5102505 | 5102505 | 20240914012910_42Ksp | RU0018 | 2024-09-17T12:07:16.930Z | 2024-09-20T12:18:53.719Z |
5102134 | 5102134 | 20240914010630_MlEmD | RU0018 | 2024-09-17T12:06:49.643Z | 2024-09-20T12:18:51.958Z |
5101718 | 5101718 | 20240914004405_WaK7d | RU0018 | 2024-09-17T12:06:09.910Z | 2024-09-20T12:18:49.371Z |
5101593 | 5101593 | 20240914003706_9yZ7P | RU0018 | 2024-09-17T12:06:03.820Z | 2024-09-20T12:18:48.810Z |
5101590 | 5101590 | 20240914003638_x8R6U | RU0018 | 2024-09-17T12:06:03.498Z | 2024-09-20T12:18:48.755Z |
5100365 | 5100365 | 20240913232352_b9ZdP | RU0018 | 2024-09-17T12:04:30.630Z | 2024-09-20T12:18:32.212Z |
5098252 | 5098252 | 20240913012312_uJjqA | RU0018 | 2024-09-16T12:17:21.933Z | 2024-09-20T12:20:30.632Z |
5097401 | 5097401 | 20240913004536_7VGyz | RU0018 | 2024-09-16T12:17:12.242Z | 2024-09-20T12:20:25.883Z |
5088123 | 5088123 | 20240912235857_2BuBI | RU0018 | 2024-09-16T12:07:44.958Z | 2024-09-20T12:20:20.568Z |
5087872 | 5087872 | 20240912234740_4Ug1b | RU0018 | 2024-09-16T12:07:34.921Z | 2024-09-20T12:20:18.985Z |
5087164 | 5087164 | 20240912231212_LphJu | RU0018 | 2024-09-16T12:06:43.602Z | 2024-09-20T12:20:14.684Z |
5086969 | 5086969 | 20240912225946_XPxMR | RU0018 | 2024-09-16T12:06:18.944Z | 2024-09-20T12:20:13.607Z |
5086828 | 5086828 | 20240912225119_GAtpr | RU0018 | 2024-09-16T12:06:08.774Z | 2024-09-20T12:20:12.989Z |
5086520 | 5086520 | 20240912223947_4YnuB | RU0018 | 2024-09-16T12:05:51.000Z | 2024-09-20T12:20:11.764Z |
5085972 | 5085972 | 20240912220132_ZuaPM | RU0018 | 2024-09-16T12:05:07.926Z | 2024-09-20T12:20:08.993Z |
5085687 | 5085687 | 20240912214324_zEFyQ | RU0018 | 2024-09-16T12:04:39.821Z | 2024-09-20T12:20:06.816Z |
5085667 | 5085667 | 20240912214128_pQ8Jg | RU0018 | 2024-09-16T12:04:35.231Z | 2024-09-20T12:20:06.608Z |
5085377 | 5085377 | 20240912211555_BkGLM | RU0018 | 2024-09-16T12:04:11.515Z | 2024-09-20T12:20:04.032Z |
5085091 | 5085091 | 20240912204458_72B6r | RU0018 | 2024-09-16T12:03:30.586Z | 2024-09-20T12:20:01.404Z |
5085000 | 5085000 | 20240912203908_47dAG | RU0018 | 2024-09-16T12:03:24.294Z | 2024-09-20T12:20:00.727Z |
5084774 | 5084774 | 20240912201233_shGRJ | RU0018 | 2024-09-16T12:02:53.440Z | 2024-09-20T12:19:58.881Z |
5084642 | 5084642 | 20240912200053_mi2tt | RU0018 | 2024-09-16T12:02:42.642Z | 2024-09-20T12:19:57.156Z |
5084409 | 5084409 | 20240912193535_1VWoR | RU0018 | 2024-09-16T12:02:02.580Z | 2024-09-20T12:19:54.118Z |
5084319 | 5084319 | 20240912192009_jB2NO | RU0018 | 2024-09-16T12:01:51.989Z | 2024-09-20T12:19:52.735Z |
5078292 | 5078292 | 20240911014851_XF4Ej | RU0018 | 2024-09-15T12:15:32.372Z | 2024-09-19T12:21:40.183Z |
5077888 | 5077888 | 20240911012701_qqbEN | RU0018 | 2024-09-15T12:15:09.894Z | 2024-09-19T12:21:39.765Z |
5077690 | 5077690 | 20240911011051_X72lQ | RU0018 | 2024-09-15T12:14:59.784Z | 2024-09-19T12:21:39.511Z |
5077646 | 5077646 | 20240911010728_riLux | RU0018 | 2024-09-15T12:14:56.219Z | 2024-09-19T12:21:39.463Z |
5077639 | 5077639 | 20240911010703_y9YmN | RU0018 | 2024-09-15T12:14:55.543Z | 2024-09-19T12:21:39.458Z |
5077466 | 5077466 | 20240911005624_C7nfA | RU0018 | 2024-09-15T12:14:46.874Z | 2024-09-19T12:21:39.017Z |
5077251 | 5077251 | 20240911003652_y3ycx | RU0018 | 2024-09-15T12:14:34.327Z | 2024-09-19T12:21:38.578Z |
5077188 | 5077188 | 20240911003120_MhT4m | RU0018 | 2024-09-15T12:14:28.698Z | 2024-09-19T12:21:38.330Z |
5076411 | 5076411 | 20240910233217_O8RLv | RU0018 | 2024-09-15T12:13:33.001Z | 2024-09-19T12:21:37.032Z |
5076347 | 5076347 | 20240910232552_0emwy | RU0018 | 2024-09-15T12:13:29.066Z | 2024-09-19T12:21:36.732Z |
5076234 | 5076234 | 20240910231558_boSbr | RU0018 | 2024-09-15T12:13:24.016Z | 2024-09-19T12:21:36.641Z |
5073981 | 5073981 | 20240911220120_jXYu3 | RU0018 | 2024-09-15T12:07:48.456Z | 2024-09-20T12:21:34.936Z |
5072009 | 5072009 | 20240911192049_5Jvid | RU0018 | 2024-09-15T12:04:19.004Z | 2024-09-20T12:21:24.619Z |
5071865 | 5071865 | 20240911183947_602UQ | RU0018 | 2024-09-15T12:03:52.492Z | 2024-09-20T12:21:23.767Z |
5070343 | 5070343 | 20240910225129_k67Df | RU0018 | 2024-09-14T12:20:19.320Z | 2024-09-19T12:21:36.010Z |
5070276 | 5070276 | 20240910224737_3M5cq | RU0018 | 2024-09-14T12:20:18.085Z | 2024-09-19T12:21:35.962Z |
5070267 | 5070267 | 20240910224658_L1Sfg | RU0018 | 2024-09-14T12:20:17.663Z | 2024-09-19T12:21:35.958Z |
5070165 | 5070165 | 20240910223624_FHHSA | RU0018 | 2024-09-14T12:20:15.582Z | 2024-09-19T12:21:35.824Z |
5069916 | 5069916 | 20240910221521_lyQKI | RU0018 | 2024-09-14T12:20:09.415Z | 2024-09-19T12:21:35.448Z |
5069887 | 5069887 | 20240910221322_URSdn | RU0018 | 2024-09-14T12:20:08.526Z | 2024-09-19T12:21:35.388Z |
5069797 | 5069797 | 20240910220610_770i3 | RU0018 | 2024-09-14T12:20:05.898Z | 2024-09-19T12:21:35.329Z |
5069385 | 5069385 | 20240910213701_nkH9G | RU0018 | 2024-09-14T12:19:55.320Z | 2024-09-19T12:21:34.807Z |
5069315 | 5069315 | 20240910213008_ky3vc | RU0018 | 2024-09-14T12:19:53.977Z | 2024-09-19T12:21:34.525Z |
5069249 | 5069249 | 20240910212258_w53wN | RU0018 | 2024-09-14T12:19:50.077Z | 2024-09-19T12:21:34.071Z |
5069209 | 5069209 | 20240910211914_EVJSb | RU0018 | 2024-09-14T12:19:48.817Z | 2024-09-19T12:21:33.856Z |
5063723 | 5063723 | 20240909222210_Pp3BV | RU0018 | 2024-09-14T12:14:16.504Z | 2024-09-18T12:15:14.454Z |
5063719 | 5063719 | 20240909222002_V3UC1 | RU0018 | 2024-09-14T12:14:15.483Z | 2024-09-18T12:15:14.419Z |
5063701 | 5063701 | 20240909221631_p6ZUr | RU0018 | 2024-09-14T12:14:13.089Z | 2024-09-18T12:15:14.368Z |
5063632 | 5063632 | 20240909220250_Fjgiq | RU0018 | 2024-09-14T12:14:10.151Z | 2024-09-18T12:15:14.316Z |
5063495 | 5063495 | 20240909212833_2olOJ | RU0018 | 2024-09-14T12:14:03.599Z | 2024-09-18T12:15:14.080Z |
5063164 | 5063164 | 20240909200757_7lKaj | RU0018 | 2024-09-14T12:13:36.153Z | 2024-09-18T12:15:13.104Z |
5062777 | 5062777 | 20240909182140_LbTVH | RU0018 | 2024-09-14T12:12:50.031Z | 2024-09-18T12:15:12.060Z |
5062615 | 5062615 | 20240909174816_X69TL | RU0018 | 2024-09-14T12:12:37.593Z | 2024-09-18T12:15:11.641Z |
5062505 | 5062505 | 20240909173417_7tJw9 | RU0018 | 2024-09-14T12:12:30.103Z | 2024-09-18T12:15:11.415Z |
5062395 | 5062395 | 20240909172006_FcFU0 | RU0018 | 2024-09-14T12:12:17.408Z | 2024-09-18T12:15:11.287Z |
5062178 | 5062178 | 20240909165422_y6ImU | RU0018 | 2024-09-14T12:11:54.309Z | 2024-09-18T12:15:10.517Z |
5060807 | 5060807 | 20240910210833_bYSeo | RU0018 | 2024-09-14T12:09:35.289Z | 2024-09-19T12:21:33.659Z |
5060684 | 5060684 | 20240910205227_maZrv | RU0018 | 2024-09-14T12:09:21.149Z | 2024-09-19T12:21:33.440Z |
5060529 | 5060529 | 20240910203543_2gtBr | RU0018 | 2024-09-14T12:08:57.963Z | 2024-09-19T12:21:32.509Z |
5060386 | 5060386 | 20240910202648_gZHj7 | RU0018 | 2024-09-14T12:08:43.861Z | 2024-09-19T12:21:32.313Z |
5059920 | 5059920 | 20240910191947_e2JEW | RU0018 | 2024-09-14T12:07:38.353Z | 2024-09-19T12:21:31.422Z |
5059917 | 5059917 | 20240910191921_tcSQu | RU0018 | 2024-09-14T12:07:37.630Z | 2024-09-19T12:21:31.404Z |
5059834 | 5059834 | 20240910190259_V6LSK | RU0018 | 2024-09-14T12:07:23.790Z | 2024-09-19T12:21:31.314Z |
5059749 | 5059749 | 20240910184307_lpngj | RU0018 | 2024-09-14T12:07:01.800Z | 2024-09-19T12:21:31.216Z |
5059594 | 5059594 | 20240910181456_M7yOm | RU0018 | 2024-09-14T12:06:33.209Z | 2024-09-19T12:21:30.923Z |
5059361 | 5059361 | 20240910173440_RSF9N | RU0018 | 2024-09-14T12:05:48.553Z | 2024-09-19T12:21:30.701Z |
5052432 | 5052432 | 20240907203957_zfAHB | RU0018 | 2024-09-13T12:15:08.910Z | 2024-09-16T12:21:05.552Z |
5052350 | 5052350 | 20240907202527_3fOo1 | RU0018 | 2024-09-13T12:15:05.157Z | 2024-09-16T12:21:05.195Z |
5052266 | 5052266 | 20240907200707_Zjgdt | RU0018 | 2024-09-13T12:15:02.215Z | 2024-09-16T12:21:04.831Z |
5052092 | 5052092 | 20240907194001_mBMo0 | RU0018 | 2024-09-13T12:14:56.372Z | 2024-09-16T12:21:03.696Z |
5045673 | 5045673 | 20240908175320_rUfAG | RU0018 | 2024-09-13T12:04:40.317Z | 2024-09-17T12:18:56.989Z |
5038765 | 5038765 | 20240905214328_6sKkd | RU0018 | 2024-09-12T12:15:00.021Z | 2024-09-14T12:22:57.896Z |
5038696 | 5038696 | 20240905212513_e25Xf | RU0018 | 2024-09-12T12:14:54.988Z | 2024-09-14T12:22:57.273Z |
5032661 | 5032661 | 20240907012631_mfwS3 | RU0018 | 2024-09-12T12:07:49.264Z | 2024-09-15T12:21:27.302Z |
5032537 | 5032537 | 20240907011225_6vSlU | RU0018 | 2024-09-12T12:07:32.981Z | 2024-09-15T12:21:26.711Z |
5032407 | 5032407 | 20240907005739_SAz2M | RU0018 | 2024-09-12T12:07:15.358Z | 2024-09-15T12:21:26.381Z |
5032403 | 5032403 | 20240907005728_9XNM2 | RU0018 | 2024-09-12T12:07:14.895Z | 2024-09-15T12:21:26.350Z |
5025751 | 5025751 | 20240905011002_2PNIM | RU0018 | 2024-09-11T12:10:56.481Z | 2024-09-13T12:19:55.457Z |
5025745 | 5025745 | 20240905010846_c3hXY | RU0018 | 2024-09-11T12:10:55.849Z | 2024-09-13T12:19:55.410Z |
5024340 | 5024340 | 20240905214328_qQ40v | RU0018 | 2024-09-11T12:03:23.613Z | 2024-09-11T12:16:32.082Z |
5024266 | 5024266 | 20240905212513_T4lhm | RU0018 | 2024-09-11T12:03:08.971Z | 2024-09-11T12:16:32.040Z |
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);