participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
8,004 rows where station_code = "RU0003" 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 |
---|---|---|---|---|---|
5132643 | 5132643 | 20240916014931_oMeuy | RU0003 | 2024-09-19T12:16:24.368Z | 2024-09-19T12:16:24.368Z |
5132602 | 5132602 | 20240916014113_4Q2Ss | RU0003 | 2024-09-19T12:16:22.102Z | 2024-09-19T12:16:22.102Z |
5132595 | 5132595 | 20240916013748_T7uzY | RU0003 | 2024-09-19T12:16:21.059Z | 2024-09-19T12:16:21.059Z |
5132562 | 5132562 | 20240916013030_YC1RE | RU0003 | 2024-09-19T12:16:18.986Z | 2024-09-19T12:16:18.986Z |
5132440 | 5132440 | 20240916010851_dKLEE | RU0003 | 2024-09-19T12:16:12.969Z | 2024-09-19T12:16:12.969Z |
5132347 | 5132347 | 20240916004408_56kRX | RU0003 | 2024-09-19T12:16:08.617Z | 2024-09-19T12:16:08.617Z |
5132317 | 5132317 | 20240916003232_hq2G6 | RU0003 | 2024-09-19T12:16:06.809Z | 2024-09-19T12:16:06.809Z |
5132196 | 5132196 | 20240915235930_ncBHR | RU0003 | 2024-09-19T12:15:58.024Z | 2024-09-19T12:15:58.024Z |
5132170 | 5132170 | 20240915235116_EY2BZ | RU0003 | 2024-09-19T12:15:54.444Z | 2024-09-19T12:15:54.444Z |
5132082 | 5132082 | 20240915231305_ZMQ0z | RU0003 | 2024-09-19T12:15:49.070Z | 2024-09-19T12:15:49.070Z |
5132044 | 5132044 | 20240915225422_yxfSS | RU0003 | 2024-09-19T12:15:44.950Z | 2024-09-19T12:15:44.950Z |
5131966 | 5131966 | 20240915222537_S8T2h | RU0003 | 2024-09-19T12:15:37.984Z | 2024-09-19T12:15:37.984Z |
5131896 | 5131896 | 20240915220753_orkeS | RU0003 | 2024-09-19T12:15:32.961Z | 2024-09-19T12:15:32.961Z |
5131828 | 5131828 | 20240915212542_9Q3KA | RU0003 | 2024-09-19T12:15:26.266Z | 2024-09-19T12:15:26.266Z |
5131727 | 5131727 | 20240915205757_mkccg | RU0003 | 2024-09-19T12:15:18.435Z | 2024-09-19T12:15:18.435Z |
5131483 | 5131483 | 20240915200142_xq2cN | RU0003 | 2024-09-19T12:15:05.840Z | 2024-09-19T12:15:05.840Z |
5131118 | 5131118 | 20240915175222_SdzWM | RU0003 | 2024-09-19T12:14:24.987Z | 2024-09-19T12:14:24.987Z |
5114552 | 5114552 | 20240915014811_Q70x2 | RU0003 | 2024-09-18T12:05:21.607Z | 2024-09-19T12:18:58.835Z |
5114431 | 5114431 | 20240915014149_GfleL | RU0003 | 2024-09-18T12:05:16.096Z | 2024-09-19T12:18:58.111Z |
5114426 | 5114426 | 20240915014117_htsJR | RU0003 | 2024-09-18T12:05:15.407Z | 2024-09-19T12:18:58.038Z |
5114359 | 5114359 | 20240915013913_0nc5S | RU0003 | 2024-09-18T12:05:13.229Z | 2024-09-19T12:18:57.783Z |
5114339 | 5114339 | 20240915013728_jKGSk | RU0003 | 2024-09-18T12:05:11.729Z | 2024-09-19T12:18:57.619Z |
5114027 | 5114027 | 20240915012338_JpUnW | RU0003 | 2024-09-18T12:04:59.229Z | 2024-09-19T12:18:55.365Z |
5113692 | 5113692 | 20240915010650_r9glN | RU0003 | 2024-09-18T12:04:41.925Z | 2024-09-19T12:18:51.485Z |
5113644 | 5113644 | 20240915010147_MRm4A | RU0003 | 2024-09-18T12:04:36.000Z | 2024-09-19T12:18:50.732Z |
5113607 | 5113607 | 20240915010044_pbTNJ | RU0003 | 2024-09-18T12:04:34.834Z | 2024-09-19T12:18:50.569Z |
5113583 | 5113583 | 20240915005954_oZwkr | RU0003 | 2024-09-18T12:04:33.737Z | 2024-09-19T12:18:50.509Z |
5113407 | 5113407 | 20240915004750_ReaUL | RU0003 | 2024-09-18T12:04:15.756Z | 2024-09-19T12:18:48.983Z |
5113319 | 5113319 | 20240915003813_yW38y | RU0003 | 2024-09-18T12:04:08.370Z | 2024-09-19T12:18:48.484Z |
5113025 | 5113025 | 20240915001542_n00pB | RU0003 | 2024-09-18T12:03:51.579Z | 2024-09-19T12:18:46.495Z |
5112740 | 5112740 | 20240914234726_RS7XJ | RU0003 | 2024-09-18T12:03:26.396Z | 2024-09-19T12:18:44.094Z |
5112695 | 5112695 | 20240914234223_IbN3H | RU0003 | 2024-09-18T12:03:22.715Z | 2024-09-19T12:18:43.511Z |
5112693 | 5112693 | 20240914234223_Z34w6 | RU0003 | 2024-09-18T12:03:22.536Z | 2024-09-19T12:18:43.495Z |
5112250 | 5112250 | 20240914224724_X33Hd | RU0003 | 2024-09-18T12:02:56.712Z | 2024-09-19T12:18:40.155Z |
5112236 | 5112236 | 20240914223918_siluD | RU0003 | 2024-09-18T12:02:54.863Z | 2024-09-19T12:18:39.894Z |
5112166 | 5112166 | 20240914222736_DbFqS | RU0003 | 2024-09-18T12:02:50.956Z | 2024-09-19T12:18:38.814Z |
5111998 | 5111998 | 20240914215236_ky2hw | RU0003 | 2024-09-18T12:02:36.879Z | 2024-09-19T12:18:36.322Z |
5111723 | 5111723 | 20240914210701_2rbNB | RU0003 | 2024-09-18T12:02:13.464Z | 2024-09-19T12:18:33.677Z |
5111716 | 5111716 | 20240914210523_28C5Z | RU0003 | 2024-09-18T12:02:12.535Z | 2024-09-19T12:18:33.481Z |
5111480 | 5111480 | 20240914204225_Qv9r6 | RU0003 | 2024-09-18T12:01:59.298Z | 2024-09-19T12:18:30.747Z |
5110902 | 5110902 | 20240914192236_aUiTM | RU0003 | 2024-09-18T12:01:10.134Z | 2024-09-19T12:18:24.619Z |
5110490 | 5110490 | 20240914163337_Gpo7M | RU0003 | 2024-09-18T12:00:16.250Z | 2024-09-19T12:18:20.746Z |
5104103 | 5104103 | 20240913015253_O2Xgu | RU0003 | 2024-09-17T12:11:25.566Z | 2024-09-19T12:20:41.032Z |
5103800 | 5103800 | 20240913014029_esCwO | RU0003 | 2024-09-17T12:11:11.312Z | 2024-09-19T12:20:40.578Z |
5103790 | 5103790 | 20240913014001_2XfH8 | RU0003 | 2024-09-17T12:11:10.609Z | 2024-09-19T12:20:40.560Z |
5103353 | 5103353 | 20240913012858_CofcA | RU0003 | 2024-09-17T12:10:54.998Z | 2024-09-19T12:20:40.108Z |
5103330 | 5103330 | 20240913012631_2iaBQ | RU0003 | 2024-09-17T12:10:51.149Z | 2024-09-19T12:20:40.034Z |
5102823 | 5102823 | 20240914014732_jgzfJ | RU0003 | 2024-09-17T12:07:38.846Z | 2024-09-19T12:19:55.842Z |
5102750 | 5102750 | 20240914014130_2sDGo | RU0003 | 2024-09-17T12:07:34.711Z | 2024-09-19T12:19:55.530Z |
5102661 | 5102661 | 20240914013548_9mWVA | RU0003 | 2024-09-17T12:07:29.851Z | 2024-09-19T12:19:55.364Z |
5102561 | 5102561 | 20240914013150_T3eSC | RU0003 | 2024-09-17T12:07:25.163Z | 2024-09-19T12:19:55.130Z |
5102559 | 5102559 | 20240914013138_s72jA | RU0003 | 2024-09-17T12:07:24.738Z | 2024-09-19T12:19:55.117Z |
5102241 | 5102241 | 20240914011249_5ubrQ | RU0003 | 2024-09-17T12:06:55.660Z | 2024-09-19T12:19:53.074Z |
5102132 | 5102132 | 20240914010630_MlEmD | RU0003 | 2024-09-17T12:06:49.643Z | 2024-09-19T12:19:52.510Z |
5102011 | 5102011 | 20240914005955_mBbCD | RU0003 | 2024-09-17T12:06:40.704Z | 2024-09-19T12:19:52.189Z |
5101591 | 5101591 | 20240914003706_9yZ7P | RU0003 | 2024-09-17T12:06:03.819Z | 2024-09-19T12:19:51.068Z |
5101150 | 5101150 | 20240914000719_BBevY | RU0003 | 2024-09-17T12:05:22.609Z | 2024-09-19T12:19:49.873Z |
5101147 | 5101147 | 20240914000652_TbSRZ | RU0003 | 2024-09-17T12:05:22.201Z | 2024-09-19T12:19:49.862Z |
5100965 | 5100965 | 20240913235519_3VpEI | RU0003 | 2024-09-17T12:05:12.247Z | 2024-09-19T12:19:49.409Z |
5100728 | 5100728 | 20240913234408_EvsyV | RU0003 | 2024-09-17T12:04:52.398Z | 2024-09-19T12:19:48.680Z |
5100671 | 5100671 | 20240913234046_USiqF | RU0003 | 2024-09-17T12:04:48.580Z | 2024-09-19T12:19:48.525Z |
5100621 | 5100621 | 20240913233532_opW1P | RU0003 | 2024-09-17T12:04:44.132Z | 2024-09-19T12:19:48.232Z |
5100278 | 5100278 | 20240913231416_W24AN | RU0003 | 2024-09-17T12:04:24.222Z | 2024-09-19T12:19:47.617Z |
5100179 | 5100179 | 20240913230016_yzfBJ | RU0003 | 2024-09-17T12:04:07.199Z | 2024-09-19T12:19:47.136Z |
5100177 | 5100177 | 20240913225902_9LKvs | RU0003 | 2024-09-17T12:04:06.515Z | 2024-09-19T12:19:47.065Z |
5099972 | 5099972 | 20240913222940_cdg1J | RU0003 | 2024-09-17T12:03:47.221Z | 2024-09-19T12:19:46.632Z |
5099300 | 5099300 | 20240913205643_VSHkF | RU0003 | 2024-09-17T12:02:42.706Z | 2024-09-19T12:19:44.441Z |
5099098 | 5099098 | 20240913202323_JLcud | RU0003 | 2024-09-17T12:02:20.649Z | 2024-09-19T12:19:43.418Z |
5098474 | 5098474 | 20240913172926_0C5lV | RU0003 | 2024-09-17T12:00:42.959Z | 2024-09-19T12:19:37.650Z |
5098251 | 5098251 | 20240913012312_uJjqA | RU0003 | 2024-09-16T12:17:21.933Z | 2024-09-19T12:20:39.969Z |
5098213 | 5098213 | 20240913012242_ecR2G | RU0003 | 2024-09-16T12:17:21.765Z | 2024-09-19T12:20:39.903Z |
5097205 | 5097205 | 20240913003614_idA0E | RU0003 | 2024-09-16T12:17:07.747Z | 2024-09-19T12:20:37.849Z |
5097202 | 5097202 | 20240913003553_ADL3i | RU0003 | 2024-09-16T12:17:07.675Z | 2024-09-19T12:20:37.846Z |
5088575 | 5088575 | 20240913001749_XQYbb | RU0003 | 2024-09-16T12:08:13.990Z | 2024-09-19T12:20:37.035Z |
5087605 | 5087605 | 20240912233353_ta5q3 | RU0003 | 2024-09-16T12:07:06.222Z | 2024-09-19T12:20:35.497Z |
5086995 | 5086995 | 20240912230056_igkIp | RU0003 | 2024-09-16T12:06:22.264Z | 2024-09-19T12:20:33.406Z |
5086408 | 5086408 | 20240912223244_Jh3pO | RU0003 | 2024-09-16T12:05:42.977Z | 2024-09-19T12:20:31.156Z |
5086313 | 5086313 | 20240912222810_kRhSw | RU0003 | 2024-09-16T12:05:33.669Z | 2024-09-19T12:20:30.873Z |
5085685 | 5085685 | 20240912214324_zEFyQ | RU0003 | 2024-09-16T12:04:39.821Z | 2024-09-19T12:20:29.445Z |
5085665 | 5085665 | 20240912214128_pQ8Jg | RU0003 | 2024-09-16T12:04:35.231Z | 2024-09-19T12:20:29.350Z |
5085218 | 5085218 | 20240912210028_xM9n4 | RU0003 | 2024-09-16T12:03:44.772Z | 2024-09-19T12:20:28.253Z |
5084998 | 5084998 | 20240912203908_47dAG | RU0003 | 2024-09-16T12:03:24.293Z | 2024-09-19T12:20:27.665Z |
5084641 | 5084641 | 20240912200053_mi2tt | RU0003 | 2024-09-16T12:02:42.618Z | 2024-09-19T12:20:26.720Z |
5077784 | 5077784 | 20240911011743_iHZPH | RU0003 | 2024-09-15T12:15:04.593Z | 2024-09-19T12:21:39.643Z |
5077688 | 5077688 | 20240911011051_X72lQ | RU0003 | 2024-09-15T12:14:59.784Z | 2024-09-19T12:21:39.511Z |
5077644 | 5077644 | 20240911010728_riLux | RU0003 | 2024-09-15T12:14:56.219Z | 2024-09-19T12:21:39.463Z |
5077618 | 5077618 | 20240911010624_Z65EA | RU0003 | 2024-09-15T12:14:54.772Z | 2024-09-19T12:21:39.448Z |
5077582 | 5077582 | 20240911010429_o9ffi | RU0003 | 2024-09-15T12:14:53.183Z | 2024-09-19T12:21:39.390Z |
5077463 | 5077463 | 20240911005613_1Pnl6 | RU0003 | 2024-09-15T12:14:46.678Z | 2024-09-19T12:21:39.009Z |
5077277 | 5077277 | 20240911004032_DMpEY | RU0003 | 2024-09-15T12:14:36.603Z | 2024-09-19T12:21:38.629Z |
5077269 | 5077269 | 20240911004007_kiJp5 | RU0003 | 2024-09-15T12:14:35.985Z | 2024-09-19T12:21:38.611Z |
5077260 | 5077260 | 20240911003905_1i6Hl | RU0003 | 2024-09-15T12:14:35.099Z | 2024-09-19T12:21:38.605Z |
5076958 | 5076958 | 20240911001749_g5kkl | RU0003 | 2024-09-15T12:14:14.957Z | 2024-09-19T12:21:37.909Z |
5076686 | 5076686 | 20240910235951_67THE | RU0003 | 2024-09-15T12:13:55.116Z | 2024-09-19T12:21:37.461Z |
5076475 | 5076475 | 20240910233914_7VZC0 | RU0003 | 2024-09-15T12:13:37.523Z | 2024-09-19T12:21:37.288Z |
5076456 | 5076456 | 20240910233704_SCcKd | RU0003 | 2024-09-15T12:13:35.163Z | 2024-09-19T12:21:37.228Z |
5076366 | 5076366 | 20240910232818_BIWy6 | RU0003 | 2024-09-15T12:13:30.205Z | 2024-09-19T12:21:36.757Z |
5076346 | 5076346 | 20240910232552_0emwy | RU0003 | 2024-09-15T12:13:29.066Z | 2024-09-19T12:21:36.732Z |
5076213 | 5076213 | 20240910231446_twa56 | RU0003 | 2024-09-15T12:13:22.910Z | 2024-09-19T12:21:36.618Z |
5076121 | 5076121 | 20240910230745_CHcl2 | RU0003 | 2024-09-15T12:13:18.464Z | 2024-09-19T12:21:36.459Z |
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);