participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
336 rows where station_code = "RU000N" 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 |
---|---|---|---|---|---|
5135654 | 5135654 | 20240914012621_h277N | RU000N | 2024-09-19T12:19:54.464Z | 2024-09-20T12:18:53.529Z |
5128536 | 5128536 | 20240917015856_u28fT | RU000N | 2024-09-19T12:10:41.887Z | 2024-09-20T12:10:55.046Z |
5114537 | 5114537 | 20240915014708_8eQlh | RU000N | 2024-09-18T12:05:21.148Z | 2024-09-20T12:16:16.584Z |
5114342 | 5114342 | 20240915013728_jKGSk | RU000N | 2024-09-18T12:05:11.729Z | 2024-09-20T12:16:12.605Z |
5114029 | 5114029 | 20240915012338_JpUnW | RU000N | 2024-09-18T12:04:59.229Z | 2024-09-20T12:16:08.025Z |
5113868 | 5113868 | 20240915011605_4bEZF | RU000N | 2024-09-18T12:04:53.697Z | 2024-09-20T12:16:04.693Z |
5113721 | 5113721 | 20240915010916_JK5VU | RU000N | 2024-09-18T12:04:46.623Z | 2024-09-20T12:16:02.607Z |
5113699 | 5113699 | 20240915010707_kspo9 | RU000N | 2024-09-18T12:04:44.210Z | 2024-09-20T12:16:02.132Z |
5113648 | 5113648 | 20240915010210_fKgbw | RU000N | 2024-09-18T12:04:36.356Z | 2024-09-20T12:16:00.648Z |
5113396 | 5113396 | 20240915004623_nc62D | RU000N | 2024-09-18T12:04:14.106Z | 2024-09-20T12:15:55.642Z |
5113378 | 5113378 | 20240915004232_nH6lE | RU000N | 2024-09-18T12:04:11.295Z | 2024-09-20T12:15:54.872Z |
5113158 | 5113158 | 20240915002744_EuaGg | RU000N | 2024-09-18T12:03:59.762Z | 2024-09-20T12:15:49.147Z |
5113154 | 5113154 | 20240915002700_bshmF | RU000N | 2024-09-18T12:03:59.322Z | 2024-09-20T12:15:48.513Z |
5113006 | 5113006 | 20240915001428_tny6h | RU000N | 2024-09-18T12:03:50.771Z | 2024-09-20T12:15:42.751Z |
5112824 | 5112824 | 20240914235831_moHlM | RU000N | 2024-09-18T12:03:41.401Z | 2024-09-20T12:15:39.236Z |
5112741 | 5112741 | 20240914234726_RS7XJ | RU000N | 2024-09-18T12:03:26.396Z | 2024-09-20T12:15:36.952Z |
5103919 | 5103919 | 20240913014404_781nW | RU000N | 2024-09-17T12:11:17.144Z | 2024-09-20T12:20:32.479Z |
5103415 | 5103415 | 20240913013003_TFZL7 | RU000N | 2024-09-17T12:10:56.627Z | 2024-09-20T12:20:31.065Z |
5102993 | 5102993 | 20240914015624_n8Ech | RU000N | 2024-09-17T12:07:46.561Z | 2024-09-20T12:18:55.619Z |
5102557 | 5102557 | 20240914013118_EedY2 | RU000N | 2024-09-17T12:07:23.952Z | 2024-09-20T12:18:53.927Z |
5102460 | 5102460 | 20240914012717_eTfm0 | RU000N | 2024-09-17T12:07:14.243Z | 2024-09-20T12:18:53.562Z |
5102450 | 5102450 | 20240914012621_gFtem | RU000N | 2024-09-17T12:07:12.412Z | 2024-09-18T12:12:27.224Z |
5102335 | 5102335 | 20240914012021_KErGp | RU000N | 2024-09-17T12:07:02.354Z | 2024-09-20T12:18:52.992Z |
5102163 | 5102163 | 20240914010834_J3j0M | RU000N | 2024-09-17T12:06:51.841Z | 2024-09-20T12:18:52.162Z |
5102154 | 5102154 | 20240914010726_P2xQs | RU000N | 2024-09-17T12:06:50.714Z | 2024-09-20T12:18:52.070Z |
5102133 | 5102133 | 20240914010630_MlEmD | RU000N | 2024-09-17T12:06:49.643Z | 2024-09-20T12:18:51.958Z |
5101995 | 5101995 | 20240914005836_wFRlW | RU000N | 2024-09-17T12:06:37.811Z | 2024-09-20T12:18:51.154Z |
5101510 | 5101510 | 20240914003206_1a89N | RU000N | 2024-09-17T12:05:58.200Z | 2024-09-20T12:18:48.138Z |
5101506 | 5101506 | 20240914003119_67R22 | RU000N | 2024-09-17T12:05:57.693Z | 2024-09-20T12:18:47.535Z |
5101498 | 5101498 | 20240914003035_wmzLs | RU000N | 2024-09-17T12:05:56.587Z | 2024-09-20T12:18:47.354Z |
5101479 | 5101479 | 20240914002923_pDupy | RU000N | 2024-09-17T12:05:55.130Z | 2024-09-20T12:18:47.127Z |
5101333 | 5101333 | 20240914001942_1eUz5 | RU000N | 2024-09-17T12:05:35.618Z | 2024-09-20T12:18:43.944Z |
5101268 | 5101268 | 20240914001723_meblk | RU000N | 2024-09-17T12:05:30.790Z | 2024-09-20T12:18:43.233Z |
5101090 | 5101090 | 20240914000218_1yPpj | RU000N | 2024-09-17T12:05:19.180Z | 2024-09-20T12:18:39.986Z |
5101065 | 5101065 | 20240913235929_WhTok | RU000N | 2024-09-17T12:05:17.337Z | 2024-09-20T12:18:39.764Z |
5100724 | 5100724 | 20240913234400_guqtx | RU000N | 2024-09-17T12:04:50.570Z | 2024-09-20T12:18:35.086Z |
5100368 | 5100368 | 20240913232354_mFN9F | RU000N | 2024-09-17T12:04:31.088Z | 2024-09-20T12:18:32.261Z |
5100334 | 5100334 | 20240913232040_ZTxdt | RU000N | 2024-09-17T12:04:28.692Z | 2024-09-20T12:18:31.848Z |
5097861 | 5097861 | 20240913010659_uy5gy | RU000N | 2024-09-16T12:17:16.125Z | 2024-09-20T12:20:28.497Z |
5097305 | 5097305 | 20240913003909_UNB0a | RU000N | 2024-09-16T12:17:09.562Z | 2024-09-20T12:20:25.163Z |
5097212 | 5097212 | 20240913003644_QF2Tg | RU000N | 2024-09-16T12:17:08.105Z | 2024-09-20T12:20:24.641Z |
5088909 | 5088909 | 20240913003317_uDPyo | RU000N | 2024-09-16T12:08:36.181Z | 2024-09-20T12:20:23.739Z |
5088805 | 5088805 | 20240913002755_GOwEM | RU000N | 2024-09-16T12:08:31.391Z | 2024-09-20T12:20:23.285Z |
5087845 | 5087845 | 20240912234642_Fwzj6 | RU000N | 2024-09-16T12:07:34.327Z | 2024-09-20T12:20:18.902Z |
5087607 | 5087607 | 20240912233353_ta5q3 | RU000N | 2024-09-16T12:07:06.222Z | 2024-09-20T12:20:16.974Z |
5087072 | 5087072 | 20240912230712_EnzqU | RU000N | 2024-09-16T12:06:32.731Z | 2024-09-20T12:20:14.326Z |
5086385 | 5086385 | 20240912223136_fwgdu | RU000N | 2024-09-16T12:05:38.138Z | 2024-09-20T12:20:10.950Z |
5086315 | 5086315 | 20240912222810_kRhSw | RU000N | 2024-09-16T12:05:33.669Z | 2024-09-20T12:20:10.784Z |
5085503 | 5085503 | 20240912212419_fA293 | RU000N | 2024-09-16T12:04:20.188Z | 2024-09-20T12:20:04.945Z |
5085363 | 5085363 | 20240912211414_Vgo3u | RU000N | 2024-09-16T12:04:09.234Z | 2024-09-20T12:20:03.747Z |
5085220 | 5085220 | 20240912210028_xM9n4 | RU000N | 2024-09-16T12:03:44.772Z | 2024-09-20T12:20:02.752Z |
5084939 | 5084939 | 20240912203514_1RRfu | RU000N | 2024-09-16T12:03:17.049Z | 2024-09-20T12:20:00.234Z |
5084933 | 5084933 | 20240912203312_MXbtv | RU000N | 2024-09-16T12:03:15.041Z | 2024-09-20T12:20:00.207Z |
5084544 | 5084544 | 20240912194907_uzKDk | RU000N | 2024-09-16T12:02:20.435Z | 2024-09-20T12:19:56.042Z |
5084482 | 5084482 | 20240912194247_WpMJV | RU000N | 2024-09-16T12:02:09.437Z | 2024-09-20T12:19:54.618Z |
5084281 | 5084281 | 20240912190602_5UwUk | RU000N | 2024-09-16T12:01:46.388Z | 2024-09-20T12:19:52.237Z |
5077786 | 5077786 | 20240911011743_iHZPH | RU000N | 2024-09-15T12:15:04.593Z | 2024-09-19T12:21:39.643Z |
5077710 | 5077710 | 20240911011235_O2U8R | RU000N | 2024-09-15T12:15:01.507Z | 2024-09-19T12:21:39.568Z |
5077699 | 5077699 | 20240911011210_ud7B0 | RU000N | 2024-09-15T12:15:00.837Z | 2024-09-19T12:21:39.534Z |
5077279 | 5077279 | 20240911004032_DMpEY | RU000N | 2024-09-15T12:14:36.603Z | 2024-09-19T12:21:38.629Z |
5077255 | 5077255 | 20240911003733_hz0ML | RU000N | 2024-09-15T12:14:34.682Z | 2024-09-19T12:21:38.597Z |
5076689 | 5076689 | 20240911000015_aMO9P | RU000N | 2024-09-15T12:13:55.455Z | 2024-09-19T12:21:37.464Z |
5076651 | 5076651 | 20240910235549_xyeCh | RU000N | 2024-09-15T12:13:50.573Z | 2024-09-19T12:21:37.426Z |
5076535 | 5076535 | 20240910234428_QUeB0 | RU000N | 2024-09-15T12:13:42.136Z | 2024-09-19T12:21:37.330Z |
5076334 | 5076334 | 20240910232209_aqmft | RU000N | 2024-09-15T12:13:28.211Z | 2024-09-19T12:21:36.716Z |
5076018 | 5076018 | 20240910230538_dbleW | RU000N | 2024-09-15T12:13:16.006Z | 2024-09-19T12:21:36.382Z |
5073999 | 5073999 | 20240911220528_kS9wV | RU000N | 2024-09-15T12:07:50.386Z | 2024-09-20T12:21:35.027Z |
5071899 | 5071899 | 20240911185410_scjQ3 | RU000N | 2024-09-15T12:03:58.670Z | 2024-09-20T12:21:24.021Z |
5071748 | 5071748 | 20240911181023_6aMbl | RU000N | 2024-09-15T12:03:24.076Z | 2024-09-20T12:21:22.607Z |
5069672 | 5069672 | 20240910215716_xkesw | RU000N | 2024-09-14T12:20:03.649Z | 2024-09-19T12:21:35.236Z |
5069647 | 5069647 | 20240910215640_PhXeq | RU000N | 2024-09-14T12:20:02.251Z | 2024-09-19T12:21:35.215Z |
5069642 | 5069642 | 20240910215552_F0FJE | RU000N | 2024-09-14T12:20:02.115Z | 2024-09-19T12:21:35.186Z |
5069208 | 5069208 | 20240910211914_EVJSb | RU000N | 2024-09-14T12:19:48.817Z | 2024-09-19T12:21:33.856Z |
5063175 | 5063175 | 20240909201113_MyF0t | RU000N | 2024-09-14T12:13:37.437Z | 2024-09-18T12:15:13.216Z |
5063105 | 5063105 | 20240909195344_mCyB8 | RU000N | 2024-09-14T12:13:29.338Z | 2024-09-18T12:15:13.020Z |
5062574 | 5062574 | 20240909174222_lEM2U | RU000N | 2024-09-14T12:12:34.117Z | 2024-09-18T12:15:11.505Z |
5062471 | 5062471 | 20240909172834_V8lSj | RU000N | 2024-09-14T12:12:24.847Z | 2024-09-18T12:15:11.384Z |
5062340 | 5062340 | 20240909171113_H3SzM | RU000N | 2024-09-14T12:12:11.134Z | 2024-09-18T12:15:10.917Z |
5062278 | 5062278 | 20240909170611_0YTxm | RU000N | 2024-09-14T12:12:05.023Z | 2024-09-18T12:15:10.830Z |
5062219 | 5062219 | 20240909165938_4fXPj | RU000N | 2024-09-14T12:11:56.415Z | 2024-09-18T12:15:10.681Z |
5062023 | 5062023 | 20240909163401_MO9cY | RU000N | 2024-09-14T12:11:45.315Z | 2024-09-18T12:15:10.324Z |
5061946 | 5061946 | 20240909162622_6sFnw | RU000N | 2024-09-14T12:11:41.106Z | 2024-09-18T12:15:10.202Z |
5060641 | 5060641 | 20240910204657_4KaX6 | RU000N | 2024-09-14T12:09:15.919Z | 2024-09-19T12:21:33.387Z |
5060610 | 5060610 | 20240910204232_ZXZbu | RU000N | 2024-09-14T12:09:11.842Z | 2024-09-19T12:21:33.122Z |
5060563 | 5060563 | 20240910203818_Q3wcu | RU000N | 2024-09-14T12:09:09.097Z | 2024-09-19T12:21:32.834Z |
5060351 | 5060351 | 20240910202048_C68eP | RU000N | 2024-09-14T12:08:40.309Z | 2024-09-19T12:21:32.191Z |
5059837 | 5059837 | 20240910190327_sSaal | RU000N | 2024-09-14T12:07:24.030Z | 2024-09-19T12:21:31.315Z |
5059796 | 5059796 | 20240910185428_q88y7 | RU000N | 2024-09-14T12:07:14.165Z | 2024-09-19T12:21:31.274Z |
5059667 | 5059667 | 20240910182736_OYjDf | RU000N | 2024-09-14T12:06:42.834Z | 2024-09-19T12:21:31.037Z |
5059593 | 5059593 | 20240910181456_M7yOm | RU000N | 2024-09-14T12:06:33.209Z | 2024-09-19T12:21:30.923Z |
5059582 | 5059582 | 20240910181044_CT2g5 | RU000N | 2024-09-14T12:06:30.691Z | 2024-09-19T12:21:30.909Z |
5059540 | 5059540 | 20240910180337_I4VvE | RU000N | 2024-09-14T12:06:23.675Z | 2024-09-19T12:21:30.861Z |
5059425 | 5059425 | 20240910174031_4yAKX | RU000N | 2024-09-14T12:05:58.645Z | 2024-09-19T12:21:30.736Z |
5059360 | 5059360 | 20240910173440_RSF9N | RU000N | 2024-09-14T12:05:48.551Z | 2024-09-19T12:21:30.701Z |
5053827 | 5053827 | 20240908013711_SUC8b | RU000N | 2024-09-13T12:16:18.567Z | 2024-09-16T12:21:12.832Z |
5052420 | 5052420 | 20240907203730_vAwXN | RU000N | 2024-09-13T12:15:08.383Z | 2024-09-16T12:21:05.484Z |
5052340 | 5052340 | 20240907202318_kdUDr | RU000N | 2024-09-13T12:15:04.882Z | 2024-09-16T12:21:05.183Z |
5052336 | 5052336 | 20240907202154_OPJ8m | RU000N | 2024-09-13T12:15:04.644Z | 2024-09-16T12:21:05.166Z |
5046357 | 5046357 | 20240908225709_kLxAb | RU000N | 2024-09-13T12:06:33.005Z | 2024-09-17T12:18:59.147Z |
5046281 | 5046281 | 20240908222644_pSekj | RU000N | 2024-09-13T12:06:17.994Z | 2024-09-17T12:18:58.991Z |
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);