participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
8,023 rows where station_code = "HR001E" 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 |
---|---|---|---|---|---|
5505321 | 5505321 | 20241108043550_fYLYM | HR001E | 2024-11-09T14:16:09.652Z | 2024-11-09T14:16:28.754Z |
5505314 | 5505314 | 20241108043440_tCmx3 | HR001E | 2024-11-09T14:16:08.529Z | 2024-11-09T14:16:28.752Z |
5505310 | 5505310 | 20241108043427_K7pzV | HR001E | 2024-11-09T14:16:08.302Z | 2024-11-09T14:16:28.751Z |
5505280 | 5505280 | 20241108042509_nP628 | HR001E | 2024-11-09T14:16:03.842Z | 2024-11-09T14:16:28.743Z |
5505060 | 5505060 | 20241108034709_pwD1R | HR001E | 2024-11-09T14:15:40.635Z | 2024-11-09T14:16:28.692Z |
5504856 | 5504856 | 20241108030826_9lEUK | HR001E | 2024-11-09T14:15:16.947Z | 2024-11-09T14:16:28.642Z |
5504783 | 5504783 | 20241108025656_NenEQ | HR001E | 2024-11-09T14:15:11.236Z | 2024-11-09T14:16:28.625Z |
5504753 | 5504753 | 20241108025215_i72LO | HR001E | 2024-11-09T14:15:09.023Z | 2024-11-09T14:16:28.616Z |
5504746 | 5504746 | 20241108025143_cP8l2 | HR001E | 2024-11-09T14:15:08.626Z | 2024-11-09T14:16:28.615Z |
5504717 | 5504717 | 20241108024422_iSboZ | HR001E | 2024-11-09T14:15:05.959Z | 2024-11-09T14:16:28.608Z |
5504561 | 5504561 | 20241108021459_Uq5b0 | HR001E | 2024-11-09T14:14:51.533Z | 2024-11-09T14:16:28.570Z |
5504519 | 5504519 | 20241108021018_k3rsm | HR001E | 2024-11-09T14:14:47.577Z | 2024-11-09T14:16:28.559Z |
5504509 | 5504509 | 20241108020856_VjvIu | HR001E | 2024-11-09T14:14:46.529Z | 2024-11-09T14:16:28.558Z |
5504445 | 5504445 | 20241108015910_oDJZs | HR001E | 2024-11-09T14:14:39.415Z | 2024-11-09T14:16:28.540Z |
5504410 | 5504410 | 20241108015451_bQoFW | HR001E | 2024-11-09T14:14:34.711Z | 2024-11-09T14:16:28.530Z |
5504394 | 5504394 | 20241108015203_2W7Wa | HR001E | 2024-11-09T14:14:31.365Z | 2024-11-09T14:16:28.525Z |
5504322 | 5504322 | 20241108013614_xK02O | HR001E | 2024-11-09T14:14:26.268Z | 2024-11-09T14:16:28.506Z |
5504313 | 5504313 | 20241108013315_KwK3O | HR001E | 2024-11-09T14:14:24.763Z | 2024-11-09T14:16:28.504Z |
5504233 | 5504233 | 20241108011825_L23vX | HR001E | 2024-11-09T14:14:15.653Z | 2024-11-09T14:16:28.483Z |
5504110 | 5504110 | 20241108005610_qaioR | HR001E | 2024-11-09T14:14:05.269Z | 2024-11-09T14:16:28.452Z |
5503943 | 5503943 | 20241108002115_xh5Hf | HR001E | 2024-11-09T14:13:54.219Z | 2024-11-09T14:16:28.406Z |
5503883 | 5503883 | 20241108000544_gs8dw | HR001E | 2024-11-09T14:13:49.470Z | 2024-11-09T14:16:28.380Z |
5503858 | 5503858 | 20241108000205_YK7uX | HR001E | 2024-11-09T14:13:48.346Z | 2024-11-09T14:16:28.369Z |
5503761 | 5503761 | 20241107234513_PJc5a | HR001E | 2024-11-09T14:13:43.251Z | 2024-11-09T14:16:28.341Z |
5503736 | 5503736 | 20241107234145_k2mOx | HR001E | 2024-11-09T14:13:41.672Z | 2024-11-09T14:16:28.335Z |
5503646 | 5503646 | 20241107231335_7D0Hp | HR001E | 2024-11-09T14:13:28.782Z | 2024-11-09T14:16:28.311Z |
5503635 | 5503635 | 20241107230824_HVKXr | HR001E | 2024-11-09T14:13:27.365Z | 2024-11-09T14:16:28.308Z |
5503561 | 5503561 | 20241107225120_O3GC9 | HR001E | 2024-11-09T14:13:18.072Z | 2024-11-09T14:16:28.290Z |
5503477 | 5503477 | 20241107222926_ELyX2 | HR001E | 2024-11-09T14:13:09.369Z | 2024-11-09T14:16:28.271Z |
5503302 | 5503302 | 20241107212934_vqfwP | HR001E | 2024-11-09T14:12:46.311Z | 2024-11-09T14:16:28.212Z |
5502949 | 5502949 | 20241107201617_sjuDc | HR001E | 2024-11-09T14:12:14.527Z | 2024-11-09T14:16:28.135Z |
5502605 | 5502605 | 20241107191600_Yn1rR | HR001E | 2024-11-09T14:11:49.231Z | 2024-11-09T14:16:28.063Z |
5502412 | 5502412 | 20241107182557_eM3kU | HR001E | 2024-11-09T14:11:17.592Z | 2024-11-09T14:16:28.023Z |
5502055 | 5502055 | 20241107170453_xGY3Y | HR001E | 2024-11-09T14:10:52.984Z | 2024-11-09T14:16:27.930Z |
5497691 | 5497691 | 20241107043208_0MHho | HR001E | 2024-11-08T14:14:12.534Z | 2024-11-09T14:18:50.677Z |
5497584 | 5497584 | 20241107040550_lHuff | HR001E | 2024-11-08T14:14:00.395Z | 2024-11-09T14:18:46.561Z |
5497563 | 5497563 | 20241107040133_Mzwuh | HR001E | 2024-11-08T14:13:59.032Z | 2024-11-09T14:18:46.308Z |
5497556 | 5497556 | 20241107040049_EqP89 | HR001E | 2024-11-08T14:13:58.597Z | 2024-11-09T14:18:46.264Z |
5497504 | 5497504 | 20241107035152_HLsqj | HR001E | 2024-11-08T14:13:54.809Z | 2024-11-09T14:18:44.869Z |
5497483 | 5497483 | 20241107034930_buzT8 | HR001E | 2024-11-08T14:13:51.974Z | 2024-11-09T14:18:44.445Z |
5497477 | 5497477 | 20241107034810_vl5CE | HR001E | 2024-11-08T14:13:51.267Z | 2024-11-09T14:18:44.357Z |
5497237 | 5497237 | 20241107030224_x82Hv | HR001E | 2024-11-08T14:13:25.687Z | 2024-11-09T14:18:37.919Z |
5497182 | 5497182 | 20241107025359_ivtO0 | HR001E | 2024-11-08T14:13:19.225Z | 2024-11-09T14:18:36.668Z |
5497065 | 5497065 | 20241107023722_W7rOU | HR001E | 2024-11-08T14:13:08.118Z | 2024-11-09T14:18:35.029Z |
5497034 | 5497034 | 20241107023156_5OaXP | HR001E | 2024-11-08T14:13:06.774Z | 2024-11-09T14:18:34.596Z |
5497030 | 5497030 | 20241107023039_ELAbJ | HR001E | 2024-11-08T14:13:06.457Z | 2024-11-09T14:18:34.507Z |
5496733 | 5496733 | 20241107012816_gaswC | HR001E | 2024-11-08T14:12:48.621Z | 2024-11-09T14:18:29.181Z |
5496723 | 5496723 | 20241107012522_8okJu | HR001E | 2024-11-08T14:12:48.036Z | 2024-11-09T14:18:29.100Z |
5496610 | 5496610 | 20241107010257_SzFhW | HR001E | 2024-11-08T14:12:31.392Z | 2024-11-09T14:18:26.569Z |
5496596 | 5496596 | 20241107005951_8ku5P | HR001E | 2024-11-08T14:12:30.464Z | 2024-11-09T14:18:26.294Z |
5496506 | 5496506 | 20241107003941_lZQ2N | HR001E | 2024-11-08T14:12:17.338Z | 2024-11-09T14:18:23.638Z |
5496471 | 5496471 | 20241107003240_w3aJd | HR001E | 2024-11-08T14:12:12.487Z | 2024-11-09T14:18:22.904Z |
5496355 | 5496355 | 20241107000256_lsjYr | HR001E | 2024-11-08T14:12:01.827Z | 2024-11-09T14:18:20.912Z |
5496282 | 5496282 | 20241106234655_7FQy4 | HR001E | 2024-11-08T14:11:53.743Z | 2024-11-09T14:18:19.532Z |
5496248 | 5496248 | 20241106233859_16WpZ | HR001E | 2024-11-08T14:11:51.364Z | 2024-11-09T14:18:19.171Z |
5496188 | 5496188 | 20241106232011_kLXzp | HR001E | 2024-11-08T14:11:44.656Z | 2024-11-09T14:18:17.859Z |
5496135 | 5496135 | 20241106230457_Xf44b | HR001E | 2024-11-08T14:11:38.067Z | 2024-11-09T14:18:16.811Z |
5496091 | 5496091 | 20241106225426_BC2OV | HR001E | 2024-11-08T14:11:33.110Z | 2024-11-09T14:18:16.096Z |
5496067 | 5496067 | 20241106225109_Cm2XT | HR001E | 2024-11-08T14:11:29.621Z | 2024-11-09T14:18:15.592Z |
5495957 | 5495957 | 20241106222140_c8LZv | HR001E | 2024-11-08T14:11:13.302Z | 2024-11-09T14:18:12.861Z |
5495937 | 5495937 | 20241106221518_nVndO | HR001E | 2024-11-08T14:11:09.875Z | 2024-11-09T14:18:12.322Z |
5495873 | 5495873 | 20241106215401_PhMc0 | HR001E | 2024-11-08T14:11:03.308Z | 2024-11-09T14:18:10.684Z |
5495867 | 5495867 | 20241106215316_jdiQw | HR001E | 2024-11-08T14:11:02.774Z | 2024-11-09T14:18:10.495Z |
5495824 | 5495824 | 20241106214143_U94CE | HR001E | 2024-11-08T14:10:56.816Z | 2024-11-09T14:18:09.867Z |
5495784 | 5495784 | 20241106213410_qHZms | HR001E | 2024-11-08T14:10:52.081Z | 2024-11-09T14:18:08.901Z |
5495648 | 5495648 | 20241106204948_LnHdP | HR001E | 2024-11-08T14:10:32.937Z | 2024-11-09T14:18:02.763Z |
5495512 | 5495512 | 20241106200614_uqZE3 | HR001E | 2024-11-08T14:10:19.827Z | 2024-11-09T14:17:56.396Z |
5495471 | 5495471 | 20241106195746_NkQEE | HR001E | 2024-11-08T14:10:16.598Z | 2024-11-09T14:17:54.684Z |
5495394 | 5495394 | 20241106194154_McX9t | HR001E | 2024-11-08T14:10:11.200Z | 2024-11-09T14:17:52.722Z |
5495380 | 5495380 | 20241106194021_Fn5LW | HR001E | 2024-11-08T14:10:10.216Z | 2024-11-09T14:17:52.425Z |
5495330 | 5495330 | 20241106193038_KHzsN | HR001E | 2024-11-08T14:10:01.301Z | 2024-11-09T14:17:51.369Z |
5495239 | 5495239 | 20241106190411_3Zvnz | HR001E | 2024-11-08T14:09:43.660Z | 2024-11-09T14:17:46.709Z |
5495199 | 5495199 | 20241106185700_WEwjg | HR001E | 2024-11-08T14:09:37.472Z | 2024-11-09T14:17:45.200Z |
5494832 | 5494832 | 20241106173112_CCP39 | HR001E | 2024-11-08T14:08:40.531Z | 2024-11-09T14:17:31.871Z |
5494728 | 5494728 | 20241106170624_YyMBg | HR001E | 2024-11-08T14:08:29.894Z | 2024-11-09T14:17:26.829Z |
5492068 | 5492068 | 20241031181847_bO9AG | HR001E | 2024-11-07T14:25:04.602Z | 2024-11-09T14:24:14.813Z |
5492063 | 5492063 | 20241102014041_DtLz4 | HR001E | 2024-11-07T14:24:13.708Z | 2024-11-09T14:23:36.427Z |
5492061 | 5492061 | 20241102010857_imd3S | HR001E | 2024-11-07T14:24:12.361Z | 2024-11-09T14:23:35.268Z |
5492059 | 5492059 | 20241101223520_uirvQ | HR001E | 2024-11-07T14:24:10.610Z | 2024-11-09T14:23:32.119Z |
5492043 | 5492043 | 20241102232006_VXcSW | HR001E | 2024-11-07T14:23:46.893Z | 2024-11-09T14:22:56.651Z |
5492035 | 5492035 | 20241104040918_CjcIF | HR001E | 2024-11-07T14:22:41.442Z | 2024-11-09T14:22:27.936Z |
5492032 | 5492032 | 20241104030024_ba9rM | HR001E | 2024-11-07T14:22:33.021Z | 2024-11-09T14:22:23.114Z |
5492030 | 5492030 | 20241104020233_3dcEJ | HR001E | 2024-11-07T14:22:26.509Z | 2024-11-09T14:22:18.343Z |
5492024 | 5492024 | 20241104002011_13r4S | HR001E | 2024-11-07T14:22:13.776Z | 2024-11-09T14:22:12.302Z |
5492013 | 5492013 | 20241105032501_enF3B | HR001E | 2024-11-07T14:20:15.375Z | 2024-11-09T14:21:16.221Z |
5492011 | 5492011 | 20241105015336_jpWTz | HR001E | 2024-11-07T14:19:56.030Z | 2024-11-09T14:21:10.020Z |
5492006 | 5492006 | 20241105001205_pfZLg | HR001E | 2024-11-07T14:19:34.709Z | 2024-11-09T14:21:04.061Z |
5491685 | 5491685 | 20241106042809_JmX3v | HR001E | 2024-11-07T14:16:45.557Z | 2024-11-09T14:20:12.877Z |
5491550 | 5491550 | 20241106034533_SCE48 | HR001E | 2024-11-07T14:16:22.671Z | 2024-11-09T14:20:10.722Z |
5491475 | 5491475 | 20241106032339_0FuSn | HR001E | 2024-11-07T14:16:12.268Z | 2024-11-09T14:20:09.275Z |
5491436 | 5491436 | 20241106031642_OJV37 | HR001E | 2024-11-07T14:16:07.605Z | 2024-11-09T14:20:07.668Z |
5491407 | 5491407 | 20241106031235_ceNAJ | HR001E | 2024-11-07T14:16:03.556Z | 2024-11-09T14:20:07.398Z |
5491373 | 5491373 | 20241106030849_58nuN | HR001E | 2024-11-07T14:16:00.046Z | 2024-11-09T14:20:07.230Z |
5491037 | 5491037 | 20241106014050_SncXm | HR001E | 2024-11-07T14:15:14.389Z | 2024-11-09T14:20:03.266Z |
5491033 | 5491033 | 20241106014047_27Fe3 | HR001E | 2024-11-07T14:15:14.341Z | 2024-11-09T14:20:03.265Z |
5490960 | 5490960 | 20241106012328_1q2xd | HR001E | 2024-11-07T14:15:08.395Z | 2024-11-09T14:20:02.422Z |
5490883 | 5490883 | 20241106010452_DwM8p | HR001E | 2024-11-07T14:15:02.556Z | 2024-11-09T14:20:00.974Z |
5490842 | 5490842 | 20241106005112_8cqmu | HR001E | 2024-11-07T14:14:58.742Z | 2024-11-09T14:20:00.135Z |
5490603 | 5490603 | 20241105233657_ztSIz | HR001E | 2024-11-07T14:14:17.219Z | 2024-11-09T14:19:57.237Z |
5490561 | 5490561 | 20241105232822_xyV3T | HR001E | 2024-11-07T14:14:13.111Z | 2024-11-09T14:19:56.973Z |
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);