participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
265 rows where station_code = "MY0005" 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 |
---|---|---|---|---|---|
4518864 | 4518864 | 20240628173815_uQFcP | MY0005 | 2024-06-30T12:02:18.464Z | 2024-07-07T12:13:44.404Z |
4479964 | 4479964 | 20240616193606_gHEd2 | MY0005 | 2024-06-19T12:10:01.837Z | 2024-06-24T12:11:50.000Z |
4401783 | 4401783 | 20240531183835_eSR3D | MY0005 | 2024-06-03T12:09:14.739Z | 2024-06-09T12:06:00.103Z |
4349905 | 4349905 | 20240510205547_eSYJV | MY0005 | 2024-05-21T12:03:39.010Z | 2024-05-22T12:11:12.606Z |
4347718 | 4347718 | 20240510200506_G3HZA | MY0005 | 2024-05-20T12:06:29.570Z | 2024-05-22T12:11:09.735Z |
4347716 | 4347716 | 20240510200444_QfGKW | MY0005 | 2024-05-20T12:06:29.389Z | 2024-05-22T12:11:09.620Z |
4347584 | 4347584 | 20240510192154_oqvor | MY0005 | 2024-05-20T12:06:21.097Z | 2024-05-22T12:11:06.201Z |
4344356 | 4344356 | 20240510145352_VIXy0 | MY0005 | 2024-05-20T12:01:46.286Z | 2024-05-22T12:09:40.311Z |
4344115 | 4344115 | 20240510141733_hDYel | MY0005 | 2024-05-20T12:01:23.053Z | 2024-05-22T12:09:30.274Z |
4343620 | 4343620 | 20240510125053_kMq9L | MY0005 | 2024-05-20T12:00:26.258Z | 2024-05-22T12:09:03.225Z |
4306495 | 4306495 | 20240506170636_S05Dc | MY0005 | 2024-05-14T12:05:44.297Z | 2024-05-16T12:12:52.225Z |
3985132 | 3985132 | 20240217180331_nbXxE | MY0005 | 2024-02-19T14:04:50.196Z | 2024-02-26T14:16:22.335Z |
3985055 | 3985055 | 20240217173255_tT29Z | MY0005 | 2024-02-19T14:04:40.142Z | 2024-02-26T14:16:19.963Z |
3980753 | 3980753 | 20240216190649_pyM3r | MY0005 | 2024-02-18T14:04:49.577Z | 2024-02-25T14:18:25.185Z |
3980602 | 3980602 | 20240216182923_67V9Q | MY0005 | 2024-02-18T14:04:24.251Z | 2024-02-25T14:18:22.659Z |
3980533 | 3980533 | 20240216181452_5Q2GT | MY0005 | 2024-02-18T14:04:16.812Z | 2024-02-25T14:18:21.735Z |
3980341 | 3980341 | 20240216171229_yKLxU | MY0005 | 2024-02-18T14:03:44.121Z | 2024-02-25T14:18:15.673Z |
3980097 | 3980097 | 20240216161251_r85Cl | MY0005 | 2024-02-18T14:03:03.888Z | 2024-02-25T14:18:06.377Z |
3970848 | 3970848 | 20240214194222_i6vIo | MY0005 | 2024-02-16T14:04:38.630Z | 2024-02-23T14:20:51.573Z |
3970745 | 3970745 | 20240214183313_W7LRm | MY0005 | 2024-02-16T14:04:18.143Z | 2024-02-23T14:20:50.123Z |
3970690 | 3970690 | 20240214180215_Q22lO | MY0005 | 2024-02-16T14:04:10.998Z | 2024-02-23T14:20:49.446Z |
3970373 | 3970373 | 20240214161410_DDhhu | MY0005 | 2024-02-16T14:03:29.112Z | 2024-02-23T14:20:44.685Z |
3923493 | 3923493 | 20240204124329_39clT | MY0005 | 2024-02-06T14:11:17.574Z | 2024-02-12T14:23:36.933Z |
3800140 | 3800140 | 20240110212601_jGGz7 | MY0005 | 2024-01-13T14:16:08.004Z | 2024-01-19T14:28:03.244Z |
3800101 | 3800101 | 20240110211647_GTEn6 | MY0005 | 2024-01-13T14:16:05.890Z | 2024-01-19T14:28:03.103Z |
3799782 | 3799782 | 20240110202513_aM2c0 | MY0005 | 2024-01-13T14:15:35.718Z | 2024-01-19T14:28:01.343Z |
3799781 | 3799781 | 20240110202406_wBNsx | MY0005 | 2024-01-13T14:15:35.448Z | 2024-01-19T14:28:01.340Z |
3799551 | 3799551 | 20240110192703_TqaLF | MY0005 | 2024-01-13T14:15:16.953Z | 2024-01-19T14:27:57.263Z |
3799500 | 3799500 | 20240110191922_AiMt3 | MY0005 | 2024-01-13T14:15:14.485Z | 2024-01-19T14:27:56.783Z |
3798666 | 3798666 | 20240110162437_2fAKO | MY0005 | 2024-01-13T14:13:41.075Z | 2024-01-19T14:27:44.347Z |
3797706 | 3797706 | 20240110130706_y86ff | MY0005 | 2024-01-13T14:12:06.449Z | 2024-01-19T14:27:35.325Z |
3797511 | 3797511 | 20240110124559_7Pw5y | MY0005 | 2024-01-13T14:11:45.044Z | 2024-01-19T14:27:32.340Z |
3797287 | 3797287 | 20240110122024_lCkHz | MY0005 | 2024-01-13T14:11:14.799Z | 2024-01-19T14:27:29.418Z |
3787960 | 3787960 | 20240109141901_rRUpZ | MY0005 | 2024-01-12T14:07:50.171Z | 2024-01-18T14:25:40.480Z |
3782558 | 3782558 | 20240108152702_7YVAw | MY0005 | 2024-01-11T14:09:23.416Z | 2024-01-17T14:23:31.050Z |
3770230 | 3770230 | 20240105171553_vyCXL | MY0005 | 2024-01-09T14:16:51.416Z | 2024-01-14T14:23:13.742Z |
3753841 | 3753841 | 20240104172622_bPWHI | MY0005 | 2024-01-07T14:08:34.391Z | 2024-01-13T14:26:05.325Z |
3753279 | 3753279 | 20240104153824_2n7gI | MY0005 | 2024-01-07T14:07:37.953Z | 2024-01-13T14:26:01.004Z |
3739308 | 3739308 | 20240103203245_XKoJV | MY0005 | 2024-01-06T00:06:14.089Z | 2024-01-12T14:25:21.089Z |
3736797 | 3736797 | 20240103131053_MwlFP | MY0005 | 2024-01-06T00:06:13.839Z | 2024-01-12T14:25:09.525Z |
3680562 | 3680562 | 20231217193013_3Dsiv | MY0005 | 2024-01-06T00:05:38.039Z | 2024-01-06T00:05:38.039Z |
3680494 | 3680494 | 20231217192127_p6Zo3 | MY0005 | 2024-01-06T00:05:38.031Z | 2024-01-06T00:05:38.031Z |
3680057 | 3680057 | 20231217182205_Vst2f | MY0005 | 2024-01-06T00:05:37.984Z | 2024-01-06T00:05:37.984Z |
3662000 | 3662000 | 20231215135957_B9j5h | MY0005 | 2024-01-06T00:05:31.932Z | 2024-01-06T00:05:31.932Z |
3600773 | 3600773 | 20231213203247_r1eX9 | MY0005 | 2024-01-06T00:05:21.415Z | 2024-01-06T00:05:21.415Z |
3600345 | 3600345 | 20231213201220_0F6W1 | MY0005 | 2024-01-06T00:05:21.382Z | 2024-01-06T00:05:21.382Z |
3600269 | 3600269 | 20231213200555_78VdP | MY0005 | 2024-01-06T00:05:21.375Z | 2024-01-06T00:05:21.375Z |
3600222 | 3600222 | 20231213200325_c9Zjl | MY0005 | 2024-01-06T00:05:21.371Z | 2024-01-06T00:05:21.371Z |
3599132 | 3599132 | 20231213182854_frZwI | MY0005 | 2024-01-06T00:05:21.254Z | 2024-01-06T00:05:21.254Z |
3599019 | 3599019 | 20231213181724_osx1O | MY0005 | 2024-01-06T00:05:21.241Z | 2024-01-06T00:05:21.241Z |
3598938 | 3598938 | 20231213180621_id9zj | MY0005 | 2024-01-06T00:05:21.232Z | 2024-01-06T00:05:21.232Z |
3598456 | 3598456 | 20231213170841_A7k2s | MY0005 | 2024-01-06T00:05:21.179Z | 2024-01-06T00:05:21.179Z |
3598331 | 3598331 | 20231213165020_DTEWX | MY0005 | 2024-01-06T00:05:21.163Z | 2024-01-06T00:05:21.163Z |
3598333 | 3598333 | 20231213165021_L1FeT | MY0005 | 2024-01-06T00:05:21.163Z | 2024-01-06T00:05:21.163Z |
3598134 | 3598134 | 20231213155824_vOzrx | MY0005 | 2024-01-06T00:05:21.139Z | 2024-01-06T00:05:21.139Z |
3598108 | 3598108 | 20231213155152_scLNZ | MY0005 | 2024-01-06T00:05:21.136Z | 2024-01-06T00:05:21.136Z |
3597988 | 3597988 | 20231213152822_tb9A5 | MY0005 | 2024-01-06T00:05:21.121Z | 2024-01-06T00:05:21.121Z |
3597517 | 3597517 | 20231213144900_8uvsm | MY0005 | 2024-01-06T00:05:18.973Z | 2024-01-06T00:05:18.973Z |
3597083 | 3597083 | 20231213141631_lqy6q | MY0005 | 2024-01-06T00:05:18.926Z | 2024-01-06T00:05:18.926Z |
3586143 | 3586143 | 20231212205122_IVOCf | MY0005 | 2024-01-06T00:05:17.592Z | 2024-01-06T00:05:17.592Z |
3585819 | 3585819 | 20231212194903_Ox6Zl | MY0005 | 2024-01-06T00:05:17.553Z | 2024-01-06T00:05:17.553Z |
3585496 | 3585496 | 20231212190810_sUCPC | MY0005 | 2024-01-06T00:05:17.514Z | 2024-01-06T00:05:17.514Z |
3585434 | 3585434 | 20231212185908_iPzsd | MY0005 | 2024-01-06T00:05:17.506Z | 2024-01-06T00:05:17.506Z |
3583933 | 3583933 | 20231212163606_1GBff | MY0005 | 2024-01-06T00:05:17.336Z | 2024-01-06T00:05:17.336Z |
3575739 | 3575739 | 20231211173038_2gfgW | MY0005 | 2024-01-06T00:05:14.917Z | 2024-01-06T00:05:14.917Z |
3575623 | 3575623 | 20231211171817_Xnncz | MY0005 | 2024-01-06T00:05:14.905Z | 2024-01-06T00:05:14.905Z |
3567625 | 3567625 | 20231210201310_Iq2Do | MY0005 | 2024-01-06T00:05:12.741Z | 2024-01-06T00:05:12.741Z |
3567392 | 3567392 | 20231210192300_Ts5Lu | MY0005 | 2024-01-06T00:05:12.716Z | 2024-01-06T00:05:12.716Z |
3567250 | 3567250 | 20231210190228_wPthy | MY0005 | 2024-01-06T00:05:12.703Z | 2024-01-06T00:05:12.703Z |
3567124 | 3567124 | 20231210184106_P2t3R | MY0005 | 2024-01-06T00:05:12.690Z | 2024-01-06T00:05:12.690Z |
3566827 | 3566827 | 20231210175045_o6Xdu | MY0005 | 2024-01-06T00:05:12.656Z | 2024-01-06T00:05:12.656Z |
3555844 | 3555844 | 20231209204930_7o71d | MY0005 | 2024-01-06T00:05:10.151Z | 2024-01-06T00:05:10.151Z |
3555822 | 3555822 | 20231209204326_sa4jb | MY0005 | 2024-01-06T00:05:10.149Z | 2024-01-06T00:05:10.149Z |
3555611 | 3555611 | 20231209195024_5mKP8 | MY0005 | 2024-01-06T00:05:10.125Z | 2024-01-06T00:05:10.125Z |
3555600 | 3555600 | 20231209194909_RycHx | MY0005 | 2024-01-06T00:05:10.124Z | 2024-01-06T00:05:10.124Z |
3555380 | 3555380 | 20231209191311_dvUmM | MY0005 | 2024-01-06T00:05:10.098Z | 2024-01-06T00:05:10.098Z |
3555310 | 3555310 | 20231209190449_N8Vgn | MY0005 | 2024-01-06T00:05:10.087Z | 2024-01-06T00:05:10.087Z |
3555051 | 3555051 | 20231209181608_aj75r | MY0005 | 2024-01-06T00:05:10.058Z | 2024-01-06T00:05:10.058Z |
3555014 | 3555014 | 20231209180921_S0Zj4 | MY0005 | 2024-01-06T00:05:10.054Z | 2024-01-06T00:05:10.054Z |
3554644 | 3554644 | 20231209170952_GqifU | MY0005 | 2024-01-06T00:05:10.014Z | 2024-01-06T00:05:10.014Z |
3554087 | 3554087 | 20231209150535_FWCld | MY0005 | 2024-01-06T00:05:08.597Z | 2024-01-06T00:05:08.597Z |
3553960 | 3553960 | 20231209141141_XS78j | MY0005 | 2024-01-06T00:05:08.581Z | 2024-01-06T00:05:08.581Z |
3435752 | 3435752 | 20231119193459_pSvAC | MY0005 | 2024-01-06T00:04:31.485Z | 2024-01-06T00:04:31.485Z |
3435754 | 3435754 | 20231119193500_9kkZx | MY0005 | 2024-01-06T00:04:31.485Z | 2024-01-06T00:04:31.485Z |
3424424 | 3424424 | 20231118155444_FLMye | MY0005 | 2024-01-06T00:04:28.976Z | 2024-01-06T00:04:28.976Z |
3423797 | 3423797 | 20231118140808_Djoog | MY0005 | 2024-01-06T00:04:28.920Z | 2024-01-06T00:04:28.920Z |
3419318 | 3419318 | 20231117201056_UX3k7 | MY0005 | 2024-01-06T00:04:27.126Z | 2024-01-06T00:04:27.126Z |
3418670 | 3418670 | 20231117185113_JtVt3 | MY0005 | 2024-01-06T00:04:27.060Z | 2024-01-06T00:04:27.060Z |
3418269 | 3418269 | 20231117174918_Nvg52 | MY0005 | 2024-01-06T00:04:27.007Z | 2024-01-06T00:04:27.007Z |
3406712 | 3406712 | 20231115204729_flylB | MY0005 | 2024-01-06T00:04:22.910Z | 2024-01-06T00:04:22.910Z |
3406533 | 3406533 | 20231115200422_HQgRn | MY0005 | 2024-01-06T00:04:22.884Z | 2024-01-06T00:04:22.884Z |
3406230 | 3406230 | 20231115185349_cQhGC | MY0005 | 2024-01-06T00:04:22.844Z | 2024-01-06T00:04:22.844Z |
3406165 | 3406165 | 20231115183616_35MW3 | MY0005 | 2024-01-06T00:04:22.837Z | 2024-01-06T00:04:22.837Z |
3406167 | 3406167 | 20231115183617_4lsJP | MY0005 | 2024-01-06T00:04:22.837Z | 2024-01-06T00:04:22.837Z |
3406121 | 3406121 | 20231115182459_qZ6QZ | MY0005 | 2024-01-06T00:04:22.831Z | 2024-01-06T00:04:22.831Z |
3406110 | 3406110 | 20231115182330_5cyyS | MY0005 | 2024-01-06T00:04:22.830Z | 2024-01-06T00:04:22.830Z |
3405982 | 3405982 | 20231115175230_0xVEo | MY0005 | 2024-01-06T00:04:22.812Z | 2024-01-06T00:04:22.812Z |
3405929 | 3405929 | 20231115174523_JqXIz | MY0005 | 2024-01-06T00:04:22.805Z | 2024-01-06T00:04:22.805Z |
3405779 | 3405779 | 20231115165740_xgrmA | MY0005 | 2024-01-06T00:04:22.787Z | 2024-01-06T00:04:22.787Z |
3405661 | 3405661 | 20231115155718_BnRPI | MY0005 | 2024-01-06T00:04:22.774Z | 2024-01-06T00:04:22.774Z |
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);